Symfony Profiler

<?php declare(strict_types=1);
namespace Neno\MarketingEssentials;
use Doctrine\DBAL\Connection;
use Doctrine\DBAL\Exception\UniqueConstraintViolationException;
use Shopware\Core\Content\MailTemplate\Aggregate\MailTemplateType\MailTemplateTypeEntity;
use Shopware\Core\Defaults;
use Shopware\Core\Framework\DataAbstractionLayer\EntityRepositoryInterface;
use Shopware\Core\Framework\DataAbstractionLayer\Search\Criteria;
use Shopware\Core\Framework\DataAbstractionLayer\Search\Filter\EqualsFilter;
use Shopware\Core\Framework\DataAbstractionLayer\Search\Filter\MultiFilter;
use Shopware\Core\Framework\Plugin;
use Shopware\Core\Framework\Plugin\Context\InstallContext;
use Shopware\Core\Framework\Plugin\Context\UninstallContext;
use Shopware\Core\Framework\Uuid\Uuid;
class NenoMarketingEssentials extends Plugin
{
// Newsletter mail
public const TEMPLATE_TYPE_NAME = 'Neno newsletter registration promotion';
public const TEMPLATE_TYPE_TECHNICAL_NAME = 'neno_newsletter_register_promotion';
// Register mail
public const REGISTER_PROMOTION_TEMPLATE_TYPE_NAME = 'Neno registration promotion';
public const REGISTER_PROMOTION_TEMPLATE_TYPE_TECHNICAL_NAME = 'neno_register_promotion';
private function fetchMailTemplateType($type, Connection $connection) {
$result = $connection->fetchAllAssociative('SELECT * FROM mail_template_type WHERE technical_name = ?', array($type));
if ($result && array_key_exists(0, $result)) {
return Uuid::fromBytesToHex($result[0]['id']);
}
return null;
}
private function checkMailTemplate($id, $context) {
$mailTemplateRepository = $this->container->get('mail_template.repository');
$criteria = new Criteria();
$criteria->addFilter(new EqualsFilter('mailTemplateTypeId', $id));
return $mailTemplateRepository->search($criteria, $context->getContext())->first() != null;
}
public function install(InstallContext $installContext): void
{
$connection = $this->container->get(Connection::class);
// Create newsletter mail
$newsletterMailTemplateTypeId = $this->fetchMailTemplateType(self::TEMPLATE_TYPE_TECHNICAL_NAME, $connection);
if (!$newsletterMailTemplateTypeId) {
$newsletterMailTemplateTypeId = Uuid::randomHex();
$this->createNewsletterMailTemplateType($connection, $newsletterMailTemplateTypeId);
}
if (!$this->checkMailTemplate($newsletterMailTemplateTypeId, $installContext)) {
try {
$this->createNewsletterMailTemplate($connection, $newsletterMailTemplateTypeId);
} catch (UniqueConstraintViolationException $err) {}
}
// Create register mail
$registerMailTemplateTypeId = $this->fetchMailTemplateType(self::REGISTER_PROMOTION_TEMPLATE_TYPE_TECHNICAL_NAME, $connection);
if(!$registerMailTemplateTypeId) {
$registerMailTemplateTypeId = Uuid::randomHex();
$this->createRegisterMailTemplateType($connection, $registerMailTemplateTypeId);
}
if (!$this->checkMailTemplate($registerMailTemplateTypeId, $installContext)) {
try {
$this->createRegisterMailTemplate($connection, $registerMailTemplateTypeId);
} catch (UniqueConstraintViolationException $err) {}
}
}
/* ---- Newsletter mail ---- */
// create mail template type
private function createNewsletterMailTemplateType($connection, $mailTemplateTypeId)
{
$enLangId = $this->getLanguageIdByLocale($connection, 'en-GB');
$deLangId = $this->getLanguageIdByLocale($connection, 'de-DE');
$connection->insert('mail_template_type', [
'id' => Uuid::fromHexToBytes($mailTemplateTypeId),
'technical_name' => self::TEMPLATE_TYPE_TECHNICAL_NAME,
'available_entities' => json_encode([
'newsletterRecipient' => 'newsletter_recipient',
'promotion' => 'promotion',
'salesChannel' => 'sales_channel'
]),
'created_at' => (new \DateTime())->format(Defaults::STORAGE_DATE_TIME_FORMAT),
]);
if ($enLangId) {
$connection->insert('mail_template_type_translation', [
'mail_template_type_id' => Uuid::fromHexToBytes($mailTemplateTypeId),
'language_id' => $enLangId,
'name' => self::TEMPLATE_TYPE_NAME,
'created_at' => (new \DateTime())->format(Defaults::STORAGE_DATE_TIME_FORMAT),
]);
}
if ($deLangId) {
$connection->insert('mail_template_type_translation', [
'mail_template_type_id' => Uuid::fromHexToBytes($mailTemplateTypeId),
'language_id' => $deLangId,
'name' => self::TEMPLATE_TYPE_NAME,
'created_at' => (new \DateTime())->format(Defaults::STORAGE_DATE_TIME_FORMAT),
]);
}
if (
$deLangId != Uuid::fromHexToBytes(Defaults::LANGUAGE_SYSTEM) &&
$enLangId != Uuid::fromHexToBytes(Defaults::LANGUAGE_SYSTEM)
) {
$connection->insert('mail_template_type_translation', [
'mail_template_type_id' => Uuid::fromHexToBytes($mailTemplateTypeId),
'language_id' => Uuid::fromHexToBytes(Defaults::LANGUAGE_SYSTEM),
'name' => self::TEMPLATE_TYPE_NAME,
'created_at' => (new \DateTime())->format(Defaults::STORAGE_DATE_TIME_FORMAT),
]);
}
}
// Create mail template
private function createNewsletterMailTemplate($connection, $mailTemplateTypeId)
{
$mailTemplateId = Uuid::randomHex();
$enLangId = $this->getLanguageIdByLocale($connection, 'en-GB');
$deLangId = $this->getLanguageIdByLocale($connection, 'de-DE');
$connection->insert('mail_template', [
'id' => Uuid::fromHexToBytes($mailTemplateId),
'mail_template_type_id' => Uuid::fromHexToBytes($mailTemplateTypeId),
'system_default' => true,
'created_at' => (new \DateTime())->format(Defaults::STORAGE_DATE_TIME_FORMAT),
]);
if ($enLangId) {
$connection->insert('mail_template_translation', [
'mail_template_id' => Uuid::fromHexToBytes($mailTemplateId),
'language_id' => $enLangId,
'sender_name' => '{{ salesChannel.name }}',
'subject' => 'Your coupon code. Thank you for registering for the newsletter',
'description' => '',
'content_html' => $this->getNewsletterContentHtmlEn(),
'content_plain' => $this->getNewsletterContentPlainEn(),
'created_at' => (new \DateTime())->format(Defaults::STORAGE_DATE_TIME_FORMAT),
]);
}
if ($deLangId) {
$connection->insert('mail_template_translation', [
'mail_template_id' => Uuid::fromHexToBytes($mailTemplateId),
'language_id' => $this->getLanguageIdByLocale($connection, 'de-DE'),
'sender_name' => '{{ salesChannel.name }}',
'subject' => 'Dein coupon code. Danke für die Registrierung zum Newsletter',
'description' => '',
'content_html' => $this->getNewsletterContentHtmlDe(),
'content_plain' => $this->getNewsletterContentPlainDe(),
'created_at' => (new \DateTime())->format(Defaults::STORAGE_DATE_TIME_FORMAT),
]);
}
if (
$deLangId != Uuid::fromHexToBytes(Defaults::LANGUAGE_SYSTEM) &&
$enLangId != Uuid::fromHexToBytes(Defaults::LANGUAGE_SYSTEM)
) {
$connection->insert('mail_template_translation', [
'mail_template_id' => Uuid::fromHexToBytes($mailTemplateId),
'language_id' => Uuid::fromHexToBytes(Defaults::LANGUAGE_SYSTEM),
'sender_name' => '{{ salesChannel.name }}',
'subject' => 'Your coupon code. Thank you for registering for the newsletter',
'description' => '',
'content_html' => $this->getNewsletterContentHtmlEn(),
'content_plain' => $this->getNewsletterContentPlainEn(),
'created_at' => (new \DateTime())->format(Defaults::STORAGE_DATE_TIME_FORMAT),
]);
}
$this->addTemplateToSalesChannels($connection, $mailTemplateTypeId, $mailTemplateId);
}
/* ---- Register mail ---- */
// Create mail template type
private function createRegisterMailTemplateType($connection, $mailTemplateTypeId)
{
$enLangId = $this->getLanguageIdByLocale($connection, 'en-GB');
$deLangId = $this->getLanguageIdByLocale($connection, 'de-DE');
$connection->insert('mail_template_type', [
'id' => Uuid::fromHexToBytes($mailTemplateTypeId),
'technical_name' => self::REGISTER_PROMOTION_TEMPLATE_TYPE_TECHNICAL_NAME,
'available_entities' => json_encode([
'customer' => 'customer',
'promotion' => 'promotion',
'salesChannel' => 'sales_channel'
]),
'created_at' => (new \DateTime())->format(Defaults::STORAGE_DATE_TIME_FORMAT),
]);
if ($enLangId) {
$connection->insert('mail_template_type_translation', [
'mail_template_type_id' => Uuid::fromHexToBytes($mailTemplateTypeId),
'language_id' => $enLangId,
'name' => self::REGISTER_PROMOTION_TEMPLATE_TYPE_NAME,
'created_at' => (new \DateTime())->format(Defaults::STORAGE_DATE_TIME_FORMAT),
]);
}
if ($deLangId) {
$connection->insert('mail_template_type_translation', [
'mail_template_type_id' => Uuid::fromHexToBytes($mailTemplateTypeId),
'language_id' => $deLangId,
'name' => self::REGISTER_PROMOTION_TEMPLATE_TYPE_NAME,
'created_at' => (new \DateTime())->format(Defaults::STORAGE_DATE_TIME_FORMAT),
]);
}
if (
$deLangId != Uuid::fromHexToBytes(Defaults::LANGUAGE_SYSTEM) &&
$enLangId != Uuid::fromHexToBytes(Defaults::LANGUAGE_SYSTEM)
) {
$connection->insert('mail_template_type_translation', [
'mail_template_type_id' => Uuid::fromHexToBytes($mailTemplateTypeId),
'language_id' => Uuid::fromHexToBytes(Defaults::LANGUAGE_SYSTEM),
'name' => self::REGISTER_PROMOTION_TEMPLATE_TYPE_NAME,
'created_at' => (new \DateTime())->format(Defaults::STORAGE_DATE_TIME_FORMAT),
]);
}
}
// Create mail template
private function createRegisterMailTemplate($connection, $mailTemplateTypeId)
{
$mailTemplateId = Uuid::randomHex();
$enLangId = $this->getLanguageIdByLocale($connection, 'en-GB');
$deLangId = $this->getLanguageIdByLocale($connection, 'de-DE');
$connection->insert('mail_template', [
'id' => Uuid::fromHexToBytes($mailTemplateId),
'mail_template_type_id' => Uuid::fromHexToBytes($mailTemplateTypeId),
'system_default' => true,
'created_at' => (new \DateTime())->format(Defaults::STORAGE_DATE_TIME_FORMAT),
]);
if ($enLangId) {
$connection->insert('mail_template_translation', [
'mail_template_id' => Uuid::fromHexToBytes($mailTemplateId),
'language_id' => $enLangId,
'sender_name' => '{{ salesChannel.name }}',
'subject' => 'Your coupon code. Thank you for registering',
'description' => '',
'content_html' => $this->getRegisterContentHtmlEn(),
'content_plain' => $this->getRegisterContentPlainEn(),
'created_at' => (new \DateTime())->format(Defaults::STORAGE_DATE_TIME_FORMAT),
]);
}
if ($deLangId) {
$connection->insert('mail_template_translation', [
'mail_template_id' => Uuid::fromHexToBytes($mailTemplateId),
'language_id' => $this->getLanguageIdByLocale($connection, 'de-DE'),
'sender_name' => '{{ salesChannel.name }}',
'subject' => 'Dein coupon code. Danke für die Registrierung',
'description' => '',
'content_html' => $this->getRegisterContentHtmlDe(),
'content_plain' => $this->getRegisterContentPlainDe(),
'created_at' => (new \DateTime())->format(Defaults::STORAGE_DATE_TIME_FORMAT),
]);
}
if (
$deLangId != Uuid::fromHexToBytes(Defaults::LANGUAGE_SYSTEM) &&
$enLangId != Uuid::fromHexToBytes(Defaults::LANGUAGE_SYSTEM)
) {
$connection->insert('mail_template_translation', [
'mail_template_id' => Uuid::fromHexToBytes($mailTemplateId),
'language_id' => Uuid::fromHexToBytes(Defaults::LANGUAGE_SYSTEM),
'sender_name' => '{{ salesChannel.name }}',
'subject' => 'Your coupon code. Thank you for registering',
'description' => '',
'content_html' => $this->getRegisterContentHtmlEn(),
'content_plain' => $this->getRegisterContentPlainEn(),
'created_at' => (new \DateTime())->format(Defaults::STORAGE_DATE_TIME_FORMAT),
]);
}
$this->addTemplateToSalesChannels($connection, $mailTemplateTypeId, $mailTemplateId);
}
/* ---- Add templates to sales channels ---- */
private function addTemplateToSalesChannels(Connection $connection, string $mailTemplateTypeId, string $mailTemplateId): void
{
$salesChannels = $connection->fetchAllAssociative('SELECT `id` FROM `sales_channel` ');
foreach ($salesChannels as $salesChannel) {
$mailTemplateSalesChannel = [
'id' => Uuid::randomBytes(),
'mail_template_id' => Uuid::fromHexToBytes($mailTemplateId),
'mail_template_type_id' => Uuid::fromHexToBytes($mailTemplateTypeId),
'sales_channel_id' => $salesChannel['id'],
'created_at' => (new \DateTime())->format(Defaults::STORAGE_DATE_TIME_FORMAT),
];
$connection->insert('mail_template_sales_channel', $mailTemplateSalesChannel);
}
}
/* ---- Check for languages ---- */
private function getLanguageIdByLocale(Connection $connection, string $locale): ?string
{
$sql = <<<SQL
SELECT `language`.`id`
FROM `language`
INNER JOIN `locale` ON `locale`.`id` = `language`.`locale_id`
WHERE `locale`.`code` = :code
SQL;
$languageId = $connection->executeQuery($sql, ['code' => $locale])->fetchOne();
return $languageId;
}
/* ---- Content for newsletter registration promotion mail ----*/
// Content html
private function getNewsletterContentHtmlEn() {
return <<<MAIL
Hello, Your coupon code is {{ promotion.code }}. Thank you for registering for the newsletter.
MAIL;
}
private function getNewsletterContentHtmlDe() {
return <<<MAIL
Hallo, Dein Coupon Code lautet {{ promotion.code }}. Vielen Dank für deine Registrierung zum Newsletter.
MAIL;
}
// Content plain
private function getNewsletterContentPlainEn() {
return <<<MAIL
Hello,\n\n Your coupon code is {{ promotion.code }}.\n\n Thank you for registering for the newsletter.
MAIL;
}
private function getNewsletterContentPlainDe() {
return <<<MAIL
Hallo,\n\n Dein Coupon Code lautet {{ promotion.code }}.\n\n Vielen Dank für deine Registrierung zum Newsletter.
MAIL;
}
/* ---- Content for registration promotion mail ----*/
// Content html
private function getRegisterContentHtmlEn() {
return <<<MAIL
Hello, Your coupon code is {{ promotion.code }}. Thank you for your registration.
MAIL;
}
private function getRegisterContentHtmlDe() {
return <<<MAIL
Hallo, Dein Coupon Code lautet {{ promotion.code }}. Vielen Dank für deine Registrierung.
MAIL;
}
// Content plain
private function getRegisterContentPlainEn() {
return <<<MAIL
Hello,\n\n Your coupon code is {{ promotion.code }}.\n\n Thank you for your registration.
MAIL;
}
private function getRegisterContentPlainDe() {
return <<<MAIL
Hallo,\n\n Dein Coupon Code lautet {{ promotion.code }}.\n\n Vielen Dank für deine Registrierung.
MAIL;
}
public function uninstall(UninstallContext $context): void
{
parent::uninstall($context);
if ($context->keepUserData()) {
return;
}
$connection = $this->container->get(Connection::class);
$connection->executeUpdate('DROP TABLE IF EXISTS `neno_marketing_essentials_newsletter_popup_translation`');
$connection->executeUpdate('DROP TABLE IF EXISTS `neno_marketing_essentials_register_popup_translation`');
$connection->executeUpdate('DROP TABLE IF EXISTS `neno_marketing_essentials_tabs_translation`');
$connection->executeUpdate('DROP TABLE IF EXISTS `neno_marketing_essentials_conversion_bar_translation`');
$connection->executeUpdate('DROP TABLE IF EXISTS `neno_marketing_essentials_newsletter_popup`');
$connection->executeUpdate('DROP TABLE IF EXISTS `neno_marketing_essentials_register_popup`');
$connection->executeUpdate('DROP TABLE IF EXISTS `neno_marketing_essentials_tabs`');
$connection->executeUpdate('DROP TABLE IF EXISTS `neno_marketing_essentials_conversion_bar`');
//get the Templates and Associations added by this Plugin from the DB
/** @var EntityRepositoryInterface $mailTemplateTypeRepository */
$mailTemplateTypeRepository = $this->container->get('mail_template_type.repository');
/** @var EntityRepositoryInterface $mailTemplateRepository */
$mailTemplateRepository = $this->container->get('mail_template.repository');
/** @var MailTemplateTypeEntity $myCustomMailTemplateType */
$myCustomMailTemplateType = $mailTemplateTypeRepository->search(
(new Criteria())
->addFilter(new EqualsFilter('technicalName', self::TEMPLATE_TYPE_TECHNICAL_NAME)),
$context
->getContext()
)->first();
/** @var MailTemplateTypeEntity $registerMailTemplateType */
$registerMailTemplateType = $mailTemplateTypeRepository->search(
(new Criteria())
->addFilter(new EqualsFilter('technicalName', self::REGISTER_PROMOTION_TEMPLATE_TYPE_TECHNICAL_NAME)),
$context
->getContext()
)->first();
$mailTemplateIds = $mailTemplateRepository->searchIds(
(new Criteria())
->addFilter(new MultiFilter(MultiFilter::CONNECTION_OR,[
new EqualsFilter('mailTemplateTypeId', $myCustomMailTemplateType->getId()),
new EqualsFilter('mailTemplateTypeId', $registerMailTemplateType->getId()),
])),
$context
->getContext()
)->getIds();
//Get the Ids from the fetched Entities
$ids = array_map(static function ($id) {
return ['id' => $id];
}, $mailTemplateIds);
//Delete the Templates which were added by this Plugin
$mailTemplateRepository->delete($ids, $context->getContext());
//Delete the TemplateType which were added by this Plugin
$mailTemplateTypeRepository->delete([
['id' => $myCustomMailTemplateType->getId()],
['id' => $registerMailTemplateType->getId()]
], $context->getContext());
}
}

vendor/store.shopware.com/nenomarketingessentials/src/NenoMarketingEssentials.php line 18