Commit | Line | Data |
---|---|---|
6a488035 TO |
1 | -- db template customization |
2 | ||
3 | CREATE TABLE IF NOT EXISTS civicrm_persistent ( | |
4 | id int(10) unsigned NOT NULL auto_increment COMMENT 'Persistent Record Id', | |
5 | context varchar(255) collate utf8_unicode_ci NOT NULL COMMENT 'Context for which name data pair is to be stored', | |
6 | name varchar(255) collate utf8_unicode_ci NOT NULL COMMENT 'Name of Context', | |
7 | data longtext collate utf8_unicode_ci COMMENT 'data associated with name', | |
8 | is_config tinyint(4) NOT NULL default '0' COMMENT 'Config Settings', | |
9 | PRIMARY KEY (id) | |
10 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4; | |
11 | ||
12 | --CRM-6655 | |
13 | SELECT @domainID := min(id) FROM civicrm_domain; | |
14 | SELECT @reportlastID := id FROM civicrm_navigation where name = 'Reports'; | |
15 | SELECT @ogrID := max(id) from civicrm_option_group where name = 'report_template'; | |
16 | SELECT @nav_max_weight := MAX(ROUND(weight)) from civicrm_navigation WHERE parent_id = @reportlastID; | |
17 | SELECT @grantCompId := max(id) FROM civicrm_component where name = 'CiviGrant'; | |
18 | SELECT @eventCompId := max(id) FROM civicrm_component where name = 'CiviEvent'; | |
19 | SELECT @max_weight := MAX(ROUND(weight)) from civicrm_option_value WHERE option_group_id = @ogrID; | |
20 | ||
21 | INSERT INTO civicrm_option_value | |
10824d34 | 22 | (option_group_id, {localize field='label'}label{/localize}, value, name, grouping, filter, is_default, weight,{localize field='description'} description{/localize}, is_optgroup,is_reserved, is_active, component_id, visibility_id ) |
6a488035 TO |
23 | VALUES |
24 | (@ogrID , {localize}'{ts escape="sql"}Grant Report{/ts}'{/localize}, 'grant', 'CRM_Report_Form_Grant', NULL, 0, 0, @max_weight+1, {localize}'{ts escape="sql"}Grant Report{/ts}'{/localize}, 0, 0, 1, @grantCompId, NULL), | |
25 | (@ogrID, {localize}'{ts escape="sql"}Participant list Count Report{/ts}'{/localize}, 'event/participantlist', 'CRM_Report_Form_Event_ParticipantListCount', NULL, 0, 0, @max_weight+2, {localize}'{ts escape="sql"}Shows the Participant list with Participant Count.{/ts}'{/localize}, 0, 0, 1, @eventCompId, NULL), | |
26 | (@ogrID, {localize}'{ts escape="sql"}Income Count Summary Report{/ts}'{/localize}, 'event/incomesummary', 'CRM_Report_Form_Event_IncomeCountSummary', NULL, 0, 0, @max_weight+3, {localize}'{ts escape="sql"}Shows the Income Summary of events with Count.{/ts}'{/localize}, 0, 0, 1, @eventCompId, NULL); | |
10824d34 | 27 | |
6a488035 TO |
28 | INSERT INTO `civicrm_report_instance` |
29 | ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`) | |
10824d34 | 30 | VALUES |
6a488035 TO |
31 | ( @domainID, 'Grant Report', 'grant', 'Grant Report', 'access CiviGrant', '{literal}a:30:{s:6:"fields";a:2:{s:12:"display_name";s:1:"1";s:25:"application_received_date";s:1:"1";}s:15:"display_name_op";s:3:"has";s:18:"display_name_value";s:0:"";s:13:"grant_type_op";s:2:"in";s:16:"grant_type_value";a:0:{}s:15:"grant_status_op";s:2:"in";s:18:"grant_status_value";a:0:{}s:18:"amount_granted_min";s:0:"";s:18:"amount_granted_max";s:0:"";s:17:"amount_granted_op";s:3:"lte";s:20:"amount_granted_value";s:0:"";s:20:"amount_requested_min";s:0:"";s:20:"amount_requested_max";s:0:"";s:19:"amount_requested_op";s:3:"lte";s:22:"amount_requested_value";s:0:"";s:34:"application_received_date_relative";s:1:"0";s:30:"application_received_date_from";s:0:"";s:28:"application_received_date_to";s:0:"";s:28:"money_transfer_date_relative";s:1:"0";s:24:"money_transfer_date_from";s:0:"";s:22:"money_transfer_date_to";s:0:"";s:23:"grant_due_date_relative";s:1:"0";s:19:"grant_due_date_from";s:0:"";s:17:"grant_due_date_to";s:0:"";s:11:"description";s:12:"Grant Report";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:16:"access CiviGrant";s:9:"domain_id";i:1;}{/literal}'); |
32 | ||
33 | SET @instanceID:=LAST_INSERT_ID(); | |
34 | INSERT INTO civicrm_navigation | |
35 | ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight ) | |
36 | VALUES | |
37 | ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), '{ts escape="sql"}Grant Report{/ts}', '{literal}Grant Report{/literal}', 'access CiviGrant', '',@reportlastID, '1', NULL, @nav_max_weight+1 ); | |
38 | ||
39 | UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID; |