Commit | Line | Data |
---|---|---|
6a488035 TO |
1 | <?php |
2 | /* | |
3 | +--------------------------------------------------------------------+ | |
39de6fd5 | 4 | | CiviCRM version 4.6 | |
6a488035 | 5 | +--------------------------------------------------------------------+ |
06b69b18 | 6 | | Copyright CiviCRM LLC (c) 2004-2014 | |
6a488035 TO |
7 | +--------------------------------------------------------------------+ |
8 | | This file is a part of CiviCRM. | | |
9 | | | | |
10 | | CiviCRM is free software; you can copy, modify, and distribute it | | |
11 | | under the terms of the GNU Affero General Public License | | |
12 | | Version 3, 19 November 2007 and the CiviCRM Licensing Exception. | | |
13 | | | | |
14 | | CiviCRM is distributed in the hope that it will be useful, but | | |
15 | | WITHOUT ANY WARRANTY; without even the implied warranty of | | |
16 | | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. | | |
17 | | See the GNU Affero General Public License for more details. | | |
18 | | | | |
19 | | You should have received a copy of the GNU Affero General Public | | |
20 | | License and the CiviCRM Licensing Exception along | | |
21 | | with this program; if not, contact CiviCRM LLC | | |
22 | | at info[AT]civicrm[DOT]org. If you have questions about the | | |
23 | | GNU Affero General Public License or the licensing of CiviCRM, | | |
24 | | see the CiviCRM license FAQ at http://civicrm.org/licensing | | |
25 | +--------------------------------------------------------------------+ | |
26 | */ | |
27 | ||
28 | /** | |
29 | * | |
30 | * @package CRM | |
06b69b18 | 31 | * @copyright CiviCRM LLC (c) 2004-2014 |
6a488035 TO |
32 | * $Id$ |
33 | * | |
34 | */ | |
35 | ||
36 | /** | |
37 | * form to process actions on the set aspect of Custom Data | |
38 | */ | |
39 | class CRM_Custom_Form_Group extends CRM_Core_Form { | |
40 | ||
41 | /** | |
100fef9d | 42 | * The set id saved to the session for an update |
6a488035 TO |
43 | * |
44 | * @var int | |
6a488035 TO |
45 | */ |
46 | protected $_id; | |
47 | ||
48 | /** | |
49 | * set is empty or not | |
50 | * | |
51 | * @var bool | |
6a488035 TO |
52 | */ |
53 | protected $_isGroupEmpty = TRUE; | |
54 | ||
55 | /** | |
100fef9d | 56 | * Array of existing subtypes set for a custom set |
6a488035 TO |
57 | * |
58 | * @var array | |
6a488035 TO |
59 | */ |
60 | protected $_subtypes = array(); | |
61 | ||
62 | /** | |
100fef9d | 63 | * Array of default params |
6a488035 TO |
64 | * |
65 | * @var array | |
6a488035 TO |
66 | */ |
67 | protected $_defaults = array(); | |
68 | ||
69 | /** | |
100fef9d | 70 | * Set variables up before form is built |
6a488035 | 71 | * |
6a488035 TO |
72 | * |
73 | * @return void | |
6a488035 TO |
74 | */ |
75 | public function preProcess() { | |
76 | // current set id | |
77 | $this->_id = $this->get('id'); | |
78 | ||
148c89c8 | 79 | if ($this->_id && $isReserved = CRM_Core_DAO::getFieldValue('CRM_Core_DAO_CustomGroup', $this->_id, 'is_reserved', 'id')) { |
e89941dc | 80 | CRM_Core_Error::fatal("You cannot edit the settings of a reserved custom field-set."); |
d06700a7 | 81 | } |
6a488035 TO |
82 | // setting title for html page |
83 | if ($this->_action == CRM_Core_Action::UPDATE) { | |
84 | $title = CRM_Core_BAO_CustomGroup::getTitle($this->_id); | |
85 | CRM_Utils_System::setTitle(ts('Edit %1', array(1 => $title))); | |
86 | } | |
87 | elseif ($this->_action == CRM_Core_Action::VIEW) { | |
88 | $title = CRM_Core_BAO_CustomGroup::getTitle($this->_id); | |
89 | CRM_Utils_System::setTitle(ts('Preview %1', array(1 => $title))); | |
90 | } | |
91 | else { | |
92 | CRM_Utils_System::setTitle(ts('New Custom Field Set')); | |
93 | } | |
94 | ||
95 | if (isset($this->_id)) { | |
96 | $params = array('id' => $this->_id); | |
97 | CRM_Core_BAO_CustomGroup::retrieve($params, $this->_defaults); | |
98 | ||
99 | $subExtends = CRM_Utils_Array::value('extends_entity_column_value', $this->_defaults); | |
100 | if (!empty($subExtends)) { | |
101 | $this->_subtypes = explode(CRM_Core_DAO::VALUE_SEPARATOR, substr($subExtends, 1, -1)); | |
102 | } | |
103 | } | |
104 | } | |
105 | ||
106 | /** | |
100fef9d | 107 | * Global form rule |
6a488035 | 108 | * |
c4ca4892 TO |
109 | * @param array $fields |
110 | * The input form values. | |
111 | * @param array $files | |
112 | * The uploaded files if any. | |
dd244018 EM |
113 | * @param $self |
114 | * | |
6a488035 | 115 | * |
72b3a70c CW |
116 | * @return bool|array |
117 | * true if no errors, else array of errors | |
6a488035 | 118 | */ |
00be9182 | 119 | public static function formRule($fields, $files, $self) { |
6a488035 TO |
120 | $errors = array(); |
121 | ||
122 | //validate group title as well as name. | |
353ffa53 TO |
123 | $title = $fields['title']; |
124 | $name = CRM_Utils_String::munge($title, '_', 64); | |
125 | $query = 'select count(*) from civicrm_custom_group where ( name like %1 OR title like %2 ) and id != %3'; | |
e8646905 | 126 | $grpCnt = CRM_Core_DAO::singleValueQuery($query, array( |
353ffa53 TO |
127 | 1 => array($name, 'String'), |
128 | 2 => array($title, 'String'), | |
129 | 3 => array((int) $self->_id, 'Integer'), | |
130 | )); | |
6a488035 TO |
131 | if ($grpCnt) { |
132 | $errors['title'] = ts('Custom group \'%1\' already exists in Database.', array(1 => $title)); | |
133 | } | |
134 | ||
a7488080 | 135 | if (!empty($fields['extends'][1])) { |
6a488035 TO |
136 | if (in_array('', $fields['extends'][1]) && count($fields['extends'][1]) > 1) { |
137 | $errors['extends'] = ts("Cannot combine other option with 'Any'."); | |
138 | } | |
139 | } | |
140 | ||
141 | if (empty($fields['extends'][0])) { | |
142 | $errors['extends'] = ts("You need to select the type of record that this set of custom fields is applicable for."); | |
143 | } | |
144 | ||
145 | $extends = array('Activity', 'Relationship', 'Group', 'Contribution', 'Membership', 'Event', 'Participant'); | |
146 | if (in_array($fields['extends'][0], $extends) && $fields['style'] == 'Tab') { | |
147 | $errors['style'] = ts("Display Style should be Inline for this Class"); | |
148 | $self->assign('showStyle', TRUE); | |
149 | } | |
150 | ||
a7488080 | 151 | if (!empty($fields['is_multiple'])) { |
e8646905 | 152 | $self->assign('showMultiple', TRUE); |
6a488035 TO |
153 | } |
154 | ||
b05a0fb6 | 155 | if (empty($fields['is_multiple']) && $fields['style'] == 'Tab with table') { |
e232751e | 156 | $errors['style'] = ts("Display Style 'Tab with table' is only supported for multiple-record custom field sets."); |
b05a0fb6 PJ |
157 | } |
158 | ||
6a488035 TO |
159 | //checks the given custom set doesnot start with digit |
160 | $title = $fields['title']; | |
161 | if (!empty($title)) { | |
162 | // gives the ascii value | |
163 | $asciiValue = ord($title{0}); | |
164 | if ($asciiValue >= 48 && $asciiValue <= 57) { | |
5ab78070 | 165 | $errors['title'] = ts("Name cannot not start with a digit"); |
6a488035 TO |
166 | } |
167 | } | |
168 | ||
169 | return empty($errors) ? TRUE : $errors; | |
170 | } | |
171 | ||
172 | /** | |
dc195289 | 173 | * add the rules (mainly global rules) for form. |
6a488035 TO |
174 | * All local rules are added near the element |
175 | * | |
6a488035 TO |
176 | * |
177 | * @return void | |
6a488035 TO |
178 | * @see valid_date |
179 | */ | |
00be9182 | 180 | public function addRules() { |
6a488035 TO |
181 | $this->addFormRule(array('CRM_Custom_Form_Group', 'formRule'), $this); |
182 | } | |
183 | ||
184 | /** | |
c490a46a | 185 | * Build the form object |
6a488035 | 186 | * |
6a488035 TO |
187 | * |
188 | * @return void | |
6a488035 TO |
189 | */ |
190 | public function buildQuickForm() { | |
191 | $this->applyFilter('__ALL__', 'trim'); | |
192 | ||
193 | $attributes = CRM_Core_DAO::getAttribute('CRM_Core_DAO_CustomGroup'); | |
194 | ||
195 | //title | |
196 | $this->add('text', 'title', ts('Set Name'), $attributes['title'], TRUE); | |
197 | ||
198 | //Fix for code alignment, CRM-3058 | |
199 | $contactTypes = array('Contact', 'Individual', 'Household', 'Organization'); | |
200 | $this->assign('contactTypes', json_encode($contactTypes)); | |
201 | ||
b6b6d6cc | 202 | $sel1 = array("" => ts("- select -")) + CRM_Core_SelectValues::customGroupExtends(); |
353ffa53 | 203 | $sel2 = array(); |
6a488035 TO |
204 | $activityType = CRM_Core_PseudoConstant::activityType(FALSE, TRUE, FALSE, 'label', TRUE); |
205 | ||
353ffa53 TO |
206 | $eventType = CRM_Core_OptionGroup::values('event_type'); |
207 | $grantType = CRM_Core_OptionGroup::values('grant_type'); | |
208 | $campaignTypes = CRM_Campaign_PseudoConstant::campaignType(); | |
209 | $membershipType = CRM_Member_BAO_MembershipType::getMembershipTypes(FALSE); | |
6a488035 | 210 | $participantRole = CRM_Core_OptionGroup::values('participant_role'); |
353ffa53 TO |
211 | $relTypeInd = CRM_Contact_BAO_Relationship::getContactRelationshipType(NULL, 'null', NULL, 'Individual'); |
212 | $relTypeOrg = CRM_Contact_BAO_Relationship::getContactRelationshipType(NULL, 'null', NULL, 'Organization'); | |
213 | $relTypeHou = CRM_Contact_BAO_Relationship::getContactRelationshipType(NULL, 'null', NULL, 'Household'); | |
6a488035 TO |
214 | |
215 | ksort($sel1); | |
216 | asort($activityType); | |
217 | asort($eventType); | |
218 | asort($grantType); | |
219 | asort($membershipType); | |
220 | asort($participantRole); | |
221 | $allRelationshipType = array(); | |
222 | $allRelationshipType = array_merge($relTypeInd, $relTypeOrg); | |
223 | $allRelationshipType = array_merge($allRelationshipType, $relTypeHou); | |
224 | ||
225 | //adding subtype specific relationships CRM-5256 | |
226 | $subTypes = CRM_Contact_BAO_ContactType::subTypeInfo(); | |
227 | ||
228 | foreach ($subTypes as $subType => $val) { | |
229 | $subTypeRelationshipTypes = CRM_Contact_BAO_Relationship::getContactRelationshipType(NULL, NULL, NULL, $val['parent'], | |
230 | FALSE, 'label', TRUE, $subType | |
231 | ); | |
232 | $allRelationshipType = array_merge($allRelationshipType, $subTypeRelationshipTypes); | |
233 | } | |
234 | ||
235 | $sel2['Event'] = $eventType; | |
236 | $sel2['Grant'] = $grantType; | |
237 | $sel2['Activity'] = $activityType; | |
238 | $sel2['Campaign'] = $campaignTypes; | |
239 | $sel2['Membership'] = $membershipType; | |
240 | $sel2['ParticipantRole'] = $participantRole; | |
241 | $sel2['ParticipantEventName'] = CRM_Event_PseudoConstant::event(NULL, FALSE, "( is_template IS NULL OR is_template != 1 )"); | |
242 | $sel2['ParticipantEventType'] = $eventType; | |
879db7b0 | 243 | $sel2['Contribution'] = CRM_Contribute_PseudoConstant::financialType(); |
6a488035 TO |
244 | $sel2['Relationship'] = $allRelationshipType; |
245 | ||
246 | $sel2['Individual'] = CRM_Contact_BAO_ContactType::subTypePairs('Individual', FALSE, NULL); | |
247 | $sel2['Household'] = CRM_Contact_BAO_ContactType::subTypePairs('Household', FALSE, NULL); | |
248 | $sel2['Organization'] = CRM_Contact_BAO_ContactType::subTypePairs('Organization', FALSE, NULL); | |
249 | ||
250 | CRM_Core_BAO_CustomGroup::getExtendedObjectTypes($sel2); | |
251 | ||
252 | foreach ($sel2 as $main => $sub) { | |
253 | if (!empty($sel2[$main])) { | |
254 | if ($main == 'Relationship') { | |
255 | $relName = self::getFormattedList($sel2[$main]); | |
256 | $sel2[$main] = array( | |
3bdca100 | 257 | '' => ts("- Any -"), |
258 | ) + $relName; | |
6a488035 TO |
259 | } |
260 | else { | |
261 | $sel2[$main] = array( | |
3bdca100 | 262 | '' => ts("- Any -"), |
263 | ) + $sel2[$main]; | |
6a488035 TO |
264 | } |
265 | } | |
266 | } | |
267 | ||
268 | $cSubTypes = CRM_Core_Component::contactSubTypes(); | |
269 | ||
270 | if (!empty($cSubTypes)) { | |
271 | $contactSubTypes = array(); | |
272 | foreach ($cSubTypes as $key => $value) { | |
273 | $contactSubTypes[$key] = $key; | |
274 | } | |
275 | $sel2['Contact'] = array( | |
b6b6d6cc | 276 | "" => ("- Any -"), |
3bdca100 | 277 | ) + $contactSubTypes; |
6a488035 TO |
278 | } |
279 | else { | |
280 | if (!isset($this->_id)) { | |
281 | $formName = 'document.forms.' . $this->_name; | |
282 | ||
283 | $js = "<script type='text/javascript'>\n"; | |
284 | $js .= "{$formName}['extends_1'].style.display = 'none';\n"; | |
285 | $js .= "</script>"; | |
286 | $this->assign('initHideBlocks', $js); | |
287 | } | |
288 | } | |
289 | ||
290 | $sel = &$this->add('hierselect', | |
291 | 'extends', | |
292 | ts('Used For'), | |
293 | array( | |
6a488035 | 294 | 'name' => 'extends[0]', |
21dfd5f5 | 295 | 'style' => 'vertical-align: top;', |
6a488035 TO |
296 | ), |
297 | TRUE | |
298 | ); | |
299 | $sel->setOptions(array($sel1, $sel2)); | |
300 | if (is_a($sel->_elements[1], 'HTML_QuickForm_select')) { | |
301 | // make second selector a multi-select - | |
302 | $sel->_elements[1]->setMultiple(TRUE); | |
303 | $sel->_elements[1]->setSize(5); | |
304 | } | |
305 | if ($this->_action == CRM_Core_Action::UPDATE) { | |
306 | $subName = CRM_Utils_Array::value('extends_entity_column_id', $this->_defaults); | |
307 | if ($this->_defaults['extends'] == 'Participant') { | |
308 | if ($subName == 1) { | |
309 | $this->_defaults['extends'] = 'ParticipantRole'; | |
310 | } | |
311 | elseif ($subName == 2) { | |
312 | $this->_defaults['extends'] = 'ParticipantEventName'; | |
313 | } | |
314 | elseif ($subName == 3) { | |
315 | $this->_defaults['extends'] = 'ParticipantEventType'; | |
316 | } | |
317 | } | |
318 | ||
319 | //allow to edit settings if custom set is empty CRM-5258 | |
320 | $this->_isGroupEmpty = CRM_Core_BAO_CustomGroup::isGroupEmpty($this->_id); | |
321 | if (!$this->_isGroupEmpty) { | |
322 | if (!empty($this->_subtypes)) { | |
323 | // we want to allow adding / updating subtypes for this case, | |
324 | // and therefore freeze the first selector only. | |
325 | $sel->_elements[0]->freeze(); | |
326 | } | |
327 | else { | |
328 | // freeze both the selectors | |
329 | $sel->freeze(); | |
330 | } | |
331 | } | |
332 | $this->assign('isCustomGroupEmpty', $this->_isGroupEmpty); | |
333 | $this->assign('gid', $this->_id); | |
334 | } | |
335 | $this->assign('defaultSubtypes', json_encode($this->_subtypes)); | |
336 | ||
337 | // help text | |
338 | $this->addWysiwyg('help_pre', ts('Pre-form Help'), $attributes['help_pre']); | |
339 | $this->addWysiwyg('help_post', ts('Post-form Help'), $attributes['help_post']); | |
340 | ||
341 | // weight | |
342 | $this->add('text', 'weight', ts('Order'), $attributes['weight'], TRUE); | |
343 | $this->addRule('weight', ts('is a numeric field'), 'numeric'); | |
344 | ||
345 | // display style | |
346 | $this->add('select', 'style', ts('Display Style'), CRM_Core_SelectValues::customGroupStyle()); | |
347 | ||
348 | // is this set collapsed or expanded ? | |
349 | $this->addElement('checkbox', 'collapse_display', ts('Collapse this set on initial display')); | |
350 | ||
351 | // is this set collapsed or expanded ? in advanced search | |
352 | $this->addElement('checkbox', 'collapse_adv_display', ts('Collapse this set in Advanced Search')); | |
353 | ||
354 | // is this set active ? | |
355 | $this->addElement('checkbox', 'is_active', ts('Is this Custom Data Set active?')); | |
356 | ||
357 | // does this set have multiple record? | |
d9aa50a7 PJ |
358 | $multiple = $this->addElement('checkbox', 'is_multiple', |
359 | ts('Does this Custom Field Set allow multiple records?'), NULL); | |
6a488035 TO |
360 | |
361 | // $min_multiple = $this->add('text', 'min_multiple', ts('Minimum number of multiple records'), $attributes['min_multiple'] ); | |
362 | // $this->addRule('min_multiple', ts('is a numeric field') , 'numeric'); | |
363 | ||
364 | $max_multiple = $this->add('text', 'max_multiple', ts('Maximum number of multiple records'), $attributes['max_multiple']); | |
365 | $this->addRule('max_multiple', ts('is a numeric field'), 'numeric'); | |
366 | ||
367 | //allow to edit settings if custom set is empty CRM-5258 | |
368 | $this->assign('isGroupEmpty', $this->_isGroupEmpty); | |
369 | if (!$this->_isGroupEmpty) { | |
370 | $multiple->freeze(); | |
371 | //$min_multiple->freeze(); | |
372 | $max_multiple->freeze(); | |
373 | } | |
374 | ||
375 | $this->assign('showStyle', FALSE); | |
376 | $this->assign('showMultiple', FALSE); | |
377 | $buttons = array( | |
378 | array( | |
379 | 'type' => 'next', | |
380 | 'name' => ts('Save'), | |
381 | 'spacing' => ' ', | |
382 | 'isDefault' => TRUE, | |
383 | ), | |
384 | array( | |
385 | 'type' => 'cancel', | |
386 | 'name' => ts('Cancel'), | |
387 | ), | |
388 | ); | |
389 | if (!$this->_isGroupEmpty && !empty($this->_subtypes)) { | |
390 | $buttons[0]['js'] = array('onclick' => "return warnDataLoss()"); | |
391 | } | |
392 | $this->addButtons($buttons); | |
393 | ||
b6b6d6cc | 394 | // TODO: Is this condition ever true? Can this code be removed? |
6a488035 TO |
395 | if ($this->_action & CRM_Core_Action::VIEW) { |
396 | $this->freeze(); | |
397 | $this->addElement('button', 'done', ts('Done'), array('onclick' => "location.href='civicrm/admin/custom/group?reset=1&action=browse'")); | |
398 | } | |
399 | } | |
400 | ||
401 | /** | |
c490a46a | 402 | * Set default values for the form. Note that in edit/view mode |
6a488035 TO |
403 | * the default values are retrieved from the database |
404 | * | |
6a488035 | 405 | * |
a6c01b45 CW |
406 | * @return array |
407 | * array of default values | |
6a488035 | 408 | */ |
00be9182 | 409 | public function setDefaultValues() { |
6a488035 TO |
410 | $defaults = &$this->_defaults; |
411 | $this->assign('showMaxMultiple', TRUE); | |
412 | if ($this->_action == CRM_Core_Action::ADD) { | |
413 | $defaults['weight'] = CRM_Utils_Weight::getDefaultWeight('CRM_Core_DAO_CustomGroup'); | |
414 | ||
415 | $defaults['is_multiple'] = $defaults['min_multiple'] = 0; | |
416 | $defaults['is_active'] = $defaults['collapse_display'] = 1; | |
417 | $defaults['style'] = 'Inline'; | |
418 | } | |
a7488080 | 419 | elseif (empty($defaults['max_multiple']) && !$this->_isGroupEmpty) { |
6a488035 TO |
420 | $this->assign('showMaxMultiple', FALSE); |
421 | } | |
422 | ||
b05a0fb6 | 423 | if (($this->_action & CRM_Core_Action::UPDATE) && !empty($defaults['is_multiple'])) { |
5a205b89 PJ |
424 | $defaults['collapse_display'] = 0; |
425 | } | |
426 | ||
6a488035 TO |
427 | if (isset($defaults['extends'])) { |
428 | $extends = $defaults['extends']; | |
429 | unset($defaults['extends']); | |
430 | ||
431 | $defaults['extends'][0] = $extends; | |
432 | ||
433 | if (!empty($this->_subtypes)) { | |
434 | $defaults['extends'][1] = $this->_subtypes; | |
435 | } | |
436 | else { | |
437 | $defaults['extends'][1] = array(0 => ''); | |
438 | } | |
439 | ||
6a488035 TO |
440 | if ($extends == 'Relationship' && !empty($this->_subtypes)) { |
441 | $relationshipDefaults = array(); | |
442 | foreach ($defaults['extends'][1] as $donCare => $rel_type_id) { | |
443 | $relationshipDefaults[] = $rel_type_id; | |
444 | } | |
445 | ||
446 | $defaults['extends'][1] = $relationshipDefaults; | |
447 | } | |
448 | } | |
449 | ||
450 | return $defaults; | |
451 | } | |
452 | ||
453 | /** | |
454 | * Process the form | |
455 | * | |
6a488035 TO |
456 | * |
457 | * @return void | |
6a488035 TO |
458 | */ |
459 | public function postProcess() { | |
460 | // get the submitted form values. | |
461 | $params = $this->controller->exportValues('Group'); | |
462 | $params['overrideFKConstraint'] = 0; | |
463 | if ($this->_action & CRM_Core_Action::UPDATE) { | |
464 | $params['id'] = $this->_id; | |
465 | if ($this->_defaults['extends'][0] != $params['extends'][0]) { | |
466 | $params['overrideFKConstraint'] = 1; | |
467 | } | |
468 | ||
469 | if (!empty($this->_subtypes)) { | |
470 | $subtypesToBeRemoved = array_diff($this->_subtypes, array_intersect($this->_subtypes, $params['extends'][1])); | |
471 | CRM_Contact_BAO_ContactType::deleteCustomRowsOfSubtype($this->_id, $subtypesToBeRemoved); | |
472 | } | |
473 | } | |
474 | elseif ($this->_action & CRM_Core_Action::ADD) { | |
475 | //new custom set , so lets set the created_id | |
476 | $session = CRM_Core_Session::singleton(); | |
477 | $params['created_id'] = $session->get('userID'); | |
478 | $params['created_date'] = date('YmdHis'); | |
479 | } | |
480 | ||
481 | $group = CRM_Core_BAO_CustomGroup::create($params); | |
482 | ||
483 | // reset the cache | |
484 | CRM_Core_BAO_Cache::deleteGroup('contact fields'); | |
485 | ||
486 | if ($this->_action & CRM_Core_Action::UPDATE) { | |
487 | CRM_Core_Session::setStatus(ts('Your custom field set \'%1 \' has been saved.', array(1 => $group->title)), ts('Saved'), 'success'); | |
488 | } | |
489 | else { | |
704f21c0 CW |
490 | // Jump directly to adding a field if popups are disabled |
491 | $action = CRM_Core_Resources::singleton()->ajaxPopupsEnabled ? '' : '/add'; | |
6f231148 | 492 | $url = CRM_Utils_System::url("civicrm/admin/custom/group/field$action", 'reset=1&new=1&gid=' . $group->id . '&action=' . ($action ? 'add' : 'browse')); |
6a488035 | 493 | CRM_Core_Session::setStatus(ts("Your custom field set '%1' has been added. You can add custom fields now.", |
353ffa53 TO |
494 | array(1 => $group->title) |
495 | ), ts('Saved'), 'success'); | |
6a488035 TO |
496 | $session = CRM_Core_Session::singleton(); |
497 | $session->replaceUserContext($url); | |
498 | } | |
499 | ||
500 | // prompt Drupal Views users to update $db_prefix in settings.php, if necessary | |
501 | global $db_prefix; | |
502 | $config = CRM_Core_Config::singleton(); | |
503 | if (is_array($db_prefix) && $config->userSystem->is_drupal && module_exists('views')) { | |
504 | // get table_name for each custom group | |
505 | $tables = array(); | |
353ffa53 | 506 | $sql = "SELECT table_name FROM civicrm_custom_group WHERE is_active = 1"; |
6a488035 TO |
507 | $result = CRM_Core_DAO::executeQuery($sql); |
508 | while ($result->fetch()) { | |
509 | $tables[$result->table_name] = $result->table_name; | |
510 | } | |
511 | ||
512 | // find out which tables are missing from the $db_prefix array | |
513 | $missingTableNames = array_diff_key($tables, $db_prefix); | |
514 | ||
515 | if (!empty($missingTableNames)) { | |
516 | 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'.", | |
353ffa53 TO |
517 | array(1 => implode(', ', $missingTableNames)) |
518 | ), ts('Note'), 'info'); | |
6a488035 TO |
519 | } |
520 | } | |
521 | } | |
522 | ||
e0ef6999 | 523 | /** |
c490a46a CW |
524 | * Return a formatted list of relationship name. |
525 | * | |
c4ca4892 TO |
526 | * @param array $list |
527 | * Array of relationship name. | |
e0ef6999 | 528 | * |
a6c01b45 | 529 | * @return array |
16b10e64 | 530 | * Array of relationship name. |
e0ef6999 | 531 | */ |
00be9182 | 532 | public static function getFormattedList(&$list) { |
6a488035 TO |
533 | $relName = array(); |
534 | ||
9382624d | 535 | foreach ($list as $listItemKey => $itemValue) { |
536 | // Extract the relationship ID. | |
537 | $key = substr($listItemKey, 0, strpos($listItemKey, '_')); | |
6a488035 | 538 | if (isset($list["{$key}_b_a"])) { |
9382624d | 539 | $relName["$key"] = $list["{$key}_a_b"]; |
540 | // Are the two labels different? | |
6a488035 TO |
541 | if ($list["{$key}_a_b"] != $list["{$key}_b_a"]) { |
542 | $relName["$key"] = $list["{$key}_a_b"] . ' / ' . $list["{$key}_b_a"]; | |
543 | } | |
544 | unset($list["{$key}_b_a"]); | |
9382624d | 545 | unset($list["{$key}_a_b"]); |
6a488035 TO |
546 | } |
547 | else { | |
9382624d | 548 | // If no '_b_a' label exists save the '_a_b' one and unset it from the list |
6a488035 | 549 | $relName["{$key}"] = $list["{$key}_a_b"]; |
9382624d | 550 | unset($list["{$key}_a_b"]); |
6a488035 TO |
551 | } |
552 | } | |
553 | return $relName; | |
554 | } | |
555 | } |