Symfony Profiler

<?php

declare(strict_types=1);

namespace DoctrineMigrations;

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

/**
 * 対応状況に「冬物入金済み」「夏物発送済み」を追加
 */
final class Version20250919044958 extends AbstractMigration
{
    public function getDescription(): string
    {
        return '対応状況に「冬物入金済み」「夏物発送済み」を追加';
    }

    public function up(Schema $schema): void
    {
        // 「冬物入金済み」を追加 (ID: 116, sort_no: 22)
        $this->addSql("INSERT INTO mtb_order_status (id, display_order_count, name, sort_no, discriminator_type) VALUES (116, 0, '冬物入金済み', 22, 'orderstatus') ON DUPLICATE KEY UPDATE name = '冬物入金済み', sort_no = 22");
        
        // 「夏物発送済み」を追加 (ID: 117, sort_no: 23)
        $this->addSql("INSERT INTO mtb_order_status (id, display_order_count, name, sort_no, discriminator_type) VALUES (117, 0, '夏物発送済み', 23, 'orderstatus') ON DUPLICATE KEY UPDATE name = '夏物発送済み', sort_no = 23");
        
        // 対応するOrderStatusColorを追加
        // 冬物入金済み: 青系 (#437ec4) - 入金系の色
        $this->addSql("INSERT INTO mtb_order_status_color (id, name, sort_no, discriminator_type) VALUES (116, '#437ec4', 22, 'orderstatuscolor') ON DUPLICATE KEY UPDATE name = '#437ec4', sort_no = 22");
        
        // 夏物発送済み: 緑系 (#25b877) - 発送済み系の色  
        $this->addSql("INSERT INTO mtb_order_status_color (id, name, sort_no, discriminator_type) VALUES (117, '#25b877', 23, 'orderstatuscolor') ON DUPLICATE KEY UPDATE name = '#25b877', sort_no = 23");
    }

    public function down(Schema $schema): void
    {
        // 追加したレコードを削除
        $this->addSql("DELETE FROM mtb_order_status WHERE id IN (116, 117)");
        $this->addSql("DELETE FROM mtb_order_status_color WHERE id IN (116, 117)");
    }
}
app/DoctrineMigrations/Version20250919044958.php line 1
