From c1230601c989b699b30908ba0bfcea13aef70dd9 Mon Sep 17 00:00:00 2001 From: Tim Otten Date: Wed, 17 May 2023 00:59:14 -0700 Subject: [PATCH] Extract 'mobile_provider' --- sql/civicrm_option_groups.php | 5 ----- sql/civicrm_option_groups/mobile_provider.sqldata.php | 11 +++++++++++ xml/templates/civicrm_data.tpl | 5 ----- 3 files changed, 11 insertions(+), 10 deletions(-) create mode 100644 sql/civicrm_option_groups/mobile_provider.sqldata.php diff --git a/sql/civicrm_option_groups.php b/sql/civicrm_option_groups.php index 0637c2350c..416dd7ea0e 100644 --- a/sql/civicrm_option_groups.php +++ b/sql/civicrm_option_groups.php @@ -19,11 +19,6 @@ $readOptionGroups = function (): array { }; return $readOptionGroups() + [ - 'mobile_provider' => CRM_Core_CodeGen_OptionGroup::create('mobile_provider') - ->addMetadata([ - 'title' => ts('Mobile Phone Providers'), - 'description' => ts('When recording mobile phone numbers for contacts, it may be useful to include the Mobile Phone Service Provider (e.g. Cingular, Sprint, etc.). CiviCRM is installed with the most commonly encountered service providers. Administrators may define as many additional providers as needed.'), - ]), 'individual_prefix' => CRM_Core_CodeGen_OptionGroup::create('individual_prefix') ->addMetadata([ 'title' => ts('Individual contact prefixes'), diff --git a/sql/civicrm_option_groups/mobile_provider.sqldata.php b/sql/civicrm_option_groups/mobile_provider.sqldata.php new file mode 100644 index 0000000000..953bfbe97e --- /dev/null +++ b/sql/civicrm_option_groups/mobile_provider.sqldata.php @@ -0,0 +1,11 @@ +addMetadata([ + 'title' => ts('Mobile Phone Providers'), + 'description' => ts('When recording mobile phone numbers for contacts, it may be useful to include the Mobile Phone Service Provider (e.g. Cingular, Sprint, etc.). CiviCRM is installed with the most commonly encountered service providers. Administrators may define as many additional providers as needed.'), + ]) + ->addValues(['label', 'name', 'value'], [ + ['Sprint', 'Sprint', 1], + ['Verizon', 'Verizon', 2], + ['Cingular', 'Cingular', 3], + ]); diff --git a/xml/templates/civicrm_data.tpl b/xml/templates/civicrm_data.tpl index bdf8f33ccc..6be0aefeb3 100644 --- a/xml/templates/civicrm_data.tpl +++ b/xml/templates/civicrm_data.tpl @@ -132,7 +132,6 @@ VALUES } {/php} -SELECT @option_group_id_mobileProvider := max(id) from civicrm_option_group where name = 'mobile_provider'; SELECT @option_group_id_prefix := max(id) from civicrm_option_group where name = 'individual_prefix'; SELECT @option_group_id_suffix := max(id) from civicrm_option_group where name = 'individual_suffix'; SELECT @option_group_id_aclRole := max(id) from civicrm_option_group where name = 'acl_role'; @@ -224,10 +223,6 @@ INSERT INTO `civicrm_option_value` (`option_group_id`, `label`, `value`, `name`, `grouping`, `filter`, `is_default`, `weight`, `description`, `is_optgroup`, `is_reserved`, `is_active`, `component_id`, `visibility_id`, `icon`) VALUES - (@option_group_id_mobileProvider, 'Sprint' , 1, 'Sprint' , NULL, 0, 0, 1, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_mobileProvider, 'Verizon' , 2, 'Verizon' , NULL, 0, 0, 2, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_mobileProvider, 'Cingular', 3, 'Cingular', NULL, 0, 0, 3, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_prefix, '{ts escape="sql"}Mrs.{/ts}', 1, 'Mrs.', NULL, 0, 0, 1, NULL, 0, 0, 1, NULL, NULL, NULL), (@option_group_id_prefix, '{ts escape="sql"}Ms.{/ts}', 2, 'Ms.', NULL, 0, 0, 2, NULL, 0, 0, 1, NULL, NULL, NULL), (@option_group_id_prefix, '{ts escape="sql"}Mr.{/ts}', 3, 'Mr.', NULL, 0, 0, 3, NULL, 0, 0, 1, NULL, NULL, NULL), -- 2.25.1