app/DoctrineMigrations/Version20201127000000.php line 1

Open in your IDE?
  1. <?php
  3. declare(strict_types=1);
  5. /*
  6. * This file is part of EC-CUBE
  7. *
  8. * Copyright(c) EC-CUBE CO.,LTD. All Rights Reserved.
  9. *
  10. * http://www.ec-cube.co.jp/
  11. *
  12. * For the full copyright and license information, please view the LICENSE
  13. * file that was distributed with this source code.
  14. */
  16. namespace DoctrineMigrations;
  18. use Doctrine\DBAL\Schema\Schema;
  19. use Doctrine\Migrations\AbstractMigration;
  21. /**
  22. * Auto-generated Migration: Please modify to your needs!
  23. */
  24. final class Version20201127000000 extends AbstractMigration
  25. {
  26. public function up(Schema $schema): void
  27. {
  28. $count = $this->connection->fetchOne("SELECT COUNT(*) FROM dtb_page WHERE url = 'entry_confirm'");
  29. if ($count > 0) {
  30. return;
  31. }
  32. $pageId = $this->connection->fetchOne('SELECT MAX(id) FROM dtb_page');
  33. $sortNo = $this->connection->fetchOne('SELECT MAX(sort_no) FROM dtb_page_layout');
  35. $pageId++;
  36. $this->addSql("INSERT INTO dtb_page (
  37. id, master_page_id, page_name, url, file_name, edit_type, create_date, update_date, meta_robots, discriminator_type
  38. ) VALUES(
  39. $pageId, 18, '会員登録(確認ページ)', 'entry_confirm', 'Entry/confirm', 3, '2020-01-12 01:15:03', '2020-01-12 01:15:03', 'noindex', 'page'
  40. )");
  42. $sortNo++;
  43. $this->addSql("INSERT INTO dtb_page_layout (page_id, layout_id, sort_no, discriminator_type) VALUES ($pageId, 2, $sortNo, 'pagelayout')");
  45. $pageId++;
  46. $this->addSql("INSERT INTO dtb_page (
  47. id, master_page_id, page_name, url, file_name, edit_type, create_date, update_date, meta_robots, discriminator_type
  48. ) VALUES(
  49. $pageId, 12, 'MYページ/退会手続き(確認ページ)', 'mypage_withdraw_confirm', 'Mypage/withdraw_confirm', 3, '2020-01-12 01:15:03', '2020-01-12 01:15:03', 'noindex', 'page'
  50. )");
  52. $sortNo++;
  53. $this->addSql("INSERT INTO dtb_page_layout (page_id, layout_id, sort_no, discriminator_type) VALUES ($pageId, 2, $sortNo, 'pagelayout')");
  55. $pageId++;
  56. $this->addSql("INSERT INTO dtb_page (
  57. id, master_page_id, page_name, url, file_name, edit_type, create_date, update_date, meta_robots, discriminator_type
  58. ) VALUES(
  59. $pageId, 16, 'お問い合わせ(確認ページ)', 'contact_confirm', 'Contact/confirm', 3, '2020-01-12 01:15:03', '2020-01-12 01:15:03', 'noindex', 'page'
  60. )");
  62. $sortNo++;
  63. $this->addSql("INSERT INTO dtb_page_layout (page_id, layout_id, sort_no, discriminator_type) VALUES ($pageId, 2, $sortNo, 'pagelayout')");
  65. if ($this->platform->getName() === 'postgresql') {
  66. $this->addSql("SELECT setval('dtb_page_id_seq', $pageId)");
  67. }
  68. }
  70. public function down(Schema $schema): void
  71. {
  72. // this down() migration is auto-generated, please modify it to your needs
  73. }
  74. }