3 +--------------------------------------------------------------------+
4 | CiviCRM version 4.4 |
5 +--------------------------------------------------------------------+
6 | Copyright CiviCRM LLC (c) 2004-2013 |
7 +--------------------------------------------------------------------+
8 | This file is a part of CiviCRM. |
10 | CiviCRM is free software; you can copy, modify, and distribute it |
11 | under the terms of the GNU Affero General Public License |
12 | Version 3, 19 November 2007 and the CiviCRM Licensing Exception. |
14 | CiviCRM is distributed in the hope that it will be useful, but |
15 | WITHOUT ANY WARRANTY; without even the implied warranty of |
16 | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. |
17 | See the GNU Affero General Public License for more details. |
19 | You should have received a copy of the GNU Affero General Public |
20 | License and the CiviCRM Licensing Exception along |
21 | with this program; if not, contact CiviCRM LLC |
22 | at info[AT]civicrm[DOT]org. If you have questions about the |
23 | GNU Affero General Public License or the licensing of CiviCRM, |
24 | see the CiviCRM license FAQ at http://civicrm.org/licensing |
25 +--------------------------------------------------------------------+
31 * @copyright CiviCRM LLC (c) 2004-2013
35 class CRM_Core_BAO_OptionValue
extends CRM_Core_DAO_OptionValue
{
40 function __construct() {
41 parent
::__construct();
44 * Create option value - note that the create function calls 'add' but
45 * has more business logic
47 * @param array $params input parameters
49 static function create($params) {
50 if (empty($params['id'])){
51 self
::setDefaults($params);
54 if (CRM_Utils_Array
::value('id', $params)) {
55 $ids = array('optionValue' => $params['id']);
57 return CRM_Core_BAO_OptionValue
::add($params, $ids);
61 * Set default Parameters
62 * This functions sets default parameters if not set:
63 * - name & label are set to each other as required (it might make more sense for one
64 * to be required but this would mean a change to the api level)
65 * - weight & value will be set to their respective option groups next values
66 * if nothing is passed in.
68 * Note this function does not check for presence of $params['id'] so should only be called
69 * if 'id' is not present
71 * @param array $params
73 static function setDefaults(&$params){
74 if(CRM_Utils_Array
::value('label', $params, NULL) === NULL){
75 $params['label'] = $params['name'];
77 if(CRM_Utils_Array
::value('name', $params, NULL) === NULL){
78 $params['name'] = $params['label'];
80 if(CRM_Utils_Array
::value('weight', $params, NULL) === NULL){
81 $params['weight'] = self
::getDefaultWeight($params);
83 if (CRM_Utils_Array
::value('value', $params, NULL) === NULL){
84 $params['value'] = self
::getDefaultValue($params);
88 * Get next available value
89 * We will take the highest numeric value (or 0 if no numeric values exist)
90 * and add one. The calling function is responsible for any
91 * more complex decision making
92 * @param array $params
94 static function getDefaultWeight($params){
95 return (int) CRM_Utils_Weight
::getDefaultWeight('CRM_Core_DAO_OptionValue',
96 array('option_group_id' => $params['option_group_id']));
100 * Get next available value
101 * We will take the highest numeric value (or 0 if no numeric values exist)
102 * and add one. The calling function is responsible for any
103 * more complex decision making
104 * @param array $params
106 static function getDefaultValue($params){
107 $bao = new CRM_Core_BAO_OptionValue();
108 $bao->option_group_id
= $params['option_group_id'];
109 if(isset($params['domain_id'])){
110 $bao->domain_id
= $params['domain_id'];
113 $bao->whereAdd("value REGEXP '^[0-9]+$'");
114 $bao->selectAdd('(ROUND(COALESCE(MAX(CONVERT(value, UNSIGNED)),0)) +1) as nextvalue');
116 return $bao->nextvalue
;
119 * Takes a bunch of params that are needed to match certain criteria and
120 * retrieves the relevant objects. Typically the valid params are only
121 * contact_id. We'll tweak this function to be more full featured over a period
122 * of time. This is the inverse function of create. It also stores all the retrieved
123 * values in the default array
125 * @param array $params (reference ) an assoc array of name/value pairs
126 * @param array $defaults (reference ) an assoc array to hold the flattened values
128 * @return object CRM_Core_BAO_OptionValue object
132 static function retrieve(&$params, &$defaults) {
133 $optionValue = new CRM_Core_DAO_OptionValue();
134 $optionValue->copyValues($params);
135 if ($optionValue->find(TRUE)) {
136 CRM_Core_DAO
::storeValues($optionValue, $defaults);
143 * update the is_active flag in the db
145 * @param int $id id of the database record
146 * @param boolean $is_active value we want to set the is_active field
148 * @return Object DAO object on sucess, null otherwise
151 static function setIsActive($id, $is_active) {
152 return CRM_Core_DAO
::setFieldValue('CRM_Core_DAO_OptionValue', $id, 'is_active', $is_active);
156 * Function to add an Option Value
158 * @param array $params reference array contains the values submitted by the form
159 * @param array $ids reference array contains the id
166 static function add(&$params, &$ids) {
167 // CRM-10921: do not reset attributes to default if this is an update
168 //@todo consider if defaults are being set in the right place. 'dumb' defaults like
169 // these would be usefully set @ the api layer so they are visible to api users
170 // complex defaults like the domain id below would make sense in the setDefauls function
171 // but unclear what other ways this function is being used
172 if (!CRM_Utils_Array
::value('optionValue', $ids)) {
173 $params['is_active'] = CRM_Utils_Array
::value('is_active', $params, FALSE);
174 $params['is_default'] = CRM_Utils_Array
::value('is_default', $params, FALSE);
175 $params['is_optgroup'] = CRM_Utils_Array
::value('is_optgroup', $params, FALSE);
176 $params['filter'] = CRM_Utils_Array
::value('filter', $params, FALSE);
179 // action is taken depending upon the mode
180 $optionValue = new CRM_Core_DAO_OptionValue();
181 $optionValue->copyValues($params);
183 if (CRM_Utils_Array
::value('is_default', $params)) {
184 $query = 'UPDATE civicrm_option_value SET is_default = 0 WHERE option_group_id = %1';
186 // tweak default reset, and allow multiple default within group.
187 if ($resetDefaultFor = CRM_Utils_Array
::value('reset_default_for', $params)) {
188 if (is_array($resetDefaultFor)) {
189 $colName = key($resetDefaultFor);
190 $colVal = $resetDefaultFor[$colName];
191 $query .= " AND ( $colName IN ( $colVal ) )";
195 $p = array(1 => array($params['option_group_id'], 'Integer'));
196 CRM_Core_DAO
::executeQuery($query, $p);
199 // CRM-13814 : evalute option group id
200 if (!array_key_exists('option_group_id', $params) && !empty($ids['optionValue'])) {
201 $groupId = CRM_Core_DAO
::getFieldValue('CRM_Core_DAO_OptionValue',
202 $ids['optionValue'], 'option_group_id', 'id'
206 $groupId = $params['option_group_id'];
209 $groupName = CRM_Core_DAO
::getFieldValue('CRM_Core_DAO_OptionGroup',
210 $groupId, 'name', 'id'
212 if (in_array($groupName, CRM_Core_OptionGroup
::$_domainIDGroups)) {
213 $optionValue->domain_id
= CRM_Utils_Array
::value('domain_id', $params, CRM_Core_Config
::domainID());
216 $optionValue->id
= CRM_Utils_Array
::value('optionValue', $ids);
217 $optionValue->save();
218 CRM_Core_PseudoConstant
::flush();
223 * Function to delete Option Value
225 * @param int $optionGroupId Id of the Option Group to be deleted.
232 static function del($optionValueId) {
233 $optionValue = new CRM_Core_DAO_OptionValue();
234 $optionValue->id
= $optionValueId;
235 if (self
::updateRecords($optionValueId, CRM_Core_Action
::DELETE
)) {
236 CRM_Core_PseudoConstant
::flush();
237 return $optionValue->delete();
243 * Function to retrieve activity type label and description
245 * @param int $activityTypeId activity type id
247 * @return array label and description
251 static function getActivityTypeDetails($activityTypeId) {
252 $query = "SELECT civicrm_option_value.label, civicrm_option_value.description
253 FROM civicrm_option_value
254 LEFT JOIN civicrm_option_group ON ( civicrm_option_value.option_group_id = civicrm_option_group.id )
255 WHERE civicrm_option_group.name = 'activity_type'
256 AND civicrm_option_value.value = {$activityTypeId} ";
258 $dao = CRM_Core_DAO
::executeQuery($query);
262 return array($dao->label
, $dao->description
);
266 * Get the Option Value title.
268 * @param int $id id of Option Value
270 * @return string title
276 public static function getTitle($id) {
277 return CRM_Core_DAO
::getFieldValue('CRM_Core_DAO_OptionValue', $id, 'label');
281 * updates contacts affected by the option value passed.
283 * @param Integer $optionValueId the option value id.
284 * @param int $action the action describing whether prefix/suffix was UPDATED or DELETED
288 static function updateRecords(&$optionValueId, $action) {
290 $optionValue = new CRM_Core_DAO_OptionValue();
291 $optionValue->id
= $optionValueId;
292 $optionValue->find(TRUE);
294 $optionGroup = new CRM_Core_DAO_OptionGroup();
295 $optionGroup->id
= $optionValue->option_group_id
;
296 $optionGroup->find(TRUE);
299 $gName = $optionGroup->name
;
301 $value = $optionValue->value
;
303 // get the proper group name & affected field name
304 // todo: this may no longer be needed for individuals - check inputs
305 $individuals = array(
306 'gender' => 'gender_id',
307 'individual_prefix' => 'prefix_id',
308 'individual_suffix' => 'suffix_id',
310 $contributions = array('payment_instrument' => 'payment_instrument_id');
311 $activities = array('activity_type' => 'activity_type_id');
312 $participant = array('participant_role' => 'role_id');
313 $eventType = array('event_type' => 'event_type_id');
314 $aclRole = array('acl_role' => 'acl_role_id');
316 $all = array_merge($individuals, $contributions, $activities, $participant, $eventType, $aclRole);
319 foreach ($all as $name => $id) {
320 if ($gName == $name) {
324 if ($fieldName == '') {
328 if (array_key_exists($gName, $individuals)) {
329 $contactDAO = new CRM_Contact_DAO_Contact();
331 $contactDAO->$fieldName = $value;
334 while ($contactDAO->fetch()) {
335 if ($action == CRM_Core_Action
::DELETE
) {
336 $contact = new CRM_Contact_DAO_Contact();
337 $contact->id
= $contactDAO->id
;
338 $contact->find(TRUE);
340 // make sure dates doesn't get reset
341 $contact->birth_date
= CRM_Utils_Date
::isoToMysql($contact->birth_date
);
342 $contact->deceased_date
= CRM_Utils_Date
::isoToMysql($contact->deceased_date
);
343 $contact->$fieldName = 'NULL';
351 if (array_key_exists($gName, $contributions)) {
352 $contribution = new CRM_Contribute_DAO_Contribution();
353 $contribution->$fieldName = $value;
354 $contribution->find();
355 while ($contribution->fetch()) {
356 if ($action == CRM_Core_Action
::DELETE
) {
357 $contribution->$fieldName = 'NULL';
358 $contribution->save();
364 if (array_key_exists($gName, $activities)) {
365 $activity = new CRM_Activity_DAO_Activity();
366 $activity->$fieldName = $value;
368 while ($activity->fetch()) {
374 //delete participant role, type and event type option value
375 if (array_key_exists($gName, $participant)) {
376 $participantValue = new CRM_Event_DAO_Participant();
377 $participantValue->$fieldName = $value;
378 if ($participantValue->find(TRUE)) {
384 //delete event type option value
385 if (array_key_exists($gName, $eventType)) {
386 $event = new CRM_Event_DAO_Event();
387 $event->$fieldName = $value;
388 if ($event->find(TRUE)) {
394 //delete acl_role option value
395 if (array_key_exists($gName, $aclRole)) {
396 $entityRole = new CRM_ACL_DAO_EntityRole();
397 $entityRole->$fieldName = $value;
399 $aclDAO = new CRM_ACL_DAO_ACL();
400 $aclDAO->entity_id
= $value;
401 if ($entityRole->find(TRUE) ||
$aclDAO->find(TRUE)) {
409 * updates options values weights.
411 * @param int $opGroupIde option group id.
412 * @param array $opWeights options value , weight pair
418 static function updateOptionWeights($opGroupId, $opWeights) {
419 if (!is_array($opWeights) ||
empty($opWeights)) {
423 foreach ($opWeights as $opValue => $opWeight) {
424 $optionValue = new CRM_Core_DAO_OptionValue();
425 $optionValue->option_group_id
= $opGroupId;
426 $optionValue->value
= $opValue;
427 if ($optionValue->find(TRUE)) {
428 $optionValue->weight
= $opWeight;
429 $optionValue->save();
431 $optionValue->free();
436 * Get the values of all option values given an option group ID. Store in system cache
437 * Does not take any filtering arguments. The object is to avoid hitting the DB and retrieve
440 * @param int $optionGroupID the option group for which we want the values from
442 * @return array an array of array of values for this option group
446 static function getOptionValuesArray($optionGroupID) {
447 // check if we can get the field values from the system cache
448 $cacheKey = "CRM_Core_BAO_OptionValue_OptionGroupID_{$optionGroupID}";
449 $cache = CRM_Utils_Cache
::singleton();
450 $optionValues = $cache->get($cacheKey);
451 if (empty($optionValues)) {
452 $dao = new CRM_Core_DAO_OptionValue();
453 $dao->option_group_id
= $optionGroupID;
454 $dao->orderBy('weight ASC, label ASC');
457 $optionValues = array();
458 while ($dao->fetch()) {
459 $optionValues[$dao->id
] = array();
460 CRM_Core_DAO
::storeValues($dao, $optionValues[$dao->id
]);
463 $cache->set($cacheKey, $optionValues);
466 return $optionValues;
470 * Get the values of all option values given an option group ID as a key => value pair
471 * Use above cached function to make it super efficient
473 * @param int $optionGroupID the option group for which we want the values from
475 * @return array an associative array of label, value pairs
479 static function getOptionValuesAssocArray($optionGroupID) {
480 $optionValues = self
::getOptionValuesArray($optionGroupID);
483 foreach ($optionValues as $id => $value) {
484 $options[$value['value']] = $value['label'];
489 * Get the values of all option values given an option group Name as a key => value pair
490 * Use above cached function to make it super efficient
492 * @param string $optionGroupName the option group name for which we want the values from
494 * @return array an associative array of label, value pairs
498 static function getOptionValuesAssocArrayFromName($optionGroupName) {
499 $dao = new CRM_Core_DAO_OptionGroup();
500 $dao->name
= $optionGroupName;
502 $dao->selectAdd('id');
504 $optionValues = self
::getOptionValuesArray($dao->id
);
507 foreach ($optionValues as $id => $value) {
508 $options[$value['value']] = $value['label'];