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::formatLocaleNumericRoundedForDefaultCurrency($optionValue['amount']);
  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::formatLocaleNumericRoundedForDefaultCurrency($discountFieldsval['amount']);
 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' => 'PriceField',
 279       'options' => $price,
 280       'onchange' => "return showHideByValue('price_set_id', '', 'map-field', 'block', 'select', false);",
 281     ]);
 282
 283     $default = [0 => NULL];
 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[$i] = NULL;
 296     }
 297
 298     $this->addRadio('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     $this->assign('deferredFinancialType', Civi::settings()->get('deferred_revenue_enabled') ? array_keys(CRM_Financial_BAO_FinancialAccount::getDeferredFinancialType()) : NULL);
 366     $this->buildAmountLabel();
 367     parent::buildQuickForm();
 368   }
 369
 370   /**
 371    * Add local and global form rules.
 372    */
 373   public function addRules() {
 374     $this->addFormRule(['CRM_Event_Form_ManageEvent_Fee', 'formRule']);
 375   }
 376
 377   /**
 378    * Global validation rules for the form.
 379    *
 380    * @param array $values
 381    *   Posted values of the form.
 382    *
 383    * @return array
 384    *   list of errors to be posted back to the form
 385    */
 386   public static function formRule($values) {
 387     $errors = [];
 388     if (!empty($values['is_discount'])) {
 389       $occurDiscount = array_count_values($values['discount_name']);
 390       $countemptyrows = 0;
 391       $countemptyvalue = 0;
 392       for ($i = 1; $i <= self::NUM_DISCOUNT; $i++) {
 393         $start_date = $end_date = NULL;
 394         if (!empty($values['discount_name'][$i])) {
 395           if (!empty($values['discount_start_date'][$i])) {
 396             $start_date = ($values['discount_start_date'][$i]) ? CRM_Utils_Date::processDate($values['discount_start_date'][$i]) : 0;
 397           }
 398           if (!empty($values['discount_end_date'][$i])) {
 399             $end_date = ($values['discount_end_date'][$i]) ? CRM_Utils_Date::processDate($values['discount_end_date'][$i]) : 0;
 400           }
 401
 402           if ($start_date && $end_date && strcmp($end_date, $start_date) < 0) {
 403             $errors["discount_end_date[$i]"] = ts('The discount end date cannot be prior to the start date.');
 404           }
 405
 406           if (!$start_date && !$end_date) {
 407             $errors["discount_start_date[$i]"] = $errors["discount_end_date[$i]"] = ts('Please specify either start date or end date.');
 408           }
 409
 410           if ($i > 1) {
 411             $end_date_1 = ($values['discount_end_date'][$i - 1]) ? CRM_Utils_Date::processDate($values['discount_end_date'][$i - 1]) : 0;
 412             if ($start_date && $end_date_1 && strcmp($end_date_1, $start_date) >= 0) {
 413               $errors["discount_start_date[$i]"] = ts('Select non-overlapping discount start date.');
 414             }
 415             elseif (!$start_date && !$end_date_1) {
 416               $j = $i - 1;
 417               $errors["discount_start_date[$i]"] = $errors["discount_end_date[$j]"] = ts('Select either of the dates.');
 418             }
 419           }
 420
 421           foreach ($occurDiscount as $key => $value) {
 422             if ($value > 1 && $key <> '') {
 423               if ($key == $values['discount_name'][$i]) {
 424                 $errors['discount_name[' . $i . ']'] = ts('%1 is already used for Discount Name.', [1 => $key]);
 425               }
 426             }
 427           }
 428
 429           //validation for discount labels and values
 430           for ($index = (self::NUM_OPTION); $index > 0; $index--) {
 431             $label = TRUE;
 432             if (empty($values['discounted_label'][$index]) && !empty($values['discounted_value'][$index][$i])) {
 433               $label = FALSE;
 434               if (!$label) {
 435                 $errors["discounted_label[{$index}]"] = ts('Label cannot be empty.');
 436               }
 437             }
 438             if (!empty($values['discounted_label'][$index])) {
 439               $duplicateIndex = CRM_Utils_Array::key($values['discounted_label'][$index], $values['discounted_label']);
 440
 441               if ((!($duplicateIndex === FALSE)) && (!($duplicateIndex == $index))) {
 442                 $errors["discounted_label[{$index}]"] = ts('Duplicate label value');
 443               }
 444             }
 445             if (empty($values['discounted_label'][$index]) && empty($values['discounted_value'][$index][$i])) {
 446               $countemptyrows++;
 447             }
 448             if (empty($values['discounted_value'][$index][$i])) {
 449               $countemptyvalue++;
 450             }
 451           }
 452           if (!empty($values['_qf_Fee_next']) && ($countemptyrows == 11 || $countemptyvalue == 11)) {
 453             $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.');
 454           }
 455         }
 456       }
 457     }
 458     if ($values['is_monetary']) {
 459       //check if financial type is selected
 460       if (!$values['financial_type_id']) {
 461         $errors['financial_type_id'] = ts("Please select financial type.");
 462       }
 463
 464       //check for the event fee label (mandatory)
 465       if (!$values['fee_label']) {
 466         $errors['fee_label'] = ts('Please enter the fee label for the paid event.');
 467       }
 468
 469       if (empty($values['price_set_id'])) {
 470         //check fee label and amount
 471         $check = 0;
 472         $optionKeys = [];
 473         foreach ($values['label'] as $key => $val) {
 474           if (trim($val) && trim($values['value'][$key])) {
 475             $optionKeys[$key] = $key;
 476             $check++;
 477           }
 478         }
 479
 480         $default = $values['default'] ?? NULL;
 481         if ($default && !in_array($default, $optionKeys)) {
 482           $errors['default'] = ts('Please select an appropriate option as default.');
 483         }
 484
 485         if (!$check) {
 486           if (!$values['label'][1]) {
 487             $errors['label[1]'] = ts('Please enter a label for at least one fee level.');
 488           }
 489           if (!$values['value'][1]) {
 490             $errors['value[1]'] = ts('Please enter an amount for at least one fee level.');
 491           }
 492         }
 493       }
 494       if (isset($values['is_pay_later'])) {
 495         if (empty($values['pay_later_text'])) {
 496           $errors['pay_later_text'] = ts('Please enter the Pay Later prompt to be displayed on the Registration form.');
 497         }
 498         if (empty($values['pay_later_receipt'])) {
 499           $errors['pay_later_receipt'] = ts('Please enter the Pay Later instructions to be displayed to your users.');
 500         }
 501       }
 502       else {
 503         if (empty($values['payment_processor'])) {
 504           $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.');
 505         }
 506       }
 507     }
 508     return empty($errors) ? TRUE : $errors;
 509   }
 510
 511   public function buildAmountLabel() {
 512     $default = [];
 513     for ($i = 1; $i <= self::NUM_OPTION; $i++) {
 514       // label
 515       $this->add('text', "discounted_label[$i]", ts('Label'), CRM_Core_DAO::getAttribute('CRM_Core_DAO_OptionValue', 'label'));
 516       // value
 517       for ($j = 1; $j <= self::NUM_DISCOUNT; $j++) {
 518         $this->add('text', "discounted_value[$i][$j]", ts('Value'), ['size' => 10]);
 519         $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');
 520       }
 521
 522       // default
 523       $default[$i] = NULL;
 524     }
 525
 526     $this->addRadio('discounted_default', NULL, $default);
 527   }
 528
 529   /**
 530    * Process the form.
 531    */
 532   public function postProcess() {
 533     $eventTitle = '';
 534     $params = $this->cleanMoneyFields($this->exportValues());
 535
 536     $this->set('discountSection', 0);
 537
 538     if (!empty($_POST['_qf_Fee_submit'])) {
 539       $this->buildAmountLabel();
 540       $this->set('discountSection', 2);
 541       return;
 542     }
 543
 544     if (!empty($params['payment_processor'])) {
 545       $params['payment_processor'] = array_keys($params['payment_processor']);
 546     }
 547     else {
 548       $params['payment_processor'] = 'null';
 549     }
 550
 551     $params['is_pay_later'] = CRM_Utils_Array::value('is_pay_later', $params, 0);
 552     $params['is_billing_required'] = CRM_Utils_Array::value('is_billing_required', $params, 0);
 553
 554     if ($this->_id) {
 555
 556       // delete all the prior label values or discounts in the custom options table
 557       // and delete a price set if one exists
 558       //@todo note that this removes the reference from existing participants -
 559       // even where there is not change - redress?
 560       // note that a more tentative form of this is invoked by passing price_set_id as an array
 561       // to event.create see CRM-14069
 562       // @todo get all of this logic out of form layer (currently partially in BAO/api layer)
 563       if (CRM_Price_BAO_PriceSet::removeFrom('civicrm_event', $this->_id)) {
 564         CRM_Core_BAO_Discount::del($this->_id, 'civicrm_event');
 565       }
 566     }
 567
 568     if ($params['is_monetary']) {
 569       if (!empty($params['price_set_id'])) {
 570         //@todo this is now being done in the event BAO if passed price_set_id as an array
 571         // per notes on that fn - looking at the api converting to an array
 572         // so calling via the api may cause this to be done in the api
 573         CRM_Price_BAO_PriceSet::addTo('civicrm_event', $this->_id, $params['price_set_id']);
 574         if (!empty($params['price_field_id'])) {
 575           $priceSetID = CRM_Core_DAO::getFieldValue('CRM_Price_DAO_PriceField', $params['price_field_id'], 'price_set_id');
 576           CRM_Price_BAO_PriceSet::setIsQuickConfig($priceSetID, 0);
 577         }
 578       }
 579       else {
 580         // if there are label / values, create custom options for them
 581         $labels = $params['label'] ?? NULL;
 582         $values = $params['value'] ?? NULL;
 583         $default = $params['default'] ?? NULL;
 584         $options = [];
 585         if (!CRM_Utils_System::isNull($labels) && !CRM_Utils_System::isNull($values)) {
 586           for ($i = 1; $i < self::NUM_OPTION; $i++) {
 587             if (!empty($labels[$i]) && !CRM_Utils_System::isNull($values[$i])) {
 588               $options[] = [
 589                 'label' => trim($labels[$i]),
 590                 'value' => $values[$i],
 591                 'weight' => $i,
 592                 'is_active' => 1,
 593                 'is_default' => $default == $i,
 594               ];
 595             }
 596           }
 597           if (!empty($options)) {
 598             $params['default_fee_id'] = NULL;
 599             if (empty($params['price_set_id'])) {
 600               if (empty($params['price_field_id'])) {
 601                 $setParams['title'] = $eventTitle = ($this->_isTemplate) ? $this->_defaultValues['template_title'] : $this->_defaultValues['title'];
 602                 $eventTitle = strtolower(CRM_Utils_String::munge($eventTitle, '_', 245));
 603                 if (!CRM_Core_DAO::getFieldValue('CRM_Price_BAO_PriceSet', $eventTitle, 'id', 'name')) {
 604                   $setParams['name'] = $eventTitle;
 605                 }
 606                 elseif (!CRM_Core_DAO::getFieldValue('CRM_Price_BAO_PriceSet', $eventTitle . '_' . $this->_id, 'id', 'name')) {
 607                   $setParams['name'] = $eventTitle . '_' . $this->_id;
 608                 }
 609                 else {
 610                   $timeSec = explode('.', microtime(TRUE));
 611                   $setParams['name'] = $eventTitle . '_' . date('is', $timeSec[0]) . $timeSec[1];
 612                 }
 613                 $setParams['is_quick_config'] = 1;
 614                 $setParams['financial_type_id'] = $params['financial_type_id'];
 615                 $setParams['extends'] = CRM_Core_Component::getComponentID('CiviEvent');
 616                 $priceSet = CRM_Price_BAO_PriceSet::create($setParams);
 617
 618                 $fieldParams['name'] = strtolower(CRM_Utils_String::munge($params['fee_label'], '_', 245));
 619                 $fieldParams['price_set_id'] = $priceSet->id;
 620               }
 621               else {
 622                 foreach ($params['price_field_value'] as $arrayID => $fieldValueID) {
 623                   if (empty($params['label'][$arrayID]) && empty($params['value'][$arrayID]) && !empty($fieldValueID)) {
 624                     CRM_Price_BAO_PriceFieldValue::setIsActive($fieldValueID, '0');
 625                     unset($params['price_field_value'][$arrayID]);
 626                   }
 627                 }
 628                 $fieldParams['id'] = $params['price_field_id'] ?? NULL;
 629                 $fieldParams['option_id'] = $params['price_field_value'];
 630
 631                 $priceSet = new CRM_Price_BAO_PriceSet();
 632                 $priceSet->id = CRM_Core_DAO::getFieldValue('CRM_Price_DAO_PriceField', CRM_Utils_Array::value('price_field_id', $params), 'price_set_id');
 633
 634                 if ($this->_defaultValues['financial_type_id'] != $params['financial_type_id']) {
 635                   CRM_Core_DAO::setFieldValue('CRM_Price_DAO_PriceSet', $priceSet->id, 'financial_type_id', $params['financial_type_id']);
 636                 }
 637               }
 638               $fieldParams['label'] = $params['fee_label'];
 639               $fieldParams['html_type'] = 'Radio';
 640               CRM_Price_BAO_PriceSet::addTo('civicrm_event', $this->_id, $priceSet->id);
 641               $fieldParams['option_label'] = $params['label'];
 642               $fieldParams['option_amount'] = $params['value'];
 643               $fieldParams['financial_type_id'] = $params['financial_type_id'];
 644               foreach ($options as $value) {
 645                 $fieldParams['option_weight'][$value['weight']] = $value['weight'];
 646               }
 647               $fieldParams['default_option'] = $params['default'];
 648               $priceField = CRM_Price_BAO_PriceField::create($fieldParams);
 649             }
 650           }
 651         }
 652
 653         $discountPriceSets = !empty($this->_defaultValues['discount_price_set']) ? $this->_defaultValues['discount_price_set'] : [];
 654         $discountFieldIDs = !empty($this->_defaultValues['discount_option_id']) ? $this->_defaultValues['discount_option_id'] : [];
 655         if (CRM_Utils_Array::value('is_discount', $params) == 1) {
 656           // if there are discounted set of label / values,
 657           // create custom options for them
 658           $labels = $params['discounted_label'] ?? NULL;
 659           $values = $params['discounted_value'] ?? NULL;
 660           $default = $params['discounted_default'] ?? NULL;
 661
 662           if (!CRM_Utils_System::isNull($labels) && !CRM_Utils_System::isNull($values)) {
 663             for ($j = 1; $j <= self::NUM_DISCOUNT; $j++) {
 664               $discountOptions = [];
 665               for ($i = 1; $i < self::NUM_OPTION; $i++) {
 666                 if (!empty($labels[$i]) &&
 667                   !CRM_Utils_System::isNull(CRM_Utils_Array::value($j, $values[$i]))
 668                 ) {
 669                   $discountOptions[] = [
 670                     'label' => trim($labels[$i]),
 671                     'value' => $values[$i][$j],
 672                     'weight' => $i,
 673                     'is_active' => 1,
 674                     'is_default' => $default == $i,
 675                   ];
 676                 }
 677               }
 678
 679               if (!empty($discountOptions)) {
 680                 $fieldParams = [];
 681                 $params['default_discount_fee_id'] = NULL;
 682                 $keyCheck = $j - 1;
 683                 $setParams = [];
 684                 if (empty($discountPriceSets[$keyCheck])) {
 685                   if (!$eventTitle) {
 686                     $eventTitle = strtolower(CRM_Utils_String::munge($this->_defaultValues['title'], '_', 200));
 687                   }
 688                   $setParams['title'] = $params['discount_name'][$j];
 689                   if (!CRM_Core_DAO::getFieldValue('CRM_Price_BAO_PriceSet', $eventTitle . '_' . $params['discount_name'][$j], 'id', 'name')) {
 690                     $setParams['name'] = $eventTitle . '_' . $params['discount_name'][$j];
 691                   }
 692                   elseif (!CRM_Core_DAO::getFieldValue('CRM_Price_BAO_PriceSet', $eventTitle . '_' . $params['discount_name'][$j] . '_' . $this->_id, 'id', 'name')) {
 693                     $setParams['name'] = $eventTitle . '_' . $params['discount_name'][$j] . '_' . $this->_id;
 694                   }
 695                   else {
 696                     $timeSec = explode('.', microtime(TRUE));
 697                     $setParams['name'] = $eventTitle . '_' . $params['discount_name'][$j] . '_' . date('is', $timeSec[0]) . $timeSec[1];
 698                   }
 699                   $setParams['is_quick_config'] = 1;
 700                   $setParams['financial_type_id'] = $params['financial_type_id'];
 701                   $setParams['extends'] = CRM_Core_Component::getComponentID('CiviEvent');
 702                   $priceSet = CRM_Price_BAO_PriceSet::create($setParams);
 703                   $priceSetID = $priceSet->id;
 704                 }
 705                 else {
 706                   $priceSetID = $discountPriceSets[$j - 1];
 707                   $setParams = [
 708                     'title' => $params['discount_name'][$j],
 709                     'id' => $priceSetID,
 710                   ];
 711                   if ($this->_defaultValues['financial_type_id'] != $params['financial_type_id']) {
 712                     $setParams['financial_type_id'] = $params['financial_type_id'];
 713                   }
 714                   CRM_Price_BAO_PriceSet::create($setParams);
 715                   unset($discountPriceSets[$j - 1]);
 716                   $fieldParams['id'] = CRM_Core_DAO::getFieldValue('CRM_Price_BAO_PriceField', $priceSetID, 'id', 'price_set_id');
 717                 }
 718
 719                 $fieldParams['name'] = $fieldParams['label'] = $params['fee_label'];
 720                 $fieldParams['is_required'] = 1;
 721                 $fieldParams['price_set_id'] = $priceSetID;
 722                 $fieldParams['html_type'] = 'Radio';
 723                 $fieldParams['financial_type_id'] = $params['financial_type_id'];
 724                 foreach ($discountOptions as $value) {
 725                   $fieldParams['option_label'][$value['weight']] = $value['label'];
 726                   $fieldParams['option_amount'][$value['weight']] = $value['value'];
 727                   $fieldParams['option_weight'][$value['weight']] = $value['weight'];
 728                   if (!empty($value['is_default'])) {
 729                     $fieldParams['default_option'] = $value['weight'];
 730                   }
 731                   if (!empty($discountFieldIDs[$j]) && !empty($discountFieldIDs[$j][$value['weight']])) {
 732                     $fieldParams['option_id'][$value['weight']] = $discountFieldIDs[$j][$value['weight']];
 733                     unset($discountFieldIDs[$j][$value['weight']]);
 734                   }
 735                 }
 736                 //create discount priceset
 737                 $priceField = CRM_Price_BAO_PriceField::create($fieldParams);
 738                 if (!empty($discountFieldIDs[$j])) {
 739                   foreach ($discountFieldIDs[$j] as $fID) {
 740                     CRM_Price_BAO_PriceFieldValue::setIsActive($fID, '0');
 741                   }
 742                 }
 743
 744                 $discountParams = [
 745                   'entity_table' => 'civicrm_event',
 746                   'entity_id' => $this->_id,
 747                   'price_set_id' => $priceSetID,
 748                   'start_date' => $params['discount_start_date'][$j],
 749                   'end_date' => $params['discount_end_date'][$j],
 750                 ];
 751                 CRM_Core_BAO_Discount::add($discountParams);
 752               }
 753             }
 754           }
 755         }
 756         if (!empty($discountPriceSets)) {
 757           foreach ($discountPriceSets as $setId) {
 758             CRM_Price_BAO_PriceSet::setIsQuickConfig($setId, 0);
 759           }
 760         }
 761       }
 762     }
 763     else {
 764       if (!empty($params['price_field_id'])) {
 765         $priceSetID = CRM_Core_DAO::getFieldValue('CRM_Price_DAO_PriceField', $params['price_field_id'], 'price_set_id');
 766         CRM_Price_BAO_PriceSet::setIsQuickConfig($priceSetID, 0);
 767       }
 768       $params['financial_type_id'] = '';
 769       $params['is_pay_later'] = 0;
 770       $params['is_billing_required'] = 0;
 771     }
 772
 773     //update 'is_billing_required'
 774     if (empty($params['is_pay_later'])) {
 775       $params['is_billing_required'] = FALSE;
 776     }
 777
 778     //update events table
 779     $params['id'] = $this->_id;
 780     // skip update of financial type in price set
 781     $params['skipFinancialType'] = TRUE;
 782     CRM_Event_BAO_Event::add($params);
 783
 784     // Update tab "disabled" css class
 785     $this->ajaxResponse['tabValid'] = !empty($params['is_monetary']);
 786     parent::endPostProcess();
 787   }
 788
 789   /**
 790    * Return a descriptive name for the page, used in wizard header
 791    *
 792    * @return string
 793    */
 794   public function getTitle() {
 795     return ts('Event Fees');
 796   }
 797
 798   /**
 799    * Clean money fields in submitted params to remove formatting.
 800    *
 801    * @param array $params
 802    *
 803    * @return array
 804    */
 805   protected function cleanMoneyFields($params) {
 806     foreach ($params['value'] as $index => $value) {
 807       if (CRM_Utils_System::isNull($value)) {
 808         unset($params['value'][$index]);
 809       }
 810       else {
 811         $params['value'][$index] = CRM_Utils_Rule::cleanMoney(trim($value));
 812       }
 813     }
 814     foreach ($params['discounted_value'] ?? [] as $index => $discountedValueSet) {
 815       foreach ($discountedValueSet as $innerIndex => $value) {
 816         if (CRM_Utils_System::isNull($value)) {
 817           unset($params['discounted_value'][$index][$innerIndex]);
 818         }
 819         else {
 820           $params['discounted_value'][$index][$innerIndex] = CRM_Utils_Rule::cleanMoney(trim($value));
 821         }
 822       }
 823       if (empty($params['discounted_value'][$index])) {
 824         unset($params['discounted_value'][$index]);
 825       }
 826     }
 827     return $params;
 828   }
 829
 830 }