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