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' => 'Country',
 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         'pseudoconstant' => [
 471           'table' => 'civicrm_country',
 472           'keyColumn' => 'id',
 473           'labelColumn' => 'name',
 474           'nameColumn' => 'iso_code',
 475         ],
 476       ],
 477       $this->getCustomFieldName('file') => [
 478         'name' => $this->getCustomFieldName('file'),
 479         'type' => 2,
 480         'title' => 'Custom Field',
 481         'headerPattern' => '//',
 482         'import' => 1,
 483         'custom_field_id' => $this->getCustomFieldID('file'),
 484         'options_per_line' => NULL,
 485         'text_length' => NULL,
 486         'data_type' => 'File',
 487         'html_type' => 'File',
 488         'is_search_range' => '0',
 489         'id' => $this->getCustomFieldID('file'),
 490         'label' => 'Custom Field',
 491         'groupTitle' => 'Custom Group',
 492         'default_value' => NULL,
 493         'custom_group_id' => $customGroupID,
 494         'extends' => 'Contact',
 495         'extends_entity_column_value' => NULL,
 496         'extends_entity_column_id' => NULL,
 497         'is_view' => '0',
 498         'is_multiple' => '0',
 499         'option_group_id' => NULL,
 500         'date_format' => NULL,
 501         'time_format' => NULL,
 502         'is_required' => '0',
 503         'table_name' => 'civicrm_value_custom_group_' . $customGroupID,
 504         'column_name' => 'custom_field_' . $this->getCustomFieldID('file'),
 505         'where' => 'civicrm_value_custom_group_' . $customGroupID . '.custom_field_' . $this->getCustomFieldID('file'),
 506         'extends_table' => 'civicrm_contact',
 507         'search_table' => 'contact_a',
 508       ],
 509       $this->getCustomFieldName('text') => [
 510         'name' => $this->getCustomFieldName('text'),
 511         'type' => 2,
 512         'title' => 'Enter text here',
 513         'headerPattern' => '//',
 514         'import' => 1,
 515         'custom_field_id' => $this->getCustomFieldID('text'),
 516         'options_per_line' => NULL,
 517         'text_length' => NULL,
 518         'data_type' => 'String',
 519         'html_type' => 'Text',
 520         'is_search_range' => '0',
 521         'id' => $this->getCustomFieldID('text'),
 522         'label' => 'Enter text here',
 523         'groupTitle' => 'Custom Group',
 524         'default_value' => 'xyz',
 525         'custom_group_id' => '1',
 526         'extends' => 'Contact',
 527         'extends_entity_column_value' => NULL,
 528         'extends_entity_column_id' => NULL,
 529         'is_view' => '0',
 530         'is_multiple' => '0',
 531         'option_group_id' => NULL,
 532         'date_format' => NULL,
 533         'time_format' => NULL,
 534         'is_required' => '1',
 535         'table_name' => 'civicrm_value_custom_group_' . $customGroupID,
 536         'column_name' => 'enter_text_here_' . $this->getCustomFieldID('text'),
 537         'where' => 'civicrm_value_custom_group_' . $customGroupID . '.enter_text_here_' . $this->getCustomFieldID('text'),
 538         'extends_table' => 'civicrm_contact',
 539         'search_table' => 'contact_a',
 540       ],
 541       $this->getCustomFieldName('select_string') => [
 542         'name' => $this->getCustomFieldName('select_string'),
 543         'type' => 2,
 544         'title' => 'Pick Color',
 545         'headerPattern' => '//',
 546         'import' => 1,
 547         'custom_field_id' => $this->getCustomFieldID('select_string'),
 548         'options_per_line' => NULL,
 549         'text_length' => NULL,
 550         'data_type' => 'String',
 551         'html_type' => 'Select',
 552         'is_search_range' => '0',
 553         'id' => $this->getCustomFieldID('select_string'),
 554         'label' => 'Pick Color',
 555         'groupTitle' => 'Custom Group',
 556         'default_value' => NULL,
 557         'custom_group_id' => $customGroupID,
 558         'extends' => 'Contact',
 559         'extends_entity_column_value' => NULL,
 560         'extends_entity_column_id' => NULL,
 561         'is_view' => '0',
 562         'is_multiple' => '0',
 563         'option_group_id' => $this->callAPISuccessGetValue('CustomField', ['id' => $this->getCustomFieldID('select_string'), 'return' => 'option_group_id']),
 564         'date_format' => NULL,
 565         'time_format' => NULL,
 566         'is_required' => '1',
 567         'table_name' => 'civicrm_value_custom_group_' . $customGroupID,
 568         'column_name' => 'pick_color_' . $this->getCustomFieldID('select_string'),
 569         'where' => 'civicrm_value_custom_group_' . $customGroupID . '.pick_color_' . $this->getCustomFieldID('select_string'),
 570         'extends_table' => 'civicrm_contact',
 571         'search_table' => 'contact_a',
 572         'pseudoconstant' => [
 573           'optionGroupName' => $this->callAPISuccessGetValue('CustomField', ['id' => $this->getCustomFieldID('select_string'), 'return' => 'option_group_id.name']),
 574           'optionEditPath' => 'civicrm/admin/options/' . $this->callAPISuccessGetValue('CustomField', ['id' => $this->getCustomFieldID('select_string'), 'return' => 'option_group_id.name']),
 575         ],
 576       ],
 577       $this->getCustomFieldName('select_date') => [
 578         'name' => $this->getCustomFieldName('select_date'),
 579         'type' => 4,
 580         'title' => 'test_date',
 581         'headerPattern' => '//',
 582         'import' => 1,
 583         'custom_field_id' => $this->getCustomFieldID('select_date'),
 584         'options_per_line' => NULL,
 585         'text_length' => NULL,
 586         'data_type' => 'Date',
 587         'html_type' => 'Select Date',
 588         'is_search_range' => '0',
 589         'date_format' => 'mm/dd/yy',
 590         'time_format' => '1',
 591         'id' => $this->getCustomFieldID('select_date'),
 592         'label' => 'test_date',
 593         'groupTitle' => 'Custom Group',
 594         'default_value' => '20090711',
 595         'custom_group_id' => $customGroupID,
 596         'extends' => 'Contact',
 597         'extends_entity_column_value' => NULL,
 598         'extends_entity_column_id' => NULL,
 599         'is_view' => '0',
 600         'is_multiple' => '0',
 601         'option_group_id' => NULL,
 602         'is_required' => '0',
 603         'table_name' => 'civicrm_value_custom_group_' . $customGroupID,
 604         'column_name' => 'test_date_' . $this->getCustomFieldID('select_date'),
 605         'where' => 'civicrm_value_custom_group_' . $customGroupID . '.test_date_' . $this->getCustomFieldID('select_date'),
 606         'extends_table' => 'civicrm_contact',
 607         'search_table' => 'contact_a',
 608       ],
 609       $this->getCustomFieldName('link') => [
 610         'name' => $this->getCustomFieldName('link'),
 611         'type' => 2,
 612         'title' => 'test_link',
 613         'headerPattern' => '//',
 614         'import' => 1,
 615         'custom_field_id' => $this->getCustomFieldID('link'),
 616         'options_per_line' => NULL,
 617         'text_length' => NULL,
 618         'data_type' => 'Link',
 619         'html_type' => 'Link',
 620         'is_search_range' => '0',
 621         'id' => $this->getCustomFieldID('link'),
 622         'label' => 'test_link',
 623         'groupTitle' => 'Custom Group',
 624         'default_value' => 'http://civicrm.org',
 625         'custom_group_id' => $customGroupID,
 626         'extends' => 'Contact',
 627         'extends_entity_column_value' => NULL,
 628         'extends_entity_column_id' => NULL,
 629         'is_view' => '0',
 630         'is_multiple' => '0',
 631         'option_group_id' => NULL,
 632         'date_format' => NULL,
 633         'time_format' => NULL,
 634         'is_required' => '1',
 635         'table_name' => 'civicrm_value_custom_group_' . $customGroupID,
 636         'column_name' => 'test_link_' . $this->getCustomFieldID('link'),
 637         'where' => 'civicrm_value_custom_group_' . $customGroupID . '.test_link_' . $this->getCustomFieldID('link'),
 638         'extends_table' => 'civicrm_contact',
 639         'search_table' => 'contact_a',
 640       ],
 641     ];
 642     $this->assertEquals($expected, CRM_Core_BAO_CustomField::getFieldsForImport());
 643   }
 644
 645   /**
 646    * Test the bulk create function works.
 647    */
 648   public function testBulkCreate() {
 649     $customGroup = $this->customGroupCreate([
 650       'extends' => 'Individual',
 651       'title' => 'my bulk group',
 652     ]);
 653     CRM_Core_BAO_CustomField::bulkSave([
 654       [
 655         'label' => 'Test',
 656         'data_type' => 'String',
 657         'html_type' => 'Text',
 658         'column_name' => 'my_text',
 659       ],
 660       [
 661         'label' => 'test_link',
 662         'data_type' => 'Link',
 663         'html_type' => 'Link',
 664         'is_search_range' => '0',
 665       ],
 666     ],
 667     [
 668       'custom_group_id' => $customGroup['id'],
 669       'is_active' => 1,
 670       'is_searchable' => 1,
 671     ]);
 672     $dao = CRM_Core_DAO::executeQuery(('SHOW CREATE TABLE ' . $customGroup['values'][$customGroup['id']]['table_name']));
 673     $dao->fetch();
 674     $this->assertContains('`test_link_2` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL', $dao->Create_Table);
 675     $this->assertContains('KEY `INDEX_my_text` (`my_text`)', $dao->Create_Table);
 676   }
 677
 678 }