mirror of
https://github.com/SuiteCRM/SuiteCRM-Core.git
synced 2026-07-26 22:39:11 +08:00
88 lines
3.3 KiB
PHP
88 lines
3.3 KiB
PHP
<?php
|
|
/**
|
|
* SuiteCRM is a customer relationship management program developed by SuiteCRM Ltd.
|
|
* Copyright (C) 2026 SuiteCRM Ltd.
|
|
*
|
|
* This program is free software; you can redistribute it and/or modify it under
|
|
* the terms of the GNU Affero General Public License version 3 as published by the
|
|
* Free Software Foundation with the addition of the following permission added
|
|
* to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED WORK
|
|
* IN WHICH THE COPYRIGHT IS OWNED BY SUITECRM, SUITECRM DISCLAIMS THE
|
|
* WARRANTY OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
|
|
*
|
|
* This program is distributed in the hope that it will be useful, but WITHOUT
|
|
* ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
|
|
* FOR A PARTICULAR PURPOSE. See the GNU Affero General Public License for more
|
|
* details.
|
|
*
|
|
* You should have received a copy of the GNU Affero General Public License
|
|
* along with this program. If not, see <http://www.gnu.org/licenses/>.
|
|
*
|
|
* In accordance with Section 7(b) of the GNU Affero General Public License
|
|
* version 3, these Appropriate Legal Notices must retain the display of the
|
|
* "Supercharged by SuiteCRM" logo. If the display of the logos is not reasonably
|
|
* feasible for technical reasons, the Appropriate Legal Notices must display
|
|
* the words "Supercharged by SuiteCRM".
|
|
*/
|
|
|
|
declare(strict_types=1);
|
|
|
|
namespace App\Migrations;
|
|
|
|
use App\Migrations\BaseMigration;
|
|
use Doctrine\DBAL\Schema\Schema;
|
|
use Symfony\Component\DependencyInjection\ContainerAwareInterface;
|
|
|
|
final class Version20260217120000 extends BaseMigration implements ContainerAwareInterface
|
|
{
|
|
public function getDescription(): string
|
|
{
|
|
return 'Add Migrate Notes Attachments manual migration task';
|
|
}
|
|
|
|
public function up(Schema $schema): void
|
|
{
|
|
$this->log('Migration Version20260217120000: Adding Migrate Notes Attachments task');
|
|
|
|
$serviceKey = 'migrate-notes-files';
|
|
|
|
$existing = $this->connection->fetchOne(
|
|
'SELECT COUNT(*) FROM manual_migration_tasks WHERE service_key = ? AND deleted = 0',
|
|
[$serviceKey]
|
|
);
|
|
|
|
if ((int)$existing > 0) {
|
|
$this->log('Migration Version20260217120000: Task already exists, skipping');
|
|
return;
|
|
}
|
|
|
|
$now = date('Y-m-d H:i:s');
|
|
|
|
$this->connection->insert('manual_migration_tasks', [
|
|
'id' => create_guid(),
|
|
'name' => 'Migrate Notes Attachments',
|
|
'type' => 'background',
|
|
'status' => 'initial',
|
|
'service_key' => $serviceKey,
|
|
'description' => 'Migrates Notes file attachments from legacy storage (upload/{note_id}) to the new media object storage system.',
|
|
'date_entered' => $now,
|
|
'date_modified' => $now,
|
|
'created_by' => '1',
|
|
'modified_user_id' => '1',
|
|
'assigned_user_id' => 1,
|
|
'deleted' => 0,
|
|
'allow_failure_retry_action' => 1,
|
|
'allow_failure_rerun_action' => 0
|
|
]);
|
|
|
|
$this->log('Migration Version20260217120000: Task added successfully');
|
|
}
|
|
|
|
public function down(Schema $schema): void
|
|
{
|
|
$this->connection->executeStatement(
|
|
'DELETE FROM manual_migration_tasks WHERE service_key = ?',
|
|
['migrate-notes-files']
|
|
);
|
|
}
|
|
}
|
