_id = $this->get('id'); if ($this->_id && $isReserved = CRM_Core_DAO::getFieldValue('CRM_Core_DAO_CustomGroup', $this->_id, 'is_reserved', 'id')) { CRM_Core_Error::fatal("You cannot edit the settings of a reserved custom field-set."); } // setting title for html page if ($this->_action == CRM_Core_Action::UPDATE) { $title = CRM_Core_BAO_CustomGroup::getTitle($this->_id); CRM_Utils_System::setTitle(ts('Edit %1', array(1 => $title))); } elseif ($this->_action == CRM_Core_Action::VIEW) { $title = CRM_Core_BAO_CustomGroup::getTitle($this->_id); CRM_Utils_System::setTitle(ts('Preview %1', array(1 => $title))); } else { CRM_Utils_System::setTitle(ts('New Custom Field Set')); } if (isset($this->_id)) { $params = array('id' => $this->_id); CRM_Core_BAO_CustomGroup::retrieve($params, $this->_defaults); $subExtends = CRM_Utils_Array::value('extends_entity_column_value', $this->_defaults); if (!empty($subExtends)) { $this->_subtypes = explode(CRM_Core_DAO::VALUE_SEPARATOR, substr($subExtends, 1, -1)); } } } /** * Global form rule * * @param array $fields * The input form values. * @param array $files * The uploaded files if any. * @param $self * * * @return bool|array * true if no errors, else array of errors * @static */ public static function formRule($fields, $files, $self) { $errors = array(); //validate group title as well as name. $title = $fields['title']; $name = CRM_Utils_String::munge($title, '_', 64); $query = 'select count(*) from civicrm_custom_group where ( name like %1 OR title like %2 ) and id != %3'; $grpCnt = CRM_Core_DAO::singleValueQuery($query, array( 1 => array($name, 'String'), 2 => array($title, 'String'), 3 => array((int) $self->_id, 'Integer'), )); if ($grpCnt) { $errors['title'] = ts('Custom group \'%1\' already exists in Database.', array(1 => $title)); } if (!empty($fields['extends'][1])) { if (in_array('', $fields['extends'][1]) && count($fields['extends'][1]) > 1) { $errors['extends'] = ts("Cannot combine other option with 'Any'."); } } if (empty($fields['extends'][0])) { $errors['extends'] = ts("You need to select the type of record that this set of custom fields is applicable for."); } $extends = array('Activity', 'Relationship', 'Group', 'Contribution', 'Membership', 'Event', 'Participant'); if (in_array($fields['extends'][0], $extends) && $fields['style'] == 'Tab') { $errors['style'] = ts("Display Style should be Inline for this Class"); $self->assign('showStyle', TRUE); } if (!empty($fields['is_multiple'])) { $self->assign('showMultiple', TRUE); } if (empty($fields['is_multiple']) && $fields['style'] == 'Tab with table') { $errors['style'] = ts("Display Style 'Tab with table' is only supported for multiple-record custom field sets."); } //checks the given custom set doesnot start with digit $title = $fields['title']; if (!empty($title)) { // gives the ascii value $asciiValue = ord($title{0}); if ($asciiValue >= 48 && $asciiValue <= 57) { $errors['title'] = ts("Name cannot not start with a digit"); } } return empty($errors) ? TRUE : $errors; } /** * add the rules (mainly global rules) for form. * All local rules are added near the element * * @param null * * @return void * @see valid_date */ public function addRules() { $this->addFormRule(array('CRM_Custom_Form_Group', 'formRule'), $this); } /** * Build the form object * * @param null * * @return void */ public function buildQuickForm() { $this->applyFilter('__ALL__', 'trim'); $attributes = CRM_Core_DAO::getAttribute('CRM_Core_DAO_CustomGroup'); //title $this->add('text', 'title', ts('Set Name'), $attributes['title'], TRUE); //Fix for code alignment, CRM-3058 $contactTypes = array('Contact', 'Individual', 'Household', 'Organization'); $this->assign('contactTypes', json_encode($contactTypes)); $sel1 = array("" => "- select -") + CRM_Core_SelectValues::customGroupExtends(); $sel2 = array(); $activityType = CRM_Core_PseudoConstant::activityType(FALSE, TRUE, FALSE, 'label', TRUE); $eventType = CRM_Core_OptionGroup::values('event_type'); $grantType = CRM_Core_OptionGroup::values('grant_type'); $campaignTypes = CRM_Campaign_PseudoConstant::campaignType(); $membershipType = CRM_Member_BAO_MembershipType::getMembershipTypes(FALSE); $participantRole = CRM_Core_OptionGroup::values('participant_role'); $relTypeInd = CRM_Contact_BAO_Relationship::getContactRelationshipType(NULL, 'null', NULL, 'Individual'); $relTypeOrg = CRM_Contact_BAO_Relationship::getContactRelationshipType(NULL, 'null', NULL, 'Organization'); $relTypeHou = CRM_Contact_BAO_Relationship::getContactRelationshipType(NULL, 'null', NULL, 'Household'); ksort($sel1); asort($activityType); asort($eventType); asort($grantType); asort($membershipType); asort($participantRole); $allRelationshipType = array(); $allRelationshipType = array_merge($relTypeInd, $relTypeOrg); $allRelationshipType = array_merge($allRelationshipType, $relTypeHou); //adding subtype specific relationships CRM-5256 $subTypes = CRM_Contact_BAO_ContactType::subTypeInfo(); foreach ($subTypes as $subType => $val) { $subTypeRelationshipTypes = CRM_Contact_BAO_Relationship::getContactRelationshipType(NULL, NULL, NULL, $val['parent'], FALSE, 'label', TRUE, $subType ); $allRelationshipType = array_merge($allRelationshipType, $subTypeRelationshipTypes); } $sel2['Event'] = $eventType; $sel2['Grant'] = $grantType; $sel2['Activity'] = $activityType; $sel2['Campaign'] = $campaignTypes; $sel2['Membership'] = $membershipType; $sel2['ParticipantRole'] = $participantRole; $sel2['ParticipantEventName'] = CRM_Event_PseudoConstant::event(NULL, FALSE, "( is_template IS NULL OR is_template != 1 )"); $sel2['ParticipantEventType'] = $eventType; $sel2['Contribution'] = CRM_Contribute_PseudoConstant::financialType(); $sel2['Relationship'] = $allRelationshipType; $sel2['Individual'] = CRM_Contact_BAO_ContactType::subTypePairs('Individual', FALSE, NULL); $sel2['Household'] = CRM_Contact_BAO_ContactType::subTypePairs('Household', FALSE, NULL); $sel2['Organization'] = CRM_Contact_BAO_ContactType::subTypePairs('Organization', FALSE, NULL); CRM_Core_BAO_CustomGroup::getExtendedObjectTypes($sel2); foreach ($sel2 as $main => $sub) { if (!empty($sel2[$main])) { if ($main == 'Relationship') { $relName = self::getFormattedList($sel2[$main]); $sel2[$main] = array( '' => ts("- Any -") ) + $relName; } else { $sel2[$main] = array( '' => ts("- Any -") ) + $sel2[$main]; } } } $cSubTypes = CRM_Core_Component::contactSubTypes(); if (!empty($cSubTypes)) { $contactSubTypes = array(); foreach ($cSubTypes as $key => $value) { $contactSubTypes[$key] = $key; } $sel2['Contact'] = array( "" => "-- Any --" ) + $contactSubTypes; } else { if (!isset($this->_id)) { $formName = 'document.forms.' . $this->_name; $js = ""; $this->assign('initHideBlocks', $js); } } $sel = &$this->add('hierselect', 'extends', ts('Used For'), array( 'name' => 'extends[0]', 'style' => 'vertical-align: top;', ), TRUE ); $sel->setOptions(array($sel1, $sel2)); if (is_a($sel->_elements[1], 'HTML_QuickForm_select')) { // make second selector a multi-select - $sel->_elements[1]->setMultiple(TRUE); $sel->_elements[1]->setSize(5); } if ($this->_action == CRM_Core_Action::UPDATE) { $subName = CRM_Utils_Array::value('extends_entity_column_id', $this->_defaults); if ($this->_defaults['extends'] == 'Participant') { if ($subName == 1) { $this->_defaults['extends'] = 'ParticipantRole'; } elseif ($subName == 2) { $this->_defaults['extends'] = 'ParticipantEventName'; } elseif ($subName == 3) { $this->_defaults['extends'] = 'ParticipantEventType'; } } //allow to edit settings if custom set is empty CRM-5258 $this->_isGroupEmpty = CRM_Core_BAO_CustomGroup::isGroupEmpty($this->_id); if (!$this->_isGroupEmpty) { if (!empty($this->_subtypes)) { // we want to allow adding / updating subtypes for this case, // and therefore freeze the first selector only. $sel->_elements[0]->freeze(); } else { // freeze both the selectors $sel->freeze(); } } $this->assign('isCustomGroupEmpty', $this->_isGroupEmpty); $this->assign('gid', $this->_id); } $this->assign('defaultSubtypes', json_encode($this->_subtypes)); // help text $this->addWysiwyg('help_pre', ts('Pre-form Help'), $attributes['help_pre']); $this->addWysiwyg('help_post', ts('Post-form Help'), $attributes['help_post']); // weight $this->add('text', 'weight', ts('Order'), $attributes['weight'], TRUE); $this->addRule('weight', ts('is a numeric field'), 'numeric'); // display style $this->add('select', 'style', ts('Display Style'), CRM_Core_SelectValues::customGroupStyle()); // is this set collapsed or expanded ? $this->addElement('checkbox', 'collapse_display', ts('Collapse this set on initial display')); // is this set collapsed or expanded ? in advanced search $this->addElement('checkbox', 'collapse_adv_display', ts('Collapse this set in Advanced Search')); // is this set active ? $this->addElement('checkbox', 'is_active', ts('Is this Custom Data Set active?')); // does this set have multiple record? $multiple = $this->addElement('checkbox', 'is_multiple', ts('Does this Custom Field Set allow multiple records?'), NULL); // $min_multiple = $this->add('text', 'min_multiple', ts('Minimum number of multiple records'), $attributes['min_multiple'] ); // $this->addRule('min_multiple', ts('is a numeric field') , 'numeric'); $max_multiple = $this->add('text', 'max_multiple', ts('Maximum number of multiple records'), $attributes['max_multiple']); $this->addRule('max_multiple', ts('is a numeric field'), 'numeric'); //allow to edit settings if custom set is empty CRM-5258 $this->assign('isGroupEmpty', $this->_isGroupEmpty); if (!$this->_isGroupEmpty) { $multiple->freeze(); //$min_multiple->freeze(); $max_multiple->freeze(); } $this->assign('showStyle', FALSE); $this->assign('showMultiple', FALSE); $buttons = array( array( 'type' => 'next', 'name' => ts('Save'), 'spacing' => '         ', 'isDefault' => TRUE, ), array( 'type' => 'cancel', 'name' => ts('Cancel'), ), ); if (!$this->_isGroupEmpty && !empty($this->_subtypes)) { $buttons[0]['js'] = array('onclick' => "return warnDataLoss()"); } $this->addButtons($buttons); // views are implemented as frozen form if ($this->_action & CRM_Core_Action::VIEW) { $this->freeze(); $this->addElement('button', 'done', ts('Done'), array('onclick' => "location.href='civicrm/admin/custom/group?reset=1&action=browse'")); } } /** * Set default values for the form. Note that in edit/view mode * the default values are retrieved from the database * * @param null * * @return array * array of default values */ public function setDefaultValues() { $defaults = &$this->_defaults; $this->assign('showMaxMultiple', TRUE); if ($this->_action == CRM_Core_Action::ADD) { $defaults['weight'] = CRM_Utils_Weight::getDefaultWeight('CRM_Core_DAO_CustomGroup'); $defaults['is_multiple'] = $defaults['min_multiple'] = 0; $defaults['is_active'] = $defaults['collapse_display'] = 1; $defaults['style'] = 'Inline'; } elseif (empty($defaults['max_multiple']) && !$this->_isGroupEmpty) { $this->assign('showMaxMultiple', FALSE); } if (($this->_action & CRM_Core_Action::UPDATE) && !empty($defaults['is_multiple'])) { $defaults['collapse_display'] = 0; } if (isset($defaults['extends'])) { $extends = $defaults['extends']; unset($defaults['extends']); $defaults['extends'][0] = $extends; if (!empty($this->_subtypes)) { $defaults['extends'][1] = $this->_subtypes; } else { $defaults['extends'][1] = array(0 => ''); } if ($extends == 'Relationship' && !empty($this->_subtypes)) { $relationshipDefaults = array(); foreach ($defaults['extends'][1] as $donCare => $rel_type_id) { $relationshipDefaults[] = $rel_type_id; } $defaults['extends'][1] = $relationshipDefaults; } } return $defaults; } /** * Process the form * * @param null * * @return void */ public function postProcess() { // get the submitted form values. $params = $this->controller->exportValues('Group'); $params['overrideFKConstraint'] = 0; if ($this->_action & CRM_Core_Action::UPDATE) { $params['id'] = $this->_id; if ($this->_defaults['extends'][0] != $params['extends'][0]) { $params['overrideFKConstraint'] = 1; } if (!empty($this->_subtypes)) { $subtypesToBeRemoved = array_diff($this->_subtypes, array_intersect($this->_subtypes, $params['extends'][1])); CRM_Contact_BAO_ContactType::deleteCustomRowsOfSubtype($this->_id, $subtypesToBeRemoved); } } elseif ($this->_action & CRM_Core_Action::ADD) { //new custom set , so lets set the created_id $session = CRM_Core_Session::singleton(); $params['created_id'] = $session->get('userID'); $params['created_date'] = date('YmdHis'); } $group = CRM_Core_BAO_CustomGroup::create($params); // reset the cache CRM_Core_BAO_Cache::deleteGroup('contact fields'); if ($this->_action & CRM_Core_Action::UPDATE) { CRM_Core_Session::setStatus(ts('Your custom field set \'%1 \' has been saved.', array(1 => $group->title)), ts('Saved'), 'success'); } else { // Jump directly to adding a field if popups are disabled $action = CRM_Core_Resources::singleton()->ajaxPopupsEnabled ? '' : '/add'; $url = CRM_Utils_System::url("civicrm/admin/custom/group/field$action", 'reset=1&new=1&gid=' . $group->id . '&action=' . ($action ? 'add' : 'browse')); CRM_Core_Session::setStatus(ts("Your custom field set '%1' has been added. You can add custom fields now.", array(1 => $group->title) ), ts('Saved'), 'success'); $session = CRM_Core_Session::singleton(); $session->replaceUserContext($url); } // prompt Drupal Views users to update $db_prefix in settings.php, if necessary global $db_prefix; $config = CRM_Core_Config::singleton(); if (is_array($db_prefix) && $config->userSystem->is_drupal && module_exists('views')) { // get table_name for each custom group $tables = array(); $sql = "SELECT table_name FROM civicrm_custom_group WHERE is_active = 1"; $result = CRM_Core_DAO::executeQuery($sql); while ($result->fetch()) { $tables[$result->table_name] = $result->table_name; } // find out which tables are missing from the $db_prefix array $missingTableNames = array_diff_key($tables, $db_prefix); if (!empty($missingTableNames)) { CRM_Core_Session::setStatus(ts("To ensure that all of your custom data groups are available to Views, you may need to add the following key(s) to the db_prefix array in your settings.php file: '%1'.", array(1 => implode(', ', $missingTableNames)) ), ts('Note'), 'info'); } } } /** * Return a formatted list of relationship name. * * @param array $list * Array of relationship name. * * @return array * Array of relationship name. */ public static function getFormattedList(&$list) { $relName = array(); foreach ($list as $listItemKey => $itemValue) { // Extract the relationship ID. $key = substr($listItemKey, 0, strpos($listItemKey, '_')); if (isset($list["{$key}_b_a"])) { $relName["$key"] = $list["{$key}_a_b"]; // Are the two labels different? if ($list["{$key}_a_b"] != $list["{$key}_b_a"]) { $relName["$key"] = $list["{$key}_a_b"] . ' / ' . $list["{$key}_b_a"]; } unset($list["{$key}_b_a"]); unset($list["{$key}_a_b"]); } else { // If no '_b_a' label exists save the '_a_b' one and unset it from the list $relName["{$key}"] = $list["{$key}_a_b"]; unset($list["{$key}_a_b"]); } } return $relName; } }