From da59445006ac42676236ac43aac57e27426088de Mon Sep 17 00:00:00 2001 From: Tim Otten Date: Wed, 17 May 2023 01:47:09 -0700 Subject: [PATCH] Extract activity_status, address_options, advanced_search_options, contact_edit_options, custom_search, group_type, user_dashboard_options NOTE: ID change. Old insert had different orderings for OG and OV --- sql/civicrm_option_groups.php | 33 ------- .../activity_status.sqldata.php | 17 ++++ .../address_options.sqldata.php | 21 ++++ .../advanced_search_options.sqldata.php | 24 +++++ .../contact_edit_options.sqldata.php | 25 +++++ .../custom_search.sqldata.php | 21 ++++ .../group_type.sqldata.php | 9 ++ .../user_dashboard_options.sqldata.php | 17 ++++ xml/templates/civicrm_data.tpl | 95 +------------------ 9 files changed, 135 insertions(+), 127 deletions(-) create mode 100644 sql/civicrm_option_groups/activity_status.sqldata.php create mode 100644 sql/civicrm_option_groups/address_options.sqldata.php create mode 100644 sql/civicrm_option_groups/advanced_search_options.sqldata.php create mode 100644 sql/civicrm_option_groups/contact_edit_options.sqldata.php create mode 100644 sql/civicrm_option_groups/custom_search.sqldata.php create mode 100644 sql/civicrm_option_groups/group_type.sqldata.php create mode 100644 sql/civicrm_option_groups/user_dashboard_options.sqldata.php diff --git a/sql/civicrm_option_groups.php b/sql/civicrm_option_groups.php index 6a11b7c448..cf9e9c7ee3 100644 --- a/sql/civicrm_option_groups.php +++ b/sql/civicrm_option_groups.php @@ -19,39 +19,6 @@ $readOptionGroups = function (): array { }; return $readOptionGroups() + [ - 'contact_edit_options' => CRM_Core_CodeGen_OptionGroup::create('contact_edit_options') - ->addMetadata([ - 'title' => ts('Contact Edit Options'), - 'is_locked' => '1', - ]), - 'advanced_search_options' => CRM_Core_CodeGen_OptionGroup::create('advanced_search_options') - ->addMetadata([ - 'title' => ts('Advanced Search Options'), - 'is_locked' => '1', - ]), - 'user_dashboard_options' => CRM_Core_CodeGen_OptionGroup::create('user_dashboard_options') - ->addMetadata([ - 'title' => ts('User Dashboard Options'), - 'is_locked' => '1', - ]), - 'address_options' => CRM_Core_CodeGen_OptionGroup::create('address_options') - ->addMetadata([ - 'title' => ts('Addressing Options'), - ]), - 'group_type' => CRM_Core_CodeGen_OptionGroup::create('group_type') - ->addMetadata([ - 'title' => ts('Group Type'), - ]), - 'custom_search' => CRM_Core_CodeGen_OptionGroup::create('custom_search') - ->addMetadata([ - 'title' => ts('Custom Search'), - ]), - 'activity_status' => CRM_Core_CodeGen_OptionGroup::create('activity_status') - ->addMetadata([ - 'title' => ts('Activity Status'), - 'data_type' => 'Integer', - 'option_value_fields' => 'name,label,description,color', - ]), 'case_type' => CRM_Core_CodeGen_OptionGroup::create('case_type') ->addMetadata([ 'title' => ts('Case Type'), diff --git a/sql/civicrm_option_groups/activity_status.sqldata.php b/sql/civicrm_option_groups/activity_status.sqldata.php new file mode 100644 index 0000000000..22c0c1b698 --- /dev/null +++ b/sql/civicrm_option_groups/activity_status.sqldata.php @@ -0,0 +1,17 @@ +addMetadata([ + 'title' => ts('Activity Status'), + 'data_type' => 'Integer', + 'option_value_fields' => 'name,label,description,color', + ]) + ->addValues(['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], + ]); diff --git a/sql/civicrm_option_groups/address_options.sqldata.php b/sql/civicrm_option_groups/address_options.sqldata.php new file mode 100644 index 0000000000..ae230b0bad --- /dev/null +++ b/sql/civicrm_option_groups/address_options.sqldata.php @@ -0,0 +1,21 @@ +addMetadata([ + 'title' => ts('Addressing Options'), + ]) + ->addValues(['label', 'name', 'value'], [ + [ts('Street Address'), 'street_address', 1], + [ts('Supplemental Address 1'), 'supplemental_address_1', 2], + [ts('Supplemental Address 2'), 'supplemental_address_2', 3], + [ts('Supplemental Address 3'), 'supplemental_address_3', 4], + [ts('City'), 'city', 5], + [ts('Postal Code'), 'postal_code', 6], + [ts('Postal Code Suffix'), 'postal_code_suffix', 7], + [ts('County'), 'county', 8], + [ts('State/Province'), 'state_province', 9], + [ts('Country'), 'country', 10], + [ts('Latitude'), 'geo_code_1', 11], + [ts('Longitude'), 'geo_code_2', 12], + [ts('Address Name'), 'address_name', 13], + [ts('Street Address Parsing'), 'street_address_parsing', 14], + ]); diff --git a/sql/civicrm_option_groups/advanced_search_options.sqldata.php b/sql/civicrm_option_groups/advanced_search_options.sqldata.php new file mode 100644 index 0000000000..5cf60799c7 --- /dev/null +++ b/sql/civicrm_option_groups/advanced_search_options.sqldata.php @@ -0,0 +1,24 @@ +addMetadata([ + 'title' => ts('Advanced Search Options'), + 'is_locked' => 1, + ]) + ->addValues(['label', 'name', 'value', 'weight'], [ + [ts('Address Fields'), 'location', 1, 1], + [ts('Custom Fields'), 'custom', 2, 2], + [ts('Activities'), 'activity', 3, 4], + [ts('Relationships'), 'relationship', 4, 5], + [ts('Notes'), 'notes', 5, 6], + [ts('Change Log'), 'changeLog', 6, 7], + [ts('Contributions'), 'CiviContribute', 7, 8], + [ts('Memberships'), 'CiviMember', 8, 9], + [ts('Events'), 'CiviEvent', 9, 10], + [ts('Cases'), 'CiviCase', 10, 11], + [ts('Demographics'), 'demographics', 13, 15], + [ts('Pledges'), 'CiviPledge', 15, 17], + [ts('Contact Type'), 'contactType', 16, 18], + [ts('Groups'), 'groups', 17, 19], + [ts('Tags'), 'tags', 18, 20], + [ts('Mailing'), 'CiviMail', 19, 21], + ]); diff --git a/sql/civicrm_option_groups/contact_edit_options.sqldata.php b/sql/civicrm_option_groups/contact_edit_options.sqldata.php new file mode 100644 index 0000000000..31a093510d --- /dev/null +++ b/sql/civicrm_option_groups/contact_edit_options.sqldata.php @@ -0,0 +1,25 @@ +addMetadata([ + 'title' => ts('Contact Edit Options'), + 'is_locked' => 1, + ]) + ->addValues(['label', 'name', 'value'], [ + [ts('Custom Data'), 'CustomData', 1], + [ts('Address'), 'Address', 2], + [ts('Communication Preferences'), 'CommunicationPreferences', 3], + [ts('Notes'), 'Notes', 4], + [ts('Demographics'), 'Demographics', 5], + [ts('Tags and Groups'), 'TagsAndGroups', 6], + [ts('Email'), 'Email', 7, 'filter' => 1], + [ts('Phone'), 'Phone', 8, 'filter' => 1], + [ts('Instant Messenger'), 'IM', 9, 'filter' => 1], + [ts('Open ID'), 'OpenID', 10, 'filter' => 1], + [ts('Website'), 'Website', 11, 'filter' => 1], + [ts('Prefix'), 'Prefix', 12, 'filter' => 2], + [ts('Formal Title'), 'Formal Title', 13, 'filter' => 2], + [ts('First Name'), 'First Name', 14, 'filter' => 2], + [ts('Middle Name'), 'Middle Name', 15, 'filter' => 2], + [ts('Last Name'), 'Last Name', 16, 'filter' => 2], + [ts('Suffix'), 'Suffix', 17, 'filter' => 2], + ]); diff --git a/sql/civicrm_option_groups/custom_search.sqldata.php b/sql/civicrm_option_groups/custom_search.sqldata.php new file mode 100644 index 0000000000..69c4726460 --- /dev/null +++ b/sql/civicrm_option_groups/custom_search.sqldata.php @@ -0,0 +1,21 @@ +addMetadata([ + 'title' => ts('Custom Search'), + ]) + ->addValues(['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')], + ]); diff --git a/sql/civicrm_option_groups/group_type.sqldata.php b/sql/civicrm_option_groups/group_type.sqldata.php new file mode 100644 index 0000000000..fb67a909f4 --- /dev/null +++ b/sql/civicrm_option_groups/group_type.sqldata.php @@ -0,0 +1,9 @@ +addMetadata([ + 'title' => ts('Group Type'), + ]) + ->addValues(['label', 'name', 'value'], [ + [ts('Access Control'), 'Access Control', 1, 'is_reserved' => 1], + [ts('Mailing List'), 'Mailing List', 2, 'is_reserved' => 1], + ]); diff --git a/sql/civicrm_option_groups/user_dashboard_options.sqldata.php b/sql/civicrm_option_groups/user_dashboard_options.sqldata.php new file mode 100644 index 0000000000..a90f64a07d --- /dev/null +++ b/sql/civicrm_option_groups/user_dashboard_options.sqldata.php @@ -0,0 +1,17 @@ +addMetadata([ + 'title' => ts('User Dashboard Options'), + 'is_locked' => 1, + ]) + ->addValues(['label', 'name', 'value', 'weight'], [ + [ts('Groups'), 'Groups', 1, 1], + [ts('Contributions'), 'CiviContribute', 2, 2], + [ts('Memberships'), 'CiviMember', 3, 3], + [ts('Events'), 'CiviEvent', 4, 4], + [ts('My Contacts / Organizations'), 'Permissioned Orgs', 5, 5], + [ts('Pledges'), 'CiviPledge', 7, 7], + [ts('Personal Campaign Pages'), 'PCP', 8, 8], + [ts('Assigned Activities'), 'Assigned Activities', 9, 9], + [ts('Invoices / Credit Notes'), 'Invoices / Credit Notes', 10, 10], + ]); diff --git a/xml/templates/civicrm_data.tpl b/xml/templates/civicrm_data.tpl index 0de8e694fc..38b9b5a23f 100644 --- a/xml/templates/civicrm_data.tpl +++ b/xml/templates/civicrm_data.tpl @@ -133,13 +133,7 @@ VALUES {/php} SELECT @option_group_id_pi := max(id) from civicrm_option_group where name = 'payment_instrument'; -SELECT @option_group_id_ceOpt := max(id) from civicrm_option_group where name = 'contact_edit_options'; -SELECT @option_group_id_asOpt := max(id) from civicrm_option_group where name = 'advanced_search_options'; -SELECT @option_group_id_udOpt := max(id) from civicrm_option_group where name = 'user_dashboard_options'; -SELECT @option_group_id_adOpt := max(id) from civicrm_option_group where name = 'address_options'; -SELECT @option_group_id_gType := max(id) from civicrm_option_group where name = 'group_type'; -SELECT @option_group_id_csearch := max(id) from civicrm_option_group where name = 'custom_search'; -SELECT @option_group_id_acs := max(id) from civicrm_option_group where name = 'activity_status'; + SELECT @option_group_id_ct := max(id) from civicrm_option_group where name = 'case_type'; SELECT @option_group_id_cas := max(id) from civicrm_option_group where name = 'case_status'; SELECT @option_group_id_pl := max(id) from civicrm_option_group where name = 'participant_listing'; @@ -212,51 +206,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_ceOpt, '{ts escape="sql"}Custom Data{/ts}' , 1, 'CustomData', NULL, 0, 0, 1, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_ceOpt, '{ts escape="sql"}Address{/ts}' , 2, 'Address', NULL, 0, 0, 2, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_ceOpt, '{ts escape="sql"}Communication Preferences{/ts}', 3, 'CommunicationPreferences', NULL, 0, 0, 3, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_ceOpt, '{ts escape="sql"}Notes{/ts}' , 4, 'Notes', NULL, 0, 0, 4, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_ceOpt, '{ts escape="sql"}Demographics{/ts}' , 5, 'Demographics', NULL, 0, 0, 5, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_ceOpt, '{ts escape="sql"}Tags and Groups{/ts}' , 6, 'TagsAndGroups', NULL, 0, 0, 6, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_ceOpt, '{ts escape="sql"}Email{/ts}' , 7, 'Email', NULL, 1, 0, 7, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_ceOpt, '{ts escape="sql"}Phone{/ts}' , 8, 'Phone', NULL, 1, 0, 8, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_ceOpt, '{ts escape="sql"}Instant Messenger{/ts}' , 9, 'IM', NULL, 1, 0, 9, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_ceOpt, '{ts escape="sql"}Open ID{/ts}' , 10, 'OpenID', NULL, 1, 0, 10, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_ceOpt, '{ts escape="sql"}Website{/ts}' , 11, 'Website', NULL, 1, 0, 11, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_ceOpt, '{ts escape="sql"}Prefix{/ts}' , 12, 'Prefix', NULL, 2, 0, 12, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_ceOpt, '{ts escape="sql"}Formal Title{/ts}' , 13, 'Formal Title', NULL, 2, 0, 13, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_ceOpt, '{ts escape="sql"}First Name{/ts}' , 14, 'First Name', NULL, 2, 0, 14, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_ceOpt, '{ts escape="sql"}Middle Name{/ts}' , 15, 'Middle Name', NULL, 2, 0, 15, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_ceOpt, '{ts escape="sql"}Last Name{/ts}' , 16, 'Last Name', NULL, 2, 0, 16, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_ceOpt, '{ts escape="sql"}Suffix{/ts}' , 17, 'Suffix', NULL, 2, 0, 17, NULL, 0, 0, 1, NULL, NULL, NULL), - - (@option_group_id_asOpt, '{ts escape="sql"}Address Fields{/ts}' , 1, 'location', NULL, 0, 0, 1, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_asOpt, '{ts escape="sql"}Custom Fields{/ts}' , 2, 'custom', NULL, 0, 0, 2, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_asOpt, '{ts escape="sql"}Activities{/ts}' , 3, 'activity', NULL, 0, 0, 4, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_asOpt, '{ts escape="sql"}Relationships{/ts}' , 4, 'relationship', NULL, 0, 0, 5, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_asOpt, '{ts escape="sql"}Notes{/ts}' , 5, 'notes', NULL, 0, 0, 6, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_asOpt, '{ts escape="sql"}Change Log{/ts}' , 6, 'changeLog', NULL, 0, 0, 7, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_asOpt, '{ts escape="sql"}Contributions{/ts}' , 7, 'CiviContribute', NULL, 0, 0, 8, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_asOpt, '{ts escape="sql"}Memberships{/ts}' , 8, 'CiviMember', NULL, 0, 0, 9, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_asOpt, '{ts escape="sql"}Events{/ts}' , 9, 'CiviEvent', NULL, 0, 0, 10, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_asOpt, '{ts escape="sql"}Cases{/ts}' , 10, 'CiviCase', NULL, 0, 0, 11, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_asOpt, '{ts escape="sql"}Demographics{/ts}' , 13, 'demographics', NULL, 0, 0, 15, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_asOpt, '{ts escape="sql"}Pledges{/ts}' , 15, 'CiviPledge', NULL, 0, 0, 17, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_asOpt, '{ts escape="sql"}Contact Type{/ts}' , 16, 'contactType', NULL, 0, 0, 18, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_asOpt, '{ts escape="sql"}Groups{/ts}' , 17, 'groups', NULL, 0, 0, 19, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_asOpt, '{ts escape="sql"}Tags{/ts}' , 18, 'tags', NULL, 0, 0, 20, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_asOpt, '{ts escape="sql"}Mailing{/ts}' , 19, 'CiviMail', NULL, 0, 0, 21, NULL, 0, 0, 1, NULL, NULL, NULL), - - (@option_group_id_udOpt, '{ts escape="sql"}Groups{/ts}' , 1, 'Groups', NULL, 0, 0, 1, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_udOpt, '{ts escape="sql"}Contributions{/ts}' , 2, 'CiviContribute', NULL, 0, 0, 2, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_udOpt, '{ts escape="sql"}Memberships{/ts}' , 3, 'CiviMember', NULL, 0, 0, 3, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_udOpt, '{ts escape="sql"}Events{/ts}' , 4, 'CiviEvent', NULL, 0, 0, 4, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_udOpt, '{ts escape="sql"}My Contacts / Organizations{/ts}', 5, 'Permissioned Orgs', NULL, 0, 0, 5, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_udOpt, '{ts escape="sql"}Pledges{/ts}' , 7, 'CiviPledge', NULL, 0, 0, 7, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_udOpt, '{ts escape="sql"}Personal Campaign Pages{/ts}' , 8, 'PCP', NULL, 0, 0, 8, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_udOpt, '{ts escape="sql"}Assigned Activities{/ts}' , 9, 'Assigned Activities', NULL, 0, 0, 9, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_udOpt, '{ts escape="sql"}Invoices / Credit Notes{/ts}' , 10, 'Invoices / Credit Notes', NULL, 0, 0, 10, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_acsOpt, '{ts escape="sql"}Email Address{/ts}' , 2, 'email' , NULL, 0, 0, 2, NULL, 0, 0, 1, NULL, NULL, NULL), (@option_group_id_acsOpt, '{ts escape="sql"}Phone{/ts}' , 3, 'phone' , NULL, 0, 0, 3, NULL, 0, 0, 1, NULL, NULL, NULL), (@option_group_id_acsOpt, '{ts escape="sql"}Street Address{/ts}' , 4, 'street_address', NULL, 0, 0, 4, NULL, 0, 0, 1, NULL, NULL, NULL), @@ -273,39 +222,6 @@ VALUES (@option_group_id_acConRef, '{ts escape="sql"}Country{/ts}' , 7, 'country' , NULL, 0, 0, 7, NULL, 0, 0, 1, NULL, NULL, NULL), (@option_group_id_acConRef, '{ts escape="sql"}Postal Code{/ts}' , 8, 'postal_code' , NULL, 0, 0, 8, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_adOpt, '{ts escape="sql"}Street Address{/ts}' , 1, 'street_address', NULL, 0, 0, 1, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_adOpt, '{ts escape="sql"}Supplemental Address 1{/ts}' , 2, 'supplemental_address_1', NULL, 0, 0, 2, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_adOpt, '{ts escape="sql"}Supplemental Address 2{/ts}' , 3, 'supplemental_address_2', NULL, 0, 0, 3, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_adOpt, '{ts escape="sql"}Supplemental Address 3{/ts}' , 4, 'supplemental_address_3', NULL, 0, 0, 4, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_adOpt, '{ts escape="sql"}City{/ts}' , 5, 'city' , NULL, 0, 0, 5, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_adOpt, '{ts escape="sql"}Postal Code{/ts}' , 6, 'postal_code' , NULL, 0, 0, 6, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_adOpt, '{ts escape="sql"}Postal Code Suffix{/ts}', 7, 'postal_code_suffix', NULL, 0, 0, 7, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_adOpt, '{ts escape="sql"}County{/ts}' , 8, 'county' , NULL, 0, 0, 8, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_adOpt, '{ts escape="sql"}State/Province{/ts}' , 9, 'state_province', NULL, 0, 0, 9, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_adOpt, '{ts escape="sql"}Country{/ts}' , 10, 'country' , NULL, 0, 0, 10, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_adOpt, '{ts escape="sql"}Latitude{/ts}' , 11, 'geo_code_1' , NULL, 0, 0, 11, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_adOpt, '{ts escape="sql"}Longitude{/ts}' , 12, 'geo_code_2', NULL, 0, 0, 12, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_adOpt, '{ts escape="sql"}Address Name{/ts}' , 13, 'address_name', NULL, 0, 0, 13, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_adOpt, '{ts escape="sql"}Street Address Parsing{/ts}', 14, 'street_address_parsing', NULL, 0, 0, 14, NULL, 0, 0, 1, NULL, NULL, NULL), - - (@option_group_id_gType, '{ts escape="sql"}Access Control{/ts}', 1, 'Access Control', NULL, 0, 0, 1, NULL, 0, 1, 1, NULL, NULL, NULL), - (@option_group_id_gType, '{ts escape="sql"}Mailing List{/ts}', 2, 'Mailing List', NULL, 0, 0, 2, NULL, 0, 1, 1, NULL, NULL, NULL), - - (@option_group_id_csearch , 'CRM_Contact_Form_Search_Custom_Sample' , 1, 'CRM_Contact_Form_Search_Custom_Sample' , NULL, 0, 0, 1, '{ts escape="sql"}Household Name and State{/ts}', 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_csearch , 'CRM_Contact_Form_Search_Custom_ContributionAggregate', 2, 'CRM_Contact_Form_Search_Custom_ContributionAggregate', NULL, 0, 0, 2, '{ts escape="sql"}Contribution Aggregate{/ts}', 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_csearch , 'CRM_Contact_Form_Search_Custom_Group' , 4, 'CRM_Contact_Form_Search_Custom_Group' , NULL, 0, 0, 4, '{ts escape="sql"}Include / Exclude Search{/ts}', 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_csearch , 'CRM_Contact_Form_Search_Custom_PostalMailing' , 5, 'CRM_Contact_Form_Search_Custom_PostalMailing', NULL, 0, 0, 5, '{ts escape="sql"}Postal Mailing{/ts}', 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_csearch , 'CRM_Contact_Form_Search_Custom_Proximity' , 6, 'CRM_Contact_Form_Search_Custom_Proximity', NULL, 0, 0, 6, '{ts escape="sql"}Proximity Search{/ts}', 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_csearch , 'CRM_Contact_Form_Search_Custom_EventAggregate' , 7, 'CRM_Contact_Form_Search_Custom_EventAggregate', NULL, 0, 0, 7, '{ts escape="sql"}Event Aggregate{/ts}', 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_csearch , 'CRM_Contact_Form_Search_Custom_ActivitySearch' , 8, 'CRM_Contact_Form_Search_Custom_ActivitySearch', NULL, 0, 0, 8, '{ts escape="sql"}Activity Search{/ts}', 0, 0, 0, NULL, NULL, NULL), - (@option_group_id_csearch , 'CRM_Contact_Form_Search_Custom_PriceSet' , 9, 'CRM_Contact_Form_Search_Custom_PriceSet', NULL, 0, 0, 9, '{ts escape="sql"}Price Set Details for Event Participants{/ts}', 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_csearch , 'CRM_Contact_Form_Search_Custom_ZipCodeRange' ,10, 'CRM_Contact_Form_Search_Custom_ZipCodeRange', NULL, 0, 0, 10, '{ts escape="sql"}Zip Code Range{/ts}', 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_csearch , 'CRM_Contact_Form_Search_Custom_DateAdded' ,11, 'CRM_Contact_Form_Search_Custom_DateAdded', NULL, 0, 0, 11, '{ts escape="sql"}Date Added to CiviCRM{/ts}', 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_csearch , 'CRM_Contact_Form_Search_Custom_MultipleValues' ,12, 'CRM_Contact_Form_Search_Custom_MultipleValues', NULL, 0, 0, 12, '{ts escape="sql"}Custom Group Multiple Values Listing{/ts}', 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_csearch , 'CRM_Contact_Form_Search_Custom_ContribSYBNT' ,13, 'CRM_Contact_Form_Search_Custom_ContribSYBNT', NULL, 0, 0, 13, '{ts escape="sql"}Contributions made in Year X and not Year Y{/ts}', 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_csearch , 'CRM_Contact_Form_Search_Custom_TagContributions' ,14, 'CRM_Contact_Form_Search_Custom_TagContributions', NULL, 0, 0, 14, '{ts escape="sql"}Find Contribution Amounts by Tag{/ts}', 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_csearch , 'CRM_Contact_Form_Search_Custom_FullText' ,15, 'CRM_Contact_Form_Search_Custom_FullText', NULL, 0, 0, 15, '{ts escape="sql"}Full-text Search{/ts}', 0, 0, 1, NULL, NULL, NULL), - -- report templates (@option_group_id_report , '{ts escape="sql"}Constituent Report (Summary){/ts}', 'contact/summary', 'CRM_Report_Form_Contact_Summary', NULL, 0, 0, 1, '{ts escape="sql"}Provides a list of address and telephone information for constituent records in your system.{/ts}', 0, 0, 1, NULL, NULL, NULL), (@option_group_id_report , '{ts escape="sql"}Constituent Report (Detail){/ts}', 'contact/detail', 'CRM_Report_Form_Contact_Detail', NULL, 0, 0, 2, '{ts escape="sql"}Provides contact-related information on contributions, memberships, events and activities.{/ts}', 0, 0, 1, NULL, NULL, NULL), @@ -355,15 +271,6 @@ VALUES (@option_group_id_report, '{ts escape="sql"}Recurring Contributions Summary{/ts}', 'contribute/recursummary', 'CRM_Report_Form_Contribute_RecurSummary', NULL, 0, 0, 49, '{ts escape="sql"}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.{/ts}', 0, 0, 1, @contributeCompId, NULL, NULL), (@option_group_id_report, '{ts escape="sql"}Deferred Revenue Details{/ts}', 'contribute/deferredrevenue', 'CRM_Report_Form_Contribute_DeferredRevenue', NULL, 0, 0, 50, '{ts escape="sql"}Deferred Revenue Details Report{/ts}', 0, 0, 1, @contributeCompId, NULL, NULL), - (@option_group_id_acs, '{ts escape="sql"}Scheduled{/ts}', 1, 'Scheduled', NULL, 0, 1, 1, NULL, 0, 1, 1, NULL, NULL, NULL), - (@option_group_id_acs, '{ts escape="sql"}Completed{/ts}', 2, 'Completed', NULL, 1, 0, 2, NULL, 0, 1, 1, NULL, NULL, NULL), - (@option_group_id_acs, '{ts escape="sql"}Cancelled{/ts}', 3, 'Cancelled', NULL, 2, 0, 3, NULL, 0, 1, 1, NULL, NULL, NULL), - (@option_group_id_acs, '{ts escape="sql"}Left Message{/ts}', 4, 'Left Message', NULL, 0, 0, 4, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_acs, '{ts escape="sql"}Unreachable{/ts}', 5, 'Unreachable', NULL, 2, 0, 5, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_acs, '{ts escape="sql"}Not Required{/ts}', 6, 'Not Required', NULL, 2, 0, 6, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_acs, '{ts escape="sql"}Available{/ts}', 7, 'Available', NULL, 0, 0, 7, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_acs, '{ts escape="sql"}No-show{/ts}', 8, 'No_show', NULL, 2, 0, 8, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_cas, '{ts escape="sql"}Ongoing{/ts}' , 1, 'Open' , 'Opened', 0, 1, 1, NULL, 0, 1, 1, NULL, NULL, NULL), (@option_group_id_cas, '{ts escape="sql"}Resolved{/ts}', 2, 'Closed', 'Closed', 0, 0, 2, NULL, 0, 1, 1, NULL, NULL, NULL), (@option_group_id_cas, '{ts escape="sql"}Urgent{/ts}' , 3, 'Urgent', 'Opened', 0, 0, 3, NULL, 0, 0, 1, NULL, NULL, NULL), -- 2.25.1