From 88c325ec04c08c0c9ef20311ef9d19e4fee40d15 Mon Sep 17 00:00:00 2001 From: Tim Otten Date: Wed, 17 May 2023 02:38:59 -0700 Subject: [PATCH] Extract cg_extend_objects, engagement_index, mail_approval_status, system_extensions --- sql/civicrm_option_groups.php | 16 ------------ .../cg_extend_objects.sqldata.php | 9 +++++++ .../engagement_index.sqldata.php | 12 +++++++++ .../mail_approval_status.sqldata.php | 10 +++++++ .../system_extensions.sqldata.php | 8 ++++++ xml/templates/civicrm_data.tpl | 26 ------------------- 6 files changed, 39 insertions(+), 42 deletions(-) create mode 100644 sql/civicrm_option_groups/cg_extend_objects.sqldata.php create mode 100644 sql/civicrm_option_groups/engagement_index.sqldata.php create mode 100644 sql/civicrm_option_groups/mail_approval_status.sqldata.php create mode 100644 sql/civicrm_option_groups/system_extensions.sqldata.php diff --git a/sql/civicrm_option_groups.php b/sql/civicrm_option_groups.php index 7029ab876b..65300f43ad 100644 --- a/sql/civicrm_option_groups.php +++ b/sql/civicrm_option_groups.php @@ -19,22 +19,6 @@ $readOptionGroups = function (): array { }; return $readOptionGroups() + [ - 'system_extensions' => CRM_Core_CodeGen_OptionGroup::create('system_extensions') - ->addMetadata([ - 'title' => ts('CiviCRM Extensions'), - ]), - 'mail_approval_status' => CRM_Core_CodeGen_OptionGroup::create('mail_approval_status') - ->addMetadata([ - 'title' => ts('CiviMail Approval Status'), - ]), - 'engagement_index' => CRM_Core_CodeGen_OptionGroup::create('engagement_index') - ->addMetadata([ - 'title' => ts('Engagement Index'), - ]), - 'cg_extend_objects' => CRM_Core_CodeGen_OptionGroup::create('cg_extend_objects') - ->addMetadata([ - 'title' => ts('Objects a custom group extends to'), - ]), 'paper_size' => CRM_Core_CodeGen_OptionGroup::create('paper_size') ->addMetadata([ 'title' => ts('Paper Size'), diff --git a/sql/civicrm_option_groups/cg_extend_objects.sqldata.php b/sql/civicrm_option_groups/cg_extend_objects.sqldata.php new file mode 100644 index 0000000000..7cc839b7e6 --- /dev/null +++ b/sql/civicrm_option_groups/cg_extend_objects.sqldata.php @@ -0,0 +1,9 @@ +addMetadata([ + 'title' => ts('Objects a custom group extends to'), + ]) + ->addValues(['label', 'name', 'value'], [ + [ts('Survey'), 'civicrm_survey', 'Survey'], + [ts('Cases'), 'civicrm_case', 'Case', 'grouping' => 'case_type_id'], + ]); diff --git a/sql/civicrm_option_groups/engagement_index.sqldata.php b/sql/civicrm_option_groups/engagement_index.sqldata.php new file mode 100644 index 0000000000..4f5c5bd36a --- /dev/null +++ b/sql/civicrm_option_groups/engagement_index.sqldata.php @@ -0,0 +1,12 @@ +addMetadata([ + 'title' => ts('Engagement Index'), + ]) + ->addValues(['label', 'name', 'value'], [ + [ts('1'), 1, 1], + [ts('2'), 2, 2], + [ts('3'), 3, 3], + [ts('4'), 4, 4], + [ts('5'), 5, 5], + ]); diff --git a/sql/civicrm_option_groups/mail_approval_status.sqldata.php b/sql/civicrm_option_groups/mail_approval_status.sqldata.php new file mode 100644 index 0000000000..2f13324033 --- /dev/null +++ b/sql/civicrm_option_groups/mail_approval_status.sqldata.php @@ -0,0 +1,10 @@ +addMetadata([ + 'title' => ts('CiviMail Approval Status'), + ]) + ->addValues(['label', 'name', 'value'], [ + [ts('Approved'), 'Approved', 1, 'is_default' => 1, 'is_reserved' => 1, 'component_id' => 4, 'domain_id' => 1], + [ts('Rejected'), 'Rejected', 2, 'is_reserved' => 1, 'component_id' => 4, 'domain_id' => 1], + [ts('None'), 'None', 3, 'is_reserved' => 1, 'component_id' => 4, 'domain_id' => 1], + ]); diff --git a/sql/civicrm_option_groups/system_extensions.sqldata.php b/sql/civicrm_option_groups/system_extensions.sqldata.php new file mode 100644 index 0000000000..4da5924bf7 --- /dev/null +++ b/sql/civicrm_option_groups/system_extensions.sqldata.php @@ -0,0 +1,8 @@ +addMetadata([ + 'title' => ts('CiviCRM Extensions'), + ]); diff --git a/xml/templates/civicrm_data.tpl b/xml/templates/civicrm_data.tpl index 56ee366c29..bee06cc8ef 100644 --- a/xml/templates/civicrm_data.tpl +++ b/xml/templates/civicrm_data.tpl @@ -134,10 +134,6 @@ VALUES SELECT @option_group_id_pi := max(id) from civicrm_option_group where name = 'payment_instrument'; -SELECT @option_group_id_extensions := max(id) from civicrm_option_group where name = 'system_extensions'; -SELECT @option_group_id_mail_approval_status := max(id) from civicrm_option_group where name = 'mail_approval_status'; -SELECT @option_group_id_engagement_index := max(id) from civicrm_option_group where name = 'engagement_index'; -SELECT @option_group_id_cgeo := max(id) from civicrm_option_group where name = 'cg_extend_objects'; SELECT @option_group_id_paperSize := max(id) from civicrm_option_group where name = 'paper_size'; SELECT @option_group_id_label := max(id) from civicrm_option_group where name = 'label_format'; SELECT @option_group_id_aco := max(id) from civicrm_option_group where name = 'activity_contacts'; @@ -178,13 +174,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 --- Engagement Level - (@option_group_id_engagement_index, '{ts escape="sql"}1{/ts}', 1, '1', NULL, 0, 0, 1, NULL, 0, 0, 1, NULL, NULL , NULL), - (@option_group_id_engagement_index, '{ts escape="sql"}2{/ts}', 2, '2', NULL, 0, 0, 2, NULL, 0, 0, 1, NULL, NULL , NULL), - (@option_group_id_engagement_index, '{ts escape="sql"}3{/ts}', 3, '3', NULL, 0, 0, 3, NULL, 0, 0, 1, NULL, NULL , NULL), - (@option_group_id_engagement_index, '{ts escape="sql"}4{/ts}', 4, '4', NULL, 0, 0, 4, NULL, 0, 0, 1, NULL, NULL , NULL), - (@option_group_id_engagement_index, '{ts escape="sql"}5{/ts}', 5, '5', NULL, 0, 0, 5, NULL, 0, 0, 1, NULL, NULL , NULL), - -- Paper Sizes (@option_group_id_paperSize, '{ts escape="sql"}Letter{/ts}', '{literal}{"metric":"in","width":8.5,"height":11}{/literal}', 'letter', NULL, NULL, 1, 1, NULL, 0, 0, 1, NULL, NULL, NULL), (@option_group_id_paperSize, '{ts escape="sql"}Legal{/ts}', '{literal}{"metric":"in","width":8.5,"height":14}{/literal}', 'legal', NULL, NULL, 0, 2, NULL, 0, 0, 1, NULL, NULL, NULL), @@ -484,21 +473,6 @@ VALUES ( '{ts escape="sql"}Deferred Revenue - Member Dues{/ts}', @contactID, @opLiability, 'Membership revenue to be recognized in future months', '2740', 'OCLIAB', 0, 1, 0, 0 ); --- Now insert option values which require domainID --- - -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`, `domain_id`, `visibility_id`) -VALUES - --- Mail Approval Status Preferences - (@option_group_id_mail_approval_status, '{ts escape="sql"}Approved{/ts}' , 1, 'Approved', NULL, 0, 1, 1, NULL, 0, 1, 1, @mailCompId, @domainID, NULL), - (@option_group_id_mail_approval_status, '{ts escape="sql"}Rejected{/ts}' , 2, 'Rejected', NULL, 0, 0, 2, NULL, 0, 1, 1, @mailCompId, @domainID, NULL), - (@option_group_id_mail_approval_status, '{ts escape="sql"}None{/ts}' , 3, 'None', NULL, 0, 0, 3, NULL, 0, 1, 1, @mailCompId, @domainID, NULL), - --- custom group objects - (@option_group_id_cgeo, '{ts escape="sql"}Survey{/ts}', 'Survey', 'civicrm_survey', NULL, 0, 0, 1, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_cgeo, '{ts escape="sql"}Cases{/ts}', 'Case', 'civicrm_case', 'case_type_id', 0, 0, 2, NULL, 0, 0, 1, NULL, NULL, NULL); -- CRM-6138 {include file='languages.tpl'} -- 2.25.1