migrations/Version20251009142530.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 Version20251009142530 extends AbstractMigration
  14. {
  15.     public function getDescription(): string
  16.     {
  17.         return '';
  18.     }
  20.     public function up(Schema $schema): void
  21.     {
  22.         // this up() migration is auto-generated, please modify it to your needs
  23.         $this->addSql('ALTER TABLE channel_user_data_cursus_company ADD address_street VARCHAR(255) DEFAULT NULL, ADD address_post_code VARCHAR(15) DEFAULT NULL, ADD address_city VARCHAR(255) DEFAULT NULL, ADD address_country VARCHAR(2) DEFAULT NULL, ADD internship_address_street VARCHAR(255) DEFAULT NULL, ADD internship_address_post_code VARCHAR(15) DEFAULT NULL, ADD internship_address_city VARCHAR(255) DEFAULT NULL, ADD internship_address_country VARCHAR(2) DEFAULT NULL');
  24.     }
  26.     public function down(Schema $schema): void
  27.     {
  28.         // this down() migration is auto-generated, please modify it to your needs
  29.         $this->addSql('ALTER TABLE channel_user_data_cursus_company DROP address_street, DROP address_post_code, DROP address_city, DROP address_country, DROP internship_address_street, DROP internship_address_post_code, DROP internship_address_city, DROP internship_address_country');
  30.     }
  32.     public function postUp(Schema $schema): void
  33.     {
  34.         // Company addresses
  35.         $companies = $this->connection->fetchAllAssociative('SELECT id, address FROM channel_user_data_cursus_company WHERE address IS NOT NULL AND address <> ""');
  37.         foreach ($companies as $company) {
  38.             $id = $company['id'];
  40.             $oldAddress = $company['address'];
  41.             $fullAddress = $this->parseFullAddress($oldAddress);
  43.             $this->connection->update('channel_user_data_cursus_company', $fullAddress, [
  44.                 'id' => $id,
  45.             ]);
  46.         }
  48.         // Internship addresses
  49.         $companies = $this->connection->fetchAllAssociative('SELECT id, internship_address FROM channel_user_data_cursus_company WHERE internship_address IS NOT NULL AND internship_address <> ""');
  51.         foreach ($companies as $company) {
  52.             $id = $company['id'];
  54.             $oldAddress = $company['internship_address'];
  55.             $fullAddress = $this->parseFullAddress($oldAddress, 'internship_');
  57.             $this->connection->update('channel_user_data_cursus_company', $fullAddress, [
  58.                 'id' => $id,
  59.             ]);
  60.         }
  62.     }
  64.     private function parseFullAddress($oldAddress, string $prefix = ''): array
  65.     {
  66.         $addressStreet = $oldAddress;
  67.         $addressStreet = preg_replace("/\r\n|\r/", "\n", $addressStreet);
  68.         $addressStreet = preg_replace('/\s+/u', ' ', $addressStreet);
  69.         $addressStreet = trim($addressStreet);
  70.         $addressPostCode = null;
  71.         $addressCity = null;
  72.         $addressCountry = 'FR';
  74.         if (preg_match('/^(?P<street>.*?)\s*[-]?\s*(?P<postcode>\d{4,5})\s*[-,]?\s+(?P<city>[\p{L}\-\'\/\s]+(?:\s\d{1,2})?)$/us', $oldAddress, $matches)) {
  75.             // Adress like "street 0000[0] city"
  76.             $addressStreet = trim($matches['street']);
  77.             $addressPostCode = trim($matches['postcode']);
  78.             $addressCity = trim($matches['city']);
  79.         }
  81.         if (null === $addressPostCode && null === $addressCity) {
  82.             if (preg_match('/^(?P<street>.*?),\s*(?P<city>.*?),\s*(?P<postcode>\d{4,5})$/u', $addressStreet, $matches)) {
  83.                 // Adress like "street, city, 0000[0]"
  84.                 $addressStreet = trim($matches['street']);
  85.                 $addressPostCode = trim($matches['postcode']);
  86.                 $addressCity = trim($matches['city']);
  87.             }
  88.         }
  90.         $addressStreet = rtrim($addressStreet, ", \t\n\r\0\x0B");
  92.         return [
  93.             $prefix . 'address_street' => $addressStreet,
  94.             $prefix . 'address_post_code' => $addressPostCode,
  95.             $prefix . 'address_city' => $addressCity,
  96.             $prefix . 'address_country' => $addressCountry,
  97.         ];
  98.     }
  99. }