migrations/Version20240405234027.php line 1

Open in your IDE?
  1. <?php
  2. declare(strict_types=1);
  3. namespace DoctrineMigrations;
  4. use Doctrine\DBAL\Schema\Schema;
  5. use Doctrine\Migrations\AbstractMigration;
  6. /**
  7.  * Auto-generated Migration: Please modify to your needs!
  8.  */
  9. final class Version20240405234027 extends AbstractMigration
  10. {
  11.     public function getDescription(): string
  12.     {
  13.         return 'Create the Online Valuation notification template';
  14.     }
  15.     public function up(Schema $schema): void
  16.     {
  17.         $this->addSql("INSERT INTO `notification_template` (identifier, notification_type, text_email, text_sms, subject, created_at, updated_at, text_system, notification_language, category, setting, profile_default, icon, color, profile_title) VALUES
  18.         ('ONLINE_VALUATION_NOR',128,'<div> <p><strong>Kundenr: </strong>  %user_id%</p> <p><strong>Navn: </strong>  %first_name% %last_name%</p> <p><strong>E-post: </strong>  %email%</p> <p><strong>Telefon: </strong>  %mobile%</p> <p><strong>Addresse: </strong>  %address%</p> <p><strong>Poststed: </strong>  %post_code%. %city%</p> </div> <div> <h2>Valuation information</h2> <p><strong>Kategori: </strong>  %category%</p> <p><strong>Navn på kunstner/formgiver: </strong>  %artist_name%</p> <p><strong>Tittel/beskrivelse: </strong>  %title%</p> <p><strong>Mål i centimeter: </strong>  %measurements%</p> <p><strong>Datering/alder: </strong>  %date_age%</p> <p><strong>Teknikk/materiale: </strong>  %technique_materials%</p> <p><strong>Skader/Tilstand: </strong>  %damages_condition%</p> <p><strong>Eierskap og annet: </strong>  %ownership_other%</p> </div>',NULL,'Online Valutering','2024-04-05 21:12:01','2024-04-05 21:12:01','','nor-NO',NULL,0,7,NULL,NULL,'Online Valutering'),
  19.         ('ONLINE_VALUATION_ENG',128,'<div><p><strong>User ID: </strong>  %user_id%</p> <p><strong>full name: </strong>  %first_name% %last_name%</p> <p><strong>Email: </strong>  %email%</p> <p><strong>Mobile: </strong>  %mobile%</p> <p><strong>Address: </strong>  %address%</p> <p><strong>Postal address: </strong>  %post_code%. %city%</p> </div> <div> <h2>Valuation information</h2> <p><strong>Category: </strong>  %category%</p> <p><strong>Artist name: </strong>  %artist_name%</p> <p><strong>Title/description: </strong>  %title%</p> <p><strong>Measurements: </strong>  %measurements%</p> <p><strong>Date/age: </strong>  %date_age%</p> <p><strong>Technique/materials: </strong>  %technique_materials%</p> <p><strong>Damages/condition: </strong>  %damages_condition%</p> <p><strong>Ownership and other: </strong>  %ownership_other%</p> </div>',NULL,'Online Valuation','2024-04-05 21:12:01','2024-04-05 21:12:01','','eng-GB',NULL,0,7,NULL,NULL,'Online Valuation');");
  20.     }
  21.     public function down(Schema $schema): void
  22.     {
  23.         $this->addSql("DELETE FROM notification_template WHERE identifier IN ('ONLINE_VALUATION_NOR', 'ONLINE_VALUATION_ENG');");
  24.     }
  25. }