tests/phpunit/CRM/Core/BAO/CustomFieldTest.php

   1 <?php
   2
   3 /**
   4  * Class CRM_Core_BAO_CustomFieldTest
   5  *
   6  * @group headless
   7  */
   8 class CRM_Core_BAO_CustomFieldTest extends CiviUnitTestCase {
   9
  10   use CRMTraits_Custom_CustomDataTrait;
  11
  12   protected $customFieldID;
  13
  14   /**
  15    * Clean up after test.
  16    *
  17    * @throws \Exception
  18    */
  19   public function tearDown() {
  20     $this->quickCleanup([], TRUE);
  21     parent::tearDown();
  22   }
  23
  24   /**
  25    * Test creating a custom field.
  26    */
  27   public function testCreateCustomField() {
  28     $customGroup = $this->createCustomField();
  29     $customFieldID = $this->assertDBNotNull('CRM_Core_DAO_CustomField', $customGroup['id'], 'id', 'custom_group_id',
  30       'Database check for created CustomField.'
  31     );
  32     $fields = [
  33       'id' => $customFieldID,
  34       'label' => 'editTestFld',
  35       'is_active' => 1,
  36       'data_type' => 'String',
  37       'html_type' => 'Text',
  38       'custom_group_id' => $customGroup['id'],
  39     ];
  40
  41     CRM_Core_BAO_CustomField::create($fields);
  42     $this->assertDBNotNull('CRM_Core_DAO_CustomField', 1, 'id', 'is_active', 'Database check for edited CustomField.');
  43     $this->assertDBNotNull('CRM_Core_DAO_CustomField', $fields['label'], 'id', 'label', 'Database check for edited CustomField.');
  44
  45     $dbFieldName = $this->assertDBNotNull('CRM_Core_DAO_CustomField', $customFieldID, 'name', 'id', 'Database check for edited CustomField.');
  46     $dbColumnName = $this->assertDBNotNull('CRM_Core_DAO_CustomField', $customFieldID, 'column_name', 'id', 'Database check for edited CustomField.');
  47     $this->assertEquals(strtolower("{$dbFieldName}_{$customFieldID}"), $dbColumnName,
  48       "Column name ends in ID");
  49
  50     $this->customGroupDelete($customGroup['id']);
  51   }
  52
  53   /**
  54    * Test custom field create accepts passed column name.
  55    */
  56   public function testCreateCustomFieldColumnName() {
  57     $customGroup = $this->customGroupCreate(['extends' => 'Individual']);
  58     $fields = [
  59       'label' => 'testFld 2',
  60       'column_name' => 'special_colname',
  61       'data_type' => 'String',
  62       'html_type' => 'Text',
  63       'custom_group_id' => $customGroup['id'],
  64     ];
  65     CRM_Core_BAO_CustomField::create($fields);
  66     $customFieldID = $this->assertDBNotNull('CRM_Core_DAO_CustomField', $customGroup['id'], 'id', 'custom_group_id',
  67       'Database check for created CustomField.'
  68     );
  69     $dbColumnName = $this->assertDBNotNull('CRM_Core_DAO_CustomField', $customFieldID, 'column_name', 'id', 'Database check for edited CustomField.');
  70     $this->assertEquals($fields['column_name'], $dbColumnName,
  71       "Column name set as specified");
  72
  73     $this->customGroupDelete($customGroup['id']);
  74   }
  75
  76   /**
  77    * Test that name is used for the column.
  78    */
  79   public function testCreateCustomFieldName() {
  80     $customGroup = $this->customGroupCreate(['extends' => 'Individual']);
  81     $fields = [
  82       'label' => 'testFld 2',
  83       'name' => 'special_fldlname',
  84       'data_type' => 'String',
  85       'html_type' => 'Text',
  86       'custom_group_id' => $customGroup['id'],
  87     ];
  88     CRM_Core_BAO_CustomField::create($fields);
  89     $customFieldID = $this->assertDBNotNull('CRM_Core_DAO_CustomField', $customGroup['id'], 'id', 'custom_group_id',
  90       'Database check for created CustomField.'
  91     );
  92     $dbFieldName = $this->assertDBNotNull('CRM_Core_DAO_CustomField', $customFieldID, 'name', 'id', 'Database check for edited CustomField.');
  93     $this->assertEquals($fields['name'], $dbFieldName,
  94       "Column name set as specified");
  95
  96     $this->customGroupDelete($customGroup['id']);
  97   }
  98
  99   /**
 100    * Test get fields function.
 101    */
 102   public function testGetFields() {
 103     $customGroup = $this->customGroupCreate(['extends' => 'Individual']);
 104     $fields = [
 105       'label' => 'testFld1',
 106       'data_type' => 'String',
 107       'html_type' => 'Text',
 108       'is_active' => 1,
 109       'custom_group_id' => $customGroup['id'],
 110     ];
 111     CRM_Core_BAO_CustomField::create($fields);
 112     $this->assertDBNotNull('CRM_Core_DAO_CustomField', $customGroup['id'], 'id', 'custom_group_id',
 113       'Database check for created CustomField.'
 114     );
 115     $fields = [
 116       'label' => 'testFld2',
 117       'data_type' => 'String',
 118       'html_type' => 'Text',
 119       'is_active' => 1,
 120       'custom_group_id' => $customGroup['id'],
 121     ];
 122     CRM_Core_BAO_CustomField::create($fields);
 123     $this->assertDBNotNull('CRM_Core_DAO_CustomField', $customGroup['id'], 'id', 'custom_group_id',
 124       'Database check for created CustomField.'
 125     );
 126
 127     $this->customGroupDelete($customGroup['id']);
 128   }
 129
 130   /**
 131    * @throws \Exception
 132    */
 133   public function testGetDisplayedValues() {
 134     $customGroup = $this->customGroupCreate(['extends' => 'Individual']);
 135     $fieldsToCreate = [
 136       [
 137         'data_type' => 'Country',
 138         'html_type' => 'Select Country',
 139         'tests' => [
 140           'United States' => 1228,
 141           '' => NULL,
 142         ],
 143       ],
 144       [
 145         'data_type' => 'StateProvince',
 146         'html_type' => 'Multi-Select State/Province',
 147         'tests' => [
 148           '' => 0,
 149           'Alabama' => 1000,
 150           'Alabama, Alaska' => [1000, 1001],
 151         ],
 152       ],
 153       [
 154         'data_type' => 'String',
 155         'html_type' => 'Radio',
 156         'option_values' => [
 157           'key' => 'KeyLabel',
 158         ],
 159         'tests' => [
 160           'KeyLabel' => 'key',
 161         ],
 162       ],
 163       [
 164         'data_type' => 'String',
 165         'html_type' => 'CheckBox',
 166         'option_values' => [
 167           'key1' => 'Label1',
 168           'key2' => 'Label2',
 169           'key3' => 'Label3',
 170           'key4' => 'Label4',
 171         ],
 172         'tests' => [
 173           'Label1' => ['key1'],
 174           'Label2' => 'key2',
 175           'Label2, Label3' => ['key2', 'key3'],
 176           'Label3, Label4' => CRM_Utils_Array::implodePadded(['key3', 'key4']),
 177           'Label1, Label4' => ['key1' => 1, 'key4' => 1],
 178         ],
 179       ],
 180       [
 181         'data_type' => 'Date',
 182         'html_type' => 'Select Date',
 183         'date_format' => 'd M yy',
 184         'time_format' => 1,
 185         'tests' => [
 186           '1 Jun 1999 1:30PM' => '1999-06-01 13:30',
 187           '' => '',
 188         ],
 189       ],
 190     ];
 191     foreach ($fieldsToCreate as $num => $field) {
 192       $params = $field + ['label' => 'test field ' . $num, 'custom_group_id' => $customGroup['id']];
 193       unset($params['tests']);
 194       $createdField = $this->callAPISuccess('customField', 'create', $params);
 195       foreach ($field['tests'] as $expected => $input) {
 196         $this->assertEquals($expected, CRM_Core_BAO_CustomField::displayValue($input, $createdField['id']));
 197       }
 198     }
 199
 200     $this->customGroupDelete($customGroup['id']);
 201   }
 202
 203   /**
 204    * Test CRM_Core_BAO_CustomField::displayValue.
 205    *
 206    * @throws \CRM_Core_Exception
 207    * @throws \Exception
 208    */
 209   public function testGetDisplayedValuesContactRef() {
 210     $customGroup = $this->customGroupCreate(['extends' => 'Individual']);
 211     $params = [
 212       'data_type' => 'ContactReference',
 213       'html_type' => 'Autocomplete-Select',
 214       'label' => 'test ref',
 215       'custom_group_id' => $customGroup['id'],
 216     ];
 217     $createdField = $this->callAPISuccess('customField', 'create', $params);
 218     $contact1 = $this->individualCreate();
 219     $contact2 = $this->individualCreate(['custom_' . $createdField['id'] => $contact1['id']]);
 220
 221     $this->assertEquals($contact1['display_name'], CRM_Core_BAO_CustomField::displayValue($contact2['id'], $createdField['id']));
 222     $this->assertEquals("Bob", CRM_Core_BAO_CustomField::displayValue("Bob", $createdField['id']));
 223
 224     $this->contactDelete($contact2['id']);
 225     $this->contactDelete($contact1['id']);
 226     $this->customGroupDelete($customGroup['id']);
 227   }
 228
 229   public function testDeleteCustomField() {
 230     $customGroup = $this->customGroupCreate(['extends' => 'Individual']);
 231     $fields = [
 232       'custom_group_id' => $customGroup['id'],
 233       'label' => 'Throwaway Field',
 234       'dataType' => 'Memo',
 235       'htmlType' => 'TextArea',
 236     ];
 237
 238     $customField = $this->customFieldCreate($fields);
 239     $fieldObject = new CRM_Core_BAO_CustomField();
 240     $fieldObject->id = $customField['id'];
 241     $fieldObject->find(TRUE);
 242     CRM_Core_BAO_CustomField::deleteField($fieldObject);
 243     $this->assertDBNull('CRM_Core_DAO_CustomField', $customGroup['id'], 'id',
 244       'custom_group_id', 'Database check for deleted Custom Field.'
 245     );
 246     $this->customGroupDelete($customGroup['id']);
 247   }
 248
 249   /**
 250    * Move a custom field from $groupA to $groupB.
 251    *
 252    * Make sure that data records are correctly matched and created.
 253    *
 254    * @throws \CRM_Core_Exception
 255    */
 256   public function testMoveField() {
 257     $countriesByName = array_flip(CRM_Core_PseudoConstant::country(FALSE, FALSE));
 258     $this->assertTrue($countriesByName['Andorra'] > 0);
 259     $groups = [
 260       'A' => $this->customGroupCreate([
 261         'title' => 'Test_Group A',
 262         'name' => 'test_group_a',
 263         'extends' => ['Individual'],
 264         'style' => 'Inline',
 265         'is_multiple' => 0,
 266         'is_active' => 1,
 267         'version' => 3,
 268       ]),
 269       'B' => $this->customGroupCreate([
 270         'title' => 'Test_Group B',
 271         'name' => 'test_group_b',
 272         'extends' => ['Individual'],
 273         'style' => 'Inline',
 274         'is_multiple' => 0,
 275         'is_active' => 1,
 276         'version' => 3,
 277       ]),
 278     ];
 279     $groupA = $groups['A']['values'][$groups['A']['id']];
 280     $groupB = $groups['B']['values'][$groups['B']['id']];
 281     $countryA = $this->customFieldCreate([
 282       'custom_group_id' => $groups['A']['id'],
 283       'label' => 'Country A',
 284       'dataType' => 'Country',
 285       'htmlType' => 'Select Country',
 286       'default_value' => NULL,
 287     ]);
 288     $countryB = $this->customFieldCreate([
 289       'custom_group_id' => $groups['A']['id'],
 290       'label' => 'Country B',
 291       'dataType' => 'Country',
 292       'htmlType' => 'Select Country',
 293       'default_value' => NULL,
 294     ]);
 295     $countryC = $this->customFieldCreate([
 296       'custom_group_id' => $groups['B']['id'],
 297       'label' => 'Country C',
 298       'dataType' => 'Country',
 299       'htmlType' => 'Select Country',
 300       'default_value' => NULL,
 301     ]);
 302
 303     $fields = [
 304       'countryA' => $countryA['values'][$countryA['id']],
 305       'countryB' => $countryB['values'][$countryB['id']],
 306       'countryC' => $countryC['values'][$countryC['id']],
 307     ];
 308     $contacts = [
 309       'alice' => $this->individualCreate([
 310         'first_name' => 'Alice',
 311         'last_name' => 'Albertson',
 312         'custom_' . $fields['countryA']['id'] => $countriesByName['Andorra'],
 313         'custom_' . $fields['countryB']['id'] => $countriesByName['Barbados'],
 314       ]),
 315       'bob' => $this->individualCreate([
 316         'first_name' => 'Bob',
 317         'last_name' => 'Roberts',
 318         'custom_' . $fields['countryA']['id'] => $countriesByName['Austria'],
 319         'custom_' . $fields['countryB']['id'] => $countriesByName['Bermuda'],
 320         'custom_' . $fields['countryC']['id'] => $countriesByName['Chad'],
 321       ]),
 322       'carol' => $this->individualCreate([
 323         'first_name' => 'Carol',
 324         'last_name' => 'Carolson',
 325         'custom_' . $fields['countryC']['id'] => $countriesByName['Cambodia'],
 326       ]),
 327     ];
 328
 329     // Move!
 330     CRM_Core_BAO_CustomField::moveField($fields['countryB']['id'], $groupB['id']);
 331
 332     // Group[A] no longer has fields[countryB]
 333     $errorScope = CRM_Core_TemporaryErrorScope::useException();
 334     try {
 335       $this->assertDBQuery(1, "SELECT {$fields['countryB']['column_name']} FROM " . $groupA['table_name']);
 336       $this->fail('Expected exception when querying column on wrong table');
 337     }
 338     catch (PEAR_Exception$e) {
 339     }
 340     $errorScope = NULL;
 341
 342     // Alice: Group[B] has fields[countryB], but fields[countryC] did not exist before
 343     $this->assertDBQuery(1,
 344       "SELECT count(*) FROM {$groupB['table_name']}
 345             WHERE entity_id = %1
 346             AND {$fields['countryB']['column_name']} = %3
 347             AND {$fields['countryC']['column_name']} is null",
 348       [
 349         1 => [$contacts['alice'], 'Integer'],
 350         3 => [$countriesByName['Barbados'], 'Integer'],
 351       ]
 352     );
 353
 354     // Bob: Group[B] has merged fields[countryB] and fields[countryC] on the same record
 355     $this->assertDBQuery(1,
 356       "SELECT count(*) FROM {$groupB['table_name']}
 357             WHERE entity_id = %1
 358             AND {$fields['countryB']['column_name']} = %3
 359             AND {$fields['countryC']['column_name']} = %4",
 360       [
 361         1 => [$contacts['bob'], 'Integer'],
 362         3 => [$countriesByName['Bermuda'], 'Integer'],
 363         4 => [$countriesByName['Chad'], 'Integer'],
 364       ]
 365     );
 366
 367     // Carol: Group[B] still has fields[countryC] but did not get fields[countryB]
 368     $this->assertDBQuery(1,
 369       "SELECT count(*) FROM {$groupB['table_name']}
 370             WHERE entity_id = %1
 371             AND {$fields['countryB']['column_name']} is null
 372             AND {$fields['countryC']['column_name']} = %4",
 373       [
 374         1 => [$contacts['carol'], 'Integer'],
 375         4 => [$countriesByName['Cambodia'], 'Integer'],
 376       ]
 377     );
 378
 379     $this->customGroupDelete($groups['A']['id']);
 380     $this->customGroupDelete($groupB['id']);
 381   }
 382
 383   /**
 384    * Test get custom field id function.
 385    *
 386    * @throws \CiviCRM_API3_Exception
 387    */
 388   public function testGetCustomFieldID() {
 389     $this->createCustomField();
 390     $fieldID = CRM_Core_BAO_CustomField::getCustomFieldID('testFld');
 391     $this->assertEquals($this->customFieldID, $fieldID);
 392
 393     $fieldID = CRM_Core_BAO_CustomField::getCustomFieldID('testFld', 'new custom group');
 394     $this->assertEquals($this->customFieldID, $fieldID);
 395
 396     $fieldID = CRM_Core_BAO_CustomField::getCustomFieldID('testFld', 'new custom group', TRUE);
 397     $this->assertEquals('custom_' . $this->customFieldID, $fieldID);
 398
 399     // create field with same name in a different group
 400     $this->createCustomField('other custom group');
 401     $otherFieldID = CRM_Core_BAO_CustomField::getCustomFieldID('testFld', 'other custom group');
 402     // make sure it does not return the field ID of the first field
 403     $this->assertNotEquals($fieldID, $otherFieldID);
 404   }
 405
 406   /**
 407    * Create a custom field
 408    *
 409    * @param string $groupTitle
 410    *
 411    * @return array
 412    */
 413   protected function createCustomField($groupTitle = 'new custom group') {
 414     $customGroup = $this->customGroupCreate([
 415       'extends' => 'Individual',
 416       'title' => $groupTitle,
 417     ]);
 418     $fields = [
 419       'label' => 'testFld',
 420       'data_type' => 'String',
 421       'html_type' => 'Text',
 422       'custom_group_id' => $customGroup['id'],
 423     ];
 424     $field = CRM_Core_BAO_CustomField::create($fields);
 425     $this->customFieldID = $field->id;
 426     return $customGroup;
 427   }
 428
 429   /**
 430    * Test the getFieldsForImport function.
 431    *
 432    * @throws \Exception
 433    */
 434   public function testGetFieldsForImport() {
 435     $this->entity = 'Contact';
 436     $this->createCustomGroupWithFieldsOfAllTypes();
 437     $customGroupID = $this->ids['CustomGroup']['Custom Group'];
 438     $expected = [
 439       $this->getCustomFieldName('country') => [
 440         'name' => $this->getCustomFieldName('country'),
 441         'type' => 1,
 442         'title' => 'Country',
 443         'headerPattern' => '//',
 444         'import' => 1,
 445         'custom_field_id' => $this->getCustomFieldID('country'),
 446         'options_per_line' => NULL,
 447         'text_length' => NULL,
 448         'data_type' => 'Int',
 449         'html_type' => 'Select Country',
 450         'is_search_range' => '0',
 451         'id' => $this->getCustomFieldID('country'),
 452         'label' => 'Country',
 453         'groupTitle' => 'Custom Group',
 454         'default_value' => NULL,
 455         'custom_group_id' => $customGroupID,
 456         'extends' => 'Contact',
 457         'extends_entity_column_value' => NULL,
 458         'extends_entity_column_id' => NULL,
 459         'is_view' => '0',
 460         'is_multiple' => '0',
 461         'option_group_id' => NULL,
 462         'date_format' => NULL,
 463         'time_format' => NULL,
 464         'is_required' => '0',
 465         'table_name' => 'civicrm_value_custom_group_' . $customGroupID,
 466         'column_name' => 'country_' . $this->getCustomFieldID('country'),
 467         'where' => 'civicrm_value_custom_group_' . $customGroupID . '.country_' . $this->getCustomFieldID('country'),
 468         'extends_table' => 'civicrm_contact',
 469         'search_table' => 'contact_a',
 470       ],
 471       $this->getCustomFieldName('file') => [
 472         'name' => $this->getCustomFieldName('file'),
 473         'type' => 2,
 474         'title' => 'Custom Field',
 475         'headerPattern' => '//',
 476         'import' => 1,
 477         'custom_field_id' => $this->getCustomFieldID('file'),
 478         'options_per_line' => NULL,
 479         'text_length' => NULL,
 480         'data_type' => 'File',
 481         'html_type' => 'File',
 482         'is_search_range' => '0',
 483         'id' => $this->getCustomFieldID('file'),
 484         'label' => 'Custom Field',
 485         'groupTitle' => 'Custom Group',
 486         'default_value' => NULL,
 487         'custom_group_id' => $customGroupID,
 488         'extends' => 'Contact',
 489         'extends_entity_column_value' => NULL,
 490         'extends_entity_column_id' => NULL,
 491         'is_view' => '0',
 492         'is_multiple' => '0',
 493         'option_group_id' => NULL,
 494         'date_format' => NULL,
 495         'time_format' => NULL,
 496         'is_required' => '0',
 497         'table_name' => 'civicrm_value_custom_group_' . $customGroupID,
 498         'column_name' => 'custom_field_' . $this->getCustomFieldID('file'),
 499         'where' => 'civicrm_value_custom_group_' . $customGroupID . '.custom_field_' . $this->getCustomFieldID('file'),
 500         'extends_table' => 'civicrm_contact',
 501         'search_table' => 'contact_a',
 502       ],
 503       $this->getCustomFieldName('text') => [
 504         'name' => $this->getCustomFieldName('text'),
 505         'type' => 2,
 506         'title' => 'Enter text here',
 507         'headerPattern' => '//',
 508         'import' => 1,
 509         'custom_field_id' => $this->getCustomFieldID('text'),
 510         'options_per_line' => NULL,
 511         'text_length' => NULL,
 512         'data_type' => 'String',
 513         'html_type' => 'Text',
 514         'is_search_range' => '0',
 515         'id' => $this->getCustomFieldID('text'),
 516         'label' => 'Enter text here',
 517         'groupTitle' => 'Custom Group',
 518         'default_value' => 'xyz',
 519         'custom_group_id' => '1',
 520         'extends' => 'Contact',
 521         'extends_entity_column_value' => NULL,
 522         'extends_entity_column_id' => NULL,
 523         'is_view' => '0',
 524         'is_multiple' => '0',
 525         'option_group_id' => NULL,
 526         'date_format' => NULL,
 527         'time_format' => NULL,
 528         'is_required' => '1',
 529         'table_name' => 'civicrm_value_custom_group_' . $customGroupID,
 530         'column_name' => 'enter_text_here_' . $this->getCustomFieldID('text'),
 531         'where' => 'civicrm_value_custom_group_' . $customGroupID . '.enter_text_here_' . $this->getCustomFieldID('text'),
 532         'extends_table' => 'civicrm_contact',
 533         'search_table' => 'contact_a',
 534       ],
 535       $this->getCustomFieldName('select_string') => [
 536         'name' => $this->getCustomFieldName('select_string'),
 537         'type' => 2,
 538         'title' => 'Pick Color',
 539         'headerPattern' => '//',
 540         'import' => 1,
 541         'custom_field_id' => $this->getCustomFieldID('select_string'),
 542         'options_per_line' => NULL,
 543         'text_length' => NULL,
 544         'data_type' => 'String',
 545         'html_type' => 'Select',
 546         'is_search_range' => '0',
 547         'id' => $this->getCustomFieldID('select_string'),
 548         'label' => 'Pick Color',
 549         'groupTitle' => 'Custom Group',
 550         'default_value' => NULL,
 551         'custom_group_id' => $customGroupID,
 552         'extends' => 'Contact',
 553         'extends_entity_column_value' => NULL,
 554         'extends_entity_column_id' => NULL,
 555         'is_view' => '0',
 556         'is_multiple' => '0',
 557         'option_group_id' => $this->callAPISuccessGetValue('CustomField', ['id' => $this->getCustomFieldID('select_string'), 'return' => 'option_group_id']),
 558         'date_format' => NULL,
 559         'time_format' => NULL,
 560         'is_required' => '1',
 561         'table_name' => 'civicrm_value_custom_group_' . $customGroupID,
 562         'column_name' => 'pick_color_' . $this->getCustomFieldID('select_string'),
 563         'where' => 'civicrm_value_custom_group_' . $customGroupID . '.pick_color_' . $this->getCustomFieldID('select_string'),
 564         'extends_table' => 'civicrm_contact',
 565         'search_table' => 'contact_a',
 566         'pseudoconstant' => [
 567           'optionGroupName' => $this->callAPISuccessGetValue('CustomField', ['id' => $this->getCustomFieldID('select_string'), 'return' => 'option_group_id.name']),
 568           'optionEditPath' => 'civicrm/admin/options/' . $this->callAPISuccessGetValue('CustomField', ['id' => $this->getCustomFieldID('select_string'), 'return' => 'option_group_id.name']),
 569         ],
 570       ],
 571       $this->getCustomFieldName('select_date') => [
 572         'name' => $this->getCustomFieldName('select_date'),
 573         'type' => 4,
 574         'title' => 'test_date',
 575         'headerPattern' => '//',
 576         'import' => 1,
 577         'custom_field_id' => $this->getCustomFieldID('select_date'),
 578         'options_per_line' => NULL,
 579         'text_length' => NULL,
 580         'data_type' => 'Date',
 581         'html_type' => 'Select Date',
 582         'is_search_range' => '0',
 583         'date_format' => 'mm/dd/yy',
 584         'time_format' => '1',
 585         'id' => $this->getCustomFieldID('select_date'),
 586         'label' => 'test_date',
 587         'groupTitle' => 'Custom Group',
 588         'default_value' => '20090711',
 589         'custom_group_id' => $customGroupID,
 590         'extends' => 'Contact',
 591         'extends_entity_column_value' => NULL,
 592         'extends_entity_column_id' => NULL,
 593         'is_view' => '0',
 594         'is_multiple' => '0',
 595         'option_group_id' => NULL,
 596         'is_required' => '0',
 597         'table_name' => 'civicrm_value_custom_group_' . $customGroupID,
 598         'column_name' => 'test_date_' . $this->getCustomFieldID('select_date'),
 599         'where' => 'civicrm_value_custom_group_' . $customGroupID . '.test_date_' . $this->getCustomFieldID('select_date'),
 600         'extends_table' => 'civicrm_contact',
 601         'search_table' => 'contact_a',
 602       ],
 603       $this->getCustomFieldName('link') => [
 604         'name' => $this->getCustomFieldName('link'),
 605         'type' => 2,
 606         'title' => 'test_link',
 607         'headerPattern' => '//',
 608         'import' => 1,
 609         'custom_field_id' => $this->getCustomFieldID('link'),
 610         'options_per_line' => NULL,
 611         'text_length' => NULL,
 612         'data_type' => 'Link',
 613         'html_type' => 'Link',
 614         'is_search_range' => '0',
 615         'id' => $this->getCustomFieldID('link'),
 616         'label' => 'test_link',
 617         'groupTitle' => 'Custom Group',
 618         'default_value' => 'http://civicrm.org',
 619         'custom_group_id' => $customGroupID,
 620         'extends' => 'Contact',
 621         'extends_entity_column_value' => NULL,
 622         'extends_entity_column_id' => NULL,
 623         'is_view' => '0',
 624         'is_multiple' => '0',
 625         'option_group_id' => NULL,
 626         'date_format' => NULL,
 627         'time_format' => NULL,
 628         'is_required' => '1',
 629         'table_name' => 'civicrm_value_custom_group_' . $customGroupID,
 630         'column_name' => 'test_link_' . $this->getCustomFieldID('link'),
 631         'where' => 'civicrm_value_custom_group_' . $customGroupID . '.test_link_' . $this->getCustomFieldID('link'),
 632         'extends_table' => 'civicrm_contact',
 633         'search_table' => 'contact_a',
 634       ],
 635     ];
 636     $this->assertEquals($expected, CRM_Core_BAO_CustomField::getFieldsForImport());
 637   }
 638
 639 }