migrations/Version20251022183255.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 Version20251022183255 extends AbstractMigration
  14. {
  15.     // shared-sales-stats (old, to be replaced)
  16.     public const OLD_WIDGET_ID = 36;
  18.     // New widgets
  19.     public const WIDGET_ID_1 = 38; // shared-sales-ranking
  20.     public const WIDGET_ID_2 = 39; // shared-sales-customers
  21.     public const WIDGET_ID_3 = 40; // shared-sales-fees
  22.     public const WIDGET_ID_4 = 41; // shared-sales-cash
  23.     public const WIDGET_ID_5 = 42; // shared-sales-new-leads
  24.     public const WIDGET_ID_6 = 43; // shared-sales-new-opportunities
  25.     public const WIDGET_ID_7 = 44; // shared-unread-messages
  26.     public const WIDGET_ID_8 = 45; // shared-unread-feeds
  27.     public const WIDGET_ID_9 = 46; // shared-unread-streams
  28.     public const WIDGET_ID_10 = 47; // shared-unread-projects
  29.     public const WIDGET_ID_11 = 48; // shared-open-issues
  31.     public function getDescription(): string
  32.     {
  33.         return '';
  34.     }
  36.     public function up(Schema $schema): void
  37.     {
  38.         // this up() migration is auto-generated, please modify it to your needs
  39.         foreach (self::newWidgets() as [$id, $token, $name]) {
  40.             $this->addSql(
  41.                 'INSERT INTO widget (id, token, name, category, enabled) VALUES (?, ?, ?, ?, 1)',
  42.                 [$id, $token, $name, 'Shared']
  43.             );
  44.         }
  46.         /** @#var string $idList */
  47.         $idList = $this->idListSql(self::newWidgetIds());
  49.         $this->addSql(sprintf(
  50.             '
  51.                 INSERT INTO user_widget (object_id, widget_id)
  52.                 SELECT uw.object_id, w.id
  53.                 FROM user_widget uw
  54.                 JOIN widget w ON w.id IN (%s)
  55.                 WHERE uw.widget_id = %d
  56.             ',
  57.             $idList,
  58.             self::OLD_WIDGET_ID
  59.         ));
  61.         $this->addSql(sprintf('DELETE FROM widget WHERE id = %d', self::OLD_WIDGET_ID));
  62.         $this->addSql(sprintf('DELETE FROM user_widget WHERE widget_id = %d', self::OLD_WIDGET_ID));
  63.     }
  65.     public function down(Schema $schema): void
  66.     {
  67.         // this down() migration is auto-generated, please modify it to your needs
  68.         $this->addSql(sprintf('INSERT INTO widget (id, token, name, category, enabled) VALUES (%d, \'shared-sales-stats\', \'Sales Stats\', \'Shared\', 1)', self::OLD_WIDGET_ID));
  70.         /** @#var string $idList */
  71.         $idList = $this->idListSql(self::newWidgetIds());
  73.         $this->addSql(sprintf(
  74.             '
  75.                 INSERT INTO user_widget (object_id, widget_id)
  76.                 SELECT DISTINCT object_id, %d
  77.                 FROM user_widget
  78.                 WHERE widget_id IN (%s)
  79.             ',
  80.             self::OLD_WIDGET_ID,
  81.             $idList
  82.         ));
  84.         $this->addSql(sprintf('DELETE FROM widget WHERE id in (%s)', $idList));
  85.         $this->addSql(sprintf('DELETE FROM user_widget WHERE widget_id in (%s)', $idList));
  86.     }
  88.     /**
  89.      * @return array
  90.      */
  91.     private static function newWidgetIds(): array
  92.     {
  93.         return [
  94.             self::WIDGET_ID_1,
  95.             self::WIDGET_ID_2,
  96.             self::WIDGET_ID_3,
  97.             self::WIDGET_ID_4,
  98.             self::WIDGET_ID_5,
  99.             self::WIDGET_ID_6,
  100.             self::WIDGET_ID_7,
  101.             self::WIDGET_ID_8,
  102.             self::WIDGET_ID_9,
  103.             self::WIDGET_ID_10,
  104.             self::WIDGET_ID_11,
  105.         ];
  106.     }
  108.     /**
  109.      * @return array
  110.      */
  111.     private static function newWidgets(): array
  112.     {
  113.         return [
  114.             [self::WIDGET_ID_1,  'shared-sales-ranking',           'Sales Ranking'],
  115.             [self::WIDGET_ID_2,  'shared-sales-customers',         'Sales Customers'],
  116.             [self::WIDGET_ID_3,  'shared-sales-fees',              'Sales Fees'],
  117.             [self::WIDGET_ID_4,  'shared-sales-cash',              'Sales Cash'],
  118.             [self::WIDGET_ID_5,  'shared-sales-new-leads',         'Sales New Leads'],
  119.             [self::WIDGET_ID_6,  'shared-sales-new-opportunities', 'Sales New Opportunities'],
  120.             [self::WIDGET_ID_7,  'shared-unread-messages',         'Sales Unread Messages'],
  121.             [self::WIDGET_ID_8,  'shared-unread-feeds',            'Sales Unread Feeds'],
  122.             [self::WIDGET_ID_9,  'shared-unread-streams',          'Sales Unread Streams'],
  123.             [self::WIDGET_ID_10, 'shared-unread-projects',         'Sales Unread Projects'],
  124.             [self::WIDGET_ID_11, 'shared-open-issues',             'Sales Open Tickets'],
  125.         ];
  126.     }
  128.     /**
  129.      * @param array $ids
  130.      *
  131.      * @return string
  132.      */
  133.     private function idListSql(array $ids): string
  134.     {
  135.         return implode(',', array_map('intval', $ids));
  136.     }
  137. }