CRM/Member/BAO/MembershipType.php

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