3 +--------------------------------------------------------------------+
4 | CiviCRM version 4.6 |
5 +--------------------------------------------------------------------+
6 | Copyright CiviCRM LLC (c) 2004-2014 |
7 +--------------------------------------------------------------------+
8 | This file is a part of CiviCRM. |
10 | CiviCRM is free software; you can copy, modify, and distribute it |
11 | under the terms of the GNU Affero General Public License |
12 | Version 3, 19 November 2007. |
14 | CiviCRM is distributed in the hope that it will be useful, but |
15 | WITHOUT ANY WARRANTY; without even the implied warranty of |
16 | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. |
17 | See the GNU Affero General Public License for more details. |
19 | You should have received a copy of the GNU Affero General Public |
20 | License along with this program; if not, contact CiviCRM LLC |
21 | at info[AT]civicrm[DOT]org. If you have questions about the |
22 | GNU Affero General Public License or the licensing of CiviCRM, |
23 | see the CiviCRM license FAQ at http://civicrm.org/licensing |
24 +--------------------------------------------------------------------+
30 * @copyright CiviCRM LLC (c) 2004-2014
34 class CRM_Upgrade_Incremental_php_ThreeFour
{
40 public function verifyPreDBstate(&$errors) {
47 public function upgrade_3_4_alpha3($rev) {
48 // CRM-7681, update report instance criteria.
49 $modifiedReportIds = array('contact/summary', 'contact/detail', 'event/participantListing', 'member/summary', 'pledge/summary', 'pledge/pbnp', 'member/detail', 'member/lapse', 'grant/detail', 'contribute/bookkeeping', 'contribute/lybunt', 'contribute/summary', 'contribute/repeat', 'contribute/detail', 'contribute/organizationSummary', 'contribute/sybunt', 'contribute/householdSummary', 'contact/relationship', 'contact/currentEmployer', 'case/demographics', 'walklist', 'case/detail', 'contact/log', 'activitySummary', 'case/timespent', 'case/summary');
51 $instances = CRM_Core_DAO
::executeQuery("SELECT id, form_values, report_id FROM civicrm_report_instance WHERE report_id IN ('" . implode("','", $modifiedReportIds) . "')");
53 while ($instances->fetch()) {
54 $formValues = unserialize($instances->form_values
);
56 // replace display_name fields by sort_name
57 if (!empty($formValues['fields']) && isset($formValues['fields']['display_name'])) {
58 $formValues['fields']['sort_name'] = $formValues['fields']['display_name'];
59 unset($formValues['fields']['display_name']);
62 // replace display_name filters by sort_name
63 if (isset($formValues['display_name_op'])) {
64 $formValues['sort_name_op'] = $formValues['display_name_op'];
65 unset($formValues['display_name_op']);
67 if (isset($formValues['display_name_value'])) {
68 $formValues['sort_name_value'] = $formValues['display_name_value'];
69 unset($formValues['display_name_value']);
72 // for report id 'contact/log' replace field
73 // display_name_touched by sort_name_touched
74 if ($instances->report_id
== 'contact/log' && isset($formValues['fields']['display_name_touched'])) {
75 $formValues['fields']['sort_name_touched'] = $formValues['fields']['display_name_touched'];
76 unset($formValues['fields']['display_name_touched']);
79 // for report id 'contact/relationship' replace field
80 // display_name_a by sort_name_a and display_name_b by sort_name_b
81 if ($instances->report_id
== 'contact/relationship') {
82 if (isset($formValues['fields']['display_name_a'])) {
83 $formValues['fields']['sort_name_a'] = $formValues['fields']['display_name_a'];
84 unset($formValues['fields']['display_name_a']);
87 if (isset($formValues['fields']['display_name_b'])) {
88 $formValues['fields']['sort_name_b'] = $formValues['fields']['display_name_b'];
89 unset($formValues['fields']['display_name_b']);
93 // save updated instance criteria
94 $dao = new CRM_Report_DAO_ReportInstance();
95 $dao->id
= $instances->id
;
96 $dao->form_values
= serialize($formValues);
101 // Handled for typo in 3.3.2.mysql.tpl, rename column visibilty to
102 // visibility in table civicrm_mailing
103 $renameColumnVisibility = CRM_Core_DAO
::checkFieldExists('civicrm_mailing', 'visibilty');
105 $upgrade = new CRM_Upgrade_Form();
106 $upgrade->assign('renameColumnVisibility', $renameColumnVisibility);
107 $upgrade->processSQL($rev);
113 public function upgrade_3_4_beta2($rev) {
114 $addPetitionOptionGroup = !(boolean
) CRM_Core_DAO
::getFieldValue('CRM_Core_DAO_OptionGroup', 'msg_tpl_workflow_petition', 'id', 'name');
115 $upgrade = new CRM_Upgrade_Form();
116 $upgrade->assign('addPetitionOptionGroup', $addPetitionOptionGroup);
117 $upgrade->processSQL($rev);
123 public function upgrade_3_4_beta3($rev) {
124 // do the regular upgrade
125 $upgrade = new CRM_Upgrade_Form
;
126 $upgrade->processSQL($rev);
128 if ($upgrade->multilingual
) {
130 // rebuild schema, because due to a CRM-7854 mis-fix some indices might be missing
131 CRM_Core_I18n_Schema
::rebuildMultilingualSchema($upgrade->locales
, $rev);
133 // turn a set of columns singlelingual
134 $config = CRM_Core_Config
::singleton();
135 $tables = array('civicrm_address', 'civicrm_contact', 'civicrm_mailing', 'civicrm_mailing_component');
136 $triggers = array(array('when' => 'before', 'event' => 'update'), array('when' => 'before', 'event' => 'insert'));
138 // FIXME: Doing require_once is a must here because a call like CRM_Core_I18n_SchemaStructure_3_4_beta2 makes
139 // class loader look for file like - CRM/Core/I18n/SchemaStructure/3/4/beta2.php which is not what we want to be loaded
140 require_once "CRM/Core/I18n/SchemaStructure_3_4_beta2.php";
141 foreach ($tables as $table) {
142 CRM_Core_I18n_Schema
::makeSinglelingualTable($config->lcMessages
, $table, 'CRM_Core_I18n_SchemaStructure_3_4_beta2', $triggers);
150 public function upgrade_3_4_3($rev) {
151 // CRM-8147, update group_type for uf groups, check and add component field types
152 $ufGroups = new CRM_Core_DAO_UFGroup();
154 $skipGroupTypes = array('Individual,Contact', 'Organization,Contact', 'Household,Contact', 'Contact', 'Individual', 'Organization', 'Household');
155 while ($ufGroups->fetch()) {
156 if (!in_array($ufGroups->group_type
, $skipGroupTypes)) {
157 $groupTypes = CRM_Core_BAO_UFGroup
::calculateGroupType($ufGroups->id
, TRUE);
158 CRM_Core_BAO_UFGroup
::updateGroupTypes($ufGroups->id
, $groupTypes);
163 // CRM-8134 add phone_ext column if it wasn't already added for this site in 3.3.7 upgrade (3.3.7 was released after 3.4.0)
164 $dao = new CRM_Contact_DAO_Contact();
165 $dbName = $dao->_database
;
167 $chkExtQuery = "SELECT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = %1
168 AND TABLE_NAME = 'civicrm_phone' AND COLUMN_NAME = 'phone_ext'";
169 $extensionExists = CRM_Core_DAO
::singleValueQuery($chkExtQuery,
170 array(1 => array($dbName, 'String')),
174 if (!$extensionExists) {
175 $colQuery = 'ALTER TABLE `civicrm_phone` ADD `phone_ext` VARCHAR( 16 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL AFTER `phone` ';
176 CRM_Core_DAO
::executeQuery($colQuery);
179 $sql = "SELECT id FROM civicrm_location_type WHERE name = 'Main'";
180 if (!CRM_Core_DAO
::singleValueQuery($sql)) {
182 INSERT INTO civicrm_location_type ( name, description, is_reserved, is_active )
183 VALUES ( 'Main', 'Main office location', 0, 1 );";
184 CRM_Core_DAO
::executeQuery($query);
187 $upgrade = new CRM_Upgrade_Form
;
188 $upgrade->processSQL($rev);
194 public function upgrade_3_4_4($rev) {
195 // CRM-8315, update report instance criteria.
196 $modifiedReportIds = array('member/summary', 'member/detail');
198 $instances = CRM_Core_DAO
::executeQuery("SELECT id, form_values, report_id FROM civicrm_report_instance WHERE report_id IN ('" . implode("','", $modifiedReportIds) . "')");
200 while ($instances->fetch()) {
201 $formValues = unserialize($instances->form_values
);
203 // replace display_name fields by sort_name
204 if (!isset($formValues['membership_start_date_relative']) &&
205 !isset($formValues['membership_end_date_relative'])
207 $formValues['membership_start_date_relative'] = '0';
208 $formValues['membership_start_date_from'] = '';
209 $formValues['membership_start_date_to'] = '';
210 $formValues['membership_end_date_relative'] = '0';
211 $formValues['membership_end_date_from'] = '';
212 $formValues['membership_end_date_to'] = '';
215 // save updated instance criteria
216 $dao = new CRM_Report_DAO_ReportInstance();
217 $dao->id
= $instances->id
;
218 $dao->form_values
= serialize($formValues);
223 $upgrade = new CRM_Upgrade_Form();
224 $upgrade->processSQL($rev);
230 public function upgrade_3_4_5($rev) {
231 // handle db changes done for CRM-8218
232 $alterContactDashboard = FALSE;
233 $dao = new CRM_Contact_DAO_DashboardContact();
234 $dbName = $dao->_database
;
236 $chkContentQuery = "SELECT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = %1
237 AND TABLE_NAME = 'civicrm_dashboard_contact' AND COLUMN_NAME = 'content'";
238 $contentExists = CRM_Core_DAO
::singleValueQuery($chkContentQuery,
239 array(1 => array($dbName, 'String')),
242 if (!$contentExists) {
243 $alterContactDashboard = TRUE;
246 $upgrade = new CRM_Upgrade_Form();
247 $upgrade->assign('alterContactDashboard', $alterContactDashboard);
248 $upgrade->processSQL($rev);
254 public function upgrade_3_4_6($rev) {
255 $modifiedReportIds = array('event/summary', 'activity', 'Mailing/bounce', 'Mailing/clicks', 'Mailing/opened');
257 $instances = CRM_Core_DAO
::executeQuery("SELECT id, form_values, report_id FROM civicrm_report_instance WHERE report_id IN ('" . implode("','", $modifiedReportIds) . "')");
258 while ($instances->fetch()) {
259 $formValues = unserialize($instances->form_values
);
261 switch ($instances->report_id
) {
262 case 'event/summary':
263 $eventDates = array('event_start_date_from', 'event_start_date_to', 'event_end_date_from', 'event_end_date_to');
264 foreach ($eventDates as $date) {
265 if (isset($formValues[$date]) && $formValues[$date] == ' ') {
266 $formValues[$date] = '';
272 if (isset($formValues['group_bys'])) {
273 if (is_array($formValues['group_bys'])) {
276 foreach ($formValues['group_bys'] as $col => $isSet) {
281 $orderBy[++
$count] = array(
286 if (!empty($orderBy)) {
287 $formValues['order_bys'] = $orderBy;
290 unset($formValues['group_bys']);
294 case 'Mailing/bounce':
295 case 'Mailing/clicks':
296 case 'Mailing/opened':
297 $formValues['fields']['mailing_name'] = 1;
301 // save updated instance criteria
302 $dao = new CRM_Report_DAO_ReportInstance();
303 $dao->id
= $instances->id
;
304 $dao->form_values
= serialize($formValues);
309 $bulkEmailActivityType = CRM_Core_DAO
::singleValueQuery("
311 FROM civicrm_option_value v,
312 civicrm_option_group g
313 WHERE v.option_group_id = g.id
316 AND v.name = %2", array(
317 1 => array('activity_type', 'String'),
318 2 => array('Bulk Email', 'String'),
321 // CRM-8852, reset contact field cache
322 CRM_Core_BAO_Cache
::deleteGroup('contact fields');
324 $upgrade = new CRM_Upgrade_Form();
325 $upgrade->assign('bulkEmailActivityType', $bulkEmailActivityType);
327 $upgrade->processSQL($rev);
335 public function upgrade_3_4_7($rev) {
336 $onBehalfProfileId = CRM_Core_DAO
::getFieldValue('CRM_Core_DAO_UFGroup', 'on_behalf_organization', 'id', 'name');
337 if (!$onBehalfProfileId) {
338 CRM_Core_Error
::fatal();
341 $pages = CRM_Core_DAO
::executeQuery("
342 SELECT civicrm_contribution_page.id
343 FROM civicrm_contribution_page
344 LEFT JOIN civicrm_uf_join ON entity_table = 'civicrm_contribution_page' AND entity_id = civicrm_contribution_page.id AND module = 'OnBehalf'
345 WHERE is_for_organization = 1
346 AND civicrm_uf_join.id IS NULL
349 while ($pages->fetch()) {
351 INSERT INTO civicrm_uf_join
352 (is_active, module, entity_table, entity_id, weight, uf_group_id)
354 (1, 'OnBehalf', 'civicrm_contribution_page', %1, 1, %2)";
357 1 => array($pages->id
, 'Integer'),
358 2 => array($onBehalfProfileId, 'Integer'),
360 CRM_Core_DAO
::executeQuery($query, $params);
364 $config = CRM_Core_Config
::singleton();
365 if ($config->userFramework
== 'Drupal' ||
$config->userFramework
== 'Drupal6') {
366 db_query("UPDATE {system} SET weight = 100 WHERE name = 'civicrm'");
367 drupal_flush_all_caches();
370 $upgrade = new CRM_Upgrade_Form();
371 $upgrade->processSQL($rev);