<?php
declare(strict_types=1);
namespace DoctrineMigrations;
use Doctrine\DBAL\Schema\Schema;
use Doctrine\Migrations\AbstractMigration;
/**
* Auto-generated Migration: Please modify to your needs!
*/
final class Version20240405234027 extends AbstractMigration
{
public function getDescription(): string
{
return 'Create the Online Valuation notification template';
}
public function up(Schema $schema): void
{
$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
('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'),
('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');");
}
public function down(Schema $schema): void
{
$this->addSql("DELETE FROM notification_template WHERE identifier IN ('ONLINE_VALUATION_NOR', 'ONLINE_VALUATION_ENG');");
}
}