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. }