CodeExplorer
You are a developer and looking for Shopware projects?
Apply Now!
fetchSystemMailTemplateIdFromType example
private function updateMailTemplate(
string $mailTemplateType,
Connection $connection,
?string $enLangId,
?string $deLangId,
string $getHtmlTemplateEn,
string $getPlainTemplateEn,
string $getHtmlTemplateDe,
string $getPlainTemplateDe
): void {
$templateId = $this->fetchSystemMailTemplateIdFromType($connection, $mailTemplateType);
if ($templateId !== null) {
// updating available entities of mail template $availableEntities = $this->fetchSystemMailTemplateAvailableEntitiesFromType($connection, $mailTemplateType);
if (!isset($availableEntities['editOrderUrl'])) {
$availableEntities['editOrderUrl'] = null;
$sqlStatement = 'UPDATE `mail_template_type` SET `available_entities` = :availableEntities WHERE `technical_name` = :mailTemplateType AND `updated_at` IS NULL';
$connection->executeStatement($sqlStatement, ['availableEntities' => json_encode($availableEntities, \JSON_THROW_ON_ERROR), 'mailTemplateType' => $mailTemplateType]);
}
if ($enLangId !== $deLangId) {
string $mailTemplateType,
Connection $connection,
?string $enLangId,
?string $deLangId,
string $getHtmlTemplateEn,
string $getPlainTemplateEn,
string $getHtmlTemplateDe,
string $getPlainTemplateDe
): void {
$templateId = $this->fetchSystemMailTemplateIdFromType($connection, $mailTemplateType);
if ($templateId !== null) {
// updating available entities of mail template $availableEntities = $this->fetchSystemMailTemplateAvailableEntitiesFromType($connection, $mailTemplateType);
if (!isset($availableEntities['editOrderUrl'])) {
$availableEntities['editOrderUrl'] = null;
$sqlStatement = 'UPDATE `mail_template_type` SET `available_entities` = :availableEntities WHERE `technical_name` = :mailTemplateType AND `updated_at` IS NULL';
$connection->executeStatement($sqlStatement, ['availableEntities' => json_encode($availableEntities, \JSON_THROW_ON_ERROR), 'mailTemplateType' => $mailTemplateType]);
}
if ($enLangId !== $deLangId) {
$migration = new Migration1692254551FixMailTranslation();
$migration->update($connection);
$deLangId = $this->fetchLanguageId($connection, 'de-DE');
$enLandId = $this->fetchLanguageId($connection, 'en-GB');
static::assertNotNull($deLangId);
static::assertNotNull($enLandId);
$templates = [
[
'id' => $this->fetchSystemMailTemplateIdFromType(
$connection,
MailTemplateTypes::MAILTYPE_STATE_ENTER_ORDER_TRANSACTION_STATE_AUTHORIZED
),
'htmlDe' => (string) file_get_contents(__DIR__ . '/../../../../src/Core/Migration/Fixtures/mails/order_transaction.state.authorized/de-html.html.twig'),
'plainDe' => (string) file_get_contents(__DIR__ . '/../../../../src/Core/Migration/Fixtures/mails/order_transaction.state.authorized/de-plain.html.twig'),
'htmlEn' => (string) file_get_contents(__DIR__ . '/../../../../src/Core/Migration/Fixtures/mails/order_transaction.state.authorized/en-html.html.twig'),
'plainEn' => (string) file_get_contents(__DIR__ . '/../../../../src/Core/Migration/Fixtures/mails/order_transaction.state.authorized/en-plain.html.twig'),
],
[
'id' => $this->fetchSystemMailTemplateIdFromType(
$connection,
$migration->update($connection);
$deLangId = $this->fetchLanguageId($connection, 'de-DE');
$enLandId = $this->fetchLanguageId($connection, 'en-GB');
static::assertNotNull($deLangId);
static::assertNotNull($enLandId);
$templates = [
[
'id' => $this->fetchSystemMailTemplateIdFromType(
$connection,
MailTemplateTypes::MAILTYPE_STATE_ENTER_ORDER_TRANSACTION_STATE_AUTHORIZED
),
'htmlDe' => (string) file_get_contents(__DIR__ . '/../../../../src/Core/Migration/Fixtures/mails/order_transaction.state.authorized/de-html.html.twig'),
'plainDe' => (string) file_get_contents(__DIR__ . '/../../../../src/Core/Migration/Fixtures/mails/order_transaction.state.authorized/de-plain.html.twig'),
'htmlEn' => (string) file_get_contents(__DIR__ . '/../../../../src/Core/Migration/Fixtures/mails/order_transaction.state.authorized/en-html.html.twig'),
'plainEn' => (string) file_get_contents(__DIR__ . '/../../../../src/Core/Migration/Fixtures/mails/order_transaction.state.authorized/en-plain.html.twig'),
],
[
'id' => $this->fetchSystemMailTemplateIdFromType(
$connection,
return 1580743279;
}
public function update(Connection $connection): void
{
// implement update $enLangId = $this->fetchLanguageId('en-GB', $connection);
$deLangId = $this->fetchLanguageId('de-DE', $connection);
// update order confirmation $templateId = $this->fetchSystemMailTemplateIdFromType($connection, MailTemplateTypes::MAILTYPE_STATE_ENTER_ORDER_DELIVERY_STATE_CANCELLED);
if ($templateId !== null) {
$this->updateMailTemplateTranslation(
$connection,
$templateId,
$enLangId,
$this->getDeliveryCancellationHtmlTemplateEn(),
$this->getDeliveryCancellationPlainTemplateEn()
);
$this->updateMailTemplateTranslation(
$connection,
private function updateMailTemplate(
string $mailTemplateType,
Connection $connection,
?string $enLangId,
?string $deLangId,
string $getHtmlTemplateEn,
string $getPlainTemplateEn,
string $getHtmlTemplateDe,
string $getPlainTemplateDe
): void {
$templateId = $this->fetchSystemMailTemplateIdFromType($connection, $mailTemplateType);
if ($templateId !== null) {
// updating available entities of mail template $availableEntities = $this->fetchSystemMailTemplateAvailableEntitiesFromType($connection, $mailTemplateType);
if (!isset($availableEntities['editOrderUrl'])) {
$availableEntities['editOrderUrl'] = null;
$sqlStatement = 'UPDATE `mail_template_type` SET `available_entities` = :availableEntities WHERE `technical_name` = :mailTemplateType AND `updated_at` IS NULL';
$connection->executeStatement($sqlStatement, ['availableEntities' => json_encode($availableEntities, \JSON_THROW_ON_ERROR), 'mailTemplateType' => $mailTemplateType]);
}
$this->updateMailTemplateTranslation(
string $mailTemplateType,
Connection $connection,
?string $enLangId,
?string $deLangId,
string $getHtmlTemplateEn,
string $getPlainTemplateEn,
string $getHtmlTemplateDe,
string $getPlainTemplateDe
): void {
$templateId = $this->fetchSystemMailTemplateIdFromType($connection, $mailTemplateType);
if ($templateId !== null) {
// updating available entities of mail template $availableEntities = $this->fetchSystemMailTemplateAvailableEntitiesFromType($connection, $mailTemplateType);
if (!isset($availableEntities['editOrderUrl'])) {
$availableEntities['editOrderUrl'] = null;
$sqlStatement = 'UPDATE `mail_template_type` SET `available_entities` = :availableEntities WHERE `technical_name` = :mailTemplateType AND `updated_at` IS NULL';
$connection->executeStatement($sqlStatement, ['availableEntities' => json_encode($availableEntities, \JSON_THROW_ON_ERROR), 'mailTemplateType' => $mailTemplateType]);
}
$this->updateMailTemplateTranslation(
return 1570621541;
}
public function update(Connection $connection): void
{
// implement update $defaultLangId = $this->fetchLanguageId('en-GB', $connection);
$deLangId = $this->fetchLanguageId('de-DE', $connection);
// update order confirmation $templateId = $this->fetchSystemMailTemplateIdFromType($connection, MailTemplateTypes::MAILTYPE_ORDER_CONFIRM);
if ($templateId !== null) {
if ($defaultLangId !== $deLangId) {
$this->updateMailTemplateTranslation(
$connection,
$templateId,
$defaultLangId,
$this->getOrderConfirmationHtmlTemplateEn(),
$this->getOrderConfirmationPlainTemplateEn()
);
}
private function updateMailTemplate(
string $mailTemplateType,
Connection $connection,
?string $enLangId,
?string $deLangId,
string $getHtmlTemplateEn,
string $getPlainTemplateEn,
string $getHtmlTemplateDe,
string $getPlainTemplateDe
): void {
$templateId = $this->fetchSystemMailTemplateIdFromType($connection, $mailTemplateType);
if ($templateId !== null) {
if ($enLangId !== $deLangId) {
$this->updateMailTemplateTranslation(
$connection,
$templateId,
$enLangId,
$getHtmlTemplateEn,
$getPlainTemplateEn
);
}
string $mailTemplateType,
Connection $connection,
?string $enLangId,
?string $deLangId,
string $getHtmlTemplateEn,
string $getPlainTemplateEn,
string $getHtmlTemplateDe,
string $getPlainTemplateDe
): void {
$templateId = $this->fetchSystemMailTemplateIdFromType($connection, $mailTemplateType);
if ($templateId !== null) {
if ($enLangId !== $deLangId) {
$this->updateMailTemplateTranslation(
$connection,
$templateId,
$enLangId,
$getHtmlTemplateEn,
$getPlainTemplateEn
);
}
private function updateMailTemplate(
string $mailTemplateType,
Connection $connection,
?string $enLangId,
?string $deLangId,
string $getHtmlTemplateEn,
string $getPlainTemplateEn,
string $getHtmlTemplateDe,
string $getPlainTemplateDe
): void {
$templateId = $this->fetchSystemMailTemplateIdFromType($connection, $mailTemplateType);
if ($templateId !== null) {
// updating available entities of mail template $availableEntities = $this->fetchSystemMailTemplateAvailableEntitiesFromType($connection, $mailTemplateType);
if (!isset($availableEntities['editOrderUrl'])) {
$availableEntities['editOrderUrl'] = null;
$sqlStatement = 'UPDATE `mail_template_type` SET `available_entities` = :availableEntities WHERE `technical_name` = :mailTemplateType AND `updated_at` IS NULL';
$connection->executeStatement($sqlStatement, ['availableEntities' => json_encode($availableEntities, \JSON_THROW_ON_ERROR), 'mailTemplateType' => $mailTemplateType]);
}
$this->updateMailTemplateTranslation(
string $mailTemplateType,
Connection $connection,
?string $enLangId,
?string $deLangId,
string $getHtmlTemplateEn,
string $getPlainTemplateEn,
string $getHtmlTemplateDe,
string $getPlainTemplateDe
): void {
$templateId = $this->fetchSystemMailTemplateIdFromType($connection, $mailTemplateType);
if ($templateId !== null) {
// updating available entities of mail template $availableEntities = $this->fetchSystemMailTemplateAvailableEntitiesFromType($connection, $mailTemplateType);
if (!isset($availableEntities['editOrderUrl'])) {
$availableEntities['editOrderUrl'] = null;
$sqlStatement = 'UPDATE `mail_template_type` SET `available_entities` = :availableEntities WHERE `technical_name` = :mailTemplateType AND `updated_at` IS NULL';
$connection->executeStatement($sqlStatement, ['availableEntities' => json_encode($availableEntities, \JSON_THROW_ON_ERROR), 'mailTemplateType' => $mailTemplateType]);
}
$this->updateMailTemplateTranslation(
return $langId;
}
private function updateMailTemplate(
string $mailTemplateType,
Connection $connection,
string $deLangId,
string $getHtmlTemplateDe,
string $getPlainTemplateDe
): void {
$templateId = $this->fetchSystemMailTemplateIdFromType($connection, $mailTemplateType);
if ($templateId !== null) {
$availableEntities = $this->fetchSystemMailTemplateAvailableEntitiesFromType($connection, $mailTemplateType);
if (!isset($availableEntities['editOrderUrl'])) {
$availableEntities['editOrderUrl'] = null;
$sqlStatement = 'UPDATE `mail_template_type` SET `available_entities` = :availableEntities WHERE `technical_name` = :mailTemplateType AND `updated_at` IS NULL';
$connection->executeStatement($sqlStatement, ['availableEntities' => json_encode($availableEntities, \JSON_THROW_ON_ERROR), 'mailTemplateType' => $mailTemplateType]);
}
$this->updateMailTemplateTranslation(
$connection,
}
private function updateMailTemplate(
string $mailTemplateType,
Connection $connection,
string $deLangId,
string $getHtmlTemplateDe,
string $getPlainTemplateDe
): void {
$templateId = $this->fetchSystemMailTemplateIdFromType($connection, $mailTemplateType);
if ($templateId !== null) {
$availableEntities = $this->fetchSystemMailTemplateAvailableEntitiesFromType($connection, $mailTemplateType);
if (!isset($availableEntities['editOrderUrl'])) {
$availableEntities['editOrderUrl'] = null;
$sqlStatement = 'UPDATE `mail_template_type` SET `available_entities` = :availableEntities WHERE `technical_name` = :mailTemplateType AND `updated_at` IS NULL';
$connection->executeStatement($sqlStatement, ['availableEntities' => json_encode($availableEntities, \JSON_THROW_ON_ERROR), 'mailTemplateType' => $mailTemplateType]);
}
$this->updateMailTemplateTranslation(
$connection,
private function updateMailTemplate(
string $mailTemplateType,
Connection $connection,
?string $enLangId,
?string $deLangId,
string $getHtmlTemplateEn,
string $getPlainTemplateEn,
string $getHtmlTemplateDe,
string $getPlainTemplateDe
): void {
$templateId = $this->fetchSystemMailTemplateIdFromType($connection, $mailTemplateType);
if ($templateId === null) {
return;
}
if ($enLangId !== null) {
$this->updateMailTemplateTranslation(
$connection,
$templateId,
$enLangId,
$getHtmlTemplateEn,
$getPlainTemplateEn
);
string $mailTemplateType,
Connection $connection,
?string $enLangId,
?string $deLangId,
string $getHtmlTemplateEn,
string $getPlainTemplateEn,
string $getHtmlTemplateDe,
string $getPlainTemplateDe
): void {
$templateId = $this->fetchSystemMailTemplateIdFromType($connection, $mailTemplateType);
if ($templateId === null) {
return;
}
if ($enLangId !== null) {
$this->updateMailTemplateTranslation(
$connection,
$templateId,
$enLangId,
$getHtmlTemplateEn,
$getPlainTemplateEn
);
return 1583142266;
}
public function update(Connection $connection): void
{
// implement update $enLangId = $this->fetchLanguageId('en-GB', $connection);
$deLangId = $this->fetchLanguageId('de-DE', $connection);
// update order confirmation $templateId = $this->fetchSystemMailTemplateIdFromType($connection, MailTemplateTypes::MAILTYPE_ORDER_CONFIRM);
if ($templateId !== null) {
$this->updateMailTemplateTranslation(
$connection,
$templateId,
$enLangId,
$this->getOrderConfirmationHtmlTemplateEn(),
$this->getOrderConfirmationPlainTemplateEn()
);
$this->updateMailTemplateTranslation(
return 1575293069;
}
public function update(Connection $connection): void
{
// implement update $enLangId = $this->fetchLanguageId('en-GB', $connection);
$deLangId = $this->fetchLanguageId('de-DE', $connection);
// update order confirmation $templateId = $this->fetchSystemMailTemplateIdFromType($connection, MailTemplateTypes::MAILTYPE_ORDER_CONFIRM);
if ($templateId !== null) {
$this->updateMailTemplateTranslation(
$connection,
$templateId,
$enLangId,
$this->getOrderConfirmationHtmlTemplateEn(),
$this->getOrderConfirmationPlainTemplateEn()
);
$this->updateMailTemplateTranslation(
$connection,