<?php
declare(strict_types=1);
namespace DoctrineMigrations;
use Doctrine\DBAL\Schema\Schema;
use Doctrine\Migrations\AbstractMigration;
/**
* Auto-generated Migration: Please modify to your needs!
*/
final class Version20250121012929 extends AbstractMigration
{
public function getDescription(): string
{
return '';
}
public function up(Schema $schema): void
{
$idLayout = $this->connection->fetchOne("SELECT id from dtb_layout WHERE layout_name = :layout_name ", [
'layout_name' => '商品購入/MDLペイメント決済画面'
]);
if ($idLayout) {
$maxIdPage = $this->connection->fetchOne("SELECT MAX(id) AS max_id FROM dtb_page;");
$maxSortno = $this->connection->fetchOne("SELECT MAX(sort_no) AS max_sort_no FROM dtb_page_layout;");
$newPageId = ++$maxIdPage;
$newMaxSortno = ++$maxSortno;
$this->addSql(
"INSERT INTO `dtb_page` (`id`,`master_page_id`, `page_name`, `url`, `file_name`, `edit_type`, `create_date`, `update_date`, `discriminator_type`)
VALUES ($newPageId, NULL, 'カード管理', 'mypage_card', 'Mypage/card', 2, NOW() , NOW(), 'page') "
);
$this->addSql(
"INSERT INTO `dtb_page_layout` (`page_id`,`layout_id`, `sort_no`, `discriminator_type`)
VALUES ($newPageId, $idLayout, $newMaxSortno, 'pagelayout')"
);
}
}
public function down(Schema $schema): void
{
$pageId = $this->connection->fetchOne("SELECT id FROM dtb_page WHERE page_name = :page_name", [
'page_name' => 'カード管理'
]);
if ($pageId) {
$this->addSql("DELETE FROM dtb_page_layout WHERE page_id = :page_id", ['page_id' => $pageId]);
$this->addSql("DELETE FROM dtb_page WHERE id = :page_id", ['page_id' => $pageId]);
}
}
}