app/DoctrineMigrations/Version20260129000000.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 Version20260129000000 extends AbstractMigration
  14. {
  15.     public function getDescription(): string
  16.     {
  17.         return 'Add order_delivery_date, order_handover_date columns to dtb_order and delivery_date, handover_date columns to dtb_order_item tables';
  18.     }
  20.     public function up(Schema $schema): void
  21.     {
  22.         // dtb_orderテーブルに受注の納入日とお渡し日カラムを追加
  23.         $table = $schema->getTable('dtb_order');
  24.         
  25.         if (!$table->hasColumn('order_delivery_date')) {
  26.             $table->addColumn('order_delivery_date', 'datetimetz', [
  27.                 'notnull' => false,
  28.                 'comment' => '受注の納入日'
  29.             ]);
  30.         }
  31.         
  32.         if (!$table->hasColumn('order_handover_date')) {
  33.             $table->addColumn('order_handover_date', 'datetimetz', [
  34.                 'notnull' => false,
  35.                 'comment' => '受注のお渡し日'
  36.             ]);
  37.         }
  39.         // dtb_order_itemテーブルに商品の納入日とお渡し日カラムを追加
  40.         $orderItemTable = $schema->getTable('dtb_order_item');
  41.         
  42.         if (!$orderItemTable->hasColumn('item_delivery_date')) {
  43.             $orderItemTable->addColumn('item_delivery_date', 'datetimetz', [
  44.                 'notnull' => false,
  45.                 'comment' => '商品の納入日'
  46.             ]);
  47.         }
  48.         
  49.         if (!$orderItemTable->hasColumn('item_handover_date')) {
  50.             $orderItemTable->addColumn('item_handover_date', 'datetimetz', [
  51.                 'notnull' => false,
  52.                 'comment' => '商品のお渡し日'
  53.             ]);
  54.         }
  55.     }
  57.     public function down(Schema $schema): void
  58.     {
  59.         // ロールバック時はカラムを削除
  60.         $table = $schema->getTable('dtb_order');
  61.         
  62.         if ($table->hasColumn('order_delivery_date')) {
  63.             $table->dropColumn('order_delivery_date');
  64.         }
  65.         
  66.         if ($table->hasColumn('order_handover_date')) {
  67.             $table->dropColumn('order_handover_date');
  68.         }
  70.         // dtb_order_itemテーブルのカラムも削除
  71.         $orderItemTable = $schema->getTable('dtb_order_item');
  72.         
  73.         if ($orderItemTable->hasColumn('item_delivery_date')) {
  74.             $orderItemTable->dropColumn('item_delivery_date');
  75.         }
  76.         
  77.         if ($orderItemTable->hasColumn('item_handover_date')) {
  78.             $orderItemTable->dropColumn('item_handover_date');
  79.         }
  80.     }
  81. }