app/DoctrineMigrations/Version20251027000000.php line 1

Open in your IDE?
  1. <?php
  3. declare(strict_types=1);
  5. namespace DoctrineMigrations;
  7. use Doctrine\DBAL\Schema\Schema;
  8. use Doctrine\Migrations\AbstractMigration;
  10. /**
  11.  * 販売元出力名マスタテーブルの作成
  12.  */
  13. final class Version20251027000000 extends AbstractMigration
  14. {
  15.     public function up(Schema $schema): void
  16.     {
  17.         $schemaManager = $this->connection->createSchemaManager();
  18.         
  19.         // dtb_seller_output_nameテーブルが存在しない場合のみ作成
  20.         if (!$schemaManager->tablesExist(['dtb_seller_output_name'])) {
  21.             // 販売元出力名テーブルの作成
  22.             $this->addSql("
  23.                 CREATE TABLE dtb_seller_output_name (
  24.                     id INT UNSIGNED AUTO_INCREMENT NOT NULL,
  25.                     seller_name VARCHAR(255) NOT NULL,
  26.                     company_name VARCHAR(255) DEFAULT NULL,
  27.                     postal_code VARCHAR(8) DEFAULT NULL,
  28.                     pref VARCHAR(255) DEFAULT NULL,
  29.                     addr01 VARCHAR(255) DEFAULT NULL,
  30.                     addr02 VARCHAR(255) DEFAULT NULL,
  31.                     phone_number VARCHAR(14) DEFAULT NULL,
  32.                     fax_number VARCHAR(14) DEFAULT NULL,
  33.                     email VARCHAR(255) DEFAULT NULL,
  34.                     invoice_registration_number VARCHAR(255) DEFAULT NULL,
  35.                     sort_no INT UNSIGNED NOT NULL DEFAULT 0,
  36.                     discriminator_type VARCHAR(255) NOT NULL,
  37.                     create_date DATETIME NOT NULL COMMENT '(DC2Type:datetimetz)',
  38.                     update_date DATETIME NOT NULL COMMENT '(DC2Type:datetimetz)',
  39.                     PRIMARY KEY(id)
  40.                 ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci ENGINE = InnoDB
  41.             ");
  42.             
  43.             // デフォルトデータの挿入（基本情報から取得したデータで初期化）
  44.             $this->addSql("
  45.                 INSERT INTO dtb_seller_output_name 
  46.                 (seller_name, company_name, postal_code, addr01, addr02, phone_number, email, invoice_registration_number, sort_no, discriminator_type, create_date, update_date)
  47.                 SELECT 
  48.                     shop_name,
  49.                     company_name,
  50.                     postal_code,
  51.                     addr01,
  52.                     addr02,
  53.                     phone_number,
  54.                     email01,
  55.                     invoice_registration_number,
  56.                     0,
  57.                     'selleroutputname',
  58.                     NOW(),
  59.                     NOW()
  60.                 FROM dtb_base_info
  61.                 LIMIT 1
  62.             ");
  63.         }
  64.         
  65.         // plg_claim_pdfテーブルが存在し、seller_output_name_idカラムが存在しない場合のみ追加
  66.         if ($schemaManager->tablesExist(['plg_claim_pdf'])) {
  67.             $columns = $schemaManager->listTableColumns('plg_claim_pdf');
  68.             $columnNames = array_map(function($column) {
  69.                 return $column->getName();
  70.             }, $columns);
  71.             
  72.             if (!in_array('seller_output_name_id', $columnNames)) {
  73.                 // plg_claim_pdf テーブルに販売元出力名ID カラムを追加
  74.                 $this->addSql("
  75.                     ALTER TABLE plg_claim_pdf 
  76.                     ADD COLUMN seller_output_name_id INT UNSIGNED DEFAULT NULL AFTER member_id,
  77.                     ADD INDEX IDX_SELLER_OUTPUT_NAME (seller_output_name_id)
  78.                 ");
  79.             }
  80.         }
  81.     }
  83.     public function down(Schema $schema): void
  84.     {
  85.         $schemaManager = $this->connection->createSchemaManager();
  86.         
  87.         // plg_claim_pdf テーブルから販売元出力名ID カラムを削除
  88.         if ($schemaManager->tablesExist(['plg_claim_pdf'])) {
  89.             $columns = $schemaManager->listTableColumns('plg_claim_pdf');
  90.             $columnNames = array_map(function($column) {
  91.                 return $column->getName();
  92.             }, $columns);
  93.             
  94.             if (in_array('seller_output_name_id', $columnNames)) {
  95.                 $this->addSql("ALTER TABLE plg_claim_pdf DROP INDEX IDX_SELLER_OUTPUT_NAME");
  96.                 $this->addSql("ALTER TABLE plg_claim_pdf DROP COLUMN seller_output_name_id");
  97.             }
  98.         }
  100.         // 販売元出力名テーブルの削除
  101.         if ($schemaManager->tablesExist(['dtb_seller_output_name'])) {
  102.             $this->addSql("DROP TABLE dtb_seller_output_name");
  103.         }
  104.     }
  105. }