From 8a7b4caa50eba59718316b008f8fafc6b5fd7494 Mon Sep 17 00:00:00 2001 From: Tim Otten Date: Wed, 17 May 2023 04:06:09 -0700 Subject: [PATCH] Extract contribution_recur_status, environment, pledge_status, relative_date_filters --- sql/civicrm_option_groups.php | 18 ---- .../contribution_recur_status.sqldata.php | 19 ++++ .../environment.sqldata.php | 14 +++ .../pledge_status.sqldata.php | 13 +++ .../relative_date_filters.sqldata.php | 74 +++++++++++++++ xml/templates/civicrm_data.tpl | 93 ------------------- 6 files changed, 120 insertions(+), 111 deletions(-) create mode 100644 sql/civicrm_option_groups/contribution_recur_status.sqldata.php create mode 100644 sql/civicrm_option_groups/environment.sqldata.php create mode 100644 sql/civicrm_option_groups/pledge_status.sqldata.php create mode 100644 sql/civicrm_option_groups/relative_date_filters.sqldata.php diff --git a/sql/civicrm_option_groups.php b/sql/civicrm_option_groups.php index 410f68d3de..13e9611fca 100644 --- a/sql/civicrm_option_groups.php +++ b/sql/civicrm_option_groups.php @@ -19,24 +19,6 @@ $readOptionGroups = function (): array { }; return $readOptionGroups() + [ - 'relative_date_filters' => CRM_Core_CodeGen_OptionGroup::create('relative_date_filters') - ->addMetadata([ - 'title' => ts('Relative Date Filters'), - ]), - 'pledge_status' => CRM_Core_CodeGen_OptionGroup::create('pledge_status') - ->addMetadata([ - 'title' => ts('Pledge Status'), - 'is_locked' => '1', - ]), - 'contribution_recur_status' => CRM_Core_CodeGen_OptionGroup::create('contribution_recur_status') - ->addMetadata([ - 'title' => ts('Recurring Contribution Status'), - 'is_locked' => '1', - ]), - 'environment' => CRM_Core_CodeGen_OptionGroup::create('environment') - ->addMetadata([ - 'title' => ts('Environment'), - ]), 'activity_default_assignee' => CRM_Core_CodeGen_OptionGroup::create('activity_default_assignee') ->addMetadata([ 'title' => ts('Activity default assignee'), diff --git a/sql/civicrm_option_groups/contribution_recur_status.sqldata.php b/sql/civicrm_option_groups/contribution_recur_status.sqldata.php new file mode 100644 index 0000000000..350e820e47 --- /dev/null +++ b/sql/civicrm_option_groups/contribution_recur_status.sqldata.php @@ -0,0 +1,19 @@ +addMetadata([ + 'title' => ts('Recurring Contribution Status'), + 'is_locked' => 1, + ]) + ->addValues(['label', 'name', 'value'], [ + [ts('Completed'), 'Completed', 1], + [ts('Pending'), 'Pending', 2], + [ts('Cancelled'), 'Cancelled', 3], + [ts('Failed'), 'Failed', 4], + [ts('In Progress'), 'In Progress', 5], + [ts('Overdue'), 'Overdue', 6], + [ts('Processing'), 'Processing', 7], + [ts('Failing'), 'Failing', 8], + ]) + ->addDefaults([ + 'is_reserved' => 1, + ]); diff --git a/sql/civicrm_option_groups/environment.sqldata.php b/sql/civicrm_option_groups/environment.sqldata.php new file mode 100644 index 0000000000..89d694ef29 --- /dev/null +++ b/sql/civicrm_option_groups/environment.sqldata.php @@ -0,0 +1,14 @@ +addMetadata([ + 'title' => ts('Environment'), + ]) + ->addValues(['label', 'name', 'value', 'description'], [ + [ts('Production'), 'Production', 'Production', ts('Production Environment'), 'is_default' => 1], + [ts('Staging'), 'Staging', 'Staging', ts('Staging Environment')], + [ts('Development'), 'Development', 'Development', ts('Development Environment')], + ]) + ->addDefaults([ + 'filter' => NULL, + 'is_reserved' => 1, + ]); diff --git a/sql/civicrm_option_groups/pledge_status.sqldata.php b/sql/civicrm_option_groups/pledge_status.sqldata.php new file mode 100644 index 0000000000..056490bb47 --- /dev/null +++ b/sql/civicrm_option_groups/pledge_status.sqldata.php @@ -0,0 +1,13 @@ +addMetadata([ + 'title' => ts('Pledge Status'), + 'is_locked' => 1, + ]) + ->addValues(['label', 'name', 'value'], [ + [ts('Completed'), 'Completed', 1, 'is_reserved' => 1], + [ts('Pending'), 'Pending', 2, 'is_reserved' => 1], + [ts('Cancelled'), 'Cancelled', 3, 'is_reserved' => 1], + [ts('In Progress'), 'In Progress', 5, 'is_reserved' => 1], + [ts('Overdue'), 'Overdue', 6, 'is_reserved' => 1], + ]); diff --git a/sql/civicrm_option_groups/relative_date_filters.sqldata.php b/sql/civicrm_option_groups/relative_date_filters.sqldata.php new file mode 100644 index 0000000000..0f6c6ee8c8 --- /dev/null +++ b/sql/civicrm_option_groups/relative_date_filters.sqldata.php @@ -0,0 +1,74 @@ +addMetadata([ + 'title' => ts('Relative Date Filters'), + ]) + ->addValues(['label', 'name', 'value'], [ + [ts('Today'), 'this.day', 'this.day'], + [ts('This week'), 'this.week', 'this.week'], + [ts('This calendar month'), 'this.month', 'this.month'], + [ts('This quarter'), 'this.quarter', 'this.quarter'], + [ts('This fiscal year'), 'this.fiscal_year', 'this.fiscal_year'], + [ts('This calendar year'), 'this.year', 'this.year'], + [ts('Yesterday'), 'previous.day', 'previous.day'], + [ts('Previous week'), 'previous.week', 'previous.week'], + [ts('Previous calendar month'), 'previous.month', 'previous.month'], + [ts('Previous quarter'), 'previous.quarter', 'previous.quarter'], + [ts('Previous fiscal year'), 'previous.fiscal_year', 'previous.fiscal_year'], + [ts('Previous calendar year'), 'previous.year', 'previous.year'], + [ts('Last 7 days including today'), 'ending.week', 'ending.week'], + [ts('Last 30 days including today'), 'ending.month', 'ending_30.day'], + [ts('Last 60 days including today'), 'ending_2.month', 'ending_60.day'], + [ts('Last 90 days including today'), 'ending.quarter', 'ending_90.day'], + [ts('Last 12 months including today'), 'ending.year', 'ending.year'], + [ts('Last 2 years including today'), 'ending_2.year', 'ending_2.year'], + [ts('Last 3 years including today'), 'ending_3.year', 'ending_3.year'], + [ts('Tomorrow'), 'starting.day', 'starting.day'], + [ts('Next week'), 'next.week', 'next.week'], + [ts('Next calendar month'), 'next.month', 'next.month'], + [ts('Next quarter'), 'next.quarter', 'next.quarter'], + [ts('Next fiscal year'), 'next.fiscal_year', 'next.fiscal_year'], + [ts('Next calendar year'), 'next.year', 'next.year'], + [ts('Next 7 days including today'), 'starting.week', 'starting.week'], + [ts('Next 30 days including today'), 'starting.month', 'starting.month'], + [ts('Next 60 days including today'), 'starting_2.month', 'starting_2.month'], + [ts('Next 90 days including today'), 'starting.quarter', 'starting.quarter'], + [ts('Next 12 months including today'), 'starting.year', 'starting.year'], + [ts('Current week to-date'), 'current.week', 'current.week'], + [ts('Current calendar month to-date'), 'current.month', 'current.month'], + [ts('Current quarter to-date'), 'current.quarter', 'current.quarter'], + [ts('Current calendar year to-date'), 'current.year', 'current.year'], + [ts('To end of yesterday'), 'earlier.day', 'earlier.day'], + [ts('To end of previous week'), 'earlier.week', 'earlier.week'], + [ts('To end of previous calendar month'), 'earlier.month', 'earlier.month'], + [ts('To end of previous quarter'), 'earlier.quarter', 'earlier.quarter'], + [ts('To end of previous calendar year'), 'earlier.year', 'earlier.year'], + [ts('From start of current day'), 'greater.day', 'greater.day'], + [ts('From start of current week'), 'greater.week', 'greater.week'], + [ts('From start of current calendar month'), 'greater.month', 'greater.month'], + [ts('From start of current quarter'), 'greater.quarter', 'greater.quarter'], + [ts('From start of current calendar year'), 'greater.year', 'greater.year'], + [ts('To end of current week'), 'less.week', 'less.week'], + [ts('To end of current calendar month'), 'less.month', 'less.month'], + [ts('To end of current quarter'), 'less.quarter', 'less.quarter'], + [ts('To end of current calendar year'), 'less.year', 'less.year'], + [ts('Previous 2 days'), 'previous_2.day', 'previous_2.day'], + [ts('Previous 2 weeks'), 'previous_2.week', 'previous_2.week'], + [ts('Previous 2 calendar months'), 'previous_2.month', 'previous_2.month'], + [ts('Previous 2 quarters'), 'previous_2.quarter', 'previous_2.quarter'], + [ts('Previous 2 calendar years'), 'previous_2.year', 'previous_2.year'], + [ts('Previous 2 fiscal years'), 'previous_2.fiscal_year', 'previous_2.fiscal_year'], + [ts('Day prior to yesterday'), 'previous_before.day', 'previous_before.day'], + [ts('Week prior to previous week'), 'previous_before.week', 'previous_before.week'], + [ts('Month prior to previous calendar month'), 'previous_before.month', 'previous_before.month', 'is_default' => NULL], + [ts('Quarter prior to previous quarter'), 'previous_before.quarter', 'previous_before.quarter'], + [ts('Year prior to previous calendar year'), 'previous_before.year', 'previous_before.year'], + [ts('Fiscal year prior to previous fiscal year'), 'previous_before.fiscal_year', 'previous_before.fiscal_year'], + [ts('From end of previous week'), 'greater_previous.week', 'greater_previous.week'], + [ts('From end of previous calendar month'), 'greater_previous.month', 'greater_previous.month'], + [ts('From end of previous quarter'), 'greater_previous.quarter', 'greater_previous.quarter'], + [ts('From end of previous calendar year'), 'greater_previous.year', 'greater_previous.year'], + ]) + ->addDefaults([ + 'filter' => NULL, + ]); diff --git a/xml/templates/civicrm_data.tpl b/xml/templates/civicrm_data.tpl index 7085323575..9079d49be6 100644 --- a/xml/templates/civicrm_data.tpl +++ b/xml/templates/civicrm_data.tpl @@ -136,10 +136,6 @@ SELECT @option_group_id_pi := max(id) from civicrm_option_group wher SELECT @option_group_id_arel := max(id) from civicrm_option_group where name = 'account_relationship'; SELECT @option_group_id_fat := max(id) from civicrm_option_group where name = 'financial_account_type'; -SELECT @option_group_id_date_filter := max(id) from civicrm_option_group where name = 'relative_date_filters'; -SELECT @option_group_id_ps := max(id) from civicrm_option_group where name = 'pledge_status'; -SELECT @option_group_id_crs := max(id) from civicrm_option_group where name = 'contribution_recur_status'; -SELECT @option_group_id_env := max(id) from civicrm_option_group where name = 'environment'; SELECT @option_group_id_default_assignee := max(id) from civicrm_option_group where name = 'activity_default_assignee'; SELECT @option_group_id_entity_batch_extends := max(id) from civicrm_option_group where name = 'entity_batch_extends'; @@ -155,95 +151,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 --- Environment -(@option_group_id_env, '{ts escape="sql"}Production{/ts}', 'Production', 'Production', NULL, NULL, 1, 1, 'Production Environment', 0, 1, 1, NULL, NULL, NULL), -(@option_group_id_env, '{ts escape="sql"}Staging{/ts}', 'Staging', 'Staging', NULL, NULL, 0, 2, 'Staging Environment', 0, 1, 1, NULL, NULL, NULL), -(@option_group_id_env, '{ts escape="sql"}Development{/ts}', 'Development', 'Development', NULL, NULL, 0, 3, 'Development Environment', 0, 1, 1, NULL, NULL, NULL), - --- Relative Date Filters - (@option_group_id_date_filter, '{ts escape="sql"}Today{/ts}', 'this.day', 'this.day', NULL, NULL, 0,1, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_date_filter, '{ts escape="sql"}This week{/ts}', 'this.week', 'this.week', NULL, NULL, 0,2, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_date_filter, '{ts escape="sql"}This calendar month{/ts}', 'this.month', 'this.month', NULL, NULL, 0,3, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_date_filter, '{ts escape="sql"}This quarter{/ts}', 'this.quarter', 'this.quarter', NULL, NULL, 0,4, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_date_filter, '{ts escape="sql"}This fiscal year{/ts}', 'this.fiscal_year', 'this.fiscal_year', NULL, NULL, 0,5, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_date_filter, '{ts escape="sql"}This calendar year{/ts}', 'this.year', 'this.year', NULL, NULL, 0,6, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_date_filter, '{ts escape="sql"}Yesterday{/ts}', 'previous.day', 'previous.day', NULL, NULL, 0,7, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_date_filter, '{ts escape="sql"}Previous week{/ts}', 'previous.week', 'previous.week', NULL, NULL, 0,8, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_date_filter, '{ts escape="sql"}Previous calendar month{/ts}', 'previous.month', 'previous.month', NULL, NULL, 0,9, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_date_filter, '{ts escape="sql"}Previous quarter{/ts}', 'previous.quarter', 'previous.quarter', NULL, NULL, 0,10, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_date_filter, '{ts escape="sql"}Previous fiscal year{/ts}', 'previous.fiscal_year', 'previous.fiscal_year', NULL, NULL, 0,11, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_date_filter, '{ts escape="sql"}Previous calendar year{/ts}', 'previous.year', 'previous.year', NULL, NULL, 0,12, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_date_filter, '{ts escape="sql"}Last 7 days including today{/ts}', 'ending.week', 'ending.week', NULL, NULL, 0,13, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_date_filter, '{ts escape="sql"}Last 30 days including today{/ts}', 'ending_30.day', 'ending.month', NULL, NULL, 0,14, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_date_filter, '{ts escape="sql"}Last 60 days including today{/ts}', 'ending_60.day', 'ending_2.month', NULL, NULL, 0,15, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_date_filter, '{ts escape="sql"}Last 90 days including today{/ts}', 'ending_90.day', 'ending.quarter', NULL, NULL, 0,16, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_date_filter, '{ts escape="sql"}Last 12 months including today{/ts}', 'ending.year', 'ending.year', NULL, NULL, 0,17, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_date_filter, '{ts escape="sql"}Last 2 years including today{/ts}', 'ending_2.year', 'ending_2.year', NULL, NULL, 0,18, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_date_filter, '{ts escape="sql"}Last 3 years including today{/ts}', 'ending_3.year', 'ending_3.year', NULL, NULL, 0,19, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_date_filter, '{ts escape="sql"}Tomorrow{/ts}', 'starting.day', 'starting.day', NULL, NULL, 0,20, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_date_filter, '{ts escape="sql"}Next week{/ts}', 'next.week', 'next.week', NULL, NULL, 0,21, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_date_filter, '{ts escape="sql"}Next calendar month{/ts}', 'next.month', 'next.month', NULL, NULL, 0,22, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_date_filter, '{ts escape="sql"}Next quarter{/ts}', 'next.quarter', 'next.quarter', NULL, NULL, 0,23, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_date_filter, '{ts escape="sql"}Next fiscal year{/ts}', 'next.fiscal_year', 'next.fiscal_year', NULL, NULL, 0,24, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_date_filter, '{ts escape="sql"}Next calendar year{/ts}', 'next.year', 'next.year', NULL, NULL, 0,25, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_date_filter, '{ts escape="sql"}Next 7 days including today{/ts}', 'starting.week', 'starting.week', NULL, NULL, 0,26, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_date_filter, '{ts escape="sql"}Next 30 days including today{/ts}', 'starting.month', 'starting.month', NULL, NULL, 0,27, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_date_filter, '{ts escape="sql"}Next 60 days including today{/ts}', 'starting_2.month', 'starting_2.month', NULL, NULL, 0,28, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_date_filter, '{ts escape="sql"}Next 90 days including today{/ts}', 'starting.quarter', 'starting.quarter', NULL, NULL, 0,29, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_date_filter, '{ts escape="sql"}Next 12 months including today{/ts}', 'starting.year', 'starting.year', NULL, NULL, 0,30, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_date_filter, '{ts escape="sql"}Current week to-date{/ts}', 'current.week', 'current.week', NULL, NULL, 0,31, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_date_filter, '{ts escape="sql"}Current calendar month to-date{/ts}', 'current.month', 'current.month', NULL, NULL, 0,32, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_date_filter, '{ts escape="sql"}Current quarter to-date{/ts}', 'current.quarter', 'current.quarter', NULL, NULL, 0,33, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_date_filter, '{ts escape="sql"}Current calendar year to-date{/ts}', 'current.year', 'current.year', NULL, NULL, 0,34, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_date_filter, '{ts escape="sql"}To end of yesterday{/ts}', 'earlier.day', 'earlier.day', NULL, NULL, 0,35, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_date_filter, '{ts escape="sql"}To end of previous week{/ts}', 'earlier.week', 'earlier.week', NULL, NULL, 0,36, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_date_filter, '{ts escape="sql"}To end of previous calendar month{/ts}', 'earlier.month', 'earlier.month', NULL, NULL, 0,37, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_date_filter, '{ts escape="sql"}To end of previous quarter{/ts}', 'earlier.quarter', 'earlier.quarter', NULL, NULL, 0,38, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_date_filter, '{ts escape="sql"}To end of previous calendar year{/ts}', 'earlier.year', 'earlier.year', NULL, NULL, 0,39, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_date_filter, '{ts escape="sql"}From start of current day{/ts}', 'greater.day', 'greater.day', NULL, NULL, 0,40, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_date_filter, '{ts escape="sql"}From start of current week{/ts}', 'greater.week', 'greater.week', NULL, NULL, 0,41, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_date_filter, '{ts escape="sql"}From start of current calendar month{/ts}', 'greater.month', 'greater.month', NULL, NULL, 0,42, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_date_filter, '{ts escape="sql"}From start of current quarter{/ts}', 'greater.quarter', 'greater.quarter', NULL, NULL, 0,43, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_date_filter, '{ts escape="sql"}From start of current calendar year{/ts}', 'greater.year', 'greater.year', NULL, NULL, 0,44, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_date_filter, '{ts escape="sql"}To end of current week{/ts}', 'less.week', 'less.week', NULL, NULL, 0,45, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_date_filter, '{ts escape="sql"}To end of current calendar month{/ts}', 'less.month', 'less.month', NULL, NULL, 0,46, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_date_filter, '{ts escape="sql"}To end of current quarter{/ts}', 'less.quarter', 'less.quarter', NULL, NULL, 0,47, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_date_filter, '{ts escape="sql"}To end of current calendar year{/ts}', 'less.year', 'less.year', NULL, NULL, 0,48, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_date_filter, '{ts escape="sql"}Previous 2 days{/ts}', 'previous_2.day', 'previous_2.day', NULL, NULL, 0,49, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_date_filter, '{ts escape="sql"}Previous 2 weeks{/ts}', 'previous_2.week', 'previous_2.week', NULL, NULL, 0,50, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_date_filter, '{ts escape="sql"}Previous 2 calendar months{/ts}', 'previous_2.month', 'previous_2.month', NULL, NULL, 0,51, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_date_filter, '{ts escape="sql"}Previous 2 quarters{/ts}', 'previous_2.quarter', 'previous_2.quarter', NULL, NULL, 0,52, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_date_filter, '{ts escape="sql"}Previous 2 calendar years{/ts}', 'previous_2.year', 'previous_2.year', NULL, NULL, 0,53, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_date_filter, '{ts escape="sql"}Previous 2 fiscal years{/ts}', 'previous_2.fiscal_year', 'previous_2.fiscal_year', NULL, NULL, 0,54, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_date_filter, '{ts escape="sql"}Day prior to yesterday{/ts}', 'previous_before.day', 'previous_before.day', NULL, NULL, 0,55, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_date_filter, '{ts escape="sql"}Week prior to previous week{/ts}', 'previous_before.week', 'previous_before.week', NULL, NULL, 0,56, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_date_filter, '{ts escape="sql"}Month prior to previous calendar month{/ts}', 'previous_before.month', 'previous_before.month', NULL, NULL, NULL,57, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_date_filter, '{ts escape="sql"}Quarter prior to previous quarter{/ts}', 'previous_before.quarter', 'previous_before.quarter', NULL, NULL, 0,58, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_date_filter, '{ts escape="sql"}Year prior to previous calendar year{/ts}', 'previous_before.year', 'previous_before.year', NULL, NULL, 0,59, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_date_filter, '{ts escape="sql"}Fiscal year prior to previous fiscal year{/ts}', 'previous_before.fiscal_year', 'previous_before.fiscal_year', NULL, NULL, 0,60, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_date_filter, '{ts escape="sql"}From end of previous week{/ts}', 'greater_previous.week', 'greater_previous.week', NULL, NULL, 0,61, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_date_filter, '{ts escape="sql"}From end of previous calendar month{/ts}', 'greater_previous.month', 'greater_previous.month', NULL, NULL, 0,62, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_date_filter, '{ts escape="sql"}From end of previous quarter{/ts}', 'greater_previous.quarter', 'greater_previous.quarter', NULL, NULL, 0,63, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_date_filter, '{ts escape="sql"}From end of previous calendar year{/ts}', 'greater_previous.year', 'greater_previous.year', NULL, NULL, 0,64, NULL, 0, 0, 1, NULL, NULL, NULL), - --- Pledge Status - (@option_group_id_ps, '{ts escape="sql"}Completed{/ts}' , 1, 'Completed' , NULL, 0, 0, 1, NULL, 0, 1, 1, NULL, NULL, NULL), - (@option_group_id_ps, '{ts escape="sql"}Pending{/ts}' , 2, 'Pending' , NULL, 0, 0, 2, NULL, 0, 1, 1, NULL, NULL, NULL), - (@option_group_id_ps, '{ts escape="sql"}Cancelled{/ts}' , 3, 'Cancelled' , NULL, 0, 0, 3, NULL, 0, 1, 1, NULL, NULL, NULL), - (@option_group_id_ps, '{ts escape="sql"}In Progress{/ts}', 5, 'In Progress', NULL, 0, 0, 4, NULL, 0, 1, 1, NULL, NULL, NULL), - (@option_group_id_ps, '{ts escape="sql"}Overdue{/ts}' , 6, 'Overdue' , NULL, 0, 0, 5, NULL, 0, 1, 1, NULL, NULL, NULL), - - --- Contribution Recur Status - (@option_group_id_crs, '{ts escape="sql"}Completed{/ts}' , 1, 'Completed' , NULL, 0, 0, 1, NULL, 0, 1, 1, NULL, NULL, NULL), - (@option_group_id_crs, '{ts escape="sql"}Pending{/ts}' , 2, 'Pending' , NULL, 0, 0, 2, NULL, 0, 1, 1, NULL, NULL, NULL), - (@option_group_id_crs, '{ts escape="sql"}Cancelled{/ts}' , 3, 'Cancelled' , NULL, 0, 0, 3, NULL, 0, 1, 1, NULL, NULL, NULL), - (@option_group_id_crs, '{ts escape="sql"}Failed{/ts}' , 4, 'Failed' , NULL, 0, 0, 4, NULL, 0, 1, 1, NULL, NULL, NULL), - (@option_group_id_crs, '{ts escape="sql"}In Progress{/ts}', 5, 'In Progress', NULL, 0, 0, 5, NULL, 0, 1, 1, NULL, NULL, NULL), - (@option_group_id_crs, '{ts escape="sql"}Overdue{/ts}' , 6, 'Overdue' , NULL, 0, 0, 6, NULL, 0, 1, 1, NULL, NULL, NULL), - (@option_group_id_crs, '{ts escape="sql"}Processing{/ts}' , 7, 'Processing' , NULL, 0, 0, 7, NULL, 0, 1, 1, NULL, NULL, NULL), - (@option_group_id_crs, '{ts escape="sql"}Failing{/ts}' , 8, 'Failing' , NULL, 0, 0, 8, NULL, 0, 1, 1, NULL, NULL, NULL), - -- CiviCase - Activity Assignee Default -- (`option_group_id`, `label`, `value`, `name`, `grouping`, `filter`, `is_default`, `weight`, `description`, `is_optgroup`, `is_reserved`, `is_active`, `component_id`, `visibility_id`, `icon`) (@option_group_id_default_assignee, '{ts escape="sql"}None{/ts}', '1', 'NONE', NULL, 0, 1, 1, NULL, 0, 0, 1, NULL, NULL, NULL), -- 2.25.1