app/DoctrineMigrations/Version20240717122837.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.  * Auto-generated Migration: Please modify to your needs!
  12.  */
  13. final class Version20240717122837 extends AbstractMigration
  14. {
  15.     public function getDescription(): string
  16.     {
  17.         return '';
  18.     }
  20.     public function up(Schema $schema): void
  21.     {
  22.         $this->addSql('DELETE FROM `mtb_order_status`');
  23.         $sql = <<<SQL
  24.             INSERT INTO `mtb_order_status`(`id`, `display_order_count`, `name`, `sort_no`, `discriminator_type`) VALUES 
  25.             (1,1,'新規受付',0,'orderstatus'),
  26.             (2,0,'購入処理中',1,'orderstatus'),
  27.             (3,0,'与信中',2,'orderstatus'),
  28.             (4,1,'決済処理中',3,'orderstatus'),
  29.             (5,1,'入金済み',4,'orderstatus'),
  30.             (6,1,'データ作成中',5,'orderstatus'),
  31.             (7,1,'データ送信済み',6,'orderstatus'),
  32.             (8,1,'承認済み',7,'orderstatus'),
  33.             (9,1,'ステッカー製作中',8,'orderstatus'),
  34.             (10,1,'検品中',9,'orderstatus'),
  35.             (11,0,'発送済み',10,'orderstatus'),
  36.             (12,0,'返品',11,'orderstatus'),
  37.             (13,0,'注文取消',12,'orderstatus')
  38.         SQL;
  39.         $this->addSql($sql);
  41.         $this->addSql('DELETE FROM `mtb_order_status_color`');
  42.         $sql = <<<SQL
  43.             INSERT INTO `mtb_order_status_color`(`id`, `name`, `sort_no`, `discriminator_type`) VALUES 
  44.             (1,'#437ec4',0,'orderstatuscolor'),
  45.             (2,'#A3A3A3',1,'orderstatuscolor'),
  46.             (3,'#873754',2,'orderstatuscolor'),
  47.             (4,'#A3A3A3',3,'orderstatuscolor'),
  48.             (5,'#25B877',4,'orderstatuscolor'),
  49.             (6,'#EEB128',5,'orderstatuscolor'),
  50.             (7,'#C4478E',6,'orderstatuscolor'),
  51.             (8,'#458737',7,'orderstatuscolor'),
  52.             (9,'#EEB128',8,'orderstatuscolor'),
  53.             (10,'#9F47C4',9,'orderstatuscolor'),
  54.             (11,'#25B877',10,'orderstatuscolor'),
  55.             (12,'#C04949',11,'orderstatuscolor'),
  56.             (13,'#C04949',12,'orderstatuscolor')
  57.         SQL;
  58.         $this->addSql($sql);
  59.     }
  61.     public function down(Schema $schema): void
  62.     {
  63.     }
  64. }