migrations/Version20210510171438.php line 1

Open in your IDE?
  1. <?php
  3. declare(strict_types=1);
  5. namespace DoctrineMigrations;
  7. use Doctrine\DBAL\Schema\Schema;
  8. use Doctrine\Migrations\AbstractMigration;
  10. /**
  11.  * Auto-generated Migration: Please modify to your needs!
  12.  */
  13. final class Version20210510171438 extends AbstractMigration
  14. {
  15.     public function getDescription() : string
  16.     {
  17.         return '';
  18.     }
  20.     public function up(Schema $schema) : void
  21.     {
  22.         $this->addSql("
  23.         SET @id_block = (select id from `std_blocks` WHERE machine_name = 'block_list');
  24.             UPDATE `std_blocks` SET `settings`='{\"isList\": true,\"webpackEntries\": [\"slick-carousel\"]}' WHERE  `id`=@id_block;
  25.         ");
  27.         $this->addSql("
  28.         SET @id_block=(SELECT id FROM std_blocks WHERE machine_name='block_list');    
  29.             INSERT INTO `std_blocks_settings` (`machine_name`, `block_id`, `created_by`, `updated_by`, `name`, `setting_type`, `is_active`, `created_date`, `updated_date`, `order_value`, `settings`) VALUES 
  30.                 ('separator_styles', @id_block, '1', '1', 'Styles', 'SEPARATOR', '1', now(), now(), '10', NULL),
  31.                 ('margin', @id_block, '1', '1', 'Margin [0px 0px 0px 0px]', 'INPUT', '1', now(), now(), '14', NULL),
  32.                 ('padding', @id_block, '1', '1', 'Padding [0px 0px 0px 0px]', 'INPUT', '1', now(), now(), '15', NULL),
  33.                 ('bgcolor', @id_block, '1', '1', 'Background Color', 'COLORPICKER', '1', now(), now(), '16', NULL),
  34.                 ('carousel_1175', @id_block, '1', '1', 'Active', 'CHECKBOX', '1', now(), now(), '31', NULL),
  35.                 ('carousel_600', @id_block, '1', '1', 'Active', 'CHECKBOX', '1', now(), now(), '41', NULL),
  36.                 ('carousel_480', @id_block, '1', '1', 'Active', 'CHECKBOX', '1', now(), now(), '51', NULL);
  38.             UPDATE `std_blocks_settings` SET `name`='Carousel Desktop' WHERE  `block_id`=@id_block AND `machine_name`='separator_carousel_default';
  39.             UPDATE `std_blocks_settings` SET `name`='Carousel Laptop' WHERE  `block_id`=@id_block AND `machine_name`='separator_carousel_1175';
  40.             UPDATE `std_blocks_settings` SET `name`='Carousel Tablet' WHERE  `block_id`=@id_block AND `machine_name`='separator_carousel_600';
  41.             UPDATE `std_blocks_settings` SET `name`='Carousel Mobile' WHERE  `block_id`=@id_block AND `machine_name`='separator_carousel_480';
  42.             UPDATE `std_blocks_settings` SET `name`='Active' WHERE  `block_id`=@id_block AND `machine_name`='carousel';
  45.             UPDATE `std_blocks_settings` SET `order_value`='25' WHERE  `block_id`=@id_block AND `machine_name`='carousel_default_slidesshow';
  46.             UPDATE `std_blocks_settings` SET `order_value`='35' WHERE  `block_id`=@id_block AND `machine_name`='carousel_1175_slidesshow';
  47.             UPDATE `std_blocks_settings` SET `order_value`='45' WHERE  `block_id`=@id_block AND `machine_name`='carousel_600_slidesshow';
  48.             UPDATE `std_blocks_settings` SET `order_value`='55' WHERE  `block_id`=@id_block AND `machine_name`='carousel_480_slidesshow';
  50.             UPDATE `std_blocks_settings` SET `order_value`='26' WHERE  `block_id`=@id_block AND `machine_name`='carousel_default_slidesscroll';
  51.             UPDATE `std_blocks_settings` SET `order_value`='36' WHERE  `block_id`=@id_block AND `machine_name`='carousel_1175_slidesscroll';
  52.             UPDATE `std_blocks_settings` SET `order_value`='46' WHERE  `block_id`=@id_block AND `machine_name`='carousel_600_slidesscroll';
  53.             UPDATE `std_blocks_settings` SET `order_value`='56' WHERE  `block_id`=@id_block AND `machine_name`='carousel_480_slidesscroll';
  55.             UPDATE `std_blocks_settings` SET `order_value`='27' WHERE  `block_id`=@id_block AND `machine_name`='carousel_default_rows';
  56.             UPDATE `std_blocks_settings` SET `order_value`='37' WHERE  `block_id`=@id_block AND `machine_name`='carousel_1175_rows';
  57.             UPDATE `std_blocks_settings` SET `order_value`='47' WHERE  `block_id`=@id_block AND `machine_name`='carousel_600_rows';
  58.             UPDATE `std_blocks_settings` SET `order_value`='57' WHERE  `block_id`=@id_block AND `machine_name`='carousel_480_rows';
  60.             UPDATE `std_blocks_settings` SET `order_value`='28' WHERE  `block_id`=@id_block AND `machine_name`='carousel_default_slidesrow';
  61.             UPDATE `std_blocks_settings` SET `order_value`='38' WHERE  `block_id`=@id_block AND `machine_name`='carousel_1175_slidesrow';
  62.             UPDATE `std_blocks_settings` SET `order_value`='48' WHERE  `block_id`=@id_block AND `machine_name`='carousel_600_slidesrow';
  63.             UPDATE `std_blocks_settings` SET `order_value`='58' WHERE  `block_id`=@id_block AND `machine_name`='carousel_480_slidesrow';
  65.         ");
  68.     }
  70.     public function down(Schema $schema) : void
  71.     {
  72.         $this->addSql("
  73.         SET @id_block = (select id from `std_blocks` WHERE machine_name = 'block_list');
  74.             UPDATE `std_blocks` SET `settings`=NULL WHERE  `id`=@id_block;
  75.         ");
  77.         $this->addSql("
  78.         SET @id_block=(SELECT id FROM std_blocks WHERE machine_name='block_list');
  79.             DELETE FROM `std_blocks_settings` WHERE  `block_id`=@id_block AND `machine_name`='separator_styles';
  80.             DELETE FROM `std_blocks_settings` WHERE  `block_id`=@id_block AND `machine_name`='bgcolor';
  81.             DELETE FROM `std_blocks_settings` WHERE  `block_id`=@id_block AND `machine_name`='margin';
  82.             DELETE FROM `std_blocks_settings` WHERE  `block_id`=@id_block AND `machine_name`='padding';
  83.         ");
  85.     }
  86. }