app/DoctrineMigrations/Version24121700_AddProductExCartCsv.php line 1

Open in your IDE?
  1. <?php
  2. declare(strict_types=1);
  4. namespace DoctrineMigrations;
  6. use Doctrine\DBAL\Schema\Schema;
  7. use Doctrine\Migrations\AbstractMigration;
  9. final class Version24121700_AddProductExCartCsv extends AbstractMigration
  10. {
  11.     public function up(Schema $schema): void
  12.     {
  13.         $this->addSql("
  14.             INSERT INTO dtb_csv (
  15.                 csv_type_id,
  16.                 entity_name,
  17.                 field_name,
  18.                 reference_field_name,
  19.                 disp_name,
  20.                 sort_no,
  21.                 enabled,
  22.                 create_date,
  23.                 update_date,
  24.                 discriminator_type
  25.             )
  26.             VALUES
  27.             -- 売価非表示コメント
  28.             (
  29.                 1,
  30.                 'Customize\\Entity\\ProductEx',
  31.                 'Product',
  32.                 'info_comment2',
  33.                 '売価非表示コメント',
  34.                 34,
  35.                 1,
  36.                 CURRENT_TIMESTAMP,
  37.                 CURRENT_TIMESTAMP,
  38.                 'csv'
  39.             ),
  40.             -- 売価非表示フラグ
  41.             (
  42.                 1,
  43.                 'Customize\\Entity\\ProductEx',
  44.                 'Product',
  45.                 'ask_price',
  46.                 '売価非表示フラグ',
  47.                 35,
  48.                 1,
  49.                 CURRENT_TIMESTAMP,
  50.                 CURRENT_TIMESTAMP,
  51.                 'csv'
  52.             ),
  53.             -- カートボタン非表示フラグ
  54.             (
  55.                 1,
  56.                 'Customize\\Entity\\ProductEx',
  57.                 'Product',
  58.                 'disable_cart',
  59.                 'カートボタン非表示フラグ',
  60.                 36,
  61.                 1,
  62.                 CURRENT_TIMESTAMP,
  63.                 CURRENT_TIMESTAMP,
  64.                 'csv'
  65.             )
  66.         ");
  67.     }
  69.     public function down(Schema $schema): void
  70.     {
  71.         $this->addSql("
  72.             DELETE FROM dtb_csv 
  73.             WHERE entity_name = 'Customize\\Entity\\ProductEx'
  74.             AND field_name = 'Product'
  75.             AND reference_field_name IN ('info_comment2', 'ask_price', 'disable_cart')
  76.             AND csv_type_id = 1
  77.         ");
  78.     }
  79. }