mirror of
https://github.com/SuiteCRM/SuiteCRM-Core.git
synced 2026-07-27 23:29:19 +08:00
111 lines
4.1 KiB
PHP
111 lines
4.1 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 Doctrine\DBAL\Schema\Schema;
|
|
use Doctrine\ORM\EntityManagerInterface;
|
|
use Symfony\Component\DependencyInjection\ContainerAwareInterface;
|
|
use Throwable;
|
|
|
|
final class Version20260223120000 extends BaseMigration implements ContainerAwareInterface
|
|
{
|
|
public function getDescription(): string
|
|
{
|
|
return 'Migrate saved_search contents from base64+serialize to JSON';
|
|
}
|
|
|
|
public function up(Schema $schema): void
|
|
{
|
|
/** @var EntityManagerInterface $entityManager */
|
|
$entityManager = $this->container->get('entity_manager');
|
|
$connection = $entityManager->getConnection();
|
|
|
|
$rows = $connection->executeQuery(
|
|
"SELECT id, contents FROM saved_search WHERE contents IS NOT NULL AND contents != '' AND deleted = '0'"
|
|
)->fetchAllAssociative();
|
|
|
|
foreach ($rows as $row) {
|
|
$raw = $row['contents'];
|
|
|
|
if (empty($raw)) {
|
|
continue;
|
|
}
|
|
|
|
// Skip if already JSON
|
|
try {
|
|
$jsonDecoded = json_decode($raw, true, 512, JSON_THROW_ON_ERROR);
|
|
} catch (Throwable $t) {
|
|
$jsonDecoded = null;
|
|
}
|
|
|
|
if ($jsonDecoded !== null) {
|
|
continue;
|
|
}
|
|
|
|
try {
|
|
try {
|
|
$decoded = @unserialize(base64_decode($raw), ['allowed_classes' => false]);
|
|
} catch (Throwable $t) {
|
|
$decoded = false;
|
|
}
|
|
|
|
if ($decoded === false) {
|
|
$connection->executeStatement(
|
|
"UPDATE saved_search SET contents = ? WHERE id = ?",
|
|
['', $row['id']]
|
|
);
|
|
$this->log('Migration Version20260223120000: Could not decode contents for saved_search id=' . $row['id'] . ' . Contents has been cleared.');
|
|
continue;
|
|
}
|
|
|
|
try {
|
|
$json = json_encode($decoded, JSON_THROW_ON_ERROR | JSON_INVALID_UTF8_SUBSTITUTE);
|
|
} catch (Throwable $t) {
|
|
$json = '';
|
|
}
|
|
|
|
$connection->executeStatement(
|
|
"UPDATE saved_search SET contents = ? WHERE id = ?",
|
|
[$json, $row['id']]
|
|
);
|
|
|
|
if ($json === '') {
|
|
$this->log('Migration Version20260223120000: Failed to encode contents to JSON for saved_search id=' . $row['id'] . '. Contents has been cleared.');
|
|
}
|
|
} catch (\Exception $e) {
|
|
$this->log('Migration Version20260223120000: Failed for saved_search id=' . $row['id'] . '. Error: ' . $e->getMessage());
|
|
}
|
|
}
|
|
}
|
|
|
|
public function down(Schema $schema): void
|
|
{
|
|
}
|
|
}
|
