/home/edulekha/crm.edulekha.com/application/controllers/Migration.php
<?php
defined('BASEPATH') or exit('No direct script access allowed');
class Migration extends App_Controller
{
public function make()
{
$this->load->config('migration');
if ($this->config->item('migration_enabled') !== true) {
echo '<h1>Set config item <b>migration_enabled</b> to TRUE in <b>application/config/migration.php</b></h1>';
die;
}
if (!$this->input->get('old_base_url')) {
echo '<h1>
You need to pass old base url in the url like: ' . site_url('migration/make?old_base_url=http://myoldbaseurl.com/')
. '</h1>';
die;
}
$old_url = $this->input->get('old_base_url');
$new_url = $this->config->item('base_url');
if (!endsWith($old_url, '/')) {
$old_url = $old_url . '/';
}
$tables = [
[
'table' => db_prefix() . 'notifications',
'field' => 'description',
],
[
'table' => db_prefix() . 'notifications',
'field' => 'additional_data',
],
[
'table' => db_prefix() . 'notes',
'field' => 'description',
],
[
'table' => db_prefix() . 'emailtemplates',
'field' => 'message',
],
[
'table' => db_prefix() . 'newsfeed_posts',
'field' => 'content',
],
[
'table' => db_prefix() . 'newsfeed_post_comments',
'field' => 'content',
],
[
'table' => db_prefix() . 'options',
'field' => 'value',
],
[
'table' => db_prefix() . 'staff',
'field' => 'email_signature',
],
[
'table' => db_prefix() . 'tickets_predefined_replies',
'field' => 'message',
],
[
'table' => db_prefix() . 'projectdiscussioncomments',
'field' => 'content',
],
[
'table' => db_prefix() . 'projectdiscussions',
'field' => 'description',
],
[
'table' => db_prefix() . 'project_notes',
'field' => 'content',
],
[
'table' => db_prefix() . 'projects',
'field' => 'description',
],
[
'table' => db_prefix() . 'reminders',
'field' => 'description',
],
[
'table' => db_prefix() . 'tasks',
'field' => 'description',
],
[
'table' => db_prefix() . 'task_comments',
'field' => 'content',
],
[
'table' => db_prefix() . 'ticket_replies',
'field' => 'message',
],
[
'table' => db_prefix() . 'tickets',
'field' => 'message',
],
[
'table' => db_prefix() . 'todos',
'field' => 'description',
],
[
'table' => db_prefix() . 'proposal_comments',
'field' => 'content',
],
[
'table' => db_prefix() . 'proposals',
'field' => 'content',
],
[
'table' => db_prefix() . 'lead_activity_log',
'field' => 'description',
],
[
'table' => db_prefix() . 'knowledge_base_groups',
'field' => 'description',
],
[
'table' => db_prefix() . 'knowledge_base',
'field' => 'description',
],
[
'table' => db_prefix() . 'invoices',
'field' => 'terms',
],
[
'table' => db_prefix() . 'invoices',
'field' => 'clientnote',
],
[
'table' => db_prefix() . 'invoices',
'field' => 'adminnote',
],
[
'table' => db_prefix() . 'creditnotes',
'field' => 'terms',
],
[
'table' => db_prefix() . 'creditnotes',
'field' => 'clientnote',
],
[
'table' => db_prefix() . 'creditnotes',
'field' => 'adminnote',
],
[
'table' => db_prefix() . 'milestones',
'field' => 'description',
],
[
'table' => db_prefix() . 'sales_activity',
'field' => 'description',
],
[
'table' => db_prefix() . 'sales_activity',
'field' => 'additional_data',
],
[
'table' => db_prefix() . 'estimates',
'field' => 'terms',
],
[
'table' => db_prefix() . 'estimates',
'field' => 'clientnote',
],
[
'table' => db_prefix() . 'estimates',
'field' => 'adminnote',
],
[
'table' => db_prefix() . 'contracts',
'field' => 'description',
],
[
'table' => db_prefix() . 'contract_comments',
'field' => 'content',
],
[
'table' => db_prefix() . 'contracts',
'field' => 'content',
],
[
'table' => db_prefix() . 'activity_log',
'field' => 'description',
],
[
'table' => db_prefix() . 'announcements',
'field' => 'message',
],
[
'table' => db_prefix() . 'consent_purposes',
'field' => 'description',
],
[
'table' => db_prefix() . 'consents',
'field' => 'description',
],
[
'table' => db_prefix() . 'consents',
'field' => 'opt_in_purpose_description',
],
[
'table' => db_prefix() . 'vault',
'field' => 'description',
],
];
$tables = hooks()->apply_filters('migration_tables_to_replace_old_links', $tables);
$affectedRows = 0;
foreach ($tables as $t) {
$this->db->query('UPDATE `' . $t['table'] . '` SET `' . $t['field'] . '` = replace(' . $t['field'] . ', "' . $old_url . '", "' . $new_url . '")');
$affectedRows += $this->db->affected_rows();
}
echo '<h1>Total links replaced: ' . $affectedRows . '</h1>';
}
}