CRM/Member/BAO/MembershipType.php

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