app/DoctrineMigrations/Version20251111000000.php line 1

<?php

declare(strict_types=1);

namespace DoctrineMigrations;

use Doctrine\DBAL\Schema\Schema;
use Doctrine\Migrations\AbstractMigration;

/**
 * 注文ごとの販売者ステータス管理テーブルのマイグレーション
 * dtb_order_seller_statusテーブルの作成・更新
 */
final class Version20251111000000 extends AbstractMigration
{
    public function getDescription(): string
    {
        return 'dtb_order_seller_statusテーブルの作成または更新';
    }

    public function up(Schema $schema): void
    {
        $platform = $this->connection->getDatabasePlatform();
        $schemaManager = $this->connection->createSchemaManager();
        
        // テーブルが存在しない場合は作成
        if (!$schemaManager->tablesExist(['dtb_order_seller_status'])) {
            $this->addSql('CREATE TABLE dtb_order_seller_status (
                id INT UNSIGNED NOT NULL,
                order_id INT UNSIGNED DEFAULT NULL,
                seller_id INT UNSIGNED DEFAULT NULL,
                order_status_id SMALLINT UNSIGNED DEFAULT NULL,
                discriminator_type VARCHAR(255) NOT NULL,
                PRIMARY KEY(id),
                INDEX IDX_5503C9F78D9F6D38 (order_id),
                INDEX IDX_5503C9F78DE820D9 (seller_id),
                INDEX IDX_5503C9F7D7707B45 (order_status_id)
            ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_bin ENGINE = InnoDB');
            return;
        }

        // テーブルが存在する場合、カラムをチェックして必要に応じて追加・変更
        $columns = $schemaManager->listTableColumns('dtb_order_seller_status');
        $columnNames = array_map(function($column) {
            return $column->getName();
        }, $columns);

        // 各カラムの存在確認と追加
        if (!in_array('id', $columnNames)) {
            $this->addSql('ALTER TABLE dtb_order_seller_status ADD id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST');
        }

        if (!in_array('order_id', $columnNames)) {
            $this->addSql('ALTER TABLE dtb_order_seller_status ADD order_id INT UNSIGNED DEFAULT NULL');
        } else {
            // 型チェックと変更
            $column = $columns[array_search('order_id', $columnNames)];
            if ($column->getType()->getName() !== 'integer' || !$column->getUnsigned()) {
                $this->addSql('ALTER TABLE dtb_order_seller_status MODIFY order_id INT UNSIGNED DEFAULT NULL');
            }
        }

        if (!in_array('seller_id', $columnNames)) {
            $this->addSql('ALTER TABLE dtb_order_seller_status ADD seller_id INT UNSIGNED DEFAULT NULL');
        } else {
            // 型チェックと変更
            $column = $columns[array_search('seller_id', $columnNames)];
            if ($column->getType()->getName() !== 'integer' || !$column->getUnsigned()) {
                $this->addSql('ALTER TABLE dtb_order_seller_status MODIFY seller_id INT UNSIGNED DEFAULT NULL');
            }
        }

        if (!in_array('order_status_id', $columnNames)) {
            $this->addSql('ALTER TABLE dtb_order_seller_status ADD order_status_id SMALLINT UNSIGNED DEFAULT NULL');
        } else {
            // 型チェックと変更
            $column = $columns[array_search('order_status_id', $columnNames)];
            if ($column->getType()->getName() !== 'smallint' || !$column->getUnsigned()) {
                $this->addSql('ALTER TABLE dtb_order_seller_status MODIFY order_status_id SMALLINT UNSIGNED DEFAULT NULL');
            }
        }

        if (!in_array('discriminator_type', $columnNames)) {
            $this->addSql('ALTER TABLE dtb_order_seller_status ADD discriminator_type VARCHAR(255) NOT NULL');
        } else {
            // 型チェックと変更
            $column = $columns[array_search('discriminator_type', $columnNames)];
            if ($column->getType()->getName() !== 'string' || $column->getLength() !== 255 || $column->getNotnull() !== true) {
                $this->addSql('ALTER TABLE dtb_order_seller_status MODIFY discriminator_type VARCHAR(255) NOT NULL');
            }
        }

        // インデックスの確認と追加
        $indexes = $schemaManager->listTableIndexes('dtb_order_seller_status');
        $indexNames = array_keys($indexes);

        if (!in_array('idx_5503c9f78d9f6d38', array_map('strtolower', $indexNames))) {
            $this->addSql('CREATE INDEX IDX_5503C9F78D9F6D38 ON dtb_order_seller_status (order_id)');
        }

        if (!in_array('idx_5503c9f78de820d9', array_map('strtolower', $indexNames))) {
            $this->addSql('CREATE INDEX IDX_5503C9F78DE820D9 ON dtb_order_seller_status (seller_id)');
        }

        if (!in_array('idx_5503c9f7d7707b45', array_map('strtolower', $indexNames))) {
            $this->addSql('CREATE INDEX IDX_5503C9F7D7707B45 ON dtb_order_seller_status (order_status_id)');
        }
    }

    public function down(Schema $schema): void
    {
        // ダウングレード時はテーブルを削除
        $this->addSql('DROP TABLE IF EXISTS dtb_order_seller_status');
    }
}