copyValues($params); if ($optionGroup->find(TRUE)) { CRM_Core_DAO::storeValues($optionGroup, $defaults); return $optionGroup; } return NULL; } /** * Update the is_active flag in the db. * * @param int $id * Id of the database record. * @param bool $is_active * Value we want to set the is_active field. * * @return Object * DAO object on success, null otherwise */ public static function setIsActive($id, $is_active) { return CRM_Core_DAO::setFieldValue('CRM_Core_DAO_OptionGroup', $id, 'is_active', $is_active); } /** * Add the Option Group. * * @param array $params * Reference array contains the values submitted by the form. * @param array $ids * Reference array contains the id. * * * @return object */ public static function add(&$params, $ids = array()) { if (empty($params['id'])) { $params['id'] = CRM_Utils_Array::value('optionGroup', $ids); } $params['is_active'] = CRM_Utils_Array::value('is_active', $params, FALSE); $params['is_default'] = CRM_Utils_Array::value('is_default', $params, FALSE); // action is taken depending upon the mode $optionGroup = new CRM_Core_DAO_OptionGroup(); $optionGroup->copyValues($params);; if ($params['is_default']) { $query = "UPDATE civicrm_option_group SET is_default = 0"; CRM_Core_DAO::executeQuery($query); } $optionGroup->save(); return $optionGroup; } /** * Delete Option Group. * * @param int $optionGroupId * Id of the Option Group to be deleted. */ public static function del($optionGroupId) { // need to delete all option value field before deleting group $optionValue = new CRM_Core_DAO_OptionValue(); $optionValue->option_group_id = $optionGroupId; $optionValue->delete(); $optionGroup = new CRM_Core_DAO_OptionGroup(); $optionGroup->id = $optionGroupId; $optionGroup->delete(); } /** * Get title of the option group. * * @param int $optionGroupId * Id of the Option Group. * * @return string * title */ public static function getTitle($optionGroupId) { $optionGroup = new CRM_Core_DAO_OptionGroup(); $optionGroup->id = $optionGroupId; $optionGroup->find(TRUE); return $optionGroup->name; } /** * Get DataType for a specified option Group * * @param int $optionGroupId * Id of the Option Group. * * @return string|null * Data Type */ public static function getDataType($optionGroupId) { $optionGroup = new CRM_Core_DAO_OptionGroup(); $optionGroup->id = $optionGroupId; $optionGroup->find(TRUE); return $optionGroup->data_type; } /** * Ensure an option group exists. * * This function is intended to be called from the upgrade script to ensure * that an option group exists, without hitting an error if it already exists. * * This is sympathetic to sites who might pre-add it. * * @param array $params * * @return int * ID of the option group. */ public static function ensureOptionGroupExists($params) { $existingValues = civicrm_api3('OptionGroup', 'get', array( 'name' => $params['name'], )); if (!$existingValues['count']) { $result = civicrm_api3('OptionGroup', 'create', $params); return $result['id']; } else { return $existingValues['id']; } } }