app/DoctrineMigrations/Version202410140000000.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 Version202410140000000 extends AbstractMigration
  14. {
  15.     const pages = [
  16.         [
  17.             'name' => '商品その他問合せ完了ページ',
  18.             'url' => 'other_complete',
  19.             'file' => 'Contact/other/complete',
  20.         ],
  21.         [
  22.             'name' => 'カタログ問合せ完了ページ',
  23.             'url' => 'catalog_complete',
  24.             'file' => 'Contact/catalog/complete',
  25.         ],
  26.         [
  27.             'name' => 'コーディネイト問合せ完了ページ',
  28.             'url' => 'coordinate_complete',
  29.             'file' => 'Contact/coordinate/complete',
  30.         ],
  31.         [
  32.             'name' => 'ショールーム問合せ完了ページ',
  33.             'url' => 'showroom_complete',
  34.             'file' => 'Contact/showroom/complete',
  35.         ],
  36.     ];
  38.     public function up(Schema $schema): void
  39.     {
  40.         foreach (self::pages as $page) {
  41.             $pageExists = $this->connection->fetchOne("SELECT COUNT(*) FROM dtb_page WHERE page_name = '$page[name]'");
  42.             if ($pageExists > 0) {
  43.                 continue;
  44.             }
  46.             $sql = "INSERT INTO dtb_page SELECT
  47.                 max(id)+1,
  48.                 null,
  49.                 '$page[name]',
  50.                 '$page[url]',
  51.                 '$page[file]',
  52.                 2,
  53.                 null,
  54.                 null,
  55.                 null,
  56.                 CURRENT_TIMESTAMP,
  57.                 CURRENT_TIMESTAMP,
  58.                 null,
  59.                 null,
  60.                 'page'
  61.             FROM dtb_page;";
  62.             $this->addSql($sql);
  64.             $sql = "INSERT INTO dtb_page_layout SELECT
  65.                 max(id),
  66.                 2,
  67.                 max(id),
  68.                 'pagelayout'
  69.             FROM dtb_page;";
  70.             $this->addSql($sql);
  71.         }
  72.     }
  74.     public function down(Schema $schema): void
  75.     {
  76.         foreach (self::pages as $page) {
  77.             $sql = "DELETE pl FROM dtb_page_layout pl
  78.             LEFT JOIN dtb_page p
  79.             ON pl.page_id = p.id
  80.             WHERE p.page_name = '$page[name]';
  81.             ";
  82.             $this->addSql($sql);
  84.             $sql = "DELETE FROM dtb_page
  85.             WHERE page_name = '$page[name]';
  86.             ";
  87.             $this->addSql($sql);
  88.         }
  89.     }
  90. }