3 +--------------------------------------------------------------------+
4 | CiviCRM version 4.7 |
5 +--------------------------------------------------------------------+
6 | Copyright CiviCRM LLC (c) 2004-2016 |
7 +--------------------------------------------------------------------+
8 | This file is a part of CiviCRM. |
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. |
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. |
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 +--------------------------------------------------------------------+
31 * @copyright CiviCRM LLC (c) 2004-2016
35 class CRM_Member_BAO_MembershipType
extends CRM_Member_DAO_MembershipType
{
38 * Static holder for the default Membership Type.
40 static $_defaultMembershipType = NULL;
42 static $_membershipTypeInfo = array();
47 public function __construct() {
48 parent
::__construct();
52 * Fetch object based on array of properties.
54 * @param array $params
55 * (reference ) an assoc array of name/value pairs.
56 * @param array $defaults
57 * (reference ) an assoc array to hold the flattened values.
59 * @return CRM_Member_BAO_MembershipType
61 public static function retrieve(&$params, &$defaults) {
62 $membershipType = new CRM_Member_DAO_MembershipType();
63 $membershipType->copyValues($params);
64 if ($membershipType->find(TRUE)) {
65 CRM_Core_DAO
::storeValues($membershipType, $defaults);
66 return $membershipType;
72 * Update the is_active flag in the db.
75 * Id of the database record.
76 * @param bool $is_active
77 * Value we want to set the is_active field.
80 * DAO object on success, null otherwise
82 public static function setIsActive($id, $is_active) {
83 return CRM_Core_DAO
::setFieldValue('CRM_Member_DAO_MembershipType', $id, 'is_active', $is_active);
87 * Add the membership types.
89 * @param array $params
90 * Reference array contains the values submitted by the form.
92 * Array contains the id (deprecated).
97 public static function add(&$params, $ids = array()) {
98 $id = CRM_Utils_Array
::value('id', $params, CRM_Utils_Array
::value('membershipType', $ids));
100 if (!isset($params['is_active'])) {
102 $params['is_active'] = FALSE;
104 if (!isset($params['domain_id'])) {
105 $params['domain_id'] = CRM_Core_Config
::domainID();
110 $isError = CRM_Financial_BAO_FinancialAccount
::validateFinancialType(
111 CRM_Utils_Array
::value('financial_type_id', $params)
114 throw new CRM_Core_Exception(ts('Deferred revenue account is not configured for selected financial type. Please have an administrator set up the deferred revenue account at Administer > CiviContribute > Financial Accounts, then configure it for financial types at Administer > CiviContribution > Financial Types, Accounts'));
117 // action is taken depending upon the mode
118 $membershipType = new CRM_Member_DAO_MembershipType();
119 $membershipType->copyValues($params);
120 $membershipType->id
= $id;
122 // $previousID is the old organization id for membership type i.e 'member_of_contact_id'. This is used when an organization is changed.
125 $previousID = CRM_Core_DAO
::getFieldValue('CRM_Member_DAO_MembershipType', $id, 'member_of_contact_id');
128 $membershipType->save();
130 // on update we may need to retrieve some details for the price field function - otherwise we get e-notices on attempts to retrieve
131 // name etc - the presence of previous id tells us this is an update
132 $params = array_merge(civicrm_api3('membership_type', 'getsingle', array('id' => $membershipType->id
)), $params);
134 self
::createMembershipPriceField($params, $previousID, $membershipType->id
);
135 // update all price field value for quick config when membership type is set CRM-11718
137 self
::updateAllPriceFieldValue($id, $params);
140 return $membershipType;
144 * Flush anywhere that membership types might be cached.
146 * @throws \CiviCRM_API3_Exception
148 public static function flush() {
149 CRM_Member_PseudoConstant
::membershipType(NULL, TRUE);
150 civicrm_api3('membership', 'getfields', array('cache_clear' => 1, 'fieldname' => 'membership_type_id'));
151 civicrm_api3('profile', 'getfields', array('action' => 'submit', 'cache_clear' => 1));
155 * Delete membership Types.
157 * @param int $membershipTypeId
159 * @throws CRM_Core_Exception
162 public static function del($membershipTypeId) {
163 // Check dependencies.
167 'Membership' => 'membership_type_id',
168 'MembershipBlock' => 'membership_type_default',
171 foreach ($dependency as $name => $field) {
172 $baoString = 'CRM_Member_BAO_' . $name;
173 $dao = new $baoString();
174 $dao->$field = $membershipTypeId;
175 /** @noinspection PhpUndefinedMethodInspection */
176 if ($dao->find(TRUE)) {
183 $message = ts('This membership type cannot be deleted due to following reason(s):');
184 if (in_array('Membership', $status)) {
185 $findMembersURL = CRM_Utils_System
::url('civicrm/member/search', 'reset=1');
186 $deleteURL = CRM_Utils_System
::url('civicrm/contact/search/advanced', 'reset=1');
187 $message .= '<br/>' . ts('%3. There are some contacts who have this membership type assigned to them. Search for contacts with this membership type from <a href=\'%1\'>Find Members</a>. If you are still getting this message after deleting these memberships, there may be contacts in the Trash (deleted) with this membership type. Try using <a href="%2">Advanced Search</a> and checking "Search in Trash".', array(
188 1 => $findMembersURL,
195 if (in_array('MembershipBlock', $status)) {
196 $deleteURL = CRM_Utils_System
::url('civicrm/admin/contribute', 'reset=1');
197 $message .= ts('%2. This Membership Type is used in an <a href=\'%1\'>Online Contribution page</a>. Uncheck this membership type in the Memberships tab.', array(
201 throw new CRM_Core_Exception($message);
204 CRM_Utils_Weight
::delWeight('CRM_Member_DAO_MembershipType', $membershipTypeId);
205 //delete from membership Type table
206 $membershipType = new CRM_Member_DAO_MembershipType();
207 $membershipType->id
= $membershipTypeId;
209 //fix for membership type delete api
211 if ($membershipType->find(TRUE)) {
212 return $membershipType->delete();
219 * Convert membership type's 'start day' & 'rollover day' to human readable formats.
221 * @param array $membershipType
222 * An array of membershipType-details.
224 public static function convertDayFormat(&$membershipType) {
226 'fixed_period_start_day',
227 'fixed_period_rollover_day',
229 foreach ($membershipType as $id => $details) {
230 foreach ($periodDays as $pDay) {
231 if (!empty($details[$pDay])) {
232 if ($details[$pDay] > 31) {
233 $month = substr($details[$pDay], 0, strlen($details[$pDay]) - 2);
234 $day = substr($details[$pDay], -2);
249 $membershipType[$id][$pDay] = $monthMap[$month] . ' ' . $day;
252 $membershipType[$id][$pDay] = $details[$pDay];
260 * Get membership Types.
262 * @param bool $public
266 public static function getMembershipTypes($public = TRUE) {
267 $membershipTypes = array();
268 $membershipType = new CRM_Member_DAO_MembershipType();
269 $membershipType->is_active
= 1;
271 $membershipType->visibility
= 'Public';
273 $membershipType->orderBy(' weight');
274 $membershipType->find();
275 while ($membershipType->fetch()) {
276 $membershipTypes[$membershipType->id
] = $membershipType->name
;
278 $membershipType->free();
279 return $membershipTypes;
283 * Get membership Type Details.
285 * @param int $membershipTypeId
289 public static function getMembershipTypeDetails($membershipTypeId) {
290 $membershipTypeDetails = array();
292 $membershipType = new CRM_Member_DAO_MembershipType();
293 $membershipType->is_active
= 1;
294 $membershipType->id
= $membershipTypeId;
295 if ($membershipType->find(TRUE)) {
296 CRM_Core_DAO
::storeValues($membershipType, $membershipTypeDetails);
297 $membershipType->free();
298 return $membershipTypeDetails;
306 * Calculate start date and end date for new membership.
308 * @param int $membershipTypeId
309 * Membership type id.
310 * @param string $joinDate
311 * Member since ( in mysql date format ).
312 * @param string $startDate
313 * Start date ( in mysql date format ).
314 * @param null $endDate
315 * @param int $numRenewTerms
316 * How many membership terms are being added to end date (default is 1).
319 * associated array with start date, end date and join date for the membership
321 public static function getDatesForMembershipType($membershipTypeId, $joinDate = NULL, $startDate = NULL, $endDate = NULL, $numRenewTerms = 1) {
322 $membershipTypeDetails = self
::getMembershipTypeDetails($membershipTypeId);
324 // Convert all dates to 'Y-m-d' format.
330 if (!empty($
$dateParam)) {
331 $
$dateParam = CRM_Utils_Date
::processDate($
$dateParam, NULL, FALSE, 'Y-m-d');
335 $joinDate = date('Y-m-d');
337 $actualStartDate = $joinDate;
339 $actualStartDate = $startDate;
342 $fixed_period_rollover = FALSE;
343 if (CRM_Utils_Array
::value('period_type', $membershipTypeDetails) == 'rolling') {
345 $startDate = $joinDate;
347 $actualStartDate = $startDate;
349 elseif (CRM_Utils_Array
::value('period_type', $membershipTypeDetails) == 'fixed') {
350 // calculate start date
351 // if !$startDate then use $joinDate
352 $toDay = explode('-', (empty($startDate) ?
$joinDate : $startDate));
357 if ($membershipTypeDetails['duration_unit'] == 'year') {
359 //get start fixed day
360 $startMonth = substr($membershipTypeDetails['fixed_period_start_day'], 0,
361 strlen($membershipTypeDetails['fixed_period_start_day']) - 2
363 $startDay = substr($membershipTypeDetails['fixed_period_start_day'], -2);
365 if (date('Y-m-d', mktime(0, 0, 0, $startMonth, $startDay, $year)) <= date('Y-m-d', mktime(0, 0, 0, $month, $day, $year))) {
366 $actualStartDate = date('Y-m-d', mktime(0, 0, 0, $startMonth, $startDay, $year));
369 $actualStartDate = date('Y-m-d', mktime(0, 0, 0, $startMonth, $startDay, $year - 1));
372 $fixed_period_rollover = self
::isDuringFixedAnnualRolloverPeriod($joinDate, $membershipTypeDetails, $year, $actualStartDate);
375 $startDate = $actualStartDate;
378 elseif ($membershipTypeDetails['duration_unit'] == 'month') {
379 // Check if we are on or after rollover day of the month - CRM-10585
380 // If so, set fixed_period_rollover TRUE so we increment end_date month below.
381 $dateParts = explode('-', $actualStartDate);
382 if ($dateParts[2] >= $membershipTypeDetails['fixed_period_rollover_day']) {
383 $fixed_period_rollover = TRUE;
386 // Start date is always first day of actualStartDate month
388 $actualStartDate = $startDate = $year . '-' . $month . '-01';
393 // Calculate end date if it is not passed by user.
395 //end date calculation
396 $date = explode('-', $actualStartDate);
401 switch ($membershipTypeDetails['duration_unit']) {
403 $year = $year +
($numRenewTerms * $membershipTypeDetails['duration_interval']);
404 //extend membership date by duration interval.
405 if ($fixed_period_rollover) {
411 $month = $month +
($numRenewTerms * $membershipTypeDetails['duration_interval']);
412 //duration interval is month
413 if ($fixed_period_rollover) {
420 $day = $day +
($numRenewTerms * $membershipTypeDetails['duration_interval']);
422 if ($fixed_period_rollover) {
423 //Fix Me: Currently we don't allow rollover if
424 //duration interval is day
429 if ($membershipTypeDetails['duration_unit'] == 'lifetime') {
433 $endDate = date('Y-m-d', mktime(0, 0, 0, $month, $day - 1, $year));
437 $membershipDates = array(
438 'start_date' => CRM_Utils_Date
::customFormat($startDate, '%Y%m%d'),
439 'end_date' => CRM_Utils_Date
::customFormat($endDate, '%Y%m%d'),
440 'join_date' => CRM_Utils_Date
::customFormat($joinDate, '%Y%m%d'),
443 return $membershipDates;
447 * Does this membership start between the rollover date and the start of the next period.
448 * (in which case they will get an extra membership period)
449 * ie if annual memberships run June - May & the rollover is in May memberships between
450 * May and June will return TRUE and between June and May will return FALSE
452 * @param string $startDate start date of current membership period
453 * @param array $membershipTypeDetails
455 * @param string $actualStartDate
456 * @return bool is this in the window where the membership gets an extra part-period added
458 protected static function isDuringFixedAnnualRolloverPeriod($startDate, $membershipTypeDetails, $year, $actualStartDate) {
460 $rolloverMonth = substr($membershipTypeDetails['fixed_period_rollover_day'], 0,
461 strlen($membershipTypeDetails['fixed_period_rollover_day']) - 2
463 $rolloverDay = substr($membershipTypeDetails['fixed_period_rollover_day'], -2);
465 $calculatedRolloverDate = date('Y-m-d', mktime(0, 0, 0, $rolloverMonth, $rolloverDay, $year));
467 //CRM-7825 -membership date rules are :
468 //1. Membership should not be start in future.
469 //2. rollover window should be subset of membership window.
471 //get the fixed end date here.
472 $dateParts = explode('-', $actualStartDate);
473 $endDateOfFirstYearMembershipPeriod = date('Y-m-d', mktime(0, 0, 0,
479 //we know the month and day of the rollover date but not the year (we're just
480 //using the start date year at the moment. So if it's after the end
481 // of the first year of membership then it's the next period & we'll adjust back a year. If it's
482 // before the start_date then it's too early & we'll adjust forward.
483 if ($endDateOfFirstYearMembershipPeriod < $calculatedRolloverDate) {
484 $calculatedRolloverDate = date('Y-m-d', mktime(0, 0, 0, $rolloverMonth, $rolloverDay, $year - 1));
486 if ($calculatedRolloverDate < $actualStartDate) {
487 $calculatedRolloverDate = date('Y-m-d', mktime(0, 0, 0, $rolloverMonth, $rolloverDay, $year +
1));
490 if ($calculatedRolloverDate <= $startDate) {
497 * Calculate start date and end date for membership updates.
499 * Note that this function is called by the api for any membership update although it was
500 * originally written for renewal (which feels a bit fragile but hey....).
502 * @param int $membershipId
503 * @param $changeToday
504 * @param int $membershipTypeID
505 * If provided, overrides the membership type of the $membershipID membership.
506 * @param int $numRenewTerms
507 * How many membership terms are being added to end date (default is 1).
509 * CRM-7297 Membership Upsell - Added $membershipTypeID param to facilitate calculations of dates when membership type changes
512 * array fo the start date, end date and join date of the membership
514 public static function getRenewalDatesForMembershipType($membershipId, $changeToday = NULL, $membershipTypeID = NULL, $numRenewTerms = 1) {
515 $params = array('id' => $membershipId);
516 $membershipDetails = CRM_Member_BAO_Membership
::getValues($params, $values);
517 $membershipDetails = $membershipDetails[$membershipId];
518 $statusID = $membershipDetails->status_id
;
519 $membershipDates = array();
520 if (!empty($membershipDetails->join_date
)) {
521 $membershipDates['join_date'] = CRM_Utils_Date
::customFormat($membershipDetails->join_date
, '%Y%m%d');
524 $oldPeriodType = CRM_Core_DAO
::getFieldValue('CRM_Member_DAO_MembershipType',
525 CRM_Core_DAO
::getFieldValue('CRM_Member_DAO_Membership', $membershipId, 'membership_type_id'), 'period_type');
527 // CRM-7297 Membership Upsell
528 if (is_null($membershipTypeID)) {
529 $membershipTypeDetails = self
::getMembershipTypeDetails($membershipDetails->membership_type_id
);
532 $membershipTypeDetails = self
::getMembershipTypeDetails($membershipTypeID);
534 $statusDetails = CRM_Member_BAO_MembershipStatus
::getMembershipStatus($statusID);
536 if ($statusDetails['is_current_member'] == 1) {
537 $startDate = $membershipDetails->start_date
;
538 // CRM=7297 Membership Upsell: we need to handle null end_date in case we are switching
539 // from a lifetime to a different membership type
540 if (is_null($membershipDetails->end_date
)) {
541 $date = date('Y-m-d');
544 $date = $membershipDetails->end_date
;
546 $date = explode('-', $date);
547 $logStartDate = date('Y-m-d', mktime(0, 0, 0,
549 (double) ($date[2] +
1),
553 $date = explode('-', $logStartDate);
558 switch ($membershipTypeDetails['duration_unit']) {
560 //need to check if the upsell is from rolling to fixed and adjust accordingly
561 if ($membershipTypeDetails['period_type'] == 'fixed' && $oldPeriodType == 'rolling') {
562 $month = substr($membershipTypeDetails['fixed_period_start_day'], 0, strlen($membershipTypeDetails['fixed_period_start_day']) - 2);
563 $day = substr($membershipTypeDetails['fixed_period_start_day'], -2);
567 $year = $year +
($numRenewTerms * $membershipTypeDetails['duration_interval']);
572 $month = $month +
($numRenewTerms * $membershipTypeDetails['duration_interval']);
576 $day = $day +
($numRenewTerms * $membershipTypeDetails['duration_interval']);
579 if ($membershipTypeDetails['duration_unit'] == 'lifetime') {
583 $endDate = date('Y-m-d', mktime(0, 0, 0,
589 $today = date('Y-m-d');
590 $membershipDates['today'] = CRM_Utils_Date
::customFormat($today, '%Y%m%d');
591 $membershipDates['start_date'] = CRM_Utils_Date
::customFormat($startDate, '%Y%m%d');
592 $membershipDates['end_date'] = CRM_Utils_Date
::customFormat($endDate, '%Y%m%d');
593 $membershipDates['log_start_date'] = CRM_Utils_Date
::customFormat($logStartDate, '%Y%m%d');
596 $today = date('Y-m-d');
598 $today = CRM_Utils_Date
::processDate($changeToday, NULL, FALSE, 'Y-m-d');
600 // Calculate new start/end dates when join date is today
601 $renewalDates = self
::getDatesForMembershipType($membershipTypeDetails['id'],
602 $today, NULL, NULL, $numRenewTerms
604 $membershipDates['today'] = CRM_Utils_Date
::customFormat($today, '%Y%m%d');
605 $membershipDates['start_date'] = $renewalDates['start_date'];
606 $membershipDates['end_date'] = $renewalDates['end_date'];
607 $membershipDates['log_start_date'] = $renewalDates['start_date'];
609 if (!isset($membershipDates['join_date'])) {
610 $membershipDates['join_date'] = $membershipDates['start_date'];
613 return $membershipDates;
617 * Retrieve all Membership Types associated.
618 * with an Organization
621 * Id of Organization.
624 * array of the details of membership types
626 public static function getMembershipTypesByOrg($orgID) {
627 $membershipTypes = array();
628 $dao = new CRM_Member_DAO_MembershipType();
629 $dao->member_of_contact_id
= $orgID;
631 while ($dao->fetch()) {
632 $membershipTypes[$dao->id
] = array();
633 CRM_Core_DAO
::storeValues($dao, $membershipTypes[$dao->id
]);
635 return $membershipTypes;
639 * Retrieve all Membership Types with Member of Contact id.
641 * @param array $membershipTypes
642 * array of membership type ids
644 * array of the details of membership types with Member of Contact id
646 public static function getMemberOfContactByMemTypes($membershipTypes) {
647 $memTypeOrganizations = array();
648 if (empty($membershipTypes)) {
649 return $memTypeOrganizations;
652 $result = CRM_Core_DAO
::executeQuery("SELECT id, member_of_contact_id FROM civicrm_membership_type WHERE id IN (" . implode(',', $membershipTypes) . ")");
653 while ($result->fetch()) {
654 $memTypeOrganizations[$result->id
] = $result->member_of_contact_id
;
657 return $memTypeOrganizations;
661 * The function returns all the Organization for all membershipTypes .
663 * @param int $membershipTypeId
667 public static function getMembershipTypeOrganization($membershipTypeId = NULL) {
668 $allMembershipTypes = array();
670 $membershipType = new CRM_Member_DAO_MembershipType();
672 if (isset($membershipTypeId)) {
673 $membershipType->id
= $membershipTypeId;
675 $membershipType->find();
677 while ($membershipType->fetch()) {
678 $allMembershipTypes[$membershipType->id
] = $membershipType->member_of_contact_id
;
680 return $allMembershipTypes;
684 * Function to retrieve organization and associated membership
688 * arrays of organization and membership types
691 public static function getMembershipTypeInfo() {
692 if (!self
::$_membershipTypeInfo) {
693 $orgs = $types = array();
695 $query = 'SELECT memType.id, memType.name, memType.member_of_contact_id, c.sort_name
696 FROM civicrm_membership_type memType INNER JOIN civicrm_contact c ON c.id = memType.member_of_contact_id
697 WHERE memType.is_active = 1 ';
698 $dao = CRM_Core_DAO
::executeQuery($query);
699 while ($dao->fetch()) {
700 $orgs[$dao->member_of_contact_id
] = $dao->sort_name
;
701 $types[$dao->member_of_contact_id
][$dao->id
] = $dao->name
;
704 self
::$_membershipTypeInfo = array($orgs, $types);
706 return self
::$_membershipTypeInfo;
711 * @param array $params
712 * @param int $previousID
713 * @param int $membershipTypeId
715 public static function createMembershipPriceField($params, $previousID, $membershipTypeId) {
717 $priceSetId = CRM_Core_DAO
::getFieldValue('CRM_Price_DAO_PriceSet', 'default_membership_type_amount', 'id', 'name');
719 if (!empty($params['member_of_contact_id'])) {
720 $fieldName = $params['member_of_contact_id'];
723 $fieldName = $previousID;
725 $fieldLabel = 'Membership Amount';
727 $fieldParams = array(
728 'price_set_id ' => $priceSetId,
729 'name' => $fieldName,
732 CRM_Price_BAO_PriceField
::retrieve($fieldParams, $results);
733 if (empty($results)) {
734 $fieldParams = array();
735 $fieldParams['label'] = $fieldLabel;
736 $fieldParams['name'] = $fieldName;
737 $fieldParams['price_set_id'] = $priceSetId;
738 $fieldParams['html_type'] = 'Radio';
739 $fieldParams['is_display_amounts'] = $fieldParams['is_required'] = 0;
740 $fieldParams['weight'] = $fieldParams['option_weight'][1] = 1;
741 $fieldParams['option_label'][1] = $params['name'];
742 $fieldParams['option_description'][1] = CRM_Utils_Array
::value('description', $params);
744 $fieldParams['membership_type_id'][1] = $membershipTypeId;
745 $fieldParams['option_amount'][1] = empty($params['minimum_fee']) ?
0 : $params['minimum_fee'];
746 $fieldParams['financial_type_id'] = CRM_Utils_Array
::value('financial_type_id', $params);
749 CRM_Member_Form_MembershipType
::checkPreviousPriceField($previousID, $priceSetId, $membershipTypeId, $optionsIds);
750 $fieldParams['option_id'] = CRM_Utils_Array
::value('option_id', $optionsIds);
752 CRM_Price_BAO_PriceField
::create($fieldParams);
755 $fieldID = $results['id'];
756 $fieldValueParams = array(
757 'price_field_id' => $fieldID,
758 'membership_type_id' => $membershipTypeId,
761 CRM_Price_BAO_PriceFieldValue
::retrieve($fieldValueParams, $results);
762 if (!empty($results)) {
763 $results['label'] = $results['name'] = $params['name'];
764 $results['amount'] = empty($params['minimum_fee']) ?
0 : $params['minimum_fee'];
765 $optionsIds['id'] = $results['id'];
769 'price_field_id' => $fieldID,
770 'name' => $params['name'],
771 'label' => $params['name'],
772 'amount' => empty($params['minimum_fee']) ?
0 : $params['minimum_fee'],
773 'membership_type_id' => $membershipTypeId,
779 CRM_Member_Form_MembershipType
::checkPreviousPriceField($previousID, $priceSetId, $membershipTypeId, $optionsIds);
780 if (!empty($optionsIds['option_id'])) {
781 $optionsIds['id'] = current(CRM_Utils_Array
::value('option_id', $optionsIds));
784 $results['financial_type_id'] = CRM_Utils_Array
::value('financial_type_id', $params);
785 $results['description'] = CRM_Utils_Array
::value('description', $params);
786 CRM_Price_BAO_PriceFieldValue
::add($results, $optionsIds);
791 * This function updates all price field value for quick config
792 * price set which has membership type
794 * @param int $membershipTypeId membership type id
796 * @param array $params
798 public static function updateAllPriceFieldValue($membershipTypeId, $params) {
799 $updateFields = array();
800 if (!empty($params['minimum_fee'])) {
801 $amount = $params['minimum_fee'];
807 $updateValues = array(
808 2 => array('financial_type_id', 'financial_type_id', 'Integer'),
809 3 => array('label', 'name', 'String'),
810 4 => array('amount', 'minimum_fee', 'Float'),
811 5 => array('description', 'description', 'String'),
814 $queryParams = array(1 => array($membershipTypeId, 'Integer'));
815 foreach ($updateValues as $key => $value) {
816 if (array_key_exists($value[1], $params)) {
817 $updateFields[] = "cpfv." . $value[0] . " = %$key";
818 if ($value[1] == 'minimum_fee') {
819 $fieldValue = $amount;
822 $fieldValue = $params[$value[1]];
824 $queryParams[$key] = array($fieldValue, $value[2]);
828 $query = "UPDATE `civicrm_price_field_value` cpfv
829 INNER JOIN civicrm_price_field cpf on cpf.id = cpfv.price_field_id
830 INNER JOIN civicrm_price_set cps on cps.id = cpf.price_set_id
831 SET " . implode(' , ', $updateFields) . " WHERE cpfv.membership_type_id = %1
832 AND cps.is_quick_config = 1 AND cps.name != 'default_membership_type_amount'";
833 CRM_Core_DAO
::executeQuery($query, $queryParams);