コード例 #1
0
 public function deleteEntry($id, $key)
 {
     $e = self::$_extensions;
     if ($e['per_id'][$id]['status'] === 'enabled') {
         require_once 'CRM/Core/DAO/OptionValue.php';
         $optionValue = new CRM_Core_DAO_OptionValue();
         $optionValue->id = $id;
         return $optionValue->delete();
     }
     return false;
 }
コード例 #2
0
 /**
  * Takes an associative array and creates a custom field object.
  *
  * This function is invoked from within the web form layer and also from the api layer
  *
  * @param array $params
  *   (reference) an assoc array of name/value pairs.
  *
  * @return CRM_Core_DAO_CustomField
  */
 public static function create(&$params)
 {
     $origParams = array_merge(array(), $params);
     if (!isset($params['id'])) {
         if (!isset($params['column_name'])) {
             // if add mode & column_name not present, calculate it.
             $params['column_name'] = strtolower(CRM_Utils_String::munge($params['label'], '_', 32));
         }
         if (!isset($params['name'])) {
             $params['name'] = CRM_Utils_String::munge($params['label'], '_', 64);
         }
     } else {
         $params['column_name'] = CRM_Core_DAO::getFieldValue('CRM_Core_DAO_CustomField', $params['id'], 'column_name');
     }
     $columnName = $params['column_name'];
     $indexExist = FALSE;
     //as during create if field is_searchable we had created index.
     if (!empty($params['id'])) {
         $indexExist = CRM_Core_DAO::getFieldValue('CRM_Core_DAO_CustomField', $params['id'], 'is_searchable');
     }
     switch (CRM_Utils_Array::value('html_type', $params)) {
         case 'Select Date':
             if (empty($params['date_format'])) {
                 $config = CRM_Core_Config::singleton();
                 $params['date_format'] = $config->dateInputFormat;
             }
             break;
         case 'CheckBox':
         case 'AdvMulti-Select':
         case 'Multi-Select':
             if (isset($params['default_checkbox_option'])) {
                 $tempArray = array_keys($params['default_checkbox_option']);
                 $defaultArray = array();
                 foreach ($tempArray as $k => $v) {
                     if ($params['option_value'][$v]) {
                         $defaultArray[] = $params['option_value'][$v];
                     }
                 }
                 if (!empty($defaultArray)) {
                     // also add the separator before and after the value per new convention (CRM-1604)
                     $params['default_value'] = CRM_Core_DAO::VALUE_SEPARATOR . implode(CRM_Core_DAO::VALUE_SEPARATOR, $defaultArray) . CRM_Core_DAO::VALUE_SEPARATOR;
                 }
             } else {
                 if (!empty($params['default_option']) && isset($params['option_value'][$params['default_option']])) {
                     $params['default_value'] = $params['option_value'][$params['default_option']];
                 }
             }
             break;
     }
     $transaction = new CRM_Core_Transaction();
     // create any option group & values if required
     if ($params['html_type'] != 'Text' && in_array($params['data_type'], array('String', 'Int', 'Float', 'Money'))) {
         $tableName = CRM_Core_DAO::getFieldValue('CRM_Core_DAO_CustomGroup', $params['custom_group_id'], 'table_name');
         //CRM-16659: if option_value then create an option group for this custom field.
         if ($params['option_type'] == 1 && (empty($params['option_group_id']) || !empty($params['option_value']))) {
             // first create an option group for this custom group
             $optionGroup = new CRM_Core_DAO_OptionGroup();
             $optionGroup->name = "{$columnName}_" . date('YmdHis');
             $optionGroup->title = $params['label'];
             $optionGroup->is_active = 1;
             $optionGroup->save();
             $params['option_group_id'] = $optionGroup->id;
             if (!empty($params['option_value']) && is_array($params['option_value'])) {
                 foreach ($params['option_value'] as $k => $v) {
                     if (strlen(trim($v))) {
                         $optionValue = new CRM_Core_DAO_OptionValue();
                         $optionValue->option_group_id = $optionGroup->id;
                         $optionValue->label = $params['option_label'][$k];
                         $optionValue->name = CRM_Utils_String::titleToVar($params['option_label'][$k]);
                         switch ($params['data_type']) {
                             case 'Money':
                                 $optionValue->value = CRM_Utils_Rule::cleanMoney($v);
                                 break;
                             case 'Int':
                                 $optionValue->value = intval($v);
                                 break;
                             case 'Float':
                                 $optionValue->value = floatval($v);
                                 break;
                             default:
                                 $optionValue->value = trim($v);
                         }
                         $optionValue->weight = $params['option_weight'][$k];
                         $optionValue->is_active = CRM_Utils_Array::value($k, $params['option_status'], FALSE);
                         $optionValue->save();
                     }
                 }
             }
         }
     }
     // check for orphan option groups
     if (!empty($params['option_group_id'])) {
         if (!empty($params['id'])) {
             self::fixOptionGroups($params['id'], $params['option_group_id']);
         }
         // if we do not have a default value
         // retrieve it from one of the other custom fields which use this option group
         if (empty($params['default_value'])) {
             //don't insert only value separator as default value, CRM-4579
             $defaultValue = self::getOptionGroupDefault($params['option_group_id'], $params['html_type']);
             if (!CRM_Utils_System::isNull(explode(CRM_Core_DAO::VALUE_SEPARATOR, $defaultValue))) {
                 $params['default_value'] = $defaultValue;
             }
         }
     }
     // since we need to save option group id :)
     if (!isset($params['attributes']) && strtolower($params['html_type']) == 'textarea') {
         $params['attributes'] = 'rows=4, cols=60';
     }
     $customField = new CRM_Core_DAO_CustomField();
     $customField->copyValues($params);
     $customField->is_required = CRM_Utils_Array::value('is_required', $params, FALSE);
     $customField->is_searchable = CRM_Utils_Array::value('is_searchable', $params, FALSE);
     $customField->in_selector = CRM_Utils_Array::value('in_selector', $params, FALSE);
     $customField->is_search_range = CRM_Utils_Array::value('is_search_range', $params, FALSE);
     //CRM-15792 - Custom field gets disabled if is_active not set
     $customField->is_active = CRM_Utils_Array::value('is_active', $params, TRUE);
     $customField->is_view = CRM_Utils_Array::value('is_view', $params, FALSE);
     $customField->save();
     // make sure all values are present in the object for further processing
     $customField->find(TRUE);
     $triggerRebuild = CRM_Utils_Array::value('triggerRebuild', $params, TRUE);
     //create/drop the index when we toggle the is_searchable flag
     if (!empty($params['id'])) {
         self::createField($customField, 'modify', $indexExist, $triggerRebuild);
     } else {
         if (!isset($origParams['column_name'])) {
             $columnName .= "_{$customField->id}";
             $params['column_name'] = $columnName;
         }
         $customField->column_name = $columnName;
         $customField->save();
         // make sure all values are present in the object
         $customField->find(TRUE);
         $indexExist = FALSE;
         self::createField($customField, 'add', $indexExist, $triggerRebuild);
     }
     // complete transaction
     $transaction->commit();
     CRM_Utils_System::flushCache();
     return $customField;
 }
コード例 #3
0
 /**
  * returns the list of fields that can be exported
  *
  * @access public
  * return array
  * @static
  */
 static function &export($prefix = false)
 {
     if (!self::$_export) {
         self::$_export = array();
         $fields = self::fields();
         foreach ($fields as $name => $field) {
             if (CRM_Utils_Array::value('export', $field)) {
                 if ($prefix) {
                     self::$_export['option_value'] =& $fields[$name];
                 } else {
                     self::$_export[$name] =& $fields[$name];
                 }
             }
         }
     }
     return self::$_export;
 }
コード例 #4
0
 /**  Remove all the report that registerd on GiftAid 1.0beta and 2.0beta
  **/
 static function removeLegacyRegisteredReport()
 {
     $reportClass = new CRM_Core_DAO_OptionValue();
     $reportClass->option_group_id = self::getReportTemplateGroupId();
     $reportClass->name = 'GiftAid_Report_Form_Contribute_GiftAid';
     if ($reportClass->find(TRUE)) {
         $reportClass->delete();
     }
 }
コード例 #5
0
 static function updateCustomValues($params)
 {
     $optionDAO = new CRM_Core_DAO_OptionValue();
     $optionDAO->id = $params['optionId'];
     $optionDAO->find(TRUE);
     $oldValue = $optionDAO->value;
     // get the table, column, html_type and data type for this field
     $query = "\nSELECT g.table_name  as tableName ,\n       f.column_name as columnName,\n       f.data_type   as dataType,\n       f.html_type   as htmlType\nFROM   civicrm_custom_group g,\n       civicrm_custom_field f\nWHERE  f.custom_group_id = g.id\n  AND  f.id = %1";
     $queryParams = array(1 => array($params['fieldId'], 'Integer'));
     $dao = CRM_Core_DAO::executeQuery($query, $queryParams);
     if ($dao->fetch()) {
         if ($dao->dataType == 'Money') {
             $params['value'] = CRM_Utils_Rule::cleanMoney($params['value']);
         }
         switch ($dao->htmlType) {
             case 'Autocomplete-Select':
             case 'Select':
             case 'Radio':
                 $query = "\nUPDATE {$dao->tableName}\nSET    {$dao->columnName} = %1\nWHERE  id = %2";
                 if ($dao->dataType == 'Auto-complete') {
                     $dataType = "String";
                 } else {
                     $dataType = $dao->dataType;
                 }
                 $queryParams = array(1 => array($params['value'], $dataType), 2 => array($params['optionId'], 'Integer'));
                 break;
             case 'AdvMulti-Select':
             case 'Multi-Select':
             case 'CheckBox':
                 $oldString = CRM_Core_DAO::VALUE_SEPARATOR . $oldValue . CRM_Core_DAO::VALUE_SEPARATOR;
                 $newString = CRM_Core_DAO::VALUE_SEPARATOR . $params['value'] . CRM_Core_DAO::VALUE_SEPARATOR;
                 $query = "\nUPDATE {$dao->tableName}\nSET    {$dao->columnName} = REPLACE( {$dao->columnName}, %1, %2 )";
                 $queryParams = array(1 => array($oldString, 'String'), 2 => array($newString, 'String'));
                 break;
             default:
                 CRM_Core_Error::fatal();
         }
         $dao = CRM_Core_DAO::executeQuery($query, $queryParams);
     }
 }
コード例 #6
0
ファイル: OptionValue.php プロジェクト: kidaa30/yes
 /**
  * Get the values of all option values given an option group ID. Store in system cache
  * Does not take any filtering arguments. The object is to avoid hitting the DB and retrieve
  * from memory
  *
  * @param int $optionGroupID
  *   The option group for which we want the values from.
  *
  * @return array
  *   an array of array of values for this option group
  */
 public static function getOptionValuesArray($optionGroupID)
 {
     // check if we can get the field values from the system cache
     $cacheKey = "CRM_Core_BAO_OptionValue_OptionGroupID_{$optionGroupID}";
     $cache = CRM_Utils_Cache::singleton();
     $optionValues = $cache->get($cacheKey);
     if (empty($optionValues)) {
         $dao = new CRM_Core_DAO_OptionValue();
         $dao->option_group_id = $optionGroupID;
         $dao->orderBy('weight ASC, label ASC');
         $dao->find();
         $optionValues = array();
         while ($dao->fetch()) {
             $optionValues[$dao->id] = array();
             CRM_Core_DAO::storeValues($dao, $optionValues[$dao->id]);
         }
         $cache->set($cacheKey, $optionValues);
     }
     return $optionValues;
 }
コード例 #7
0
ファイル: PdfFormat.php プロジェクト: kidaa30/yes
 /**
  * Delete a PDF Page Format.
  *
  * @param int $id
  *   ID of the PDF Page Format to be deleted.
  *
  */
 public static function del($id)
 {
     if ($id) {
         $dao = new CRM_Core_DAO_OptionValue();
         $dao->id = $id;
         if ($dao->find(TRUE)) {
             if ($dao->option_group_id == self::_getGid()) {
                 $filter = array('option_group_id' => self::_getGid());
                 CRM_Utils_Weight::delWeight('CRM_Core_DAO_OptionValue', $id, $filter);
                 $dao->delete();
                 return;
             }
         }
     }
     CRM_Core_Error::fatal(ts('Invalid value passed to delete function.'));
 }
コード例 #8
0
 /**
  * Process the form
  *
  * @param null
  *
  * @return void
  * @access public
  */
 public function postProcess()
 {
     // store the submitted values in an array
     $params = $this->controller->exportValues('Option');
     if ($this->_action == CRM_Core_Action::DELETE) {
         $fieldValues = array('option_group_id' => $this->_optionGroupID);
         $wt = CRM_Utils_Weight::delWeight('CRM_Core_DAO_OptionValue', $this->_id, $fieldValues);
         CRM_Core_BAO_CustomOption::del($this->_id);
         CRM_Core_Session::setStatus(ts('Your multiple choice option has been deleted'));
         return;
     }
     // set values for custom field properties and save
     $customOption = new CRM_Core_DAO_OptionValue();
     $customOption->label = $params['label'];
     $customOption->name = CRM_Utils_String::titleToVar($params['label']);
     $customOption->weight = $params['weight'];
     $customOption->value = $params['value'];
     $customOption->is_active = CRM_Utils_Array::value('is_active', $params, FALSE);
     $oldWeight = NULL;
     if ($this->_id) {
         $customOption->id = $this->_id;
         CRM_Core_BAO_CustomOption::updateCustomValues($params);
         $oldWeight = CRM_Core_DAO::getFieldValue('CRM_Core_DAO_OptionValue', $this->_id, 'weight', 'id');
     }
     $fieldValues = array('option_group_id' => $this->_optionGroupID);
     $customOption->weight = CRM_Utils_Weight::updateOtherWeights('CRM_Core_DAO_OptionValue', $oldWeight, $params['weight'], $fieldValues);
     $customOption->option_group_id = $this->_optionGroupID;
     $customField = new CRM_Core_DAO_CustomField();
     $customField->id = $this->_fid;
     if ($customField->find(TRUE) && ($customField->html_type == 'CheckBox' || $customField->html_type == 'AdvMulti-Select' || $customField->html_type == 'Multi-Select')) {
         $defVal = explode(CRM_Core_DAO::VALUE_SEPARATOR, substr($customField->default_value, 1, -1));
         if (CRM_Utils_Array::value('default_value', $params)) {
             if (!in_array($customOption->value, $defVal)) {
                 if (empty($defVal[0])) {
                     $defVal = array($customOption->value);
                 } else {
                     $defVal[] = $customOption->value;
                 }
                 $customField->default_value = CRM_Core_DAO::VALUE_SEPARATOR . implode(CRM_Core_DAO::VALUE_SEPARATOR, $defVal) . CRM_Core_DAO::VALUE_SEPARATOR;
                 $customField->save();
             }
         } elseif (in_array($customOption->value, $defVal)) {
             $tempVal = array();
             foreach ($defVal as $v) {
                 if ($v != $customOption->value) {
                     $tempVal[] = $v;
                 }
             }
             $customField->default_value = CRM_Core_DAO::VALUE_SEPARATOR . implode(CRM_Core_DAO::VALUE_SEPARATOR, $tempVal) . CRM_Core_DAO::VALUE_SEPARATOR;
             $customField->save();
         }
     } else {
         switch ($customField->data_type) {
             case 'Money':
                 $customOption->value = CRM_Utils_Rule::cleanMoney($customOption->value);
                 break;
             case 'Int':
                 $customOption->value = intval($customOption->value);
                 break;
             case 'Float':
                 $customOption->value = floatval($customOption->value);
                 break;
         }
         if (CRM_Utils_Array::value('default_value', $params)) {
             $customField->default_value = $customOption->value;
             $customField->save();
         } elseif ($customField->find(TRUE) && $customField->default_value == $customOption->value) {
             // this is the case where this option is the current default value and we have been reset
             $customField->default_value = 'null';
             $customField->save();
         }
     }
     $customOption->save();
     CRM_Core_Session::setStatus(ts('Your multiple choice option \'%1\' has been saved', array(1 => $customOption->label)));
     $buttonName = $this->controller->getButtonName();
     $session = CRM_Core_Session::singleton();
     if ($buttonName == $this->getButtonName('next', 'new')) {
         CRM_Core_Session::setStatus(ts(' You can add another option.'));
         $session->replaceUserContext(CRM_Utils_System::url('civicrm/admin/custom/group/field/option', 'reset=1&action=add&fid=' . $this->_fid . '&gid=' . $this->_gid));
     }
 }
コード例 #9
0
ファイル: Survey.php プロジェクト: hampelm/Ginsberg-CiviDemo
 /**
  * Process the form
  * 
  * @param null
  * 
  * @return void
  * @access public
  */
 public function postProcess()
 {
     // store the submitted values in an array
     $params = $this->controller->exportValues($this->_name);
     $session = CRM_Core_Session::singleton();
     $params['last_modified_id'] = $session->get('userID');
     $params['last_modified_date'] = date('YmdHis');
     require_once 'CRM/Core/BAO/OptionValue.php';
     require_once 'CRM/Core/BAO/OptionGroup.php';
     $updateResultSet = false;
     if (CRM_Utils_Array::value('option_type', $params) == 2 && CRM_Utils_Array::value('option_group_id', $params)) {
         if ($params['option_group_id'] == CRM_Utils_Array::value('result_id', $this->_values)) {
             $updateResultSet = true;
         }
     }
     if ($this->_surveyId) {
         if ($this->_action & CRM_Core_Action::DELETE) {
             CRM_Campaign_BAO_Survey::del($this->_surveyId);
             CRM_Core_Session::setStatus(ts(' Survey has been deleted.'));
             $session->replaceUserContext(CRM_Utils_System::url('civicrm/campaign', 'reset=1&subPage=survey'));
             return;
         }
         $params['id'] = $this->_surveyId;
     } else {
         $params['created_id'] = $session->get('userID');
         $params['created_date'] = date('YmdHis');
     }
     $params['is_active'] = CRM_Utils_Array::value('is_active', $params, 0);
     $params['is_default'] = CRM_Utils_Array::value('is_default', $params, 0);
     $recontactInterval = array();
     if ($updateResultSet) {
         $optionValue = new CRM_Core_DAO_OptionValue();
         $optionValue->option_group_id = $this->_values['result_id'];
         $optionValue->delete();
         $params['result_id'] = $this->_values['result_id'];
     } else {
         $opGroupName = 'civicrm_survey_' . rand(10, 1000) . '_' . date('YmdHis');
         $optionGroup = new CRM_Core_DAO_OptionGroup();
         $optionGroup->name = $opGroupName;
         $optionGroup->label = $params['title'] . ' Response Set';
         $optionGroup->is_active = 1;
         $optionGroup->save();
         $params['result_id'] = $optionGroup->id;
     }
     foreach ($params['option_value'] as $k => $v) {
         if (strlen(trim($v))) {
             $optionValue = new CRM_Core_DAO_OptionValue();
             $optionValue->option_group_id = $params['result_id'];
             $optionValue->label = $params['option_label'][$k];
             $optionValue->name = CRM_Utils_String::titleToVar($params['option_label'][$k]);
             $optionValue->value = trim($v);
             $optionValue->weight = $params['option_weight'][$k];
             $optionValue->is_active = 1;
             if (CRM_Utils_Array::value('default_option', $params) && $params['default_option'] == $k) {
                 $optionValue->is_default = 1;
             }
             $optionValue->save();
             if (CRM_Utils_Array::value($k, $params['option_interval'])) {
                 $recontactInterval[$optionValue->label] = $params['option_interval'][$k];
             }
         }
     }
     $params['recontact_interval'] = serialize($recontactInterval);
     $surveyId = CRM_Campaign_BAO_Survey::create($params);
     if (CRM_Utils_Array::value('result_id', $this->_values) && !$updateResultSet) {
         $query = "SELECT COUNT(*) FROM civicrm_survey WHERE result_id = %1";
         $countSurvey = CRM_Core_DAO::singleValueQuery($query, array(1 => array($this->_values['result_id'], 'Integer')));
         // delete option group if no any survey is using it.
         if (!($countSurvey >= 1)) {
             CRM_Core_BAO_OptionGroup::del($this->_values['result_id']);
         }
     }
     require_once 'CRM/Core/BAO/UFJoin.php';
     // also update the ProfileModule tables
     $ufJoinParams = array('is_active' => 1, 'module' => 'CiviCampaign', 'entity_table' => 'civicrm_survey', 'entity_id' => $surveyId->id);
     // first delete all past entries
     if ($this->_surveyId) {
         CRM_Core_BAO_UFJoin::deleteAll($ufJoinParams);
     }
     if (CRM_Utils_Array::value('profile_id', $params)) {
         $ufJoinParams['weight'] = 1;
         $ufJoinParams['uf_group_id'] = $params['profile_id'];
         CRM_Core_BAO_UFJoin::create($ufJoinParams);
     }
     if (!is_a($surveyId, 'CRM_Core_Error')) {
         CRM_Core_Session::setStatus(ts('Survey %1 has been saved.', array(1 => $params['title'])));
     }
     if ($this->_context == 'dialog') {
         $returnArray = array('returnSuccess' => true);
         echo json_encode($returnArray);
         CRM_Utils_System::civiExit();
     }
     $buttonName = $this->controller->getButtonName();
     if ($buttonName == $this->getButtonName('next', 'new')) {
         CRM_Core_Session::setStatus(ts(' You can add another Survey.'));
         $session->replaceUserContext(CRM_Utils_System::url('civicrm/survey/add', 'reset=1&action=add'));
     } else {
         $session->replaceUserContext(CRM_Utils_System::url('civicrm/campaign', 'reset=1&subPage=survey'));
     }
 }
コード例 #10
0
ファイル: Results.php プロジェクト: FundingWorks/civicrm-core
 /**
  * Process the form.
  */
 public function postProcess()
 {
     // store the submitted values in an array
     $status = '';
     $params = $this->controller->exportValues($this->_name);
     $params['id'] = $this->_surveyId;
     $updateResultSet = FALSE;
     $resultSetOptGrpId = NULL;
     if (CRM_Utils_Array::value('option_type', $params) == 2 && !empty($params['option_group_id'])) {
         $updateResultSet = TRUE;
         $resultSetOptGrpId = $params['option_group_id'];
     }
     $recontactInterval = array();
     if ($updateResultSet) {
         $optionValue = new CRM_Core_DAO_OptionValue();
         $optionValue->option_group_id = $resultSetOptGrpId;
         $optionValue->delete();
         $params['result_id'] = $resultSetOptGrpId;
     } else {
         $opGroupName = 'civicrm_survey_' . rand(10, 1000) . '_' . date('YmdHis');
         $optionGroup = new CRM_Core_DAO_OptionGroup();
         $optionGroup->name = $opGroupName;
         $optionGroup->title = $this->_values['title'] . ' Result Set';
         $optionGroup->is_active = 1;
         $optionGroup->save();
         $params['result_id'] = $optionGroup->id;
     }
     foreach ($params['option_value'] as $k => $v) {
         if (strlen(trim($v))) {
             $optionValue = new CRM_Core_DAO_OptionValue();
             $optionValue->option_group_id = $params['result_id'];
             $optionValue->label = $params['option_label'][$k];
             $optionValue->name = CRM_Utils_String::titleToVar($params['option_label'][$k]);
             $optionValue->value = trim($v);
             $optionValue->weight = $params['option_weight'][$k];
             $optionValue->is_active = 1;
             if (!empty($params['default_option']) && $params['default_option'] == $k) {
                 $optionValue->is_default = 1;
             }
             $optionValue->save();
             // using is_numeric since 0 is a valid value for option_interval
             if (is_numeric($params['option_interval'][$k])) {
                 $recontactInterval[$optionValue->label] = $params['option_interval'][$k];
             }
         }
     }
     $params['recontact_interval'] = serialize($recontactInterval);
     $survey = CRM_Campaign_BAO_Survey::create($params);
     // create report if required.
     if (!$this->_reportId && $survey->id && !empty($params['create_report'])) {
         $activityStatus = CRM_Core_PseudoConstant::activityStatus('name');
         $activityStatus = array_flip($activityStatus);
         $this->_params = array('name' => "survey_{$survey->id}", 'title' => $params['report_title'] ? $params['report_title'] : $this->_values['title'], 'status_id_op' => 'eq', 'status_id_value' => $activityStatus['Scheduled'], 'survey_id_value' => array($survey->id), 'description' => ts('Detailed report for canvassing, phone-banking, walk lists or other surveys.'));
         //Default value of order by
         $this->_params['order_bys'] = array(1 => array('column' => 'sort_name', 'order' => 'ASC'));
         // for WalkList or default
         $displayFields = array('id', 'sort_name', 'result', 'street_number', 'street_name', 'street_unit', 'survey_response');
         if (CRM_Core_OptionGroup::getValue('activity_type', 'WalkList') == $this->_values['activity_type_id']) {
             $this->_params['order_bys'] = array(1 => array('column' => 'street_name', 'order' => 'ASC'), 2 => array('column' => 'street_number_odd_even', 'order' => 'ASC'), 3 => array('column' => 'street_number', 'order' => 'ASC'), 4 => array('column' => 'sort_name', 'order' => 'ASC'));
         } elseif (CRM_Core_OptionGroup::getValue('activity_type', 'PhoneBank') == $this->_values['activity_type_id']) {
             array_push($displayFields, 'phone');
         } elseif (CRM_Core_OptionGroup::getValue('activity_type', 'Survey') == $this->_values['activity_type_id'] || CRM_Core_OptionGroup::getValue('activity_type', 'Canvass') == $this->_values['activity_type_id']) {
             array_push($displayFields, 'phone', 'city', 'state_province_id', 'postal_code', 'email');
         }
         foreach ($displayFields as $key) {
             $this->_params['fields'][$key] = 1;
         }
         $this->_createNew = TRUE;
         $this->_id = CRM_Report_Utils_Report::getInstanceIDForValue('survey/detail');
         CRM_Report_Form_Instance::postProcess($this, FALSE);
         $query = "SELECT MAX(id) FROM civicrm_report_instance WHERE name = %1";
         $reportID = CRM_Core_DAO::singleValueQuery($query, array(1 => array("survey_{$survey->id}", 'String')));
         if ($reportID) {
             $url = CRM_Utils_System::url("civicrm/report/instance/{$reportID}", 'reset=1');
             $status = ts("A Survey Detail Report <a href='%1'>%2</a> has been created.", array(1 => $url, 2 => $this->_params['title']));
         }
     }
     if ($status) {
         // reset status as we don't want status set by Instance::postProcess
         $session = CRM_Core_Session::singleton();
         $session->getStatus(TRUE);
         // set new status
         CRM_Core_Session::setStatus($status, ts('Saved'), 'success');
     }
     parent::endPostProcess();
 }
コード例 #11
0
ファイル: Step3.php プロジェクト: prashantgajare/civicrm-core
 /**
  * This function preserve the civicrm_domain.email_name and civicrm_domain.email_address
  * as a default option value into "from_email_address" option group
  * and drop these columns from civicrm_domain table.
  * @access public
  *
  * @return void
  */
 function upgradeDomainFromEmail()
 {
     $query = "\nSELECT id\n  FROM civicrm_option_group\n WHERE name = 'from_Email_address'";
     $fmaGroup = CRM_Core_DAO::executeQuery($query, CRM_Core_DAO::$_nullArray);
     $fmaGroupId = NULL;
     if ($fmaGroup->fetch()) {
         $fmaGroupId = $fmaGroup->id;
     } else {
         //insert 'from_mailing_address' option group.
         $query = "\nINSERT INTO civicrm_option_group ( name, description, is_reserved, is_active )\nVALUES ('from_email_address', 'From Email Address', 0, 1)";
         CRM_Core_DAO::executeQuery($query, CRM_Core_DAO::$_nullArray);
         //get the group id.
         $query = "\nSELECT id\n  FROM civicrm_option_group\n WHERE name = 'from_email_address'";
         $dao = CRM_Core_DAO::executeQuery($query, CRM_Core_DAO::$_nullArray);
         if ($dao->fetch()) {
             $fmaGroupId = $dao->id;
         }
     }
     if ($fmaGroupId) {
         //get domain from email address and name as default value.
         $domain = CRM_Core_BAO_Domain::getDomain();
         $domain->selectAdd();
         $domain->selectAdd('email_name', 'email_address');
         $domain->find(TRUE);
         $formEmailAddress = '"' . $domain->email_name . '"<' . $domain->email_address . '>';
         //first check given domain email address exist in option
         //value, if yes make it as domain email address by making
         //it as default from email address..
         //get the existing from email address.
         $optionValues = array();
         $grpParams['name'] = 'from_email_address';
         CRM_Core_OptionValue::getValues($grpParams, $optionValues);
         $maxVal = $maxWt = 1;
         $insertEmailAddress = TRUE;
         if (!empty($optionValues)) {
             //make existing is_default = 0
             $query = "\nUPDATE  civicrm_option_value\n   SET  is_default = 0\n WHERE  option_group_id = %1";
             $params = array(1 => array($fmaGroupId, 'Integer'));
             CRM_Core_DAO::executeQuery($query, $params);
             //if domain from name and email exist as name or label in option value
             //table need to preserve that name and label  and take care that label
             //and name both remain unique in db.
             $labelValues = $nameValues = array();
             foreach ($optionValues as $id => $value) {
                 if ($value['label'] == $formEmailAddress) {
                     $labelValues = $value;
                 } elseif ($value['name'] == $formEmailAddress) {
                     $nameValues = $value;
                 }
             }
             //as we consider label so label should preserve.
             $updateValues = array();
             if (!empty($labelValues)) {
                 $updateValues = $labelValues;
             }
             //if matching name found need to preserve it.
             if (!empty($nameValues)) {
                 //copy domain from email address as label.
                 if (empty($updateValues)) {
                     $updateValues = $nameValues;
                     $updateValues['label'] = $formEmailAddress;
                 } else {
                     //since name is also imp so preserve it
                     //as name for domain email address record.
                     $updateValues['name'] = $nameValues['name'];
                     //name is unique so drop name value record.
                     //since we transfer this name to found label record.
                     CRM_Core_BAO_OptionValue::del($nameValues['id']);
                 }
             }
             if (!empty($updateValues)) {
                 $insertEmailAddress = FALSE;
                 //update label/name found record w/ manupulated values.
                 $updateValues['is_active'] = $updateValues['is_default'] = 1;
                 $optionValue = new CRM_Core_DAO_OptionValue();
                 $optionValue->copyValues($updateValues);
                 $optionValue->save();
             }
             //get the max value and wt.
             if ($insertEmailAddress) {
                 $query = "\nSELECT   max(ROUND(civicrm_option_value.value)) as maxVal,\n         max(civicrm_option_value.weight) as maxWt\n    FROM civicrm_option_value, civicrm_option_group\n   WHERE civicrm_option_group.name = 'from_Email_address'\n     AND civicrm_option_value.option_group_id = civicrm_option_group.id\nGROUP BY civicrm_option_group.id";
                 $dao = CRM_Core_DAO::executeQuery($query, CRM_Core_DAO::$_nullArray);
                 if ($dao->fetch()) {
                     $maxWt += $dao->maxWt;
                     $maxVal += $dao->maxVal;
                 }
             }
         }
         if ($insertEmailAddress) {
             //insert domain from email address and name.
             $query = "\nINSERT INTO  `civicrm_option_value`\n             (`option_group_id`, `label`, `value`, `name` , `grouping`, `filter`, `is_default`,\n              `weight`, `description`, `is_optgroup`, `is_reserved`, `is_active`, `component_id`)\n     VALUES  ( %1, %2, %3, %2, NULL, 0, 1, %4, 'Default domain email address and from name.', 0, 0, 1, NULL)";
             $params = array(1 => array($fmaGroupId, 'Integer'), 2 => array($formEmailAddress, 'String'), 3 => array($maxVal, 'Integer'), 4 => array($maxWt, 'Integer'));
             CRM_Core_DAO::executeQuery($query, $params);
         }
         //drop civicrm_domain.email_name and
         //civicrm_domain.email_address.
         $query = "\nALTER TABLE `civicrm_domain`\n       DROP `email_name`,\n       DROP `email_address`";
         CRM_Core_DAO::executeQuery($query, CRM_Core_DAO::$_nullArray);
     }
 }
コード例 #12
0
ファイル: OptionValue.php プロジェクト: ksecor/civicrm
 /**
  * class constructor
  */
 function __construct()
 {
     parent::__construct();
 }
コード例 #13
0
ファイル: Grant.php プロジェクト: ksecor/civicrm
 static function getGrantStatuses()
 {
     $og = CRM_Grant_BAO_Grant::getGrantStatusOptGroup();
     require_once 'CRM/Core/BAO/OptionValue.php';
     $dao = new CRM_Core_DAO_OptionValue();
     $dao->option_group_id = $og->id;
     $dao->find();
     $statuses = array();
     while ($dao->fetch()) {
         $statuses[$dao->id] = $dao->label;
     }
     return $statuses;
 }
コード例 #14
0
 /**
  * Function to delete Option Group 
  * 
  * @param  int  $optionGroupId     Id of the Option Group to be deleted.
  * 
  * @return void
  * 
  * @access public
  * @static
  */
 static function del($optionGroupId)
 {
     // need to delete all option value field before deleting group
     require_once 'CRM/Core/DAO/OptionValue.php';
     $optionValue = new CRM_Core_DAO_OptionValue();
     $optionValue->option_group_id = $optionGroupId;
     $optionValue->delete();
     $optionGroup = new CRM_Core_DAO_OptionGroup();
     $optionGroup->id = $optionGroupId;
     $optionGroup->delete();
 }
コード例 #15
0
ファイル: OptionValue.php プロジェクト: ksecor/civicrm
 /**
  * Check if there is a record with the same name in the db
  *
  * @param string $value     the value of the field we are checking
  * @param string $daoName   the dao object name
  * @param string $daoID     the id of the object being updated. u can change your name
  *                          as long as there is no conflict
  * @param string $fieldName the name of the field in the DAO
  *
  * @return boolean     true if object exists
  * @access public
  * @static
  */
 static function getFields($mode = '', $contactType = 'Individual')
 {
     $key = "{$mode} {$contactType}";
     if (empty(self::$_fields[$key]) || !self::$_fields[$key]) {
         self::$_fields[$key] = array();
         require_once "CRM/Core/DAO/OptionValue.php";
         $option = CRM_Core_DAO_OptionValue::import();
         foreach (array_keys($option) as $id) {
             $optionName = $option[$id];
         }
         $nameTitle = array();
         if ($mode == 'contribute') {
             $nameTitle = array('payment_instrument' => array('name' => 'payment_instrument', 'title' => 'Payment Instrument', 'headerPattern' => '/^payment|(p(ayment\\s)?instrument)$/i'));
         } else {
             if ($mode == '') {
                 //the fields email greeting and postal greeting are meant only for Individual and Household
                 //the field addressee is meant for all contact types, CRM-4575
                 if (in_array($contactType, array('Individual', 'Household', 'Organization', 'All'))) {
                     $nameTitle = array('addressee' => array('name' => 'addressee', 'title' => 'Addressee', 'headerPattern' => '/^addressee$/i'));
                 }
                 if ($contactType == 'Individual' || $contactType == 'Household' || $contactType == 'All') {
                     $title = array('email_greeting' => array('name' => 'email_greeting', 'title' => 'Email Greeting', 'headerPattern' => '/^email_greeting$/i'), 'postal_greeting' => array('name' => 'postal_greeting', 'title' => 'Postal Greeting', 'headerPattern' => '/^postal_greeting$/i'));
                     $nameTitle = array_merge($nameTitle, $title);
                 }
                 if ($contactType == 'Individual' || $contactType == 'All') {
                     $title = array('gender' => array('name' => 'gender', 'title' => 'Gender', 'headerPattern' => '/^gender$/i'), 'individual_prefix' => array('name' => 'individual_prefix', 'title' => 'Individual Prefix', 'headerPattern' => '/^(prefix|title)/i'), 'individual_suffix' => array('name' => 'individual_suffix', 'title' => 'Individual Suffix', 'headerPattern' => '/^suffix$/i'));
                     $nameTitle = array_merge($nameTitle, $title);
                 }
             }
         }
         if (is_array($nameTitle)) {
             foreach ($nameTitle as $name => $attribs) {
                 self::$_fields[$key][$name] = $optionName;
                 list($tableName, $fieldName) = explode('.', $optionName['where']);
                 // not sure of this fix, so keeping it commented for now
                 // this is from CRM-1541
                 // self::$_fields[$mode][$name]['where'] = $name . '.' . $fieldName;
                 self::$_fields[$key][$name]['where'] = "{$name}.label";
                 foreach ($attribs as $k => $val) {
                     self::$_fields[$key][$name][$k] = $val;
                 }
             }
         }
     }
     return self::$_fields[$key];
 }
コード例 #16
0
 function upgrade_3_3_beta1($rev)
 {
     $upgrade = new CRM_Upgrade_Form();
     $upgrade->processSQL($rev);
     // CRM-6902
     // Add column price_field_value_id in civicrm_line_item.
     // Do not drop option_group_id column now since we need it to
     // update line items.
     $updateLineItem1 = "ALTER TABLE civicrm_line_item ADD COLUMN price_field_value_id int(10) unsigned default NULL;";
     CRM_Core_DAO::executeQuery($updateLineItem1);
     $priceFieldDAO = new CRM_Price_DAO_Field();
     $priceFieldDAO->find();
     $ids = array();
     while ($priceFieldDAO->fetch()) {
         $opGroupDAO = new CRM_Core_DAO_OptionGroup();
         $opGroupDAO->name = 'civicrm_price_field.amount.' . $priceFieldDAO->id;
         if (!$opGroupDAO->find(TRUE)) {
             $opGroupDAO->free();
             continue;
         }
         $opValueDAO = new CRM_Core_DAO_OptionValue();
         $opValueDAO->option_group_id = $opGroupDAO->id;
         $opValueDAO->find();
         while ($opValueDAO->fetch()) {
             // FIX ME: not migrating description(?), there will
             // be a field description for each option.
             $fieldValue = array('price_field_id' => $priceFieldDAO->id, 'label' => $opValueDAO->label, 'name' => CRM_Utils_String::munge($opValueDAO->label, '_', 64), 'amount' => $opValueDAO->name, 'weight' => $opValueDAO->weight, 'is_default' => $opValueDAO->is_default, 'is_active' => $opValueDAO->is_active);
             if ($priceFieldDAO->count) {
                 // Migrate Participant Counts on option level.
                 // count of each option will be the same
                 // as earlier field count.
                 $fieldValue['count'] = $priceFieldDAO->count;
             }
             $fieldValueDAO = CRM_Price_BAO_FieldValue::add($fieldValue, $ids);
             $lineItemDAO = new CRM_Price_DAO_LineItem();
             $lineItemDAO->option_group_id = $opGroupDAO->id;
             $lineItemDAO->label = $opValueDAO->label;
             $lineItemDAO->unit_price = $opValueDAO->name;
             $labelFound = $priceFound = FALSE;
             // check with label and amount
             if (!$lineItemDAO->find(TRUE)) {
                 $lineItemDAO->free();
                 $lineItemDAO = new CRM_Price_DAO_LineItem();
                 $lineItemDAO->option_group_id = $opGroupDAO->id;
                 $lineItemDAO->label = $opValueDAO->label;
                 // check with label only
                 if ($lineItemDAO->find(TRUE)) {
                     $labelFound = TRUE;
                 }
             } else {
                 $labelFound = TRUE;
                 $priceFound = TRUE;
             }
             $lineItemDAO->free();
             // update civicrm_line_item for price_field_value_id.
             // Used query to avoid line by line update.
             if ($labelFound || $priceFound) {
                 $lineItemParams = array(1 => array($fieldValueDAO->id, 'Integer'), 2 => array($opValueDAO->label, 'String'));
                 $updateLineItems = "UPDATE civicrm_line_item SET price_field_value_id = %1 WHERE label = %2";
                 if ($priceFound) {
                     $lineItemParams[3] = array($opValueDAO->name, 'Float');
                     $updateLineItems .= " AND unit_price = %3";
                 }
                 CRM_Core_DAO::executeQuery($updateLineItems, $lineItemParams);
             }
         }
         $opGroupDAO->delete();
         $opValueDAO->free();
         $opGroupDAO->free();
     }
     $priceFieldDAO->free();
     // Now drop option_group_id column from civicrm_line_item
     $updateLineItem2 = "ALTER TABLE civicrm_line_item DROP option_group_id,\n                           ADD CONSTRAINT `FK_civicrm_price_field_value_id` FOREIGN KEY (price_field_value_id) REFERENCES civicrm_price_field_value(id) ON DELETE SET NULL;";
     CRM_Core_DAO::executeQuery($updateLineItem2, array(), TRUE, NULL, FALSE, FALSE);
     $updatePriceField = "ALTER TABLE civicrm_price_field DROP count";
     CRM_Core_DAO::executeQuery($updatePriceField, array(), TRUE, NULL, FALSE, FALSE);
     // as the table 'civicrm_price_field' is localised and column 'count' is dropped
     // after the views are rebuild, we need to rebuild views to avoid invalid refrence of table.
     if ($upgrade->multilingual) {
         CRM_Core_I18n_Schema::rebuildMultilingualSchema($upgrade->locales, $rev);
     }
 }
コード例 #17
0
ファイル: OptionValue.php プロジェクト: konadave/civicrm-core
 /**
  * Check if there is a record with the same name in the db.
  *
  * @param string $mode
  * @param string $contactType
  *
  * @return bool
  *   true if object exists
  */
 public static function getFields($mode = '', $contactType = 'Individual')
 {
     $key = "{$mode} {$contactType}";
     if (empty(self::$_fields[$key]) || !self::$_fields[$key]) {
         self::$_fields[$key] = array();
         $option = CRM_Core_DAO_OptionValue::import();
         foreach (array_keys($option) as $id) {
             $optionName = $option[$id];
         }
         $nameTitle = array();
         if ($mode == 'contribute') {
             $nameTitle = array('payment_instrument' => array('name' => 'payment_instrument', 'title' => ts('Payment Method'), 'headerPattern' => '/^payment|(p(ayment\\s)?instrument)$/i'));
         } elseif ($mode == '') {
             //the fields email greeting and postal greeting are meant only for Individual and Household
             //the field addressee is meant for all contact types, CRM-4575
             if (in_array($contactType, array('Individual', 'Household', 'Organization', 'All'))) {
                 $nameTitle = array('addressee' => array('name' => 'addressee', 'title' => ts('Addressee'), 'headerPattern' => '/^addressee$/i'));
                 $title = array('email_greeting' => array('name' => 'email_greeting', 'title' => ts('Email Greeting'), 'headerPattern' => '/^email_greeting$/i'), 'postal_greeting' => array('name' => 'postal_greeting', 'title' => ts('Postal Greeting'), 'headerPattern' => '/^postal_greeting$/i'));
                 $nameTitle = array_merge($nameTitle, $title);
             }
         }
         if (is_array($nameTitle)) {
             foreach ($nameTitle as $name => $attribs) {
                 self::$_fields[$key][$name] = $optionName;
                 list($tableName, $fieldName) = explode('.', $optionName['where']);
                 self::$_fields[$key][$name]['where'] = "{$name}.label";
                 foreach ($attribs as $k => $val) {
                     self::$_fields[$key][$name][$k] = $val;
                 }
             }
         }
     }
     return self::$_fields[$key];
 }
コード例 #18
0
ファイル: OptionGroup.php プロジェクト: hguru/224Civi
 /**
  * Function to delete Option Group
  *
  * @param  int  $optionGroupId     Id of the Option Group to be deleted.
  *
  * @return void
  *
  * @access public
  * @static
  */
 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();
 }
コード例 #19
0
ファイル: CustomField.php プロジェクト: bhirsch/voipdev
 /**
  * takes an associative array and creates a custom field object
  *
  * This function is invoked from within the web form layer and also from the api layer
  *
  * @param array $params (reference) an assoc array of name/value pairs
  *
  * @return object CRM_Core_DAO_CustomField object
  * @access public
  * @static
  */
 static function create(&$params)
 {
     if (!isset($params['id']) && !isset($params['column_name'])) {
         // if add mode & column_name not present, calculate it.
         require_once 'CRM/Utils/String.php';
         $params['column_name'] = strtolower(CRM_Utils_String::munge($params['label'], '_', 32));
     } else {
         if (isset($params['id'])) {
             $params['column_name'] = CRM_Core_DAO::getFieldValue('CRM_Core_DAO_CustomField', $params['id'], 'column_name');
         }
     }
     $indexExist = false;
     //as during create if field is_searchable we had created index.
     if (CRM_Utils_Array::value('id', $params)) {
         $indexExist = CRM_Core_DAO::getFieldValue('CRM_Core_DAO_CustomField', $params['id'], 'is_searchable');
     }
     if (($params['html_type'] == 'CheckBox' || $params['html_type'] == 'AdvMulti-Select' || $params['html_type'] == 'Multi-Select') && isset($params['default_checkbox_option'])) {
         $tempArray = array_keys($params['default_checkbox_option']);
         $defaultArray = array();
         foreach ($tempArray as $k => $v) {
             if ($params['option_value'][$v]) {
                 $defaultArray[] = $params['option_value'][$v];
             }
         }
         if (!empty($defaultArray)) {
             // also add the seperator before and after the value per new conventio (CRM-1604)
             $params['default_value'] = CRM_Core_BAO_CustomOption::VALUE_SEPERATOR . implode(CRM_Core_BAO_CustomOption::VALUE_SEPERATOR, $defaultArray) . CRM_Core_BAO_CustomOption::VALUE_SEPERATOR;
         }
     } else {
         if (CRM_Utils_Array::value('default_option', $params) && isset($params['option_value'][$params['default_option']])) {
             $params['default_value'] = $params['option_value'][$params['default_option']];
         }
     }
     require_once 'CRM/Core/Transaction.php';
     $transaction = new CRM_Core_Transaction();
     // create any option group & values if required
     if ($params['html_type'] != 'Text' && in_array($params['data_type'], array('String', 'Int', 'Float', 'Money')) && !empty($params['option_value']) && is_array($params['option_value'])) {
         $tableName = CRM_Core_DAO::getFieldValue('CRM_Core_DAO_CustomGroup', $params['custom_group_id'], 'table_name');
         if ($params['option_type'] == 1) {
             // first create an option group for this custom group
             require_once 'CRM/Core/BAO/OptionGroup.php';
             $optionGroup =& new CRM_Core_DAO_OptionGroup();
             $optionGroup->name = "{$params['column_name']}_" . date('YmdHis');
             $optionGroup->label = $params['label'];
             $optionGroup->is_active = 1;
             $optionGroup->save();
             $params['option_group_id'] = $optionGroup->id;
             require_once 'CRM/Core/BAO/OptionValue.php';
             require_once 'CRM/Utils/String.php';
             foreach ($params['option_value'] as $k => $v) {
                 if (strlen(trim($v))) {
                     $optionValue = new CRM_Core_DAO_OptionValue();
                     $optionValue->option_group_id = $optionGroup->id;
                     $optionValue->label = $params['option_label'][$k];
                     $optionValue->name = CRM_Utils_String::titleToVar($params['option_label'][$k]);
                     switch ($params['data_type']) {
                         case 'Money':
                             require_once 'CRM/Utils/Rule.php';
                             $optionValue->value = number_format(CRM_Utils_Rule::cleanMoney($v), 2);
                             break;
                         case 'Int':
                             $optionValue->value = intval($v);
                             break;
                         case 'Float':
                             $optionValue->value = floatval($v);
                             break;
                         default:
                             $optionValue->value = $v;
                     }
                     $optionValue->weight = $params['option_weight'][$k];
                     $optionValue->is_active = CRM_Utils_Array::value($k, $params['option_status'], false);
                     $optionValue->save();
                 }
             }
         }
     }
     // check for orphan option groups
     if (CRM_Utils_Array::value('option_group_id', $params)) {
         if (CRM_Utils_Array::value('id', $params)) {
             self::fixOptionGroups($params['id'], $params['option_group_id']);
         }
         // if we dont have a default value
         // retrive it from one of the other custom fields which use this option group
         if (!CRM_Utils_Array::value('default_value', $params)) {
             //don't insert only value separator as default value, CRM-4579
             $defaultValue = self::getOptionGroupDefault($params['option_group_id'], $params['html_type']);
             if (!CRM_Utils_System::isNull(explode(CRM_Core_BAO_CustomOption::VALUE_SEPERATOR, $defaultValue))) {
                 $params['default_value'] = $defaultValue;
             }
         }
     }
     // since we need to save option group id :)
     if (!isset($params['attributes']) && strtolower($params['html_type']) == 'textarea') {
         $params['attributes'] = 'rows=4, cols=60';
     }
     $customField =& new CRM_Core_DAO_CustomField();
     $customField->copyValues($params);
     $customField->is_required = CRM_Utils_Array::value('is_required', $params, false);
     $customField->is_searchable = CRM_Utils_Array::value('is_searchable', $params, false);
     $customField->is_search_range = CRM_Utils_Array::value('is_search_range', $params, false);
     $customField->is_active = CRM_Utils_Array::value('is_active', $params, false);
     $customField->is_view = CRM_Utils_Array::value('is_view', $params, false);
     $customField->save();
     // make sure all values are present in the object for further processing
     $customField->find(true);
     //create/drop the index when we toggle the is_searchable flag
     if (CRM_Utils_Array::value('id', $params)) {
         self::createField($customField, 'modify', $indexExist);
     } else {
         $customField->column_name .= "_{$customField->id}";
         $customField->save();
         // make sure all values are present in the object
         $customField->find(true);
         self::createField($customField, 'add');
     }
     // complete transaction
     $transaction->commit();
     // reset the cache
     require_once 'CRM/Core/BAO/Cache.php';
     CRM_Core_BAO_Cache::deleteGroup('contact fields');
     // reset various static arrays used here
     require_once 'CRM/Contact/BAO/Contact.php';
     CRM_Contact_BAO_Contact::$_importableFields = CRM_Contact_BAO_Contact::$_exportableFields = self::$_importFields = null;
     return $customField;
 }
コード例 #20
0
 static function formRule($fields, $files, $self)
 {
     $errors = array();
     $dupeClass = FALSE;
     $reportUrl = new CRM_Core_DAO_OptionValue();
     $reportUrl->option_group_id = $self->_opID;
     $reportUrl->value = $fields['value'];
     if ($reportUrl->find(TRUE) && $self->_id != $reportUrl->id) {
         $errors['value'] = ts('Url already exists in Database.');
         if ($reportUrl->name == $fields['name']) {
             $dupeClass = TRUE;
         }
     }
     if (!$dupeClass) {
         $reportClass = new CRM_Core_DAO_OptionValue();
         $reportClass->option_group_id = $self->_opID;
         $reportClass->name = $fields['name'];
         if ($reportClass->find(TRUE) && $self->_id != $reportClass->id) {
             $dupeClass = TRUE;
         }
     }
     if ($dupeClass) {
         $errors['name'] = ts('Class already exists in Database.');
     }
     return $errors;
 }
コード例 #21
0
 /**
  * When changing the value of an option this is called to update all corresponding custom data
  *
  * @param int $optionId
  * @param string $newValue
  */
 public static function updateValue($optionId, $newValue)
 {
     $optionValue = new CRM_Core_DAO_OptionValue();
     $optionValue->id = $optionId;
     $optionValue->find(TRUE);
     $oldValue = $optionValue->value;
     if ($oldValue == $newValue) {
         return;
     }
     $customField = new CRM_Core_DAO_CustomField();
     $customField->option_group_id = $optionValue->option_group_id;
     $customField->find();
     while ($customField->fetch()) {
         $customGroup = new CRM_Core_DAO_CustomGroup();
         $customGroup->id = $customField->custom_group_id;
         $customGroup->find(TRUE);
         if (CRM_Core_BAO_CustomField::isSerialized($customField)) {
             $params = array(1 => array(CRM_Utils_Array::implodePadded($oldValue), 'String'), 2 => array(CRM_Utils_Array::implodePadded($newValue), 'String'), 3 => array('%' . CRM_Utils_Array::implodePadded($oldValue) . '%', 'String'));
         } else {
             $params = array(1 => array($oldValue, 'String'), 2 => array($newValue, 'String'), 3 => array($oldValue, 'String'));
         }
         $sql = "UPDATE `{$customGroup->table_name}` SET `{$customField->column_name}` = REPLACE(`{$customField->column_name}`, %1, %2) WHERE `{$customField->column_name}` LIKE %3";
         $customGroup->free();
         CRM_Core_DAO::executeQuery($sql, $params);
     }
     $customField->free();
 }
コード例 #22
0
 /**
  * Browse all options value.
  *
  *
  * @return void
  * @access public
  * @static
  */
 function browse()
 {
     $dao = new CRM_Core_DAO_OptionValue();
     $dao->option_group_id = $this->_gid;
     if (in_array($this->_gName, CRM_Core_OptionGroup::$_domainIDGroups)) {
         $dao->domain_id = CRM_Core_Config::domainID();
     }
     if ($this->_gName == 'encounter_medium') {
         $mediumIds = CRM_Case_BAO_Case::getUsedEncounterMediums();
     } elseif ($this->_gName == 'case_status') {
         $caseStatusIds = CRM_Case_BAO_Case::getUsedCaseStatuses();
     } elseif ($this->_gName == 'case_type') {
         $caseTypeIds = CRM_Case_BAO_Case::getUsedCaseType();
     }
     $dao->orderBy('name');
     $dao->find();
     $optionValue = array();
     while ($dao->fetch()) {
         $optionValue[$dao->id] = array();
         CRM_Core_DAO::storeValues($dao, $optionValue[$dao->id]);
         // form all action links
         $action = array_sum(array_keys($this->links()));
         if ($dao->is_default) {
             $optionValue[$dao->id]['default_value'] = '[x]';
         }
         //do not show default option for email/postal greeting and addressee, CRM-4575
         if (!in_array($this->_gName, array('email_greeting', 'postal_greeting', 'addressee'))) {
             $this->assign('showIsDefault', TRUE);
         }
         // update enable/disable links depending on if it is is_reserved or is_active
         if ($dao->is_reserved) {
             $action = CRM_Core_Action::UPDATE;
         } else {
             if ($dao->is_active) {
                 $action -= CRM_Core_Action::ENABLE;
             } else {
                 $action -= CRM_Core_Action::DISABLE;
             }
             if ($this->_gName == 'encounter_medium' && in_array($dao->value, $mediumIds) || $this->_gName == 'case_status' && in_array($dao->value, $caseStatusIds) || $this->_gName == 'case_type' && in_array($dao->value, $caseTypeIds)) {
                 $action -= CRM_Core_Action::DELETE;
             }
         }
         $optionValue[$dao->id]['action'] = CRM_Core_Action::formLink(self::links(), $action, array('id' => $dao->id, 'gid' => $this->_gid));
     }
     $this->assign('rows', $optionValue);
 }
コード例 #23
0
ファイル: OptionGroup.php プロジェクト: kidaa30/yes
 /**
  * Creates a new option group with the passed in values.
  * @TODO: Should update the group if it already exists intelligently, so multi-lingual is
  * not messed up. Currently deletes the old group
  *
  * @param string $groupName
  *   The name of the option group - make sure there is no conflict.
  * @param array $values
  *   The associative array that has information on the option values.
  *                          the keys of this array are:
  *                          string 'title'       (required)
  *                          string 'value'       (required)
  *                          string 'name'        (optional)
  *                          string 'description' (optional)
  *                          int    'weight'      (optional) - the order in which the value are displayed
  *                          bool   'is_default'  (optional) - is this the default one to display when rendered in form
  *                          bool   'is_active'   (optional) - should this element be rendered
  * @param int $defaultID
  *   (reference) - the option value ID of the default element (if set) is returned else 'null'.
  * @param null $groupTitle
  *   The optional label of the option group else set to group name.
  *
  *
  * @return int
  *   the option group ID
  */
 public static function createAssoc($groupName, &$values, &$defaultID, $groupTitle = NULL)
 {
     self::deleteAssoc($groupName);
     if (!empty($values)) {
         $group = new CRM_Core_DAO_OptionGroup();
         $group->name = $groupName;
         $group->title = empty($groupTitle) ? $groupName : $groupTitle;
         $group->is_reserved = 1;
         $group->is_active = 1;
         $group->save();
         foreach ($values as $v) {
             $value = new CRM_Core_DAO_OptionValue();
             $value->option_group_id = $group->id;
             $value->label = $v['label'];
             $value->value = $v['value'];
             $value->name = CRM_Utils_Array::value('name', $v);
             $value->description = CRM_Utils_Array::value('description', $v);
             $value->weight = CRM_Utils_Array::value('weight', $v);
             $value->is_default = CRM_Utils_Array::value('is_default', $v);
             $value->is_active = CRM_Utils_Array::value('is_active', $v);
             $value->save();
             if ($value->is_default) {
                 $defaultID = $value->id;
             }
         }
     } else {
         return $defaultID = 'null';
     }
     return $group->id;
 }
コード例 #24
0
 static function updateCiviACLRole(&$params, $op)
 {
     $optionGroupID = CRM_Core_DAO::getFieldValue('CRM_Core_DAO_OptionGroup', 'acl_role', 'id', 'name');
     $dao = new CRM_Core_DAO_OptionValue();
     $dao->option_group_id = $optionGroupID;
     $dao->description = $params['source'];
     if ($op == 'delete') {
         $dao->delete();
         return;
     }
     $dao->label = $params['title'];
     $dao->is_active = 1;
     $weightParams = array('option_group_id' => $optionGroupID);
     $dao->weight = CRM_Utils_Weight::getDefaultWeight('CRM_Core_DAO_OptionValue', $weightParams);
     $dao->value = CRM_Utils_Weight::getDefaultWeight('CRM_Core_DAO_OptionValue', $weightParams, 'value');
     $query = "\nSELECT v.id\n  FROM civicrm_option_value v\n WHERE v.option_group_id = %1\n   AND v.description     = %2\n";
     $queryParams = array(1 => array($optionGroupID, 'Integer'), 2 => array($params['source'], 'String'));
     $dao->id = CRM_Core_DAO::singleValueQuery($query, $queryParams);
     $dao->save();
     $params['acl_role_id'] = $dao->value;
 }
コード例 #25
0
function _civicrm_api3_pcpteams_getCustomData(&$params)
{
    $result = array();
    foreach ($params as $pcpId => $pcpValues) {
        foreach ($pcpValues as $fieldName => $values) {
            $explodeFieldName = explode('_', $fieldName);
            if ($explodeFieldName[0] == 'custom') {
                $column_name = CRM_Core_DAO::getFieldValue('CRM_Core_DAO_CustomField', $explodeFieldName[1], 'column_name');
                $params[$pcpId][$column_name] = $values;
                if ($column_name == 'team_pcp_id') {
                    $params[$pcpId]['team_pcp_name'] = CRM_Core_DAO::getFieldValue('CRM_PCP_DAO_PCP', $values, 'title');
                } elseif (isset($explodeFieldName[2]) && $explodeFieldName[2] == 'id') {
                    $column_name = str_replace('id', 'name', $column_name);
                    $params[$pcpId][$column_name] = $pcpValues['custom_' . $explodeFieldName[1]];
                } else {
                    $column_name .= '_label';
                    $ogId = CRM_Core_DAO::getFieldValue('CRM_Core_DAO_CustomField', $explodeFieldName[1], 'option_group_id');
                    $ovDao = new CRM_Core_DAO_OptionValue();
                    $ovDao->option_group_id = $ogId;
                    $ovDao->value = $values;
                    $ovDao->find(TRUE);
                    $params[$pcpId][$column_name] = $ovDao->label;
                }
            }
        }
    }
}
コード例 #26
0
 /**
  * updates options values weights.
  *
  * @param int   $opGroupIde option group id.
  * @param array $opWeights  options value , weight pair
  *
  * @return void
  * @access public
  * @static
  */
 static function updateOptionWeights($opGroupId, $opWeights)
 {
     if (!is_array($opWeights) || empty($opWeights)) {
         return;
     }
     foreach ($opWeights as $opValue => $opWeight) {
         $optionValue = new CRM_Core_DAO_OptionValue();
         $optionValue->option_group_id = $opGroupId;
         $optionValue->value = $opValue;
         if ($optionValue->find(true)) {
             $optionValue->weight = $opWeight;
             $optionValue->save();
         }
         $optionValue->free();
     }
 }