From b9ce714f332fd7c99b884e0cd63dca57950e98b9 Mon Sep 17 00:00:00 2001 From: Tim Otten Date: Wed, 17 May 2023 02:10:02 -0700 Subject: [PATCH] Extract addressee, contact_autocomplete_options, contact_reference_options, custom_data_type... And also: email_greeting, mail_protocol, note_used_for, postal_greeting, priority, redaction_rule, report_template, tag_used_for, visibility, website_type --- sql/civicrm_option_groups.php | 60 ------- .../addressee.sqldata.php | 11 ++ .../contact_autocomplete_options.sqldata.php | 15 ++ .../contact_reference_options.sqldata.php | 15 ++ .../custom_data_type.sqldata.php | 10 ++ .../email_greeting.sqldata.php | 12 ++ .../mail_protocol.sqldata.php | 11 ++ .../note_used_for.sqldata.php | 12 ++ .../postal_greeting.sqldata.php | 12 ++ .../priority.sqldata.php | 10 ++ .../redaction_rule.sqldata.php | 9 ++ .../report_template.sqldata.php | 54 +++++++ .../tag_used_for.sqldata.php | 12 ++ .../visibility.sqldata.php | 9 ++ .../website_type.sqldata.php | 18 +++ xml/templates/civicrm_data.tpl | 147 ------------------ 16 files changed, 210 insertions(+), 207 deletions(-) create mode 100644 sql/civicrm_option_groups/addressee.sqldata.php create mode 100644 sql/civicrm_option_groups/contact_autocomplete_options.sqldata.php create mode 100644 sql/civicrm_option_groups/contact_reference_options.sqldata.php create mode 100644 sql/civicrm_option_groups/custom_data_type.sqldata.php create mode 100644 sql/civicrm_option_groups/email_greeting.sqldata.php create mode 100644 sql/civicrm_option_groups/mail_protocol.sqldata.php create mode 100644 sql/civicrm_option_groups/note_used_for.sqldata.php create mode 100644 sql/civicrm_option_groups/postal_greeting.sqldata.php create mode 100644 sql/civicrm_option_groups/priority.sqldata.php create mode 100644 sql/civicrm_option_groups/redaction_rule.sqldata.php create mode 100644 sql/civicrm_option_groups/report_template.sqldata.php create mode 100644 sql/civicrm_option_groups/tag_used_for.sqldata.php create mode 100644 sql/civicrm_option_groups/visibility.sqldata.php create mode 100644 sql/civicrm_option_groups/website_type.sqldata.php diff --git a/sql/civicrm_option_groups.php b/sql/civicrm_option_groups.php index 3bba5cb927..f97f6e5533 100644 --- a/sql/civicrm_option_groups.php +++ b/sql/civicrm_option_groups.php @@ -19,66 +19,6 @@ $readOptionGroups = function (): array { }; return $readOptionGroups() + [ - 'custom_data_type' => CRM_Core_CodeGen_OptionGroup::create('custom_data_type') - ->addMetadata([ - 'title' => ts('Custom Data Type'), - ]), - 'visibility' => CRM_Core_CodeGen_OptionGroup::create('visibility') - ->addMetadata([ - 'title' => ts('Visibility'), - ]), - 'mail_protocol' => CRM_Core_CodeGen_OptionGroup::create('mail_protocol') - ->addMetadata([ - 'title' => ts('Mail Protocol'), - ]), - 'priority' => CRM_Core_CodeGen_OptionGroup::create('priority') - ->addMetadata([ - 'title' => ts('Priority'), - ]), - 'redaction_rule' => CRM_Core_CodeGen_OptionGroup::create('redaction_rule') - ->addMetadata([ - 'title' => ts('Redaction Rule'), - ]), - 'report_template' => CRM_Core_CodeGen_OptionGroup::create('report_template') - ->addMetadata([ - 'title' => ts('Report Template'), - ]), - 'email_greeting' => CRM_Core_CodeGen_OptionGroup::create('email_greeting') - ->addMetadata([ - 'title' => ts('Email Greeting Type'), - ]), - 'postal_greeting' => CRM_Core_CodeGen_OptionGroup::create('postal_greeting') - ->addMetadata([ - 'title' => ts('Postal Greeting Type'), - ]), - 'addressee' => CRM_Core_CodeGen_OptionGroup::create('addressee') - ->addMetadata([ - 'title' => ts('Addressee Type'), - ]), - 'contact_autocomplete_options' => CRM_Core_CodeGen_OptionGroup::create('contact_autocomplete_options') - ->addMetadata([ - 'title' => ts('Autocomplete Contact Search'), - 'is_locked' => '1', - ]), - 'contact_reference_options' => CRM_Core_CodeGen_OptionGroup::create('contact_reference_options') - ->addMetadata([ - 'title' => ts('Contact Reference Autocomplete Options'), - 'is_locked' => '1', - ]), - 'website_type' => CRM_Core_CodeGen_OptionGroup::create('website_type') - ->addMetadata([ - 'title' => ts('Website Type'), - ]), - 'tag_used_for' => CRM_Core_CodeGen_OptionGroup::create('tag_used_for') - ->addMetadata([ - 'title' => ts('Tag Used For'), - 'is_locked' => '1', - ]), - 'note_used_for' => CRM_Core_CodeGen_OptionGroup::create('note_used_for') - ->addMetadata([ - 'title' => ts('Note Used For'), - 'is_locked' => '1', - ]), 'currencies_enabled' => CRM_Core_CodeGen_OptionGroup::create('currencies_enabled') ->addMetadata([ 'title' => ts('Currencies Enabled'), diff --git a/sql/civicrm_option_groups/addressee.sqldata.php b/sql/civicrm_option_groups/addressee.sqldata.php new file mode 100644 index 0000000000..33eb2ca467 --- /dev/null +++ b/sql/civicrm_option_groups/addressee.sqldata.php @@ -0,0 +1,11 @@ +addMetadata([ + 'title' => ts('Addressee Type'), + ]) + ->addValues(['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], + ]); diff --git a/sql/civicrm_option_groups/contact_autocomplete_options.sqldata.php b/sql/civicrm_option_groups/contact_autocomplete_options.sqldata.php new file mode 100644 index 0000000000..e6f91576da --- /dev/null +++ b/sql/civicrm_option_groups/contact_autocomplete_options.sqldata.php @@ -0,0 +1,15 @@ +addMetadata([ + 'title' => ts('Autocomplete Contact Search'), + 'is_locked' => 1, + ]) + ->addValues(['label', 'name', 'value', 'weight'], [ + [ts('Email Address'), 'email', 2, 2], + [ts('Phone'), 'phone', 3, 3], + [ts('Street Address'), 'street_address', 4, 4], + [ts('City'), 'city', 5, 5], + [ts('State/Province'), 'state_province', 6, 6], + [ts('Country'), 'country', 7, 7], + [ts('Postal Code'), 'postal_code', 8, 8], + ]); diff --git a/sql/civicrm_option_groups/contact_reference_options.sqldata.php b/sql/civicrm_option_groups/contact_reference_options.sqldata.php new file mode 100644 index 0000000000..61d6d57fcd --- /dev/null +++ b/sql/civicrm_option_groups/contact_reference_options.sqldata.php @@ -0,0 +1,15 @@ +addMetadata([ + 'title' => ts('Contact Reference Autocomplete Options'), + 'is_locked' => 1, + ]) + ->addValues(['label', 'name', 'value', 'weight'], [ + [ts('Email Address'), 'email', 2, 2], + [ts('Phone'), 'phone', 3, 3], + [ts('Street Address'), 'street_address', 4, 4], + [ts('City'), 'city', 5, 5], + [ts('State/Province'), 'state_province', 6, 6], + [ts('Country'), 'country', 7, 7], + [ts('Postal Code'), 'postal_code', 8, 8], + ]); diff --git a/sql/civicrm_option_groups/custom_data_type.sqldata.php b/sql/civicrm_option_groups/custom_data_type.sqldata.php new file mode 100644 index 0000000000..0417500343 --- /dev/null +++ b/sql/civicrm_option_groups/custom_data_type.sqldata.php @@ -0,0 +1,10 @@ +addMetadata([ + 'title' => ts('Custom Data Type'), + ]) + ->addValues(['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'], + ]); diff --git a/sql/civicrm_option_groups/email_greeting.sqldata.php b/sql/civicrm_option_groups/email_greeting.sqldata.php new file mode 100644 index 0000000000..735d929c8e --- /dev/null +++ b/sql/civicrm_option_groups/email_greeting.sqldata.php @@ -0,0 +1,12 @@ +addMetadata([ + 'title' => ts('Email Greeting Type'), + ]) + ->addValues(['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], + ]); diff --git a/sql/civicrm_option_groups/mail_protocol.sqldata.php b/sql/civicrm_option_groups/mail_protocol.sqldata.php new file mode 100644 index 0000000000..71b58f1db7 --- /dev/null +++ b/sql/civicrm_option_groups/mail_protocol.sqldata.php @@ -0,0 +1,11 @@ +addMetadata([ + 'title' => ts('Mail Protocol'), + ]) + ->addValues(['label', 'name', 'value'], [ + ['IMAP', 'IMAP', 1], + ['Maildir', 'Maildir', 2], + ['POP3', 'POP3', 3], + ['Localdir', 'Localdir', 4], + ]); diff --git a/sql/civicrm_option_groups/note_used_for.sqldata.php b/sql/civicrm_option_groups/note_used_for.sqldata.php new file mode 100644 index 0000000000..880a230967 --- /dev/null +++ b/sql/civicrm_option_groups/note_used_for.sqldata.php @@ -0,0 +1,12 @@ +addMetadata([ + 'title' => ts('Note Used For'), + 'is_locked' => 1, + ]) + ->addValues(['label', 'name', 'value'], [ + [ts('Contacts'), 'Contact', 'civicrm_contact'], + [ts('Relationships'), 'Relationship', 'civicrm_relationship'], + [ts('Participants'), 'Participant', 'civicrm_participant'], + [ts('Contributions'), 'Contribution', 'civicrm_contribution'], + ]); diff --git a/sql/civicrm_option_groups/postal_greeting.sqldata.php b/sql/civicrm_option_groups/postal_greeting.sqldata.php new file mode 100644 index 0000000000..70f53fd51f --- /dev/null +++ b/sql/civicrm_option_groups/postal_greeting.sqldata.php @@ -0,0 +1,12 @@ +addMetadata([ + 'title' => ts('Postal Greeting Type'), + ]) + ->addValues(['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], + ]); diff --git a/sql/civicrm_option_groups/priority.sqldata.php b/sql/civicrm_option_groups/priority.sqldata.php new file mode 100644 index 0000000000..b5cfdb1140 --- /dev/null +++ b/sql/civicrm_option_groups/priority.sqldata.php @@ -0,0 +1,10 @@ +addMetadata([ + 'title' => ts('Priority'), + ]) + ->addValues(['label', 'name', 'value'], [ + [ts('Urgent'), 'Urgent', 1], + [ts('Normal'), 'Normal', 2], + [ts('Low'), 'Low', 3], + ]); diff --git a/sql/civicrm_option_groups/redaction_rule.sqldata.php b/sql/civicrm_option_groups/redaction_rule.sqldata.php new file mode 100644 index 0000000000..205f833dcb --- /dev/null +++ b/sql/civicrm_option_groups/redaction_rule.sqldata.php @@ -0,0 +1,9 @@ +addMetadata([ + 'title' => ts('Redaction Rule'), + ]) + ->addValues(['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], + ]); diff --git a/sql/civicrm_option_groups/report_template.sqldata.php b/sql/civicrm_option_groups/report_template.sqldata.php new file mode 100644 index 0000000000..a638bed946 --- /dev/null +++ b/sql/civicrm_option_groups/report_template.sqldata.php @@ -0,0 +1,54 @@ +addMetadata([ + 'title' => ts('Report Template'), + ]) + ->addValues(['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], + ]); diff --git a/sql/civicrm_option_groups/tag_used_for.sqldata.php b/sql/civicrm_option_groups/tag_used_for.sqldata.php new file mode 100644 index 0000000000..8d2e4c43f5 --- /dev/null +++ b/sql/civicrm_option_groups/tag_used_for.sqldata.php @@ -0,0 +1,12 @@ +addMetadata([ + 'title' => ts('Tag Used For'), + 'is_locked' => 1, + ]) + ->addValues(['label', 'name', 'value'], [ + [ts('Contacts'), 'Contact', 'civicrm_contact'], + [ts('Activities'), 'Activity', 'civicrm_activity'], + [ts('Cases'), 'Case', 'civicrm_case'], + [ts('Attachments'), 'File', 'civicrm_file'], + ]); diff --git a/sql/civicrm_option_groups/visibility.sqldata.php b/sql/civicrm_option_groups/visibility.sqldata.php new file mode 100644 index 0000000000..70880cee63 --- /dev/null +++ b/sql/civicrm_option_groups/visibility.sqldata.php @@ -0,0 +1,9 @@ +addMetadata([ + 'title' => ts('Visibility'), + ]) + ->addValues(['label', 'name', 'value'], [ + ['Public', 'public', 1], + ['Admin', 'admin', 2], + ]); diff --git a/sql/civicrm_option_groups/website_type.sqldata.php b/sql/civicrm_option_groups/website_type.sqldata.php new file mode 100644 index 0000000000..7bd1a0d020 --- /dev/null +++ b/sql/civicrm_option_groups/website_type.sqldata.php @@ -0,0 +1,18 @@ +addMetadata([ + 'title' => ts('Website Type'), + ]) + ->addValues(['label', 'name', 'value', 'weight'], [ + ['Work', 'Work', 1, 1, 'is_default' => 1], + ['Main', 'Main', 2, 2], + ['Facebook', 'Facebook', 3, 3], + ['Instagram', 'Instagram', 5, 5], + ['LinkedIn', 'LinkedIn', 6, 6], + ['MySpace', 'MySpace', 7, 7], + ['Pinterest', 'Pinterest', 8, 8], + ['SnapChat', 'SnapChat', 9, 9], + ['Tumblr', 'Tumblr', 10, 10], + ['Twitter', 'Twitter', 11, 11], + ['Vine', 'Vine ', 12, 12], + ]); diff --git a/xml/templates/civicrm_data.tpl b/xml/templates/civicrm_data.tpl index cb2c4947ab..aae9eab8ce 100644 --- a/xml/templates/civicrm_data.tpl +++ b/xml/templates/civicrm_data.tpl @@ -134,20 +134,6 @@ VALUES SELECT @option_group_id_pi := max(id) from civicrm_option_group where name = 'payment_instrument'; -SELECT @option_group_id_cdt := max(id) from civicrm_option_group where name = 'custom_data_type'; -SELECT @option_group_id_vis := max(id) from civicrm_option_group where name = 'visibility'; -SELECT @option_group_id_mp := max(id) from civicrm_option_group where name = 'mail_protocol'; -SELECT @option_group_id_priority := max(id) from civicrm_option_group where name = 'priority'; -SELECT @option_group_id_rr := max(id) from civicrm_option_group where name = 'redaction_rule'; -SELECT @option_group_id_emailGreeting := max(id) from civicrm_option_group where name = 'email_greeting'; -SELECT @option_group_id_postalGreeting := max(id) from civicrm_option_group where name = 'postal_greeting'; -SELECT @option_group_id_addressee := max(id) from civicrm_option_group where name = 'addressee'; -SELECT @option_group_id_report := max(id) from civicrm_option_group where name = 'report_template'; -SELECT @option_group_id_acsOpt := max(id) from civicrm_option_group where name = 'contact_autocomplete_options'; -SELECT @option_group_id_acConRef := max(id) from civicrm_option_group where name = 'contact_reference_options'; -SELECT @option_group_id_website := max(id) from civicrm_option_group where name = 'website_type'; -SELECT @option_group_id_tuf := max(id) from civicrm_option_group where name = 'tag_used_for'; -SELECT @option_group_id_nuf := max(id) from civicrm_option_group where name = 'note_used_for'; SELECT @option_group_id_currency := max(id) from civicrm_option_group where name = 'currencies_enabled'; SELECT @option_group_id_eventBadge := max(id) from civicrm_option_group where name = 'event_badge'; SELECT @option_group_id_notePrivacy := max(id) from civicrm_option_group where name = 'note_privacy'; @@ -197,139 +183,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_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), - (@option_group_id_acsOpt, '{ts escape="sql"}City{/ts}' , 5, 'city' , NULL, 0, 0, 5, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_acsOpt, '{ts escape="sql"}State/Province{/ts}' , 6, 'state_province', NULL, 0, 0, 6, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_acsOpt, '{ts escape="sql"}Country{/ts}' , 7, 'country' , NULL, 0, 0, 7, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_acsOpt, '{ts escape="sql"}Postal Code{/ts}' , 8, 'postal_code' , NULL, 0, 0, 8, NULL, 0, 0, 1, NULL, NULL, NULL), - - (@option_group_id_acConRef, '{ts escape="sql"}Email Address{/ts}' , 2, 'email' , NULL, 0, 0, 2, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_acConRef, '{ts escape="sql"}Phone{/ts}' , 3, 'phone' , NULL, 0, 0, 3, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_acConRef, '{ts escape="sql"}Street Address{/ts}' , 4, 'street_address', NULL, 0, 0, 4, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_acConRef, '{ts escape="sql"}City{/ts}' , 5, 'city' , NULL, 0, 0, 5, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_acConRef, '{ts escape="sql"}State/Province{/ts}' , 6, 'state_province', NULL, 0, 0, 6, NULL, 0, 0, 1, NULL, NULL, NULL), - (@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), - --- 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), - (@option_group_id_report , '{ts escape="sql"}Activity Details Report{/ts}', 'activity', 'CRM_Report_Form_Activity', NULL, 0, 0, 3, '{ts escape="sql"}Provides a list of constituent activity including activity statistics for one/all contacts during a given date range(required){/ts}', 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_report , '{ts escape="sql"}Walk / Phone List Report{/ts}', 'walklist', 'CRM_Report_Form_Walklist_Walklist', NULL, 0, 0, 4, '{ts escape="sql"}Provides a detailed report for your walk/phonelist for targeted contacts{/ts}', 0, 0, 0, NULL, NULL, NULL), - (@option_group_id_report , '{ts escape="sql"}Current Employer Report{/ts}', 'contact/currentEmployer', 'CRM_Report_Form_Contact_CurrentEmployer', NULL, 0, 0, 5, '{ts escape="sql"}Provides detail list of employer employee relationships along with employment details Ex Join Date{/ts}', 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_report , '{ts escape="sql"}Contribution Summary Report{/ts}', 'contribute/summary', 'CRM_Report_Form_Contribute_Summary', NULL, 0, 0, 6, '{ts escape="sql"}Groups and totals contributions by criteria including contact, time period, financial type, contributor location, etc.{/ts}', 0, 0, 1, @contributeCompId, NULL, NULL), - (@option_group_id_report , '{ts escape="sql"}Contribution Detail Report{/ts}', 'contribute/detail', 'CRM_Report_Form_Contribute_Detail', NULL, 0, 0, 7, '{ts escape="sql"}Lists specific contributions by criteria including contact, time period, financial type, contributor location, etc. Contribution summary report points to this report for contribution details.{/ts}', 0, 0, 1, @contributeCompId, NULL, NULL), - (@option_group_id_report , '{ts escape="sql"}Repeat Contributions Report{/ts}', 'contribute/repeat', 'CRM_Report_Form_Contribute_Repeat', NULL, 0, 0, 8, '{ts escape="sql"}Given two date ranges, shows contacts who contributed in both the date ranges with the amount contributed in each and the percentage increase / decrease.{/ts}', 0, 0, 1, @contributeCompId, NULL, NULL), - (@option_group_id_report , '{ts escape="sql"}Contributions by Organization Report{/ts}', 'contribute/organizationSummary', 'CRM_Report_Form_Contribute_OrganizationSummary', NULL, 0, 0, 9, '{ts escape="sql"}Displays a detailed list of contributions grouped by organization, which includes contributions made by employees for the organisation.{/ts}', 0, 0, 1, @contributeCompId, NULL, NULL), - (@option_group_id_report , '{ts escape="sql"}Contributions by Household Report{/ts}', 'contribute/householdSummary', 'CRM_Report_Form_Contribute_HouseholdSummary', NULL, 0, 0, 10, '{ts escape="sql"}Displays a detailed list of contributions grouped by household which includes contributions made by members of the household.{/ts}', 0, 0, 1, @contributeCompId, NULL, NULL), - (@option_group_id_report , '{ts escape="sql"}Top Donors Report{/ts}', 'contribute/topDonor', 'CRM_Report_Form_Contribute_TopDonor', NULL, 0, 0, 11, '{ts escape="sql"}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).{/ts}', 0, 0, 1, @contributeCompId, NULL, NULL), - (@option_group_id_report , '{ts escape="sql"}SYBUNT Report{/ts}', 'contribute/sybunt', 'CRM_Report_Form_Contribute_Sybunt', NULL, 0, 0, 12, '{ts escape="sql"}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.{/ts}', 0, 0, 1, @contributeCompId, NULL, NULL), - (@option_group_id_report , '{ts escape="sql"}LYBUNT Report{/ts}', 'contribute/lybunt', 'CRM_Report_Form_Contribute_Lybunt', NULL, 0, 0, 13, '{ts escape="sql"}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.{/ts}', 0, 0, 1, @contributeCompId, NULL, NULL), - (@option_group_id_report , '{ts escape="sql"}Soft Credit Report{/ts}', 'contribute/softcredit', 'CRM_Report_Form_Contribute_SoftCredit', NULL, 0, 0, 14, '{ts escape="sql"}Shows contributions made by contacts that have been soft-credited to other contacts.{/ts}', 0, 0, 1,@contributeCompId, NULL, NULL), - (@option_group_id_report , '{ts escape="sql"}Membership Report (Summary){/ts}', 'member/summary', 'CRM_Report_Form_Member_Summary', NULL, 0, 0, 15, '{ts escape="sql"}Provides a summary of memberships by type and Member Since.{/ts}', 0, 0, 1, @memberCompId, NULL, NULL), - (@option_group_id_report , '{ts escape="sql"}Membership Report (Detail){/ts}', 'member/detail', 'CRM_Report_Form_Member_Detail', NULL, 0, 0, 16, '{ts escape="sql"}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.{/ts}', 0, 0, 1, @memberCompId, NULL, NULL), - (@option_group_id_report , '{ts escape="sql"}Membership Report (Lapsed){/ts}', 'member/lapse', 'CRM_Report_Form_Member_Lapse', NULL, 0, 0, 17, '{ts escape="sql"}Provides a list of memberships that lapsed or will lapse before the date you specify.{/ts}', 0, 0, 1, @memberCompId, NULL, NULL), - (@option_group_id_report , '{ts escape="sql"}Event Participant Report (List){/ts}', 'event/participantListing', 'CRM_Report_Form_Event_ParticipantListing', NULL, 0, 0, 18, '{ts escape="sql"}Provides lists of participants for an event.{/ts}', 0, 0, 1, @eventCompId, NULL, NULL), - (@option_group_id_report , '{ts escape="sql"}Event Income Report (Summary){/ts}', 'event/summary', 'CRM_Report_Form_Event_Summary', NULL, 0, 0, 19, '{ts escape="sql"}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.{/ts}', 0, 0, 1, @eventCompId, NULL, NULL), - (@option_group_id_report , '{ts escape="sql"}Event Income Report (Detail){/ts}', 'event/income', 'CRM_Report_Form_Event_Income', NULL, 0, 0, 20, '{ts escape="sql"}Helps you to analyze the income generated by an event. The report can include details by participant type, status and payment method.{/ts}', 0, 0, 1, @eventCompId, NULL, NULL), - (@option_group_id_report , '{ts escape="sql"}Pledge Detail Report{/ts}', 'pledge/detail', 'CRM_Report_Form_Pledge_Detail', NULL, 0, 0, 21, '{ts escape="sql"}List of pledges including amount pledged, pledge status, next payment date, balance due, total amount paid etc.{/ts}', 0, 0, 1, @pledgeCompId, NULL, NULL), - (@option_group_id_report , '{ts escape="sql"}Pledged but not Paid Report{/ts}', 'pledge/pbnp', 'CRM_Report_Form_Pledge_Pbnp', NULL, 0, 0, 22, '{ts escape="sql"}Pledged but not Paid Report{/ts}', 0, 0, 1, @pledgeCompId, NULL, NULL), - (@option_group_id_report , '{ts escape="sql"}Relationship Report{/ts}', 'contact/relationship', 'CRM_Report_Form_Contact_Relationship', NULL, 0, 0, 23, '{ts escape="sql"}Relationship Report{/ts}', 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_report , '{ts escape="sql"}Case Summary Report{/ts}', 'case/summary', 'CRM_Report_Form_Case_Summary', NULL, 0, 0, 24, '{ts escape="sql"}Provides a summary of cases and their duration by date range, status, staff member and / or case role.{/ts}', 0, 0, 1, @caseCompId, NULL, NULL), - (@option_group_id_report , '{ts escape="sql"}Case Time Spent Report{/ts}', 'case/timespent', 'CRM_Report_Form_Case_TimeSpent', NULL, 0, 0, 25, '{ts escape="sql"}Aggregates time spent on case and / or non-case activities by activity type and contact.{/ts}', 0, 0, 1, @caseCompId, NULL, NULL), - (@option_group_id_report , '{ts escape="sql"}Contact Demographics Report{/ts}', 'case/demographics', 'CRM_Report_Form_Case_Demographics', NULL, 0, 0, 26, '{ts escape="sql"}Demographic breakdown for case clients (and or non-case contacts) in your database. Includes custom contact fields.{/ts}', 0, 0, 1, @caseCompId, NULL, NULL), - (@option_group_id_report , '{ts escape="sql"}Database Log Report{/ts}', 'contact/log', 'CRM_Report_Form_Contact_Log', NULL, 0, 0, 27, '{ts escape="sql"}Log of contact and activity records created or updated in a given date range.{/ts}', 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_report , '{ts escape="sql"}Activity Summary Report{/ts}', 'activitySummary', 'CRM_Report_Form_ActivitySummary', NULL, 0, 0, 28, '{ts escape="sql"}Shows activity statistics by type / date{/ts}', 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_report, '{ts escape="sql"}Bookkeeping Transactions Report{/ts}', 'contribute/bookkeeping', 'CRM_Report_Form_Contribute_Bookkeeping', NULL, 0, 0, 29, '{ts escape="sql"}Shows Bookkeeping Transactions Report{/ts}', 0, 0, 1, 2, NULL, NULL), - (@option_group_id_report, '{ts escape="sql"}Participant list Count Report{/ts}', 'event/participantlist', 'CRM_Report_Form_Event_ParticipantListCount', NULL, 0, 0, 31, '{ts escape="sql"}Shows the Participant list with Participant Count.{/ts}', 0, 0, 1, @eventCompId, NULL, NULL), - (@option_group_id_report, '{ts escape="sql"}Income Count Summary Report{/ts}', 'event/incomesummary', 'CRM_Report_Form_Event_IncomeCountSummary', NULL, 0, 0, 32, '{ts escape="sql"}Shows the Income Summary of events with Count.{/ts}', 0, 0, 1, @eventCompId, NULL, NULL), - (@option_group_id_report, '{ts escape="sql"}Case Detail Report{/ts}', 'case/detail', 'CRM_Report_Form_Case_Detail', NULL, 0, 0, 33, '{ts escape="sql"}Case Details{/ts}', 0, 0, 1, @caseCompId, NULL, NULL), - (@option_group_id_report, '{ts escape="sql"}Mail Bounce Report{/ts}', 'Mailing/bounce', 'CRM_Report_Form_Mailing_Bounce', NULL, 0, 0, 34, '{ts escape="sql"}Bounce Report for mailings{/ts}', 0, 0, 1, @mailCompId, NULL, NULL), - (@option_group_id_report, '{ts escape="sql"}Mail Summary Report{/ts}', 'Mailing/summary', 'CRM_Report_Form_Mailing_Summary', NULL, 0, 0, 35, '{ts escape="sql"}Summary statistics for mailings{/ts}', 0, 0, 1, @mailCompId, NULL, NULL), - (@option_group_id_report, '{ts escape="sql"}Mail Opened Report{/ts}', 'Mailing/opened', 'CRM_Report_Form_Mailing_Opened', NULL, 0, 0, 36, '{ts escape="sql"}Display contacts who opened emails from a mailing{/ts}', 0, 0, 1, @mailCompId, NULL, NULL), - (@option_group_id_report, '{ts escape="sql"}Mail Click-Through Report{/ts}', 'Mailing/clicks', 'CRM_Report_Form_Mailing_Clicks', NULL, 0, 0, 37, '{ts escape="sql"}Display clicks from each mailing{/ts}', 0, 0, 1, @mailCompId, NULL, NULL), - (@option_group_id_report, '{ts escape="sql"}Contact Logging Report (Summary){/ts}', 'logging/contact/summary', 'CRM_Report_Form_Contact_LoggingSummary', NULL, 0, 0, 38, '{ts escape="sql"}Contact modification report for the logging infrastructure (summary).{/ts}', 0, 0, 0, NULL, NULL, NULL), - (@option_group_id_report, '{ts escape="sql"}Contact Logging Report (Detail){/ts}', 'logging/contact/detail', 'CRM_Report_Form_Contact_LoggingDetail', NULL, 0, 0, 39, '{ts escape="sql"}Contact modification report for the logging infrastructure (detail).{/ts}', 0, 0, 0, NULL, NULL, NULL), - (@option_group_id_report, '{ts escape="sql"}Survey Report (Detail){/ts}', 'survey/detail', 'CRM_Report_Form_Campaign_SurveyDetails', NULL, 0, 0, 43, '{ts escape="sql"}Detailed report for canvassing, phone-banking, walk lists or other surveys.{/ts}', 0, 0, 1, @campaignCompId, NULL, NULL), - (@option_group_id_report, '{ts escape="sql"}Personal Campaign Page Report{/ts}', 'contribute/pcp', 'CRM_Report_Form_Contribute_PCP', NULL, 0, 0, 44, '{ts escape="sql"}Summarizes amount raised and number of contributors for each Personal Campaign Page.{/ts}', 0, 0, 1, @contributeCompId, NULL, NULL), - (@option_group_id_report , '{ts escape="sql"}Pledge Summary Report{/ts}', 'pledge/summary', 'CRM_Report_Form_Pledge_Summary', NULL, 0, 0, 45, '{ts escape="sql"}Groups and totals pledges by criteria including contact, time period, pledge status, location, etc.{/ts}', 0, 0, 1, @pledgeCompId, NULL, NULL), - (@option_group_id_report , '{ts escape="sql"}Contribution Aggregate by Relationship{/ts}', 'contribute/history', 'CRM_Report_Form_Contribute_History', NULL, 0, 0, 46, '{ts escape="sql"}List contact's donation history, grouped by year, along with contributions attributed to any of the contact's related contacts.{/ts}', 0, 0, 1, @contributeCompId, NULL, NULL), - (@option_group_id_report, '{ts escape="sql"}Mail Detail Report{/ts}', 'mailing/detail', 'CRM_Report_Form_Mailing_Detail', NULL, 0, 0, 47, '{ts escape="sql"}Provides reporting on Intended and Successful Deliveries, Unsubscribes and Opt-outs, Replies and Forwards.{/ts}', 0, 0, 1, @mailCompId, NULL, NULL), - (@option_group_id_report, '{ts escape="sql"}Contribution and Membership Details{/ts}', 'member/contributionDetail', 'CRM_Report_Form_Member_ContributionDetail', NULL, 0, 0, 48, '{ts escape="sql"}Contribution details for any type of contribution, plus associated membership information for contributions which are in payment for memberships.{/ts}', 0, 0, 1, @memberCompId, NULL, NULL), - (@option_group_id_report, '{ts escape="sql"}Recurring Contributions Report{/ts}', 'contribute/recur', 'CRM_Report_Form_Contribute_Recur', NULL, 0, 0, 49, '{ts escape="sql"}Provides information about the status of recurring contributions{/ts}', 0, 0, 1, @contributeCompId, NULL, NULL), - (@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), - --- custom data types. - (@option_group_id_cdt, '{ts escape="sql"}Participants (Role){/ts}', '1', 'ParticipantRole', 'role_id', 0, 0, 1, NULL, 0, 0, 1, NULL, NULL , NULL), - (@option_group_id_cdt, '{ts escape="sql"}Participants (Event Name){/ts}', '2', 'ParticipantEventName', 'event_id', 0, 0, 2, NULL, 0, 0, 1, NULL, NULL , NULL), - (@option_group_id_cdt, '{ts escape="sql"}Participants (Event Type){/ts}', '3', 'ParticipantEventType', 'event_id.event_type_id', 0, 0, 3, NULL, 0, 0, 1, NULL, NULL , NULL), - --- visibility. - (@option_group_id_vis, 'Public', 1, 'public', NULL, 0, 0, 1, NULL, 0, 0, 1, NULL, NULL , NULL), - (@option_group_id_vis, 'Admin', 2, 'admin', NULL, 0, 0, 2, NULL, 0, 0, 1, NULL, NULL , NULL), - --- mail protocol. - (@option_group_id_mp, 'IMAP', 1, 'IMAP', NULL, 0, 0, 1, NULL, 0, 0, 1, NULL, NULL , NULL), - (@option_group_id_mp, 'Maildir', 2, 'Maildir', NULL, 0, 0, 2, NULL, 0, 0, 1, NULL, NULL , NULL), - (@option_group_id_mp, 'POP3', 3, 'POP3', NULL, 0, 0, 3, NULL, 0, 0, 1, NULL, NULL , NULL), - (@option_group_id_mp, 'Localdir', 4, 'Localdir', NULL, 0, 0, 4, NULL, 0, 0, 1, NULL, NULL , NULL), - --- priority - (@option_group_id_priority, '{ts escape="sql"}Urgent{/ts}', 1, 'Urgent', NULL, 0, 0, 1, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_priority, '{ts escape="sql"}Normal{/ts}', 2, 'Normal', NULL, 0, 0, 2, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_priority, '{ts escape="sql"}Low{/ts}', 3, 'Low', NULL, 0, 0, 3, NULL, 0, 0, 1, NULL, NULL, NULL), - --- redaction rule FIXME: should this be in sample data instead? - (@option_group_id_rr, 'Vancouver', 'city_', 'city_', NULL, 0, 0, 1, NULL, 0, 0, 0, NULL, NULL, NULL), - (@option_group_id_rr, '{literal}/(19|20)(\\d{2})-(\\d{1,2})-(\\d{1,2})/{/literal}', 'date_', 'date_', NULL, 1, 0, 2, NULL, 0, 0, 0, NULL, NULL, NULL), - --- email greeting. - (@option_group_id_emailGreeting, '{literal}Dear {contact.first_name}{/literal}', 1, '{literal}Dear {contact.first_name}{/literal}', NULL, 1, 1, 1, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_emailGreeting, '{literal}Dear {contact.prefix_id:label} {contact.first_name} {contact.last_name}{/literal}', 2, '{literal}Dear {contact.prefix_id:label} {contact.first_name} {contact.last_name}{/literal}', NULL, 1, 0, 2, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_emailGreeting, '{literal}Dear {contact.prefix_id:label} {contact.last_name}{/literal}', 3, '{literal}Dear {contact.prefix_id:label} {contact.last_name}{/literal}', NULL, 1, 0, 3, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_emailGreeting, '{literal}Customized{/literal}', 4, '{literal}Customized{/literal}', NULL, 0, 0, 4, NULL, 0, 1, 1, NULL, NULL, NULL), - (@option_group_id_emailGreeting, '{literal}Dear {contact.household_name}{/literal}', 5, '{literal}Dear {contact.household_name}{/literal}', NULL, 2, 1, 5, NULL, 0, 0, 1, NULL, NULL, NULL), --- postal greeting. - (@option_group_id_postalGreeting, '{literal}Dear {contact.first_name}{/literal}', 1, '{literal}Dear {contact.first_name}{/literal}', NULL, 1, 1, 1, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_postalGreeting, '{literal}Dear {contact.prefix_id:label} {contact.first_name} {contact.last_name}{/literal}', 2, '{literal}Dear {contact.prefix_id:label} {contact.first_name} {contact.last_name}{/literal}', NULL, 1, 0, 2, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_postalGreeting, '{literal}Dear {contact.prefix_id:label} {contact.last_name}{/literal}', 3, '{literal}Dear {contact.prefix_id:label} {contact.last_name}{/literal}', NULL, 1, 0, 3, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_postalGreeting, '{literal}Customized{/literal}', 4, '{literal}Customized{/literal}', NULL, 0, 0, 4, NULL, 0, 1, 1, NULL, NULL, NULL), - (@option_group_id_postalGreeting, '{literal}Dear {contact.household_name}{/literal}', 5, '{literal}Dear {contact.household_name}{/literal}', NULL, 2, 1, 5, NULL, 0, 0, 1, NULL, NULL, NULL), - --- addressee - (@option_group_id_addressee, '{literal}{contact.prefix_id:label}{ }{contact.first_name}{ }{contact.middle_name}{ }{contact.last_name}{ }{contact.suffix_id:label}{/literal}', '1', '{literal}{contact.prefix_id:label}{ }{contact.first_name}{ }{contact.middle_name}{ }{contact.last_name}{ }{contact.suffix_id:label}{/literal}', NULL , '1', '1', '1', NULL , '0', '0', '1', NULL , NULL, NULL), - (@option_group_id_addressee, '{literal}{contact.household_name}{/literal}', '2', '{literal}{contact.household_name}{/literal}', NULL , '2', '1', '2', NULL , '0', '0', '1', NULL , NULL, NULL), - (@option_group_id_addressee, '{literal}{contact.organization_name}{/literal}', '3', '{literal}{contact.organization_name}{/literal}', NULL , '3', '1', '3', NULL , '0', '0', '1', NULL , NULL, NULL), - (@option_group_id_addressee, '{literal}Customized{/literal}', '4', '{literal}Customized{/literal}', NULL , 0 , '0', '4', NULL , '0', '1', '1', NULL , NULL, NULL), - --- website type - (@option_group_id_website, 'Work', 1, 'Work', NULL, 0, 1, 1, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_website, 'Main', 2, 'Main', NULL, 0, 0, 2, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_website, 'Facebook', 3, 'Facebook', NULL, 0, 0, 3, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_website, 'Instagram', 5, 'Instagram', NULL, 0, 0, 5, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_website, 'LinkedIn', 6, 'LinkedIn', NULL, 0, 0, 6, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_website, 'MySpace', 7, 'MySpace', NULL, 0, 0, 7, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_website, 'Pinterest', 8, 'Pinterest', NULL, 0, 0, 8, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_website, 'SnapChat', 9, 'SnapChat', NULL, 0, 0, 9, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_website, 'Tumblr', 10, 'Tumblr', NULL, 0, 0, 10, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_website, 'Twitter', 11, 'Twitter', NULL, 0, 0, 11, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_website, 'Vine', 12, 'Vine ', NULL, 0, 0, 12, NULL, 0, 0, 1, NULL, NULL, NULL), - --- Tag used for - (@option_group_id_tuf, '{ts escape="sql"}Contacts{/ts}', 'civicrm_contact', 'Contact', NULL, 0, 0, 1, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_tuf, '{ts escape="sql"}Activities{/ts}', 'civicrm_activity', 'Activity', NULL, 0, 0, 2, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_tuf, '{ts escape="sql"}Cases{/ts}', 'civicrm_case', 'Case', NULL, 0, 0, 3, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_tuf, '{ts escape="sql"}Attachments{/ts}', 'civicrm_file', 'File', NULL, 0, 0, 4, NULL, 0, 0, 1, NULL, NULL, NULL), - --- Note used for - (@option_group_id_nuf, '{ts escape="sql"}Contacts{/ts}', 'civicrm_contact', 'Contact', NULL, 0, 0, 1, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_nuf, '{ts escape="sql"}Relationships{/ts}', 'civicrm_relationship', 'Relationship', NULL, 0, 0, 2, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_nuf, '{ts escape="sql"}Participants{/ts}', 'civicrm_participant', 'Participant', NULL, 0, 0, 3, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_nuf, '{ts escape="sql"}Contributions{/ts}', 'civicrm_contribution', 'Contribution', NULL, 0, 0, 4, NULL, 0, 0, 1, NULL, NULL, NULL), - -- Available currencies. (@option_group_id_currency, 'USD ($)', 'USD', 'USD', NULL, 0, 1, 1, NULL, 0, 0, 1, NULL, NULL, NULL), (@option_group_id_currency, 'CAD ($)', 'CAD', 'CAD', NULL, 0, 0, 2, NULL, 0, 0, 1, NULL, NULL, NULL), -- 2.25.1