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)
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);
9 SELECT @addId := id from civicrm_address where street_address = '15 Main St';
11 INSERT INTO civicrm_email (contact_id, location_type_id, email, is_primary, is_billing, on_hold, hold_date, reset_date)
13 (@contactID, 1, 'domainemail2@example.org', 1, 0, 0, NULL, NULL);
15 SELECT @emailId := id from civicrm_email where email = 'domainemail2@example.org';
17 INSERT INTO civicrm_phone (contact_id, location_type_id, is_primary, is_billing, mobile_provider_id, phone, phone_type_id)
19 (@contactID, 1, 1, 0, NULL,'204 555-1001', 1);
21 SELECT @phoneId := id from civicrm_phone where phone = '204 555-1001';
23 INSERT INTO civicrm_loc_block ( address_id, email_id, phone_id, address_2_id, email_2_id, phone_2_id)
25 ( @addId, @emailId, @phoneId, NULL,NULL,NULL);
27 SELECT @locBlockId := id from civicrm_loc_block where phone_id = @phoneId AND email_id = @emailId AND address_id = @addId;
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';
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`)
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 ),
38 -- Mail Approval Status Preferences
39 (@option_group_id_mail_approval_status, 'Approved' , 1, 'Approved', NULL, 0, 1, 1, NULL, 0, 1, 1, @mailCompId, @domainID, NULL),
40 (@option_group_id_mail_approval_status, 'Rejected' , 2, 'Rejected', NULL, 0, 0, 2, NULL, 0, 1, 1, @mailCompId, @domainID, NULL),
41 (@option_group_id_mail_approval_status, 'None' , 3, 'None', NULL, 0, 0, 3, NULL, 0, 1, 1, @mailCompId, @domainID, NULL);
42 INSERT INTO `civicrm_job`
43 ( domain_id, run_frequency, last_run, name, description, api_entity, api_action, parameters, is_active )
45 ( @domainID, 'Always' , NULL, 'Send Scheduled Mailings', 'Sends out scheduled CiviMail mailings', 'job', 'process_mailing', NULL, 0),
46 ( @domainID, 'Hourly' , NULL, 'Fetch Bounces', 'Fetches bounces from mailings and writes them to mailing statistics', 'job', 'fetch_bounces', NULL, 0),
47 ( @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),
48 ( @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),
49 ( @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),
50 ( @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),
51 ( @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),
52 ( @domainID, 'Hourly' , NULL, 'Send Scheduled Reminders', 'Sends out scheduled reminders via email', 'job', 'send_reminder', NULL, 0),
53 ( @domainID, 'Always' , NULL, 'Update Participant Statuses', 'Updates pending event participant statuses based on time', 'job', 'process_participant', NULL, 0),
54 ( @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),
55 ( @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),
56 ( @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);
57 -- Initial default state of system settings
59 INSERT INTO `civicrm_dashboard`
60 ( `domain_id`, `label`, `url`, `permission`, `permission_operator`, `is_active`, `fullscreen_url`, `is_reserved`)
62 ( @domainID, 'Activities', 'civicrm/dashlet/activity&reset=1&snippet=5', 'access CiviCRM', NULL, 1, 'civicrm/dashlet/activity&reset=1&snippet=5&context=dashletFullscreen', 1),
63 ( @domainID, 'My Cases', 'civicrm/dashlet/myCases&reset=1&snippet=5', 'access my cases and activities', NULL, 1, 'civicrm/dashlet/myCases&reset=1&snippet=5&context=dashletFullscreen', 1),
64 ( @domainID, 'All Cases', 'civicrm/dashlet/allCases&reset=1&snippet=5', 'access all cases and activities', NULL, 1, 'civicrm/dashlet/allCases&reset=1&snippet=5&context=dashletFullscreen', 1),
65 ( @domainID, 'Case Dashboard Dashlet', 'civicrm/dashlet/casedashboard&reset=1&snippet=5', 'access my cases and activities,access all cases and activities', 'OR', 1, 'civicrm/dashlet/casedashboard&reset=1&snippet=5&context=dashletFullscreen', 1);
69 INSERT INTO civicrm_navigation
70 ( domain_id, label, name, url, permission, permission_operator, parent_id, is_active, has_separator, weight )
72 ( @domainID, 'Home', 'Home', 'civicrm/dashboard&reset=1', NULL, '', NULL, 1, NULL, 0);
74 INSERT INTO civicrm_navigation
75 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
77 ( @domainID, NULL, 'Search', 'Search...', NULL, '', NULL, '1', NULL, 10 );
79 SET @searchlastID:=LAST_INSERT_ID();
81 INSERT INTO civicrm_navigation
82 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
84 ( @domainID, 'civicrm/contact/search&reset=1', 'Find Contacts', 'Find Contacts', NULL, '', @searchlastID, '1', NULL, 1 ),
85 ( @domainID, 'civicrm/contact/search/advanced&reset=1', 'Advanced Search', 'Advanced Search', NULL, '', @searchlastID, '1', NULL, 2 ),
86 ( @domainID, 'civicrm/contact/search/custom&csid=15&reset=1', 'Full-text Search', 'Full-text Search', NULL, '', @searchlastID, '1', NULL, 3 ),
87 ( @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 ),
88 ( @domainID, 'civicrm/contribute/search&reset=1', 'Find Contributions', 'Find Contributions', 'access CiviContribute', '', @searchlastID, '1', NULL, 6 ),
89 ( @domainID, 'civicrm/mailing&reset=1', 'Find Mailings', 'Find Mailings', 'access CiviMail', '', @searchlastID, '1', NULL, 7 ),
90 ( @domainID, 'civicrm/member/search&reset=1', 'Find Memberships', 'Find Memberships', 'access CiviMember', '', @searchlastID, '1', NULL, 8 ),
91 ( @domainID, 'civicrm/event/search&reset=1', 'Find Participants', 'Find Participants', 'access CiviEvent', '', @searchlastID, '1', NULL, 9 ),
92 ( @domainID, 'civicrm/pledge/search&reset=1', 'Find Pledges', 'Find Pledges', 'access CiviPledge', '', @searchlastID, '1', NULL, 10 ),
93 ( @domainID, 'civicrm/activity/search&reset=1', 'Find Activities', 'Find Activities', NULL, '', @searchlastID, '1', '1', 11 );
95 INSERT INTO civicrm_navigation
96 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
98 ( @domainID, 'civicrm/contact/search/custom/list&reset=1', 'Custom Searches', 'Custom Searches', NULL, '', @searchlastID, '1', NULL, 12 );
100 INSERT INTO civicrm_navigation
101 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
103 ( @domainID, NULL, 'Contacts', 'Contacts', NULL, '', NULL, '1', NULL, 20 );
105 SET @contactlastID:=LAST_INSERT_ID();
106 INSERT INTO civicrm_navigation
107 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
109 ( @domainID, 'civicrm/contact/add&reset=1&ct=Individual', 'New Individual', 'New Individual', 'add contacts', '', @contactlastID, '1', NULL, 1 ),
110 ( @domainID, 'civicrm/contact/add&reset=1&ct=Household', 'New Household', 'New Household', 'add contacts', '', @contactlastID, '1', NULL, 2 ),
111 ( @domainID, 'civicrm/contact/add&reset=1&ct=Organization', 'New Organization', 'New Organization', 'add contacts', '', @contactlastID, '1', 1, 3 );
114 INSERT INTO civicrm_navigation
115 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
117 ( @domainID, 'civicrm/activity&reset=1&action=add&context=standalone', 'New Activity', 'New Activity', NULL, '', @contactlastID, '1', NULL, 4 ),
118 ( @domainID, 'civicrm/activity/email/add&atype=3&action=add&reset=1&context=standalone', 'New Email', 'New Email', NULL, '', @contactlastID, '1', '1', 5 ),
119 ( @domainID, 'civicrm/import/contact&reset=1', 'Import Contacts', 'Import Contacts', 'import contacts', '', @contactlastID, '1', NULL, 6 ),
120 ( @domainID, 'civicrm/import/activity&reset=1', 'Import Activities', 'Import Activities', 'import contacts', '', @contactlastID, '1', '1', 7 ),
121 ( @domainID, 'civicrm/group/add&reset=1', 'New Group', 'New Group', 'edit groups', '', @contactlastID, '1', NULL, 8 ),
122 ( @domainID, 'civicrm/group&reset=1', 'Manage Groups', 'Manage Groups', 'access CiviCRM', '', @contactlastID, '1', '1', 9 ),
123 ( @domainID, 'civicrm/admin/tag&reset=1&action=add', 'New Tag', 'New Tag', 'administer CiviCRM', '', @contactlastID, '1', NULL, 10 ),
124 ( @domainID, 'civicrm/admin/tag&reset=1', 'Manage Tags (Categories)', 'Manage Tags (Categories)', 'administer CiviCRM', '', @contactlastID, '1','1', 11 ),
125 ( @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 );
127 INSERT INTO civicrm_navigation
128 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
130 ( @domainID, NULL, 'Contributions', 'Contributions', 'access CiviContribute', '', NULL, '1', NULL, 30 );
132 SET @contributionlastID:=LAST_INSERT_ID();
133 INSERT INTO civicrm_navigation
134 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
136 ( @domainID, 'civicrm/contribute&reset=1', 'Dashboard', 'Dashboard', 'access CiviContribute', '', @contributionlastID, '1', NULL, 1 ),
137 ( @domainID, 'civicrm/contribute/add&reset=1&action=add&context=standalone', 'New Contribution', 'New Contribution', 'access CiviContribute,edit contributions', 'AND', @contributionlastID, '1', NULL, 2 ),
138 ( @domainID, 'civicrm/contribute/search&reset=1', 'Find Contributions', 'Find Contributions', 'access CiviContribute', '', @contributionlastID, '1', NULL, 3 ),
139 ( @domainID, 'civicrm/batch&reset=1', 'Batches', 'Batches', 'access CiviContribute,access CiviMember', '', @contributionlastID, '1', NULL, 4 ),
140 ( @domainID, 'civicrm/contribute/import&reset=1', 'Import Contributions', 'Import Contributions', 'access CiviContribute,edit contributions', 'AND', @contributionlastID, '1', '1', 5 );
142 INSERT INTO civicrm_navigation
143 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
145 ( @domainID,NULL, 'Pledges', 'Pledges', 'access CiviPledge', '', @contributionlastID, '1', 1, 5 );
147 SET @pledgelastID:=LAST_INSERT_ID();
148 INSERT INTO civicrm_navigation
149 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
151 ( @domainID, 'civicrm/pledge&reset=1', 'Dashboard', 'Dashboard', 'access CiviPledge', '', @pledgelastID, '1', NULL, 1 ),
152 ( @domainID, 'civicrm/pledge/add&reset=1&action=add&context=standalone', 'New Pledge', 'New Pledge', 'access CiviPledge,edit pledges', 'AND', @pledgelastID, '1', NULL, 2 ),
153 ( @domainID, 'civicrm/pledge/search&reset=1', 'Find Pledges', 'Find Pledges', 'access CiviPledge', '', @pledgelastID, '1', NULL, 3 ),
154 ( @domainID, 'civicrm/admin/contribute/add&reset=1&action=add', 'New Contribution Page', 'New Contribution Page', 'access CiviContribute,administer CiviCRM', 'AND', @contributionlastID, '1', NULL, 6 ),
155 ( @domainID, 'civicrm/admin/contribute&reset=1', 'Manage Contribution Pages', 'Manage Contribution Pages', 'access CiviContribute,administer CiviCRM', 'AND', @contributionlastID, '1', '1', 7 ),
156 ( @domainID, 'civicrm/admin/pcp?reset=1&page_type=contribute', 'Personal Campaign Pages', 'Personal Campaign Pages', 'access CiviContribute,administer CiviCRM', 'AND', @contributionlastID, '1', NULL, 8 ),
157 ( @domainID, 'civicrm/admin/contribute/managePremiums&reset=1', 'Premiums (Thank-you Gifts)', 'Premiums', 'access CiviContribute,administer CiviCRM', 'AND', @contributionlastID, '1', 1, 9 ),
158 ( @domainID, 'civicrm/admin/price&reset=1&action=add', 'New Price Set', 'New Price Set', 'access CiviContribute,administer CiviCRM', 'AND', @contributionlastID, '1', NULL, 10 ),
159 ( @domainID, 'civicrm/admin/price&reset=1', 'Manage Price Sets', 'Manage Price Sets', 'access CiviContribute,administer CiviCRM', 'AND', @contributionlastID, '1', NULL, 11 );
161 INSERT INTO civicrm_navigation
162 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
164 ( @domainID, NULL, 'Events', 'Events', 'access CiviEvent', '', NULL, '1', NULL, 40 );
166 SET @eventlastID:=LAST_INSERT_ID();
167 INSERT INTO civicrm_navigation
168 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
170 ( @domainID, 'civicrm/event&reset=1', 'Dashboard', 'CiviEvent Dashboard', 'access CiviEvent', '', @eventlastID, '1', NULL, 1 ),
171 ( @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 ),
172 ( @domainID, 'civicrm/event/search&reset=1', 'Find Participants', 'Find Participants', 'access CiviEvent', '', @eventlastID, '1', NULL, 3 ),
173 ( @domainID, 'civicrm/event/import&reset=1', 'Import Participants','Import Participants', 'access CiviEvent,edit event participants', 'AND', @eventlastID, '1', '1', 4 ),
174 ( @domainID, 'civicrm/event/add&reset=1&action=add', 'New Event', 'New Event', 'access CiviEvent,edit all events', 'AND', @eventlastID, '1', NULL, 5 ),
175 ( @domainID, 'civicrm/event/manage&reset=1', 'Manage Events', 'Manage Events', 'access CiviEvent,edit all events', 'AND', @eventlastID, '1', 1, 6 ),
176 ( @domainID, 'civicrm/admin/pcp?reset=1&page_type=event', 'Personal Campaign Pages', 'Personal Campaign Pages', 'access CiviEvent,administer CiviCRM', 'AND', @eventlastID, '1', 1, 7 ),
177 ( @domainID, 'civicrm/admin/eventTemplate&reset=1', 'Event Templates', 'Event Templates', 'access CiviEvent,edit all events', 'AND', @eventlastID, '1', 1, 8 ),
178 ( @domainID, 'civicrm/admin/price&reset=1&action=add', 'New Price Set', 'New Price Set', 'access CiviEvent,edit all events', 'AND', @eventlastID, '1', NULL, 9 ),
179 ( @domainID, 'civicrm/admin/price&reset=1', 'Manage Price Sets', 'Manage Price Sets', 'access CiviEvent,edit all events', 'AND', @eventlastID, '1', NULL, 10 );
181 INSERT INTO civicrm_navigation
182 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
184 ( @domainID, NULL, 'Mailings', 'Mailings', 'access CiviMail,create mailings,approve mailings,schedule mailings', 'OR', NULL, '1', NULL, 50 );
186 SET @mailinglastID:=LAST_INSERT_ID();
187 INSERT INTO civicrm_navigation
188 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
190 ( @domainID, 'civicrm/mailing/send&reset=1', 'New Mailing', 'New Mailing', 'access CiviMail,create mailings', 'OR', @mailinglastID, '1', NULL, 1 ),
191 ( @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 ),
192 ( @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 ),
193 ( @domainID, 'civicrm/mailing/browse/archived&reset=1', 'Archived Mailings', 'Archived Mailings', 'access CiviMail,create mailings', 'OR', @mailinglastID, '1', 1, 4 ),
194 ( @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 ),
195 ( @domainID, 'civicrm/admin/messageTemplates&reset=1', 'Message Templates', 'Message Templates', 'administer CiviCRM', '', @mailinglastID, '1', NULL, 6 ),
196 ( @domainID, 'civicrm/admin/options/from_email&group=from_email_address&reset=1', 'From Email Addresses', 'From Email Addresses', 'administer CiviCRM', '', @mailinglastID, '1', 1, 7 ),
197 ( @domainID, 'civicrm/sms/send?reset=1', 'New SMS', 'New SMS', 'administer CiviCRM', NULL, @mailinglastID, '1', 1, 8 );
198 INSERT INTO civicrm_navigation
199 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
201 ( @domainID, NULL, 'Memberships', 'Memberships', 'access CiviMember', '', NULL, '1', NULL, 60 );
203 SET @memberlastID:=LAST_INSERT_ID();
204 INSERT INTO civicrm_navigation
205 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
207 ( @domainID, 'civicrm/member&reset=1', 'Dashboard', 'Dashboard', 'access CiviMember', '', @memberlastID, '1', NULL, 1 ),
208 ( @domainID, 'civicrm/member/add&reset=1&action=add&context=standalone', 'New Membership', 'New Membership', 'access CiviMember,edit memberships', 'AND', @memberlastID, '1', NULL, 2 ),
209 ( @domainID, 'civicrm/member/search&reset=1', 'Find Memberships', 'Find Memberships','access CiviMember', '', @memberlastID, '1', NULL, 3 ),
210 ( @domainID, 'civicrm/batch&reset=1', 'Batches', 'Batches','access CiviMember,access CiviContribute', '', @memberlastID, '1', NULL, 4 ),
211 ( @domainID, 'civicrm/member/import&reset=1', 'Import Memberships', 'Import Members', 'access CiviMember,edit memberships', 'AND', @memberlastID, '1', 1, 5 ),
212 ( @domainID, 'civicrm/admin/price&reset=1&action=add', 'New Price Set', 'New Price Set', 'access CiviMember,administer CiviCRM', 'AND', @memberlastID, '1', NULL, 6 ),
213 ( @domainID, 'civicrm/admin/price&reset=1', 'Manage Price Sets', 'Manage Price Sets', 'access CiviMember,administer CiviCRM', 'AND', @memberlastID, '1', NULL, 7 );
216 INSERT INTO civicrm_navigation
217 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
219 ( @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 );
221 SET @campaignlastID:=LAST_INSERT_ID();
222 INSERT INTO civicrm_navigation
223 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
225 ( @domainID, 'civicrm/campaign&reset=1', 'Dashboard', 'Dashboard', 'manage campaign,administer CiviCampaign', 'OR', @campaignlastID, '1', NULL, 1 );
226 SET @campaigndashboardlastID:=LAST_INSERT_ID();
227 INSERT INTO civicrm_navigation
228 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
230 ( @domainID, 'civicrm/campaign&reset=1&subPage=survey', 'Surveys', 'Survey Dashboard', 'manage campaign,administer CiviCampaign', 'OR', @campaigndashboardlastID, '1', NULL, 1 ),
231 ( @domainID, 'civicrm/campaign&reset=1&subPage=petition', 'Petitions', 'Petition Dashboard', 'manage campaign,administer CiviCampaign', 'OR', @campaigndashboardlastID, '1', NULL, 2 ),
232 ( @domainID, 'civicrm/campaign&reset=1&subPage=campaign', 'Campaigns', 'Campaign Dashboard', 'manage campaign,administer CiviCampaign', 'OR', @campaigndashboardlastID, '1', NULL, 3 ),
233 ( @domainID, 'civicrm/campaign/add&reset=1', 'New Campaign', 'New Campaign', 'manage campaign,administer CiviCampaign', 'OR', @campaignlastID, '1', NULL, 2 ),
234 ( @domainID, 'civicrm/survey/add&reset=1', 'New Survey', 'New Survey', 'manage campaign,administer CiviCampaign', 'OR', @campaignlastID, '1', NULL, 3 ),
235 ( @domainID, 'civicrm/petition/add&reset=1', 'New Petition', 'New Petition', 'manage campaign,administer CiviCampaign', 'OR', @campaignlastID, '1', NULL, 4 ),
236 ( @domainID, 'civicrm/survey/search&reset=1&op=reserve', 'Reserve Respondents', 'Reserve Respondents', 'administer CiviCampaign,manage campaign,reserve campaign contacts', 'OR', @campaignlastID, '1', NULL, 5 ),
237 ( @domainID, 'civicrm/survey/search&reset=1&op=interview', 'Interview Respondents', 'Interview Respondents', 'administer CiviCampaign,manage campaign,interview campaign contacts', 'OR', @campaignlastID, '1', NULL, 6 ),
238 ( @domainID, 'civicrm/survey/search&reset=1&op=release', 'Release Respondents', 'Release Respondents', 'administer CiviCampaign,manage campaign,release campaign contacts', 'OR', @campaignlastID, '1', NULL, 7 ),
239 ( @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 ),
240 ( @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 );
242 INSERT INTO civicrm_navigation
243 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
245 ( @domainID, NULL, 'Cases', 'Cases', 'access my cases and activities,access all cases and activities', 'OR', NULL, '1', NULL, 80 );
247 SET @caselastID:=LAST_INSERT_ID();
248 INSERT INTO civicrm_navigation
249 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
251 ( @domainID, 'civicrm/case&reset=1', 'Dashboard', 'Dashboard', 'access my cases and activities,access all cases and activities', 'OR', @caselastID, '1', NULL, 1 ),
252 ( @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 ),
253 ( @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 );
255 INSERT INTO civicrm_navigation
256 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
258 ( @domainID, NULL, 'Administer', 'Administer', 'administer CiviCRM', '', NULL, '1', NULL, 100 );
260 SET @adminlastID:=LAST_INSERT_ID();
261 INSERT INTO civicrm_navigation
262 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
264 ( @domainID, 'civicrm/admin&reset=1', 'Administration Console', 'Administration Console', 'administer CiviCRM', '', @adminlastID, '1', NULL, 1 );
266 SET @adminConsolelastID:=LAST_INSERT_ID();
267 INSERT INTO civicrm_navigation
268 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
270 ( @domainID, 'civicrm/admin/configtask&reset=1', 'Configuration Checklist', 'Configuration Checklist', 'administer CiviCRM', '', @adminConsolelastID, '1', NULL, 1 );
272 INSERT INTO civicrm_navigation
273 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
275 ( @domainID, NULL, 'Customize Data and Screens', 'Customize Data and Screens', 'administer CiviCRM', '', @adminlastID, '1', NULL, 3 );
277 SET @CustomizelastID:=LAST_INSERT_ID();
278 INSERT INTO civicrm_navigation
279 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
281 ( @domainID, 'civicrm/admin/custom/group&reset=1', 'Custom Fields', 'Custom Fields', 'administer CiviCRM', '', @CustomizelastID, '1', NULL, 1 ),
282 ( @domainID, 'civicrm/admin/uf/group&reset=1', 'Profiles', 'Profiles', 'administer CiviCRM', '', @CustomizelastID, '1', NULL, 2 ),
283 ( @domainID, 'civicrm/admin/tag&reset=1', 'Tags (Categories)', 'Tags (Categories)', 'administer CiviCRM', '', @CustomizelastID, '1', NULL, 3 ),
284 ( @domainID, 'civicrm/admin/options/activity_type&reset=1&group=activity_type', 'Activity Types', 'Activity Types', 'administer CiviCRM', '', @CustomizelastID, '1', NULL, 4 ),
285 ( @domainID, 'civicrm/admin/reltype&reset=1', 'Relationship Types', 'Relationship Types', 'administer CiviCRM', '', @CustomizelastID, '1', NULL, 5 ),
286 ( @domainID, 'civicrm/admin/options/subtype&reset=1', 'Contact Types','Contact Types', 'administer CiviCRM', '', @CustomizelastID, '1', NULL, 6 ),
287 ( @domainID, 'civicrm/admin/setting/preferences/display&reset=1', 'Display Preferences', 'Display Preferences', 'administer CiviCRM', '', @CustomizelastID, '1', NULL, 9 ),
288 ( @domainID, 'civicrm/admin/setting/search&reset=1', 'Search Preferences', 'Search Preferences', 'administer CiviCRM', '', @CustomizelastID, '1', NULL, 10 ),
289 ( @domainID, 'civicrm/admin/menu&reset=1', 'Navigation Menu', 'Navigation Menu', 'administer CiviCRM', '', @CustomizelastID, '1', NULL, 11 ),
290 ( @domainID, 'civicrm/admin/options/wordreplacements&reset=1','Word Replacements','Word Replacements', 'administer CiviCRM', '', @CustomizelastID, '1', NULL, 12 ),
291 ( @domainID, 'civicrm/admin/options/custom_search&reset=1&group=custom_search', 'Manage Custom Searches', 'Manage Custom Searches', 'administer CiviCRM', '', @CustomizelastID, '1', NULL, 13 );
293 INSERT INTO civicrm_navigation
294 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
296 ( @domainID, NULL, 'Dropdown Options', 'Dropdown Options', 'administer CiviCRM', '', @CustomizelastID, '1', NULL, 8 );
298 SET @optionListlastID:=LAST_INSERT_ID();
299 INSERT INTO civicrm_navigation
300 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
302 ( @domainID, 'civicrm/admin/options/gender&reset=1&group=gender', 'Gender Options', 'Gender Options', 'administer CiviCRM', '', @optionListlastID, '1', NULL, 1 ),
303 ( @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 ),
304 ( @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 ),
305 ( @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 ),
306 ( @domainID, 'civicrm/admin/locationType&reset=1', 'Location Types (Home, Work...)', 'Location Types (Home, Work...)', 'administer CiviCRM', '', @optionListlastID, '1', NULL, 5 ),
307 ( @domainID, 'civicrm/admin/options/mobile_provider&group=mobile_provider&reset=1', 'Mobile Phone Providers', 'Mobile Phone Providers', 'administer CiviCRM', '', @optionListlastID, '1', NULL, 6 ),
308 ( @domainID, 'civicrm/admin/options/phone_type&group=phone_type&reset=1', 'Phone Types', 'Phone Types', 'administer CiviCRM', '', @optionListlastID, '1', NULL, 7 ),
309 ( @domainID, 'civicrm/admin/options/website_type&group=website_type&reset=1', 'Website Types', 'Website Types', 'administer CiviCRM', '', @optionListlastID, '1', NULL, 8 );
311 INSERT INTO civicrm_navigation
312 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
314 ( @domainID, NULL, 'Communications', 'Communications', 'administer CiviCRM', '', @adminlastID, '1', NULL, 4 );
316 SET @communicationslastID:=LAST_INSERT_ID();
317 INSERT INTO civicrm_navigation
318 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
320 ( @domainID, 'civicrm/admin/domain&action=update&reset=1', 'Organization Address and Contact Info', 'Organization Address and Contact Info', 'administer CiviCRM', '', @communicationslastID, '1', NULL, 1 ),
321 ( @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 ),
322 ( @domainID, 'civicrm/admin/messageTemplates&reset=1', 'Message Templates', 'Message Templates', 'administer CiviCRM', '', @communicationslastID, '1', NULL, 3 ),
323 ( @domainID, 'civicrm/admin/scheduleReminders&reset=1', 'Schedule Reminders', 'Schedule Reminders', 'administer CiviCRM', '', @communicationslastID, '1', NULL, 4 ),
324 ( @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 ),
325 ( @domainID, 'civicrm/admin/labelFormats&reset=1', 'Label Formats', 'Label Formats', 'administer CiviCRM', '', @communicationslastID, '1', NULL, 6 ),
326 ( @domainID, 'civicrm/admin/pdfFormats&reset=1', 'Print Page (PDF) Formats', 'Print Page (PDF) Formats', 'administer CiviCRM', '', @communicationslastID, '1', NULL, 7 ),
327 ( @domainID, 'civicrm/admin/options/email_greeting&group=email_greeting&reset=1', 'Email Greeting Formats', 'Email Greeting Formats', 'administer CiviCRM', '', @communicationslastID, '1', NULL, 8 ),
328 ( @domainID, 'civicrm/admin/options/postal_greeting&group=postal_greeting&reset=1', 'Postal Greeting Formats', 'Postal Greeting Formats', 'administer CiviCRM', '', @communicationslastID, '1', NULL, 9 ),
329 ( @domainID, 'civicrm/admin/options/addressee&group=addressee&reset=1', 'Addressee Formats', 'Addressee Formats', 'administer CiviCRM', '', @communicationslastID, '1', NULL, 10 );
331 INSERT INTO civicrm_navigation
332 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
334 ( @domainID, NULL, 'Localization', 'Localization', 'administer CiviCRM', '', @adminlastID, '1', NULL, 6 );
336 SET @locallastID:=LAST_INSERT_ID();
337 INSERT INTO civicrm_navigation
338 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
340 ( @domainID, 'civicrm/admin/setting/localization&reset=1', 'Languages, Currency, Locations', 'Languages, Currency, Locations', 'administer CiviCRM', '', @locallastID, '1', NULL, 1 ),
341 ( @domainID, 'civicrm/admin/setting/preferences/address&reset=1', 'Address Settings', 'Address Settings', 'administer CiviCRM', '', @locallastID, '1', NULL, 2 ),
342 ( @domainID, 'civicrm/admin/setting/date&reset=1', 'Date Formats', 'Date Formats', 'administer CiviCRM', '', @locallastID, '1', NULL, 3 ),
343 ( @domainID, 'civicrm/admin/options/languages&group=languages&reset=1', 'Preferred Language Options', 'Preferred Language Options', 'administer CiviCRM', '', @locallastID, '1', NULL, 4 );
345 INSERT INTO civicrm_navigation
346 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
348 ( @domainID, NULL, 'Users and Permissions', 'Users and Permissions', 'administer CiviCRM', '', @adminlastID, '1', NULL, 7 );
350 SET @usersPermslastID:=LAST_INSERT_ID();
351 INSERT INTO civicrm_navigation
352 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
354 ( @domainID, 'civicrm/admin/access&reset=1', 'Permissions (Access Control)', 'Permissions (Access Control)', 'administer CiviCRM', '', @usersPermslastID, '1', NULL, 1 ),
355 ( @domainID, 'civicrm/admin/synchUser&reset=1', 'Synchronize Users to Contacts', 'Synchronize Users to Contacts', 'administer CiviCRM', '', @usersPermslastID, '1', NULL, 2 );
357 INSERT INTO civicrm_navigation
358 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
360 ( @domainID, NULL, 'System Settings', 'System Settings', 'administer CiviCRM', '', @adminlastID, '1', NULL, 8 );
362 SET @systemSettingslastID:=LAST_INSERT_ID();
363 INSERT INTO civicrm_navigation
364 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
366 ( @domainID, 'civicrm/admin/setting/component&reset=1', 'Enable CiviCRM Components', 'Enable Components', 'administer CiviCRM', '', @systemSettingslastID, '1', NULL, 1 ),
367 ( @domainID, 'civicrm/admin/extensions&reset=1', 'Manage Extensions', 'Manage Extensions', 'administer CiviCRM', '', @systemSettingslastID, '1', NULL, 2 ),
368 ( @domainID, 'civicrm/admin/setting/smtp&reset=1', 'Outbound Email (SMTP/Sendmail)', 'Outbound Email', 'administer CiviCRM', '', @systemSettingslastID, '1', NULL, 3 ),
369 ( @domainID, 'civicrm/admin/paymentProcessor&reset=1', 'Payment Processors', 'Payment Processors', 'administer CiviCRM', '', @systemSettingslastID, '1', NULL, 4 ),
370 ( @domainID, 'civicrm/admin/setting/mapping&reset=1', 'Mapping and Geocoding', 'Mapping and Geocoding', 'administer CiviCRM', '', @systemSettingslastID, '1', NULL, 5 ),
371 ( @domainID, 'civicrm/admin/setting/misc&reset=1', 'Undelete, Logging and ReCAPTCHA', 'Undelete, Logging and ReCAPTCHA', 'administer CiviCRM', '', @systemSettingslastID, '1', NULL, 6 ),
372 ( @domainID, 'civicrm/admin/setting/path&reset=1', 'Directories', 'Directories', 'administer CiviCRM', '', @systemSettingslastID, '1', NULL, 7 ),
373 ( @domainID, 'civicrm/admin/setting/url&reset=1', 'Resource URLs', 'Resource URLs', 'administer CiviCRM', '', @systemSettingslastID, '1', NULL, 8 ),
374 ( @domainID, 'civicrm/admin/setting/updateConfigBackend&reset=1', 'Cleanup Caches and Update Paths', 'Cleanup Caches and Update Paths', 'administer CiviCRM', '', @systemSettingslastID, '1', NULL, 9 ),
375 ( @domainID, 'civicrm/admin/setting/uf&reset=1', 'CMS Database Integration', 'CMS Integration', 'administer CiviCRM', '', @systemSettingslastID, '1', NULL, 10 ),
376 ( @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 ),
377 ( @domainID, 'civicrm/admin/options?reset=1', 'Option Groups', 'Option Groups', 'administer CiviCRM', '', @systemSettingslastID, '1', NULL, 12 ),
378 ( @domainID, 'civicrm/admin/mapping&reset=1', 'Import/Export Mappings', 'Import/Export Mappings', 'administer CiviCRM', '', @systemSettingslastID, '1', NULL, 13 ),
379 ( @domainID, 'civicrm/admin/setting/debug&reset=1', 'Debugging and Error Handling','Debugging and Error Handling', 'administer CiviCRM', '', @systemSettingslastID, '1', NULL, 14 ),
380 ( @domainID, 'civicrm/admin/setting/preferences/multisite&reset=1', 'Multi Site Settings', 'Multi Site Settings', 'administer CiviCRM', '', @systemSettingslastID, '1', NULL, 15 ),
381 ( @domainID, 'civicrm/admin/job&reset=1', 'Scheduled Jobs', 'Scheduled Jobs', 'administer CiviCRM', '', @systemSettingslastID, '1', NULL, 16 ),
382 ( @domainID, 'civicrm/admin/sms/provider?reset=1', 'SMS Providers', 'SMS Providers', 'administer CiviCRM', '', @systemSettingslastID, '1', NULL, 17 );
385 -- begin component admin menus
386 INSERT INTO civicrm_navigation
387 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
389 ( @domainID, NULL, 'CiviCampaign', 'CiviCampaign', 'administer CiviCampaign,administer CiviCRM', 'AND', @adminlastID, '1', NULL, 9 );
391 SET @adminCampaignlastID:=LAST_INSERT_ID();
392 INSERT INTO civicrm_navigation
393 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
395 ( @domainID, 'civicrm/admin/campaign/surveyType&reset=1', 'Survey Types', 'Survey Types', 'administer CiviCampaign', '', @adminCampaignlastID, '1', NULL, 1 ),
396 ( @domainID, 'civicrm/admin/options/campaign_type&group=campaign_type&reset=1', 'Campaign Types', 'Campaign Types', 'administer CiviCampaign', '', @adminCampaignlastID, '1', NULL, 2 ),
397 ( @domainID, 'civicrm/admin/options/campaign_status&group=campaign_status&reset=1', 'Campaign Status', 'Campaign Status', 'administer CiviCampaign', '', @adminCampaignlastID, '1', NULL, 3 ),
398 ( @domainID, 'civicrm/admin/options/engagement_index&group=engagement_index&reset=1', 'Engagement Index', 'Engagement Index', 'administer CiviCampaign', '', @adminCampaignlastID, '1', NULL, 4 ),
399 ( @domainID, 'civicrm/admin/setting/preferences/campaign&reset=1', 'CiviCampaign Component Settings', 'CiviCampaign Component Settings','administer CiviCampaign', '', @adminCampaignlastID, '1', NULL, 5 );
401 INSERT INTO civicrm_navigation
402 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
404 ( @domainID, NULL, 'CiviCase', 'CiviCase', 'administer CiviCase', NULL, @adminlastID, '1', NULL, 10 );
406 SET @adminCaselastID:=LAST_INSERT_ID();
407 INSERT INTO civicrm_navigation
408 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
410 ( @domainID, 'civicrm/admin/options/case_type&group=case_type&reset=1', 'Case Types', 'Case Types', 'administer CiviCase', NULL, @adminCaselastID, '1', NULL, 1 ),
411 ( @domainID, 'civicrm/admin/options/redaction_rule&group=redaction_rule&reset=1', 'Redaction Rules', 'Redaction Rules', 'administer CiviCase', NULL, @adminCaselastID, '1', NULL, 2 ),
412 ( @domainID, 'civicrm/admin/options/case_status&group=case_status&reset=1', 'Case Statuses', 'Case Statuses', 'administer CiviCase', NULL, @adminCaselastID, '1', NULL, 3 ),
413 ( @domainID, 'civicrm/admin/options/encounter_medium&group=encounter_medium&reset=1', 'Encounter Medium', 'Encounter Medium', 'administer CiviCase', NULL, @adminCaselastID, '1', NULL, 4 );
415 INSERT INTO civicrm_navigation
416 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
418 ( @domainID, NULL, 'CiviContribute', 'CiviContribute', 'access CiviContribute,administer CiviCRM', 'AND', @adminlastID, '1', NULL, 11 );
420 SET @adminContributelastID:=LAST_INSERT_ID();
421 INSERT INTO civicrm_navigation
422 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
424 ( @domainID, 'civicrm/admin/contribute&reset=1&action=add', 'New Contribution Page', 'New Contribution Page', 'access CiviContribute,administer CiviCRM', 'AND', @adminContributelastID, '1', NULL, 6 ),
425 ( @domainID, 'civicrm/admin/contribute&reset=1', 'Manage Contribution Pages', 'Manage Contribution Pages', 'access CiviContribute,administer CiviCRM', 'AND', @adminContributelastID, '1', '1', 7 ),
426 ( @domainID, 'civicrm/admin/pcp?reset=1&page_type=contribute', 'Personal Campaign Pages', 'Personal Campaign Pages', 'access CiviContribute,administer CiviCRM', 'AND', @adminContributelastID, '1', NULL, 8 ),
427 ( @domainID, 'civicrm/admin/contribute/managePremiums&reset=1', 'Premiums (Thank-you Gifts)', 'Premiums', 'access CiviContribute,administer CiviCRM', 'AND', @adminContributelastID, '1', 1, 9 ),
428 ( @domainID, 'civicrm/admin/contribute/contributionType&reset=1', 'Contribution Types', 'Contribution Types', 'access CiviContribute,administer CiviCRM', 'AND', @adminContributelastID, '1', NULL, 10),
429 ( @domainID, 'civicrm/admin/options/payment_instrument&group=payment_instrument&reset=1', 'Payment Instruments', 'Payment Instruments', 'access CiviContribute,administer CiviCRM', 'AND', @adminContributelastID, '1', NULL, 11 ),
430 ( @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 ),
431 ( @domainID, 'civicrm/admin/price&reset=1&action=add', 'New Price Set', 'New Price Set', 'access CiviContribute,administer CiviCRM', 'AND', @adminContributelastID, '1', NULL, 13 ),
432 ( @domainID, 'civicrm/admin/price&reset=1', 'Manage Price Sets', 'Manage Price Sets', 'access CiviContribute,administer CiviCRM', 'AND', @adminContributelastID, '1', NULL, 14 ),
433 ( @domainID, 'civicrm/admin/paymentProcessor&reset=1', 'Payment Processors', 'Payment Processors', 'administer CiviCRM', '', @adminContributelastID, '1', NULL, 15 );
435 INSERT INTO civicrm_navigation
436 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
438 ( @domainID, NULL, 'CiviEvent', 'CiviEvent', 'access CiviEvent,administer CiviCRM', 'AND', @adminlastID, '1', NULL, 12 );
440 SET @adminEventlastID:=LAST_INSERT_ID();
441 INSERT INTO civicrm_navigation
442 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
444 ( @domainID, 'civicrm/event/add&reset=1&action=add', 'New Event', 'New Event', 'access CiviEvent,administer CiviCRM', 'AND', @adminEventlastID, '1', NULL, 1 ),
445 ( @domainID, 'civicrm/event/manage&reset=1', 'Manage Events', 'Manage Events', 'access CiviEvent,administer CiviCRM', 'AND', @adminEventlastID, '1', 1, 2 ),
446 ( @domainID, 'civicrm/admin/pcp?reset=1&page_type=event', 'Personal Campaign Pages', 'Personal Campaign Pages', 'access CiviEvent,administer CiviCRM', 'AND', @adminEventlastID, '1', 1, 3 ),
447 ( @domainID, 'civicrm/admin/eventTemplate&reset=1', 'Event Templates', 'Event Templates', 'access CiviEvent,administer CiviCRM', 'AND', @adminEventlastID, '1', 1, 4 ),
448 ( @domainID, 'civicrm/admin/price&reset=1&action=add', 'New Price Set', 'New Price Set', 'access CiviEvent,administer CiviCRM', 'AND', @adminEventlastID, '1', NULL, 5 ),
449 ( @domainID, 'civicrm/admin/price&reset=1', 'Manage Price Sets', 'Manage Price Sets', 'access CiviEvent,administer CiviCRM', 'AND', @adminEventlastID, '1', 1, 6 ),
450 ( @domainID, 'civicrm/admin/options/event_type&group=event_type&reset=1', 'Event Types', 'Event Types', 'access CiviEvent,administer CiviCRM', 'AND', @adminEventlastID, '1', NULL, 7 ),
451 ( @domainID, 'civicrm/admin/participant_status&reset=1', 'Participant Statuses', 'Participant Statuses', 'access CiviEvent,administer CiviCRM', 'AND', @adminEventlastID, '1', NULL, 8 ),
452 ( @domainID, 'civicrm/admin/options/participant_role&group=participant_role&reset=1', 'Participant Roles', 'Participant Roles', 'access CiviEvent,administer CiviCRM', 'AND', @adminEventlastID, '1', NULL, 9 ),
453 ( @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 ),
454 ( @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 ),
455 ( @domainID, 'civicrm/admin/paymentProcessor&reset=1', 'Payment Processors', 'Payment Processors', 'administer CiviCRM', '', @adminEventlastID, '1', NULL, 12),
456 ( @domainID, 'civicrm/admin/setting/preferences/event&reset=1', 'CiviEvent Component Settings', 'CiviEvent Component Settings','access CiviEvent,administer CiviCRM', 'AND', @adminEventlastID, '1', NULL, 13 );
458 INSERT INTO civicrm_navigation
459 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
461 ( @domainID, NULL, 'CiviMail', 'CiviMail', 'access CiviMail,administer CiviCRM', 'AND', @adminlastID, '1', NULL, 14 );
463 SET @adminMailinglastID:=LAST_INSERT_ID();
464 INSERT INTO civicrm_navigation
465 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
467 ( @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 ),
468 ( @domainID, 'civicrm/admin/messageTemplates&reset=1', 'Message Templates', 'Message Templates', 'administer CiviCRM', '', @adminMailinglastID, '1', NULL, 2 ),
469 ( @domainID, 'civicrm/admin/options/from_email&group=from_email_address&reset=1', 'From Email Addresses', 'From Email Addresses', 'administer CiviCRM', '', @adminMailinglastID, '1', NULL, 3 ),
470 ( @domainID, 'civicrm/admin/mailSettings&reset=1', 'Mail Accounts', 'Mail Accounts', 'access CiviMail,administer CiviCRM', 'AND', @adminMailinglastID, '1', NULL, 4 ),
471 ( @domainID, 'civicrm/admin/mail&reset=1', 'Mailer Settings', 'Mailer Settings', 'access CiviMail,administer CiviCRM', 'AND', @adminMailinglastID, '1', NULL, 5 ),
472 ( @domainID, 'civicrm/admin/setting/preferences/mailing&reset=1', 'CiviMail Component Settings', 'CiviMail Component Settings','access CiviMail,administer CiviCRM', 'AND', @adminMailinglastID, '1', NULL, 6 );
474 INSERT INTO civicrm_navigation
475 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
477 ( @domainID, NULL, 'CiviMember', 'CiviMember', 'access CiviMember,administer CiviCRM', 'AND', @adminlastID, '1', NULL, 15 );
479 SET @adminMemberlastID:=LAST_INSERT_ID();
480 INSERT INTO civicrm_navigation
481 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
483 ( @domainID, 'civicrm/admin/member/membershipType&reset=1', 'Membership Types', 'Membership Types', 'access CiviMember,administer CiviCRM', 'AND', @adminMemberlastID, '1', NULL, 1 ),
484 ( @domainID, 'civicrm/admin/member/membershipStatus&reset=1', 'Membership Status Rules', 'Membership Status Rules', 'access CiviMember,administer CiviCRM', 'AND', @adminMemberlastID, '1', 1, 2 ),
485 ( @domainID, 'civicrm/admin/price&reset=1&action=add', 'New Price Set', 'New Price Set', 'access CiviMember,administer CiviCRM', 'AND', @adminMemberlastID, '1', NULL, 3 ),
486 ( @domainID, 'civicrm/admin/price&reset=1', 'Manage Price Sets', 'Manage Price Sets', 'access CiviMember,administer CiviCRM', 'AND', @adminMemberlastID, '1', NULL, 4 ),
487 ( @domainID, 'civicrm/admin/setting/preferences/member&reset=1', 'CiviMember Component Settings', 'CiviMember Component Settings','access CiviMember,administer CiviCRM', 'AND', @adminMemberlastID, '1', NULL, 5 );
489 INSERT INTO civicrm_navigation
490 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
492 ( @domainID, NULL, 'CiviReport', 'CiviReport', 'access CiviReport,administer CiviCRM', 'AND', @adminlastID, '1', NULL, 16 );
494 SET @adminReportlastID:=LAST_INSERT_ID();
495 INSERT INTO civicrm_navigation
496 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
498 ( @domainID, 'civicrm/report/list&reset=1', 'Reports Listing', 'Reports Listing', 'access CiviReport', '', @adminReportlastID, '1', NULL, 1 ),
499 ( @domainID, 'civicrm/admin/report/template/list&reset=1', 'Create Reports from Templates', 'Create Reports from Templates', 'administer Reports', '', @adminReportlastID, '1', NULL, 2 ),
500 ( @domainID, 'civicrm/admin/report/options/report_template&reset=1', 'Manage Templates', 'Manage Templates', 'administer Reports', '', @adminReportlastID, '1', NULL, 3 ),
501 ( @domainID, 'civicrm/admin/report/register&reset=1', 'Register Report', 'Register Report', 'administer Reports', '', @adminReportlastID, '1', NULL, 4 );
503 INSERT INTO civicrm_navigation
504 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
506 ( @domainID, NULL, 'Help', 'Help', NULL, '', NULL, '1', NULL, 110);
508 SET @adminHelplastID:=LAST_INSERT_ID();
509 INSERT INTO civicrm_navigation
510 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
512 ( @domainID, 'http://documentation.civicrm.org', 'Documentation', 'Documentation', NULL, 'AND', @adminHelplastID, '1', NULL, 1 ),
513 ( @domainID, 'http://forum.civicrm.org', 'Community Forums', 'Community Forums', NULL, 'AND', @adminHelplastID, '1', NULL, 2 ),
514 ( @domainID, 'http://civicrm.org/participate', 'Participate', 'Participate', NULL, 'AND', @adminHelplastID, '1', NULL, 3 ),
515 ( @domainID, 'http://civicrm.org/aboutcivicrm', 'About', 'About', NULL, 'AND', @adminHelplastID, '1', NULL, 4 );
517 INSERT INTO civicrm_navigation
518 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
520 ( @domainID, NULL, 'Reports', 'Reports', 'access CiviReport', '', NULL, '1', NULL, 95 );
522 SET @reportlastID:=LAST_INSERT_ID();
523 INSERT INTO civicrm_navigation
524 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
526 ( @domainID, 'civicrm/report/list&reset=1', 'Reports Listing', 'Reports Listing', 'access CiviReport', '', @reportlastID, '1', 1, 1 );
528 INSERT INTO civicrm_navigation
529 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
531 ( @domainID, 'civicrm/admin/report/template/list&reset=1', 'Create Reports from Templates', 'Create Reports from Templates', 'administer Reports', '', @reportlastID, '1', 1, 2 );
533 -- sample reports with navigation menus
535 INSERT INTO `civicrm_report_instance`
536 ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
538 ( @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;}');
539 SET @instanceID:=LAST_INSERT_ID();
540 INSERT INTO civicrm_navigation
541 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
543 ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'Constituent Report (Summary)', 'Constituent Report (Summary)', 'administer CiviCRM', '', @reportlastID, '1', NULL, @instanceID+2 );
544 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
547 INSERT INTO `civicrm_report_instance`
548 ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
550 ( @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;}');
551 SET @instanceID:=LAST_INSERT_ID();
552 INSERT INTO civicrm_navigation
553 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
555 ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'Constituent Report (Detail)', 'Constituent Report (Detail)', 'administer CiviCRM', '', @reportlastID, '1', NULL, @instanceID+2 );
556 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
558 INSERT INTO `civicrm_report_instance`
559 ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
561 ( @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;}');
562 SET @instanceID:=LAST_INSERT_ID();
563 INSERT INTO civicrm_navigation
564 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
566 ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'Activity Report', 'activity', 'administer CiviCRM', '', @reportlastID, '1', NULL, @instanceID+2 );
567 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
569 INSERT INTO `civicrm_report_instance`
570 (`domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
572 ( @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;}');
573 SET @instanceID:=LAST_INSERT_ID();
574 INSERT INTO civicrm_navigation
575 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
577 ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'Current Employer Report', 'Current Employer Report', 'administer CiviCRM', '', @reportlastID, '1', NULL, @instanceID+2 );
578 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
581 INSERT INTO `civicrm_report_instance`
582 ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
584 ( @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;}');
585 SET @instanceID:=LAST_INSERT_ID();
586 INSERT INTO civicrm_navigation
587 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
589 ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'Relationship Report', 'Relationship Report', 'administer CiviCRM', '', @reportlastID, '1', NULL, @instanceID+2 );
590 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
593 INSERT INTO `civicrm_report_instance`
594 ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
596 ( @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;}');
597 SET @instanceID:=LAST_INSERT_ID();
598 INSERT INTO civicrm_navigation
599 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
601 ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'Contribution Summary Report', 'Contribution Summary Report', 'access CiviContribute', '', @reportlastID, '1', NULL, @instanceID+2 );
602 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
605 INSERT INTO `civicrm_report_instance`
606 ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
608 ( @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;}');
609 SET @instanceID:=LAST_INSERT_ID();
610 INSERT INTO civicrm_navigation
611 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
613 ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'Contribution Detail Report', 'Contribution Detail Report', 'access CiviContribute', '', @reportlastID, '1', NULL, @instanceID+2 );
614 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
617 INSERT INTO `civicrm_report_instance`
618 ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
620 ( @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;}');
621 SET @instanceID:=LAST_INSERT_ID();
622 INSERT INTO civicrm_navigation
623 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
625 ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'Repeat Contribution Report', 'Repeat Contribution Report', 'access CiviContribute', '', @reportlastID, '1', NULL, @instanceID+2 );
626 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
629 INSERT INTO `civicrm_report_instance`
630 ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
632 ( @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;}');
633 SET @instanceID:=LAST_INSERT_ID();
634 INSERT INTO civicrm_navigation
635 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
637 ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'SYBUNT Report', 'SYBUNT Report', 'access CiviContribute', '', @reportlastID, '1', NULL, @instanceID+2 );
638 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
641 INSERT INTO `civicrm_report_instance`
642 ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
644 ( @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;}');
645 SET @instanceID:=LAST_INSERT_ID();
646 INSERT INTO civicrm_navigation
647 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
649 ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'LYBUNT Report', 'LYBUNT Report', 'access CiviContribute', '', @reportlastID, '1', NULL, @instanceID+2 );
650 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
652 INSERT INTO `civicrm_report_instance`
653 ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
655 ( @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;}');
656 SET @instanceID:=LAST_INSERT_ID();
657 INSERT INTO civicrm_navigation
658 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
660 ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'Contributions by Organization Report', 'Contributions by Organization Report', 'access CiviContribute', '', @reportlastID, '1', NULL, @instanceID+2 );
661 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
664 INSERT INTO `civicrm_report_instance`
665 ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
667 ( @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;}');
668 SET @instanceID:=LAST_INSERT_ID();
669 INSERT INTO civicrm_navigation
670 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
672 ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'Contributions by Household Report', 'Contributions by Household Report', 'access CiviContribute', '', @reportlastID, '1', NULL, @instanceID+2 );
673 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
675 INSERT INTO `civicrm_report_instance`
676 ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
678 ( @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:"";}');
679 SET @instanceID:=LAST_INSERT_ID();
680 INSERT INTO civicrm_navigation
681 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
683 ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'Top Donors Report', 'Top Donors Report', 'access CiviContribute', '', @reportlastID, '1', NULL, @instanceID+2 );
684 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
686 INSERT INTO `civicrm_report_instance`
687 ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
689 ( @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;}');
690 SET @instanceID:=LAST_INSERT_ID();
691 INSERT INTO civicrm_navigation
692 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
694 ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'Soft Credit Report', 'Soft Credit Report', 'access CiviContribute', '', @reportlastID, '1', NULL, @instanceID+2 );
695 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
698 INSERT INTO `civicrm_report_instance`
699 ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
701 ( @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;}');
702 SET @instanceID:=LAST_INSERT_ID();
703 INSERT INTO civicrm_navigation
704 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
706 ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'Personal Campaign Page Summary', 'Personal Campaign Page Summary', 'access CiviContribute', '', @reportlastID, '1', NULL, @instanceID+2 );
707 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
710 INSERT INTO `civicrm_report_instance`
711 ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
713 ( @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;}');
714 SET @instanceID:=LAST_INSERT_ID();
715 INSERT INTO civicrm_navigation
716 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
718 ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'Pledge Summary Report', 'Pledge Summary Report', 'access CiviPledge', '', @reportlastID, '1', NULL, @instanceID+2 );
719 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
721 INSERT INTO `civicrm_report_instance`
722 ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
724 ( @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;}');
725 SET @instanceID:=LAST_INSERT_ID();
726 INSERT INTO civicrm_navigation
727 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
729 ( @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 );
730 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
732 INSERT INTO `civicrm_report_instance`
733 ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
735 ( @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;}');
736 SET @instanceID:=LAST_INSERT_ID();
737 INSERT INTO civicrm_navigation
738 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
740 ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'Bookkeeping Transactions Report', 'Bookkeeping Transactions Report', 'access CiviContribute', '', @reportlastID, '1', NULL, @instanceID+2 );
742 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
745 INSERT INTO `civicrm_report_instance`
746 ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
748 ( @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;}');
749 SET @instanceID:=LAST_INSERT_ID();
750 INSERT INTO civicrm_navigation
751 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
753 ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'Membership Report (Summary)', 'Membership Report (Summary)', 'access CiviMember', '', @reportlastID, '1', NULL, @instanceID+2 );
754 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
757 INSERT INTO `civicrm_report_instance`
758 ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
760 ( @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;}');
761 SET @instanceID:=LAST_INSERT_ID();
762 INSERT INTO civicrm_navigation
763 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
765 ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'Membership Report (Detail)', 'Membership Report (Detail)', 'access CiviMember', '', @reportlastID, '1', NULL, @instanceID+2 );
766 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
768 -- contribution and membership report
769 INSERT INTO `civicrm_report_instance`
770 ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
772 ( @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;}');
773 SET @instanceID:=LAST_INSERT_ID();
774 INSERT INTO civicrm_navigation
775 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
777 ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'Contribution and Membership Details', 'Contribution and Membership Details', 'access CiviMember', 'AND', @reportlastID, '1', NULL, @instanceID+2 );
778 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
780 INSERT INTO `civicrm_report_instance`
781 ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
783 ( @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;}');
784 SET @instanceID:=LAST_INSERT_ID();
785 INSERT INTO civicrm_navigation
786 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
788 ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'Membership Report (Lapsed)', 'Membership Report (Lapsed)', 'access CiviMember', '', @reportlastID, '1', NULL, @instanceID+2 );
789 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
792 INSERT INTO `civicrm_report_instance`
793 ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
795 ( @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;}');
796 SET @instanceID:=LAST_INSERT_ID();
797 INSERT INTO civicrm_navigation
798 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
800 ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'Event Participant Report (List)', 'Event Participant Report (List)', 'access CiviEvent', '', @reportlastID, '1', NULL, @instanceID+2 );
801 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
804 INSERT INTO `civicrm_report_instance`
805 ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
807 ( @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;}');
808 SET @instanceID:=LAST_INSERT_ID();
809 INSERT INTO civicrm_navigation
810 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
812 ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'Event Income Report (Summary)', 'Event Income Report (Summary)', 'access CiviEvent', '', @reportlastID, '1', NULL, @instanceID+2 );
813 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
816 INSERT INTO `civicrm_report_instance`
817 ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
819 ( @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";}');
820 SET @instanceID:=LAST_INSERT_ID();
821 INSERT INTO civicrm_navigation
822 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
824 ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'Event Income Report (Detail)', 'Event Income Report (Detail)', 'access CiviEvent', '', @reportlastID, '1', NULL, @instanceID+2 );
825 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
828 INSERT INTO `civicrm_report_instance`
829 ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
831 ( @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;}');
832 SET @instanceID:=LAST_INSERT_ID();
833 INSERT INTO civicrm_navigation
834 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
836 ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'Attendee List', 'Attendee List', 'access CiviEvent', '', @reportlastID, '1', NULL, @instanceID+2 );
837 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
840 INSERT INTO `civicrm_report_instance`
841 ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
843 ( @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;}');
844 SET @instanceID:=LAST_INSERT_ID( );
845 INSERT INTO civicrm_navigation
846 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
848 ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'Mail Bounce Report', 'Mail Bounce Report', 'access CiviMail', '',@reportlastID, '1', NULL, @instanceID+2 );
849 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
852 INSERT INTO `civicrm_report_instance`
853 ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
855 ( @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;}');
856 SET @instanceID:=LAST_INSERT_ID( );
857 INSERT INTO civicrm_navigation
858 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
860 ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'Mail Summary Report', 'Mail Summary Report', 'access CiviMail', '',@reportlastID, '1', NULL, @instanceID+2 );
861 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
864 INSERT INTO `civicrm_report_instance`
865 ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
867 ( @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;}');
868 SET @instanceID:=LAST_INSERT_ID( );
869 INSERT INTO civicrm_navigation
870 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
872 ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'Mail Opened Report', 'Mail Opened Report', 'access CiviMail', '',@reportlastID, '1', NULL, @instanceID+2 );
873 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
876 INSERT INTO `civicrm_report_instance`
877 ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
879 ( @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;}');
880 SET @instanceID:=LAST_INSERT_ID( );
881 INSERT INTO civicrm_navigation
882 ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
884 ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'Mail Clickthrough Report', 'Mail Clickthrough Report', 'access CiviMail', '',@reportlastID, '1', NULL, @instanceID+2 );
885 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
888 -- walk list survey report.
889 INSERT INTO `civicrm_report_instance`
890 ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
892 ( @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;}');
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 )
897 ( @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 );
898 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
900 -- mailing detail report
901 INSERT INTO `civicrm_report_instance`
902 ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
904 ( @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;}');
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 )
909 ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'Mailing Detail Report', 'Mailing Detail Report', 'administer CiviMail', 'OR', @reportlastID, '1', NULL, @instanceID+2 );
910 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
911 UPDATE civicrm_domain SET version = '5.50.alpha1';