'time_format' => NULL,
'is_required' => 0,
'table_name' => 'civicrm_value_custom_group_' . $customGroupID,
- 'column_name' => 'country_' . $this->getCustomFieldID('country'),
- 'where' => 'civicrm_value_custom_group_' . $customGroupID . '.country_' . $this->getCustomFieldID('country'),
+ 'column_name' => $this->getCustomFieldColumnName('country'),
+ 'where' => 'civicrm_value_custom_group_' . $customGroupID . '.' . $this->getCustomFieldColumnName('country'),
+ 'extends_table' => 'civicrm_contact',
+ 'search_table' => 'contact_a',
+ 'pseudoconstant' => [
+ 'table' => 'civicrm_country',
+ 'keyColumn' => 'id',
+ 'labelColumn' => 'name',
+ 'nameColumn' => 'iso_code',
+ ],
+ ],
+ $this->getCustomFieldName('multi_country') => [
+ 'name' => $this->getCustomFieldName('multi_country'),
+ 'type' => 1,
+ 'title' => 'Country-multi',
+ 'headerPattern' => '//',
+ 'import' => 1,
+ 'custom_field_id' => $this->getCustomFieldID('multi_country'),
+ 'options_per_line' => NULL,
+ 'text_length' => NULL,
+ 'data_type' => 'Country',
+ 'html_type' => 'Multi-Select Country',
+ 'is_search_range' => '0',
+ 'id' => $this->getCustomFieldID('multi_country'),
+ 'label' => 'Country-multi',
+ 'groupTitle' => 'Custom Group',
+ 'default_value' => NULL,
+ 'custom_group_id' => $customGroupID,
+ 'extends' => 'Contact',
+ 'extends_entity_column_value' => NULL,
+ 'extends_entity_column_id' => NULL,
+ 'is_view' => '0',
+ 'is_multiple' => '0',
+ 'option_group_id' => NULL,
+ 'date_format' => NULL,
+ 'time_format' => NULL,
+ 'is_required' => 0,
+ 'table_name' => 'civicrm_value_custom_group_' . $customGroupID,
+ 'column_name' => $this->getCustomFieldColumnName('multi_country'),
+ 'where' => 'civicrm_value_custom_group_' . $customGroupID . '.' . $this->getCustomFieldColumnName('multi_country'),
'extends_table' => 'civicrm_contact',
'search_table' => 'contact_a',
'pseudoconstant' => [
'extends_table' => 'civicrm_contact',
'search_table' => 'contact_a',
],
+ $this->getCustomFieldName('state') => [
+ 'name' => $this->getCustomFieldName('state'),
+ 'id' => $this->getCustomFieldID('state'),
+ 'label' => 'State',
+ 'headerPattern' => '//',
+ 'title' => 'State',
+ 'custom_field_id' => $this->getCustomFieldID('state'),
+ 'groupTitle' => 'Custom Group',
+ 'default_value' => NULL,
+ 'custom_group_id' => $customGroupID,
+ 'extends' => 'Contact',
+ 'extends_entity_column_value' => NULL,
+ 'extends_entity_column_id' => NULL,
+ 'is_view' => '0',
+ 'is_multiple' => '0',
+ 'option_group_id' => NULL,
+ 'date_format' => NULL,
+ 'time_format' => NULL,
+ 'is_required' => 0,
+ 'table_name' => 'civicrm_value_custom_group_' . $customGroupID,
+ 'column_name' => $this->getCustomFieldColumnName('state'),
+ 'where' => 'civicrm_value_custom_group_' . $customGroupID . '.' . $this->getCustomFieldColumnName('state'),
+ 'extends_table' => 'civicrm_contact',
+ 'search_table' => 'contact_a',
+ 'pseudoconstant' => [
+ 'table' => 'civicrm_state_province',
+ 'keyColumn' => 'id',
+ 'labelColumn' => 'name',
+ ],
+ 'import' => 1,
+ 'data_type' => 'StateProvince',
+ 'type' => 1,
+ 'html_type' => 'Select State/Province',
+ 'text_length' => NULL,
+ 'options_per_line' => NULL,
+ 'is_search_range' => '0',
+ ],
+ $this->getCustomFieldName('multi_state') => [
+ 'id' => $this->getCustomFieldID('multi_state'),
+ 'label' => 'State-multi',
+ 'headerPattern' => '//',
+ 'title' => 'State-multi',
+ 'custom_field_id' => $this->getCustomFieldID('multi_state'),
+ 'groupTitle' => 'Custom Group',
+ 'default_value' => NULL,
+ 'custom_group_id' => $customGroupID,
+ 'extends' => 'Contact',
+ 'extends_entity_column_value' => NULL,
+ 'extends_entity_column_id' => NULL,
+ 'is_view' => '0',
+ 'is_multiple' => '0',
+ 'option_group_id' => NULL,
+ 'date_format' => NULL,
+ 'time_format' => NULL,
+ 'is_required' => 0,
+ 'table_name' => 'civicrm_value_custom_group_' . $customGroupID,
+ 'column_name' => $this->getCustomFieldColumnName('multi_state'),
+ 'where' => 'civicrm_value_custom_group_' . $customGroupID . '.' . $this->getCustomFieldColumnName('multi_state'),
+ 'extends_table' => 'civicrm_contact',
+ 'search_table' => 'contact_a',
+ 'pseudoconstant' => [
+ 'table' => 'civicrm_state_province',
+ 'keyColumn' => 'id',
+ 'labelColumn' => 'name',
+ ],
+ 'import' => 1,
+ 'data_type' => 'StateProvince',
+ 'name' => $this->getCustomFieldName('multi_state'),
+ 'type' => 1,
+ 'html_type' => 'Multi-Select State/Province',
+ 'text_length' => NULL,
+ 'options_per_line' => NULL,
+ 'is_search_range' => '0',
+ ],
+ $this->getCustomFieldName('boolean') => [
+ 'id' => $this->getCustomFieldID('boolean'),
+ 'label' => 'Yes No',
+ 'headerPattern' => '//',
+ 'title' => 'Yes No',
+ 'custom_field_id' => $this->getCustomFieldID('boolean'),
+ 'groupTitle' => 'Custom Group',
+ 'default_value' => NULL,
+ 'custom_group_id' => $customGroupID,
+ 'extends' => 'Contact',
+ 'extends_entity_column_value' => NULL,
+ 'extends_entity_column_id' => NULL,
+ 'is_view' => '0',
+ 'is_multiple' => '0',
+ 'option_group_id' => NULL,
+ 'date_format' => NULL,
+ 'time_format' => NULL,
+ 'is_required' => 0,
+ 'table_name' => 'civicrm_value_custom_group_' . $customGroupID,
+ 'column_name' => $this->getCustomFieldColumnName('boolean'),
+ 'where' => 'civicrm_value_custom_group_' . $customGroupID . '.' . $this->getCustomFieldColumnName('boolean'),
+ 'extends_table' => 'civicrm_contact',
+ 'search_table' => 'contact_a',
+ 'import' => 1,
+ 'data_type' => 'Boolean',
+ 'name' => $this->getCustomFieldName('boolean'),
+ 'type' => 16,
+ 'html_type' => 'Radio',
+ 'text_length' => NULL,
+ 'options_per_line' => NULL,
+ 'is_search_range' => '0',
+ 'pseudoconstant' => [
+ 'callback' => 'CRM_Core_SelectValues::boolean',
+ ],
+ ],
];
$this->assertEquals($expected, CRM_Core_BAO_CustomField::getFieldsForImport());
}