Merge pull request #8427 from eileenmcnaughton/event_cart
[civicrm-core.git] / CRM / Price / BAO / PriceField.php
CommitLineData
6a488035
TO
1<?php
2/*
3 +--------------------------------------------------------------------+
7e9e8871 4 | CiviCRM version 4.7 |
6a488035 5 +--------------------------------------------------------------------+
fa938177 6 | Copyright CiviCRM LLC (c) 2004-2016 |
6a488035
TO
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 +--------------------------------------------------------------------+
e70a7fc0 26 */
6a488035
TO
27
28/**
29 *
30 * @package CRM
fa938177 31 * @copyright CiviCRM LLC (c) 2004-2016
6a488035
TO
32 * $Id$
33 *
34 */
35
36/**
37 * Business objects for managing price fields.
38 *
39 */
9da8dc8c 40class CRM_Price_BAO_PriceField extends CRM_Price_DAO_PriceField {
6a488035
TO
41
42 protected $_options;
43
44 /**
fe482240 45 * Takes an associative array and creates a price field object.
6a488035
TO
46 *
47 * the function extract all the params it needs to initialize the create a
48 * price field object. the params array could contain additional unused name/value
49 * pairs
50 *
414c1420
TO
51 * @param array $params
52 * (reference) an assoc array of name/value pairs.
6a488035 53 *
16b10e64 54 * @return CRM_Price_BAO_PriceField
6a488035 55 */
00be9182 56 public static function add(&$params) {
9da8dc8c 57 $priceFieldBAO = new CRM_Price_BAO_PriceField();
6a488035
TO
58
59 $priceFieldBAO->copyValues($params);
60
61 if ($id = CRM_Utils_Array::value('id', $params)) {
62 $priceFieldBAO->id = $id;
63 }
64
65 $priceFieldBAO->save();
66 return $priceFieldBAO;
67 }
68
69 /**
fe482240 70 * Takes an associative array and creates a price field object.
6a488035
TO
71 *
72 * This function is invoked from within the web form layer and also from the api layer
73 *
414c1420
TO
74 * @param array $params
75 * (reference) an assoc array of name/value pairs.
6a488035 76 *
16b10e64 77 * @return CRM_Price_DAO_PriceField
6a488035 78 */
00be9182 79 public static function create(&$params) {
22e263ad 80 if (empty($params['id']) && empty($params['name'])) {
b10b974d 81 $params['name'] = strtolower(CRM_Utils_String::munge($params['label'], '_', 242));
291ebece 82 }
6a488035
TO
83 $transaction = new CRM_Core_Transaction();
84
85 $priceField = self::add($params);
86
87 if (is_a($priceField, 'CRM_Core_Error')) {
88 $transaction->rollback();
89 return $priceField;
90 }
91
e0c1764e 92 $optionsIds = array();
6a488035
TO
93 $maxIndex = CRM_Price_Form_Field::NUM_OPTION;
94
95 if ($priceField->html_type == 'Text') {
96 $maxIndex = 1;
97
9da8dc8c 98 $fieldValue = new CRM_Price_DAO_PriceFieldValue();
6a488035
TO
99 $fieldValue->price_field_id = $priceField->id;
100
101 // update previous field values( if any )
102 if ($fieldValue->find(TRUE)) {
103 $optionsIds['id'] = $fieldValue->id;
104 }
105 }
106 $defaultArray = array();
a4537ddd
EM
107 //html type would be empty in update scenario not sure what would happen ...
108 if (!empty($params['html_type']) && $params['html_type'] == 'CheckBox' && isset($params['default_checkbox_option'])) {
6a488035
TO
109 $tempArray = array_keys($params['default_checkbox_option']);
110 foreach ($tempArray as $v) {
111 if ($params['option_amount'][$v]) {
112 $defaultArray[$v] = 1;
113 }
114 }
115 }
116 else {
a7488080 117 if (!empty($params['default_option'])) {
6a488035
TO
118 $defaultArray[$params['default_option']] = 1;
119 }
120 }
121
122 for ($index = 1; $index <= $maxIndex; $index++) {
123 if (array_key_exists('option_amount', $params) &&
124 array_key_exists($index, $params['option_amount']) &&
8cc574cf 125 (CRM_Utils_Array::value($index, CRM_Utils_Array::value('option_label', $params)) || !empty($params['is_quick_config'])) &&
6a488035
TO
126 !CRM_Utils_System::isNull($params['option_amount'][$index])
127 ) {
128 $options = array(
129 'price_field_id' => $priceField->id,
130 'label' => trim($params['option_label'][$index]),
131 'name' => CRM_Utils_String::munge($params['option_label'][$index], '_', 64),
132 'amount' => CRM_Utils_Rule::cleanMoney(trim($params['option_amount'][$index])),
133 'count' => CRM_Utils_Array::value($index, CRM_Utils_Array::value('option_count', $params), NULL),
134 'max_value' => CRM_Utils_Array::value($index, CRM_Utils_Array::value('option_max_value', $params), NULL),
135 'description' => CRM_Utils_Array::value($index, CRM_Utils_Array::value('option_description', $params), NULL),
136 'membership_type_id' => CRM_Utils_Array::value($index, CRM_Utils_Array::value('membership_type_id', $params), NULL),
137 'weight' => $params['option_weight'][$index],
138 'is_active' => 1,
139 'is_default' => CRM_Utils_Array::value($params['option_weight'][$index], $defaultArray) ? $defaultArray[$params['option_weight'][$index]] : 0,
140 'membership_num_terms' => NULL,
141 );
142
143 if ($options['membership_type_id']) {
144 $options['membership_num_terms'] = CRM_Utils_Array::value($index, CRM_Utils_Array::value('membership_num_terms', $params), 1);
145 }
146
481a74f4 147 if (CRM_Utils_Array::value($index, CRM_Utils_Array::value('option_financial_type_id', $params))) {
353ffa53 148 $options['financial_type_id'] = $params['option_financial_type_id'][$index];
0db6c3e1
TO
149 }
150 elseif (!empty($params['financial_type_id'])) {
6a488035
TO
151 $options['financial_type_id'] = $params['financial_type_id'];
152 }
153
154 if ($opIds = CRM_Utils_Array::value('option_id', $params)) {
155 if ($opId = CRM_Utils_Array::value($index, $opIds)) {
156 $optionsIds['id'] = $opId;
0db6c3e1
TO
157 }
158 else {
6a488035
TO
159 $optionsIds['id'] = NULL;
160 }
161 }
9da8dc8c 162 CRM_Price_BAO_PriceFieldValue::create($options, $optionsIds);
6a488035
TO
163 }
164 }
165
166 $transaction->commit();
167 return $priceField;
168 }
169
170 /**
fe482240 171 * Fetch object based on array of properties.
6a488035 172 *
414c1420
TO
173 * @param array $params
174 * (reference ) an assoc array of name/value pairs.
175 * @param array $defaults
176 * (reference ) an assoc array to hold the flattened values.
6a488035 177 *
16b10e64 178 * @return CRM_Price_DAO_PriceField
6a488035 179 */
00be9182 180 public static function retrieve(&$params, &$defaults) {
9da8dc8c 181 return CRM_Core_DAO::commonRetrieve('CRM_Price_DAO_PriceField', $params, $defaults);
6a488035
TO
182 }
183
184 /**
fe482240 185 * Update the is_active flag in the db.
6a488035 186 *
414c1420
TO
187 * @param int $id
188 * Id of the database record.
189 * @param bool $is_active
190 * Value we want to set the is_active field.
6a488035 191 *
a6c01b45 192 * @return Object
2e2605fe 193 * DAO object on success, null otherwise.
6a488035 194 */
00be9182 195 public static function setIsActive($id, $is_active) {
9da8dc8c 196 return CRM_Core_DAO::setFieldValue('CRM_Price_DAO_PriceField', $id, 'is_active', $is_active);
6a488035
TO
197 }
198
2e2605fe
EM
199 /**
200 * Freeze form if the event is full.
201 *
202 * @param $element
203 * @param $fieldOptions
204 *
205 * @return null
206 */
00be9182 207 public static function freezeIfEnabled(&$element, $fieldOptions) {
79b152ac 208 if (!empty($fieldOptions['is_full'])) {
209 $element->freeze();
210 }
d5cc0fc2 211 return NULL;
79b152ac 212 }
213
6a488035
TO
214 /**
215 * Get the field title.
216 *
414c1420
TO
217 * @param int $id
218 * Id of field.
6a488035 219 *
a6c01b45
CW
220 * @return string
221 * name
6a488035 222 *
6a488035
TO
223 */
224 public static function getTitle($id) {
9da8dc8c 225 return CRM_Core_DAO::getFieldValue('CRM_Price_DAO_PriceField', $id, 'label');
6a488035
TO
226 }
227
228 /**
fe482240 229 * This function for building custom fields.
6a488035 230 *
414c1420
TO
231 * @param CRM_Core_Form $qf
232 * Form object (reference).
233 * @param string $elementName
234 * Name of the custom field.
100fef9d 235 * @param int $fieldId
414c1420
TO
236 * @param bool $inactiveNeeded
237 * @param bool $useRequired
238 * True if required else false.
239 * @param string $label
240 * Label for custom field.
77b97be7
EM
241 *
242 * @param null $fieldOptions
1537c309 243 * @param array $freezeOptions
6a488035 244 *
77b97be7 245 * @return null
6a488035 246 */
9277d9e4
TO
247 public static function addQuickFormElement(
248 &$qf,
6a488035
TO
249 $elementName,
250 $fieldId,
251 $inactiveNeeded,
535a8e1e
CW
252 $useRequired = TRUE,
253 $label = NULL,
6a488035 254 $fieldOptions = NULL,
1537c309 255 $freezeOptions = array()
6a488035
TO
256 ) {
257
9da8dc8c 258 $field = new CRM_Price_DAO_PriceField();
6a488035
TO
259 $field->id = $fieldId;
260 if (!$field->find(TRUE)) {
261 /* FIXME: failure! */
262 return NULL;
263 }
366fe2a3 264
6a488035
TO
265 $is_pay_later = 0;
266 if (isset($qf->_mode) && empty($qf->_mode)) {
267 $is_pay_later = 1;
268 }
269 elseif (isset($qf->_values)) {
481a74f4 270 $is_pay_later = CRM_Utils_Array::value('is_pay_later', $qf->_values);
6a488035
TO
271 }
272
273 $otherAmount = $qf->get('values');
274 $config = CRM_Core_Config::singleton();
353ffa53 275 $currencySymbol = CRM_Core_DAO::getFieldValue('CRM_Financial_DAO_Currency', $config->defaultCurrency, 'symbol', 'name');
6a488035
TO
276 $qf->assign('currencySymbol', $currencySymbol);
277 // get currency name for price field and option attributes
278 $currencyName = $config->defaultCurrency;
279
280 if (!isset($label)) {
15831617 281 $label = (!empty($qf->_membershipBlock) && $field->name == 'contribution_amount') ? ts('Additional Contribution') : $field->label;
6a488035
TO
282 }
283
284 if ($field->name == 'contribution_amount') {
285 $qf->_contributionAmount = 1;
286 }
287
288 if (isset($qf->_online) && $qf->_online) {
289 $useRequired = FALSE;
290 }
291
292 $customOption = $fieldOptions;
293 if (!is_array($customOption)) {
9da8dc8c 294 $customOption = CRM_Price_BAO_PriceField::getOptions($field->id, $inactiveNeeded);
6a488035
TO
295 }
296
297 //use value field.
298 $valueFieldName = 'amount';
299 $seperator = '|';
aaffa79f 300 $invoiceSettings = Civi::settings()->get('contribution_invoice_settings');
5ebee375 301 $taxTerm = CRM_Utils_Array::value('tax_term', $invoiceSettings);
302 $displayOpt = CRM_Utils_Array::value('tax_display_settings', $invoiceSettings);
fff0f449 303 $invoicing = CRM_Utils_Array::value('invoicing', $invoiceSettings);
6a488035
TO
304 switch ($field->html_type) {
305 case 'Text':
306 $optionKey = key($customOption);
535a8e1e 307 $count = CRM_Utils_Array::value('count', $customOption[$optionKey], '');
6a488035 308 $max_value = CRM_Utils_Array::value('max_value', $customOption[$optionKey], '');
9d1c9154 309 $taxAmount = CRM_Utils_Array::value('tax_amount', $customOption[$optionKey]);
3bd20e3f 310 if (isset($taxAmount) && $displayOpt && $invoicing) {
dc428161 311 $qf->assign('displayOpt', $displayOpt);
5ebee375 312 $qf->assign('taxTerm', $taxTerm);
fff0f449 313 $qf->assign('invoicing', $invoicing);
dc428161 314 }
353ffa53 315 $priceVal = implode($seperator, array(
c5c263ca
AH
316 $customOption[$optionKey][$valueFieldName] + $taxAmount,
317 $count,
318 $max_value,
319 ));
6a488035
TO
320
321 $extra = array();
15831617 322 if (!empty($qf->_membershipBlock) && !empty($qf->_quickConfig) && $field->name == 'other_amount' && empty($qf->_contributionAmount)) {
6a488035 323 $useRequired = 0;
366fe2a3 324 }
d5cc0fc2 325 elseif (!empty($fieldOptions[$optionKey]['label'])) {
326 //check for label.
6a488035 327 $label = $fieldOptions[$optionKey]['label'];
0d7d6391 328 if (!empty($qf->_quickConfig) && !empty($qf->_contributionAmount) && strtolower($fieldOptions[$optionKey]['name']) == 'other_amount') {
2882b6a4 329 $label .= ' ' . $currencySymbol;
0d7d6391 330 $qf->assign('priceset', $elementName);
331 $extra = array('onclick' => 'useAmountOther();');
332 }
6a488035
TO
333 }
334
335 $element = &$qf->add('text', $elementName, $label,
353ffa53
TO
336 array_merge($extra,
337 array(
338 'price' => json_encode(array($optionKey, $priceVal)),
339 'size' => '4',
340 )
341 ),
342 $useRequired && $field->is_required
6a488035
TO
343 );
344 if ($is_pay_later) {
353ffa53 345 $qf->add('text', 'txt-' . $elementName, $label, array('size' => '4'));
6a488035
TO
346 }
347
d2108f71 348 // CRM-6902 - Add "max" option for a price set field
1537c309 349 if (in_array($optionKey, $freezeOptions)) {
0dc0b759 350 self::freezeIfEnabled($element, $fieldOptions[$optionKey]);
79b152ac 351 // CRM-14696 - Improve display for sold out price set options
352 $element->setLabel($label . '&nbsp;<span class="sold-out-option">' . ts('Sold out') . '</span>');
6a488035
TO
353 }
354
355 //CRM-10117
55c0b49a
RK
356 if (!empty($qf->_quickConfig)) {
357 $message = ts('Please enter a valid amount.');
358 $type = 'money';
359 }
360 else {
361 $message = ts('%1 must be a number (with or without decimal point).', array(1 => $label));
362 $type = 'numeric';
363 }
6a488035
TO
364 // integers will have numeric rule applied to them.
365 $qf->addRule($elementName, $message, $type);
366 break;
367
368 case 'Radio':
369 $choice = array();
370
15831617 371 if (!empty($qf->_quickConfig) && !empty($qf->_contributionAmount)) {
6a488035
TO
372 $qf->assign('contriPriceset', $elementName);
373 }
374
375 foreach ($customOption as $opId => $opt) {
9d1c9154 376 $taxAmount = CRM_Utils_Array::value('tax_amount', $opt);
6a488035 377 if ($field->is_display_amounts) {
e2d2aeab 378 $opt['label'] = !empty($opt['label']) ? $opt['label'] . '&nbsp;-&nbsp;' : '';
3bd20e3f 379 if (isset($taxAmount) && $invoicing) {
dc428161 380 if ($displayOpt == 'Do_not_show') {
353ffa53 381 $opt['label'] = '<span class="crm-price-amount-label">' . $opt['label'] . '</span>' . '<span class="crm-price-amount-amount">' . CRM_Utils_Money::format($opt[$valueFieldName] + $taxAmount) . '</span>';
dc428161 382 }
4c9b6178 383 elseif ($displayOpt == 'Inclusive') {
e2d2aeab
DG
384 $opt['label'] = '<span class="crm-price-amount-label">' . $opt['label'] . '</span>' . '<span class="crm-price-amount-amount">' . CRM_Utils_Money::format($opt[$valueFieldName] + $taxAmount) . '</span>';
385 $opt['label'] .= '<span class="crm-price-amount-tax"> (includes ' . $taxTerm . ' of ' . CRM_Utils_Money::format($opt['tax_amount']) . ')</span>';
dc428161 386 }
387 else {
353ffa53 388 $opt['label'] = '<span class="crm-price-amount-label">' . $opt['label'] . '</span>' . '<span class="crm-price-amount-amount">' . CRM_Utils_Money::format($opt[$valueFieldName]) . '</span>';
86bfa4f6 389 $opt['label'] .= '<span class="crm-price-amount-tax"> + ' . CRM_Utils_Money::format($opt['tax_amount']) . ' ' . $taxTerm . '</span>';
dc428161 390 }
391 }
392 else {
e2d2aeab 393 $opt['label'] = '<span class="crm-price-amount-label">' . $opt['label'] . '</span>' . '<span class="crm-price-amount-amount">' . CRM_Utils_Money::format($opt[$valueFieldName]) . '</span>';
dc428161 394 }
6a488035 395 }
535a8e1e 396 $count = CRM_Utils_Array::value('count', $opt, '');
6a488035 397 $max_value = CRM_Utils_Array::value('max_value', $opt, '');
dc428161 398 $priceVal = implode($seperator, array($opt[$valueFieldName] + $taxAmount, $count, $max_value));
6ea503d4 399 $extra = array(
353ffa53
TO
400 'price' => json_encode(array($elementName, $priceVal)),
401 'data-amount' => $opt[$valueFieldName],
402 'data-currency' => $currencyName,
c23c87f6 403 'data-price-field-values' => json_encode($customOption),
6a488035 404 );
15831617 405 if (!empty($qf->_quickConfig) && $field->name == 'contribution_amount') {
6a488035 406 $extra += array('onclick' => 'clearAmountOther();');
366fe2a3 407 }
15831617 408 elseif (!empty($qf->_quickConfig) && $field->name == 'membership_amount') {
6a488035
TO
409 $extra += array(
410 'onclick' => "return showHideAutoRenew({$opt['membership_type_id']});",
411 'membership-type' => $opt['membership_type_id'],
366fe2a3 412 );
353ffa53 413 $qf->assign('membershipFieldID', $field->id);
6a488035 414 }
366fe2a3 415
6a488035
TO
416 $choice[$opId] = $qf->createElement('radio', NULL, '', $opt['label'], $opt['id'], $extra);
417
418 if ($is_pay_later) {
353ffa53 419 $qf->add('text', 'txt-' . $elementName, $label, array('size' => '4'));
6a488035
TO
420 }
421
d2108f71 422 // CRM-6902 - Add "max" option for a price set field
1537c309 423 if (in_array($opId, $freezeOptions)) {
e4c6a396 424 self::freezeIfEnabled($choice[$opId], $customOption[$opId]);
d2108f71 425 // CRM-14696 - Improve display for sold out price set options
be6dcd4e 426 $choice[$opId]->setText('<span class="sold-out-option">' . $choice[$opId]->getText() . '&nbsp;(' . ts('Sold out') . ')</span>');
6a488035
TO
427 }
428 }
15831617 429 if (!empty($qf->_membershipBlock) && $field->name == 'contribution_amount') {
6a488035 430 $choice[] = $qf->createElement('radio', NULL, '', ts('No thank you'), '-1',
abcf506a 431 array(
2975161b 432 'price' => json_encode(array($elementName, '0|0')),
433 'data-currency' => $currencyName,
abcf506a
PN
434 'onclick' => 'clearAmountOther();',
435 )
6a488035
TO
436 );
437 }
438
439 if (!$field->is_required) {
440 // add "none" option
a7488080 441 if (!empty($otherAmount['is_allow_other_amount']) && $field->name == 'contribution_amount') {
6a488035 442 $none = ts('Other Amount');
366fe2a3 443 }
8cc574cf 444 elseif (!empty($qf->_membershipBlock) && empty($qf->_membershipBlock['is_required']) && $field->name == 'membership_amount') {
6a488035 445 $none = ts('No thank you');
366fe2a3 446 }
6a488035
TO
447 else {
448 $none = ts('- none -');
449 }
450
451 $choice[] = $qf->createElement('radio', NULL, '', $none, '0',
452 array('price' => json_encode(array($elementName, '0')))
453 );
454 }
455
456 $element = &$qf->addGroup($choice, $elementName, $label);
457
458 // make contribution field required for quick config when membership block is enabled
abcf506a 459 if (($field->name == 'membership_amount' || $field->name == 'contribution_amount')
353ffa53
TO
460 && !empty($qf->_membershipBlock) && !$field->is_required
461 ) {
6a488035
TO
462 $useRequired = $field->is_required = TRUE;
463 }
464
465 if ($useRequired && $field->is_required) {
466 $qf->addRule($elementName, ts('%1 is a required field.', array(1 => $label)), 'required');
467 }
468 break;
469
470 case 'Select':
471 $selectOption = $allowedOptions = $priceVal = array();
472
473 foreach ($customOption as $opt) {
9d1c9154 474 $taxAmount = CRM_Utils_Array::value('tax_amount', $opt);
6a488035
TO
475 $count = CRM_Utils_Array::value('count', $opt, '');
476 $max_value = CRM_Utils_Array::value('max_value', $opt, '');
6a488035
TO
477
478 if ($field->is_display_amounts) {
479 $opt['label'] .= '&nbsp;-&nbsp;';
353ffa53 480 if (isset($taxAmount) && $invoicing) {
e2d2aeab 481 $opt['label'] = $opt['label'] . self::getTaxLabel($opt, $valueFieldName, $displayOpt, $taxTerm);
dc428161 482 }
483 else {
e2d2aeab 484 $opt['label'] = $opt['label'] . CRM_Utils_Money::format($opt[$valueFieldName]);
dc428161 485 }
6a488035 486 }
79b152ac 487
dc428161 488 $priceVal[$opt['id']] = implode($seperator, array($opt[$valueFieldName] + $taxAmount, $count, $max_value));
79b152ac 489
1537c309 490 if (!in_array($opt['id'], $freezeOptions)) {
6a488035
TO
491 $allowedOptions[] = $opt['id'];
492 }
d2108f71 493 // CRM-14696 - Improve display for sold out price set options
76991db6 494 else {
a14eff52 495 $opt['id'] = 'crm_disabled_opt-' . $opt['id'];
be6dcd4e 496 $opt['label'] = $opt['label'] . ' (' . ts('Sold out') . ')';
d2108f71 497 }
79b152ac 498
d2108f71
J
499 $selectOption[$opt['id']] = $opt['label'];
500
6a488035 501 if ($is_pay_later) {
353ffa53 502 $qf->add('text', 'txt-' . $elementName, $label, array('size' => '4'));
6a488035
TO
503 }
504 }
79b152ac 505
6a488035
TO
506 $element = &$qf->add('select', $elementName, $label,
507 array(
d5cc0fc2 508 '' => ts('- select -'),
353ffa53
TO
509 ) + $selectOption,
510 $useRequired && $field->is_required,
c23c87f6 511 array('price' => json_encode($priceVal), 'class' => 'crm-select2', 'data-price-field-values' => json_encode($customOption))
353ffa53 512 );
6a488035 513
d2108f71 514 // CRM-6902 - Add "max" option for a price set field
6a488035 515 $button = substr($qf->controller->getButtonName(), -4);
1537c309 516 if (!empty($freezeOptions) && $button != 'skip') {
6a488035
TO
517 $qf->addRule($elementName, ts('Sorry, this option is currently sold out.'), 'regex', "/" . implode('|', $allowedOptions) . "/");
518 }
519 break;
520
521 case 'CheckBox':
522
523 $check = array();
524 foreach ($customOption as $opId => $opt) {
9d1c9154 525 $taxAmount = CRM_Utils_Array::value('tax_amount', $opt);
535a8e1e 526 $count = CRM_Utils_Array::value('count', $opt, '');
6a488035 527 $max_value = CRM_Utils_Array::value('max_value', $opt, '');
6a488035
TO
528
529 if ($field->is_display_amounts) {
e2d2aeab 530 $opt['label'] = '<span class="crm-price-amount-label">' . $opt['label'] . '</span>&nbsp;-&nbsp;';
3bd20e3f 531 if (isset($taxAmount) && $invoicing) {
5ebee375 532 $opt['label'] .= self::getTaxLabel($opt, $valueFieldName, $displayOpt, $taxTerm);
dc428161 533 }
534 else {
535 $opt['label'] .= CRM_Utils_Money::format($opt[$valueFieldName]);
536 }
6a488035 537 }
dc428161 538 $priceVal = implode($seperator, array($opt[$valueFieldName] + $taxAmount, $count, $max_value));
6a488035 539 $check[$opId] = &$qf->createElement('checkbox', $opt['id'], NULL, $opt['label'],
6ea503d4 540 array(
353ffa53
TO
541 'price' => json_encode(array($opt['id'], $priceVal)),
542 'data-amount' => $opt[$valueFieldName],
543 'data-currency' => $currencyName,
6a488035
TO
544 )
545 );
546 if ($is_pay_later) {
481a74f4 547 $txtcheck[$opId] =& $qf->createElement('text', $opId, $opt['label'], array('size' => '4'));
92fcb95f 548 $qf->addGroup($txtcheck, 'txt-' . $elementName, $label);
6a488035 549 }
d2108f71 550 // CRM-6902 - Add "max" option for a price set field
1537c309 551 if (in_array($opId, $freezeOptions)) {
e4c6a396 552 self::freezeIfEnabled($check[$opId], $customOption[$opId]);
d2108f71 553 // CRM-14696 - Improve display for sold out price set options
be6dcd4e 554 $check[$opId]->setText('<span class="sold-out-option">' . $check[$opId]->getText() . '&nbsp;(' . ts('Sold out') . ')</span>');
6a488035
TO
555 }
556 }
557 $element = &$qf->addGroup($check, $elementName, $label);
558 if ($useRequired && $field->is_required) {
559 $qf->addRule($elementName, ts('%1 is a required field.', array(1 => $label)), 'required');
560 }
561 break;
562 }
563 if (isset($qf->_online) && $qf->_online) {
564 $element->freeze();
565 }
566 }
567
568 /**
fe482240 569 * Retrieve a list of options for the specified field.
6a488035 570 *
414c1420
TO
571 * @param int $fieldId
572 * Price field ID.
573 * @param bool $inactiveNeeded
574 * Include inactive options.
575 * @param bool $reset
ba6920b3 576 * Discard stored values.
6a488035 577 *
a6c01b45
CW
578 * @return array
579 * array of options
6a488035
TO
580 */
581 public static function getOptions($fieldId, $inactiveNeeded = FALSE, $reset = FALSE) {
582 static $options = array();
ba6920b3 583 if ($reset) {
584 $options = array();
057e7134
EM
585 // This would happen if the function was only called to clear the cache.
586 if (empty($fieldId)) {
587 return array();
588 }
ba6920b3 589 }
6a488035 590
ba6920b3 591 if (empty($options[$fieldId])) {
6a488035 592 $values = array();
9da8dc8c 593 CRM_Price_BAO_PriceFieldValue::getValues($fieldId, $values, 'weight', !$inactiveNeeded);
6a488035 594 $options[$fieldId] = $values;
dc428161 595 $taxRates = CRM_Core_PseudoConstant::getTaxRates();
596
597 // ToDo - Code for Hook Invoke
598
599 foreach ($options[$fieldId] as $priceFieldId => $priceFieldValues) {
17ab42dd 600 if (isset($priceFieldValues['financial_type_id']) && array_key_exists($priceFieldValues['financial_type_id'], $taxRates)) {
dc428161 601 $options[$fieldId][$priceFieldId]['tax_rate'] = $taxRates[$priceFieldValues['financial_type_id']];
9d1c9154 602 $taxAmount = CRM_Contribute_BAO_Contribution_Utils::calculateTaxAmount($priceFieldValues['amount'], $options[$fieldId][$priceFieldId]['tax_rate']);
ac9def5a 603 $options[$fieldId][$priceFieldId]['tax_amount'] = $taxAmount['tax_amount'];
dc428161 604 }
605 }
6a488035
TO
606 }
607
608 return $options[$fieldId];
609 }
610
ffd93213
EM
611 /**
612 * @param $optionLabel
100fef9d 613 * @param int $fid
ffd93213
EM
614 *
615 * @return mixed
616 */
6a488035
TO
617 public static function getOptionId($optionLabel, $fid) {
618 if (!$optionLabel || !$fid) {
619 return;
620 }
621
622 $optionGroupName = "civicrm_price_field.amount.{$fid}";
623
624 $query = "
625SELECT
626 option_value.id as id
627FROM
628 civicrm_option_value option_value,
629 civicrm_option_group option_group
630WHERE
535a8e1e
CW
631 option_group.name = %1
632 AND option_group.id = option_value.option_group_id
6a488035
TO
633 AND option_value.label = %2";
634
353ffa53 635 $dao = CRM_Core_DAO::executeQuery($query, array(
c5c263ca
AH
636 1 => array($optionGroupName, 'String'),
637 2 => array($optionLabel, 'String'),
638 ));
6a488035
TO
639
640 while ($dao->fetch()) {
641 return $dao->id;
642 }
643 }
644
645 /**
646 * Delete the price set field.
647 *
414c1420
TO
648 * @param int $id
649 * Field Id.
6a488035 650 *
d5cc0fc2 651 * @return bool
6a488035 652 *
6a488035
TO
653 */
654 public static function deleteField($id) {
9da8dc8c 655 $field = new CRM_Price_DAO_PriceField();
6a488035
TO
656 $field->id = $id;
657
658 if ($field->find(TRUE)) {
659 // delete the options for this field
9da8dc8c 660 CRM_Price_BAO_PriceFieldValue::deleteValues($id);
6a488035
TO
661
662 // reorder the weight before delete
663 $fieldValues = array('price_set_id' => $field->price_set_id);
664
9da8dc8c 665 CRM_Utils_Weight::delWeight('CRM_Price_DAO_PriceField', $field->id, $fieldValues);
6a488035
TO
666
667 // now delete the field
668 return $field->delete();
669 }
670
671 return NULL;
672 }
673
ffd93213
EM
674 /**
675 * @return array
676 */
00be9182 677 public static function &htmlTypes() {
6a488035
TO
678 static $htmlTypes = NULL;
679 if (!$htmlTypes) {
680 $htmlTypes = array(
681 'Text' => ts('Text / Numeric Quantity'),
682 'Select' => ts('Select'),
683 'Radio' => ts('Radio'),
684 'CheckBox' => ts('CheckBox'),
685 );
686 }
687 return $htmlTypes;
688 }
689
690 /**
fe482240 691 * Validate the priceset.
6a488035 692 *
414c1420
TO
693 * @param int $priceSetId
694 * , array $fields.
6a488035
TO
695 *
696 * retrun the error string
697 *
2a6da8d7
EM
698 * @param $fields
699 * @param $error
700 * @param bool $allowNoneSelection
701 *
6a488035 702 */
6a488035
TO
703 public static function priceSetValidation($priceSetId, $fields, &$error, $allowNoneSelection = FALSE) {
704 // check for at least one positive
705 // amount price field should be selected.
9da8dc8c 706 $priceField = new CRM_Price_DAO_PriceField();
6a488035
TO
707 $priceField->price_set_id = $priceSetId;
708 $priceField->find();
709
710 $priceFields = array();
711
712 if ($allowNoneSelection) {
713 $noneSelectedPriceFields = array();
714 }
715
716 while ($priceField->fetch()) {
717 $key = "price_{$priceField->id}";
718
719 if ($allowNoneSelection) {
720 if (array_key_exists($key, $fields)) {
721 if ($fields[$key] == 0 && !$priceField->is_required) {
722 $noneSelectedPriceFields[] = $priceField->id;
723 }
724 }
725 }
726
a7488080 727 if (!empty($fields[$key])) {
6a488035
TO
728 $priceFields[$priceField->id] = $fields[$key];
729 }
730 }
731
732 if (!empty($priceFields)) {
733 // we should has to have positive amount.
734 $sql = "
735SELECT id, html_type
736FROM civicrm_price_field
737WHERE id IN (" . implode(',', array_keys($priceFields)) . ')';
738 $fieldDAO = CRM_Core_DAO::executeQuery($sql);
739 $htmlTypes = array();
740 while ($fieldDAO->fetch()) {
741 $htmlTypes[$fieldDAO->id] = $fieldDAO->html_type;
742 }
743
744 $selectedAmounts = array();
745
746 foreach ($htmlTypes as $fieldId => $type) {
747 $options = array();
9da8dc8c 748 CRM_Price_BAO_PriceFieldValue::getValues($fieldId, $options);
6a488035
TO
749
750 if (empty($options)) {
751 continue;
752 }
753
754 if ($type == 'Text') {
755 foreach ($options as $opId => $option) {
756 $selectedAmounts[$opId] = $priceFields[$fieldId] * $option['amount'];
757 break;
758 }
759 }
760 elseif (is_array($fields["price_{$fieldId}"])) {
761 foreach (array_keys($fields["price_{$fieldId}"]) as $opId) {
762 $selectedAmounts[$opId] = $options[$opId]['amount'];
763 }
764 }
765 elseif (in_array($fields["price_{$fieldId}"], array_keys($options))) {
766 $selectedAmounts[$fields["price_{$fieldId}"]] = $options[$fields["price_{$fieldId}"]]['amount'];
767 }
768 }
769
770 list($componentName) = explode(':', $fields['_qf_default']);
771 // now we have all selected amount in hand.
772 $totalAmount = array_sum($selectedAmounts);
773 if ($totalAmount < 0) {
774 $error['_qf_default'] = ts('%1 amount can not be less than zero. Please select the options accordingly.', array(1 => $componentName));
775 }
776 }
777 else {
778 if ($allowNoneSelection) {
779 if (empty($noneSelectedPriceFields)) {
780 $error['_qf_default'] = ts('Please select at least one option from price set.');
781 }
0db6c3e1
TO
782 }
783 else {
6a488035
TO
784 $error['_qf_default'] = ts('Please select at least one option from price set.');
785 }
786 }
787 }
dc428161 788
789 /**
9d1c9154 790 * Generate the label for price fields based on tax display setting option on CiviContribute Component Settings page.
dc428161 791 *
9d1c9154 792 * @param array $opt
414c1420
TO
793 * @param string $valueFieldName
794 * Amount.
795 * @param string $displayOpt
796 * Tax display setting option.
dc428161 797 *
ad37ac8e 798 * @param string $taxTerm
dc428161 799 *
ad37ac8e 800 * @return string
801 * Tax label for custom field.
dc428161 802 */
5ebee375 803 public static function getTaxLabel($opt, $valueFieldName, $displayOpt, $taxTerm) {
9d1c9154 804 if ($displayOpt == 'Do_not_show') {
805 $label = CRM_Utils_Money::format($opt[$valueFieldName] + $opt['tax_amount']);
806 }
4c9b6178 807 elseif ($displayOpt == 'Inclusive') {
9d1c9154 808 $label = CRM_Utils_Money::format($opt[$valueFieldName] + $opt['tax_amount']);
e2d2aeab 809 $label .= '<span class="crm-price-amount-tax"> (includes ' . $taxTerm . ' of ' . CRM_Utils_Money::format($opt['tax_amount']) . ')</span>';
9d1c9154 810 }
811 else {
812 $label = CRM_Utils_Money::format($opt[$valueFieldName]);
86bfa4f6 813 $label .= '<span class="crm-price-amount-tax"> + ' . CRM_Utils_Money::format($opt['tax_amount']) . ' ' . $taxTerm . '</span>';
9d1c9154 814 }
dc428161 815
9d1c9154 816 return $label;
dc428161 817 }
96025800 818
6a488035 819}