<?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 Version20240702080228 extends AbstractMigration
{
public function getDescription(): string
{
return '';
}
public function up(Schema $schema): void
{
$pageId = $this->connection->fetchOne('SELECT MAX(id) FROM dtb_page');
$pageId++;
$this->addSql("INSERT INTO `dtb_page` (
`id`, `master_page_id`, `page_name`, `url`, `file_name`, `edit_type`, `create_date`, `update_date`, `meta_robots`, `discriminator_type`
) VALUES(
$pageId, NULL, '見積申込み', 'estimate_request', 'EstimateRequest/index', 2, NOW(), NOW(), 'noindex', 'page'
)");
$sortNo = $this->connection->fetchOne('SELECT MAX(sort_no) FROM dtb_page_layout');
$sortNo++;
$this->addSql("INSERT INTO dtb_page_layout (
`page_id`, `layout_id`, `sort_no`, `discriminator_type`
) VALUES (
$pageId, 2, $sortNo, 'pagelayout')");
$pageId++;
$this->addSql("INSERT INTO `dtb_page` (
`id`, `master_page_id`, `page_name`, `url`, `file_name`, `edit_type`, `create_date`, `update_date`, `meta_robots`, `discriminator_type`
) VALUES(
$pageId, NULL, '見積申込み/非会員購入情報入力', 'estimate_request_nonmember', 'EstimateRequest/nonmember', 2, NOW(), NOW(), 'noindex', 'page'
)");
$sortNo++;
$this->addSql("INSERT INTO dtb_page_layout (
`page_id`, `layout_id`, `sort_no`, `discriminator_type`
) VALUES (
$pageId, 2, $sortNo, 'pagelayout')");
$pageId++;
$this->addSql("INSERT INTO `dtb_page` (
`id`, `master_page_id`, `page_name`, `url`, `file_name`, `edit_type`, `create_date`, `update_date`, `meta_robots`, `discriminator_type`
) VALUES(
$pageId, NULL, '見積申込み/お届け先の指定', 'estimate_request_shipping', 'EstimateRequest/shipping', 2, NOW(), NOW(), 'noindex', 'page'
)");
$sortNo++;
$this->addSql("INSERT INTO dtb_page_layout (
`page_id`, `layout_id`, `sort_no`, `discriminator_type`
) VALUES (
$pageId, 2, $sortNo, 'pagelayout')");
$pageId++;
$this->addSql("INSERT INTO `dtb_page` (
`id`, `master_page_id`, `page_name`, `url`, `file_name`, `edit_type`, `create_date`, `update_date`, `meta_robots`, `discriminator_type`
) VALUES(
$pageId, NULL, '見積申込み/お届け先の追加', 'estimate_request_shipping_edit', 'EstimateRequest/shipping_edit', 2, NOW(), NOW(), 'noindex', 'page'
)");
$sortNo++;
$this->addSql("INSERT INTO dtb_page_layout (
`page_id`, `layout_id`, `sort_no`, `discriminator_type`
) VALUES (
$pageId, 2, $sortNo, 'pagelayout')");
$pageId++;
$this->addSql("INSERT INTO `dtb_page` (
`id`, `master_page_id`, `page_name`, `url`, `file_name`, `edit_type`, `create_date`, `update_date`, `meta_robots`, `discriminator_type`
) VALUES(
$pageId, NULL, '見積申込み/申込み内容確認', 'estimate_request_confirm', 'EstimateRequest/confirm', 2, NOW(), NOW(), 'noindex', 'page'
)");
$sortNo++;
$this->addSql("INSERT INTO dtb_page_layout (
`page_id`, `layout_id`, `sort_no`, `discriminator_type`
) VALUES (
$pageId, 2, $sortNo, 'pagelayout')");
$pageId++;
$this->addSql("INSERT INTO `dtb_page` (
`id`, `master_page_id`, `page_name`, `url`, `file_name`, `edit_type`, `create_date`, `update_date`, `meta_robots`, `discriminator_type`
) VALUES(
$pageId, NULL, '見積申込み/申込み完了', 'estimate_request_complete', 'EstimateRequest/complete', 2, NOW(), NOW(), 'noindex', 'page'
)");
$sortNo++;
$this->addSql("INSERT INTO dtb_page_layout (
`page_id`, `layout_id`, `sort_no`, `discriminator_type`
) VALUES (
$pageId, 2, $sortNo, 'pagelayout')");
$pageId++;
$this->addSql("INSERT INTO `dtb_page` (
`id`, `master_page_id`, `page_name`, `url`, `file_name`, `edit_type`, `create_date`, `update_date`, `meta_robots`, `discriminator_type`
) VALUES(
$pageId, NULL, '見積りデザイン確認(注文前)', 'design_confirm_before_order', 'EstimateRequest/design_confirm_before_order', 2, NOW(), NOW(), 'noindex', 'page'
)");
$sortNo++;
$this->addSql("INSERT INTO dtb_page_layout (
`page_id`, `layout_id`, `sort_no`, `discriminator_type`
) VALUES (
$pageId, 2, $sortNo, 'pagelayout')");
$pageId++;
$this->addSql("INSERT INTO `dtb_page` (
`id`, `master_page_id`, `page_name`, `url`, `file_name`, `edit_type`, `create_date`, `update_date`, `meta_robots`, `discriminator_type`
) VALUES(
$pageId, NULL, '見積りデザイン確認(注文後)', 'design_confirm_after_order', 'EstimateRequest/design_confirm_after_order', 2, NOW(), NOW(), 'noindex', 'page'
)");
$sortNo++;
$this->addSql("INSERT INTO dtb_page_layout (
`page_id`, `layout_id`, `sort_no`, `discriminator_type`
) VALUES (
$pageId, 2, $sortNo, 'pagelayout')");
$pageId++;
$this->addSql("INSERT INTO `dtb_page` (
`id`, `master_page_id`, `page_name`, `url`, `file_name`, `edit_type`, `create_date`, `update_date`, `meta_robots`, `discriminator_type`
) VALUES(
$pageId, NULL, 'MYページ/見積り一覧', 'mypage_estimate', 'Mypage/estimate', 2, NOW(), NOW(), 'noindex', 'page'
)");
$sortNo++;
$this->addSql("INSERT INTO dtb_page_layout (
`page_id`, `layout_id`, `sort_no`, `discriminator_type`
) VALUES (
$pageId, 2, $sortNo, 'pagelayout')");
$pageId++;
$this->addSql("INSERT INTO `dtb_page` (
`id`, `master_page_id`, `page_name`, `url`, `file_name`, `edit_type`, `create_date`, `update_date`, `meta_robots`, `discriminator_type`
) VALUES(
$pageId, NULL, 'MYページ/見積り詳細', 'mypage_estimate_detail', 'Mypage/estimate_detail', 2, NOW(), NOW(), 'noindex', 'page'
)");
$sortNo++;
$this->addSql("INSERT INTO dtb_page_layout (
`page_id`, `layout_id`, `sort_no`, `discriminator_type`
) VALUES (
$pageId, 2, $sortNo, 'pagelayout')");
}
public function down(Schema $schema): void
{
// this down() migration is auto-generated, please modify it to your needs
}
}