vendor/bluue/planning-bundle/migrations/Version20230830081226.php line 1

Open in your IDE?
  1. <?php
  3. declare(strict_types=1);
  5. namespace PlanningBundleMigrations;
  7. use Doctrine\DBAL\Schema\Schema;
  8. use Symfony\Component\Uid\UuidV6;
  9. use Doctrine\Migrations\AbstractMigration;
  11. final class Version20230830081226 extends AbstractMigration
  12. {
  13.     public function up(Schema $schema): void
  14.     {
  15.         $this->addSql('ALTER TABLE planning_bundle__slot_type ADD respected TINYINT(1) DEFAULT 0 NOT NULL');
  16.         $this->addSql('CREATE INDEX respected ON planning_bundle__slot_type (respected)');
  17.     }
  19.     public function down(Schema $schema): void
  20.     {
  21.         $this->addSql('DROP INDEX respected ON planning_bundle__slot_type');
  22.         $this->addSql('ALTER TABLE planning_bundle__slot_type DROP respected');
  23.     }
  25.     public function postUp(Schema $schema): void
  26.     {
  27.         parent::postUp($schema);
  29.         $now = (new \DateTime())->format('Y-m-d H:i:s');
  31.         $languages = $this->connection->executeQuery('SELECT * FROM language WHERE deleted_at IS NULL')
  32.             ->fetchAllAssociative();
  34.         $rootLocale = 'en';
  35.         $defaultLocale = $this->connection
  36.             ->executeQuery('SELECT locale FROM language WHERE deleted_at IS NULL AND is_default = 1')
  37.             ->fetchOne() ?: 'en';
  39.         $slotTypes = [
  40.             [
  41.                 'names' => ['fr' => 'Respecté', 'en' => 'Respected'],
  42.                 'color' => '#22d325',
  43.                 'text_color' => '#ffffff',
  44.                 'active' => 1,
  45.                 'default' => 0,
  46.                 'respected' => 1
  47.             ]
  48.         ];
  50.         foreach ($slotTypes as $slotType) {
  51.             $slotTypeId = (new UuidV6())->toBinary();
  52.             $this->connection->insert('planning_bundle__slot_type', [
  53.                 'id' => $slotTypeId,
  54.                 'name' => !empty($slotType['names'][$defaultLocale]) ?
  55.                     $slotType['names'][$defaultLocale] : $slotType['names'][$rootLocale],
  56.                 'color' => $slotType['color'],
  57.                 'text_color' => $slotType['text_color'],
  58.                 'is_active' => $slotType['active'],
  59.                 'is_default' => $slotType['default'],
  60.                 'respected' => $slotType['respected'],
  61.                 'created_at' => $now,
  62.                 'updated_at' => $now
  63.             ]);
  65.             foreach ($languages as $language) {
  66.                 $localeTo = $rootLocale;
  67.                 if (!empty($slotType['names'][$language['locale']])) {
  68.                     $localeTo = $language['locale'];
  69.                 } elseif (!empty($slotType['names'][$defaultLocale])) {
  70.                     $localeTo = $defaultLocale;
  71.                 }
  73.                 $this->connection->insert('planning_bundle__slot_type_translations', [
  74.                     'object_id' => $slotTypeId,
  75.                     'locale' => $language['locale'],
  76.                     'field' => 'name',
  77.                     'content' => $slotType['names'][$localeTo]
  78.                 ]);
  79.             }
  80.         }
  81.     }
  82. }