<?php
declare(strict_types=1);
namespace DoctrineMigrations;
use Doctrine\DBAL\Schema\Schema;
use Doctrine\Migrations\AbstractMigration;
final class Version24121700_AddProductExCartCsv extends AbstractMigration
{
public function up(Schema $schema): void
{
$this->addSql("
INSERT INTO dtb_csv (
csv_type_id,
entity_name,
field_name,
reference_field_name,
disp_name,
sort_no,
enabled,
create_date,
update_date,
discriminator_type
)
VALUES
-- 売価非表示コメント
(
1,
'Customize\\Entity\\ProductEx',
'Product',
'info_comment2',
'売価非表示コメント',
34,
1,
CURRENT_TIMESTAMP,
CURRENT_TIMESTAMP,
'csv'
),
-- 売価非表示フラグ
(
1,
'Customize\\Entity\\ProductEx',
'Product',
'ask_price',
'売価非表示フラグ',
35,
1,
CURRENT_TIMESTAMP,
CURRENT_TIMESTAMP,
'csv'
),
-- カートボタン非表示フラグ
(
1,
'Customize\\Entity\\ProductEx',
'Product',
'disable_cart',
'カートボタン非表示フラグ',
36,
1,
CURRENT_TIMESTAMP,
CURRENT_TIMESTAMP,
'csv'
)
");
}
public function down(Schema $schema): void
{
$this->addSql("
DELETE FROM dtb_csv
WHERE entity_name = 'Customize\\Entity\\ProductEx'
AND field_name = 'Product'
AND reference_field_name IN ('info_comment2', 'ask_price', 'disable_cart')
AND csv_type_id = 1
");
}
}