From 0c93949c10398f687f0c73e7b68c0a1429b1174e Mon Sep 17 00:00:00 2001 From: Tim Otten Date: Wed, 17 May 2023 21:37:57 -0700 Subject: [PATCH] (REF) civicrm_option_groups - Use key-value-tree for messy OGs --- .../acl_role.sqldata.php | 15 +- .../activity_default_assignee.sqldata.php | 31 +- .../activity_status.sqldata.php | 59 ++- .../addressee.sqldata.php | 33 +- .../case_status.sqldata.php | 26 +- .../cg_extend_objects.sqldata.php | 15 +- .../communication_style.sqldata.php | 15 +- .../custom_data_type.sqldata.php | 23 +- .../custom_search.sqldata.php | 115 ++++- .../email_greeting.sqldata.php | 39 +- .../entity_batch_extends.sqldata.php | 10 +- .../event_badge.sqldata.php | 34 +- .../financial_account_type.sqldata.php | 48 +- .../mail_approval_status.sqldata.php | 30 +- .../msg_mode.sqldata.php | 24 +- .../name_badge.sqldata.php | 26 +- .../note_privacy.sqldata.php | 17 +- .../participant_listing.sqldata.php | 26 +- .../payment_instrument.sqldata.php | 36 +- .../pcp_owner_notify.sqldata.php | 24 +- .../pdf_format.sqldata.php | 9 +- .../redaction_rule.sqldata.php | 17 +- .../report_template.sqldata.php | 418 ++++++++++++++++-- 23 files changed, 937 insertions(+), 153 deletions(-) diff --git a/sql/civicrm_option_groups/acl_role.sqldata.php b/sql/civicrm_option_groups/acl_role.sqldata.php index 95a001290a..4caadde9cc 100644 --- a/sql/civicrm_option_groups/acl_role.sqldata.php +++ b/sql/civicrm_option_groups/acl_role.sqldata.php @@ -3,7 +3,16 @@ return CRM_Core_CodeGen_OptionGroup::create('acl_role', 'a/0008') ->addMetadata([ 'title' => ts('ACL Role'), ]) - ->addValueTable(['label', 'name', 'value'], [ - [ts('Administrator'), 'Admin', 1], - [ts('Authenticated'), 'Auth', 2, 'is_reserved' => 1], + ->addValues([ + [ + 'label' => ts('Administrator'), + 'value' => 1, + 'name' => 'Admin', + ], + [ + 'label' => ts('Authenticated'), + 'value' => 2, + 'name' => 'Auth', + 'is_reserved' => 1, + ], ]); diff --git a/sql/civicrm_option_groups/activity_default_assignee.sqldata.php b/sql/civicrm_option_groups/activity_default_assignee.sqldata.php index c9b6de29dd..c8021926cc 100644 --- a/sql/civicrm_option_groups/activity_default_assignee.sqldata.php +++ b/sql/civicrm_option_groups/activity_default_assignee.sqldata.php @@ -3,9 +3,30 @@ return CRM_Core_CodeGen_OptionGroup::create('activity_default_assignee', 'a/0082 ->addMetadata([ 'title' => ts('Activity default assignee'), ]) - ->addValueTable(['label', 'name', 'value', 'weight'], [ - [ts('None'), 'NONE', 1, 1, 'is_default' => 1], - [ts('By relationship to case client'), 'BY_RELATIONSHIP', 2, 1], - [ts('Specific contact'), 'SPECIFIC_CONTACT', 3, 1], - [ts('User creating the case'), 'USER_CREATING_THE_CASE', 4, 1], + ->addValues([ + [ + 'label' => ts('None'), + 'value' => 1, + 'name' => 'NONE', + 'is_default' => 1, + 'weight' => 1, + ], + [ + 'label' => ts('By relationship to case client'), + 'value' => 2, + 'name' => 'BY_RELATIONSHIP', + 'weight' => 1, + ], + [ + 'label' => ts('Specific contact'), + 'value' => 3, + 'name' => 'SPECIFIC_CONTACT', + 'weight' => 1, + ], + [ + 'label' => ts('User creating the case'), + 'value' => 4, + 'name' => 'USER_CREATING_THE_CASE', + 'weight' => 1, + ], ]); diff --git a/sql/civicrm_option_groups/activity_status.sqldata.php b/sql/civicrm_option_groups/activity_status.sqldata.php index 5f691bcc98..f27dc1bf19 100644 --- a/sql/civicrm_option_groups/activity_status.sqldata.php +++ b/sql/civicrm_option_groups/activity_status.sqldata.php @@ -5,13 +5,54 @@ return CRM_Core_CodeGen_OptionGroup::create('activity_status', 'a/0024') 'data_type' => 'Integer', 'option_value_fields' => 'name,label,description,color', ]) - ->addValueTable(['label', 'name', 'value'], [ - [ts('Scheduled'), 'Scheduled', 1, 'is_default' => 1, 'is_reserved' => 1], - [ts('Completed'), 'Completed', 2, 'filter' => 1, 'is_reserved' => 1], - [ts('Cancelled'), 'Cancelled', 3, 'filter' => 2, 'is_reserved' => 1], - [ts('Left Message'), 'Left Message', 4], - [ts('Unreachable'), 'Unreachable', 5, 'filter' => 2], - [ts('Not Required'), 'Not Required', 6, 'filter' => 2], - [ts('Available'), 'Available', 7], - [ts('No-show'), 'No_show', 8, 'filter' => 2], + ->addValues([ + [ + 'label' => ts('Scheduled'), + 'value' => 1, + 'name' => 'Scheduled', + 'is_default' => 1, + 'is_reserved' => 1, + ], + [ + 'label' => ts('Completed'), + 'value' => 2, + 'name' => 'Completed', + 'filter' => 1, + 'is_reserved' => 1, + ], + [ + 'label' => ts('Cancelled'), + 'value' => 3, + 'name' => 'Cancelled', + 'filter' => 2, + 'is_reserved' => 1, + ], + [ + 'label' => ts('Left Message'), + 'value' => 4, + 'name' => 'Left Message', + ], + [ + 'label' => ts('Unreachable'), + 'value' => 5, + 'name' => 'Unreachable', + 'filter' => 2, + ], + [ + 'label' => ts('Not Required'), + 'value' => 6, + 'name' => 'Not Required', + 'filter' => 2, + ], + [ + 'label' => ts('Available'), + 'value' => 7, + 'name' => 'Available', + ], + [ + 'label' => ts('No-show'), + 'value' => 8, + 'name' => 'No_show', + 'filter' => 2, + ], ]); diff --git a/sql/civicrm_option_groups/addressee.sqldata.php b/sql/civicrm_option_groups/addressee.sqldata.php index 6cf090be50..30c25e3afd 100644 --- a/sql/civicrm_option_groups/addressee.sqldata.php +++ b/sql/civicrm_option_groups/addressee.sqldata.php @@ -3,9 +3,32 @@ return CRM_Core_CodeGen_OptionGroup::create('addressee', 'a/0042') ->addMetadata([ 'title' => ts('Addressee Type'), ]) - ->addValueTable(['label', 'name', 'value'], [ - ['{contact.prefix_id:label}{ }{contact.first_name}{ }{contact.middle_name}{ }{contact.last_name}{ }{contact.suffix_id:label}', '{contact.prefix_id:label}{ }{contact.first_name}{ }{contact.middle_name}{ }{contact.last_name}{ }{contact.suffix_id:label}', 1, 'filter' => 1, 'is_default' => 1], - ['{contact.household_name}', '{contact.household_name}', 2, 'filter' => 2, 'is_default' => 1], - ['{contact.organization_name}', '{contact.organization_name}', 3, 'filter' => 3, 'is_default' => 1], - ['Customized', 'Customized', 4, 'is_reserved' => 1], + ->addValues([ + [ + 'label' => '{contact.prefix_id:label}{ }{contact.first_name}{ }{contact.middle_name}{ }{contact.last_name}{ }{contact.suffix_id:label}', + 'value' => 1, + 'name' => '{contact.prefix_id:label}{ }{contact.first_name}{ }{contact.middle_name}{ }{contact.last_name}{ }{contact.suffix_id:label}', + 'filter' => 1, + 'is_default' => 1, + ], + [ + 'label' => '{contact.household_name}', + 'value' => 2, + 'name' => '{contact.household_name}', + 'filter' => 2, + 'is_default' => 1, + ], + [ + 'label' => '{contact.organization_name}', + 'value' => 3, + 'name' => '{contact.organization_name}', + 'filter' => 3, + 'is_default' => 1, + ], + [ + 'label' => 'Customized', + 'value' => 4, + 'name' => 'Customized', + 'is_reserved' => 1, + ], ]); diff --git a/sql/civicrm_option_groups/case_status.sqldata.php b/sql/civicrm_option_groups/case_status.sqldata.php index e9125de8bb..41cc891f58 100644 --- a/sql/civicrm_option_groups/case_status.sqldata.php +++ b/sql/civicrm_option_groups/case_status.sqldata.php @@ -4,8 +4,26 @@ return CRM_Core_CodeGen_OptionGroup::create('case_status', 'a/0026') 'title' => ts('Case Status'), 'option_value_fields' => 'name,label,description,color', ]) - ->addValueTable(['label', 'name', 'value'], [ - [ts('Ongoing'), 'Open', 1, 'grouping' => 'Opened', 'is_default' => 1, 'is_reserved' => 1], - [ts('Resolved'), 'Closed', 2, 'grouping' => 'Closed', 'is_reserved' => 1], - [ts('Urgent'), 'Urgent', 3, 'grouping' => 'Opened'], + ->addValues([ + [ + 'label' => ts('Ongoing'), + 'value' => 1, + 'name' => 'Open', + 'grouping' => 'Opened', + 'is_default' => 1, + 'is_reserved' => 1, + ], + [ + 'label' => ts('Resolved'), + 'value' => 2, + 'name' => 'Closed', + 'grouping' => 'Closed', + 'is_reserved' => 1, + ], + [ + 'label' => ts('Urgent'), + 'value' => 3, + 'name' => 'Urgent', + 'grouping' => 'Opened', + ], ]); diff --git a/sql/civicrm_option_groups/cg_extend_objects.sqldata.php b/sql/civicrm_option_groups/cg_extend_objects.sqldata.php index 467688aaf5..3fd3a5b2d3 100644 --- a/sql/civicrm_option_groups/cg_extend_objects.sqldata.php +++ b/sql/civicrm_option_groups/cg_extend_objects.sqldata.php @@ -3,7 +3,16 @@ return CRM_Core_CodeGen_OptionGroup::create('cg_extend_objects', 'a/0056') ->addMetadata([ 'title' => ts('Objects a custom group extends to'), ]) - ->addValueTable(['label', 'name', 'value'], [ - [ts('Survey'), 'civicrm_survey', 'Survey'], - [ts('Cases'), 'civicrm_case', 'Case', 'grouping' => 'case_type_id'], + ->addValues([ + [ + 'label' => ts('Survey'), + 'value' => 'Survey', + 'name' => 'civicrm_survey', + ], + [ + 'label' => ts('Cases'), + 'value' => 'Case', + 'name' => 'civicrm_case', + 'grouping' => 'case_type_id', + ], ]); diff --git a/sql/civicrm_option_groups/communication_style.sqldata.php b/sql/civicrm_option_groups/communication_style.sqldata.php index c3de9f55f3..be01faeff2 100644 --- a/sql/civicrm_option_groups/communication_style.sqldata.php +++ b/sql/civicrm_option_groups/communication_style.sqldata.php @@ -3,7 +3,16 @@ return CRM_Core_CodeGen_OptionGroup::create('communication_style', 'a/0074') ->addMetadata([ 'title' => ts('Communication Style'), ]) - ->addValueTable(['label', 'name', 'value'], [ - [ts('Formal'), 'formal', 1, 'is_default' => 1], - [ts('Familiar'), 'familiar', 2], + ->addValues([ + [ + 'label' => ts('Formal'), + 'value' => 1, + 'name' => 'formal', + 'is_default' => 1, + ], + [ + 'label' => ts('Familiar'), + 'value' => 2, + 'name' => 'familiar', + ], ]); diff --git a/sql/civicrm_option_groups/custom_data_type.sqldata.php b/sql/civicrm_option_groups/custom_data_type.sqldata.php index 1103cdd91f..0ecea058f3 100644 --- a/sql/civicrm_option_groups/custom_data_type.sqldata.php +++ b/sql/civicrm_option_groups/custom_data_type.sqldata.php @@ -3,8 +3,23 @@ return CRM_Core_CodeGen_OptionGroup::create('custom_data_type', 'a/0034') ->addMetadata([ 'title' => ts('Custom Data Type'), ]) - ->addValueTable(['label', 'name', 'value'], [ - [ts('Participants (Role)'), 'ParticipantRole', 1, 'grouping' => 'role_id'], - [ts('Participants (Event Name)'), 'ParticipantEventName', 2, 'grouping' => 'event_id'], - [ts('Participants (Event Type)'), 'ParticipantEventType', 3, 'grouping' => 'event_id.event_type_id'], + ->addValues([ + [ + 'label' => ts('Participants (Role)'), + 'value' => 1, + 'name' => 'ParticipantRole', + 'grouping' => 'role_id', + ], + [ + 'label' => ts('Participants (Event Name)'), + 'value' => 2, + 'name' => 'ParticipantEventName', + 'grouping' => 'event_id', + ], + [ + 'label' => ts('Participants (Event Type)'), + 'value' => 3, + 'name' => 'ParticipantEventType', + 'grouping' => 'event_id.event_type_id', + ], ]); diff --git a/sql/civicrm_option_groups/custom_search.sqldata.php b/sql/civicrm_option_groups/custom_search.sqldata.php index 0c4562fe1f..b52d9ae173 100644 --- a/sql/civicrm_option_groups/custom_search.sqldata.php +++ b/sql/civicrm_option_groups/custom_search.sqldata.php @@ -3,19 +3,104 @@ return CRM_Core_CodeGen_OptionGroup::create('custom_search', 'a/0023') ->addMetadata([ 'title' => ts('Custom Search'), ]) - ->addValueTable(['label', 'name', 'value', 'weight', 'description'], [ - ['CRM_Contact_Form_Search_Custom_Sample', 'CRM_Contact_Form_Search_Custom_Sample', 1, 1, ts('Household Name and State')], - ['CRM_Contact_Form_Search_Custom_ContributionAggregate', 'CRM_Contact_Form_Search_Custom_ContributionAggregate', 2, 2, ts('Contribution Aggregate')], - ['CRM_Contact_Form_Search_Custom_Group', 'CRM_Contact_Form_Search_Custom_Group', 4, 4, ts('Include / Exclude Search')], - ['CRM_Contact_Form_Search_Custom_PostalMailing', 'CRM_Contact_Form_Search_Custom_PostalMailing', 5, 5, ts('Postal Mailing')], - ['CRM_Contact_Form_Search_Custom_Proximity', 'CRM_Contact_Form_Search_Custom_Proximity', 6, 6, ts('Proximity Search')], - ['CRM_Contact_Form_Search_Custom_EventAggregate', 'CRM_Contact_Form_Search_Custom_EventAggregate', 7, 7, ts('Event Aggregate')], - ['CRM_Contact_Form_Search_Custom_ActivitySearch', 'CRM_Contact_Form_Search_Custom_ActivitySearch', 8, 8, ts('Activity Search'), 'is_active' => 0], - ['CRM_Contact_Form_Search_Custom_PriceSet', 'CRM_Contact_Form_Search_Custom_PriceSet', 9, 9, ts('Price Set Details for Event Participants')], - ['CRM_Contact_Form_Search_Custom_ZipCodeRange', 'CRM_Contact_Form_Search_Custom_ZipCodeRange', 10, 10, ts('Zip Code Range')], - ['CRM_Contact_Form_Search_Custom_DateAdded', 'CRM_Contact_Form_Search_Custom_DateAdded', 11, 11, ts('Date Added to CiviCRM')], - ['CRM_Contact_Form_Search_Custom_MultipleValues', 'CRM_Contact_Form_Search_Custom_MultipleValues', 12, 12, ts('Custom Group Multiple Values Listing')], - ['CRM_Contact_Form_Search_Custom_ContribSYBNT', 'CRM_Contact_Form_Search_Custom_ContribSYBNT', 13, 13, ts('Contributions made in Year X and not Year Y')], - ['CRM_Contact_Form_Search_Custom_TagContributions', 'CRM_Contact_Form_Search_Custom_TagContributions', 14, 14, ts('Find Contribution Amounts by Tag')], - ['CRM_Contact_Form_Search_Custom_FullText', 'CRM_Contact_Form_Search_Custom_FullText', 15, 15, ts('Full-text Search')], + ->addValues([ + [ + 'label' => 'CRM_Contact_Form_Search_Custom_Sample', + 'value' => 1, + 'name' => 'CRM_Contact_Form_Search_Custom_Sample', + 'weight' => 1, + 'description' => ts('Household Name and State'), + ], + [ + 'label' => 'CRM_Contact_Form_Search_Custom_ContributionAggregate', + 'value' => 2, + 'name' => 'CRM_Contact_Form_Search_Custom_ContributionAggregate', + 'weight' => 2, + 'description' => ts('Contribution Aggregate'), + ], + [ + 'label' => 'CRM_Contact_Form_Search_Custom_Group', + 'value' => 4, + 'name' => 'CRM_Contact_Form_Search_Custom_Group', + 'weight' => 4, + 'description' => ts('Include / Exclude Search'), + ], + [ + 'label' => 'CRM_Contact_Form_Search_Custom_PostalMailing', + 'value' => 5, + 'name' => 'CRM_Contact_Form_Search_Custom_PostalMailing', + 'weight' => 5, + 'description' => ts('Postal Mailing'), + ], + [ + 'label' => 'CRM_Contact_Form_Search_Custom_Proximity', + 'value' => 6, + 'name' => 'CRM_Contact_Form_Search_Custom_Proximity', + 'weight' => 6, + 'description' => ts('Proximity Search'), + ], + [ + 'label' => 'CRM_Contact_Form_Search_Custom_EventAggregate', + 'value' => 7, + 'name' => 'CRM_Contact_Form_Search_Custom_EventAggregate', + 'weight' => 7, + 'description' => ts('Event Aggregate'), + ], + [ + 'label' => 'CRM_Contact_Form_Search_Custom_ActivitySearch', + 'value' => 8, + 'name' => 'CRM_Contact_Form_Search_Custom_ActivitySearch', + 'weight' => 8, + 'description' => ts('Activity Search'), + 'is_active' => 0, + ], + [ + 'label' => 'CRM_Contact_Form_Search_Custom_PriceSet', + 'value' => 9, + 'name' => 'CRM_Contact_Form_Search_Custom_PriceSet', + 'weight' => 9, + 'description' => ts('Price Set Details for Event Participants'), + ], + [ + 'label' => 'CRM_Contact_Form_Search_Custom_ZipCodeRange', + 'value' => 10, + 'name' => 'CRM_Contact_Form_Search_Custom_ZipCodeRange', + 'weight' => 10, + 'description' => ts('Zip Code Range'), + ], + [ + 'label' => 'CRM_Contact_Form_Search_Custom_DateAdded', + 'value' => 11, + 'name' => 'CRM_Contact_Form_Search_Custom_DateAdded', + 'weight' => 11, + 'description' => ts('Date Added to CiviCRM'), + ], + [ + 'label' => 'CRM_Contact_Form_Search_Custom_MultipleValues', + 'value' => 12, + 'name' => 'CRM_Contact_Form_Search_Custom_MultipleValues', + 'weight' => 12, + 'description' => ts('Custom Group Multiple Values Listing'), + ], + [ + 'label' => 'CRM_Contact_Form_Search_Custom_ContribSYBNT', + 'value' => 13, + 'name' => 'CRM_Contact_Form_Search_Custom_ContribSYBNT', + 'weight' => 13, + 'description' => ts('Contributions made in Year X and not Year Y'), + ], + [ + 'label' => 'CRM_Contact_Form_Search_Custom_TagContributions', + 'value' => 14, + 'name' => 'CRM_Contact_Form_Search_Custom_TagContributions', + 'weight' => 14, + 'description' => ts('Find Contribution Amounts by Tag'), + ], + [ + 'label' => 'CRM_Contact_Form_Search_Custom_FullText', + 'value' => 15, + 'name' => 'CRM_Contact_Form_Search_Custom_FullText', + 'weight' => 15, + 'description' => ts('Full-text Search'), + ], ]); diff --git a/sql/civicrm_option_groups/email_greeting.sqldata.php b/sql/civicrm_option_groups/email_greeting.sqldata.php index 299cc39a41..de7ac44e6f 100644 --- a/sql/civicrm_option_groups/email_greeting.sqldata.php +++ b/sql/civicrm_option_groups/email_greeting.sqldata.php @@ -3,10 +3,37 @@ return CRM_Core_CodeGen_OptionGroup::create('email_greeting', 'a/0040') ->addMetadata([ 'title' => ts('Email Greeting Type'), ]) - ->addValueTable(['label', 'name', 'value'], [ - ['Dear {contact.first_name}', 'Dear {contact.first_name}', 1, 'filter' => 1, 'is_default' => 1], - ['Dear {contact.prefix_id:label} {contact.first_name} {contact.last_name}', 'Dear {contact.prefix_id:label} {contact.first_name} {contact.last_name}', 2, 'filter' => 1], - ['Dear {contact.prefix_id:label} {contact.last_name}', 'Dear {contact.prefix_id:label} {contact.last_name}', 3, 'filter' => 1], - ['Customized', 'Customized', 4, 'is_reserved' => 1], - ['Dear {contact.household_name}', 'Dear {contact.household_name}', 5, 'filter' => 2, 'is_default' => 1], + ->addValues([ + [ + 'label' => 'Dear {contact.first_name}', + 'value' => 1, + 'name' => 'Dear {contact.first_name}', + 'filter' => 1, + 'is_default' => 1, + ], + [ + 'label' => 'Dear {contact.prefix_id:label} {contact.first_name} {contact.last_name}', + 'value' => 2, + 'name' => 'Dear {contact.prefix_id:label} {contact.first_name} {contact.last_name}', + 'filter' => 1, + ], + [ + 'label' => 'Dear {contact.prefix_id:label} {contact.last_name}', + 'value' => 3, + 'name' => 'Dear {contact.prefix_id:label} {contact.last_name}', + 'filter' => 1, + ], + [ + 'label' => 'Customized', + 'value' => 4, + 'name' => 'Customized', + 'is_reserved' => 1, + ], + [ + 'label' => 'Dear {contact.household_name}', + 'value' => 5, + 'name' => 'Dear {contact.household_name}', + 'filter' => 2, + 'is_default' => 1, + ], ]); diff --git a/sql/civicrm_option_groups/entity_batch_extends.sqldata.php b/sql/civicrm_option_groups/entity_batch_extends.sqldata.php index 55762609e6..937d07eb9f 100644 --- a/sql/civicrm_option_groups/entity_batch_extends.sqldata.php +++ b/sql/civicrm_option_groups/entity_batch_extends.sqldata.php @@ -3,6 +3,12 @@ return CRM_Core_CodeGen_OptionGroup::create('entity_batch_extends', 'a/0083') ->addMetadata([ 'title' => ts('Entity Batch Extends'), ]) - ->addValueTable(['label', 'name', 'value'], [ - [ts('Financial Transactions'), 'civicrm_financial_trxn', 'civicrm_financial_trxn', 'is_default' => 1, 'component_id' => 2], + ->addValues([ + [ + 'label' => ts('Financial Transactions'), + 'value' => 'civicrm_financial_trxn', + 'name' => 'civicrm_financial_trxn', + 'is_default' => 1, + 'component_id' => 2, + ], ]); diff --git a/sql/civicrm_option_groups/event_badge.sqldata.php b/sql/civicrm_option_groups/event_badge.sqldata.php index 48112c145a..64721f241f 100644 --- a/sql/civicrm_option_groups/event_badge.sqldata.php +++ b/sql/civicrm_option_groups/event_badge.sqldata.php @@ -3,9 +3,33 @@ return CRM_Core_CodeGen_OptionGroup::create('event_badge', 'a/0049') ->addMetadata([ 'title' => ts('Event Name Badge'), ]) - ->addValueTable(['label', 'name', 'value', 'description'], [ - [ts('Name Only'), 'CRM_Event_Badge_Simple', 1, ts('Simple Event Name Badge'), 'is_reserved' => 1], - [ts('Name Tent'), 'CRM_Event_Badge_NameTent', 2, ts('Name Tent'), 'is_reserved' => 1], - [ts('With Logo'), 'CRM_Event_Badge_Logo', 3, ts('You can set your own background image'), 'is_reserved' => 1], - [ts('5395 with Logo'), 'CRM_Event_Badge_Logo5395', 4, ts('Avery 5395 compatible labels with logo (4 up by 2, 59.2mm x 85.7mm)'), 'is_reserved' => 1], + ->addValues([ + [ + 'label' => ts('Name Only'), + 'value' => 1, + 'name' => 'CRM_Event_Badge_Simple', + 'description' => ts('Simple Event Name Badge'), + 'is_reserved' => 1, + ], + [ + 'label' => ts('Name Tent'), + 'value' => 2, + 'name' => 'CRM_Event_Badge_NameTent', + 'description' => ts('Name Tent'), + 'is_reserved' => 1, + ], + [ + 'label' => ts('With Logo'), + 'value' => 3, + 'name' => 'CRM_Event_Badge_Logo', + 'description' => ts('You can set your own background image'), + 'is_reserved' => 1, + ], + [ + 'label' => ts('5395 with Logo'), + 'value' => 4, + 'name' => 'CRM_Event_Badge_Logo5395', + 'description' => ts('Avery 5395 compatible labels with logo (4 up by 2, 59.2mm x 85.7mm)'), + 'is_reserved' => 1, + ], ]); diff --git a/sql/civicrm_option_groups/financial_account_type.sqldata.php b/sql/civicrm_option_groups/financial_account_type.sqldata.php index 5e36e6a4b4..b5d3972b0f 100644 --- a/sql/civicrm_option_groups/financial_account_type.sqldata.php +++ b/sql/civicrm_option_groups/financial_account_type.sqldata.php @@ -3,10 +3,46 @@ return CRM_Core_CodeGen_OptionGroup::create('financial_account_type', 'a/0070') ->addMetadata([ 'title' => ts('Financial Account Type'), ]) - ->addValueTable(['label', 'name', 'value', 'description'], [ - [ts('Asset'), 'Asset', 1, ts('Things you own'), 'is_reserved' => 1, 'component_id' => 2], - [ts('Liability'), 'Liability', 2, ts('Things you owe, like a grant still to be disbursed'), 'is_reserved' => 1, 'component_id' => 2], - [ts('Revenue'), 'Revenue', 3, ts('Income from contributions and sales of tickets and memberships'), 'is_default' => 1, 'is_reserved' => 1, 'component_id' => 2], - [ts('Cost of Sales'), 'Cost of Sales', 4, ts('Costs incurred to get revenue, e.g. premiums for donations, dinner for a fundraising dinner ticket'), 'is_reserved' => 1, 'component_id' => 2], - [ts('Expenses'), 'Expenses', 5, ts('Things that are paid for that are consumable, e.g. grants disbursed'), 'is_reserved' => 1, 'component_id' => 2], + ->addValues([ + [ + 'label' => ts('Asset'), + 'value' => 1, + 'name' => 'Asset', + 'description' => ts('Things you own'), + 'is_reserved' => 1, + 'component_id' => 2, + ], + [ + 'label' => ts('Liability'), + 'value' => 2, + 'name' => 'Liability', + 'description' => ts('Things you owe, like a grant still to be disbursed'), + 'is_reserved' => 1, + 'component_id' => 2, + ], + [ + 'label' => ts('Revenue'), + 'value' => 3, + 'name' => 'Revenue', + 'is_default' => 1, + 'description' => ts('Income from contributions and sales of tickets and memberships'), + 'is_reserved' => 1, + 'component_id' => 2, + ], + [ + 'label' => ts('Cost of Sales'), + 'value' => 4, + 'name' => 'Cost of Sales', + 'description' => ts('Costs incurred to get revenue, e.g. premiums for donations, dinner for a fundraising dinner ticket'), + 'is_reserved' => 1, + 'component_id' => 2, + ], + [ + 'label' => ts('Expenses'), + 'value' => 5, + 'name' => 'Expenses', + 'description' => ts('Things that are paid for that are consumable, e.g. grants disbursed'), + 'is_reserved' => 1, + 'component_id' => 2, + ], ]); diff --git a/sql/civicrm_option_groups/mail_approval_status.sqldata.php b/sql/civicrm_option_groups/mail_approval_status.sqldata.php index 1b6ff70fea..66d8a2f100 100644 --- a/sql/civicrm_option_groups/mail_approval_status.sqldata.php +++ b/sql/civicrm_option_groups/mail_approval_status.sqldata.php @@ -3,8 +3,30 @@ return CRM_Core_CodeGen_OptionGroup::create('mail_approval_status', 'a/0054') ->addMetadata([ 'title' => ts('CiviMail Approval Status'), ]) - ->addValueTable(['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], + ->addValues([ + [ + 'label' => ts('Approved'), + 'value' => 1, + 'name' => 'Approved', + 'is_default' => 1, + 'is_reserved' => 1, + 'component_id' => 4, + 'domain_id' => 1, + ], + [ + 'label' => ts('Rejected'), + 'value' => 2, + 'name' => 'Rejected', + 'is_reserved' => 1, + 'component_id' => 4, + 'domain_id' => 1, + ], + [ + 'label' => ts('None'), + 'value' => 3, + 'name' => 'None', + 'is_reserved' => 1, + 'component_id' => 4, + 'domain_id' => 1, + ], ]); diff --git a/sql/civicrm_option_groups/msg_mode.sqldata.php b/sql/civicrm_option_groups/msg_mode.sqldata.php index f302cb3653..aef74bb52c 100644 --- a/sql/civicrm_option_groups/msg_mode.sqldata.php +++ b/sql/civicrm_option_groups/msg_mode.sqldata.php @@ -3,8 +3,24 @@ return CRM_Core_CodeGen_OptionGroup::create('msg_mode', 'a/0075') ->addMetadata([ 'title' => ts('Message Mode'), ]) - ->addValueTable(['label', 'name', 'value'], [ - [ts('Email'), 'Email', 'Email', 'is_default' => 1, 'is_reserved' => 1], - [ts('SMS'), 'SMS', 'SMS', 'is_reserved' => 1], - [ts('User Preference'), 'User Preference', 'User_Preference', 'is_reserved' => 1], + ->addValues([ + [ + 'label' => ts('Email'), + 'value' => 'Email', + 'name' => 'Email', + 'is_default' => 1, + 'is_reserved' => 1, + ], + [ + 'label' => ts('SMS'), + 'value' => 'SMS', + 'name' => 'SMS', + 'is_reserved' => 1, + ], + [ + 'label' => ts('User Preference'), + 'value' => 'User_Preference', + 'name' => 'User Preference', + 'is_reserved' => 1, + ], ]); diff --git a/sql/civicrm_option_groups/name_badge.sqldata.php b/sql/civicrm_option_groups/name_badge.sqldata.php index 2c92b8c681..0f2c8f67cc 100644 --- a/sql/civicrm_option_groups/name_badge.sqldata.php +++ b/sql/civicrm_option_groups/name_badge.sqldata.php @@ -3,9 +3,25 @@ return CRM_Core_CodeGen_OptionGroup::create('name_badge', 'a/0073') ->addMetadata([ 'title' => ts('Name Badge Format'), ]) - ->addValueTable(['label', 'name', 'value'], [ - [ts('Avery 5395'), 'Avery 5395', '{"name":"Avery 5395","paper-size":"a4","metric":"mm","lMargin":15,"tMargin":26,"NX":2,"NY":4,"SpaceX":10,"SpaceY":5,"width":83,"height":57,"font-size":12,"orientation":"portrait","font-name":"helvetica","font-style":"","lPadding":3,"tPadding":3}'], - [ts('A6 Badge Portrait 150x106'), 'A6 Badge Portrait 150x106', '{"paper-size":"a4","orientation":"landscape","font-name":"times","font-size":6,"font-style":"","NX":2,"NY":1,"metric":"mm","lMargin":25,"tMargin":27,"SpaceX":0,"SpaceY":35,"width":106,"height":150,"lPadding":5,"tPadding":5}'], - [ts('Fattorini Name Badge 100x65'), 'Fattorini Name Badge 100x65', '{"paper-size":"a4","orientation":"portrait","font-name":"times","font-size":6,"font-style":"","NX":2,"NY":4,"metric":"mm","lMargin":6,"tMargin":19,"SpaceX":0,"SpaceY":0,"width":100,"height":65,"lPadding":0,"tPadding":0}'], - [ts('Hanging Badge 3-3/4" x 4-3"/4'), 'Hanging Badge 3-3/4" x 4-3"/4', '{"paper-size":"a4","orientation":"portrait","font-name":"times","font-size":6,"font-style":"","NX":2,"NY":2,"metric":"mm","lMargin":10,"tMargin":28,"SpaceX":0,"SpaceY":0,"width":96,"height":121,"lPadding":5,"tPadding":5}'], + ->addValues([ + [ + 'label' => ts('Avery 5395'), + 'value' => '{"name":"Avery 5395","paper-size":"a4","metric":"mm","lMargin":15,"tMargin":26,"NX":2,"NY":4,"SpaceX":10,"SpaceY":5,"width":83,"height":57,"font-size":12,"orientation":"portrait","font-name":"helvetica","font-style":"","lPadding":3,"tPadding":3}', + 'name' => 'Avery 5395', + ], + [ + 'label' => ts('A6 Badge Portrait 150x106'), + 'value' => '{"paper-size":"a4","orientation":"landscape","font-name":"times","font-size":6,"font-style":"","NX":2,"NY":1,"metric":"mm","lMargin":25,"tMargin":27,"SpaceX":0,"SpaceY":35,"width":106,"height":150,"lPadding":5,"tPadding":5}', + 'name' => 'A6 Badge Portrait 150x106', + ], + [ + 'label' => ts('Fattorini Name Badge 100x65'), + 'value' => '{"paper-size":"a4","orientation":"portrait","font-name":"times","font-size":6,"font-style":"","NX":2,"NY":4,"metric":"mm","lMargin":6,"tMargin":19,"SpaceX":0,"SpaceY":0,"width":100,"height":65,"lPadding":0,"tPadding":0}', + 'name' => 'Fattorini Name Badge 100x65', + ], + [ + 'label' => ts('Hanging Badge 3-3/4" x 4-3"/4'), + 'value' => '{"paper-size":"a4","orientation":"portrait","font-name":"times","font-size":6,"font-style":"","NX":2,"NY":2,"metric":"mm","lMargin":10,"tMargin":28,"SpaceX":0,"SpaceY":0,"width":96,"height":121,"lPadding":5,"tPadding":5}', + 'name' => 'Hanging Badge 3-3/4" x 4-3"/4', + ], ]); diff --git a/sql/civicrm_option_groups/note_privacy.sqldata.php b/sql/civicrm_option_groups/note_privacy.sqldata.php index 2588f68e43..3c79d882a0 100644 --- a/sql/civicrm_option_groups/note_privacy.sqldata.php +++ b/sql/civicrm_option_groups/note_privacy.sqldata.php @@ -3,7 +3,18 @@ return CRM_Core_CodeGen_OptionGroup::create('note_privacy', 'a/0050') ->addMetadata([ 'title' => ts('Privacy levels for notes'), ]) - ->addValueTable(['label', 'name', 'value'], [ - [ts('None'), 'None', 0, 'is_default' => 1, 'is_reserved' => 1], - [ts('Author Only'), 'Author Only', 1, 'is_reserved' => 1], + ->addValues([ + [ + 'label' => ts('None'), + 'value' => 0, + 'name' => 'None', + 'is_default' => 1, + 'is_reserved' => 1, + ], + [ + 'label' => ts('Author Only'), + 'value' => 1, + 'name' => 'Author Only', + 'is_reserved' => 1, + ], ]); diff --git a/sql/civicrm_option_groups/participant_listing.sqldata.php b/sql/civicrm_option_groups/participant_listing.sqldata.php index 884e8bb3a6..b7f2c187c6 100644 --- a/sql/civicrm_option_groups/participant_listing.sqldata.php +++ b/sql/civicrm_option_groups/participant_listing.sqldata.php @@ -3,8 +3,26 @@ return CRM_Core_CodeGen_OptionGroup::create('participant_listing', 'a/0027') ->addMetadata([ 'title' => ts('Participant Listing'), ]) - ->addValueTable(['label', 'name', 'value', 'description'], [ - [ts('Name Only'), 'Name Only', 1, ts('CRM_Event_Page_ParticipantListing_Name'), 'is_reserved' => 1], - [ts('Name and Email'), 'Name and Email', 2, ts('CRM_Event_Page_ParticipantListing_NameAndEmail'), 'is_reserved' => 1], - [ts('Name, Status and Register Date'), 'Name, Status and Register Date', 3, ts('CRM_Event_Page_ParticipantListing_NameStatusAndDate'), 'is_reserved' => 1], + ->addValues([ + [ + 'label' => ts('Name Only'), + 'value' => 1, + 'name' => 'Name Only', + 'description' => ts('CRM_Event_Page_ParticipantListing_Name'), + 'is_reserved' => 1, + ], + [ + 'label' => ts('Name and Email'), + 'value' => 2, + 'name' => 'Name and Email', + 'description' => ts('CRM_Event_Page_ParticipantListing_NameAndEmail'), + 'is_reserved' => 1, + ], + [ + 'label' => ts('Name, Status and Register Date'), + 'value' => 3, + 'name' => 'Name, Status and Register Date', + 'description' => ts('CRM_Event_Page_ParticipantListing_NameStatusAndDate'), + 'is_reserved' => 1, + ], ]); diff --git a/sql/civicrm_option_groups/payment_instrument.sqldata.php b/sql/civicrm_option_groups/payment_instrument.sqldata.php index 90aec10c11..cca6514100 100644 --- a/sql/civicrm_option_groups/payment_instrument.sqldata.php +++ b/sql/civicrm_option_groups/payment_instrument.sqldata.php @@ -5,10 +5,34 @@ return CRM_Core_CodeGen_OptionGroup::create('payment_instrument', 'a/0010') 'description' => ts('You may choose to record the payment method used for each contribution and fee. Reserved payment methods are required - you may modify their labels but they can not be deleted (e.g. Check, Credit Card, Debit Card). If your site requires additional payment methods, you can add them here. You can associate each payment method with a Financial Account which specifies where the payment is going (e.g. a bank account for checks and cash).'), 'data_type' => 'Integer', ]) - ->addValueTable(['label', 'name', 'value'], [ - [ts('Credit Card'), 'Credit Card', 1, 'is_reserved' => 1], - [ts('Debit Card'), 'Debit Card', 2, 'is_reserved' => 1], - [ts('Cash'), 'Cash', 3], - [ts('Check'), 'Check', 4, 'is_default' => 1, 'is_reserved' => 1], - [ts('EFT'), 'EFT', 5], + ->addValues([ + [ + 'label' => ts('Credit Card'), + 'value' => 1, + 'name' => 'Credit Card', + 'is_reserved' => 1, + ], + [ + 'label' => ts('Debit Card'), + 'value' => 2, + 'name' => 'Debit Card', + 'is_reserved' => 1, + ], + [ + 'label' => ts('Cash'), + 'value' => 3, + 'name' => 'Cash', + ], + [ + 'label' => ts('Check'), + 'value' => 4, + 'name' => 'Check', + 'is_default' => 1, + 'is_reserved' => 1, + ], + [ + 'label' => ts('EFT'), + 'value' => 5, + 'name' => 'EFT', + ], ]); diff --git a/sql/civicrm_option_groups/pcp_owner_notify.sqldata.php b/sql/civicrm_option_groups/pcp_owner_notify.sqldata.php index 51e775a242..20ed1361c5 100644 --- a/sql/civicrm_option_groups/pcp_owner_notify.sqldata.php +++ b/sql/civicrm_option_groups/pcp_owner_notify.sqldata.php @@ -4,8 +4,24 @@ return CRM_Core_CodeGen_OptionGroup::create('pcp_owner_notify', 'a/0013') 'title' => ts('PCP owner notifications'), 'is_locked' => 1, ]) - ->addValueTable(['label', 'name', 'value'], [ - [ts('Owner chooses whether to receive notifications'), 'owner_chooses', 1, 'is_default' => 1, 'is_reserved' => 1], - [ts('Notifications are sent to ALL owners'), 'all_owners', 2, 'is_reserved' => 1], - [ts('Notifications are NOT available'), 'no_notifications', 3, 'is_reserved' => 1], + ->addValues([ + [ + 'label' => ts('Owner chooses whether to receive notifications'), + 'value' => 1, + 'name' => 'owner_chooses', + 'is_default' => 1, + 'is_reserved' => 1, + ], + [ + 'label' => ts('Notifications are sent to ALL owners'), + 'value' => 2, + 'name' => 'all_owners', + 'is_reserved' => 1, + ], + [ + 'label' => ts('Notifications are NOT available'), + 'value' => 3, + 'name' => 'no_notifications', + 'is_reserved' => 1, + ], ]); diff --git a/sql/civicrm_option_groups/pdf_format.sqldata.php b/sql/civicrm_option_groups/pdf_format.sqldata.php index 6a8ea92b8a..31392e769c 100644 --- a/sql/civicrm_option_groups/pdf_format.sqldata.php +++ b/sql/civicrm_option_groups/pdf_format.sqldata.php @@ -3,6 +3,11 @@ return CRM_Core_CodeGen_OptionGroup::create('pdf_format', 'a/0058') ->addMetadata([ 'title' => ts('PDF Page Format'), ]) - ->addValueTable(['label', 'name', 'value'], [ - [ts('Invoice PDF Format'), 'default_invoice_pdf_format', '{"metric":"px","margin_top":10,"margin_bottom":0,"margin_left":65,"margin_right":0}', 'is_reserved' => 1], + ->addValues([ + [ + 'label' => ts('Invoice PDF Format'), + 'value' => '{"metric":"px","margin_top":10,"margin_bottom":0,"margin_left":65,"margin_right":0}', + 'name' => 'default_invoice_pdf_format', + 'is_reserved' => 1, + ], ]); diff --git a/sql/civicrm_option_groups/redaction_rule.sqldata.php b/sql/civicrm_option_groups/redaction_rule.sqldata.php index be2de65c0a..82474c7af9 100644 --- a/sql/civicrm_option_groups/redaction_rule.sqldata.php +++ b/sql/civicrm_option_groups/redaction_rule.sqldata.php @@ -3,7 +3,18 @@ return CRM_Core_CodeGen_OptionGroup::create('redaction_rule', 'a/0038') ->addMetadata([ 'title' => ts('Redaction Rule'), ]) - ->addValueTable(['label', 'name', 'value'], [ - ['Vancouver', 'city_', 'city_', 'is_active' => 0], - ['/(19|20)(\\d{2})-(\\d{1,2})-(\\d{1,2})/', 'date_', 'date_', 'filter' => 1, 'is_active' => 0], + ->addValues([ + [ + 'label' => 'Vancouver', + 'value' => 'city_', + 'name' => 'city_', + 'is_active' => 0, + ], + [ + 'label' => '/(19|20)(\\d{2})-(\\d{1,2})-(\\d{1,2})/', + 'value' => 'date_', + 'name' => 'date_', + 'filter' => 1, + 'is_active' => 0, + ], ]); diff --git a/sql/civicrm_option_groups/report_template.sqldata.php b/sql/civicrm_option_groups/report_template.sqldata.php index 2b96a56a02..c77ed8a230 100644 --- a/sql/civicrm_option_groups/report_template.sqldata.php +++ b/sql/civicrm_option_groups/report_template.sqldata.php @@ -3,52 +3,374 @@ return CRM_Core_CodeGen_OptionGroup::create('report_template', 'a/0039') ->addMetadata([ 'title' => ts('Report Template'), ]) - ->addValueTable(['label', 'name', 'value', 'weight', 'description'], [ - [ts('Constituent Report (Summary)'), 'CRM_Report_Form_Contact_Summary', 'contact/summary', 1, ts('Provides a list of address and telephone information for constituent records in your system.')], - [ts('Constituent Report (Detail)'), 'CRM_Report_Form_Contact_Detail', 'contact/detail', 2, ts('Provides contact-related information on contributions, memberships, events and activities.')], - [ts('Activity Details Report'), 'CRM_Report_Form_Activity', 'activity', 3, ts('Provides a list of constituent activity including activity statistics for one/all contacts during a given date range(required)')], - [ts('Walk / Phone List Report'), 'CRM_Report_Form_Walklist_Walklist', 'walklist', 4, ts('Provides a detailed report for your walk/phonelist for targeted contacts'), 'is_active' => 0], - [ts('Current Employer Report'), 'CRM_Report_Form_Contact_CurrentEmployer', 'contact/currentEmployer', 5, ts('Provides detail list of employer employee relationships along with employment details Ex Join Date')], - [ts('Contribution Summary Report'), 'CRM_Report_Form_Contribute_Summary', 'contribute/summary', 6, ts('Groups and totals contributions by criteria including contact, time period, financial type, contributor location, etc.'), 'component_id' => 2], - [ts('Contribution Detail Report'), 'CRM_Report_Form_Contribute_Detail', 'contribute/detail', 7, ts('Lists specific contributions by criteria including contact, time period, financial type, contributor location, etc. Contribution summary report points to this report for contribution details.'), 'component_id' => 2], - [ts('Repeat Contributions Report'), 'CRM_Report_Form_Contribute_Repeat', 'contribute/repeat', 8, ts('Given two date ranges, shows contacts who contributed in both the date ranges with the amount contributed in each and the percentage increase / decrease.'), 'component_id' => 2], - [ts('Contributions by Organization Report'), 'CRM_Report_Form_Contribute_OrganizationSummary', 'contribute/organizationSummary', 9, ts('Displays a detailed list of contributions grouped by organization, which includes contributions made by employees for the organisation.'), 'component_id' => 2], - [ts('Contributions by Household Report'), 'CRM_Report_Form_Contribute_HouseholdSummary', 'contribute/householdSummary', 10, ts('Displays a detailed list of contributions grouped by household which includes contributions made by members of the household.'), 'component_id' => 2], - [ts('Top Donors Report'), 'CRM_Report_Form_Contribute_TopDonor', 'contribute/topDonor', 11, ts('Provides a list of the top donors during a time period you define. You can include as many donors as you want (for example, top 100 of your donors).'), 'component_id' => 2], - [ts('SYBUNT Report'), 'CRM_Report_Form_Contribute_Sybunt', 'contribute/sybunt', 12, ts('SYBUNT means some year(s) but not this year. Provides a list of constituents who donated at some time in the history of your organization but did not donate during the time period you specify.'), 'component_id' => 2], - [ts('LYBUNT Report'), 'CRM_Report_Form_Contribute_Lybunt', 'contribute/lybunt', 13, ts('LYBUNT means last year but not this year. Provides a list of constituents who donated last year but did not donate during the time period you specify as the current year.'), 'component_id' => 2], - [ts('Soft Credit Report'), 'CRM_Report_Form_Contribute_SoftCredit', 'contribute/softcredit', 14, ts('Shows contributions made by contacts that have been soft-credited to other contacts.'), 'component_id' => 2], - [ts('Membership Report (Summary)'), 'CRM_Report_Form_Member_Summary', 'member/summary', 15, ts('Provides a summary of memberships by type and Member Since.'), 'component_id' => 3], - [ts('Membership Report (Detail)'), 'CRM_Report_Form_Member_Detail', 'member/detail', 16, ts('Provides a list of members along with their membership status and membership details (Member Since, Membership Start Date, Membership Expiration Date). Can also display contributions (payments) associated with each membership.'), 'component_id' => 3], - [ts('Membership Report (Lapsed)'), 'CRM_Report_Form_Member_Lapse', 'member/lapse', 17, ts('Provides a list of memberships that lapsed or will lapse before the date you specify.'), 'component_id' => 3], - [ts('Event Participant Report (List)'), 'CRM_Report_Form_Event_ParticipantListing', 'event/participantListing', 18, ts('Provides lists of participants for an event.'), 'component_id' => 1], - [ts('Event Income Report (Summary)'), 'CRM_Report_Form_Event_Summary', 'event/summary', 19, ts('Provides an overview of event income. You can include key information such as event ID, registration, attendance, and income generated to help you determine the success of an event.'), 'component_id' => 1], - [ts('Event Income Report (Detail)'), 'CRM_Report_Form_Event_Income', 'event/income', 20, ts('Helps you to analyze the income generated by an event. The report can include details by participant type, status and payment method.'), 'component_id' => 1], - [ts('Pledge Detail Report'), 'CRM_Report_Form_Pledge_Detail', 'pledge/detail', 21, ts('List of pledges including amount pledged, pledge status, next payment date, balance due, total amount paid etc.'), 'component_id' => 6], - [ts('Pledged but not Paid Report'), 'CRM_Report_Form_Pledge_Pbnp', 'pledge/pbnp', 22, ts('Pledged but not Paid Report'), 'component_id' => 6], - [ts('Relationship Report'), 'CRM_Report_Form_Contact_Relationship', 'contact/relationship', 23, ts('Relationship Report')], - [ts('Case Summary Report'), 'CRM_Report_Form_Case_Summary', 'case/summary', 24, ts('Provides a summary of cases and their duration by date range, status, staff member and / or case role.'), 'component_id' => 7], - [ts('Case Time Spent Report'), 'CRM_Report_Form_Case_TimeSpent', 'case/timespent', 25, ts('Aggregates time spent on case and / or non-case activities by activity type and contact.'), 'component_id' => 7], - [ts('Contact Demographics Report'), 'CRM_Report_Form_Case_Demographics', 'case/demographics', 26, ts('Demographic breakdown for case clients (and or non-case contacts) in your database. Includes custom contact fields.'), 'component_id' => 7], - [ts('Database Log Report'), 'CRM_Report_Form_Contact_Log', 'contact/log', 27, ts('Log of contact and activity records created or updated in a given date range.')], - [ts('Activity Summary Report'), 'CRM_Report_Form_ActivitySummary', 'activitySummary', 28, ts('Shows activity statistics by type / date')], - [ts('Bookkeeping Transactions Report'), 'CRM_Report_Form_Contribute_Bookkeeping', 'contribute/bookkeeping', 29, ts('Shows Bookkeeping Transactions Report'), 'component_id' => 2], - [ts('Participant list Count Report'), 'CRM_Report_Form_Event_ParticipantListCount', 'event/participantlist', 31, ts('Shows the Participant list with Participant Count.'), 'component_id' => 1], - [ts('Income Count Summary Report'), 'CRM_Report_Form_Event_IncomeCountSummary', 'event/incomesummary', 32, ts('Shows the Income Summary of events with Count.'), 'component_id' => 1], - [ts('Case Detail Report'), 'CRM_Report_Form_Case_Detail', 'case/detail', 33, ts('Case Details'), 'component_id' => 7], - [ts('Mail Bounce Report'), 'CRM_Report_Form_Mailing_Bounce', 'Mailing/bounce', 34, ts('Bounce Report for mailings'), 'component_id' => 4], - [ts('Mail Summary Report'), 'CRM_Report_Form_Mailing_Summary', 'Mailing/summary', 35, ts('Summary statistics for mailings'), 'component_id' => 4], - [ts('Mail Opened Report'), 'CRM_Report_Form_Mailing_Opened', 'Mailing/opened', 36, ts('Display contacts who opened emails from a mailing'), 'component_id' => 4], - [ts('Mail Click-Through Report'), 'CRM_Report_Form_Mailing_Clicks', 'Mailing/clicks', 37, ts('Display clicks from each mailing'), 'component_id' => 4], - [ts('Contact Logging Report (Summary)'), 'CRM_Report_Form_Contact_LoggingSummary', 'logging/contact/summary', 38, ts('Contact modification report for the logging infrastructure (summary).'), 'is_active' => 0], - [ts('Contact Logging Report (Detail)'), 'CRM_Report_Form_Contact_LoggingDetail', 'logging/contact/detail', 39, ts('Contact modification report for the logging infrastructure (detail).'), 'is_active' => 0], - [ts('Survey Report (Detail)'), 'CRM_Report_Form_Campaign_SurveyDetails', 'survey/detail', 43, ts('Detailed report for canvassing, phone-banking, walk lists or other surveys.'), 'component_id' => 9], - [ts('Personal Campaign Page Report'), 'CRM_Report_Form_Contribute_PCP', 'contribute/pcp', 44, ts('Summarizes amount raised and number of contributors for each Personal Campaign Page.'), 'component_id' => 2], - [ts('Pledge Summary Report'), 'CRM_Report_Form_Pledge_Summary', 'pledge/summary', 45, ts('Groups and totals pledges by criteria including contact, time period, pledge status, location, etc.'), 'component_id' => 6], - [ts('Contribution Aggregate by Relationship'), 'CRM_Report_Form_Contribute_History', 'contribute/history', 46, ts('List contact\'s donation history, grouped by year, along with contributions attributed to any of the contact\'s related contacts.'), 'component_id' => 2], - [ts('Mail Detail Report'), 'CRM_Report_Form_Mailing_Detail', 'mailing/detail', 47, ts('Provides reporting on Intended and Successful Deliveries, Unsubscribes and Opt-outs, Replies and Forwards.'), 'component_id' => 4], - [ts('Contribution and Membership Details'), 'CRM_Report_Form_Member_ContributionDetail', 'member/contributionDetail', 48, ts('Contribution details for any type of contribution, plus associated membership information for contributions which are in payment for memberships.'), 'component_id' => 3], - [ts('Recurring Contributions Report'), 'CRM_Report_Form_Contribute_Recur', 'contribute/recur', 49, ts('Provides information about the status of recurring contributions'), 'component_id' => 2], - [ts('Recurring Contributions Summary'), 'CRM_Report_Form_Contribute_RecurSummary', 'contribute/recursummary', 49, ts('Provides simple summary for each payment instrument for which there are recurring contributions (e.g. Credit Card, Standing Order, Direct Debit, etc., NULL), showing within a given date range.'), 'component_id' => 2], - [ts('Deferred Revenue Details'), 'CRM_Report_Form_Contribute_DeferredRevenue', 'contribute/deferredrevenue', 50, ts('Deferred Revenue Details Report'), 'component_id' => 2], + ->addValues([ + [ + 'label' => ts('Constituent Report (Summary)'), + 'value' => 'contact/summary', + 'name' => 'CRM_Report_Form_Contact_Summary', + 'weight' => 1, + 'description' => ts('Provides a list of address and telephone information for constituent records in your system.'), + ], + [ + 'label' => ts('Constituent Report (Detail)'), + 'value' => 'contact/detail', + 'name' => 'CRM_Report_Form_Contact_Detail', + 'weight' => 2, + 'description' => ts('Provides contact-related information on contributions, memberships, events and activities.'), + ], + [ + 'label' => ts('Activity Details Report'), + 'value' => 'activity', + 'name' => 'CRM_Report_Form_Activity', + 'weight' => 3, + 'description' => ts('Provides a list of constituent activity including activity statistics for one/all contacts during a given date range(required)'), + ], + [ + 'label' => ts('Walk / Phone List Report'), + 'value' => 'walklist', + 'name' => 'CRM_Report_Form_Walklist_Walklist', + 'weight' => 4, + 'description' => ts('Provides a detailed report for your walk/phonelist for targeted contacts'), + 'is_active' => 0, + ], + [ + 'label' => ts('Current Employer Report'), + 'value' => 'contact/currentEmployer', + 'name' => 'CRM_Report_Form_Contact_CurrentEmployer', + 'weight' => 5, + 'description' => ts('Provides detail list of employer employee relationships along with employment details Ex Join Date'), + ], + [ + 'label' => ts('Contribution Summary Report'), + 'value' => 'contribute/summary', + 'name' => 'CRM_Report_Form_Contribute_Summary', + 'weight' => 6, + 'description' => ts('Groups and totals contributions by criteria including contact, time period, financial type, contributor location, etc.'), + 'component_id' => 2, + ], + [ + 'label' => ts('Contribution Detail Report'), + 'value' => 'contribute/detail', + 'name' => 'CRM_Report_Form_Contribute_Detail', + 'weight' => 7, + 'description' => ts('Lists specific contributions by criteria including contact, time period, financial type, contributor location, etc. Contribution summary report points to this report for contribution details.'), + 'component_id' => 2, + ], + [ + 'label' => ts('Repeat Contributions Report'), + 'value' => 'contribute/repeat', + 'name' => 'CRM_Report_Form_Contribute_Repeat', + 'weight' => 8, + 'description' => ts('Given two date ranges, shows contacts who contributed in both the date ranges with the amount contributed in each and the percentage increase / decrease.'), + 'component_id' => 2, + ], + [ + 'label' => ts('Contributions by Organization Report'), + 'value' => 'contribute/organizationSummary', + 'name' => 'CRM_Report_Form_Contribute_OrganizationSummary', + 'weight' => 9, + 'description' => ts('Displays a detailed list of contributions grouped by organization, which includes contributions made by employees for the organisation.'), + 'component_id' => 2, + ], + [ + 'label' => ts('Contributions by Household Report'), + 'value' => 'contribute/householdSummary', + 'name' => 'CRM_Report_Form_Contribute_HouseholdSummary', + 'weight' => 10, + 'description' => ts('Displays a detailed list of contributions grouped by household which includes contributions made by members of the household.'), + 'component_id' => 2, + ], + [ + 'label' => ts('Top Donors Report'), + 'value' => 'contribute/topDonor', + 'name' => 'CRM_Report_Form_Contribute_TopDonor', + 'weight' => 11, + 'description' => ts('Provides a list of the top donors during a time period you define. You can include as many donors as you want (for example, top 100 of your donors).'), + 'component_id' => 2, + ], + [ + 'label' => ts('SYBUNT Report'), + 'value' => 'contribute/sybunt', + 'name' => 'CRM_Report_Form_Contribute_Sybunt', + 'weight' => 12, + 'description' => ts('SYBUNT means some year(s) but not this year. Provides a list of constituents who donated at some time in the history of your organization but did not donate during the time period you specify.'), + 'component_id' => 2, + ], + [ + 'label' => ts('LYBUNT Report'), + 'value' => 'contribute/lybunt', + 'name' => 'CRM_Report_Form_Contribute_Lybunt', + 'weight' => 13, + 'description' => ts('LYBUNT means last year but not this year. Provides a list of constituents who donated last year but did not donate during the time period you specify as the current year.'), + 'component_id' => 2, + ], + [ + 'label' => ts('Soft Credit Report'), + 'value' => 'contribute/softcredit', + 'name' => 'CRM_Report_Form_Contribute_SoftCredit', + 'weight' => 14, + 'description' => ts('Shows contributions made by contacts that have been soft-credited to other contacts.'), + 'component_id' => 2, + ], + [ + 'label' => ts('Membership Report (Summary)'), + 'value' => 'member/summary', + 'name' => 'CRM_Report_Form_Member_Summary', + 'weight' => 15, + 'description' => ts('Provides a summary of memberships by type and Member Since.'), + 'component_id' => 3, + ], + [ + 'label' => ts('Membership Report (Detail)'), + 'value' => 'member/detail', + 'name' => 'CRM_Report_Form_Member_Detail', + 'weight' => 16, + 'description' => ts('Provides a list of members along with their membership status and membership details (Member Since, Membership Start Date, Membership Expiration Date). Can also display contributions (payments) associated with each membership.'), + 'component_id' => 3, + ], + [ + 'label' => ts('Membership Report (Lapsed)'), + 'value' => 'member/lapse', + 'name' => 'CRM_Report_Form_Member_Lapse', + 'weight' => 17, + 'description' => ts('Provides a list of memberships that lapsed or will lapse before the date you specify.'), + 'component_id' => 3, + ], + [ + 'label' => ts('Event Participant Report (List)'), + 'value' => 'event/participantListing', + 'name' => 'CRM_Report_Form_Event_ParticipantListing', + 'weight' => 18, + 'description' => ts('Provides lists of participants for an event.'), + 'component_id' => 1, + ], + [ + 'label' => ts('Event Income Report (Summary)'), + 'value' => 'event/summary', + 'name' => 'CRM_Report_Form_Event_Summary', + 'weight' => 19, + 'description' => ts('Provides an overview of event income. You can include key information such as event ID, registration, attendance, and income generated to help you determine the success of an event.'), + 'component_id' => 1, + ], + [ + 'label' => ts('Event Income Report (Detail)'), + 'value' => 'event/income', + 'name' => 'CRM_Report_Form_Event_Income', + 'weight' => 20, + 'description' => ts('Helps you to analyze the income generated by an event. The report can include details by participant type, status and payment method.'), + 'component_id' => 1, + ], + [ + 'label' => ts('Pledge Detail Report'), + 'value' => 'pledge/detail', + 'name' => 'CRM_Report_Form_Pledge_Detail', + 'weight' => 21, + 'description' => ts('List of pledges including amount pledged, pledge status, next payment date, balance due, total amount paid etc.'), + 'component_id' => 6, + ], + [ + 'label' => ts('Pledged but not Paid Report'), + 'value' => 'pledge/pbnp', + 'name' => 'CRM_Report_Form_Pledge_Pbnp', + 'weight' => 22, + 'description' => ts('Pledged but not Paid Report'), + 'component_id' => 6, + ], + [ + 'label' => ts('Relationship Report'), + 'value' => 'contact/relationship', + 'name' => 'CRM_Report_Form_Contact_Relationship', + 'weight' => 23, + 'description' => ts('Relationship Report'), + ], + [ + 'label' => ts('Case Summary Report'), + 'value' => 'case/summary', + 'name' => 'CRM_Report_Form_Case_Summary', + 'weight' => 24, + 'description' => ts('Provides a summary of cases and their duration by date range, status, staff member and / or case role.'), + 'component_id' => 7, + ], + [ + 'label' => ts('Case Time Spent Report'), + 'value' => 'case/timespent', + 'name' => 'CRM_Report_Form_Case_TimeSpent', + 'weight' => 25, + 'description' => ts('Aggregates time spent on case and / or non-case activities by activity type and contact.'), + 'component_id' => 7, + ], + [ + 'label' => ts('Contact Demographics Report'), + 'value' => 'case/demographics', + 'name' => 'CRM_Report_Form_Case_Demographics', + 'weight' => 26, + 'description' => ts('Demographic breakdown for case clients (and or non-case contacts) in your database. Includes custom contact fields.'), + 'component_id' => 7, + ], + [ + 'label' => ts('Database Log Report'), + 'value' => 'contact/log', + 'name' => 'CRM_Report_Form_Contact_Log', + 'weight' => 27, + 'description' => ts('Log of contact and activity records created or updated in a given date range.'), + ], + [ + 'label' => ts('Activity Summary Report'), + 'value' => 'activitySummary', + 'name' => 'CRM_Report_Form_ActivitySummary', + 'weight' => 28, + 'description' => ts('Shows activity statistics by type / date'), + ], + [ + 'label' => ts('Bookkeeping Transactions Report'), + 'value' => 'contribute/bookkeeping', + 'name' => 'CRM_Report_Form_Contribute_Bookkeeping', + 'weight' => 29, + 'description' => ts('Shows Bookkeeping Transactions Report'), + 'component_id' => 2, + ], + [ + 'label' => ts('Participant list Count Report'), + 'value' => 'event/participantlist', + 'name' => 'CRM_Report_Form_Event_ParticipantListCount', + 'weight' => 31, + 'description' => ts('Shows the Participant list with Participant Count.'), + 'component_id' => 1, + ], + [ + 'label' => ts('Income Count Summary Report'), + 'value' => 'event/incomesummary', + 'name' => 'CRM_Report_Form_Event_IncomeCountSummary', + 'weight' => 32, + 'description' => ts('Shows the Income Summary of events with Count.'), + 'component_id' => 1, + ], + [ + 'label' => ts('Case Detail Report'), + 'value' => 'case/detail', + 'name' => 'CRM_Report_Form_Case_Detail', + 'weight' => 33, + 'description' => ts('Case Details'), + 'component_id' => 7, + ], + [ + 'label' => ts('Mail Bounce Report'), + 'value' => 'Mailing/bounce', + 'name' => 'CRM_Report_Form_Mailing_Bounce', + 'weight' => 34, + 'description' => ts('Bounce Report for mailings'), + 'component_id' => 4, + ], + [ + 'label' => ts('Mail Summary Report'), + 'value' => 'Mailing/summary', + 'name' => 'CRM_Report_Form_Mailing_Summary', + 'weight' => 35, + 'description' => ts('Summary statistics for mailings'), + 'component_id' => 4, + ], + [ + 'label' => ts('Mail Opened Report'), + 'value' => 'Mailing/opened', + 'name' => 'CRM_Report_Form_Mailing_Opened', + 'weight' => 36, + 'description' => ts('Display contacts who opened emails from a mailing'), + 'component_id' => 4, + ], + [ + 'label' => ts('Mail Click-Through Report'), + 'value' => 'Mailing/clicks', + 'name' => 'CRM_Report_Form_Mailing_Clicks', + 'weight' => 37, + 'description' => ts('Display clicks from each mailing'), + 'component_id' => 4, + ], + [ + 'label' => ts('Contact Logging Report (Summary)'), + 'value' => 'logging/contact/summary', + 'name' => 'CRM_Report_Form_Contact_LoggingSummary', + 'weight' => 38, + 'description' => ts('Contact modification report for the logging infrastructure (summary).'), + 'is_active' => 0, + ], + [ + 'label' => ts('Contact Logging Report (Detail)'), + 'value' => 'logging/contact/detail', + 'name' => 'CRM_Report_Form_Contact_LoggingDetail', + 'weight' => 39, + 'description' => ts('Contact modification report for the logging infrastructure (detail).'), + 'is_active' => 0, + ], + [ + 'label' => ts('Survey Report (Detail)'), + 'value' => 'survey/detail', + 'name' => 'CRM_Report_Form_Campaign_SurveyDetails', + 'weight' => 43, + 'description' => ts('Detailed report for canvassing, phone-banking, walk lists or other surveys.'), + 'component_id' => 9, + ], + [ + 'label' => ts('Personal Campaign Page Report'), + 'value' => 'contribute/pcp', + 'name' => 'CRM_Report_Form_Contribute_PCP', + 'weight' => 44, + 'description' => ts('Summarizes amount raised and number of contributors for each Personal Campaign Page.'), + 'component_id' => 2, + ], + [ + 'label' => ts('Pledge Summary Report'), + 'value' => 'pledge/summary', + 'name' => 'CRM_Report_Form_Pledge_Summary', + 'weight' => 45, + 'description' => ts('Groups and totals pledges by criteria including contact, time period, pledge status, location, etc.'), + 'component_id' => 6, + ], + [ + 'label' => ts('Contribution Aggregate by Relationship'), + 'value' => 'contribute/history', + 'name' => 'CRM_Report_Form_Contribute_History', + 'weight' => 46, + 'description' => ts('List contact\'s donation history, grouped by year, along with contributions attributed to any of the contact\'s related contacts.'), + 'component_id' => 2, + ], + [ + 'label' => ts('Mail Detail Report'), + 'value' => 'mailing/detail', + 'name' => 'CRM_Report_Form_Mailing_Detail', + 'weight' => 47, + 'description' => ts('Provides reporting on Intended and Successful Deliveries, Unsubscribes and Opt-outs, Replies and Forwards.'), + 'component_id' => 4, + ], + [ + 'label' => ts('Contribution and Membership Details'), + 'value' => 'member/contributionDetail', + 'name' => 'CRM_Report_Form_Member_ContributionDetail', + 'weight' => 48, + 'description' => ts('Contribution details for any type of contribution, plus associated membership information for contributions which are in payment for memberships.'), + 'component_id' => 3, + ], + [ + 'label' => ts('Recurring Contributions Report'), + 'value' => 'contribute/recur', + 'name' => 'CRM_Report_Form_Contribute_Recur', + 'weight' => 49, + 'description' => ts('Provides information about the status of recurring contributions'), + 'component_id' => 2, + ], + [ + 'label' => ts('Recurring Contributions Summary'), + 'value' => 'contribute/recursummary', + 'name' => 'CRM_Report_Form_Contribute_RecurSummary', + 'weight' => 49, + 'description' => ts('Provides simple summary for each payment instrument for which there are recurring contributions (e.g. Credit Card, Standing Order, Direct Debit, etc., NULL), showing within a given date range.'), + 'component_id' => 2, + ], + [ + 'label' => ts('Deferred Revenue Details'), + 'value' => 'contribute/deferredrevenue', + 'name' => 'CRM_Report_Form_Contribute_DeferredRevenue', + 'weight' => 50, + 'description' => ts('Deferred Revenue Details Report'), + 'component_id' => 2, + ], ]); -- 2.25.1