Commit | Line | Data |
---|---|---|
6a488035 TO |
1 | -- CRM-7494 |
2 | -- update navigation. | |
3 | ||
10824d34 | 4 | UPDATE civicrm_navigation |
6a488035 TO |
5 | SET name = 'Survey Report (Detail)', |
6 | label = 'Survey Report (Detail)' | |
7 | WHERE name LIKE 'Walk List Survey Report'; | |
8 | ||
9 | -- update report instance. | |
10 | ||
10824d34 | 11 | UPDATE civicrm_report_instance |
6a488035 TO |
12 | SET title = 'Survey Report (Detail)', |
13 | description = 'Detailed report for canvassing, phone-banking, walk lists or other surveys.' | |
14 | WHERE report_id LIKE 'survey/detail'; | |
15 | ||
16 | -- update report template option values. | |
17 | {if $multilingual} | |
18 | ||
19 | {foreach from=$locales item=loc} | |
20 | ||
21 | UPDATE civicrm_option_value val | |
22 | INNER JOIN civicrm_option_group grp ON ( grp.id = val.option_group_id ) | |
23 | SET val.label_{$loc} = '{ts escape="sql"}Survey Report (Detail){/ts}', | |
24 | val.description_{$loc} = '{ts escape="sql"}Detailed report for canvassing, phone-banking, walk lists or other surveys.{/ts}' | |
10824d34 | 25 | WHERE val.name = 'CRM_Report_Form_Campaign_SurveyDetails' |
6a488035 TO |
26 | AND grp.name = 'report_template'; |
27 | ||
28 | {/foreach} | |
29 | ||
30 | {else} | |
31 | ||
32 | UPDATE civicrm_option_value val | |
33 | INNER JOIN civicrm_option_group grp ON ( grp.id = val.option_group_id ) | |
34 | SET val.label = '{ts escape="sql"}Survey Report (Detail){/ts}', | |
35 | val.description = '{ts escape="sql"}Detailed report for canvassing, phone-banking, walk lists or other surveys.{/ts}' | |
10824d34 | 36 | WHERE val.name = 'CRM_Report_Form_Campaign_SurveyDetails' |
6a488035 TO |
37 | AND grp.name = 'report_template'; |
38 | ||
39 | {/if} | |
40 | ||
41 | -- get rid of standalone tables CRM-7672 | |
42 | DROP TABLE IF EXISTS civicrm_openid_associations; | |
43 | DROP TABLE IF EXISTS civicrm_openid_nonces; | |
44 | ||
45 | -- insert 5395 Logo style event name badge CRM-7695 | |
46 | SELECT @option_group_id_eventBadge := max(id) from civicrm_option_group where name = 'event_badge'; | |
47 | {if $multilingual} | |
48 | INSERT INTO civicrm_option_value | |
10824d34 | 49 | (option_group_id, {foreach from=$locales item=locale}label_{$locale}, description_{$locale}, {/foreach} value, name, weight, is_active, component_id ) |
6a488035 TO |
50 | VALUES |
51 | (@option_group_id_eventBadge , {foreach from=$locales item=locale}'5395 with Logo', 'Avery 5395 compatible labels with logo (4 up by 2, 59.2mm x 85.7mm)', {/foreach} '4', 'CRM_Event_Badge_Logo5395', 1, 1, NULL ); | |
52 | {else} | |
53 | INSERT INTO civicrm_option_value | |
10824d34 | 54 | (option_group_id, label, description, value, name, weight, is_active, component_id ) |
6a488035 TO |
55 | VALUES |
56 | (@option_group_id_eventBadge , '{ts escape="sql"}5395 with Logo{/ts}', '{ts escape="sql"}Avery 5395 compatible labels with logo (4 up by 2, 59.2mm x 85.7mm){/ts}', '4', 'CRM_Event_Badge_Logo5395', 1, 1, NULL ); | |
57 | {/if} |