migrations/Version20260220210804.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. final class Version20260220210804 extends AbstractMigration
  11. {
  12.     public function getDescription(): string
  13.     {
  14.         return 'Filling customers info on orders table';
  15.     }
  17.     public function up(Schema $schema): void
  18.     {
  19.         // setting customer_name
  20.         $this->addSql("
  21.             UPDATE
  22.                 `order` o
  23.             INNER JOIN `user` u ON
  24.                 o.customer_id = u.id
  25.             SET
  26.                 o.customer_name = CONCAT(u.first_name, ' ', u.last_name)
  27.             WHERE
  28.                 o.created_by_guest = 0
  29.         ");
  31.         // setting customer_phone
  32.         $this->addSql("
  33.             UPDATE
  34.                 `order` o
  35.             INNER JOIN `user` u ON
  36.                 o.customer_id = u.id
  37.             SET
  38.                 o.customer_phone = u.phone
  39.             WHERE
  40.                 o.created_by_guest = 0
  41.         ");
  43.         // setting customer_email and managing cases deleted users
  44.         $this->addSql("
  45.             UPDATE `order` o
  46.             INNER JOIN `user` u ON o.customer_id = u.id
  47.             SET o.customer_email = CASE
  48.                 WHEN u.email LIKE 'deleted-%' THEN
  49.                     NULLIF(
  50.                         SUBSTRING(
  51.                             u.email,
  52.                             LOCATE('-', u.email, LOCATE('-', u.email) + 1) + 1
  53.                         ),
  54.                         ''
  55.                     )
  56.                 ELSE u.email
  57.             END
  58.             WHERE o.created_by_guest = 0
  59.             AND (o.customer_email IS NULL OR o.customer_email = '');
  60.         ");
  61.     }
  62. }