Commit | Line | Data |
---|---|---|
6a488035 TO |
1 | -- CRM-4104 |
2 | SELECT @og_id_cs := id FROM civicrm_option_group WHERE name = 'custom_search'; | |
3 | SELECT @maxValue := max(CAST( `value` AS UNSIGNED )) FROM civicrm_option_value WHERE option_group_id = @og_id_cs; | |
4 | {if $customSearchAbsentAll} | |
5 | {if $multilingual} | |
6 | INSERT INTO civicrm_option_value | |
10824d34 | 7 | (option_group_id, {foreach from=$locales item=locale}label_{$locale}, description_{$locale}, {/foreach} value, name, weight, is_active) VALUES |
8 | (@og_id_cs, {foreach from=$locales item=locale}'CRM_Contact_Form_Search_Custom_ZipCodeRange', 'Zip Code Range', {/foreach} @maxValue + 1, 'CRM_Contact_Form_Search_Custom_ZipCodeRange', @maxValue + 1, 1), | |
9 | (@og_id_cs, {foreach from=$locales item=locale}'CRM_Contact_Form_Search_Custom_DateAdded', 'Date Added to CiviCRM', {/foreach} @maxValue + 2, 'CRM_Contact_Form_Search_Custom_DateAdded', @maxValue + 2, 1), | |
10 | (@og_id_cs, {foreach from=$locales item=locale}'CRM_Contact_Form_Search_Custom_MultipleValues', 'Custom Group Multiple Values Listing', {/foreach} @maxValue + 3, 'CRM_Contact_Form_Search_Custom_MultipleValues', @maxValue + 3, 1), | |
6a488035 TO |
11 | (@og_id_cs, {foreach from=$locales item=locale}'CRM_Contact_Form_Search_Custom_ContribSYBNT', 'Contributions made in Year X and not Year Y', {/foreach} @maxValue + 4, 'CRM_Contact_Form_Search_Custom_ContribSYBNT', @maxValue + 4, 1); |
12 | {else} | |
10824d34 | 13 | INSERT INTO civicrm_option_value |
14 | (option_group_id, label, value, name, description, weight, is_active ) VALUES | |
15 | (@og_id_cs, 'CRM_Contact_Form_Search_Custom_ZipCodeRange', @maxValue + 1, 'CRM_Contact_Form_Search_Custom_ZipCodeRange', 'Zip Code Range', @maxValue + 1, 1), | |
6a488035 TO |
16 | (@og_id_cs, 'CRM_Contact_Form_Search_Custom_DateAdded', @maxValue + 2, 'CRM_Contact_Form_Search_Custom_DateAdded', 'Date Added to CiviCRM', @maxValue + 2, 1), |
17 | (@og_id_cs, 'CRM_Contact_Form_Search_Custom_MultipleValues', @maxValue + 3, 'CRM_Contact_Form_Search_Custom_MultipleValues', 'Custom Group Multiple Values Listing', @maxValue + 3, 1), | |
18 | (@og_id_cs, 'CRM_Contact_Form_Search_Custom_ContribSYBNT', @maxValue + 4, 'CRM_Contact_Form_Search_Custom_ContribSYBNT', 'Contributions made in Year X and not Year Y', @maxValue + 4, 1); | |
19 | {/if} | |
20 | {else if $customSearchAbsent} | |
21 | {if $multilingual} | |
22 | INSERT INTO civicrm_option_value | |
23 | (option_group_id, {foreach from=$locales item=locale}label_{$locale}, description_{$locale}, {/foreach} value, name, weight, is_active) VALUES | |
24 | (@og_id_cs, {foreach from=$locales item=locale}'CRM_Contact_Form_Search_Custom_MultipleValues', 'Custom Group Multiple Values Listing', {/foreach} @maxValue + 1, 'CRM_Contact_Form_Search_Custom_MultipleValues', @maxValue + 1, 1), | |
25 | (@og_id_cs, {foreach from=$locales item=locale}'CRM_Contact_Form_Search_Custom_ContribSYBNT', 'Contributions made in Year X and not Year Y', {/foreach} @maxValue + 2, 'CRM_Contact_Form_Search_Custom_ContribSYBNT', @maxValue + 2, 1); | |
26 | {else} | |
27 | INSERT INTO civicrm_option_value | |
10824d34 | 28 | (option_group_id, label, value, name, description, weight, is_active ) VALUES |
29 | (@og_id_cs, 'CRM_Contact_Form_Search_Custom_MultipleValues', @maxValue + 1, 'CRM_Contact_Form_Search_Custom_MultipleValues', 'Custom Group Multiple Values Listing', @maxValue + 1, 1), | |
6a488035 TO |
30 | (@og_id_cs, 'CRM_Contact_Form_Search_Custom_ContribSYBNT', @maxValue + 2, 'CRM_Contact_Form_Search_Custom_ContribSYBNT', 'Contributions made in Year X and not Year Y', @maxValue + 2, 1); |
31 | {/if} | |
32 | {/if} | |
33 | ||
34 | -- Added dummy processor | |
35 | INSERT IGNORE INTO `civicrm_payment_processor_type` | |
36 | (`name`, `title`, `is_active`, `is_default`, `user_name_label`, `class_name`, `billing_mode`) VALUES | |
37 | ('Dummy', 'Dummy Payment Processor', 1, 1, 'User Name', 'Payment_Dummy', 1 ); |