PHP CRM_Core_OptionGroup::deleteAssoc方法代码示例

 /**
  * Process the form when submitted
  *
  * @return void
  * @access public
  */
 public function postProcess()
 {
     require_once 'CRM/Core/Transaction.php';
     $transaction = new CRM_Core_Transaction();
     // first delete the join entries associated with this contribution page
     require_once 'CRM/Core/DAO/UFJoin.php';
     $dao = new CRM_Core_DAO_UFJoin();
     $params = array('entity_table' => 'civicrm_contribution_page', 'entity_id' => $this->_id);
     $dao->copyValues($params);
     $dao->delete();
     require_once 'CRM/Core/OptionGroup.php';
     $groupName = "civicrm_contribution_page.amount.{$this->_id}";
     CRM_Core_OptionGroup::deleteAssoc($groupName);
     //next delete the membership block fields
     require_once 'CRM/Member/DAO/MembershipBlock.php';
     $dao = new CRM_Member_DAO_MembershipBlock();
     $dao->entity_table = 'civicrm_contribution_page';
     $dao->entity_id = $this->_id;
     $dao->delete();
     //next delete the pcp block fields
     require_once 'CRM/Contribute/DAO/PCPBlock.php';
     $dao = new CRM_Contribute_DAO_PCPBlock();
     $dao->entity_table = 'civicrm_contribution_page';
     $dao->entity_id = $this->_id;
     $dao->delete();
     // need to delete premiums. CRM-4586
     require_once 'CRM/Contribute/BAO/Premium.php';
     CRM_Contribute_BAO_Premium::deletePremium($this->_id);
     // price set cleanup, CRM-5527
     require_once 'CRM/Price/BAO/Set.php';
     CRM_Price_BAO_Set::removeFrom('civicrm_contribution_page', $this->_id);
     // finally delete the contribution page
     require_once 'CRM/Contribute/DAO/ContributionPage.php';
     $dao = new CRM_Contribute_DAO_ContributionPage();
     $dao->id = $this->_id;
     $dao->delete();
     $transaction->commit();
     CRM_Core_Session::setStatus(ts('The contribution page \'%1\' has been deleted.', array(1 => $this->_title)));
 }

//.........这里部分代码省略.........
     if (CRM_Utils_Array::value('payment_processor_id', $params) == CRM_Core_DAO::getFieldValue('CRM_Core_DAO_PaymentProcessor', 'AuthNet', 'id', 'payment_processor_type')) {
         CRM_Core_Session::setStatus(ts(' Please note that the Authorize.net payment processor only allows recurring contributions and auto-renew memberships with payment intervals from 7-365 days or 1-12 months (i.e. not greater than 1 year).'));
     }
     // check for price set.
     $priceSetID = CRM_Utils_Array::value('price_set_id', $params);
     // get required fields.
     $fields = array('id' => $this->_id, 'is_recur' => false, 'min_amount' => "null", 'max_amount' => "null", 'is_monetary' => false, 'is_pay_later' => false, 'is_recur_interval' => false, 'recur_frequency_unit' => "null", 'default_amount_id' => "null", 'is_allow_other_amount' => false, 'amount_block_is_active' => false);
     $resetFields = array();
     if ($priceSetID) {
         $resetFields = array('min_amount', 'max_amount', 'is_allow_other_amount');
     }
     if (!CRM_Utils_Array::value('is_recur', $params)) {
         $resetFields = array_merge($resetFields, array('is_recur_interval', 'recur_frequency_unit'));
     }
     foreach ($fields as $field => $defaultVal) {
         $val = CRM_Utils_Array::value($field, $params, $defaultVal);
         if (in_array($field, $resetFields)) {
             $val = $defaultVal;
         }
         if (in_array($field, array('min_amount', 'max_amount'))) {
             $val = CRM_Utils_Rule::cleanMoney($val);
         }
         $params[$field] = $val;
     }
     if ($params['is_recur']) {
         require_once 'CRM/Core/BAO/CustomOption.php';
         $params['recur_frequency_unit'] = implode(CRM_Core_BAO_CustomOption::VALUE_SEPERATOR, array_keys($params['recur_frequency_unit']));
         $params['is_recur_interval'] = CRM_Utils_Array::value('is_recur_interval', $params, false);
     }
     require_once 'CRM/Contribute/BAO/ContributionPage.php';
     $contributionPage = CRM_Contribute_BAO_ContributionPage::create($params);
     $contributionPageID = $contributionPage->id;
     // prepare for data cleanup.
     $deleteAmountBlk = $deletePledgeBlk = $deletePriceSet = false;
     if ($this->_priceSetID) {
         $deletePriceSet = true;
     }
     if ($this->_pledgeBlockID) {
         $deletePledgeBlk = true;
     }
     if (!empty($this->_amountBlock)) {
         $deleteAmountBlk = true;
     }
     if ($contributionPageID) {
         require_once 'CRM/Price/BAO/Set.php';
         require_once 'CRM/Core/OptionGroup.php';
         require_once 'CRM/Pledge/BAO/PledgeBlock.php';
         if (CRM_Utils_Array::value('amount_block_is_active', $params)) {
             // handle price set.
             if ($priceSetID) {
                 // add/update price set.
                 $deletePriceSet = false;
                 CRM_Price_BAO_Set::addTo('civicrm_contribution_page', $contributionPageID, $priceSetID);
             } else {
                 // process contribution amount block
                 $deleteAmountBlk = false;
                 $labels = CRM_Utils_Array::value('label', $params);
                 $values = CRM_Utils_Array::value('value', $params);
                 $default = CRM_Utils_Array::value('default', $params);
                 $options = array();
                 for ($i = 1; $i < self::NUM_OPTION; $i++) {
                     if (isset($values[$i]) && strlen(trim($values[$i])) > 0) {
                         $options[] = array('label' => trim($labels[$i]), 'value' => CRM_Utils_Rule::cleanMoney(trim($values[$i])), 'weight' => $i, 'is_active' => 1, 'is_default' => $default == $i);
                     }
                 }
                 CRM_Core_OptionGroup::createAssoc("civicrm_contribution_page.amount.{$contributionPageID}", $options, $params['default_amount_id']);
                 if ($params['default_amount_id']) {
                     CRM_Core_DAO::setFieldValue('CRM_Contribute_DAO_ContributionPage', $contributionPageID, 'default_amount_id', $params['default_amount_id']);
                 }
                 if (CRM_Utils_Array::value('is_pledge_active', $params)) {
                     $deletePledgeBlk = false;
                     $pledgeBlockParams = array('entity_id' => $contributionPageID, 'entity_table' => ts('civicrm_contribution_page'));
                     if ($this->_pledgeBlockID) {
                         $pledgeBlockParams['id'] = $this->_pledgeBlockID;
                     }
                     $pledgeBlock = array('pledge_frequency_unit', 'max_reminders', 'initial_reminder_day', 'additional_reminder_day');
                     foreach ($pledgeBlock as $key) {
                         $pledgeBlockParams[$key] = CRM_Utils_Array::value($key, $params);
                     }
                     $pledgeBlockParams['is_pledge_interval'] = CRM_Utils_Array::value('is_pledge_interval', $params, false);
                     // create pledge block.
                     require_once 'CRM/Pledge/BAO/PledgeBlock.php';
                     CRM_Pledge_BAO_PledgeBlock::create($pledgeBlockParams);
                 }
             }
         }
         // delete pledge block.
         if ($deletePledgeBlk) {
             CRM_Pledge_BAO_PledgeBlock::deletePledgeBlock($this->_pledgeBlockID);
         }
         // delete previous price set.
         if ($deletePriceSet) {
             CRM_Price_BAO_Set::removeFrom('civicrm_contribution_page', $contributionPageID);
         }
         // delete amount block.
         if ($deleteAmountBlk) {
             CRM_Core_OptionGroup::deleteAssoc("civicrm_contribution_page.amount.{$contributionPageID}");
         }
     }
 }

 /**
  * (Queue Task Callback)
  *
  * Upgrade code to create priceset for contribution pages and events
  */
 public static function task_4_2_alpha1_createPriceSets(CRM_Queue_TaskContext $ctx, $rev)
 {
     $upgrade = new CRM_Upgrade_Form();
     $daoName = array('civicrm_contribution_page' => array('CRM_Contribute_BAO_ContributionPage', CRM_Core_Component::getComponentID('CiviContribute')), 'civicrm_event' => array('CRM_Event_BAO_Event', CRM_Core_Component::getComponentID('CiviEvent')));
     // get all option group used for event and contribution page
     $query = "\nSELECT id, name\nFROM   civicrm_option_group\nWHERE  name LIKE '%.amount.%' ";
     $dao = CRM_Core_DAO::executeQuery($query);
     while ($dao->fetch()) {
         $addTo = explode('.', $dao->name);
         if (!empty($addTo[2])) {
             $options = array('optionGroup' => $dao->name);
             self::createPriceSet($daoName, $addTo, $options);
         }
         CRM_Core_OptionGroup::deleteAssoc($dao->name);
     }
     //create pricesets for contribution with only other amount
     $query = "\nSELECT    ccp.id as contribution_page_id, ccp.is_allow_other_amount, cmb.id as membership_block_id\nFROM      civicrm_contribution_page ccp\nLEFT JOIN civicrm_membership_block cmb ON  cmb.entity_id = ccp.id AND cmb.entity_table = 'civicrm_contribution_page'\nLEFT JOIN civicrm_price_set_entity cpse ON cpse.entity_id = ccp.id and cpse.entity_table = 'civicrm_contribution_page'\nWHERE     cpse.price_set_id IS NULL";
     $dao = CRM_Core_DAO::executeQuery($query);
     $addTo = array('civicrm_contribution_page');
     while ($dao->fetch()) {
         $addTo[2] = $dao->contribution_page_id;
         $options = array('otherAmount' => $dao->is_allow_other_amount, 'membership' => $dao->membership_block_id);
         self::createPriceSet($daoName, $addTo, $options);
     }
     return TRUE;
 }

 /**
  * Function to delete the event
  *
  * @param int $id  event id
  *
  * @access public
  * @static
  *
  */
 static function del($id)
 {
     if (!$id) {
         return null;
     }
     require_once 'CRM/Utils/Hook.php';
     CRM_Utils_Hook::pre('delete', 'Event', $id, CRM_Core_DAO::$_nullArray);
     require_once 'CRM/Core/BAO/CustomGroup.php';
     $extends = array('event');
     $groupTree = CRM_Core_BAO_CustomGroup::getGroupDetail(null, null, $extends);
     foreach ($groupTree as $values) {
         $query = "DELETE FROM " . $values['table_name'] . " WHERE entity_id = " . $id;
         $params = array(1 => array($values['table_name'], 'string'), 2 => array($id, 'integer'));
         CRM_Core_DAO::executeQuery($query, CRM_Core_DAO::$_nullArray);
     }
     $dependencies = array('CRM_Core_DAO_OptionGroup' => array('name' => 'civicrm_event.amount.' . $id), 'CRM_Core_DAO_UFJoin' => array('entity_id' => $id, 'entity_table' => 'civicrm_event'));
     require_once 'CRM/Core/BAO/OptionGroup.php';
     foreach ($dependencies as $daoName => $values) {
         require_once str_replace('_', DIRECTORY_SEPARATOR, $daoName) . ".php";
         eval('$dao = new ' . $daoName . '( );');
         if ($daoName == 'CRM_Core_DAO_OptionGroup') {
             $dao->name = $values['name'];
             $dao->find();
             while ($dao->fetch()) {
                 CRM_Core_BAO_OptionGroup::del($dao->id);
             }
         } else {
             foreach ($values as $fieldName => $fieldValue) {
                 $dao->{$fieldName} = $fieldValue;
             }
             $dao->find();
             while ($dao->fetch()) {
                 $dao->delete();
             }
         }
     }
     require_once 'CRM/Core/OptionGroup.php';
     CRM_Core_OptionGroup::deleteAssoc("civicrm_event.amount.{$id}.discount.%", "LIKE");
     // price set cleanup, CRM-5527
     require_once 'CRM/Price/BAO/Set.php';
     CRM_Price_BAO_Set::removeFrom('civicrm_event', $id);
     require_once 'CRM/Event/DAO/Event.php';
     $event = new CRM_Event_DAO_Event();
     $event->id = $id;
     if ($event->find(true)) {
         $locBlockId = $event->loc_block_id;
         $result = $event->delete();
         if (!is_null($locBlockId)) {
             self::deleteEventLocBlock($locBlockId, $id);
         }
         CRM_Utils_Hook::post('delete', 'Event', $id, $event);
         return $result;
     }
     return null;
 }

 /**
  * @param $rev
  */
 public function upgrade_4_1_beta1($rev)
 {
     //CRM-9311
     $groupNames = array('directory_preferences', 'url_preferences');
     foreach ($groupNames as $groupName) {
         CRM_Core_OptionGroup::deleteAssoc($groupName);
     }
     $domainCols = array(CRM_Core_BAO_Setting::SYSTEM_PREFERENCES_NAME => array('contact_ajax_check_similar', 'activity_assignee_notification'), CRM_Core_BAO_Setting::CAMPAIGN_PREFERENCES_NAME => array('tag_unconfirmed', 'petition_contacts'), CRM_Core_BAO_Setting::EVENT_PREFERENCES_NAME => array('enable_cart'), CRM_Core_BAO_Setting::MAILING_PREFERENCES_NAME => array('profile_double_optin', 'profile_add_to_group_double_optin', 'track_civimail_replies', 'civimail_workflow', 'civimail_server_wide_lock'), CRM_Core_BAO_Setting::MEMBER_PREFERENCES_NAME => array('default_renewal_contribution_page'), CRM_Core_BAO_Setting::MULTISITE_PREFERENCES_NAME => array('is_enabled', 'uniq_email_per_site', 'domain_group_id', 'event_price_set_domain_id'), CRM_Core_BAO_Setting::DIRECTORY_PREFERENCES_NAME => array('uploadDir', 'imageUploadDir', 'customFileUploadDir', 'customTemplateDir', 'customPHPPathDir', 'extensionsDir'), CRM_Core_BAO_Setting::URL_PREFERENCES_NAME => array('userFrameworkResourceURL', 'imageUploadURL', 'customCSSURL'));
     $arrGroupNames = array_keys($domainCols);
     $groupNames = implode("','", $arrGroupNames);
     $arrNames = array();
     foreach ($domainCols as $groupName => $names) {
         $arrNames[] = implode("','", $names);
     }
     $name = implode("','", $arrNames);
     $sql = "\n        update civicrm_setting set is_domain = 1 where is_domain = 0 and group_name in ( '{$groupNames}' ) and name in ('{$name}')";
     CRM_Core_DAO::executeQuery($sql);
     $upgrade = new CRM_Upgrade_Form();
     $upgrade->assign('addWightForActivity', !CRM_Core_DAO::checkFieldExists('civicrm_activity', 'weight'));
     $upgrade->processSQL($rev);
 }

 /**
  * Process the form
  *
  * @return void
  * @access public
  */
 public function postProcess()
 {
     $params = array();
     $params = $this->exportValues();
     $this->set('discountSection', 0);
     if (CRM_Utils_Array::value('_qf_Fee_submit', $_POST)) {
         $this->buildAmountLabel();
         $this->set('discountSection', 1);
         CRM_Utils_System::redirect(CRM_Utils_System::url('civicrm/event/manage', '#isDiscount'));
         return;
     }
     $params['is_pay_later'] = CRM_Utils_Array::value('is_pay_later', $params, 0);
     if ($this->_id) {
         require_once 'CRM/Price/BAO/Set.php';
         // delete all the prior label values or discounts in the custom options table
         // and delete a price set if one exists
         if (!CRM_Price_BAO_Set::removeFrom('civicrm_event', $this->_id)) {
             require_once 'CRM/Core/OptionGroup.php';
             CRM_Core_OptionGroup::deleteAssoc("civicrm_event.amount.{$this->_id}");
             CRM_Core_OptionGroup::deleteAssoc("civicrm_event.amount.{$this->_id}.discount.%", "LIKE");
         }
     }
     if ($params['is_monetary']) {
         if ($params['price_set_id']) {
             CRM_Price_BAO_Set::addTo('civicrm_event', $this->_id, $params['price_set_id']);
         } else {
             // if there are label / values, create custom options for them
             $labels = CRM_Utils_Array::value('label', $params);
             $values = CRM_Utils_Array::value('value', $params);
             $default = CRM_Utils_Array::value('default', $params);
             $options = array();
             if (!CRM_Utils_System::isNull($labels) && !CRM_Utils_System::isNull($values)) {
                 for ($i = 1; $i < self::NUM_OPTION; $i++) {
                     if (!empty($labels[$i]) && !CRM_Utils_System::isNull($values[$i])) {
                         $options[] = array('label' => trim($labels[$i]), 'value' => CRM_Utils_Rule::cleanMoney(trim($values[$i])), 'weight' => $i, 'is_active' => 1, 'is_default' => $default == $i);
                     }
                 }
                 if (!empty($options)) {
                     $params['default_fee_id'] = null;
                     CRM_Core_OptionGroup::createAssoc("civicrm_event.amount.{$this->_id}", $options, $params['default_fee_id']);
                 }
             }
             if (CRM_Utils_Array::value('is_discount', $params) == 1) {
                 // if there are discounted set of label / values,
                 // create custom options for them
                 $labels = CRM_Utils_Array::value('discounted_label', $params);
                 $values = CRM_Utils_Array::value('discounted_value', $params);
                 $default = CRM_Utils_Array::value('discounted_default', $params);
                 if (!CRM_Utils_System::isNull($labels) && !CRM_Utils_System::isNull($values)) {
                     for ($j = 1; $j <= self::NUM_DISCOUNT; $j++) {
                         $discountOptions = array();
                         for ($i = 1; $i < self::NUM_OPTION; $i++) {
                             if (!empty($labels[$i]) && CRM_Utils_Array::value($j, $values[$i])) {
                                 $discountOptions[] = array('label' => trim($labels[$i]), 'value' => CRM_Utils_Rule::cleanMoney(trim($values[$i][$j])), 'weight' => $i, 'is_active' => 1, 'is_default' => $default == $i);
                             }
                         }
                         if (!empty($discountOptions)) {
                             $params['default_discount_fee_id'] = null;
                             $discountOptionsGroupId = CRM_Core_OptionGroup::createAssoc("civicrm_event.amount.{$this->_id}.discount.{$params['discount_name'][$j]}", $discountOptions, $params['default_discount_fee_id'], $params['discount_name'][$j]);
                             $discountParams = array('entity_table' => 'civicrm_event', 'entity_id' => $this->_id, 'option_group_id' => $discountOptionsGroupId, 'start_date' => CRM_Utils_Date::format($params["discount_start_date"][$j]), 'end_date' => CRM_Utils_Date::format($params["discount_end_date"][$j]));
                             require_once 'CRM/Core/BAO/Discount.php';
                             CRM_Core_BAO_Discount::add($discountParams);
                         }
                     }
                 }
             }
         }
     } else {
         $params['contribution_type_id'] = '';
     }
     //update events table
     require_once 'CRM/Event/BAO/Event.php';
     $params['id'] = $this->_id;
     CRM_Event_BAO_Event::add($params);
     parent::endPostProcess();
 }

 /**
  * Delete the price set field.
  *
  * @param   int   $id    Field Id 
  * 
  * @return  boolean
  *
  * @access public
  * @static
  *
  */
 public static function deleteField($id)
 {
     $field =& new CRM_Price_DAO_Field();
     $field->id = $id;
     if ($field->find(true)) {
         // delete the options for this field
         require_once 'CRM/Core/OptionGroup.php';
         CRM_Core_OptionGroup::deleteAssoc("civicrm_price_field.amount.{$id}");
         // reorder the weight before delete
         $fieldValues = array('price_set_id' => $field->price_set_id);
         require_once 'CRM/Utils/Weight.php';
         CRM_Utils_Weight::delWeight('CRM_Price_DAO_Field', $field->id, $fieldValues);
         // now delete the field
         return $field->delete();
     }
     return null;
 }

 public function upgrade_1108()
 {
     $this->ctx->log->info('Applying update 1108');
     if (CRM_Core_DAO::checkFieldExists('civicrm_hrjob_health', 'provider') && CRM_Core_DAO::checkFieldExists('civicrm_hrjob_health', 'provider_life_insurance')) {
         $opt_grp_name = array('hrjob_health_provider' => array('name' => 'Health_Insurance_Provider', 'label' => ts('Health Insurance Provider'), 'column' => 'provider'), 'hrjob_life_provider' => array('name' => 'Life_Insurance_Provider', 'label' => ts('Life Insurance Provider'), 'column' => 'provider_life_insurance'));
         $org_id = array_search('Organization', CRM_Contact_BAO_ContactType::basicTypePairs(FALSE, 'id'));
         $orgSubType = CRM_Contact_BAO_ContactType::subTypeInfo('Organization');
         foreach ($opt_grp_name as $oKey => $oValue) {
             $subID = array_key_exists($oValue['name'], $orgSubType);
             if (!$subID) {
                 CRM_Contact_BAO_ContactType::add(array('parent_id' => $org_id, 'is_active' => 1, 'name' => $oValue['name'], 'label' => $oValue['label']));
             }
             $options = CRM_Core_OptionGroup::values($oKey, TRUE, FALSE);
             foreach ($options as $orgKey => $orgValue) {
                 $params = array('organization_name' => $orgValue, 'sort_name' => $orgValue, 'display_name' => $orgValue, 'legal_name' => $orgValue, 'contact_type' => 'Organization', 'contact_sub_type' => $oValue['name']);
                 $result = civicrm_api3('contact', 'create', $params);
                 if ($result['id']) {
                     CRM_Core_DAO::executeQuery("UPDATE civicrm_hrjob_health SET {$oValue['column']} = {$result['id']} WHERE {$oValue['column']} LIKE '{$orgValue}'");
                     CRM_Core_DAO::executeQuery("UPDATE civicrm_hrjob_health SET {$oValue['column']} = NULL WHERE {$oValue['column']} = ''");
                 }
             }
             CRM_Core_OptionGroup::deleteAssoc($oKey);
         }
         CRM_Core_DAO::executeQuery("ALTER TABLE `civicrm_hrjob_health`\n        MODIFY COLUMN `provider` int(10) unsigned DEFAULT NULL,\n        MODIFY COLUMN `provider_life_insurance` int(10) unsigned DEFAULT NULL,\n        ADD CONSTRAINT `FK_civicrm_hrjob_health_provider` FOREIGN KEY (`provider`)  REFERENCES `civicrm_contact`(`id`) ON DELETE SET NULL,\n        ADD CONSTRAINT `FK_civicrm_hrjob_health_provider_life_insurance` FOREIGN KEY (`provider_life_insurance`)  REFERENCES `civicrm_contact`(`id`) ON DELETE SET NULL");
     }
     return TRUE;
 }

 public function installAbsenceTypes()
 {
     $leaves = TRUE;
     $weight = 0;
     $values = '';
     $options = CRM_Core_OptionGroup::values('hrjob_leave_type', TRUE, FALSE);
     if (empty($options)) {
         $leaves = FALSE;
         $options = array('Sick' => 'Sick', 'Vacation' => 'Vacation', 'Maternity' => 'Maternity', 'Paternity' => 'Paternity', 'TOIL' => 'TOIL', 'Other' => 'Other');
     }
     $seperator = CRM_Core_DAO::VALUE_SEPARATOR;
     foreach ($options as $orgKey => $orgValue) {
         $params = array('title' => $orgValue, 'is_active' => 1, 'allow_debits' => 1);
         if ($orgKey == 'TOIL') {
             $params['allow_credits'] = 1;
         }
         $absenceTypes = CRM_HRAbsence_BAO_HRAbsenceType::create($params);
         $values .= " WHEN '{$orgValue}' THEN '{$absenceTypes->id}'";
         if ($absenceTypes->debit_activity_type_id) {
             $absenceTypeID[] = $absenceTypes->debit_activity_type_id;
             if ($orgKey == 'Sick') {
                 $sickTypeID = $absenceTypes->debit_activity_type_id;
             }
         }
         if ($absenceTypes->credit_activity_type_id) {
             $absenceTypeID[] = $absenceTypes->credit_activity_type_id;
             if ($orgKey == 'Sick') {
                 $sickTypeID = $absenceTypes->debit_activity_type_id;
             }
         }
     }
     if (CRM_Core_DAO::checkTableExists('civicrm_hrjobcontract_leave') && $leaves) {
         $query = "UPDATE civicrm_hrjobcontract_leave\n        SET leave_type = CASE leave_type\n        {$values}\n        END;";
         CRM_Core_DAO::executeQuery($query);
     }
     CRM_Core_OptionGroup::deleteAssoc('hrjob_leave_type');
     $absenceTypeIDs = implode($seperator, $absenceTypeID);
     $paramsCGroup = array('title' => 'Absence Comment', 'extends' => array('0' => 'Activity'), 'style' => 'Inline', 'extends_entity_column_value' => array('0' => $absenceTypeIDs), 'is_active' => 1);
     $customGroup = civicrm_api3('CustomGroup', 'get', array('sequential' => 1, 'title' => $paramsCGroup['title']));
     $resultCGroup = CRM_Utils_Array::first($customGroup['values']);
     if (empty($resultCGroup['id'])) {
         $resultCGroup = civicrm_api3('custom_group', 'create', $paramsCGroup);
     }
     $paramsCField = array('custom_group_id' => $resultCGroup['id'], 'label' => 'Comment', 'html_type' => 'TextArea', 'data_type' => 'Memo', 'is_active' => 1);
     $resultCField = civicrm_api3('custom_field', 'get', $paramsCField);
     if ($resultCField['count'] == 0) {
         $resultCField = civicrm_api3('custom_field', 'create', $paramsCField);
     }
     $paramsSGroup = array('title' => 'Type of Sickness', 'extends' => array('0' => 'Activity'), 'style' => 'Inline', 'extends_entity_column_value' => array('0' => $sickTypeID), 'is_active' => 1);
     $sickGroup = civicrm_api3('CustomGroup', 'get', array('sequential' => 1, 'title' => $paramsSGroup['title']));
     $resultSGroup = CRM_Utils_Array::first($sickGroup['values']);
     if (empty($resultSGroup['id'])) {
         $resultSGroup = civicrm_api3('custom_group', 'create', $paramsSGroup);
     }
     $paramsSField = array('custom_group_id' => $resultSGroup['id'], 'label' => 'Sick Type', 'html_type' => 'Select', 'data_type' => 'String', 'is_active' => 1);
     $resultSField = civicrm_api3('custom_field', 'get', $paramsSField);
     if ($resultSField['count'] == 0) {
         $resultSField = civicrm_api3('custom_field', 'create', $paramsSField);
     }
     $sickType = array('Cold', 'Cough', 'Fever');
     foreach ($sickType as $Key => $val) {
         $paramsOVal = array('sequential' => 1, 'name' => $val, 'option_group_id' => $resultSField['values'][$resultSField['id']]['option_group_id']);
         $optionValue = civicrm_api3('OptionValue', 'get', array('sequential' => 1, 'option_group_id' => $paramsOVal['option_group_id'], 'name' => $paramsOVal['name']));
         if ($optionValue['count'] == 0) {
             civicrm_api3('OptionValue', 'create', $paramsOVal);
         }
     }
 }