CRM/Member/BAO/MembershipType.php

   1 <?php
   2 /*
   3  +--------------------------------------------------------------------+
   4  | CiviCRM version 5                                                  |
   5  +--------------------------------------------------------------------+
   6  | Copyright CiviCRM LLC (c) 2004-2018                                |
   7  +--------------------------------------------------------------------+
   8  | This file is a part of CiviCRM.                                    |
   9  |                                                                    |
  10  | CiviCRM is free software; you can copy, modify, and distribute it  |
  11  | under the terms of the GNU Affero General Public License           |
  12  | Version 3, 19 November 2007 and the CiviCRM Licensing Exception.   |
  13  |                                                                    |
  14  | CiviCRM is distributed in the hope that it will be useful, but     |
  15  | WITHOUT ANY WARRANTY; without even the implied warranty of         |
  16  | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.               |
  17  | See the GNU Affero General Public License for more details.        |
  18  |                                                                    |
  19  | You should have received a copy of the GNU Affero General Public   |
  20  | License and the CiviCRM Licensing Exception along                  |
  21  | with this program; if not, contact CiviCRM LLC                     |
  22  | at info[AT]civicrm[DOT]org. If you have questions about the        |
  23  | GNU Affero General Public License or the licensing of CiviCRM,     |
  24  | see the CiviCRM license FAQ at http://civicrm.org/licensing        |
  25  +--------------------------------------------------------------------+
  26  */
  27
  28 /**
  29  *
  30  * @package CRM
  31  * @copyright CiviCRM LLC (c) 2004-2018
  32  * $Id$
  33  *
  34  */
  35 class CRM_Member_BAO_MembershipType extends CRM_Member_DAO_MembershipType {
  36
  37   /**
  38    * Static holder for the default Membership Type.
  39    */
  40   static $_defaultMembershipType = NULL;
  41
  42   static $_membershipTypeInfo = array();
  43
  44   /**
  45    * Class constructor.
  46    */
  47   public function __construct() {
  48     parent::__construct();
  49   }
  50
  51   /**
  52    * Fetch object based on array of properties.
  53    *
  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.
  58    *
  59    * @return CRM_Member_BAO_MembershipType
  60    */
  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;
  67     }
  68     return NULL;
  69   }
  70
  71   /**
  72    * Update the is_active flag in the db.
  73    *
  74    * @param int $id
  75    *   Id of the database record.
  76    * @param bool $is_active
  77    *   Value we want to set the is_active field.
  78    *
  79    * @return Object
  80    *   DAO object on success, null otherwise
  81    */
  82   public static function setIsActive($id, $is_active) {
  83     return CRM_Core_DAO::setFieldValue('CRM_Member_DAO_MembershipType', $id, 'is_active', $is_active);
  84   }
  85
  86   /**
  87    * Add the membership types.
  88    *
  89    * @param array $params
  90    *   Reference array contains the values submitted by the form.
  91    * @param array $ids
  92    *   Array contains the id (deprecated).
  93    *
  94    *
  95    * @return object
  96    */
  97   public static function add(&$params, $ids = array()) {
  98     $id = CRM_Utils_Array::value('id', $params, CRM_Utils_Array::value('membershipType', $ids));
  99     if (!$id) {
 100       if (!isset($params['is_active'])) {
 101         // do we need this?
 102         $params['is_active'] = FALSE;
 103       }
 104       if (!isset($params['domain_id'])) {
 105         $params['domain_id'] = CRM_Core_Config::domainID();
 106       }
 107     }
 108
 109     // action is taken depending upon the mode
 110     $membershipType = new CRM_Member_DAO_MembershipType();
 111     $membershipType->copyValues($params);
 112     $membershipType->id = $id;
 113
 114     // $previousID is the old organization id for membership type i.e 'member_of_contact_id'. This is used when an organization is changed.
 115     $previousID = NULL;
 116     if ($id) {
 117       $previousID = CRM_Core_DAO::getFieldValue('CRM_Member_DAO_MembershipType', $id, 'member_of_contact_id');
 118     }
 119
 120     $membershipType->save();
 121     if ($id) {
 122       // on update we may need to retrieve some details for the price field function - otherwise we get e-notices on attempts to retrieve
 123       // name etc - the presence of previous id tells us this is an update
 124       $params = array_merge(civicrm_api3('membership_type', 'getsingle', array('id' => $membershipType->id)), $params);
 125     }
 126     self::createMembershipPriceField($params, $previousID, $membershipType->id);
 127     // update all price field value for quick config when membership type is set CRM-11718
 128     if ($id) {
 129       self::updateAllPriceFieldValue($id, $params);
 130     }
 131     self::flush();
 132     return $membershipType;
 133   }
 134
 135   /**
 136    * Flush anywhere that membership types might be cached.
 137    *
 138    * @throws \CiviCRM_API3_Exception
 139    */
 140   public static function flush() {
 141     CRM_Member_PseudoConstant::membershipType(NULL, TRUE);
 142     civicrm_api3('membership', 'getfields', array('cache_clear' => 1, 'fieldname' => 'membership_type_id'));
 143     civicrm_api3('profile', 'getfields', array('action' => 'submit', 'cache_clear' => 1));
 144   }
 145
 146   /**
 147    * Delete membership Types.
 148    *
 149    * @param int $membershipTypeId
 150    *
 151    * @throws CRM_Core_Exception
 152    * @return bool|mixed
 153    */
 154   public static function del($membershipTypeId) {
 155     // Check dependencies.
 156     $check = FALSE;
 157     $status = array();
 158     $dependency = array(
 159       'Membership' => 'membership_type_id',
 160       'MembershipBlock' => 'membership_type_default',
 161     );
 162
 163     foreach ($dependency as $name => $field) {
 164       $baoString = 'CRM_Member_BAO_' . $name;
 165       $dao = new $baoString();
 166       $dao->$field = $membershipTypeId;
 167       /** @noinspection PhpUndefinedMethodInspection */
 168       if ($dao->find(TRUE)) {
 169         $check = TRUE;
 170         $status[] = $name;
 171       }
 172     }
 173     if ($check) {
 174       $cnt = 1;
 175       $message = ts('This membership type cannot be deleted due to following reason(s):');
 176       if (in_array('Membership', $status)) {
 177         $findMembersURL = CRM_Utils_System::url('civicrm/member/search', 'reset=1');
 178         $deleteURL = CRM_Utils_System::url('civicrm/contact/search/advanced', 'reset=1');
 179         $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(
 180           1 => $findMembersURL,
 181           2 => $deleteURL,
 182           3 => $cnt,
 183         ));
 184         $cnt++;
 185       }
 186
 187       if (in_array('MembershipBlock', $status)) {
 188         $deleteURL = CRM_Utils_System::url('civicrm/admin/contribute', 'reset=1');
 189         $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(
 190           1 => $deleteURL,
 191           2 => $cnt,
 192         ));
 193         throw new CRM_Core_Exception($message);
 194       }
 195     }
 196     CRM_Utils_Weight::delWeight('CRM_Member_DAO_MembershipType', $membershipTypeId);
 197     //delete from membership Type table
 198     $membershipType = new CRM_Member_DAO_MembershipType();
 199     $membershipType->id = $membershipTypeId;
 200
 201     //fix for membership type delete api
 202     $result = FALSE;
 203     if ($membershipType->find(TRUE)) {
 204       return $membershipType->delete();
 205     }
 206
 207     return $result;
 208   }
 209
 210   /**
 211    * Convert membership type's 'start day' & 'rollover day' to human readable formats.
 212    *
 213    * @param array $membershipType
 214    *   An array of membershipType-details.
 215    */
 216   public static function convertDayFormat(&$membershipType) {
 217     $periodDays = array(
 218       'fixed_period_start_day',
 219       'fixed_period_rollover_day',
 220     );
 221     foreach ($membershipType as $id => $details) {
 222       foreach ($periodDays as $pDay) {
 223         if (!empty($details[$pDay])) {
 224           if ($details[$pDay] > 31) {
 225             $month = substr($details[$pDay], 0, strlen($details[$pDay]) - 2);
 226             $day = substr($details[$pDay], -2);
 227             $monthMap = array(
 228               '1' => 'Jan',
 229               '2' => 'Feb',
 230               '3' => 'Mar',
 231               '4' => 'Apr',
 232               '5' => 'May',
 233               '6' => 'Jun',
 234               '7' => 'Jul',
 235               '8' => 'Aug',
 236               '9' => 'Sep',
 237               '10' => 'Oct',
 238               '11' => 'Nov',
 239               '12' => 'Dec',
 240             );
 241             $membershipType[$id][$pDay] = $monthMap[$month] . ' ' . $day;
 242           }
 243           else {
 244             $membershipType[$id][$pDay] = $details[$pDay];
 245           }
 246         }
 247       }
 248     }
 249   }
 250
 251   /**
 252    * Get membership Types.
 253    *
 254    * @param bool $public
 255    *
 256    * @return array
 257    */
 258   public static function getMembershipTypes($public = TRUE) {
 259     $membershipTypes = array();
 260     $membershipType = new CRM_Member_DAO_MembershipType();
 261     $membershipType->is_active = 1;
 262     if ($public) {
 263       $membershipType->visibility = 'Public';
 264     }
 265     $membershipType->orderBy(' weight');
 266     $membershipType->find();
 267     while ($membershipType->fetch()) {
 268       $membershipTypes[$membershipType->id] = $membershipType->name;
 269     }
 270     $membershipType->free();
 271     return $membershipTypes;
 272   }
 273
 274   /**
 275    * Get membership Type Details.
 276    *
 277    * @param int $membershipTypeId
 278    *
 279    * @return array|null
 280    */
 281   public static function getMembershipTypeDetails($membershipTypeId) {
 282     $membershipTypeDetails = array();
 283
 284     $membershipType = new CRM_Member_DAO_MembershipType();
 285     $membershipType->is_active = 1;
 286     $membershipType->id = $membershipTypeId;
 287     if ($membershipType->find(TRUE)) {
 288       CRM_Core_DAO::storeValues($membershipType, $membershipTypeDetails);
 289       $membershipType->free();
 290       return $membershipTypeDetails;
 291     }
 292     else {
 293       return NULL;
 294     }
 295   }
 296
 297   /**
 298    * Calculate start date and end date for new membership.
 299    *
 300    * @param int $membershipTypeId
 301    *   Membership type id.
 302    * @param string $joinDate
 303    *   Member since ( in mysql date format ).
 304    * @param string $startDate
 305    *   Start date ( in mysql date format ).
 306    * @param null $endDate
 307    * @param int $numRenewTerms
 308    *   How many membership terms are being added to end date (default is 1).
 309    *
 310    * @return array
 311    *   associated array with  start date, end date and join date for the membership
 312    */
 313   public static function getDatesForMembershipType($membershipTypeId, $joinDate = NULL, $startDate = NULL, $endDate = NULL, $numRenewTerms = 1) {
 314     $membershipTypeDetails = self::getMembershipTypeDetails($membershipTypeId);
 315
 316     // Convert all dates to 'Y-m-d' format.
 317     foreach (array(
 318       'joinDate',
 319       'startDate',
 320       'endDate',
 321     ) as $dateParam) {
 322       if (!empty($$dateParam)) {
 323         $$dateParam = CRM_Utils_Date::processDate($$dateParam, NULL, FALSE, 'Y-m-d');
 324       }
 325     }
 326     if (!$joinDate) {
 327       $joinDate = date('Y-m-d');
 328     }
 329     $actualStartDate = $joinDate;
 330     if ($startDate) {
 331       $actualStartDate = $startDate;
 332     }
 333
 334     $fixed_period_rollover = FALSE;
 335     if (CRM_Utils_Array::value('period_type', $membershipTypeDetails) == 'rolling') {
 336       if (!$startDate) {
 337         $startDate = $joinDate;
 338       }
 339       $actualStartDate = $startDate;
 340     }
 341     elseif (CRM_Utils_Array::value('period_type', $membershipTypeDetails) == 'fixed') {
 342       // calculate start date
 343       // if !$startDate then use $joinDate
 344       $toDay = explode('-', (empty($startDate) ? $joinDate : $startDate));
 345       $year = $toDay[0];
 346       $month = $toDay[1];
 347       $day = $toDay[2];
 348
 349       if ($membershipTypeDetails['duration_unit'] == 'year') {
 350
 351         //get start fixed day
 352         $startMonth = substr($membershipTypeDetails['fixed_period_start_day'], 0,
 353           strlen($membershipTypeDetails['fixed_period_start_day']) - 2
 354         );
 355         $startDay = substr($membershipTypeDetails['fixed_period_start_day'], -2);
 356
 357         if (date('Y-m-d', mktime(0, 0, 0, $startMonth, $startDay, $year)) <= date('Y-m-d', mktime(0, 0, 0, $month, $day, $year))) {
 358           $actualStartDate = date('Y-m-d', mktime(0, 0, 0, $startMonth, $startDay, $year));
 359         }
 360         else {
 361           $actualStartDate = date('Y-m-d', mktime(0, 0, 0, $startMonth, $startDay, $year - 1));
 362         }
 363
 364         $fixed_period_rollover = self::isDuringFixedAnnualRolloverPeriod($joinDate, $membershipTypeDetails, $year, $actualStartDate);
 365
 366         if (!$startDate) {
 367           $startDate = $actualStartDate;
 368         }
 369       }
 370       elseif ($membershipTypeDetails['duration_unit'] == 'month') {
 371         // Check if we are on or after rollover day of the month - CRM-10585
 372         // If so, set fixed_period_rollover TRUE so we increment end_date month below.
 373         $dateParts = explode('-', $actualStartDate);
 374         if ($dateParts[2] >= $membershipTypeDetails['fixed_period_rollover_day']) {
 375           $fixed_period_rollover = TRUE;
 376         }
 377
 378         // Start date is always first day of actualStartDate month
 379         if (!$startDate) {
 380           $actualStartDate = $startDate = $year . '-' . $month . '-01';
 381         }
 382       }
 383     }
 384
 385     // Calculate end date if it is not passed by user.
 386     if (!$endDate) {
 387       //end date calculation
 388       $date = explode('-', $actualStartDate);
 389       $year = $date[0];
 390       $month = $date[1];
 391       $day = $date[2];
 392
 393       switch ($membershipTypeDetails['duration_unit']) {
 394         case 'year':
 395           $year = $year + ($numRenewTerms * $membershipTypeDetails['duration_interval']);
 396           //extend membership date by duration interval.
 397           if ($fixed_period_rollover) {
 398             $year += 1;
 399           }
 400           break;
 401
 402         case 'month':
 403           $month = $month + ($numRenewTerms * $membershipTypeDetails['duration_interval']);
 404           //duration interval is month
 405           if ($fixed_period_rollover) {
 406             //CRM-10585
 407             $month += 1;
 408           }
 409           break;
 410
 411         case 'day':
 412           $day = $day + ($numRenewTerms * $membershipTypeDetails['duration_interval']);
 413
 414           if ($fixed_period_rollover) {
 415             //Fix Me: Currently we don't allow rollover if
 416             //duration interval is day
 417           }
 418           break;
 419       }
 420
 421       if ($membershipTypeDetails['duration_unit'] == 'lifetime') {
 422         $endDate = NULL;
 423       }
 424       else {
 425         $endDate = date('Y-m-d', mktime(0, 0, 0, $month, $day - 1, $year));
 426       }
 427     }
 428
 429     $membershipDates = array(
 430       'start_date' => CRM_Utils_Date::customFormat($startDate, '%Y%m%d'),
 431       'end_date' => CRM_Utils_Date::customFormat($endDate, '%Y%m%d'),
 432       'join_date' => CRM_Utils_Date::customFormat($joinDate, '%Y%m%d'),
 433     );
 434
 435     return $membershipDates;
 436   }
 437
 438   /**
 439    * Does this membership start between the rollover date and the start of the next period.
 440    * (in which case they will get an extra membership period)
 441    *  ie if annual memberships run June - May & the rollover is in May memberships between
 442    * May and June will return TRUE and between June and May will return FALSE
 443    *
 444    * @param string $startDate start date of current membership period
 445    * @param array $membershipTypeDetails
 446    * @param int $year
 447    * @param string $actualStartDate
 448    * @return bool is this in the window where the membership gets an extra part-period added
 449    */
 450   public static function isDuringFixedAnnualRolloverPeriod($startDate, $membershipTypeDetails, $year, $actualStartDate) {
 451
 452     $rolloverMonth = substr($membershipTypeDetails['fixed_period_rollover_day'], 0,
 453       strlen($membershipTypeDetails['fixed_period_rollover_day']) - 2
 454     );
 455     $rolloverDay = substr($membershipTypeDetails['fixed_period_rollover_day'], -2);
 456
 457     $calculatedRolloverDate = date('Y-m-d', mktime(0, 0, 0, $rolloverMonth, $rolloverDay, $year));
 458
 459     //CRM-7825 -membership date rules are :
 460     //1. Membership should not be start in future.
 461     //2. rollover window should be subset of membership window.
 462
 463     //get the fixed end date here.
 464     $dateParts = explode('-', $actualStartDate);
 465     $endDateOfFirstYearMembershipPeriod = date('Y-m-d', mktime(0, 0, 0,
 466       $dateParts[1],
 467       $dateParts[2] - 1,
 468       $dateParts[0] + 1
 469     ));
 470
 471     //we know the month and day of the rollover date but not the year (we're just
 472     //using the start date year at the moment. So if it's after the end
 473     // of the first year of membership then it's the next period & we'll adjust back a year. If it's
 474     // before the start_date then it's too early & we'll adjust forward.
 475     if ($endDateOfFirstYearMembershipPeriod < $calculatedRolloverDate) {
 476       $calculatedRolloverDate = date('Y-m-d', mktime(0, 0, 0, $rolloverMonth, $rolloverDay, $year - 1));
 477     }
 478     if ($calculatedRolloverDate < $actualStartDate) {
 479       $calculatedRolloverDate = date('Y-m-d', mktime(0, 0, 0, $rolloverMonth, $rolloverDay, $year + 1));
 480     }
 481
 482     if ($calculatedRolloverDate <= $startDate) {
 483       return TRUE;
 484     }
 485     return FALSE;
 486   }
 487
 488   /**
 489    * Calculate start date and end date for membership updates.
 490    *
 491    * Note that this function is called by the api for any membership update although it was
 492    * originally written for renewal (which feels a bit fragile but hey....).
 493    *
 494    * @param int $membershipId
 495    * @param $changeToday
 496    * @param int $membershipTypeID
 497    *   If provided, overrides the membership type of the $membershipID membership.
 498    * @param int $numRenewTerms
 499    *   How many membership terms are being added to end date (default is 1).
 500    *
 501    * CRM-7297 Membership Upsell - Added $membershipTypeID param to facilitate calculations of dates when membership type changes
 502    *
 503    * @return array
 504    *   array fo the start date, end date and join date of the membership
 505    */
 506   public static function getRenewalDatesForMembershipType($membershipId, $changeToday = NULL, $membershipTypeID = NULL, $numRenewTerms = 1) {
 507     $params = array('id' => $membershipId);
 508     $membershipDetails = CRM_Member_BAO_Membership::getValues($params, $values);
 509     $membershipDetails = $membershipDetails[$membershipId];
 510     $statusID = $membershipDetails->status_id;
 511     $membershipDates = array();
 512     if (!empty($membershipDetails->join_date)) {
 513       $membershipDates['join_date'] = CRM_Utils_Date::customFormat($membershipDetails->join_date, '%Y%m%d');
 514     }
 515
 516     $oldPeriodType = CRM_Core_DAO::getFieldValue('CRM_Member_DAO_MembershipType',
 517       CRM_Core_DAO::getFieldValue('CRM_Member_DAO_Membership', $membershipId, 'membership_type_id'), 'period_type');
 518
 519     // CRM-7297 Membership Upsell
 520     if (is_null($membershipTypeID)) {
 521       $membershipTypeDetails = self::getMembershipTypeDetails($membershipDetails->membership_type_id);
 522     }
 523     else {
 524       $membershipTypeDetails = self::getMembershipTypeDetails($membershipTypeID);
 525     }
 526     $statusDetails = CRM_Member_BAO_MembershipStatus::getMembershipStatus($statusID);
 527
 528     if ($statusDetails['is_current_member'] == 1) {
 529       $startDate = $membershipDetails->start_date;
 530       // CRM=7297 Membership Upsell: we need to handle null end_date in case we are switching
 531       // from a lifetime to a different membership type
 532       if (is_null($membershipDetails->end_date)) {
 533         $date = date('Y-m-d');
 534       }
 535       else {
 536         $date = $membershipDetails->end_date;
 537       }
 538       $date = explode('-', $date);
 539       // We have to add 1 day first in case it's the end of the month, then subtract afterwards
 540       // eg. 2018-02-28 should renew to 2018-03-31, if we just added 1 month we'd get 2018-03-28
 541       $logStartDate = date('Y-m-d', mktime(0, 0, 0,
 542         (double) $date[1],
 543         (double) ($date[2] + 1),
 544         (double) $date[0]
 545       ));
 546
 547       $date = explode('-', $logStartDate);
 548       $year = $date[0];
 549       $month = $date[1];
 550       $day = $date[2];
 551
 552       switch ($membershipTypeDetails['duration_unit']) {
 553         case 'year':
 554           //need to check if the upsell is from rolling to fixed and adjust accordingly
 555           if ($membershipTypeDetails['period_type'] == 'fixed' && $oldPeriodType == 'rolling') {
 556             $month = substr($membershipTypeDetails['fixed_period_start_day'], 0, strlen($membershipTypeDetails['fixed_period_start_day']) - 2);
 557             $day = substr($membershipTypeDetails['fixed_period_start_day'], -2);
 558             $year += 1;
 559           }
 560           else {
 561             $year = $year + ($numRenewTerms * $membershipTypeDetails['duration_interval']);
 562           }
 563           break;
 564
 565         case 'month':
 566           $month = $month + ($numRenewTerms * $membershipTypeDetails['duration_interval']);
 567           break;
 568
 569         case 'day':
 570           $day = $day + ($numRenewTerms * $membershipTypeDetails['duration_interval']);
 571           break;
 572       }
 573       if ($membershipTypeDetails['duration_unit'] == 'lifetime') {
 574         $endDate = NULL;
 575       }
 576       else {
 577         $endDate = date('Y-m-d', mktime(0, 0, 0,
 578           $month,
 579           $day - 1,
 580           $year
 581         ));
 582       }
 583       $today = date('Y-m-d');
 584       $membershipDates['today'] = CRM_Utils_Date::customFormat($today, '%Y%m%d');
 585       $membershipDates['start_date'] = CRM_Utils_Date::customFormat($startDate, '%Y%m%d');
 586       $membershipDates['end_date'] = CRM_Utils_Date::customFormat($endDate, '%Y%m%d');
 587       $membershipDates['log_start_date'] = CRM_Utils_Date::customFormat($logStartDate, '%Y%m%d');
 588     }
 589     else {
 590       $today = date('Y-m-d');
 591       if ($changeToday) {
 592         $today = CRM_Utils_Date::processDate($changeToday, NULL, FALSE, 'Y-m-d');
 593       }
 594       // Calculate new start/end dates when join date is today
 595       $renewalDates = self::getDatesForMembershipType($membershipTypeDetails['id'],
 596         $today, NULL, NULL, $numRenewTerms
 597       );
 598       $membershipDates['today'] = CRM_Utils_Date::customFormat($today, '%Y%m%d');
 599       $membershipDates['start_date'] = $renewalDates['start_date'];
 600       $membershipDates['end_date'] = $renewalDates['end_date'];
 601       $membershipDates['log_start_date'] = $renewalDates['start_date'];
 602       // CRM-18503 - set join_date as today in case the membership type is fixed.
 603       if ($membershipTypeDetails['period_type'] == 'fixed' && !isset($membershipDates['join_date'])) {
 604         $membershipDates['join_date'] = $renewalDates['join_date'];
 605       }
 606     }
 607     if (!isset($membershipDates['join_date'])) {
 608       $membershipDates['join_date'] = $membershipDates['start_date'];
 609     }
 610
 611     return $membershipDates;
 612   }
 613
 614   /**
 615    * @deprecated Please use the Membership API
 616    * Retrieve all Membership Types associated with an Organization
 617    *
 618    * @param int $orgID
 619    *   Id of Organization.
 620    *
 621    * @return array
 622    *   array of the details of membership types
 623    */
 624   public static function getMembershipTypesByOrg($orgID) {
 625     Civi::log()->warning('Deprecated function getMembershipTypesByOrg, please user membership_type api', array('civi.tag' => 'deprecated'));
 626     $memberTypesSameParentOrg = civicrm_api3('MembershipType', 'get', array(
 627       'member_of_contact_id' => $orgID,
 628       'options' => array(
 629         'limit' => 0,
 630       ),
 631     ));
 632     return CRM_Utils_Array::value('values', $memberTypesSameParentOrg, array());
 633   }
 634
 635   /**
 636    * Retrieve all Membership Types with Member of Contact id.
 637    *
 638    * @param array $membershipTypes
 639    *   array of membership type ids
 640    * @return array
 641    *   array of the details of membership types with Member of Contact id
 642    */
 643   public static function getMemberOfContactByMemTypes($membershipTypes) {
 644     $memTypeOrganizations = array();
 645     if (empty($membershipTypes)) {
 646       return $memTypeOrganizations;
 647     }
 648
 649     $result = CRM_Core_DAO::executeQuery("SELECT id, member_of_contact_id FROM civicrm_membership_type WHERE id IN (" . implode(',', $membershipTypes) . ")");
 650     while ($result->fetch()) {
 651       $memTypeOrganizations[$result->id] = $result->member_of_contact_id;
 652     }
 653
 654     return $memTypeOrganizations;
 655   }
 656
 657   /**
 658    * The function returns all the Organization for  all membershipTypes .
 659    *
 660    * @param int $membershipTypeId
 661    *
 662    * @return array
 663    */
 664   public static function getMembershipTypeOrganization($membershipTypeId = NULL) {
 665     $allMembershipTypes = array();
 666
 667     $membershipType = new CRM_Member_DAO_MembershipType();
 668
 669     if (isset($membershipTypeId)) {
 670       $membershipType->id = $membershipTypeId;
 671     }
 672     $membershipType->find();
 673
 674     while ($membershipType->fetch()) {
 675       $allMembershipTypes[$membershipType->id] = $membershipType->member_of_contact_id;
 676     }
 677     return $allMembershipTypes;
 678   }
 679
 680   /**
 681    * Function to retrieve organization and associated membership
 682    * types
 683    *
 684    * @return array
 685    *   arrays of organization and membership types
 686    *
 687    */
 688   public static function getMembershipTypeInfo() {
 689     if (!self::$_membershipTypeInfo) {
 690       $orgs = $types = array();
 691
 692       $query = 'SELECT memType.id, memType.name, memType.member_of_contact_id, c.sort_name
 693         FROM civicrm_membership_type memType INNER JOIN civicrm_contact c ON c.id = memType.member_of_contact_id
 694         WHERE memType.is_active = 1 ';
 695       $dao = CRM_Core_DAO::executeQuery($query);
 696       while ($dao->fetch()) {
 697         $orgs[$dao->member_of_contact_id] = $dao->sort_name;
 698         $types[$dao->member_of_contact_id][$dao->id] = $dao->name;
 699       }
 700
 701       self::$_membershipTypeInfo = array($orgs, $types);
 702     }
 703     return self::$_membershipTypeInfo;
 704   }
 705
 706
 707   /**
 708    * @param array $params
 709    * @param int $previousID
 710    * @param int $membershipTypeId
 711    */
 712   public static function createMembershipPriceField($params, $previousID, $membershipTypeId) {
 713
 714     $priceSetId = CRM_Core_DAO::getFieldValue('CRM_Price_DAO_PriceSet', 'default_membership_type_amount', 'id', 'name');
 715
 716     if (!empty($params['member_of_contact_id'])) {
 717       $fieldName = $params['member_of_contact_id'];
 718     }
 719     else {
 720       $fieldName = $previousID;
 721     }
 722     $fieldLabel = 'Membership Amount';
 723     $optionsIds = NULL;
 724     $fieldParams = array(
 725       'price_set_id ' => $priceSetId,
 726       'name' => $fieldName,
 727     );
 728     $results = array();
 729     CRM_Price_BAO_PriceField::retrieve($fieldParams, $results);
 730     if (empty($results)) {
 731       $fieldParams = array();
 732       $fieldParams['label'] = $fieldLabel;
 733       $fieldParams['name'] = $fieldName;
 734       $fieldParams['price_set_id'] = $priceSetId;
 735       $fieldParams['html_type'] = 'Radio';
 736       $fieldParams['is_display_amounts'] = $fieldParams['is_required'] = 0;
 737       $fieldParams['weight'] = $fieldParams['option_weight'][1] = 1;
 738       $fieldParams['option_label'][1] = $params['name'];
 739       $fieldParams['option_description'][1] = CRM_Utils_Array::value('description', $params);
 740
 741       $fieldParams['membership_type_id'][1] = $membershipTypeId;
 742       $fieldParams['option_amount'][1] = empty($params['minimum_fee']) ? 0 : $params['minimum_fee'];
 743       $fieldParams['financial_type_id'] = CRM_Utils_Array::value('financial_type_id', $params);
 744
 745       if ($previousID) {
 746         CRM_Member_Form_MembershipType::checkPreviousPriceField($previousID, $priceSetId, $membershipTypeId, $optionsIds);
 747         $fieldParams['option_id'] = CRM_Utils_Array::value('option_id', $optionsIds);
 748       }
 749       CRM_Price_BAO_PriceField::create($fieldParams);
 750     }
 751     else {
 752       $fieldID = $results['id'];
 753       $fieldValueParams = array(
 754         'price_field_id' => $fieldID,
 755         'membership_type_id' => $membershipTypeId,
 756       );
 757       $results = array();
 758       CRM_Price_BAO_PriceFieldValue::retrieve($fieldValueParams, $results);
 759       if (!empty($results)) {
 760         $results['label'] = $results['name'] = $params['name'];
 761         $results['amount'] = empty($params['minimum_fee']) ? 0 : $params['minimum_fee'];
 762         $optionsIds['id'] = $results['id'];
 763       }
 764       else {
 765         $results = array(
 766           'price_field_id' => $fieldID,
 767           'name' => $params['name'],
 768           'label' => $params['name'],
 769           'amount' => empty($params['minimum_fee']) ? 0 : $params['minimum_fee'],
 770           'membership_type_id' => $membershipTypeId,
 771           'is_active' => 1,
 772         );
 773       }
 774
 775       if ($previousID) {
 776         CRM_Member_Form_MembershipType::checkPreviousPriceField($previousID, $priceSetId, $membershipTypeId, $optionsIds);
 777         if (!empty($optionsIds['option_id'])) {
 778           $optionsIds['id'] = current(CRM_Utils_Array::value('option_id', $optionsIds));
 779         }
 780       }
 781       $results['financial_type_id'] = CRM_Utils_Array::value('financial_type_id', $params);
 782       $results['description'] = CRM_Utils_Array::value('description', $params);
 783       CRM_Price_BAO_PriceFieldValue::add($results, $optionsIds);
 784     }
 785   }
 786
 787   /**
 788    * This function updates all price field value for quick config
 789    * price set which has membership type
 790    *
 791    * @param int $membershipTypeId membership type id
 792    *
 793    * @param array $params
 794    */
 795   public static function updateAllPriceFieldValue($membershipTypeId, $params) {
 796     $updateFields = array();
 797     if (!empty($params['minimum_fee'])) {
 798       $amount = $params['minimum_fee'];
 799     }
 800     else {
 801       $amount = 0;
 802     }
 803
 804     $updateValues = array(
 805       2 => array('financial_type_id', 'financial_type_id', 'Integer'),
 806       3 => array('label', 'name', 'String'),
 807       4 => array('amount', 'minimum_fee', 'Float'),
 808       5 => array('description', 'description', 'String'),
 809     );
 810
 811     $queryParams = array(1 => array($membershipTypeId, 'Integer'));
 812     foreach ($updateValues as $key => $value) {
 813       if (array_key_exists($value[1], $params)) {
 814         $updateFields[] = "cpfv." . $value[0] . " = %$key";
 815         if ($value[1] == 'minimum_fee') {
 816           $fieldValue = $amount;
 817         }
 818         else {
 819           $fieldValue = $params[$value[1]];
 820         }
 821         $queryParams[$key] = array($fieldValue, $value[2]);
 822       }
 823     }
 824
 825     $query = "UPDATE `civicrm_price_field_value` cpfv
 826 INNER JOIN civicrm_price_field cpf on cpf.id = cpfv.price_field_id
 827 INNER JOIN civicrm_price_set cps on cps.id = cpf.price_set_id
 828 SET " . implode(' , ', $updateFields) . " WHERE cpfv.membership_type_id = %1
 829 AND cps.is_quick_config = 1 AND cps.name != 'default_membership_type_amount'";
 830     CRM_Core_DAO::executeQuery($query, $queryParams);
 831   }
 832
 833 }