projects / civicrm-core.git / blob
? search:
summary | shortlog | log | commit | commitdiff | tree
blame | history | raw | HEAD
Upgrade changes
[civicrm-core.git] / sql / test_data_second_domain.mysql
1 SET @domainName := 'Second Domain';
2 INSERT INTO civicrm_contact(sort_name, display_name, contact_type, organization_name)
3 VALUES (@domainName, @domainName, 'Organization', @domainName);
4 SET @contactID:=LAST_INSERT_ID();
5 INSERT INTO civicrm_address ( contact_id, location_type_id, is_primary, is_billing, street_address, street_number, street_number_suffix, street_number_predirectional, street_name, street_type, street_number_postdirectional, street_unit, supplemental_address_1, supplemental_address_2, supplemental_address_3, city, county_id, state_province_id, postal_code_suffix, postal_code, usps_adc, country_id, geo_code_1, geo_code_2, timezone)
6 VALUES
7 ( @contactID, 1, 1, 1, '15 Main St', 15, 'S', NULL, 'Main', 'St', NULL, NULL, NULL, NULL, NULL, 'Collinsville', NULL, 1006, NULL, '6022', NULL, 1228, 41.8328, -72.9253, NULL);
8
9 SELECT @addId := id from civicrm_address where street_address = '15 Main St';
10
11 INSERT INTO civicrm_email (contact_id, location_type_id, email, is_primary, is_billing, on_hold, hold_date, reset_date)
12 VALUES
13 (@contactID, 1, '"Domain Email" <domainemail2@example.org>', 0, 0, 0, NULL, NULL);
14
15 SELECT @emailId := id from civicrm_email where email = 'domainemail2@example.org';
16
17 INSERT INTO civicrm_phone (contact_id, location_type_id, is_primary, is_billing, mobile_provider_id, phone, phone_type_id)
18 VALUES
19 (@contactID, 1, 0, 0, NULL,'204 555-1001', 1);
20
21 SELECT @phoneId := id from civicrm_phone where phone = '204 555-1001';
22
23 INSERT INTO civicrm_loc_block ( address_id, email_id, phone_id, address_2_id, email_2_id, phone_2_id)
24 VALUES
25 ( @addId, @emailId, @phoneId, NULL,NULL,NULL);
26
27 SELECT @locBlockId := id from civicrm_loc_block where phone_id = @phoneId AND email_id = @emailId AND address_id = @addId;
28
29 INSERT INTO civicrm_domain
30 (name, version,contact_id) VALUES (@domainName, '4.2', @contactID);
31 SELECT @domainID := id FROM civicrm_domain where name = 'Second Domain';
32 INSERT INTO
33 `civicrm_option_value` (`option_group_id`, `label`, `value`, `name`, `grouping`, `filter`, `is_default`, `weight`, `description`, `is_optgroup`, `is_reserved`, `is_active`, `component_id`, `domain_id`, `visibility_id`)
34 VALUES
35 -- from email address.
36 (@option_group_id_fma, '"FIXME" <info@EXAMPLE.ORG>', '1', '"FIXME" <info@EXAMPLE.ORG>', NULL, 0, 1, 1, 'Default domain email address and from name.', 0, 0, 1, NULL, @domainID, NULL ),
37
38 -- grant types
39 (@option_group_id_grantTyp, 'Emergency' , 1, 'Emergency' , NULL, 0, 1, 1, NULL, 0, 0, 1, NULL, @domainID, NULL),
40 (@option_group_id_grantTyp, 'Family Support' , 2, 'Family Support' , NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL, @domainID, NULL),
41 (@option_group_id_grantTyp, 'General Protection' , 3, 'General Protection', NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL, @domainID, NULL),
42 (@option_group_id_grantTyp, 'Impunity' , 4, 'Impunity' , NULL, 0, NULL, 4, NULL, 0, 0, 1, NULL, @domainID, NULL),
43
44 -- Mail Approval Status Preferences
45 (@option_group_id_mail_approval_status, 'Approved' , 1, 'Approved', NULL, 0, 1, 1, NULL, 0, 1, 1, @mailCompId, @domainID, NULL),
46 (@option_group_id_mail_approval_status, 'Rejected' , 2, 'Rejected', NULL, 0, 0, 2, NULL, 0, 1, 1, @mailCompId, @domainID, NULL),
47 (@option_group_id_mail_approval_status, 'None' , 3, 'None', NULL, 0, 0, 3, NULL, 0, 1, 1, @mailCompId, @domainID, NULL);
48 INSERT INTO `civicrm_job`
49 ( domain_id, run_frequency, last_run, name, description, api_entity, api_action, parameters, is_active )
50 VALUES
51 ( @domainID, 'Always' , NULL, 'Send Scheduled Mailings', 'Sends out scheduled CiviMail mailings', 'job', 'process_mailing', NULL, 0),
52 ( @domainID, 'Hourly' , NULL, 'Fetch Bounces', 'Fetches bounces from mailings and writes them to mailing statistics', 'job', 'fetch_bounces', NULL, 0),
53 ( @domainID, 'Hourly' , NULL, 'Process Inbound Emails', 'Inserts activity for a contact or a case by retrieving inbound emails from a mail directory', 'job', 'fetch_activities', NULL, 0),
54 ( @domainID, 'Daily' , NULL, 'Process Pledges', 'Updates pledge records and sends out reminders', 'job', 'process_pledge','send_reminders=[1 or 0] optional- 1 to send payment reminders', 0),
55 ( @domainID, 'Daily' , NULL, 'Geocode and Parse Addresses', 'Retrieves geocodes (lat and long) and / or parses street addresses (populates street number, street name, etc.)', 'job', 'geocode', 'geocoding=[1 or 0] required\nparse=[1 or 0] required\nstart=[contact ID] optional-begin with this contact ID\nend=[contact ID] optional-process contacts with IDs less than this\nthrottle=[1 or 0] optional-1 adds five second sleep', 0),
56 ( @domainID, 'Daily' , NULL, 'Update Greetings and Addressees','Goes through contact records and updates email and postal greetings, or addressee value', 'job', 'update_greeting','ct=[Individual or Household or Organization] required\ngt=[email_greeting or postal_greeting or addressee] required\nforce=[0 or 1] optional-0 update contacts with null value, 1 update all', 0),
57 ( @domainID, 'Daily' , NULL, 'Mail Reports', 'Generates and sends out reports via email', 'job', 'mail_report','instanceId=[ID of report instance] required\nformat=[csv or print] optional-output CSV or print-friendly HTML, else PDF', 0),
58 ( @domainID, 'Daily' , NULL, 'Send Scheduled Reminders', 'Sends out scheduled reminders via email', 'job', 'send_reminder', NULL, 0),
59 ( @domainID, 'Always' , NULL, 'Update Participant Statuses', 'Updates pending event participant statuses based on time', 'job', 'process_participant', NULL, 0),
60 ( @domainID, 'Daily' , NULL, 'Update Membership Statuses', 'Updates membership statuses. WARNING: Membership renewal reminders have been migrated to the Schedule Reminders functionality, which supports multiple renewal reminders.', 'job', 'process_membership', NULL, 0),
61 ( @domainID, 'Always' , NULL, 'Process Survey Respondents', 'Releases reserved survey respondents when they have been reserved for longer than the Release Frequency days specified for that survey.', 'job', 'process_respondent',NULL, 0),
62 ( @domainID, 'Hourly' , NULL, 'Clean-up Temporary Data and Files','Removes temporary data and files, and clears old data from cache tables. Recommend running this job every hour to help prevent database and file system bloat.', 'job', 'cleanup', NULL, 0);
63 -- Initial default state of system settings
64 INSERT INTO civicrm_setting
65 ( domain_id, contact_id, is_domain, group_name, name, value )
66 VALUES
67 ( @domainID, NULL, 1, 'CiviCRM Preferences', 'contact_view_options', 's:28:"\ 11\ 12\ 13\ 14\ 15\ 16\ 17\ 18\ 19\ 110\ 111\ 113\ 1";' ),
68 ( @domainID, NULL, 1, 'CiviCRM Preferences', 'contact_edit_options', 's:22:"\ 11\ 12\ 13\ 14\ 15\ 16\ 17\ 18\ 19\ 111\ 1";' ),
69 ( @domainID, NULL, 1, 'CiviCRM Preferences', 'advanced_search_options', 's:46:"\ 11\ 12\ 13\ 14\ 15\ 16\ 17\ 18\ 19\ 110\ 111\ 112\ 113\ 115\ 116\ 117\ 118\ 119\ 1";' ),
70 ( @domainID, NULL, 1, 'CiviCRM Preferences', 'user_dashboard_options', 's:15:"\ 11\ 12\ 13\ 14\ 15\ 17\ 18\ 1";' ),
71 ( @domainID, NULL, 1, 'CiviCRM Preferences', 'address_options', 's:23:"\ 11\ 12\ 13\ 14\ 15\ 16\ 18\ 19\ 110\ 111\ 1";' ),
72 ( @domainID, NULL, 1, 'CiviCRM Preferences', 'address_format', 's:198:"{contact.address_name}
73 {contact.street_address}
74 {contact.supplemental_address_1}
75 {contact.supplemental_address_2}
76 {contact.city}{, }{contact.state_province}{ }{contact.postal_code}
77 {contact.country}";' ),
78 ( @domainID, NULL, 1, 'CiviCRM Preferences', 'mailing_format', 's:195:"{contact.addressee}
79 {contact.street_address}
80 {contact.supplemental_address_1}
81 {contact.supplemental_address_2}
82 {contact.city}{, }{contact.state_province}{ }{contact.postal_code}
83 {contact.country}";' ),
84 ( @domainID, NULL, 1, 'CiviCRM Preferences', 'display_name_format', 's:102:"{contact.individual_prefix}{ }{contact.first_name}{ }{contact.last_name}{ }{contact.individual_suffix}";' ),
85 ( @domainID, NULL, 1, 'CiviCRM Preferences', 'sort_name_format', 's:43:"{contact.last_name}{, }{contact.first_name}";' ),
86 ( @domainID, NULL, 1, 'CiviCRM Preferences', 'editor_id', 's:1:"2";' ),
87 ( @domainID, NULL, 1, 'CiviCRM Preferences', 'contact_ajax_check_similar', 's:1:"1";' ),
88 ( @domainID, NULL, 1, 'CiviCRM Preferences', 'activity_assignee_notification', 's:1:"1";' ),
89 ( @domainID, NULL, 1, 'CiviCRM Preferences', 'contact_autocomplete_options', 's:5:"\ 11\ 12\ 1";' ),
90 ( @domainID, NULL, 1, 'CiviCRM Preferences', 'contact_reference_options', 's:5:"\ 11\ 12\ 1";' ),
91 ( @domainID, NULL, 1, 'Address Standardization Preferences', 'address_standardization_provider', NULL ),
92 ( @domainID, NULL, 1, 'Address Standardization Preferences', 'address_standardization_userid', NULL ),
93 ( @domainID, NULL, 1, 'Address Standardization Preferences', 'address_standardization_url', NULL ),
94 ( @domainID, NULL, 1, 'Campaign Preferences', 'tag_unconfirmed', 's:11:"Unconfirmed";' ),
95 ( @domainID, NULL, 1, 'Campaign Preferences', 'petition_contacts', 's:17:"Petition Contacts";' ),
96 ( @domainID, NULL, 1, 'Event Preferences' , 'enable_cart', 's:1:"0";' ),
97 ( @domainID, NULL, 1, 'Mailing Preferences', 'profile_double_optin', 's:1:"1";' ),
98 ( @domainID, NULL, 1, 'Mailing Preferences', 'profile_add_to_group_double_optin', 's:1:"0";' ),
99 ( @domainID, NULL, 1, 'Mailing Preferences', 'track_civimail_replies', 's:1:"0";' ),
100 ( @domainID, NULL, 1, 'Mailing Preferences', 'civimail_workflow', 's:1:"0";' ),
101 ( @domainID, NULL, 1, 'Mailing Preferences', 'civimail_server_wide_lock', 's:1:"0";' ),
102 ( @domainID, NULL, 1, 'Mailing Preferences', 'mailing_backend', 'a:1:{s:15:"outBound_option";s:1:"3";}' ),
103 ( @domainID, NULL, 1, 'Member Preferences' , 'default_renewal_contribution_page', NULL ),
104 ( @domainID, NULL, 1, 'Multi Site Preferences', 'is_enabled', 's:1:"0";' ),
105 ( @domainID, NULL, 1, 'Multi Site Preferences', 'uniq_email_per_site', 's:1:"0";' ),
106 ( @domainID, NULL, 1, 'Multi Site Preferences', 'domain_group_id', 's:1:"0";' ),
107 ( @domainID, NULL, 1, 'Multi Site Preferences', 'event_price_set_domain_id', 's:1:"0";' ),
108 ( @domainID, NULL, 1, 'Directory Preferences', 'uploadDir' , NULL ),
109 ( @domainID, NULL, 1, 'Directory Preferences', 'imageUploadDir' , NULL ),
110 ( @domainID, NULL, 1, 'Directory Preferences', 'customFileUploadDir', NULL ),
111 ( @domainID, NULL, 1, 'Directory Preferences', 'customTemplateDir' , NULL ),
112 ( @domainID, NULL, 1, 'Directory Preferences', 'customPHPPathDir' , NULL ),
113 ( @domainID, NULL, 1, 'Directory Preferences', 'extensionsDir' , NULL ),
114 ( @domainID, NULL, 1, 'URL Preferences', 'userFrameworkResourceURL' , NULL ),
115 ( @domainID, NULL, 1, 'URL Preferences', 'imageUploadURL' , NULL ),
116 ( @domainID, NULL, 1, 'URL Preferences', 'customCSSURL' , NULL ),
117 ( @domainID, NULL, 1, 'URL Preferences', 'extensionsURL' , NULL );
118
119 INSERT INTO `civicrm_dashboard`
120 ( `domain_id`, `label`, `url`, `permission`, `permission_operator`, `column_no`, `is_minimized`, `is_active`, `weight`, `fullscreen_url`, `is_fullscreen`, `is_reserved`)
121 VALUES
122 ( @domainID, 'Activities', 'civicrm/dashlet/activity&reset=1&snippet=5', 'access CiviCRM', NULL, 0, 0, 1, 1, 'civicrm/dashlet/activity&reset=1&snippet=5&context=dashletFullscreen', 1, 1),
123 ( @domainID, 'My Cases', 'civicrm/dashlet/myCases&reset=1&snippet=5', 'access my cases and activities', NULL , 0, 0, 1, 2, 'civicrm/dashlet/myCases&reset=1&snippet=5&context=dashletFullscreen', 1, 1),
124 ( @domainID, 'All Cases', 'civicrm/dashlet/allCases&reset=1&snippet=5', 'access all cases and activities', NULL , 0, 0, 1, 3, 'civicrm/dashlet/allCases&reset=1&snippet=5&context=dashletFullscreen', 1, 1),
125 ( @domainID, 'Case Dashboard Dashlet', 'civicrm/dashlet/casedashboard&reset=1&snippet=5', 'access my cases and activities,access all cases and activities', 'OR' , 0, 0, 1, 4, 'civicrm/dashlet/casedashboard&reset=1&snippet=5&context=dashletFullscreen', 1, 1);
126
127 -- navigation
128
129 INSERT INTO civicrm_navigation
130 ( domain_id, label, name, url, permission, permission_operator, parent_id, is_active, has_separator, weight )
131 VALUES
132 ( @domainID, 'Home', 'Home', 'civicrm/dashboard&reset=1', NULL, '', NULL, 1, NULL, 0);
133
134 INSERT INTO civicrm_navigation
135 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
136 VALUES
137 ( @domainID, NULL, 'Search', 'Search...', NULL, '', NULL, '1', NULL, 10 );
138
139 SET @searchlastID:=LAST_INSERT_ID();
140
141 INSERT INTO civicrm_navigation
142 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
143 VALUES
144 ( @domainID, 'civicrm/contact/search&reset=1', 'Find Contacts', 'Find Contacts', NULL, '', @searchlastID, '1', NULL, 1 ),
145 ( @domainID, 'civicrm/contact/search/advanced&reset=1', 'Advanced Search', 'Advanced Search', NULL, '', @searchlastID, '1', NULL, 2 ),
146 ( @domainID, 'civicrm/contact/search/custom&csid=15&reset=1', 'Full-text Search', 'Full-text Search', NULL, '', @searchlastID, '1', NULL, 3 ),
147 ( @domainID, 'civicrm/contact/search/builder&reset=1', 'Search Builder', 'Search Builder', NULL, '', @searchlastID, '1', '1', 4 ),
148 ( @domainID, 'civicrm/case/search&reset=1', 'Find Cases', 'Find Cases', 'access my cases and activities,access all cases and activities', 'OR', @searchlastID, '1', NULL, 5 ),
149 ( @domainID, 'civicrm/contribute/search&reset=1', 'Find Contributions', 'Find Contributions', 'access CiviContribute', '', @searchlastID, '1', NULL, 6 ),
150 ( @domainID, 'civicrm/mailing&reset=1', 'Find Mailings', 'Find Mailings', 'access CiviMail', '', @searchlastID, '1', NULL, 7 ),
151 ( @domainID, 'civicrm/member/search&reset=1', 'Find Memberships', 'Find Memberships', 'access CiviMember', '', @searchlastID, '1', NULL, 8 ),
152 ( @domainID, 'civicrm/event/search&reset=1', 'Find Participants', 'Find Participants', 'access CiviEvent', '', @searchlastID, '1', NULL, 9 ),
153 ( @domainID, 'civicrm/pledge/search&reset=1', 'Find Pledges', 'Find Pledges', 'access CiviPledge', '', @searchlastID, '1', NULL, 10 ),
154 ( @domainID, 'civicrm/activity/search&reset=1', 'Find Activities', 'Find Activities', NULL, '', @searchlastID, '1', '1', 11 );
155
156 INSERT INTO civicrm_navigation
157 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
158 VALUES
159 ( @domainID, 'civicrm/contact/search/custom/list&reset=1', 'Custom Searches', 'Custom Searches', NULL, '', @searchlastID, '1', NULL, 12 );
160
161 INSERT INTO civicrm_navigation
162 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
163 VALUES
164 ( @domainID, NULL, 'Contacts', 'Contacts', NULL, '', NULL, '1', NULL, 20 );
165
166 SET @contactlastID:=LAST_INSERT_ID();
167 INSERT INTO civicrm_navigation
168 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
169 VALUES
170 ( @domainID, 'civicrm/contact/add&reset=1&ct=Individual', 'New Individual', 'New Individual', 'add contacts', '', @contactlastID, '1', NULL, 1 ),
171 ( @domainID, 'civicrm/contact/add&reset=1&ct=Household', 'New Household', 'New Household', 'add contacts', '', @contactlastID, '1', NULL, 2 ),
172 ( @domainID, 'civicrm/contact/add&reset=1&ct=Organization', 'New Organization', 'New Organization', 'add contacts', '', @contactlastID, '1', 1, 3 );
173
174
175 INSERT INTO civicrm_navigation
176 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
177 VALUES
178 ( @domainID, 'civicrm/activity&reset=1&action=add&context=standalone', 'New Activity', 'New Activity', NULL, '', @contactlastID, '1', NULL, 4 ),
179 ( @domainID, 'civicrm/activity/email/add&atype=3&action=add&reset=1&context=standalone', 'New Email', 'New Email', NULL, '', @contactlastID, '1', '1', 5 ),
180 ( @domainID, 'civicrm/import/contact&reset=1', 'Import Contacts', 'Import Contacts', 'import contacts', '', @contactlastID, '1', NULL, 6 ),
181 ( @domainID, 'civicrm/import/activity&reset=1', 'Import Activities', 'Import Activities', 'import contacts', '', @contactlastID, '1', '1', 7 ),
182 ( @domainID, 'civicrm/group/add&reset=1', 'New Group', 'New Group', 'edit groups', '', @contactlastID, '1', NULL, 8 ),
183 ( @domainID, 'civicrm/group&reset=1', 'Manage Groups', 'Manage Groups', 'access CiviCRM', '', @contactlastID, '1', '1', 9 ),
184 ( @domainID, 'civicrm/admin/tag&reset=1&action=add', 'New Tag', 'New Tag', 'administer CiviCRM', '', @contactlastID, '1', NULL, 10 ),
185 ( @domainID, 'civicrm/admin/tag&reset=1', 'Manage Tags (Categories)', 'Manage Tags (Categories)', 'administer CiviCRM', '', @contactlastID, '1','1', 11 ),
186 ( @domainID, 'civicrm/contact/deduperules&reset=1', 'Find and Merge Duplicate Contacts', 'Find and Merge Duplicate Contacts', 'administer dedupe rules,merge duplicate contacts', 'OR', @contactlastID, '1', NULL, 12 );
187
188 INSERT INTO civicrm_navigation
189 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
190 VALUES
191 ( @domainID, NULL, 'Contributions', 'Contributions', 'access CiviContribute', '', NULL, '1', NULL, 30 );
192
193 SET @contributionlastID:=LAST_INSERT_ID();
194 INSERT INTO civicrm_navigation
195 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
196 VALUES
197 ( @domainID, 'civicrm/contribute&reset=1', 'Dashboard', 'Dashboard', 'access CiviContribute', '', @contributionlastID, '1', NULL, 1 ),
198 ( @domainID, 'civicrm/contribute/add&reset=1&action=add&context=standalone', 'New Contribution', 'New Contribution', 'access CiviContribute,edit contributions', 'AND', @contributionlastID, '1', NULL, 2 ),
199 ( @domainID, 'civicrm/contribute/search&reset=1', 'Find Contributions', 'Find Contributions', 'access CiviContribute', '', @contributionlastID, '1', NULL, 3 ),
200 ( @domainID, 'civicrm/batch&reset=1', 'Batches', 'Batches', 'access CiviContribute,access CiviMember', '', @contributionlastID, '1', NULL, 4 ),
201 ( @domainID, 'civicrm/contribute/import&reset=1', 'Import Contributions', 'Import Contributions', 'access CiviContribute,edit contributions', 'AND', @contributionlastID, '1', '1', 5 );
202
203 INSERT INTO civicrm_navigation
204 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
205 VALUES
206 ( @domainID,NULL, 'Pledges', 'Pledges', 'access CiviPledge', '', @contributionlastID, '1', 1, 5 );
207
208 SET @pledgelastID:=LAST_INSERT_ID();
209 INSERT INTO civicrm_navigation
210 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
211 VALUES
212 ( @domainID, 'civicrm/pledge&reset=1', 'Dashboard', 'Dashboard', 'access CiviPledge', '', @pledgelastID, '1', NULL, 1 ),
213 ( @domainID, 'civicrm/pledge/add&reset=1&action=add&context=standalone', 'New Pledge', 'New Pledge', 'access CiviPledge,edit pledges', 'AND', @pledgelastID, '1', NULL, 2 ),
214 ( @domainID, 'civicrm/pledge/search&reset=1', 'Find Pledges', 'Find Pledges', 'access CiviPledge', '', @pledgelastID, '1', NULL, 3 ),
215 ( @domainID, 'civicrm/admin/contribute/add&reset=1&action=add', 'New Contribution Page', 'New Contribution Page', 'access CiviContribute,administer CiviCRM', 'AND', @contributionlastID, '1', NULL, 6 ),
216 ( @domainID, 'civicrm/admin/contribute&reset=1', 'Manage Contribution Pages', 'Manage Contribution Pages', 'access CiviContribute,administer CiviCRM', 'AND', @contributionlastID, '1', '1', 7 ),
217 ( @domainID, 'civicrm/admin/pcp?reset=1&page_type=contribute', 'Personal Campaign Pages', 'Personal Campaign Pages', 'access CiviContribute,administer CiviCRM', 'AND', @contributionlastID, '1', NULL, 8 ),
218 ( @domainID, 'civicrm/admin/contribute/managePremiums&reset=1', 'Premiums (Thank-you Gifts)', 'Premiums', 'access CiviContribute,administer CiviCRM', 'AND', @contributionlastID, '1', 1, 9 ),
219 ( @domainID, 'civicrm/admin/price&reset=1&action=add', 'New Price Set', 'New Price Set', 'access CiviContribute,administer CiviCRM', 'AND', @contributionlastID, '1', NULL, 10 ),
220 ( @domainID, 'civicrm/admin/price&reset=1', 'Manage Price Sets', 'Manage Price Sets', 'access CiviContribute,administer CiviCRM', 'AND', @contributionlastID, '1', NULL, 11 );
221
222 INSERT INTO civicrm_navigation
223 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
224 VALUES
225 ( @domainID, NULL, 'Events', 'Events', 'access CiviEvent', '', NULL, '1', NULL, 40 );
226
227 SET @eventlastID:=LAST_INSERT_ID();
228 INSERT INTO civicrm_navigation
229 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
230 VALUES
231 ( @domainID, 'civicrm/event&reset=1', 'Dashboard', 'CiviEvent Dashboard', 'access CiviEvent', '', @eventlastID, '1', NULL, 1 ),
232 ( @domainID, 'civicrm/participant/add&reset=1&action=add&context=standalone', 'Register Event Participant', 'Register Event Participant', 'access CiviEvent,edit event participants', 'AND', @eventlastID, '1', NULL, 2 ),
233 ( @domainID, 'civicrm/event/search&reset=1', 'Find Participants', 'Find Participants', 'access CiviEvent', '', @eventlastID, '1', NULL, 3 ),
234 ( @domainID, 'civicrm/event/import&reset=1', 'Import Participants','Import Participants', 'access CiviEvent,edit event participants', 'AND', @eventlastID, '1', '1', 4 ),
235 ( @domainID, 'civicrm/event/add&reset=1&action=add', 'New Event', 'New Event', 'access CiviEvent,edit all events', 'AND', @eventlastID, '1', NULL, 5 ),
236 ( @domainID, 'civicrm/event/manage&reset=1', 'Manage Events', 'Manage Events', 'access CiviEvent,edit all events', 'AND', @eventlastID, '1', 1, 6 ),
237 ( @domainID, 'civicrm/admin/pcp?reset=1&page_type=event', 'Personal Campaign Pages', 'Personal Campaign Pages', 'access CiviEvent,administer CiviCRM', 'AND', @eventlastID, '1', 1, 7 ),
238 ( @domainID, 'civicrm/admin/eventTemplate&reset=1', 'Event Templates', 'Event Templates', 'access CiviEvent,edit all events', 'AND', @eventlastID, '1', 1, 8 ),
239 ( @domainID, 'civicrm/admin/price&reset=1&action=add', 'New Price Set', 'New Price Set', 'access CiviEvent,edit all events', 'AND', @eventlastID, '1', NULL, 9 ),
240 ( @domainID, 'civicrm/admin/price&reset=1', 'Manage Price Sets', 'Manage Price Sets', 'access CiviEvent,edit all events', 'AND', @eventlastID, '1', NULL, 10 );
241
242 INSERT INTO civicrm_navigation
243 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
244 VALUES
245 ( @domainID, NULL, 'Mailings', 'Mailings', 'access CiviMail,create mailings,approve mailings,schedule mailings', 'OR', NULL, '1', NULL, 50 );
246
247 SET @mailinglastID:=LAST_INSERT_ID();
248 INSERT INTO civicrm_navigation
249 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
250 VALUES
251 ( @domainID, 'civicrm/mailing/send&reset=1', 'New Mailing', 'New Mailing', 'access CiviMail,create mailings', 'OR', @mailinglastID, '1', NULL, 1 ),
252 ( @domainID, 'civicrm/mailing/browse/unscheduled&reset=1&scheduled=false', 'Draft and Unscheduled Mailings', 'Draft and Unscheduled Mailings', 'access CiviMail,create mailings,schedule mailings', 'OR', @mailinglastID, '1', NULL, 2 ),
253 ( @domainID, 'civicrm/mailing/browse/scheduled&reset=1&scheduled=true', 'Scheduled and Sent Mailings', 'Scheduled and Sent Mailings', 'access CiviMail,approve mailings,create mailings,schedule mailings', 'OR', @mailinglastID, '1', NULL, 3 ),
254 ( @domainID, 'civicrm/mailing/browse/archived&reset=1', 'Archived Mailings', 'Archived Mailings', 'access CiviMail,create mailings', 'OR', @mailinglastID, '1', 1, 4 ),
255 ( @domainID, 'civicrm/admin/component&reset=1', 'Headers, Footers, and Automated Messages', 'Headers, Footers, and Automated Messages', 'access CiviMail,administer CiviCRM', 'AND', @mailinglastID, '1', NULL, 5 ),
256 ( @domainID, 'civicrm/admin/messageTemplates&reset=1', 'Message Templates', 'Message Templates', 'administer CiviCRM', '', @mailinglastID, '1', NULL, 6 ),
257 ( @domainID, 'civicrm/admin/options/from_email&group=from_email_address&reset=1', 'From Email Addresses', 'From Email Addresses', 'administer CiviCRM', '', @mailinglastID, '1', 1, 7 ),
258 ( @domainID, 'civicrm/sms/send?reset=1', 'New SMS', 'New SMS', 'administer CiviCRM', NULL, @mailinglastID, '1', 1, 8 );
259 INSERT INTO civicrm_navigation
260 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
261 VALUES
262 ( @domainID, NULL, 'Memberships', 'Memberships', 'access CiviMember', '', NULL, '1', NULL, 60 );
263
264 SET @memberlastID:=LAST_INSERT_ID();
265 INSERT INTO civicrm_navigation
266 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
267 VALUES
268 ( @domainID, 'civicrm/member&reset=1', 'Dashboard', 'Dashboard', 'access CiviMember', '', @memberlastID, '1', NULL, 1 ),
269 ( @domainID, 'civicrm/member/add&reset=1&action=add&context=standalone', 'New Membership', 'New Membership', 'access CiviMember,edit memberships', 'AND', @memberlastID, '1', NULL, 2 ),
270 ( @domainID, 'civicrm/member/search&reset=1', 'Find Memberships', 'Find Memberships','access CiviMember', '', @memberlastID, '1', NULL, 3 ),
271 ( @domainID, 'civicrm/batch&reset=1', 'Batches', 'Batches','access CiviMember,access CiviContribute', '', @memberlastID, '1', NULL, 4 ),
272 ( @domainID, 'civicrm/member/import&reset=1', 'Import Memberships', 'Import Members', 'access CiviMember,edit memberships', 'AND', @memberlastID, '1', 1, 5 ),
273 ( @domainID, 'civicrm/admin/price&reset=1&action=add', 'New Price Set', 'New Price Set', 'access CiviMember,administer CiviCRM', 'AND', @memberlastID, '1', NULL, 6 ),
274 ( @domainID, 'civicrm/admin/price&reset=1', 'Manage Price Sets', 'Manage Price Sets', 'access CiviMember,administer CiviCRM', 'AND', @memberlastID, '1', NULL, 7 );
275
276
277 INSERT INTO civicrm_navigation
278 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
279 VALUES
280 ( @domainID, NULL, 'Campaigns', 'Campaigns', 'interview campaign contacts,release campaign contacts,reserve campaign contacts,manage campaign,administer CiviCampaign,gotv campaign contacts', 'OR', NULL, '1', NULL, 70 );
281
282 SET @campaignlastID:=LAST_INSERT_ID();
283 INSERT INTO civicrm_navigation
284 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
285 VALUES
286 ( @domainID, 'civicrm/campaign&reset=1', 'Dashboard', 'Dashboard', 'manage campaign,administer CiviCampaign', 'OR', @campaignlastID, '1', NULL, 1 );
287 SET @campaigndashboardlastID:=LAST_INSERT_ID();
288 INSERT INTO civicrm_navigation
289 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
290 VALUES
291 ( @domainID, 'civicrm/campaign&reset=1&subPage=survey', 'Surveys', 'Survey Dashboard', 'manage campaign,administer CiviCampaign', 'OR', @campaigndashboardlastID, '1', NULL, 1 ),
292 ( @domainID, 'civicrm/campaign&reset=1&subPage=petition', 'Petitions', 'Petition Dashboard', 'manage campaign,administer CiviCampaign', 'OR', @campaigndashboardlastID, '1', NULL, 2 ),
293 ( @domainID, 'civicrm/campaign&reset=1&subPage=campaign', 'Campaigns', 'Campaign Dashboard', 'manage campaign,administer CiviCampaign', 'OR', @campaigndashboardlastID, '1', NULL, 3 ),
294 ( @domainID, 'civicrm/campaign/add&reset=1', 'New Campaign', 'New Campaign', 'manage campaign,administer CiviCampaign', 'OR', @campaignlastID, '1', NULL, 2 ),
295 ( @domainID, 'civicrm/survey/add&reset=1', 'New Survey', 'New Survey', 'manage campaign,administer CiviCampaign', 'OR', @campaignlastID, '1', NULL, 3 ),
296 ( @domainID, 'civicrm/petition/add&reset=1', 'New Petition', 'New Petition', 'manage campaign,administer CiviCampaign', 'OR', @campaignlastID, '1', NULL, 4 ),
297 ( @domainID, 'civicrm/survey/search&reset=1&op=reserve', 'Reserve Respondents', 'Reserve Respondents', 'administer CiviCampaign,manage campaign,reserve campaign contacts', 'OR', @campaignlastID, '1', NULL, 5 ),
298 ( @domainID, 'civicrm/survey/search&reset=1&op=interview', 'Interview Respondents', 'Interview Respondents', 'administer CiviCampaign,manage campaign,interview campaign contacts', 'OR', @campaignlastID, '1', NULL, 6 ),
299 ( @domainID, 'civicrm/survey/search&reset=1&op=release', 'Release Respondents', 'Release Respondents', 'administer CiviCampaign,manage campaign,release campaign contacts', 'OR', @campaignlastID, '1', NULL, 7 ),
300 ( @domainID, 'civicrm/campaign/gotv&reset=1', 'GOTV (Voter Tracking)', 'Voter Listing', 'administer CiviCampaign,manage campaign,release campaign contacts,gotv campaign contacts', 'OR', @campaignlastID, '1', NULL, 8 ),
301 ( @domainID, 'civicrm/campaign/vote&reset=1', 'Conduct Survey', 'Conduct Survey', 'administer CiviCampaign,manage campaign,reserve campaign contacts,interview campaign contacts', 'OR', @campaignlastID, '1', NULL, 9 );
302
303 INSERT INTO civicrm_navigation
304 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
305 VALUES
306 ( @domainID, NULL, 'Cases', 'Cases', 'access my cases and activities,access all cases and activities', 'OR', NULL, '1', NULL, 80 );
307
308 SET @caselastID:=LAST_INSERT_ID();
309 INSERT INTO civicrm_navigation
310 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
311 VALUES
312 ( @domainID, 'civicrm/case&reset=1', 'Dashboard', 'Dashboard', 'access my cases and activities,access all cases and activities', 'OR', @caselastID, '1', NULL, 1 ),
313 ( @domainID, 'civicrm/case/add&reset=1&action=add&atype=13&context=standalone', 'New Case', 'New Case', 'add cases,access all cases and activities', 'OR', @caselastID, '1', NULL, 2 ),
314 ( @domainID, 'civicrm/case/search&reset=1', 'Find Cases', 'Find Cases', 'access my cases and activities,access all cases and activities', 'OR', @caselastID, '1', 1, 3 );
315
316 INSERT INTO civicrm_navigation
317 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
318 VALUES
319 ( @domainID, NULL, 'Grants', 'Grants', 'access CiviGrant', '', NULL, '1', NULL, 90 );
320
321 SET @grantlastID:=LAST_INSERT_ID();
322 INSERT INTO civicrm_navigation
323 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
324 VALUES
325 ( @domainID, 'civicrm/grant&reset=1', 'Dashboard', 'Dashboard', 'access CiviGrant', '', @grantlastID, '1', NULL, 1 ),
326 ( @domainID, 'civicrm/grant/add&reset=1&action=add&context=standalone', 'New Grant', 'New Grant', 'access CiviGrant,edit grants', 'AND', @grantlastID, '1', NULL, 2 ),
327 ( @domainID, 'civicrm/grant/search&reset=1', 'Find Grants', 'Find Grants', 'access CiviGrant', '', @grantlastID, '1', 1, 3 );
328
329 INSERT INTO civicrm_navigation
330 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
331 VALUES
332 ( @domainID, NULL, 'Administer', 'Administer', 'administer CiviCRM', '', NULL, '1', NULL, 100 );
333
334 SET @adminlastID:=LAST_INSERT_ID();
335 INSERT INTO civicrm_navigation
336 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
337 VALUES
338 ( @domainID, 'civicrm/admin&reset=1', 'Administration Console', 'Administration Console', 'administer CiviCRM', '', @adminlastID, '1', NULL, 1 );
339
340 SET @adminConsolelastID:=LAST_INSERT_ID();
341 INSERT INTO civicrm_navigation
342 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
343 VALUES
344 ( @domainID, 'civicrm/admin/configtask&reset=1', 'Configuration Checklist', 'Configuration Checklist', 'administer CiviCRM', '', @adminConsolelastID, '1', NULL, 1 );
345
346 INSERT INTO civicrm_navigation
347 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
348 VALUES
349 ( @domainID, NULL, 'Customize Data and Screens', 'Customize Data and Screens', 'administer CiviCRM', '', @adminlastID, '1', NULL, 3 );
350
351 SET @CustomizelastID:=LAST_INSERT_ID();
352 INSERT INTO civicrm_navigation
353 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
354 VALUES
355 ( @domainID, 'civicrm/admin/custom/group&reset=1', 'Custom Fields', 'Custom Fields', 'administer CiviCRM', '', @CustomizelastID, '1', NULL, 1 ),
356 ( @domainID, 'civicrm/admin/uf/group&reset=1', 'Profiles', 'Profiles', 'administer CiviCRM', '', @CustomizelastID, '1', NULL, 2 ),
357 ( @domainID, 'civicrm/admin/tag&reset=1', 'Tags (Categories)', 'Tags (Categories)', 'administer CiviCRM', '', @CustomizelastID, '1', NULL, 3 ),
358 ( @domainID, 'civicrm/admin/options/activity_type&reset=1&group=activity_type', 'Activity Types', 'Activity Types', 'administer CiviCRM', '', @CustomizelastID, '1', NULL, 4 ),
359 ( @domainID, 'civicrm/admin/reltype&reset=1', 'Relationship Types', 'Relationship Types', 'administer CiviCRM', '', @CustomizelastID, '1', NULL, 5 ),
360 ( @domainID, 'civicrm/admin/options/subtype&reset=1', 'Contact Types','Contact Types', 'administer CiviCRM', '', @CustomizelastID, '1', NULL, 6 ),
361 ( @domainID, 'civicrm/admin/setting/preferences/display&reset=1', 'Display Preferences', 'Display Preferences', 'administer CiviCRM', '', @CustomizelastID, '1', NULL, 9 ),
362 ( @domainID, 'civicrm/admin/setting/search&reset=1', 'Search Preferences', 'Search Preferences', 'administer CiviCRM', '', @CustomizelastID, '1', NULL, 10 ),
363 ( @domainID, 'civicrm/admin/menu&reset=1', 'Navigation Menu', 'Navigation Menu', 'administer CiviCRM', '', @CustomizelastID, '1', NULL, 11 ),
364 ( @domainID, 'civicrm/admin/options/wordreplacements&reset=1','Word Replacements','Word Replacements', 'administer CiviCRM', '', @CustomizelastID, '1', NULL, 12 ),
365 ( @domainID, 'civicrm/admin/options/custom_search&reset=1&group=custom_search', 'Manage Custom Searches', 'Manage Custom Searches', 'administer CiviCRM', '', @CustomizelastID, '1', NULL, 13 );
366
367 INSERT INTO civicrm_navigation
368 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
369 VALUES
370 ( @domainID, NULL, 'Dropdown Options', 'Dropdown Options', 'administer CiviCRM', '', @CustomizelastID, '1', NULL, 8 );
371
372 SET @optionListlastID:=LAST_INSERT_ID();
373 INSERT INTO civicrm_navigation
374 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
375 VALUES
376 ( @domainID, 'civicrm/admin/options/gender&reset=1&group=gender', 'Gender Options', 'Gender Options', 'administer CiviCRM', '', @optionListlastID, '1', NULL, 1 ),
377 ( @domainID, 'civicrm/admin/options/individual_prefix&group=individual_prefix&reset=1', 'Individual Prefixes (Ms, Mr...)', 'Individual Prefixes (Ms, Mr...)', 'administer CiviCRM', '', @optionListlastID, '1', NULL, 2 ),
378 ( @domainID, 'civicrm/admin/options/individual_suffix&group=individual_suffix&reset=1', 'Individual Suffixes (Jr, Sr...)', 'Individual Suffixes (Jr, Sr...)', 'administer CiviCRM', '', @optionListlastID, '1', NULL, 3 ),
379 ( @domainID, 'civicrm/admin/options/instant_messenger_service&group=instant_messenger_service&reset=1', 'Instant Messenger Services', 'Instant Messenger Services', 'administer CiviCRM', '', @optionListlastID, '1', NULL, 4 ),
380 ( @domainID, 'civicrm/admin/locationType&reset=1', 'Location Types (Home, Work...)', 'Location Types (Home, Work...)', 'administer CiviCRM', '', @optionListlastID, '1', NULL, 5 ),
381 ( @domainID, 'civicrm/admin/options/mobile_provider&group=mobile_provider&reset=1', 'Mobile Phone Providers', 'Mobile Phone Providers', 'administer CiviCRM', '', @optionListlastID, '1', NULL, 6 ),
382 ( @domainID, 'civicrm/admin/options/phone_type&group=phone_type&reset=1', 'Phone Types', 'Phone Types', 'administer CiviCRM', '', @optionListlastID, '1', NULL, 7 ),
383 ( @domainID, 'civicrm/admin/options/website_type&group=website_type&reset=1', 'Website Types', 'Website Types', 'administer CiviCRM', '', @optionListlastID, '1', NULL, 8 );
384
385 INSERT INTO civicrm_navigation
386 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
387 VALUES
388 ( @domainID, NULL, 'Communications', 'Communications', 'administer CiviCRM', '', @adminlastID, '1', NULL, 4 );
389
390 SET @communicationslastID:=LAST_INSERT_ID();
391 INSERT INTO civicrm_navigation
392 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
393 VALUES
394 ( @domainID, 'civicrm/admin/domain&action=update&reset=1', 'Organization Address and Contact Info', 'Organization Address and Contact Info', 'administer CiviCRM', '', @communicationslastID, '1', NULL, 1 ),
395 ( @domainID, 'civicrm/admin/options/from_email_address&group=from_email_address&reset=1', 'FROM Email Addresses', 'FROM Email Addresses', 'administer CiviCRM', '', @communicationslastID, '1', NULL, 2 ),
396 ( @domainID, 'civicrm/admin/messageTemplates&reset=1', 'Message Templates', 'Message Templates', 'administer CiviCRM', '', @communicationslastID, '1', NULL, 3 ),
397 ( @domainID, 'civicrm/admin/scheduleReminders&reset=1', 'Schedule Reminders', 'Schedule Reminders', 'administer CiviCRM', '', @communicationslastID, '1', NULL, 4 ),
398 ( @domainID, 'civicrm/admin/options/preferred_communication_method&group=preferred_communication_method&reset=1', 'Preferred Communication Methods', 'Preferred Communication Methods', 'administer CiviCRM', '', @communicationslastID, '1', NULL, 5 ),
399 ( @domainID, 'civicrm/admin/labelFormats&reset=1', 'Label Formats', 'Label Formats', 'administer CiviCRM', '', @communicationslastID, '1', NULL, 6 ),
400 ( @domainID, 'civicrm/admin/pdfFormats&reset=1', 'Print Page (PDF) Formats', 'Print Page (PDF) Formats', 'administer CiviCRM', '', @communicationslastID, '1', NULL, 7 ),
401 ( @domainID, 'civicrm/admin/options/email_greeting&group=email_greeting&reset=1', 'Email Greeting Formats', 'Email Greeting Formats', 'administer CiviCRM', '', @communicationslastID, '1', NULL, 8 ),
402 ( @domainID, 'civicrm/admin/options/postal_greeting&group=postal_greeting&reset=1', 'Postal Greeting Formats', 'Postal Greeting Formats', 'administer CiviCRM', '', @communicationslastID, '1', NULL, 9 ),
403 ( @domainID, 'civicrm/admin/options/addressee&group=addressee&reset=1', 'Addressee Formats', 'Addressee Formats', 'administer CiviCRM', '', @communicationslastID, '1', NULL, 10 );
404
405 INSERT INTO civicrm_navigation
406 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
407 VALUES
408 ( @domainID, NULL, 'Localization', 'Localization', 'administer CiviCRM', '', @adminlastID, '1', NULL, 6 );
409
410 SET @locallastID:=LAST_INSERT_ID();
411 INSERT INTO civicrm_navigation
412 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
413 VALUES
414 ( @domainID, 'civicrm/admin/setting/localization&reset=1', 'Languages, Currency, Locations', 'Languages, Currency, Locations', 'administer CiviCRM', '', @locallastID, '1', NULL, 1 ),
415 ( @domainID, 'civicrm/admin/setting/preferences/address&reset=1', 'Address Settings', 'Address Settings', 'administer CiviCRM', '', @locallastID, '1', NULL, 2 ),
416 ( @domainID, 'civicrm/admin/setting/date&reset=1', 'Date Formats', 'Date Formats', 'administer CiviCRM', '', @locallastID, '1', NULL, 3 ),
417 ( @domainID, 'civicrm/admin/options/languages&group=languages&reset=1', 'Preferred Language Options', 'Preferred Language Options', 'administer CiviCRM', '', @locallastID, '1', NULL, 4 );
418
419 INSERT INTO civicrm_navigation
420 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
421 VALUES
422 ( @domainID, NULL, 'Users and Permissions', 'Users and Permissions', 'administer CiviCRM', '', @adminlastID, '1', NULL, 7 );
423
424 SET @usersPermslastID:=LAST_INSERT_ID();
425 INSERT INTO civicrm_navigation
426 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
427 VALUES
428 ( @domainID, 'civicrm/admin/access&reset=1', 'Permissions (Access Control)', 'Permissions (Access Control)', 'administer CiviCRM', '', @usersPermslastID, '1', NULL, 1 ),
429 ( @domainID, 'civicrm/admin/synchUser&reset=1', 'Synchronize Users to Contacts', 'Synchronize Users to Contacts', 'administer CiviCRM', '', @usersPermslastID, '1', NULL, 2 );
430
431 INSERT INTO civicrm_navigation
432 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
433 VALUES
434 ( @domainID, NULL, 'System Settings', 'System Settings', 'administer CiviCRM', '', @adminlastID, '1', NULL, 8 );
435
436 SET @systemSettingslastID:=LAST_INSERT_ID();
437 INSERT INTO civicrm_navigation
438 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
439 VALUES
440 ( @domainID, 'civicrm/admin/setting/component&reset=1', 'Enable CiviCRM Components', 'Enable Components', 'administer CiviCRM', '', @systemSettingslastID, '1', NULL, 1 ),
441 ( @domainID, 'civicrm/admin/extensions&reset=1', 'Manage Extensions', 'Manage Extensions', 'administer CiviCRM', '', @systemSettingslastID, '1', NULL, 2 ),
442 ( @domainID, 'civicrm/admin/setting/smtp&reset=1', 'Outbound Email (SMTP/Sendmail)', 'Outbound Email', 'administer CiviCRM', '', @systemSettingslastID, '1', NULL, 3 ),
443 ( @domainID, 'civicrm/admin/paymentProcessor&reset=1', 'Payment Processors', 'Payment Processors', 'administer CiviCRM', '', @systemSettingslastID, '1', NULL, 4 ),
444 ( @domainID, 'civicrm/admin/setting/mapping&reset=1', 'Mapping and Geocoding', 'Mapping and Geocoding', 'administer CiviCRM', '', @systemSettingslastID, '1', NULL, 5 ),
445 ( @domainID, 'civicrm/admin/setting/misc&reset=1', 'Undelete, Logging and ReCAPTCHA', 'Undelete, Logging and ReCAPTCHA', 'administer CiviCRM', '', @systemSettingslastID, '1', NULL, 6 ),
446 ( @domainID, 'civicrm/admin/setting/path&reset=1', 'Directories', 'Directories', 'administer CiviCRM', '', @systemSettingslastID, '1', NULL, 7 ),
447 ( @domainID, 'civicrm/admin/setting/url&reset=1', 'Resource URLs', 'Resource URLs', 'administer CiviCRM', '', @systemSettingslastID, '1', NULL, 8 ),
448 ( @domainID, 'civicrm/admin/setting/updateConfigBackend&reset=1', 'Cleanup Caches and Update Paths', 'Cleanup Caches and Update Paths', 'administer CiviCRM', '', @systemSettingslastID, '1', NULL, 9 ),
449 ( @domainID, 'civicrm/admin/setting/uf&reset=1', 'CMS Database Integration', 'CMS Integration', 'administer CiviCRM', '', @systemSettingslastID, '1', NULL, 10 ),
450 ( @domainID, 'civicrm/admin/options/safe_file_extension&group=safe_file_extension&reset=1', 'Safe File Extensions', 'Safe File Extensions','administer CiviCRM', '',@systemSettingslastID, '1', NULL, 11 ),
451 ( @domainID, 'civicrm/admin/options?reset=1', 'Option Groups', 'Option Groups', 'administer CiviCRM', '', @systemSettingslastID, '1', NULL, 12 ),
452 ( @domainID, 'civicrm/admin/mapping&reset=1', 'Import/Export Mappings', 'Import/Export Mappings', 'administer CiviCRM', '', @systemSettingslastID, '1', NULL, 13 ),
453 ( @domainID, 'civicrm/admin/setting/debug&reset=1', 'Debugging and Error Handling','Debugging and Error Handling', 'administer CiviCRM', '', @systemSettingslastID, '1', NULL, 14 ),
454 ( @domainID, 'civicrm/admin/setting/preferences/multisite&reset=1', 'Multi Site Settings', 'Multi Site Settings', 'administer CiviCRM', '', @systemSettingslastID, '1', NULL, 15 ),
455 ( @domainID, 'civicrm/admin/job&reset=1', 'Scheduled Jobs', 'Scheduled Jobs', 'administer CiviCRM', '', @systemSettingslastID, '1', NULL, 16 ),
456 ( @domainID, 'civicrm/admin/sms/provider?reset=1', 'SMS Providers', 'SMS Providers', 'administer CiviCRM', '', @systemSettingslastID, '1', NULL, 17 );
457
458
459 -- begin component admin menus
460 INSERT INTO civicrm_navigation
461 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
462 VALUES
463 ( @domainID, NULL, 'CiviCampaign', 'CiviCampaign', 'administer CiviCampaign,administer CiviCRM', 'AND', @adminlastID, '1', NULL, 9 );
464
465 SET @adminCampaignlastID:=LAST_INSERT_ID();
466 INSERT INTO civicrm_navigation
467 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
468 VALUES
469 ( @domainID, 'civicrm/admin/campaign/surveyType&reset=1', 'Survey Types', 'Survey Types', 'administer CiviCampaign', '', @adminCampaignlastID, '1', NULL, 1 ),
470 ( @domainID, 'civicrm/admin/options/campaign_type&group=campaign_type&reset=1', 'Campaign Types', 'Campaign Types', 'administer CiviCampaign', '', @adminCampaignlastID, '1', NULL, 2 ),
471 ( @domainID, 'civicrm/admin/options/campaign_status&group=campaign_status&reset=1', 'Campaign Status', 'Campaign Status', 'administer CiviCampaign', '', @adminCampaignlastID, '1', NULL, 3 ),
472 ( @domainID, 'civicrm/admin/options/engagement_index&group=engagement_index&reset=1', 'Engagement Index', 'Engagement Index', 'administer CiviCampaign', '', @adminCampaignlastID, '1', NULL, 4 ),
473 ( @domainID, 'civicrm/admin/setting/preferences/campaign&reset=1', 'CiviCampaign Component Settings', 'CiviCampaign Component Settings','administer CiviCampaign', '', @adminCampaignlastID, '1', NULL, 5 );
474
475 INSERT INTO civicrm_navigation
476 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
477 VALUES
478 ( @domainID, NULL, 'CiviCase', 'CiviCase', 'administer CiviCase', NULL, @adminlastID, '1', NULL, 10 );
479
480 SET @adminCaselastID:=LAST_INSERT_ID();
481 INSERT INTO civicrm_navigation
482 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
483 VALUES
484 ( @domainID, 'civicrm/admin/options/case_type&group=case_type&reset=1', 'Case Types', 'Case Types', 'administer CiviCase', NULL, @adminCaselastID, '1', NULL, 1 ),
485 ( @domainID, 'civicrm/admin/options/redaction_rule&group=redaction_rule&reset=1', 'Redaction Rules', 'Redaction Rules', 'administer CiviCase', NULL, @adminCaselastID, '1', NULL, 2 ),
486 ( @domainID, 'civicrm/admin/options/case_status&group=case_status&reset=1', 'Case Statuses', 'Case Statuses', 'administer CiviCase', NULL, @adminCaselastID, '1', NULL, 3 ),
487 ( @domainID, 'civicrm/admin/options/encounter_medium&group=encounter_medium&reset=1', 'Encounter Medium', 'Encounter Medium', 'administer CiviCase', NULL, @adminCaselastID, '1', NULL, 4 );
488
489 INSERT INTO civicrm_navigation
490 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
491 VALUES
492 ( @domainID, NULL, 'CiviContribute', 'CiviContribute', 'access CiviContribute,administer CiviCRM', 'AND', @adminlastID, '1', NULL, 11 );
493
494 SET @adminContributelastID:=LAST_INSERT_ID();
495 INSERT INTO civicrm_navigation
496 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
497 VALUES
498 ( @domainID, 'civicrm/admin/contribute&reset=1&action=add', 'New Contribution Page', 'New Contribution Page', 'access CiviContribute,administer CiviCRM', 'AND', @adminContributelastID, '1', NULL, 6 ),
499 ( @domainID, 'civicrm/admin/contribute&reset=1', 'Manage Contribution Pages', 'Manage Contribution Pages', 'access CiviContribute,administer CiviCRM', 'AND', @adminContributelastID, '1', '1', 7 ),
500 ( @domainID, 'civicrm/admin/pcp?reset=1&page_type=contribute', 'Personal Campaign Pages', 'Personal Campaign Pages', 'access CiviContribute,administer CiviCRM', 'AND', @adminContributelastID, '1', NULL, 8 ),
501 ( @domainID, 'civicrm/admin/contribute/managePremiums&reset=1', 'Premiums (Thank-you Gifts)', 'Premiums', 'access CiviContribute,administer CiviCRM', 'AND', @adminContributelastID, '1', 1, 9 ),
502 ( @domainID, 'civicrm/admin/contribute/contributionType&reset=1', 'Contribution Types', 'Contribution Types', 'access CiviContribute,administer CiviCRM', 'AND', @adminContributelastID, '1', NULL, 10),
503 ( @domainID, 'civicrm/admin/options/payment_instrument&group=payment_instrument&reset=1', 'Payment Instruments', 'Payment Instruments', 'access CiviContribute,administer CiviCRM', 'AND', @adminContributelastID, '1', NULL, 11 ),
504 ( @domainID, 'civicrm/admin/options/accept_creditcard&group=accept_creditcard&reset=1', 'Accepted Credit Cards', 'Accepted Credit Cards', 'access CiviContribute,administer CiviCRM', 'AND', @adminContributelastID, '1', 1, 12 ),
505 ( @domainID, 'civicrm/admin/price&reset=1&action=add', 'New Price Set', 'New Price Set', 'access CiviContribute,administer CiviCRM', 'AND', @adminContributelastID, '1', NULL, 13 ),
506 ( @domainID, 'civicrm/admin/price&reset=1', 'Manage Price Sets', 'Manage Price Sets', 'access CiviContribute,administer CiviCRM', 'AND', @adminContributelastID, '1', NULL, 14 ),
507 ( @domainID, 'civicrm/admin/paymentProcessor&reset=1', 'Payment Processors', 'Payment Processors', 'administer CiviCRM', '', @adminContributelastID, '1', NULL, 15 );
508
509 INSERT INTO civicrm_navigation
510 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
511 VALUES
512 ( @domainID, NULL, 'CiviEvent', 'CiviEvent', 'access CiviEvent,administer CiviCRM', 'AND', @adminlastID, '1', NULL, 12 );
513
514 SET @adminEventlastID:=LAST_INSERT_ID();
515 INSERT INTO civicrm_navigation
516 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
517 VALUES
518 ( @domainID, 'civicrm/event/add&reset=1&action=add', 'New Event', 'New Event', 'access CiviEvent,administer CiviCRM', 'AND', @adminEventlastID, '1', NULL, 1 ),
519 ( @domainID, 'civicrm/event/manage&reset=1', 'Manage Events', 'Manage Events', 'access CiviEvent,administer CiviCRM', 'AND', @adminEventlastID, '1', 1, 2 ),
520 ( @domainID, 'civicrm/admin/pcp?reset=1&page_type=event', 'Personal Campaign Pages', 'Personal Campaign Pages', 'access CiviEvent,administer CiviCRM', 'AND', @adminEventlastID, '1', 1, 3 ),
521 ( @domainID, 'civicrm/admin/eventTemplate&reset=1', 'Event Templates', 'Event Templates', 'access CiviEvent,administer CiviCRM', 'AND', @adminEventlastID, '1', 1, 4 ),
522 ( @domainID, 'civicrm/admin/price&reset=1&action=add', 'New Price Set', 'New Price Set', 'access CiviEvent,administer CiviCRM', 'AND', @adminEventlastID, '1', NULL, 5 ),
523 ( @domainID, 'civicrm/admin/price&reset=1', 'Manage Price Sets', 'Manage Price Sets', 'access CiviEvent,administer CiviCRM', 'AND', @adminEventlastID, '1', 1, 6 ),
524 ( @domainID, 'civicrm/admin/options/event_type&group=event_type&reset=1', 'Event Types', 'Event Types', 'access CiviEvent,administer CiviCRM', 'AND', @adminEventlastID, '1', NULL, 7 ),
525 ( @domainID, 'civicrm/admin/participant_status&reset=1', 'Participant Statuses', 'Participant Statuses', 'access CiviEvent,administer CiviCRM', 'AND', @adminEventlastID, '1', NULL, 8 ),
526 ( @domainID, 'civicrm/admin/options/participant_role&group=participant_role&reset=1', 'Participant Roles', 'Participant Roles', 'access CiviEvent,administer CiviCRM', 'AND', @adminEventlastID, '1', NULL, 9 ),
527 ( @domainID, 'civicrm/admin/options/participant_listing&group=participant_listing&reset=1', 'Participant Listing Options', 'Participant Listing Options', 'access CiviEvent,administer CiviCRM', 'AND', @adminEventlastID, '1', NULL, 10 ),
528 ( @domainID, 'civicrm/admin/options/event_badge&group=event_badge&reset=1', 'Event Badge Formats', 'Event Badge Formats', 'access CiviEvent,administer CiviCRM', 'AND', @adminEventlastID, '1', NULL, 11 ),
529 ( @domainID, 'civicrm/admin/paymentProcessor&reset=1', 'Payment Processors', 'Payment Processors', 'administer CiviCRM', '', @adminEventlastID, '1', NULL, 12),
530 ( @domainID, 'civicrm/admin/setting/preferences/event&reset=1', 'CiviEvent Component Settings', 'CiviEvent Component Settings','access CiviEvent,administer CiviCRM', 'AND', @adminEventlastID, '1', NULL, 13 );
531
532 INSERT INTO civicrm_navigation
533 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
534 VALUES
535 ( @domainID, NULL, 'CiviGrant', 'CiviGrant', 'access CiviGrant,administer CiviCRM', 'AND', @adminlastID, '1', NULL, 13 );
536
537 SET @adminGrantlastID:=LAST_INSERT_ID();
538 INSERT INTO civicrm_navigation
539 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
540 VALUES
541 ( @domainID, 'civicrm/admin/options/grant_type&group=grant_type&reset=1', 'Grant Types', 'Grant Types', 'access CiviGrant,administer CiviCRM', 'AND', @adminGrantlastID, '1', NULL, 1 );
542
543 INSERT INTO civicrm_navigation
544 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
545 VALUES
546 ( @domainID, NULL, 'CiviMail', 'CiviMail', 'access CiviMail,administer CiviCRM', 'AND', @adminlastID, '1', NULL, 14 );
547
548 SET @adminMailinglastID:=LAST_INSERT_ID();
549 INSERT INTO civicrm_navigation
550 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
551 VALUES
552 ( @domainID, 'civicrm/admin/component&reset=1', 'Headers, Footers, and Automated Messages', 'Headers, Footers, and Automated Messages', 'access CiviMail,administer CiviCRM', 'AND', @adminMailinglastID, '1', NULL, 1 ),
553 ( @domainID, 'civicrm/admin/messageTemplates&reset=1', 'Message Templates', 'Message Templates', 'administer CiviCRM', '', @adminMailinglastID, '1', NULL, 2 ),
554 ( @domainID, 'civicrm/admin/options/from_email&group=from_email_address&reset=1', 'From Email Addresses', 'From Email Addresses', 'administer CiviCRM', '', @adminMailinglastID, '1', NULL, 3 ),
555 ( @domainID, 'civicrm/admin/mailSettings&reset=1', 'Mail Accounts', 'Mail Accounts', 'access CiviMail,administer CiviCRM', 'AND', @adminMailinglastID, '1', NULL, 4 ),
556 ( @domainID, 'civicrm/admin/mail&reset=1', 'Mailer Settings', 'Mailer Settings', 'access CiviMail,administer CiviCRM', 'AND', @adminMailinglastID, '1', NULL, 5 ),
557 ( @domainID, 'civicrm/admin/setting/preferences/mailing&reset=1', 'CiviMail Component Settings', 'CiviMail Component Settings','access CiviMail,administer CiviCRM', 'AND', @adminMailinglastID, '1', NULL, 6 );
558
559 INSERT INTO civicrm_navigation
560 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
561 VALUES
562 ( @domainID, NULL, 'CiviMember', 'CiviMember', 'access CiviMember,administer CiviCRM', 'AND', @adminlastID, '1', NULL, 15 );
563
564 SET @adminMemberlastID:=LAST_INSERT_ID();
565 INSERT INTO civicrm_navigation
566 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
567 VALUES
568 ( @domainID, 'civicrm/admin/member/membershipType&reset=1', 'Membership Types', 'Membership Types', 'access CiviMember,administer CiviCRM', 'AND', @adminMemberlastID, '1', NULL, 1 ),
569 ( @domainID, 'civicrm/admin/member/membershipStatus&reset=1', 'Membership Status Rules', 'Membership Status Rules', 'access CiviMember,administer CiviCRM', 'AND', @adminMemberlastID, '1', 1, 2 ),
570 ( @domainID, 'civicrm/admin/price&reset=1&action=add', 'New Price Set', 'New Price Set', 'access CiviMember,administer CiviCRM', 'AND', @adminMemberlastID, '1', NULL, 3 ),
571 ( @domainID, 'civicrm/admin/price&reset=1', 'Manage Price Sets', 'Manage Price Sets', 'access CiviMember,administer CiviCRM', 'AND', @adminMemberlastID, '1', NULL, 4 ),
572 ( @domainID, 'civicrm/admin/setting/preferences/member&reset=1', 'CiviMember Component Settings', 'CiviMember Component Settings','access CiviMember,administer CiviCRM', 'AND', @adminMemberlastID, '1', NULL, 5 );
573
574 INSERT INTO civicrm_navigation
575 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
576 VALUES
577 ( @domainID, NULL, 'CiviReport', 'CiviReport', 'access CiviReport,administer CiviCRM', 'AND', @adminlastID, '1', NULL, 16 );
578
579 SET @adminReportlastID:=LAST_INSERT_ID();
580 INSERT INTO civicrm_navigation
581 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
582 VALUES
583 ( @domainID, 'civicrm/report/list&reset=1', 'Reports Listing', 'Reports Listing', 'access CiviReport', '', @adminReportlastID, '1', NULL, 1 ),
584 ( @domainID, 'civicrm/admin/report/template/list&reset=1', 'Create Reports from Templates', 'Create Reports from Templates', 'administer Reports', '', @adminReportlastID, '1', NULL, 2 ),
585 ( @domainID, 'civicrm/admin/report/options/report_template&reset=1', 'Manage Templates', 'Manage Templates', 'administer Reports', '', @adminReportlastID, '1', NULL, 3 ),
586 ( @domainID, 'civicrm/admin/report/register&reset=1', 'Register Report', 'Register Report', 'administer Reports', '', @adminReportlastID, '1', NULL, 4 );
587
588 INSERT INTO civicrm_navigation
589 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
590 VALUES
591 ( @domainID, NULL, 'Help', 'Help', NULL, '', NULL, '1', NULL, 110);
592
593 SET @adminHelplastID:=LAST_INSERT_ID();
594 INSERT INTO civicrm_navigation
595 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
596 VALUES
597 ( @domainID, 'http://documentation.civicrm.org', 'Documentation', 'Documentation', NULL, 'AND', @adminHelplastID, '1', NULL, 1 ),
598 ( @domainID, 'http://forum.civicrm.org', 'Community Forums', 'Community Forums', NULL, 'AND', @adminHelplastID, '1', NULL, 2 ),
599 ( @domainID, 'http://civicrm.org/participate', 'Participate', 'Participate', NULL, 'AND', @adminHelplastID, '1', NULL, 3 ),
600 ( @domainID, 'http://civicrm.org/aboutcivicrm', 'About', 'About', NULL, 'AND', @adminHelplastID, '1', NULL, 4 );
601
602 INSERT INTO civicrm_navigation
603 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
604 VALUES
605 ( @domainID, NULL, 'Reports', 'Reports', 'access CiviReport', '', NULL, '1', NULL, 95 );
606
607 SET @reportlastID:=LAST_INSERT_ID();
608 INSERT INTO civicrm_navigation
609 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
610 VALUES
611 ( @domainID, 'civicrm/report/list&reset=1', 'Reports Listing', 'Reports Listing', 'access CiviReport', '', @reportlastID, '1', 1, 1 );
612
613 INSERT INTO civicrm_navigation
614 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
615 VALUES
616 ( @domainID, 'civicrm/admin/report/template/list&reset=1', 'Create Reports from Templates', 'Create Reports from Templates', 'administer Reports', '', @reportlastID, '1', 1, 2 );
617
618 -- sample reports with navigation menus
619
620 INSERT INTO `civicrm_report_instance`
621 ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
622 VALUES
623 ( @domainID, 'Constituent Report (Summary)', 'contact/summary', 'Provides a list of address and telephone information for constituent records in your system.', 'administer CiviCRM', 'a:31:{s:6:"fields";a:4:{s:9:"sort_name";s:1:"1";s:14:"street_address";s:1:"1";s:4:"city";s:1:"1";s:10:"country_id";s:1:"1";}s:12:"sort_name_op";s:3:"has";s:15:"sort_name_value";s:0:"";s:9:"source_op";s:3:"has";s:12:"source_value";s:0:"";s:6:"id_min";s:0:"";s:6:"id_max";s:0:"";s:5:"id_op";s:3:"lte";s:8:"id_value";s:0:"";s:13:"country_id_op";s:2:"in";s:16:"country_id_value";a:0:{}s:20:"state_province_id_op";s:2:"in";s:23:"state_province_id_value";a:0:{}s:6:"gid_op";s:2:"in";s:9:"gid_value";a:0:{}s:8:"tagid_op";s:2:"in";s:11:"tagid_value";a:0:{}s:11:"custom_1_op";s:2:"in";s:14:"custom_1_value";a:0:{}s:11:"custom_2_op";s:2:"in";s:14:"custom_2_value";a:0:{}s:17:"custom_3_relative";s:1:"0";s:13:"custom_3_from";s:0:"";s:11:"custom_3_to";s:0:"";s:11:"description";s:92:"Provides a list of address and telephone information for constituent records in your system.";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:18:"administer CiviCRM";s:6:"groups";s:0:"";s:9:"domain_id";i:1;}');
624 SET @instanceID:=LAST_INSERT_ID();
625 INSERT INTO civicrm_navigation
626 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
627 VALUES
628 ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'Constituent Report (Summary)', 'Constituent Report (Summary)', 'administer CiviCRM', '', @reportlastID, '1', NULL, @instanceID+2 );
629 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
630
631
632 INSERT INTO `civicrm_report_instance`
633 ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
634 VALUES
635 ( @domainID, 'Constituent Report (Detail)', 'contact/detail', 'Provides contact-related information on contributions, memberships, events and activities.', 'administer CiviCRM', 'a:25:{s:6:"fields";a:30:{s:9:"sort_name";s:1:"1";s:10:"country_id";s:1:"1";s:15:"contribution_id";s:1:"1";s:12:"total_amount";s:1:"1";s:20:"contribution_type_id";s:1:"1";s:12:"receive_date";s:1:"1";s:22:"contribution_status_id";s:1:"1";s:13:"membership_id";s:1:"1";s:18:"membership_type_id";s:1:"1";s:21:"membership_start_date";s:1:"1";s:19:"membership_end_date";s:1:"1";s:20:"membership_status_id";s:1:"1";s:14:"participant_id";s:1:"1";s:8:"event_id";s:1:"1";s:21:"participant_status_id";s:1:"1";s:7:"role_id";s:1:"1";s:25:"participant_register_date";s:1:"1";s:9:"fee_level";s:1:"1";s:10:"fee_amount";s:1:"1";s:15:"relationship_id";s:1:"1";s:20:"relationship_type_id";s:1:"1";s:12:"contact_id_b";s:1:"1";s:2:"id";s:1:"1";s:16:"activity_type_id";s:1:"1";s:7:"subject";s:1:"1";s:17:"source_contact_id";s:1:"1";s:18:"activity_date_time";s:1:"1";s:18:"activity_status_id";s:1:"1";s:17:"target_contact_id";s:1:"1";s:19:"assignee_contact_id";s:1:"1";}s:6:"id_min";s:0:"";s:6:"id_max";s:0:"";s:5:"id_op";s:3:"lte";s:8:"id_value";s:0:"";s:12:"sort_name_op";s:3:"has";s:15:"sort_name_value";s:0:"";s:6:"gid_op";s:2:"in";s:9:"gid_value";a:0:{}s:8:"tagid_op";s:2:"in";s:11:"tagid_value";a:0:{}s:11:"custom_1_op";s:2:"in";s:14:"custom_1_value";a:0:{}s:11:"custom_2_op";s:2:"in";s:14:"custom_2_value";a:0:{}s:17:"custom_3_relative";s:1:"0";s:13:"custom_3_from";s:0:"";s:11:"custom_3_to";s:0:"";s:11:"description";s:90:"Provides contact-related information on contributions, memberships, events and activities.";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:18:"administer CiviCRM";s:6:"groups";s:0:"";s:9:"domain_id";i:1;}');
636 SET @instanceID:=LAST_INSERT_ID();
637 INSERT INTO civicrm_navigation
638 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
639 VALUES
640 ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'Constituent Report (Detail)', 'Constituent Report (Detail)', 'administer CiviCRM', '', @reportlastID, '1', NULL, @instanceID+2 );
641 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
642
643 INSERT INTO `civicrm_report_instance`
644 ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
645 VALUES
646 ( @domainID, 'Activity Report ', 'activity', 'Provides a list of constituent activity including activity statistics for one/all contacts during a given date range(required)', 'administer CiviCRM', 'a:26:{s:6:"fields";a:6:{s:16:"contact_assignee";s:1:"1";s:14:"contact_target";s:1:"1";s:16:"activity_type_id";s:1:"1";s:16:"activity_subject";s:1:"1";s:18:"activity_date_time";s:1:"1";s:9:"status_id";s:1:"1";}s:17:"contact_source_op";s:3:"has";s:20:"contact_source_value";s:0:"";s:19:"contact_assignee_op";s:3:"has";s:22:"contact_assignee_value";s:0:"";s:17:"contact_target_op";s:3:"has";s:20:"contact_target_value";s:0:"";s:15:"current_user_op";s:2:"eq";s:18:"current_user_value";s:1:"0";s:27:"activity_date_time_relative";s:10:"this.month";s:23:"activity_date_time_from";s:0:"";s:21:"activity_date_time_to";s:0:"";s:19:"activity_subject_op";s:3:"has";s:22:"activity_subject_value";s:0:"";s:19:"activity_type_id_op";s:2:"in";s:22:"activity_type_id_value";a:0:{}s:12:"status_id_op";s:2:"in";s:15:"status_id_value";a:0:{}s:11:"description";s:126:"Provides a list of constituent activity including activity statistics for one/all contacts during a given date range(required)";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:18:"administer CiviCRM";s:6:"groups";s:0:"";s:9:"group_bys";N;s:9:"domain_id";i:1;}');
647 SET @instanceID:=LAST_INSERT_ID();
648 INSERT INTO civicrm_navigation
649 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
650 VALUES
651 ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'Activity Report', 'activity', 'administer CiviCRM', '', @reportlastID, '1', NULL, @instanceID+2 );
652 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
653
654 INSERT INTO `civicrm_report_instance`
655 (`domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
656 VALUES
657 ( @domainID, 'Current Employer Report', 'contact/currentEmployer', 'Provides detail list of employer employee relationships along with employment details.', 'administer CiviCRM', 'a:33:{s:6:"fields";a:5:{s:17:"organization_name";s:1:"1";s:9:"sort_name";s:1:"1";s:9:"job_title";s:1:"1";s:10:"start_date";s:1:"1";s:5:"email";s:1:"1";}s:20:"organization_name_op";s:3:"has";s:23:"organization_name_value";s:0:"";s:12:"sort_name_op";s:3:"has";s:15:"sort_name_value";s:0:"";s:6:"id_min";s:0:"";s:6:"id_max";s:0:"";s:5:"id_op";s:3:"lte";s:8:"id_value";s:0:"";s:19:"start_date_relative";s:1:"0";s:15:"start_date_from";s:0:"";s:13:"start_date_to";s:0:"";s:13:"country_id_op";s:2:"in";s:16:"country_id_value";a:0:{}s:20:"state_province_id_op";s:2:"in";s:23:"state_province_id_value";a:0:{}s:6:"gid_op";s:2:"in";s:9:"gid_value";a:0:{}s:8:"tagid_op";s:2:"in";s:11:"tagid_value";a:0:{}s:11:"custom_1_op";s:2:"in";s:14:"custom_1_value";a:0:{}s:11:"custom_2_op";s:2:"in";s:14:"custom_2_value";a:0:{}s:17:"custom_3_relative";s:1:"0";s:13:"custom_3_from";s:0:"";s:11:"custom_3_to";s:0:"";s:11:"description";s:98:"Provides detail list of employer employee relationships along with employment details Ex Join Date";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:18:"administer CiviCRM";s:9:"domain_id";i:1;}');
658 SET @instanceID:=LAST_INSERT_ID();
659 INSERT INTO civicrm_navigation
660 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
661 VALUES
662 ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'Current Employer Report', 'Current Employer Report', 'administer CiviCRM', '', @reportlastID, '1', NULL, @instanceID+2 );
663 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
664
665
666 INSERT INTO `civicrm_report_instance`
667 ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
668 VALUES
669 ( @domainID, 'Relationship Report', 'contact/relationship', 'Gives relationship details between two contacts', 'administer CiviCRM', 'a:28:{s:6:"fields";a:4:{s:11:"sort_name_a";s:1:"1";s:11:"sort_name_b";s:1:"1";s:9:"label_a_b";s:1:"1";s:9:"label_b_a";s:1:"1";}s:14:"sort_name_a_op";s:3:"has";s:17:"sort_name_a_value";s:0:"";s:14:"sort_name_b_op";s:3:"has";s:17:"sort_name_b_value";s:0:"";s:17:"contact_type_a_op";s:2:"in";s:20:"contact_type_a_value";a:0:{}s:17:"contact_type_b_op";s:2:"in";s:20:"contact_type_b_value";a:0:{}s:12:"is_active_op";s:2:"eq";s:15:"is_active_value";s:0:"";s:23:"relationship_type_id_op";s:2:"eq";s:26:"relationship_type_id_value";s:0:"";s:13:"country_id_op";s:2:"in";s:16:"country_id_value";a:0:{}s:20:"state_province_id_op";s:2:"in";s:23:"state_province_id_value";a:0:{}s:6:"gid_op";s:2:"in";s:9:"gid_value";a:0:{}s:8:"tagid_op";s:2:"in";s:11:"tagid_value";a:0:{}s:11:"description";s:19:"Relationship Report";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:18:"administer CiviCRM";s:6:"groups";s:0:"";s:9:"domain_id";i:1;}');
670 SET @instanceID:=LAST_INSERT_ID();
671 INSERT INTO civicrm_navigation
672 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
673 VALUES
674 ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'Relationship Report', 'Relationship Report', 'administer CiviCRM', '', @reportlastID, '1', NULL, @instanceID+2 );
675 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
676
677
678 INSERT INTO `civicrm_report_instance`
679 ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
680 VALUES
681 ( @domainID, 'Contribution Summary Report', 'contribute/summary', 'Groups and totals contributions by criteria including contact, time period, contribution type, contributor location, etc.', 'access CiviContribute', 'a:42:{s:6:"fields";a:1:{s:12:"total_amount";s:1:"1";}s:13:"country_id_op";s:2:"in";s:16:"country_id_value";a:0:{}s:20:"state_province_id_op";s:2:"in";s:23:"state_province_id_value";a:0:{}s:21:"receive_date_relative";s:1:"0";s:17:"receive_date_from";s:0:"";s:15:"receive_date_to";s:0:"";s:25:"contribution_status_id_op";s:2:"in";s:28:"contribution_status_id_value";a:1:{i:0;s:1:"1";}s:23:"contribution_type_id_op";s:2:"in";s:26:"contribution_type_id_value";a:0:{}s:16:"total_amount_min";s:0:"";s:16:"total_amount_max";s:0:"";s:15:"total_amount_op";s:3:"lte";s:18:"total_amount_value";s:0:"";s:13:"total_sum_min";s:0:"";s:13:"total_sum_max";s:0:"";s:12:"total_sum_op";s:3:"lte";s:15:"total_sum_value";s:0:"";s:15:"total_count_min";s:0:"";s:15:"total_count_max";s:0:"";s:14:"total_count_op";s:3:"lte";s:17:"total_count_value";s:0:"";s:13:"total_avg_min";s:0:"";s:13:"total_avg_max";s:0:"";s:12:"total_avg_op";s:3:"lte";s:15:"total_avg_value";s:0:"";s:6:"gid_op";s:2:"in";s:9:"gid_value";a:0:{}s:8:"tagid_op";s:2:"in";s:11:"tagid_value";a:0:{}s:9:"group_bys";a:1:{s:12:"receive_date";s:1:"1";}s:14:"group_bys_freq";a:1:{s:12:"receive_date";s:5:"MONTH";}s:11:"description";s:80:"Shows contribution statistics by month / week / year .. country / state .. type.";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:21:"access CiviContribute";s:6:"groups";s:0:"";s:6:"charts";s:0:"";s:9:"domain_id";i:1;}');
682 SET @instanceID:=LAST_INSERT_ID();
683 INSERT INTO civicrm_navigation
684 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
685 VALUES
686 ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'Contribution Summary Report', 'Contribution Summary Report', 'access CiviContribute', '', @reportlastID, '1', NULL, @instanceID+2 );
687 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
688
689
690 INSERT INTO `civicrm_report_instance`
691 ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
692 VALUES
693 ( @domainID, 'Contribution Detail Report', 'contribute/detail', 'Lists specific contributions by criteria including contact, time period, contribution type, contributor location, etc. Contribution summary report points to this report for contribution details.', 'access CiviContribute', 'a:34:{s:6:"fields";a:7:{s:9:"sort_name";s:1:"1";s:5:"email";s:1:"1";s:5:"phone";s:1:"1";s:10:"country_id";s:1:"1";s:20:"contribution_type_id";s:1:"1";s:12:"receive_date";s:1:"1";s:12:"total_amount";s:1:"1";}s:12:"sort_name_op";s:3:"has";s:15:"sort_name_value";s:0:"";s:6:"id_min";s:0:"";s:6:"id_max";s:0:"";s:5:"id_op";s:3:"lte";s:8:"id_value";s:0:"";s:13:"country_id_op";s:2:"in";s:16:"country_id_value";a:0:{}s:20:"state_province_id_op";s:2:"in";s:23:"state_province_id_value";a:0:{}s:21:"receive_date_relative";s:1:"0";s:17:"receive_date_from";s:0:"";s:15:"receive_date_to";s:0:"";s:23:"contribution_type_id_op";s:2:"in";s:26:"contribution_type_id_value";a:0:{}s:25:"contribution_status_id_op";s:2:"in";s:28:"contribution_status_id_value";a:1:{i:0;s:1:"1";}s:16:"total_amount_min";s:0:"";s:16:"total_amount_max";s:0:"";s:15:"total_amount_op";s:3:"lte";s:18:"total_amount_value";s:0:"";s:6:"gid_op";s:2:"in";s:9:"gid_value";a:0:{}s:13:"ordinality_op";s:2:"in";s:16:"ordinality_value";a:0:{}s:8:"tagid_op";s:2:"in";s:11:"tagid_value";a:0:{}s:11:"description";s:126:"Lists detailed contribution(s) for one / all contacts. Contribution summary report points to this report for specific details.";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:21:"access CiviContribute";s:9:"domain_id";i:1;}');
694 SET @instanceID:=LAST_INSERT_ID();
695 INSERT INTO civicrm_navigation
696 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
697 VALUES
698 ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'Contribution Detail Report', 'Contribution Detail Report', 'access CiviContribute', '', @reportlastID, '1', NULL, @instanceID+2 );
699 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
700
701
702 INSERT INTO `civicrm_report_instance`
703 ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
704 VALUES
705 ( @domainID, 'Repeat Contribution Report', 'contribute/repeat', 'Given two date ranges, shows contacts who contributed in both the date ranges with the amount contributed in each and the percentage increase / decrease.', 'access CiviContribute', 'a:29:{s:6:"fields";a:3:{s:9:"sort_name";s:1:"1";s:13:"total_amount1";s:1:"1";s:13:"total_amount2";s:1:"1";}s:22:"receive_date1_relative";s:13:"previous.year";s:18:"receive_date1_from";s:0:"";s:16:"receive_date1_to";s:0:"";s:22:"receive_date2_relative";s:9:"this.year";s:18:"receive_date2_from";s:0:"";s:16:"receive_date2_to";s:0:"";s:17:"total_amount1_min";s:0:"";s:17:"total_amount1_max";s:0:"";s:16:"total_amount1_op";s:3:"lte";s:19:"total_amount1_value";s:0:"";s:17:"total_amount2_min";s:0:"";s:17:"total_amount2_max";s:0:"";s:16:"total_amount2_op";s:3:"lte";s:19:"total_amount2_value";s:0:"";s:25:"contribution_status_id_op";s:2:"in";s:28:"contribution_status_id_value";a:1:{i:0;s:1:"1";}s:6:"gid_op";s:2:"in";s:9:"gid_value";a:0:{}s:8:"tagid_op";s:2:"in";s:11:"tagid_value";a:0:{}s:9:"group_bys";a:1:{s:2:"id";s:1:"1";}s:11:"description";s:140:"Given two date ranges, shows contacts (and their contributions) who contributed in both the date ranges with percentage increase / decrease.";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:21:"access CiviContribute";s:6:"groups";s:0:"";s:9:"domain_id";i:1;}');
706 SET @instanceID:=LAST_INSERT_ID();
707 INSERT INTO civicrm_navigation
708 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
709 VALUES
710 ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'Repeat Contribution Report', 'Repeat Contribution Report', 'access CiviContribute', '', @reportlastID, '1', NULL, @instanceID+2 );
711 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
712
713
714 INSERT INTO `civicrm_report_instance`
715 ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
716 VALUES
717 ( @domainID, 'SYBUNT Report', 'contribute/sybunt', '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.', 'access CiviContribute', 'a:18:{s:6:"fields";a:3:{s:9:"sort_name";s:1:"1";s:5:"email";s:1:"1";s:5:"phone";s:1:"1";}s:12:"sort_name_op";s:3:"has";s:15:"sort_name_value";s:0:"";s:6:"yid_op";s:2:"eq";s:9:"yid_value";s:4:"2011";s:25:"contribution_status_id_op";s:2:"in";s:28:"contribution_status_id_value";a:1:{i:0;s:1:"1";}s:6:"gid_op";s:2:"in";s:9:"gid_value";a:0:{}s:8:"tagid_op";s:2:"in";s:11:"tagid_value";a:0:{}s:11:"description";s:179:"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.";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:21:"access CiviContribute";s:6:"charts";s:0:"";s:9:"domain_id";i:1;}');
718 SET @instanceID:=LAST_INSERT_ID();
719 INSERT INTO civicrm_navigation
720 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
721 VALUES
722 ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'SYBUNT Report', 'SYBUNT Report', 'access CiviContribute', '', @reportlastID, '1', NULL, @instanceID+2 );
723 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
724
725
726 INSERT INTO `civicrm_report_instance`
727 ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
728 VALUES
729 ( @domainID, 'LYBUNT Report', 'contribute/lybunt', '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.', 'access CiviContribute', 'a:19:{s:6:"fields";a:3:{s:9:"sort_name";s:1:"1";s:5:"email";s:1:"1";s:5:"phone";s:1:"1";}s:12:"sort_name_op";s:3:"has";s:15:"sort_name_value";s:0:"";s:6:"yid_op";s:2:"eq";s:9:"yid_value";s:4:"2011";s:25:"contribution_status_id_op";s:2:"in";s:28:"contribution_status_id_value";a:1:{i:0;s:1:"1";}s:6:"gid_op";s:2:"in";s:9:"gid_value";a:0:{}s:8:"tagid_op";s:2:"in";s:11:"tagid_value";a:0:{}s:11:"description";s:157:"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.";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:21:"access CiviContribute";s:6:"groups";s:0:"";s:6:"charts";s:0:"";s:9:"domain_id";i:1;}');
730 SET @instanceID:=LAST_INSERT_ID();
731 INSERT INTO civicrm_navigation
732 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
733 VALUES
734 ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'LYBUNT Report', 'LYBUNT Report', 'access CiviContribute', '', @reportlastID, '1', NULL, @instanceID+2 );
735 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
736
737 INSERT INTO `civicrm_report_instance`
738 ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
739 VALUES
740 ( @domainID, 'Contributions by Organization Report', 'contribute/organizationSummary', 'Displays a detailed list of contributions grouped by organization, which includes contributions made by employees for the organisation.', 'access CiviContribute', 'a:20:{s:6:"fields";a:5:{s:17:"organization_name";s:1:"1";s:9:"sort_name";s:1:"1";s:12:"total_amount";s:1:"1";s:22:"contribution_status_id";s:1:"1";s:12:"receive_date";s:1:"1";}s:20:"organization_name_op";s:3:"has";s:23:"organization_name_value";s:0:"";s:23:"relationship_type_id_op";s:2:"eq";s:26:"relationship_type_id_value";s:5:"4_b_a";s:21:"receive_date_relative";s:1:"0";s:17:"receive_date_from";s:0:"";s:15:"receive_date_to";s:0:"";s:16:"total_amount_min";s:0:"";s:16:"total_amount_max";s:0:"";s:15:"total_amount_op";s:3:"lte";s:18:"total_amount_value";s:0:"";s:25:"contribution_status_id_op";s:2:"in";s:28:"contribution_status_id_value";a:1:{i:0;s:1:"1";}s:11:"description";s:193:"Displays a detailed contribution report for Organization relationships with contributors, as to if contribution done was from an employee of some organization or from that Organization itself.";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:21:"access CiviContribute";s:9:"domain_id";i:1;}');
741 SET @instanceID:=LAST_INSERT_ID();
742 INSERT INTO civicrm_navigation
743 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
744 VALUES
745 ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'Contributions by Organization Report', 'Contributions by Organization Report', 'access CiviContribute', '', @reportlastID, '1', NULL, @instanceID+2 );
746 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
747
748
749 INSERT INTO `civicrm_report_instance`
750 ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
751 VALUES
752 ( @domainID, 'Contributions by Household Report', 'contribute/householdSummary', 'Displays a detailed list of contributions grouped by household which includes contributions made by members of the household.', 'access CiviContribute', 'a:21:{s:6:"fields";a:5:{s:14:"household_name";s:1:"1";s:9:"sort_name";s:1:"1";s:12:"total_amount";s:1:"1";s:22:"contribution_status_id";s:1:"1";s:12:"receive_date";s:1:"1";}s:17:"household_name_op";s:3:"has";s:20:"household_name_value";s:0:"";s:23:"relationship_type_id_op";s:2:"eq";s:26:"relationship_type_id_value";s:5:"6_b_a";s:21:"receive_date_relative";s:1:"0";s:17:"receive_date_from";s:0:"";s:15:"receive_date_to";s:0:"";s:16:"total_amount_min";s:0:"";s:16:"total_amount_max";s:0:"";s:15:"total_amount_op";s:3:"lte";s:18:"total_amount_value";s:0:"";s:25:"contribution_status_id_op";s:2:"in";s:28:"contribution_status_id_value";a:1:{i:0;s:1:"1";}s:11:"description";s:213:"Provides a detailed report for Contributions made by contributors(Or Household itself) who are having a relationship with household (For ex a Contributor is Head of Household for some household or is a member of.)";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:21:"access CiviContribute";s:6:"groups";s:0:"";s:9:"domain_id";i:1;}');
753 SET @instanceID:=LAST_INSERT_ID();
754 INSERT INTO civicrm_navigation
755 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
756 VALUES
757 ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'Contributions by Household Report', 'Contributions by Household Report', 'access CiviContribute', '', @reportlastID, '1', NULL, @instanceID+2 );
758 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
759
760 INSERT INTO `civicrm_report_instance`
761 ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
762 VALUES
763 ( @domainID, 'Top Donors Report', 'contribute/topDonor', '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).', 'access CiviContribute', 'a:20:{s:6:"fields";a:2:{s:12:"display_name";s:1:"1";s:12:"total_amount";s:1:"1";}s:21:"receive_date_relative";s:9:"this.year";s:17:"receive_date_from";s:0:"";s:15:"receive_date_to";s:0:"";s:15:"total_range_min";s:0:"";s:15:"total_range_max";s:0:"";s:14:"total_range_op";s:2:"eq";s:17:"total_range_value";s:0:"";s:23:"contribution_type_id_op";s:2:"in";s:26:"contribution_type_id_value";a:0:{}s:25:"contribution_status_id_op";s:2:"in";s:28:"contribution_status_id_value";a:1:{i:0;s:1:"1";}s:6:"gid_op";s:2:"in";s:9:"gid_value";a:0:{}s:11:"description";s:148:"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).";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:21:"access CiviContribute";s:6:"groups";s:0:"";}');
764 SET @instanceID:=LAST_INSERT_ID();
765 INSERT INTO civicrm_navigation
766 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
767 VALUES
768 ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'Top Donors Report', 'Top Donors Report', 'access CiviContribute', '', @reportlastID, '1', NULL, @instanceID+2 );
769 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
770
771 INSERT INTO `civicrm_report_instance`
772 ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
773 VALUES
774 ( @domainID, 'Soft Credit Report', 'contribute/softcredit', 'Shows contributions made by contacts that have been soft-credited to other contacts.', 'access CiviContribute', 'a:23:{s:6:"fields";a:5:{s:21:"display_name_creditor";s:1:"1";s:24:"display_name_constituent";s:1:"1";s:14:"email_creditor";s:1:"1";s:14:"phone_creditor";s:1:"1";s:12:"total_amount";s:1:"1";}s:5:"id_op";s:2:"in";s:8:"id_value";a:0:{}s:21:"receive_date_relative";s:1:"0";s:17:"receive_date_from";s:0:"";s:15:"receive_date_to";s:0:"";s:25:"contribution_status_id_op";s:2:"in";s:28:"contribution_status_id_value";a:1:{i:0;s:1:"1";}s:16:"total_amount_min";s:0:"";s:16:"total_amount_max";s:0:"";s:15:"total_amount_op";s:3:"lte";s:18:"total_amount_value";s:0:"";s:6:"gid_op";s:2:"in";s:9:"gid_value";a:0:{}s:8:"tagid_op";s:2:"in";s:11:"tagid_value";a:0:{}s:11:"description";s:20:"Soft Credit details.";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:21:"access CiviContribute";s:6:"groups";s:0:"";s:9:"domain_id";i:1;}');
775 SET @instanceID:=LAST_INSERT_ID();
776 INSERT INTO civicrm_navigation
777 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
778 VALUES
779 ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'Soft Credit Report', 'Soft Credit Report', 'access CiviContribute', '', @reportlastID, '1', NULL, @instanceID+2 );
780 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
781
782
783 INSERT INTO `civicrm_report_instance`
784 ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
785 VALUES
786 ( @domainID, 'Personal Campaign Page Summary', 'contribute/pcp', 'Summarizes amount raised and number of contributors for each Personal Campaign Page.', 'access CiviContribute', 'a:22:{s:6:"fields";a:8:{s:9:"sort_name";s:1:"1";s:10:"page_title";s:1:"1";s:5:"title";s:1:"1";s:11:"goal_amount";s:1:"1";s:8:"amount_1";s:1:"1";s:8:"amount_2";s:1:"1";s:7:"soft_id";s:1:"1";s:12:"receive_date";s:1:"1";}s:12:"sort_name_op";s:3:"has";s:15:"sort_name_value";s:0:"";s:6:"id_min";s:0:"";s:6:"id_max";s:0:"";s:5:"id_op";s:3:"lte";s:8:"id_value";s:0:"";s:13:"page_title_op";s:3:"has";s:16:"page_title_value";s:0:"";s:8:"title_op";s:3:"has";s:11:"title_value";s:0:"";s:12:"amount_2_min";s:0:"";s:12:"amount_2_max";s:0:"";s:11:"amount_2_op";s:3:"lte";s:14:"amount_2_value";s:0:"";s:11:"description";s:35:"Shows Personal Campaign Page Report";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:21:"access CiviContribute";s:6:"groups";s:0:"";s:9:"domain_id";i:1;}');
787 SET @instanceID:=LAST_INSERT_ID();
788 INSERT INTO civicrm_navigation
789 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
790 VALUES
791 ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'Personal Campaign Page Summary', 'Personal Campaign Page Summary', 'access CiviContribute', '', @reportlastID, '1', NULL, @instanceID+2 );
792 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
793
794
795 INSERT INTO `civicrm_report_instance`
796 ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
797 VALUES
798 ( @domainID, 'Pledge Summary Report', 'pledge/detail', 'Summary of pledges including amount pledged, pledge status, next payment date, balance due, total amount paid etc.', 'access CiviPledge', 'a:27:{s:6:"fields";a:4:{s:9:"sort_name";s:1:"1";s:10:"country_id";s:1:"1";s:6:"amount";s:1:"1";s:9:"status_id";s:1:"1";}s:12:"sort_name_op";s:3:"has";s:15:"sort_name_value";s:0:"";s:6:"id_min";s:0:"";s:6:"id_max";s:0:"";s:5:"id_op";s:3:"lte";s:8:"id_value";s:0:"";s:27:"pledge_create_date_relative";s:1:"0";s:23:"pledge_create_date_from";s:0:"";s:21:"pledge_create_date_to";s:0:"";s:17:"pledge_amount_min";s:0:"";s:17:"pledge_amount_max";s:0:"";s:16:"pledge_amount_op";s:3:"lte";s:19:"pledge_amount_value";s:0:"";s:6:"sid_op";s:2:"in";s:9:"sid_value";a:0:{}s:6:"gid_op";s:2:"in";s:9:"gid_value";a:0:{}s:8:"tagid_op";s:2:"in";s:11:"tagid_value";a:0:{}s:11:"description";s:13:"Pledge Report";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:17:"access CiviPledge";s:6:"groups";s:0:"";s:9:"domain_id";i:1;}');
799 SET @instanceID:=LAST_INSERT_ID();
800 INSERT INTO civicrm_navigation
801 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
802 VALUES
803 ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'Pledge Summary Report', 'Pledge Summary Report', 'access CiviPledge', '', @reportlastID, '1', NULL, @instanceID+2 );
804 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
805
806 INSERT INTO `civicrm_report_instance`
807 ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
808 VALUES
809 ( @domainID, 'Pledged But not Paid Report', 'pledge/pbnp', 'Pledged but not Paid Report', 'access CiviPledge', 'a:17:{s:6:"fields";a:5:{s:9:"sort_name";s:1:"1";s:18:"pledge_create_date";s:1:"1";s:6:"amount";s:1:"1";s:14:"scheduled_date";s:1:"1";s:10:"country_id";s:1:"1";}s:27:"pledge_create_date_relative";s:1:"0";s:23:"pledge_create_date_from";s:0:"";s:21:"pledge_create_date_to";s:0:"";s:23:"contribution_type_id_op";s:2:"in";s:26:"contribution_type_id_value";a:0:{}s:6:"gid_op";s:2:"in";s:9:"gid_value";a:0:{}s:8:"tagid_op";s:2:"in";s:11:"tagid_value";a:0:{}s:11:"description";s:27:"Pledged but not Paid Report";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:17:"access CiviPledge";s:6:"groups";s:0:"";s:9:"domain_id";i:1;}');
810 SET @instanceID:=LAST_INSERT_ID();
811 INSERT INTO civicrm_navigation
812 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
813 VALUES
814 ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'Pledged But not Paid Report', 'Pledged But not Paid Report', 'access CiviPledge', '', @reportlastID, '1', NULL, @instanceID+2 );
815 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
816
817 INSERT INTO `civicrm_report_instance`
818 ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
819 VALUES
820 ( @domainID, 'Bookkeeping Transactions Report', 'contribute/bookkeeping', 'Shows Bookkeeping Transactions Report', 'access CiviContribute', 'a:25:{s:6:"fields";a:10:{s:9:"sort_name";s:1:"1";s:12:"receive_date";s:1:"1";s:12:"total_amount";s:1:"1";s:20:"contribution_type_id";s:1:"1";s:7:"trxn_id";s:1:"1";s:10:"invoice_id";s:1:"1";s:12:"check_number";s:1:"1";s:21:"payment_instrument_id";s:1:"1";s:22:"contribution_status_id";s:1:"1";s:2:"id";s:1:"1";}s:12:"sort_name_op";s:3:"has";s:15:"sort_name_value";s:0:"";s:6:"id_min";s:0:"";s:6:"id_max";s:0:"";s:5:"id_op";s:3:"lte";s:8:"id_value";s:0:"";s:21:"receive_date_relative";s:1:"0";s:17:"receive_date_from";s:0:"";s:15:"receive_date_to";s:0:"";s:23:"contribution_type_id_op";s:2:"in";s:26:"contribution_type_id_value";a:0:{}s:25:"contribution_status_id_op";s:2:"in";s:28:"contribution_status_id_value";a:1:{i:0;s:1:"1";}s:16:"total_amount_min";s:0:"";s:16:"total_amount_max";s:0:"";s:15:"total_amount_op";s:3:"lte";s:18:"total_amount_value";s:0:"";s:11:"description";s:37:"Shows Bookkeeping Transactions Report";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:21:"access CiviContribute";s:6:"groups";s:0:"";s:9:"domain_id";i:1;}');
821 SET @instanceID:=LAST_INSERT_ID();
822 INSERT INTO civicrm_navigation
823 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
824 VALUES
825 ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'Bookkeeping Transactions Report', 'Bookkeeping Transactions Report', 'access CiviContribute', '', @reportlastID, '1', NULL, @instanceID+2 );
826
827 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
828
829
830 INSERT INTO `civicrm_report_instance`
831 ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
832 VALUES
833 ( @domainID, 'Membership Report (Summary)', 'member/summary', 'Provides a summary of memberships by type and join date.', 'access CiviMember', 'a:18:{s:6:"fields";a:2:{s:18:"membership_type_id";s:1:"1";s:12:"total_amount";s:1:"1";}s:18:"join_date_relative";s:1:"0";s:14:"join_date_from";s:0:"";s:12:"join_date_to";s:0:"";s:21:"membership_type_id_op";s:2:"in";s:24:"membership_type_id_value";a:0:{}s:12:"status_id_op";s:2:"in";s:15:"status_id_value";a:0:{}s:25:"contribution_status_id_op";s:2:"in";s:28:"contribution_status_id_value";a:0:{}s:9:"group_bys";a:2:{s:9:"join_date";s:1:"1";s:18:"membership_type_id";s:1:"1";}s:14:"group_bys_freq";a:1:{s:9:"join_date";s:5:"MONTH";}s:11:"description";s:56:"Provides a summary of memberships by type and join date.";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:17:"access CiviMember";s:9:"domain_id";i:1;}');
834 SET @instanceID:=LAST_INSERT_ID();
835 INSERT INTO civicrm_navigation
836 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
837 VALUES
838 ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'Membership Report (Summary)', 'Membership Report (Summary)', 'access CiviMember', '', @reportlastID, '1', NULL, @instanceID+2 );
839 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
840
841
842 INSERT INTO `civicrm_report_instance`
843 ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
844 VALUES
845 ( @domainID, 'Membership Report (Detail)', 'member/detail', 'Provides a list of members along with their membership status and membership details (Join Date, Start Date, End Date). Can also display contributions (payments) associated with each membership.', 'access CiviMember', 'a:28:{s:6:"fields";a:5:{s:9:"sort_name";s:1:"1";s:18:"membership_type_id";s:1:"1";s:21:"membership_start_date";s:1:"1";s:19:"membership_end_date";s:1:"1";s:4:"name";s:1:"1";}s:12:"sort_name_op";s:3:"has";s:15:"sort_name_value";s:0:"";s:6:"id_min";s:0:"";s:6:"id_max";s:0:"";s:5:"id_op";s:3:"lte";s:8:"id_value";s:0:"";s:18:"join_date_relative";s:1:"0";s:14:"join_date_from";s:0:"";s:12:"join_date_to";s:0:"";s:23:"owner_membership_id_min";s:0:"";s:23:"owner_membership_id_max";s:0:"";s:22:"owner_membership_id_op";s:3:"lte";s:25:"owner_membership_id_value";s:0:"";s:6:"tid_op";s:2:"in";s:9:"tid_value";a:0:{}s:6:"sid_op";s:2:"in";s:9:"sid_value";a:0:{}s:6:"gid_op";s:2:"in";s:9:"gid_value";a:0:{}s:8:"tagid_op";s:2:"in";s:11:"tagid_value";a:0:{}s:11:"description";s:119:"Provides a list of members along with their membership status and membership details (Join Date, Start Date, End Date).";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:17:"access CiviMember";s:9:"domain_id";i:1;}');
846 SET @instanceID:=LAST_INSERT_ID();
847 INSERT INTO civicrm_navigation
848 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
849 VALUES
850 ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'Membership Report (Detail)', 'Membership Report (Detail)', 'access CiviMember', '', @reportlastID, '1', NULL, @instanceID+2 );
851 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
852
853 -- contribution and membership report
854 INSERT INTO `civicrm_report_instance`
855 ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
856 VALUES
857 ( @domainID, 'Contribution and Membership Details', 'member/contributionDetail', 'Contribution details for any type of contribution, plus associated membership information for contributions which are in payment for memberships.', '', 'a:67:{s:6:"fields";a:12:{s:9:"sort_name";s:1:"1";s:5:"email";s:1:"1";s:5:"phone";s:1:"1";s:20:"contribution_type_id";s:1:"1";s:12:"receive_date";s:1:"1";s:12:"total_amount";s:1:"1";s:18:"membership_type_id";s:1:"1";s:21:"membership_start_date";s:1:"1";s:19:"membership_end_date";s:1:"1";s:9:"join_date";s:1:"1";s:22:"membership_status_name";s:1:"1";s:10:"country_id";s:1:"1";}s:12:"sort_name_op";s:3:"has";s:15:"sort_name_value";s:0:"";s:6:"id_min";s:0:"";s:6:"id_max";s:0:"";s:5:"id_op";s:3:"lte";s:8:"id_value";s:0:"";s:21:"receive_date_relative";s:1:"0";s:17:"receive_date_from";s:0:"";s:15:"receive_date_to";s:0:"";s:23:"contribution_type_id_op";s:2:"in";s:26:"contribution_type_id_value";a:0:{}s:24:"payment_instrument_id_op";s:2:"in";s:27:"payment_instrument_id_value";a:0:{}s:25:"contribution_status_id_op";s:2:"in";s:28:"contribution_status_id_value";a:0:{}s:16:"total_amount_min";s:0:"";s:16:"total_amount_max";s:0:"";s:15:"total_amount_op";s:3:"lte";s:18:"total_amount_value";s:0:"";s:6:"gid_op";s:2:"in";s:9:"gid_value";a:0:{}s:13:"ordinality_op";s:2:"in";s:16:"ordinality_value";a:0:{}s:18:"join_date_relative";s:1:"0";s:14:"join_date_from";s:0:"";s:12:"join_date_to";s:0:"";s:30:"membership_start_date_relative";s:1:"0";s:26:"membership_start_date_from";s:0:"";s:24:"membership_start_date_to";s:0:"";s:28:"membership_end_date_relative";s:1:"0";s:24:"membership_end_date_from";s:0:"";s:22:"membership_end_date_to";s:0:"";s:23:"owner_membership_id_min";s:0:"";s:23:"owner_membership_id_max";s:0:"";s:22:"owner_membership_id_op";s:3:"lte";s:25:"owner_membership_id_value";s:0:"";s:6:"tid_op";s:2:"in";s:9:"tid_value";a:0:{}s:6:"sid_op";s:2:"in";s:9:"sid_value";a:0:{}s:17:"street_number_min";s:0:"";s:17:"street_number_max";s:0:"";s:16:"street_number_op";s:3:"lte";s:19:"street_number_value";s:0:"";s:14:"street_name_op";s:3:"has";s:17:"street_name_value";s:0:"";s:15:"postal_code_min";s:0:"";s:15:"postal_code_max";s:0:"";s:14:"postal_code_op";s:3:"lte";s:17:"postal_code_value";s:0:"";s:7:"city_op";s:3:"has";s:10:"city_value";s:0:"";s:12:"county_id_op";s:2:"in";s:15:"county_id_value";a:0:{}s:20:"state_province_id_op";s:2:"in";s:23:"state_province_id_value";a:0:{}s:13:"country_id_op";s:2:"in";s:16:"country_id_value";a:0:{}s:8:"tagid_op";s:2:"in";s:11:"tagid_value";a:0:{}s:11:"description";s:35:"Contribution and Membership Details";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:1:"0";s:9:"domain_id";i:1;}{s:6:"fields";a:12:{s:9:"sort_name";s:1:"1";s:5:"email";s:1:"1";s:5:"phone";s:1:"1";s:20:"contribution_type_id";s:1:"1";s:12:"receive_date";s:1:"1";s:12:"total_amount";s:1:"1";s:18:"membership_type_id";s:1:"1";s:21:"membership_start_date";s:1:"1";s:19:"membership_end_date";s:1:"1";s:9:"join_date";s:1:"1";s:22:"membership_status_name";s:1:"1";s:10:"country_id";s:1:"1";}s:12:"sort_name_op";s:3:"has";s:15:"sort_name_value";s:0:"";s:6:"id_min";s:0:"";s:6:"id_max";s:0:"";s:5:"id_op";s:3:"lte";s:8:"id_value";s:0:"";s:21:"receive_date_relative";s:1:"0";s:17:"receive_date_from";s:0:"";s:15:"receive_date_to";s:0:"";s:23:"contribution_type_id_op";s:2:"in";s:26:"contribution_type_id_value";a:0:{}s:24:"payment_instrument_id_op";s:2:"in";s:27:"payment_instrument_id_value";a:0:{}s:25:"contribution_status_id_op";s:2:"in";s:28:"contribution_status_id_value";a:0:{}s:16:"total_amount_min";s:0:"";s:16:"total_amount_max";s:0:"";s:15:"total_amount_op";s:3:"lte";s:18:"total_amount_value";s:0:"";s:6:"gid_op";s:2:"in";s:9:"gid_value";a:0:{}s:13:"ordinality_op";s:2:"in";s:16:"ordinality_value";a:0:{}s:18:"join_date_relative";s:1:"0";s:14:"join_date_from";s:0:"";s:12:"join_date_to";s:0:"";s:30:"membership_start_date_relative";s:1:"0";s:26:"membership_start_date_from";s:0:"";s:24:"membership_start_date_to";s:0:"";s:28:"membership_end_date_relative";s:1:"0";s:24:"membership_end_date_from";s:0:"";s:22:"membership_end_date_to";s:0:"";s:23:"owner_membership_id_min";s:0:"";s:23:"owner_membership_id_max";s:0:"";s:22:"owner_membership_id_op";s:3:"lte";s:25:"owner_membership_id_value";s:0:"";s:6:"tid_op";s:2:"in";s:9:"tid_value";a:0:{}s:6:"sid_op";s:2:"in";s:9:"sid_value";a:0:{}s:17:"street_number_min";s:0:"";s:17:"street_number_max";s:0:"";s:16:"street_number_op";s:3:"lte";s:19:"street_number_value";s:0:"";s:14:"street_name_op";s:3:"has";s:17:"street_name_value";s:0:"";s:15:"postal_code_min";s:0:"";s:15:"postal_code_max";s:0:"";s:14:"postal_code_op";s:3:"lte";s:17:"postal_code_value";s:0:"";s:7:"city_op";s:3:"has";s:10:"city_value";s:0:"";s:12:"county_id_op";s:2:"in";s:15:"county_id_value";a:0:{}s:20:"state_province_id_op";s:2:"in";s:23:"state_province_id_value";a:0:{}s:13:"country_id_op";s:2:"in";s:16:"country_id_value";a:0:{}s:8:"tagid_op";s:2:"in";s:11:"tagid_value";a:0:{}s:11:"description";s:35:"Contribution and Membership Details";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:1:"0";s:9:"domain_id";i:1;}');
858 SET @instanceID:=LAST_INSERT_ID();
859 INSERT INTO civicrm_navigation
860 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
861 VALUES
862 ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'Contribution and Membership Details', 'Contribution and Membership Details', 'access CiviMember', 'AND', @reportlastID, '1', NULL, @instanceID+2 );
863 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
864
865 INSERT INTO `civicrm_report_instance`
866 ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
867 VALUES
868 ( @domainID, 'Membership Report (Lapsed)', 'member/lapse', 'Provides a list of memberships that lapsed or will lapse before the date you specify.', 'access CiviMember', 'a:16:{s:6:"fields";a:5:{s:9:"sort_name";s:1:"1";s:18:"membership_type_id";s:1:"1";s:19:"membership_end_date";s:1:"1";s:4:"name";s:1:"1";s:10:"country_id";s:1:"1";}s:6:"tid_op";s:2:"in";s:9:"tid_value";a:0:{}s:28:"membership_end_date_relative";s:1:"0";s:24:"membership_end_date_from";s:0:"";s:22:"membership_end_date_to";s:0:"";s:6:"gid_op";s:2:"in";s:9:"gid_value";a:0:{}s:8:"tagid_op";s:2:"in";s:11:"tagid_value";a:0:{}s:11:"description";s:85:"Provides a list of memberships that lapsed or will lapse before the date you specify.";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:17:"access CiviMember";s:9:"domain_id";i:1;}');
869 SET @instanceID:=LAST_INSERT_ID();
870 INSERT INTO civicrm_navigation
871 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
872 VALUES
873 ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'Membership Report (Lapsed)', 'Membership Report (Lapsed)', 'access CiviMember', '', @reportlastID, '1', NULL, @instanceID+2 );
874 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
875
876
877 INSERT INTO `civicrm_report_instance`
878 ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
879 VALUES
880 ( @domainID, 'Event Participant Report (List)', 'event/participantListing', 'Provides lists of participants for an event.', 'access CiviEvent', 'a:27:{s:6:"fields";a:4:{s:9:"sort_name";s:1:"1";s:8:"event_id";s:1:"1";s:9:"status_id";s:1:"1";s:7:"role_id";s:1:"1";}s:12:"sort_name_op";s:3:"has";s:15:"sort_name_value";s:0:"";s:8:"email_op";s:3:"has";s:11:"email_value";s:0:"";s:11:"event_id_op";s:2:"in";s:14:"event_id_value";a:0:{}s:6:"sid_op";s:2:"in";s:9:"sid_value";a:0:{}s:6:"rid_op";s:2:"in";s:9:"rid_value";a:0:{}s:34:"participant_register_date_relative";s:1:"0";s:30:"participant_register_date_from";s:0:"";s:28:"participant_register_date_to";s:0:"";s:6:"eid_op";s:2:"in";s:9:"eid_value";a:0:{}s:11:"custom_4_op";s:2:"in";s:14:"custom_4_value";a:0:{}s:16:"blank_column_end";s:0:"";s:11:"description";s:44:"Provides lists of participants for an event.";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:16:"access CiviEvent";s:6:"groups";s:0:"";s:7:"options";N;s:9:"domain_id";i:1;}');
881 SET @instanceID:=LAST_INSERT_ID();
882 INSERT INTO civicrm_navigation
883 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
884 VALUES
885 ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'Event Participant Report (List)', 'Event Participant Report (List)', 'access CiviEvent', '', @reportlastID, '1', NULL, @instanceID+2 );
886 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
887
888
889 INSERT INTO `civicrm_report_instance`
890 ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
891 VALUES
892 ( @domainID, 'Event Income Report (Summary)', 'event/summary', '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.', 'access CiviEvent', 'a:18:{s:6:"fields";a:2:{s:5:"title";s:1:"1";s:13:"event_type_id";s:1:"1";}s:5:"id_op";s:2:"in";s:8:"id_value";a:0:{}s:16:"event_type_id_op";s:2:"in";s:19:"event_type_id_value";a:0:{}s:25:"event_start_date_relative";s:1:"0";s:21:"event_start_date_from";s:0:"";s:19:"event_start_date_to";s:0:"";s:23:"event_end_date_relative";s:1:"0";s:19:"event_end_date_from";s:0:"";s:17:"event_end_date_to";s:0:"";s:11:"description";s:181:"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.";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:16:"access CiviEvent";s:6:"charts";s:0:"";s:9:"domain_id";i:1;}');
893 SET @instanceID:=LAST_INSERT_ID();
894 INSERT INTO civicrm_navigation
895 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
896 VALUES
897 ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'Event Income Report (Summary)', 'Event Income Report (Summary)', 'access CiviEvent', '', @reportlastID, '1', NULL, @instanceID+2 );
898 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
899
900
901 INSERT INTO `civicrm_report_instance`
902 ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
903 VALUES
904 ( @domainID, 'Event Income Report (Detail)', 'event/income', 'Helps you to analyze the income generated by an event. The report can include details by participant type, status and payment method.', 'access CiviEvent', 'a:7:{s:5:"id_op";s:2:"in";s:8:"id_value";N;s:11:"description";s:133:"Helps you to analyze the income generated by an event. The report can include details by participant type, status and payment method.";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:16:"access CiviEvent";}');
905 SET @instanceID:=LAST_INSERT_ID();
906 INSERT INTO civicrm_navigation
907 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
908 VALUES
909 ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'Event Income Report (Detail)', 'Event Income Report (Detail)', 'access CiviEvent', '', @reportlastID, '1', NULL, @instanceID+2 );
910 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
911
912
913 INSERT INTO `civicrm_report_instance`
914 ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
915 VALUES
916 ( @domainID, 'Attendee List', 'event/participantListing', 'Provides lists of event attendees.', 'access CiviEvent', 'a:27:{s:6:"fields";a:4:{s:9:"sort_name";s:1:"1";s:8:"event_id";s:1:"1";s:9:"status_id";s:1:"1";s:7:"role_id";s:1:"1";}s:12:"sort_name_op";s:3:"has";s:15:"sort_name_value";s:0:"";s:8:"email_op";s:3:"has";s:11:"email_value";s:0:"";s:11:"event_id_op";s:2:"in";s:14:"event_id_value";a:0:{}s:6:"sid_op";s:2:"in";s:9:"sid_value";a:0:{}s:6:"rid_op";s:2:"in";s:9:"rid_value";a:0:{}s:34:"participant_register_date_relative";s:1:"0";s:30:"participant_register_date_from";s:0:"";s:28:"participant_register_date_to";s:0:"";s:6:"eid_op";s:2:"in";s:9:"eid_value";a:0:{}s:11:"custom_4_op";s:2:"in";s:14:"custom_4_value";a:0:{}s:16:"blank_column_end";s:0:"";s:11:"description";s:44:"Provides lists of participants for an event.";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:16:"access CiviEvent";s:6:"groups";s:0:"";s:7:"options";N;s:9:"domain_id";i:1;}');
917 SET @instanceID:=LAST_INSERT_ID();
918 INSERT INTO civicrm_navigation
919 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
920 VALUES
921 ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'Attendee List', 'Attendee List', 'access CiviEvent', '', @reportlastID, '1', NULL, @instanceID+2 );
922 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
923
924
925 INSERT INTO `civicrm_report_instance`
926 ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
927 VALUES
928 ( @domainID, 'Grant Report (Detail)', 'grant/detail', 'Grant Report Detail', 'access CiviGrant', 'a:40:{s:6:"fields";a:2:{s:9:"sort_name";s:1:"1";s:25:"application_received_date";s:1:"1";}s:12:"sort_name_op";s:3:"has";s:15:"sort_name_value";s:0:"";s:12:"gender_id_op";s:2:"in";s:15:"gender_id_value";a:0:{}s:6:"id_min";s:0:"";s:6:"id_max";s:0:"";s:5:"id_op";s:3:"lte";s:8:"id_value";s:0:"";s:13:"country_id_op";s:2:"in";s:16:"country_id_value";a:0:{}s:20:"state_province_id_op";s:2:"in";s:23:"state_province_id_value";a:0:{}s:13:"grant_type_op";s:2:"in";s:16:"grant_type_value";a:0:{}s:12:"status_id_op";s:2:"in";s:15:"status_id_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:19:"Grant Report Detail";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;}');
929 SET @instanceID:=LAST_INSERT_ID( );
930 INSERT INTO civicrm_navigation
931 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
932 VALUES
933 ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'Grant Report (Detail)', 'Grant Report Detail', 'access CiviGrant', '',@reportlastID, '1', NULL, @instanceID+2 );
934 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
935
936
937 INSERT INTO `civicrm_report_instance`
938 ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
939 VALUES
940 ( @domainID, 'Grant Report (Statistics)', 'grant/statistics', 'Grant Report Statistics', 'access CiviGrant', 'a:42:{s:6:"fields";a:2:{s:18:"summary_statistics";s:1:"1";s:13:"grant_type_id";s:1:"1";}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:22:"decision_date_relative";s:1:"0";s:18:"decision_date_from";s:0:"";s:16:"decision_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:13:"grant_type_op";s:2:"in";s:16:"grant_type_value";a:0:{}s:12:"status_id_op";s:2:"in";s:15:"status_id_value";a: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: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:24:"grant_report_received_op";s:2:"eq";s:27:"grant_report_received_value";s:0:"";s:12:"gender_id_op";s:2:"in";s:15:"gender_id_value";a:0:{}s:15:"contact_type_op";s:2:"in";s:18:"contact_type_value";a:0:{}s:12:"region_id_op";s:2:"in";s:15:"region_id_value";a:0:{}s:13:"country_id_op";s:2:"in";s:16:"country_id_value";a:0:{}s:11:"description";s:23:"Grant Report Statistics";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:1:"0";s:9:"parent_id";s:0:"";s:9:"domain_id";i:1;}');
941 SET @instanceID:=LAST_INSERT_ID( );
942 INSERT INTO civicrm_navigation
943 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
944 VALUES
945 ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'Grant Report (Statistics)', 'Grant Report Statistics', 'access CiviGrant', '',@reportlastID, '1', NULL, @instanceID+2 );
946 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
947
948
949 INSERT INTO `civicrm_report_instance`
950 ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
951 VALUES
952 ( @domainID, 'Mail Bounce Report', 'Mailing/bounce', 'Bounce Report for mailings', 'access CiviMail', 'a:33:{s:6:"fields";a:5:{s:2:"id";s:1:"1";s:10:"first_name";s:1:"1";s:9:"last_name";s:1:"1";s:11:"bounce_name";s:1:"1";s:5:"email";s:1:"1";}s:12:"sort_name_op";s:3:"has";s:15:"sort_name_value";s:0:"";s:9:"source_op";s:3:"has";s:12:"source_value";s:0:"";s:6:"id_min";s:0:"";s:6:"id_max";s:0:"";s:5:"id_op";s:3:"lte";s:8:"id_value";s:0:"";s:15:"mailing_name_op";s:2:"in";s:18:"mailing_name_value";a:0:{}s:19:"bounce_type_name_op";s:2:"eq";s:22:"bounce_type_name_value";s:0:"";s:6:"gid_op";s:2:"in";s:9:"gid_value";a:0:{}s:8:"tagid_op";s:2:"in";s:11:"tagid_value";a:0:{}s:11:"custom_1_op";s:2:"in";s:14:"custom_1_value";a:0:{}s:11:"custom_2_op";s:2:"in";s:14:"custom_2_value";a:0:{}s:17:"custom_3_relative";s:1:"0";s:13:"custom_3_from";s:0:"";s:11:"custom_3_to";s:0:"";s:9:"order_bys";a:1:{i:1;a:1:{s:6:"column";s:1:"-";}}s:11:"description";s:26:"Bounce Report for mailings";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:15:"access CiviMail";s:6:"groups";s:0:"";s:6:"charts";s:0:"";s:9:"domain_id";i:1;}');
953 SET @instanceID:=LAST_INSERT_ID( );
954 INSERT INTO civicrm_navigation
955 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
956 VALUES
957 ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'Mail Bounce Report', 'Mail Bounce Report', 'access CiviMail', '',@reportlastID, '1', NULL, @instanceID+2 );
958 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
959
960
961 INSERT INTO `civicrm_report_instance`
962 ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
963 VALUES
964 ( @domainID, 'Mail Summary Report', 'Mailing/summary','Summary statistics for mailings','access CiviMail','a:25:{s:6:"fields";a:5:{s:4:"name";s:1:"1";s:11:"queue_count";s:1:"1";s:15:"delivered_count";s:1:"1";s:12:"bounce_count";s:1:"1";s:10:"open_count";s:1:"1";}s:15:"is_completed_op";s:2:"eq";s:18:"is_completed_value";s:1:"1";s:15:"mailing_name_op";s:2:"in";s:18:"mailing_name_value";a:0:{}s:9:"status_op";s:3:"has";s:12:"status_value";s:8:"Complete";s:11:"is_test_min";s:0:"";s:11:"is_test_max";s:0:"";s:10:"is_test_op";s:3:"lte";s:13:"is_test_value";s:1:"0";s:19:"start_date_relative";s:9:"this.year";s:15:"start_date_from";s:0:"";s:13:"start_date_to";s:0:"";s:17:"end_date_relative";s:9:"this.year";s:13:"end_date_from";s:0:"";s:11:"end_date_to";s:0:"";s:11:"description";s:31:"Summary statistics for mailings";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:15:"access CiviMail";s:6:"groups";s:0:"";s:6:"charts";s:0:"";s:9:"domain_id";i:1;}');
965 SET @instanceID:=LAST_INSERT_ID( );
966 INSERT INTO civicrm_navigation
967 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
968 VALUES
969 ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'Mail Summary Report', 'Mail Summary Report', 'access CiviMail', '',@reportlastID, '1', NULL, @instanceID+2 );
970 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
971
972
973 INSERT INTO `civicrm_report_instance`
974 ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
975 VALUES
976 ( @domainID, 'Mail Opened Report', 'Mailing/opened', 'Display contacts who opened emails from a mailing', 'access CiviMail', 'a:31:{s:6:"fields";a:5:{s:2:"id";s:1:"1";s:10:"first_name";s:1:"1";s:9:"last_name";s:1:"1";s:12:"mailing_name";s:1:"1";s:5:"email";s:1:"1";}s:12:"sort_name_op";s:3:"has";s:15:"sort_name_value";s:0:"";s:9:"source_op";s:3:"has";s:12:"source_value";s:0:"";s:6:"id_min";s:0:"";s:6:"id_max";s:0:"";s:5:"id_op";s:3:"lte";s:8:"id_value";s:0:"";s:15:"mailing_name_op";s:2:"in";s:18:"mailing_name_value";a:0:{}s:6:"gid_op";s:2:"in";s:9:"gid_value";a:0:{}s:8:"tagid_op";s:2:"in";s:11:"tagid_value";a:0:{}s:11:"custom_1_op";s:2:"in";s:14:"custom_1_value";a:0:{}s:11:"custom_2_op";s:2:"in";s:14:"custom_2_value";a:0:{}s:17:"custom_3_relative";s:1:"0";s:13:"custom_3_from";s:0:"";s:11:"custom_3_to";s:0:"";s:9:"order_bys";a:1:{i:1;a:1:{s:6:"column";s:1:"-";}}s:11:"description";s:49:"Display contacts who opened emails from a mailing";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:15:"access CiviMail";s:6:"groups";s:0:"";s:6:"charts";s:0:"";s:9:"domain_id";i:1;}');
977 SET @instanceID:=LAST_INSERT_ID( );
978 INSERT INTO civicrm_navigation
979 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
980 VALUES
981 ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'Mail Opened Report', 'Mail Opened Report', 'access CiviMail', '',@reportlastID, '1', NULL, @instanceID+2 );
982 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
983
984
985 INSERT INTO `civicrm_report_instance`
986 ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
987 VALUES
988 ( @domainID, 'Mail Clickthrough Report', 'Mailing/clicks', 'Display clicks from each mailing', 'access CiviMail', 'a:31:{s:6:"fields";a:6:{s:2:"id";s:1:"1";s:10:"first_name";s:1:"1";s:9:"last_name";s:1:"1";s:12:"mailing_name";s:1:"1";s:5:"email";s:1:"1";s:3:"url";s:1:"1";}s:12:"sort_name_op";s:3:"has";s:15:"sort_name_value";s:0:"";s:9:"source_op";s:3:"has";s:12:"source_value";s:0:"";s:6:"id_min";s:0:"";s:6:"id_max";s:0:"";s:5:"id_op";s:3:"lte";s:8:"id_value";s:0:"";s:15:"mailing_name_op";s:2:"in";s:18:"mailing_name_value";a:0:{}s:6:"gid_op";s:2:"in";s:9:"gid_value";a:0:{}s:8:"tagid_op";s:2:"in";s:11:"tagid_value";a:0:{}s:11:"custom_1_op";s:2:"in";s:14:"custom_1_value";a:0:{}s:11:"custom_2_op";s:2:"in";s:14:"custom_2_value";a:0:{}s:17:"custom_3_relative";s:1:"0";s:13:"custom_3_from";s:0:"";s:11:"custom_3_to";s:0:"";s:9:"order_bys";a:1:{i:1;a:1:{s:6:"column";s:1:"-";}}s:11:"description";s:32:"Display clicks from each mailing";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:15:"access CiviMail";s:6:"groups";s:0:"";s:6:"charts";s:0:"";s:9:"domain_id";i:1;}');
989 SET @instanceID:=LAST_INSERT_ID( );
990 INSERT INTO civicrm_navigation
991 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
992 VALUES
993 ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'Mail Clickthrough Report', 'Mail Clickthrough Report', 'access CiviMail', '',@reportlastID, '1', NULL, @instanceID+2 );
994 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
995
996
997 -- walk list survey report.
998 INSERT INTO `civicrm_report_instance`
999 ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
1000 VALUES
1001 ( @domainID, 'Survey Report (Detail)', 'survey/detail', 'Detailed report for canvassing, phone-banking, walk lists or other surveys.', '', 'a:39:{s:6:"fields";a:2:{s:9:"sort_name";s:1:"1";s:6:"result";s:1:"1";}s:22:"assignee_contact_id_op";s:2:"eq";s:25:"assignee_contact_id_value";s:0:"";s:12:"sort_name_op";s:3:"has";s:15:"sort_name_value";s:0:"";s:17:"street_number_min";s:0:"";s:17:"street_number_max";s:0:"";s:16:"street_number_op";s:3:"lte";s:19:"street_number_value";s:0:"";s:14:"street_name_op";s:3:"has";s:17:"street_name_value";s:0:"";s:15:"postal_code_min";s:0:"";s:15:"postal_code_max";s:0:"";s:14:"postal_code_op";s:3:"lte";s:17:"postal_code_value";s:0:"";s:7:"city_op";s:3:"has";s:10:"city_value";s:0:"";s:20:"state_province_id_op";s:2:"in";s:23:"state_province_id_value";a:0:{}s:13:"country_id_op";s:2:"in";s:16:"country_id_value";a:0:{}s:12:"survey_id_op";s:2:"in";s:15:"survey_id_value";a:0:{}s:12:"status_id_op";s:2:"eq";s:15:"status_id_value";s:1:"1";s:11:"custom_1_op";s:2:"in";s:14:"custom_1_value";a:0:{}s:11:"custom_2_op";s:2:"in";s:14:"custom_2_value";a:0:{}s:17:"custom_3_relative";s:1:"0";s:13:"custom_3_from";s:0:"";s:11:"custom_3_to";s:0:"";s:11:"description";s:75:"Detailed report for canvassing, phone-banking, walk lists or other surveys.";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:1:"0";s:6:"groups";s:0:"";s:9:"domain_id";i:1;}');
1002 SET @instanceID:=LAST_INSERT_ID();
1003 INSERT INTO civicrm_navigation
1004 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
1005 VALUES
1006 ( @domainID, CONCAT('civicrm/report/instance/', @instanceID, '&reset=1'), 'Survey Report (Detail)', 'Survey Report (Detail)', 'administer CiviCampaign,manage campaign,interview campaign contacts', 'OR', @reportlastID, '1', NULL, @instanceID+2 );
1007 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
1008
1009 -- mailing detail report
1010 INSERT INTO `civicrm_report_instance`
1011 ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
1012 VALUES
1013 ( @domainID, 'Mailing Detail Report', 'mailing/detail', 'Provides reporting on Intended and Successful Deliveries, Unsubscribes and Opt-outs, Replies and Forwards.', '', 'a:30:{s:6:"fields";a:6:{s:9:"sort_name";s:1:"1";s:12:"mailing_name";s:1:"1";s:11:"delivery_id";s:1:"1";s:14:"unsubscribe_id";s:1:"1";s:9:"optout_id";s:1:"1";s:5:"email";s:1:"1";}s:12:"sort_name_op";s:3:"has";s:15:"sort_name_value";s:0:"";s:6:"id_min";s:0:"";s:6:"id_max";s:0:"";s:5:"id_op";s:3:"lte";s:8:"id_value";s:0:"";s:13:"mailing_id_op";s:2:"in";s:16:"mailing_id_value";a:0:{}s:18:"delivery_status_op";s:2:"eq";s:21:"delivery_status_value";s:0:"";s:18:"is_unsubscribed_op";s:2:"eq";s:21:"is_unsubscribed_value";s:0:"";s:12:"is_optout_op";s:2:"eq";s:15:"is_optout_value";s:0:"";s:13:"is_replied_op";s:2:"eq";s:16:"is_replied_value";s:0:"";s:15:"is_forwarded_op";s:2:"eq";s:18:"is_forwarded_value";s:0:"";s:6:"gid_op";s:2:"in";s:9:"gid_value";a:0:{}s:9:"order_bys";a:1:{i:1;a:2:{s:6:"column";s:9:"sort_name";s:5:"order";s:3:"ASC";}}s:11:"description";s:21:"Mailing Detail Report";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:1:"0";s:9:"parent_id";s:0:"";s:6:"groups";s:0:"";s:9:"domain_id";i:1;}');
1014 SET @instanceID:=LAST_INSERT_ID();
1015 INSERT INTO civicrm_navigation
1016 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
1017 VALUES
1018 ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'Mailing Detail Report', 'Mailing Detail Report', 'administer CiviMail', 'OR', @reportlastID, '1', NULL, @instanceID+2 );
1019 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
1020 UPDATE civicrm_domain SET version = '4.6.alpha1';