<?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 Version20230712154321 extends AbstractMigration
{
public function getDescription(): string
{
return 'Add new notifications';
}
public function up(Schema $schema): void
{
// this up() migration is auto-generated, please modify it to your needs
$this->addSql("INSERT INTO blomqvist.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 ('SELLER_OBJECT_NOT_SOLD_SECOND_OVER_4000_NOR', 49, '<p>Hei %user_name%</p><p> </p><p>Ditt objekt ble dessverre ikke solgt. </p><p> </p><p>Objekt: <a href=\"%link_to_lot%\">%lot_number% %object_title%</a></p><p>Vurdering: %evaluation%</p><p>Minstepris: %minimum_bid% </p><p> </p><p> </p><p>Dette var det andre forsøket på auksjon. For objekter med en lav vurdering under 4 000 kroner vil minsteprisen automatisk bli halvert etter 14 dager, og objekter forsøkt på nytt. For objekter med høyere vurdering vil din kontraktansvarlig snart ta kontakt med deg for å diskutere neste steg. Du har også muligheten til å endre minsteprisen selv under <a href=\"https://www.blomqvist.no/min-side/salg-og-kontrakter\">Mine salg og kontrakter</a>. </p><p> </p><p>Dersom du ønkser å hente objektet i retur, <a href=\"%link_to_lot%\">gi oss beskjed her</a>. </p><p> </p><p>Si ifra dersom du har noen spørsmål. <br>Mvh,<br>Blomqvist </p><p> </p>', 'Ditt objekt ble dessverre ikke solgt, men vi forsøker gjerne igjen. Da må du først redusere minsteprisen. Flere detaljer finner du på Min Side på blomqvist.no', 'Usolgt objekt - andre forsøk', '2023-07-12 15:35:44', '2023-07-12 15:35:44', '<p><a href=\"%link_to_lot%\">%lot_number% %object_title%</a>. </p><p>Ditt objekt ble dessverre ikke solgt. Dette var det andre forsøket på auksjon. For objekter med en lav vurdering under 5 000 kroner vil minsteprisen automatisk bli halvert etter syv dager og objekter forsøkt på nytt. For andre objekter vil din kontraktansvarlig snart ta kontakt med deg for å diskutere neste steg. Du har også muligheten til å endre minsteprisen selv under <a href=\"https://www.blomqvist.no/min-side/salg-og-kontrakter\">Mine salg og kontrakter</a>. </p>', 'nor-NO', 'Mine salg', 60, 6, '', 'yellow', 'Usolgt objekt ');");
$this->addSql("INSERT INTO blomqvist.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 ('SELLER_OBJECT_NOT_SOLD_SECOND_OVER_4000_ENG', 49, '<p>Hei %user_name%</p><p> </p><p>Your lot was unfortunately not sold. </p><p> </p><p>Lot: <a href=\"%link_to_lot%\">%lot_number% %object_title%</a></p><p>Estimate: %evaluation%</p><p>Starting price: %minimum_bid% </p><p><br>This was our second attempt at auction. For lots with a low estimate of 4 000 NOK or less, we will automatically half the starting price after 14 days, and try again. For other lots, your contract specialist will be in touch to discuss the next steps. You may also adjust the starting price yourself under <a href=\"https://www.blomqvist.no/en/my-page/my-contracts\">My Consignments and Contracts</a>. </p><p> </p><p>If you wish to collect the lot, <a href=\"%link_to_lot%\">please let us know here</a>. </p><p> </p><p>If you have any questions, please let us know. </p><p>Sincerely,</p><p>Blomqvist </p><p> </p>', 'Your lot was unfortunately not sold, but we want to try again. Please go to My Page on blomqvist.no to learn more about reducing the starting price and the next steps. ', 'Unsold lot', '2023-07-12 15:35:44', '2023-07-12 15:35:44', '<p><a href=\"%link_to_lot%\">%lot_number% %object_title%</a> </p><p>Your lot was unfortunately not sold, but we want to try again. For lots with a low estimate of 5 000 NOK or less, we will automatically half the starting price after seven days and try again. For other lots, your contract specialist will be in touch to discuss the next steps. You may adjust the starting price yourself under <a href=\"https://www.blomqvist.no/en/my-page/my-contracts\">My Consignments and Contracts</a>. </p>', 'eng-GB', 'Mine salg', 60, 6, '', 'yellow', 'Unsold lot');");
}
public function down(Schema $schema): void
{
// this down() migration is auto-generated, please modify it to your needs
$this->addSql("DELETE FROM notification_template WHERE identifier IN ('SELLER_OBJECT_NOT_SOLD_SECOND_OVER_4000_NOR', 'SELLER_OBJECT_NOT_SOLD_SECOND_OVER_4000_ENG');");
}
}