CodeExplorer
You are a developer and looking for Shopware projects?
Apply Now!
updateTranslation example
$sql = <<<SQL
UPDATE `s_core_config_mails` SET `contentHTML` = "$content" WHERE `name` = "$name" AND dirty = 0
SQL;
$this->addSql($sql);
}
/** * Update translations of mail templates */
private function updateTranslations()
{
$this->updateTranslation(
'sORDER',
"{include file=\"string:{config name=emailheaderhtml}\"}\r\n<br/><br/>\r\n<p>Hello {\$billingaddress.firstname} {\$billingaddress.lastname},<br/><br/>\n\nThank you for your order with {config name=shopName} (Nummer: {\$sOrderNumber}) on {\$sOrderDay} at {\$sOrderTime}.\n<br/>\n<br/>\n<strong>Information on your order:</strong></p>\n <table width=\"80%\" border=\"0\" style=\"font-family:Arial, Helvetica, sans-serif; font-size:10px;\">\n <tr>\n <td bgcolor=\"#F7F7F2\" style=\"border-bottom:1px solid #cccccc;\"><strong>Art.No.</strong></td>\n <td bgcolor=\"#F7F7F2\" style=\"border-bottom:1px solid #cccccc;\"><strong>Pos.</strong></td>\n <td bgcolor=\"#F7F7F2\" style=\"border-bottom:1px solid #cccccc;\"><strong>Art-Nr.</strong></td>\n <td bgcolor=\"#F7F7F2\" style=\"border-bottom:1px solid #cccccc;\"><strong>Quantities</strong></td>\n <td bgcolor=\"#F7F7F2\" style=\"border-bottom:1px solid #cccccc;\"><strong>Price</strong></td>\n <td bgcolor=\"#F7F7F2\" style=\"border-bottom:1px solid #cccccc;\"><strong>Total</strong></td>\n </tr>\n\n {foreach item=details key=position from=\$sOrderDetails}\n <tr>\n <td rowspan=\"2\" style=\"border-bottom:1px solid #cccccc;\">{if \$details.image.src.0}<img style=\"height: 57px;\" src=\"{\$details.image.src.0}\" alt=\"{\$details.articlename}\" />{else} {/if}</td>\n <td>{\$position+1|fill:4} </td>\n <td>{\$details.ordernumber|fill:20}</td>\n <td>{\$details.quantity|fill:6}</td>\n <td>{\$details.price|padding:8}{\$sCurrency}</td>\n <td>{\$details.amount|padding:8} {\$sCurrency}</td>\n </tr>\n <tr>\n <td colspan=\"5\" style=\"border-bottom:1px solid #cccccc;\">{\$details.articlename|wordwrap:80|indent:4}</td>\n </tr>\n {/foreach}\n\n </table>\n\n<p>\n <br/>\n <br/>\n Shipping costs:: {\$sShippingCosts}<br/>\n Total net: {\$sAmountNet}<br/>\n {if !\$sNet}\n Total gross: {\$sAmount}<br/>\n {/if}\n <br/>\n <br/>\n <strong>Selected payment type:</strong> {\$additional.payment.description}<br/>\n {\$additional.payment.additionaldescription}\n {if \$additional.payment.name == \"debit\"}\n Your bank connection:<br/>\n Account number: {\$sPaymentTable.account}<br/>\n BIN:{\$sPaymentTable.bankcode}<br/>\n We will withdraw the money from your bank account within the next days.<br/>\n {/if}\n <br/>\n <br/>\n {if \$additional.payment.name == \"prepayment\"}\n Our bank connection:<br/>\n {config name=bankAccount}\n {/if}\n <br/>\n <br/>\n <strong>Selected dispatch:</strong> {\$sDispatch.name}<br/>{\$sDispatch.description}\n</p>\n<p>\n {if \$sComment}\n <strong>Your comment:</strong><br/>\n {\$sComment}<br/>\n {/if}\n <br/>\n <br/>\n <strong>Billing address:</strong><br/>\n {\$billingaddress.company}<br/>\n {\$billingaddress.firstname} {\$billingaddress.lastname}<br/>\n {\$billingaddress.street}<br/>\n {\$billingaddress.zipcode} {\$billingaddress.city}<br/>\n {\$billingaddress.phone}<br/>\n {\$additional.country.countryname}<br/>\n <br/>\n <br/>\n <strong>Shipping address:</strong><br/>\n {\$shippingaddress.company}<br/>\n {\$shippingaddress.firstname} {\$shippingaddress.lastname}<br/>\n {\$shippingaddress.street}<br/>\n {\$shippingaddress.zipcode} {\$shippingaddress.city}<br/>\n {\$additional.countryShipping.countryname}<br/>\n <br/>\n {if \$billingaddress.ustid}\n Your VAT-ID: {\$billingaddress.ustid}<br/>\n In case of a successful order and if you are based in one of the EU countries, you will receive your goods exempt from turnover tax.\n {/if}</p>\r\n<br/><br/>\r\n{include file=\"string:{config name=emailfooterhtml}\"}"
);
}
/** * Helper method to update the translations of a mail template * * @param string $name * @param string $content */
$this->addSql($sql);
}
/** * Update translations of mail templates */
private function updateTranslations()
{
$this->updateTranslation(
'sORDER',
"{include file=\"string:{config name=emailheaderhtml}\"}\r\n<br/><br/>\r\n<p>Hello {\$billingaddress.firstname} {\$billingaddress.lastname},<br/><br/>\n\nThank you for your order with {config name=shopName} (Nummer: {\$sOrderNumber}) on {\$sOrderDay} at {\$sOrderTime}.\n<br/>\n<br/>\n<strong>Information on your order:</strong></p>\n <table width=\"80%\" border=\"0\" style=\"font-family:Arial, Helvetica, sans-serif; font-size:10px;\">\n <tr>\n <td bgcolor=\"#F7F7F2\" style=\"border-bottom:1px solid #cccccc;\"><strong>Art.No.</strong></td>\n <td bgcolor=\"#F7F7F2\" style=\"border-bottom:1px solid #cccccc;\"><strong>Pos.</strong></td>\n <td bgcolor=\"#F7F7F2\" style=\"border-bottom:1px solid #cccccc;\"><strong>Art-Nr.</strong></td>\n <td bgcolor=\"#F7F7F2\" style=\"border-bottom:1px solid #cccccc;\"><strong>Quantities</strong></td>\n <td bgcolor=\"#F7F7F2\" style=\"border-bottom:1px solid #cccccc;\"><strong>Price</strong></td>\n <td bgcolor=\"#F7F7F2\" style=\"border-bottom:1px solid #cccccc;\"><strong>Total</strong></td>\n </tr>\n\n {foreach item=details key=position from=\$sOrderDetails}\n <tr>\n <td rowspan=\"2\" style=\"border-bottom:1px solid #cccccc;\">{if \$details.image.src.0}<img style=\"height: 57px;\" src=\"{\$details.image.src.0}\" alt=\"{\$details.articlename}\" />{else} {/if}</td>\n <td>{\$position+1|fill:4} </td>\n <td>{\$details.ordernumber|fill:20}</td>\n <td>{\$details.quantity|fill:6}</td>\n <td>{\$details.price|padding:8}{\$sCurrency}</td>\n <td>{\$details.amount|padding:8} {\$sCurrency}</td>\n </tr>\n <tr>\n <td colspan=\"5\" style=\"border-bottom:1px solid #cccccc;\">{\$details.articlename|wordwrap:80|indent:4}</td>\n </tr>\n {/foreach}\n\n </table>\n\n<p>\n <br/>\n <br/>\n Shipping costs:: {\$sShippingCosts}<br/>\n Total net: {\$sAmountNet}<br/>\n {if !\$sNet}\n Total gross: {\$sAmount}<br/>\n {/if}\n <br/>\n <br/>\n <strong>Selected payment type:</strong> {\$additional.payment.description}<br/>\n {\$additional.payment.additionaldescription}\n {if \$additional.payment.name == \"debit\"}\n Your bank connection:<br/>\n Account number: {\$sPaymentTable.account}<br/>\n BIN:{\$sPaymentTable.bankcode}<br/>\n We will withdraw the money from your bank account within the next days.<br/>\n {/if}\n <br/>\n <br/>\n {if \$additional.payment.name == \"prepayment\"}\n Our bank connection:<br/>\n {config name=bankAccount}\n {/if}\n <br/>\n <br/>\n <strong>Selected dispatch:</strong> {\$sDispatch.name}<br/>{\$sDispatch.description}\n</p>\n<p>\n {if \$sComment}\n <strong>Your comment:</strong><br/>\n {\$sComment}<br/>\n {/if}\n <br/>\n <br/>\n <strong>Billing address:</strong><br/>\n {\$billingaddress.company}<br/>\n {\$billingaddress.firstname} {\$billingaddress.lastname}<br/>\n {\$billingaddress.street}<br/>\n {\$billingaddress.zipcode} {\$billingaddress.city}<br/>\n {\$billingaddress.phone}<br/>\n {\$additional.country.countryname}<br/>\n <br/>\n <br/>\n <strong>Shipping address:</strong><br/>\n {\$shippingaddress.company}<br/>\n {\$shippingaddress.firstname} {\$shippingaddress.lastname}<br/>\n {\$shippingaddress.street}<br/>\n {\$shippingaddress.zipcode} {\$shippingaddress.city}<br/>\n {\$additional.countryShipping.countryname}<br/>\n <br/>\n {if \$billingaddress.ustid}\n Your VAT-ID: {\$billingaddress.ustid}<br/>\n In case of a successful order and if you are based in one of the EU countries, you will receive your goods exempt from turnover tax.\n {/if}</p>\r\n<br/><br/>\r\n{include file=\"string:{config name=emailfooterhtml}\"}"
);
}
/** * Helper method to update the translations of a mail template * * @param string $name * @param string $content */
'sORDERSEPAAUTHORIZATION',
'Hallo {$paymentInstance.firstName} {$paymentInstance.lastName}, im Anhang finden Sie ein Lastschriftmandat zu Ihrer Bestellung {$paymentInstance.orderNumber}. Bitte senden Sie uns das komplett ausgefüllte Dokument per Fax oder Email zurück.',
'Hallo {$paymentInstance.firstName} {$paymentInstance.lastName}, im Anhang finden Sie ein Lastschriftmandat zu Ihrer Bestellung {$paymentInstance.orderNumber}. Bitte senden Sie uns das komplett ausgefüllte Dokument per Fax oder Email zurück.'
);
}
/** * Update translations of mail templates */
private function updateTranslations()
{
$this->updateTranslation(
'sREGISTERCONFIRMATION',
"Hello {salutation} {firstname} {lastname},\n\nthank you for your registration with our Shop.\n\nYou will gain access via the email address {sMAIL}\nand the password you have chosen.\n\nYou can have your password sent to you by email anytime.",
"Hello {salutation} {firstname} {lastname},<br/><br/>\n\nThank you for your registration with our Shop.<br/><br/>\n\nYou will gain access via the email address {sMAIL} and the password you have chosen.<br/><br/>\n\nYou can have your password sent to you by email anytime."
);
$this->updateTranslation(
'sORDER',
"Hello {\$billingaddress.firstname} {\$billingaddress.lastname},\n\nThank you for your order at {config name=shopName} (Number: {\$sOrderNumber}) on {\$sOrderDay} at {\$sOrderTime}.\nInformation on your order:\n\nPos. Art.No. Quantities Price Total\n{foreach item=details key=position from=\$sOrderDetails}\n{\$position+1|fill:4} {\$details.ordernumber|fill:20} {\$details.quantity|fill:6} {\$details.price|padding:8} EUR {\$details.amount|padding:8} EUR\n{\$details.articlename|wordwrap:49|indent:5}\n{/foreach}\n\nShipping costs: {\$sShippingCosts}\nTotal net: {\$sAmountNet}\n{if !\$sNet}\nTotal gross: {\$sAmount}\n{/if}\n\nSelected payment type: {\$additional.payment.description}\n{\$additional.payment.additionaldescription}\n{if \$additional.payment.name == \"debit\"}\nYour bank connection:\nAccount number: {\$sPaymentTable.account}\nBIN:{\$sPaymentTable.bankcode}\nWe will withdraw the money from your bank account within the next days.\n{/if}\n{if \$additional.payment.name == \"prepayment\"}\n\nOur bank connection:\nAccount: ###\nBIN: ###\n{/if}\n\n{if \$sComment}\nYour comment:\n{\$sComment}\n{/if}\n\nBilling address:\n{\$billingaddress.company}\n{\$billingaddress.firstname} {\$billingaddress.lastname}\n{\$billingaddress.street}\n{\$billingaddress.zipcode} {\$billingaddress.city}\n{\$billingaddress.phone}\n{\$additional.country.countryname}\n\nShipping address:\n{\$shippingaddress.company}\n{\$shippingaddress.firstname} {\$shippingaddress.lastname}\n{\$shippingaddress.street}\n{\$shippingaddress.zipcode} {\$shippingaddress.city}\n{\$additional.country.countryname}{if \$billingaddress.ustid}\n\n\nYour VAT-ID: {\$billingaddress.ustid}\nIn case of a successful order and if you are based in one of the EU countries, you will receive your goods exempt from turnover tax.{/if}",
"<p>Hello {\$billingaddress.firstname} {\$billingaddress.lastname},<br/><br/>\n\nThank you for your order with {config name=shopName} (Nummer: {\$sOrderNumber}) on {\$sOrderDay} at {\$sOrderTime}.\n<br/>\n<br/>\n<strong>Information on your order:</strong></p>\n <table width=\"80%\" border=\"0\" style=\"font-family:Arial, Helvetica, sans-serif; font-size:10px;\">\n <tr>\n <td bgcolor=\"#F7F7F2\" style=\"border-bottom:1px solid #cccccc;\"><strong>Art.No.</strong></td>\n <td bgcolor=\"#F7F7F2\" style=\"border-bottom:1px solid #cccccc;\"><strong>Pos.</strong></td>\n <td bgcolor=\"#F7F7F2\" style=\"border-bottom:1px solid #cccccc;\"><strong>Art-Nr.</strong></td>\n <td bgcolor=\"#F7F7F2\" style=\"border-bottom:1px solid #cccccc;\"><strong>Quantities</strong></td>\n <td bgcolor=\"#F7F7F2\" style=\"border-bottom:1px solid #cccccc;\"><strong>Price</strong></td>\n <td bgcolor=\"#F7F7F2\" style=\"border-bottom:1px solid #cccccc;\"><strong>Total</strong></td>\n </tr>\n\n {foreach item=details key=position from=\$sOrderDetails}\n <tr>\n <td rowspan=\"2\" style=\"border-bottom:1px solid #cccccc;\">{if \$details.image.src.1}<img src=\"{\$details.image.src.1}\" alt=\"{\$details.articlename}\" />{else} {/if}</td>\n <td>{\$position+1|fill:4} </td>\n <td>{\$details.ordernumber|fill:20}</td>\n <td>{\$details.quantity|fill:6}</td>\n <td>{\$details.price|padding:8}{\$sCurrency}</td>\n <td>{\$details.amount|padding:8} {\$sCurrency}</td>\n </tr>\n <tr>\n <td colspan=\"5\" style=\"border-bottom:1px solid #cccccc;\">{\$details.articlename|wordwrap:80|indent:4}</td>\n </tr>\n {/foreach}\n\n </table>\n\n<p>\n <br/>\n <br/>\n Shipping costs:: {\$sShippingCosts}<br/>\n Total net: {\$sAmountNet}<br/>\n {if !\$sNet}\n Total gross: {\$sAmount}<br/>\n {/if}\n <br/>\n <br/>\n <strong>Selected payment type:</strong> {\$additional.payment.description}<br/>\n {\$additional.payment.additionaldescription}\n {if \$additional.payment.name == \"debit\"}\n Your bank connection:<br/>\n Account number: {\$sPaymentTable.account}<br/>\n BIN:{\$sPaymentTable.bankcode}<br/>\n We will withdraw the money from your bank account within the next days.<br/>\n {/if}\n <br/>\n <br/>\n {if \$additional.payment.name == \"prepayment\"}\n Our bank connection:<br/>\n {config name=bankAccount}\n {/if}\n <br/>\n <br/>\n <strong>Selected dispatch:</strong> {\$sDispatch.name}<br/>{\$sDispatch.description}\n</p>\n<p>\n {if \$sComment}\n <strong>Your comment:</strong><br/>\n {\$sComment}<br/>\n {/if}\n <br/>\n <br/>\n <strong>Billing address:</strong><br/>\n {\$billingaddress.company}<br/>\n {\$billingaddress.firstname} {\$billingaddress.lastname}<br/>\n {\$billingaddress.street}<br/>\n {\$billingaddress.zipcode} {\$billingaddress.city}<br/>\n {\$billingaddress.phone}<br/>\n {\$additional.country.countryname}<br/>\n <br/>\n <br/>\n <strong>Shipping address:</strong><br/>\n {\$shippingaddress.company}<br/>\n {\$shippingaddress.firstname} {\$shippingaddress.lastname}<br/>\n {\$shippingaddress.street}<br/>\n {\$shippingaddress.zipcode} {\$shippingaddress.city}<br/>\n {\$additional.countryShipping.countryname}<br/>\n <br/>\n {if \$billingaddress.ustid}\n Your VAT-ID: {\$billingaddress.ustid}<br/>\n In case of a successful order and if you are based in one of the EU countries, you will receive your goods exempt from turnover tax.\n {/if}</p>"
);
'Hallo {$paymentInstance.firstName} {$paymentInstance.lastName}, im Anhang finden Sie ein Lastschriftmandat zu Ihrer Bestellung {$paymentInstance.orderNumber}. Bitte senden Sie uns das komplett ausgefüllte Dokument per Fax oder Email zurück.',
'Hallo {$paymentInstance.firstName} {$paymentInstance.lastName}, im Anhang finden Sie ein Lastschriftmandat zu Ihrer Bestellung {$paymentInstance.orderNumber}. Bitte senden Sie uns das komplett ausgefüllte Dokument per Fax oder Email zurück.'
);
}
/** * Update translations of mail templates */
private function updateTranslations()
{
$this->updateTranslation(
'sREGISTERCONFIRMATION',
"Hello {salutation} {firstname} {lastname},\n\nthank you for your registration with our Shop.\n\nYou will gain access via the email address {sMAIL}\nand the password you have chosen.\n\nYou can have your password sent to you by email anytime.",
"Hello {salutation} {firstname} {lastname},<br/><br/>\n\nThank you for your registration with our Shop.<br/><br/>\n\nYou will gain access via the email address {sMAIL} and the password you have chosen.<br/><br/>\n\nYou can have your password sent to you by email anytime."
);
$this->updateTranslation(
'sORDER',
"Hello {\$billingaddress.firstname} {\$billingaddress.lastname},\n\nThank you for your order at {config name=shopName} (Number: {\$sOrderNumber}) on {\$sOrderDay} at {\$sOrderTime}.\nInformation on your order:\n\nPos. Art.No. Quantities Price Total\n{foreach item=details key=position from=\$sOrderDetails}\n{\$position+1|fill:4} {\$details.ordernumber|fill:20} {\$details.quantity|fill:6} {\$details.price|padding:8} EUR {\$details.amount|padding:8} EUR\n{\$details.articlename|wordwrap:49|indent:5}\n{/foreach}\n\nShipping costs: {\$sShippingCosts}\nTotal net: {\$sAmountNet}\n{if !\$sNet}\nTotal gross: {\$sAmount}\n{/if}\n\nSelected payment type: {\$additional.payment.description}\n{\$additional.payment.additionaldescription}\n{if \$additional.payment.name == \"debit\"}\nYour bank connection:\nAccount number: {\$sPaymentTable.account}\nBIN:{\$sPaymentTable.bankcode}\nWe will withdraw the money from your bank account within the next days.\n{/if}\n{if \$additional.payment.name == \"prepayment\"}\n\nOur bank connection:\nAccount: ###\nBIN: ###\n{/if}\n\n{if \$sComment}\nYour comment:\n{\$sComment}\n{/if}\n\nBilling address:\n{\$billingaddress.company}\n{\$billingaddress.firstname} {\$billingaddress.lastname}\n{\$billingaddress.street}\n{\$billingaddress.zipcode} {\$billingaddress.city}\n{\$billingaddress.phone}\n{\$additional.country.countryname}\n\nShipping address:\n{\$shippingaddress.company}\n{\$shippingaddress.firstname} {\$shippingaddress.lastname}\n{\$shippingaddress.street}\n{\$shippingaddress.zipcode} {\$shippingaddress.city}\n{\$additional.country.countryname}{if \$billingaddress.ustid}\n\n\nYour VAT-ID: {\$billingaddress.ustid}\nIn case of a successful order and if you are based in one of the EU countries, you will receive your goods exempt from turnover tax.{/if}",
"<p>Hello {\$billingaddress.firstname} {\$billingaddress.lastname},<br/><br/>\n\nThank you for your order with {config name=shopName} (Nummer: {\$sOrderNumber}) on {\$sOrderDay} at {\$sOrderTime}.\n<br/>\n<br/>\n<strong>Information on your order:</strong></p>\n <table width=\"80%\" border=\"0\" style=\"font-family:Arial, Helvetica, sans-serif; font-size:10px;\">\n <tr>\n <td bgcolor=\"#F7F7F2\" style=\"border-bottom:1px solid #cccccc;\"><strong>Art.No.</strong></td>\n <td bgcolor=\"#F7F7F2\" style=\"border-bottom:1px solid #cccccc;\"><strong>Pos.</strong></td>\n <td bgcolor=\"#F7F7F2\" style=\"border-bottom:1px solid #cccccc;\"><strong>Art-Nr.</strong></td>\n <td bgcolor=\"#F7F7F2\" style=\"border-bottom:1px solid #cccccc;\"><strong>Quantities</strong></td>\n <td bgcolor=\"#F7F7F2\" style=\"border-bottom:1px solid #cccccc;\"><strong>Price</strong></td>\n <td bgcolor=\"#F7F7F2\" style=\"border-bottom:1px solid #cccccc;\"><strong>Total</strong></td>\n </tr>\n\n {foreach item=details key=position from=\$sOrderDetails}\n <tr>\n <td rowspan=\"2\" style=\"border-bottom:1px solid #cccccc;\">{if \$details.image.src.1}<img src=\"{\$details.image.src.1}\" alt=\"{\$details.articlename}\" />{else} {/if}</td>\n <td>{\$position+1|fill:4} </td>\n <td>{\$details.ordernumber|fill:20}</td>\n <td>{\$details.quantity|fill:6}</td>\n <td>{\$details.price|padding:8}{\$sCurrency}</td>\n <td>{\$details.amount|padding:8} {\$sCurrency}</td>\n </tr>\n <tr>\n <td colspan=\"5\" style=\"border-bottom:1px solid #cccccc;\">{\$details.articlename|wordwrap:80|indent:4}</td>\n </tr>\n {/foreach}\n\n </table>\n\n<p>\n <br/>\n <br/>\n Shipping costs:: {\$sShippingCosts}<br/>\n Total net: {\$sAmountNet}<br/>\n {if !\$sNet}\n Total gross: {\$sAmount}<br/>\n {/if}\n <br/>\n <br/>\n <strong>Selected payment type:</strong> {\$additional.payment.description}<br/>\n {\$additional.payment.additionaldescription}\n {if \$additional.payment.name == \"debit\"}\n Your bank connection:<br/>\n Account number: {\$sPaymentTable.account}<br/>\n BIN:{\$sPaymentTable.bankcode}<br/>\n We will withdraw the money from your bank account within the next days.<br/>\n {/if}\n <br/>\n <br/>\n {if \$additional.payment.name == \"prepayment\"}\n Our bank connection:<br/>\n {config name=bankAccount}\n {/if}\n <br/>\n <br/>\n <strong>Selected dispatch:</strong> {\$sDispatch.name}<br/>{\$sDispatch.description}\n</p>\n<p>\n {if \$sComment}\n <strong>Your comment:</strong><br/>\n {\$sComment}<br/>\n {/if}\n <br/>\n <br/>\n <strong>Billing address:</strong><br/>\n {\$billingaddress.company}<br/>\n {\$billingaddress.firstname} {\$billingaddress.lastname}<br/>\n {\$billingaddress.street}<br/>\n {\$billingaddress.zipcode} {\$billingaddress.city}<br/>\n {\$billingaddress.phone}<br/>\n {\$additional.country.countryname}<br/>\n <br/>\n <br/>\n <strong>Shipping address:</strong><br/>\n {\$shippingaddress.company}<br/>\n {\$shippingaddress.firstname} {\$shippingaddress.lastname}<br/>\n {\$shippingaddress.street}<br/>\n {\$shippingaddress.zipcode} {\$shippingaddress.city}<br/>\n {\$additional.countryShipping.countryname}<br/>\n <br/>\n {if \$billingaddress.ustid}\n Your VAT-ID: {\$billingaddress.ustid}<br/>\n In case of a successful order and if you are based in one of the EU countries, you will receive your goods exempt from turnover tax.\n {/if}</p>"
);
$sql = <<<SQL
UPDATE `s_core_config_mails` SET `contentHTML` = "$contentHtml", `content` = "$content" WHERE `name` = "$name" AND dirty = 0
SQL;
$this->addSql($sql);
}
/** * Update translations of mail templates */
private function updateTranslations()
{
$this->updateTranslation(
'sORDER',
"{include file=\"string:{config name=emailheaderplain}\"}\n\nHello {\$billingaddress.firstname} {\$billingaddress.lastname},\n\nThank you for your order at {config name=shopName} (Number: {\$sOrderNumber}) on {\$sOrderDay} at {\$sOrderTime}.\nInformation on your order:\n\nPos. Art.No. Quantities Price Total\n{foreach item=details key=position from=\$sOrderDetails}\n{\$position+1|fill:4} {\$details.ordernumber|fill:20} {\$details.quantity|fill:6} {\$details.price|padding:8} EUR {\$details.amount|padding:8} EUR\n{\$details.articlename|wordwrap:49|indent:5}\n{/foreach}\n\nShipping costs: {\$sShippingCosts}\nTotal net: {\$sAmountNet}\n{if !\$sNet}\nTotal gross: {\$sAmount}\n{/if}\n\nSelected payment type: {\$additional.payment.description}\n{\$additional.payment.additionaldescription}\n{if \$additional.payment.name == \"debit\"}\nYour bank connection:\nAccount number: {\$sPaymentTable.account}\nBIN:{\$sPaymentTable.bankcode}\nWe will withdraw the money from your bank account within the next days.\n{/if}\n{if \$additional.payment.name == \"prepayment\"}\n\nOur bank connection:\nAccount: ###\nBIN: ###\n{/if}\n\n{if \$sComment}\nYour comment:\n{\$sComment}\n{/if}\n\nBilling address:\n{\$billingaddress.company}\n{\$billingaddress.firstname} {\$billingaddress.lastname}\n{\$billingaddress.street}\n{if {config name=showZipBeforeCity}}{\$billingaddress.zipcode} {\$billingaddress.city}{else}{\$billingaddress.city} {\$billingaddress.zipcode}{/if}\n{\$billingaddress.phone}\n{\$additional.country.countryname}\n\nShipping address:\n{\$shippingaddress.company}\n{\$shippingaddress.firstname} {\$shippingaddress.lastname}\n{\$shippingaddress.street}\n{if {config name=showZipBeforeCity}}{\$shippingaddress.zipcode} {\$shippingaddress.city}{else}{\$shippingaddress.city} {\$shippingaddress.zipcode}{/if}\n{\$additional.countryShipping.countryname}{if \$billingaddress.ustid}\n\n\nYour VAT-ID: {\$billingaddress.ustid}\nIn case of a successful order and if you are based in one of the EU countries, you will receive your goods exempt from turnover tax.{/if}\n\n{include file=\"string:{config name=emailfooterplain}\"}",
"{include file=\"string:{config name=emailheaderhtml}\"}\r\n<br/><br/>\r\n<p>Hello {\$billingaddress.firstname} {\$billingaddress.lastname},<br/><br/>\n\nThank you for your order with {config name=shopName} (Nummer: {\$sOrderNumber}) on {\$sOrderDay} at {\$sOrderTime}.\n<br/>\n<br/>\n<strong>Information on your order:</strong></p>\n <table width=\"80%\" border=\"0\" style=\"font-family:Arial, Helvetica, sans-serif; font-size:10px;\">\n <tr>\n <td bgcolor=\"#F7F7F2\" style=\"border-bottom:1px solid #cccccc;\"><strong>Art.No.</strong></td>\n <td bgcolor=\"#F7F7F2\" style=\"border-bottom:1px solid #cccccc;\"><strong>Pos.</strong></td>\n <td bgcolor=\"#F7F7F2\" style=\"border-bottom:1px solid #cccccc;\"><strong>Art-Nr.</strong></td>\n <td bgcolor=\"#F7F7F2\" style=\"border-bottom:1px solid #cccccc;\"><strong>Quantities</strong></td>\n <td bgcolor=\"#F7F7F2\" style=\"border-bottom:1px solid #cccccc;\"><strong>Price</strong></td>\n <td bgcolor=\"#F7F7F2\" style=\"border-bottom:1px solid #cccccc;\"><strong>Total</strong></td>\n </tr>\n\n {foreach item=details key=position from=\$sOrderDetails}\n <tr>\n <td rowspan=\"2\" style=\"border-bottom:1px solid #cccccc;\">{if \$details.image.src.0}<img style=\"height: 57px;\" src=\"{\$details.image.src.0}\" alt=\"{\$details.articlename}\" />{else} {/if}</td>\n <td>{\$position+1|fill:4} </td>\n <td>{\$details.ordernumber|fill:20}</td>\n <td>{\$details.quantity|fill:6}</td>\n <td>{\$details.price|padding:8}{\$sCurrency}</td>\n <td>{\$details.amount|padding:8} {\$sCurrency}</td>\n </tr>\n <tr>\n <td colspan=\"5\" style=\"border-bottom:1px solid #cccccc;\">{\$details.articlename|wordwrap:80|indent:4}</td>\n </tr>\n {/foreach}\n\n </table>\n\n<p>\n <br/>\n <br/>\n Shipping costs:: {\$sShippingCosts}<br/>\n Total net: {\$sAmountNet}<br/>\n {if !\$sNet}\n Total gross: {\$sAmount}<br/>\n {/if}\n <br/>\n <br/>\n <strong>Selected payment type:</strong> {\$additional.payment.description}<br/>\n {\$additional.payment.additionaldescription}\n {if \$additional.payment.name == \"debit\"}\n Your bank connection:<br/>\n Account number: {\$sPaymentTable.account}<br/>\n BIN:{\$sPaymentTable.bankcode}<br/>\n We will withdraw the money from your bank account within the next days.<br/>\n {/if}\n <br/>\n <br/>\n {if \$additional.payment.name == \"prepayment\"}\n Our bank connection:<br/>\n {config name=bankAccount}\n {/if}\n <br/>\n <br/>\n <strong>Selected dispatch:</strong> {\$sDispatch.name}<br/>{\$sDispatch.description}\n</p>\n<p>\n {if \$sComment}\n <strong>Your comment:</strong><br/>\n {\$sComment}<br/>\n {/if}\n <br/>\n <br/>\n <strong>Billing address:</strong><br/>\n {\$billingaddress.company}<br/>\n {\$billingaddress.firstname} {\$billingaddress.lastname}<br/>\n {\$billingaddress.street}<br/>\n {if {config name=showZipBeforeCity}}{\$billingaddress.zipcode} {\$billingaddress.city}{else}{\$billingaddress.city} {\$billingaddress.zipcode}{/if}<br/>\n {\$billingaddress.phone}<br/>\n {\$additional.country.countryname}<br/>\n <br/>\n <br/>\n <strong>Shipping address:</strong><br/>\n {\$shippingaddress.company}<br/>\n {\$shippingaddress.firstname} {\$shippingaddress.lastname}<br/>\n {\$shippingaddress.street}<br/>\n {if {config name=showZipBeforeCity}}{\$shippingaddress.zipcode} {\$shippingaddress.city}{else}{\$shippingaddress.city} {\$shippingaddress.zipcode}{/if}<br/>\n {\$additional.countryShipping.countryname}<br/>\n <br/>\n {if \$billingaddress.ustid}\n Your VAT-ID: {\$billingaddress.ustid}<br/>\n In case of a successful order and if you are based in one of the EU countries, you will receive your goods exempt from turnover tax.\n {/if}</p>\r\n<br/><br/>\r\n{include file=\"string:{config name=emailfooterhtml}\"}"
);
}
/** * Helper method to update the translations of a mail template * * @param string $name * @param string $content */
$this->addSql($sql);
}
/** * Update translations of mail templates */
private function updateTranslations()
{
$this->updateTranslation(
'sORDER',
"{include file=\"string:{config name=emailheaderplain}\"}\n\nHello {\$billingaddress.firstname} {\$billingaddress.lastname},\n\nThank you for your order at {config name=shopName} (Number: {\$sOrderNumber}) on {\$sOrderDay} at {\$sOrderTime}.\nInformation on your order:\n\nPos. Art.No. Quantities Price Total\n{foreach item=details key=position from=\$sOrderDetails}\n{\$position+1|fill:4} {\$details.ordernumber|fill:20} {\$details.quantity|fill:6} {\$details.price|padding:8} EUR {\$details.amount|padding:8} EUR\n{\$details.articlename|wordwrap:49|indent:5}\n{/foreach}\n\nShipping costs: {\$sShippingCosts}\nTotal net: {\$sAmountNet}\n{if !\$sNet}\nTotal gross: {\$sAmount}\n{/if}\n\nSelected payment type: {\$additional.payment.description}\n{\$additional.payment.additionaldescription}\n{if \$additional.payment.name == \"debit\"}\nYour bank connection:\nAccount number: {\$sPaymentTable.account}\nBIN:{\$sPaymentTable.bankcode}\nWe will withdraw the money from your bank account within the next days.\n{/if}\n{if \$additional.payment.name == \"prepayment\"}\n\nOur bank connection:\nAccount: ###\nBIN: ###\n{/if}\n\n{if \$sComment}\nYour comment:\n{\$sComment}\n{/if}\n\nBilling address:\n{\$billingaddress.company}\n{\$billingaddress.firstname} {\$billingaddress.lastname}\n{\$billingaddress.street}\n{if {config name=showZipBeforeCity}}{\$billingaddress.zipcode} {\$billingaddress.city}{else}{\$billingaddress.city} {\$billingaddress.zipcode}{/if}\n{\$billingaddress.phone}\n{\$additional.country.countryname}\n\nShipping address:\n{\$shippingaddress.company}\n{\$shippingaddress.firstname} {\$shippingaddress.lastname}\n{\$shippingaddress.street}\n{if {config name=showZipBeforeCity}}{\$shippingaddress.zipcode} {\$shippingaddress.city}{else}{\$shippingaddress.city} {\$shippingaddress.zipcode}{/if}\n{\$additional.countryShipping.countryname}{if \$billingaddress.ustid}\n\n\nYour VAT-ID: {\$billingaddress.ustid}\nIn case of a successful order and if you are based in one of the EU countries, you will receive your goods exempt from turnover tax.{/if}\n\n{include file=\"string:{config name=emailfooterplain}\"}",
"{include file=\"string:{config name=emailheaderhtml}\"}\r\n<br/><br/>\r\n<p>Hello {\$billingaddress.firstname} {\$billingaddress.lastname},<br/><br/>\n\nThank you for your order with {config name=shopName} (Nummer: {\$sOrderNumber}) on {\$sOrderDay} at {\$sOrderTime}.\n<br/>\n<br/>\n<strong>Information on your order:</strong></p>\n <table width=\"80%\" border=\"0\" style=\"font-family:Arial, Helvetica, sans-serif; font-size:10px;\">\n <tr>\n <td bgcolor=\"#F7F7F2\" style=\"border-bottom:1px solid #cccccc;\"><strong>Art.No.</strong></td>\n <td bgcolor=\"#F7F7F2\" style=\"border-bottom:1px solid #cccccc;\"><strong>Pos.</strong></td>\n <td bgcolor=\"#F7F7F2\" style=\"border-bottom:1px solid #cccccc;\"><strong>Art-Nr.</strong></td>\n <td bgcolor=\"#F7F7F2\" style=\"border-bottom:1px solid #cccccc;\"><strong>Quantities</strong></td>\n <td bgcolor=\"#F7F7F2\" style=\"border-bottom:1px solid #cccccc;\"><strong>Price</strong></td>\n <td bgcolor=\"#F7F7F2\" style=\"border-bottom:1px solid #cccccc;\"><strong>Total</strong></td>\n </tr>\n\n {foreach item=details key=position from=\$sOrderDetails}\n <tr>\n <td rowspan=\"2\" style=\"border-bottom:1px solid #cccccc;\">{if \$details.image.src.0}<img style=\"height: 57px;\" src=\"{\$details.image.src.0}\" alt=\"{\$details.articlename}\" />{else} {/if}</td>\n <td>{\$position+1|fill:4} </td>\n <td>{\$details.ordernumber|fill:20}</td>\n <td>{\$details.quantity|fill:6}</td>\n <td>{\$details.price|padding:8}{\$sCurrency}</td>\n <td>{\$details.amount|padding:8} {\$sCurrency}</td>\n </tr>\n <tr>\n <td colspan=\"5\" style=\"border-bottom:1px solid #cccccc;\">{\$details.articlename|wordwrap:80|indent:4}</td>\n </tr>\n {/foreach}\n\n </table>\n\n<p>\n <br/>\n <br/>\n Shipping costs:: {\$sShippingCosts}<br/>\n Total net: {\$sAmountNet}<br/>\n {if !\$sNet}\n Total gross: {\$sAmount}<br/>\n {/if}\n <br/>\n <br/>\n <strong>Selected payment type:</strong> {\$additional.payment.description}<br/>\n {\$additional.payment.additionaldescription}\n {if \$additional.payment.name == \"debit\"}\n Your bank connection:<br/>\n Account number: {\$sPaymentTable.account}<br/>\n BIN:{\$sPaymentTable.bankcode}<br/>\n We will withdraw the money from your bank account within the next days.<br/>\n {/if}\n <br/>\n <br/>\n {if \$additional.payment.name == \"prepayment\"}\n Our bank connection:<br/>\n {config name=bankAccount}\n {/if}\n <br/>\n <br/>\n <strong>Selected dispatch:</strong> {\$sDispatch.name}<br/>{\$sDispatch.description}\n</p>\n<p>\n {if \$sComment}\n <strong>Your comment:</strong><br/>\n {\$sComment}<br/>\n {/if}\n <br/>\n <br/>\n <strong>Billing address:</strong><br/>\n {\$billingaddress.company}<br/>\n {\$billingaddress.firstname} {\$billingaddress.lastname}<br/>\n {\$billingaddress.street}<br/>\n {if {config name=showZipBeforeCity}}{\$billingaddress.zipcode} {\$billingaddress.city}{else}{\$billingaddress.city} {\$billingaddress.zipcode}{/if}<br/>\n {\$billingaddress.phone}<br/>\n {\$additional.country.countryname}<br/>\n <br/>\n <br/>\n <strong>Shipping address:</strong><br/>\n {\$shippingaddress.company}<br/>\n {\$shippingaddress.firstname} {\$shippingaddress.lastname}<br/>\n {\$shippingaddress.street}<br/>\n {if {config name=showZipBeforeCity}}{\$shippingaddress.zipcode} {\$shippingaddress.city}{else}{\$shippingaddress.city} {\$shippingaddress.zipcode}{/if}<br/>\n {\$additional.countryShipping.countryname}<br/>\n <br/>\n {if \$billingaddress.ustid}\n Your VAT-ID: {\$billingaddress.ustid}<br/>\n In case of a successful order and if you are based in one of the EU countries, you will receive your goods exempt from turnover tax.\n {/if}</p>\r\n<br/><br/>\r\n{include file=\"string:{config name=emailfooterhtml}\"}"
);
}
/** * Helper method to update the translations of a mail template * * @param string $name * @param string $content */
$this->connection = $connection;
}
public function swapProductVariantTranslation(ProductVariant $newMainVariant, ProductVariant $oldMainVariant): void
{
$productId = $newMainVariant->getArticle()->getId();
$oldMainVariantTranslations = $this->getTranslations(self::OBJECT_TYPE_PRODUCT, $productId);
$newMainVariantTranslations = $this->getTranslations(self::OBJECT_TYPE_VARIANT, $newMainVariant->getId());
$this->updateTranslation(self::OBJECT_TYPE_VARIANT, (int) $oldMainVariant->getId(), $oldMainVariantTranslations);
$this->updateTranslation(self::OBJECT_TYPE_PRODUCT, (int) $productId, $newMainVariantTranslations);
}
/** * @param array<int|string, array<string, mixed>> $translationsToUpdate */
private function updateTranslation(string $objectType, int $objectKey, array $translationsToUpdate): void
{
$translationIdsToUpdate = array_map(function D$translation) {
return (int) $translation[self::TRANSLATION_ID_KEY];
}, $translationsToUpdate);
use Shopware\Components\Migrations\AbstractMigration;
class Migrations_Migration939 extends AbstractMigration
{
/** * {@inheritdoc} */
public function up($modus)
{
$this->updateTranslation();
$this->updateCustomerFacetAndSorting();
}
private function updateTranslation(): void
{
$shops = $this->connection->query('SELECT id FROM s_core_shops')->fetchAll(PDO::FETCH_ASSOC);
foreach ($shops as $shop) {
$translation = $this->getExistingSortingTranslations((int) $shop['id']);
if (!empty($translation)) {
$sql = <<<SQL
UPDATE `s_core_config_mails` SET `content` = "$content", `contentHTML` = "$contentHtml" WHERE `name` = "$name" AND dirty = 0
SQL;
$this->addSql($sql);
}
/** * Update translations of mail templates */
private function updateTranslations()
{
$this->updateTranslation(
'sORDER',
"Hello {\$billingaddress.firstname} {\$billingaddress.lastname},\n\nThank you for your order at {config name=shopName} (Number: {\$sOrderNumber}) on {\$sOrderDay} at {\$sOrderTime}.\nInformation on your order:\n\nPos. Art.No. Quantities Price Total\n{foreach item=details key=position from=\$sOrderDetails}\n{\$position+1|fill:4} {\$details.ordernumber|fill:20} {\$details.quantity|fill:6} {\$details.price|padding:8} EUR {\$details.amount|padding:8} EUR\n{\$details.articlename|wordwrap:49|indent:5}\n{/foreach}\n\nShipping costs: {\$sShippingCosts}\nTotal net: {\$sAmountNet}\n{if !\$sNet}\nTotal gross: {\$sAmount}\n{/if}\n\nSelected payment type: {\$additional.payment.description}\n{\$additional.payment.additionaldescription}\n{if \$additional.payment.name == \"debit\"}\nYour bank connection:\nAccount number: {\$sPaymentTable.account}\nBIN:{\$sPaymentTable.bankcode}\nWe will withdraw the money from your bank account within the next days.\n{/if}\n{if \$additional.payment.name == \"prepayment\"}\n\nOur bank connection:\nAccount: ###\nBIN: ###\n{/if}\n\n{if \$sComment}\nYour comment:\n{\$sComment}\n{/if}\n\nBilling address:\n{\$billingaddress.company}\n{\$billingaddress.firstname} {\$billingaddress.lastname}\n{\$billingaddress.street}\n{\$billingaddress.zipcode} {\$billingaddress.city}\n{\$billingaddress.phone}\n{\$additional.country.countryname}\n\nShipping address:\n{\$shippingaddress.company}\n{\$shippingaddress.firstname} {\$shippingaddress.lastname}\n{\$shippingaddress.street}\n{\$shippingaddress.zipcode} {\$shippingaddress.city}\n{\$additional.countryShipping.countryname}{if \$billingaddress.ustid}\n\n\nYour VAT-ID: {\$billingaddress.ustid}\nIn case of a successful order and if you are based in one of the EU countries, you will receive your goods exempt from turnover tax.{/if}",
"<p>Hello {\$billingaddress.firstname} {\$billingaddress.lastname},<br/><br/>\n\nThank you for your order with {config name=shopName} (Nummer: {\$sOrderNumber}) on {\$sOrderDay} at {\$sOrderTime}.\n<br/>\n<br/>\n<strong>Information on your order:</strong></p>\n <table width=\"80%\" border=\"0\" style=\"font-family:Arial, Helvetica, sans-serif; font-size:10px;\">\n <tr>\n <td bgcolor=\"#F7F7F2\" style=\"border-bottom:1px solid #cccccc;\"><strong>Art.No.</strong></td>\n <td bgcolor=\"#F7F7F2\" style=\"border-bottom:1px solid #cccccc;\"><strong>Pos.</strong></td>\n <td bgcolor=\"#F7F7F2\" style=\"border-bottom:1px solid #cccccc;\"><strong>Art-Nr.</strong></td>\n <td bgcolor=\"#F7F7F2\" style=\"border-bottom:1px solid #cccccc;\"><strong>Quantities</strong></td>\n <td bgcolor=\"#F7F7F2\" style=\"border-bottom:1px solid #cccccc;\"><strong>Price</strong></td>\n <td bgcolor=\"#F7F7F2\" style=\"border-bottom:1px solid #cccccc;\"><strong>Total</strong></td>\n </tr>\n\n {foreach item=details key=position from=\$sOrderDetails}\n <tr>\n <td rowspan=\"2\" style=\"border-bottom:1px solid #cccccc;\">{if \$details.image.src.1}<img src=\"{\$details.image.src.1}\" alt=\"{\$details.articlename}\" />{else} {/if}</td>\n <td>{\$position+1|fill:4} </td>\n <td>{\$details.ordernumber|fill:20}</td>\n <td>{\$details.quantity|fill:6}</td>\n <td>{\$details.price|padding:8}{\$sCurrency}</td>\n <td>{\$details.amount|padding:8} {\$sCurrency}</td>\n </tr>\n <tr>\n <td colspan=\"5\" style=\"border-bottom:1px solid #cccccc;\">{\$details.articlename|wordwrap:80|indent:4}</td>\n </tr>\n {/foreach}\n\n </table>\n\n<p>\n <br/>\n <br/>\n Shipping costs:: {\$sShippingCosts}<br/>\n Total net: {\$sAmountNet}<br/>\n {if !\$sNet}\n Total gross: {\$sAmount}<br/>\n {/if}\n <br/>\n <br/>\n <strong>Selected payment type:</strong> {\$additional.payment.description}<br/>\n {\$additional.payment.additionaldescription}\n {if \$additional.payment.name == \"debit\"}\n Your bank connection:<br/>\n Account number: {\$sPaymentTable.account}<br/>\n BIN:{\$sPaymentTable.bankcode}<br/>\n We will withdraw the money from your bank account within the next days.<br/>\n {/if}\n <br/>\n <br/>\n {if \$additional.payment.name == \"prepayment\"}\n Our bank connection:<br/>\n {config name=bankAccount}\n {/if}\n <br/>\n <br/>\n <strong>Selected dispatch:</strong> {\$sDispatch.name}<br/>{\$sDispatch.description}\n</p>\n<p>\n {if \$sComment}\n <strong>Your comment:</strong><br/>\n {\$sComment}<br/>\n {/if}\n <br/>\n <br/>\n <strong>Billing address:</strong><br/>\n {\$billingaddress.company}<br/>\n {\$billingaddress.firstname} {\$billingaddress.lastname}<br/>\n {\$billingaddress.street}<br/>\n {\$billingaddress.zipcode} {\$billingaddress.city}<br/>\n {\$billingaddress.phone}<br/>\n {\$additional.country.countryname}<br/>\n <br/>\n <br/>\n <strong>Shipping address:</strong><br/>\n {\$shippingaddress.company}<br/>\n {\$shippingaddress.firstname} {\$shippingaddress.lastname}<br/>\n {\$shippingaddress.street}<br/>\n {\$shippingaddress.zipcode} {\$shippingaddress.city}<br/>\n {\$additional.countryShipping.countryname}<br/>\n <br/>\n {if \$billingaddress.ustid}\n Your VAT-ID: {\$billingaddress.ustid}<br/>\n In case of a successful order and if you are based in one of the EU countries, you will receive your goods exempt from turnover tax.\n {/if}</p>"
);
}
/** * Helper method to update the translations of a mail template * * @param string $name * @param string $content * @param string $contentHtml */
$this->addSql($sql);
}
/** * Update translations of mail templates */
private function updateTranslations()
{
$this->updateTranslation(
'sORDER',
"Hello {\$billingaddress.firstname} {\$billingaddress.lastname},\n\nThank you for your order at {config name=shopName} (Number: {\$sOrderNumber}) on {\$sOrderDay} at {\$sOrderTime}.\nInformation on your order:\n\nPos. Art.No. Quantities Price Total\n{foreach item=details key=position from=\$sOrderDetails}\n{\$position+1|fill:4} {\$details.ordernumber|fill:20} {\$details.quantity|fill:6} {\$details.price|padding:8} EUR {\$details.amount|padding:8} EUR\n{\$details.articlename|wordwrap:49|indent:5}\n{/foreach}\n\nShipping costs: {\$sShippingCosts}\nTotal net: {\$sAmountNet}\n{if !\$sNet}\nTotal gross: {\$sAmount}\n{/if}\n\nSelected payment type: {\$additional.payment.description}\n{\$additional.payment.additionaldescription}\n{if \$additional.payment.name == \"debit\"}\nYour bank connection:\nAccount number: {\$sPaymentTable.account}\nBIN:{\$sPaymentTable.bankcode}\nWe will withdraw the money from your bank account within the next days.\n{/if}\n{if \$additional.payment.name == \"prepayment\"}\n\nOur bank connection:\nAccount: ###\nBIN: ###\n{/if}\n\n{if \$sComment}\nYour comment:\n{\$sComment}\n{/if}\n\nBilling address:\n{\$billingaddress.company}\n{\$billingaddress.firstname} {\$billingaddress.lastname}\n{\$billingaddress.street}\n{\$billingaddress.zipcode} {\$billingaddress.city}\n{\$billingaddress.phone}\n{\$additional.country.countryname}\n\nShipping address:\n{\$shippingaddress.company}\n{\$shippingaddress.firstname} {\$shippingaddress.lastname}\n{\$shippingaddress.street}\n{\$shippingaddress.zipcode} {\$shippingaddress.city}\n{\$additional.countryShipping.countryname}{if \$billingaddress.ustid}\n\n\nYour VAT-ID: {\$billingaddress.ustid}\nIn case of a successful order and if you are based in one of the EU countries, you will receive your goods exempt from turnover tax.{/if}",
"<p>Hello {\$billingaddress.firstname} {\$billingaddress.lastname},<br/><br/>\n\nThank you for your order with {config name=shopName} (Nummer: {\$sOrderNumber}) on {\$sOrderDay} at {\$sOrderTime}.\n<br/>\n<br/>\n<strong>Information on your order:</strong></p>\n <table width=\"80%\" border=\"0\" style=\"font-family:Arial, Helvetica, sans-serif; font-size:10px;\">\n <tr>\n <td bgcolor=\"#F7F7F2\" style=\"border-bottom:1px solid #cccccc;\"><strong>Art.No.</strong></td>\n <td bgcolor=\"#F7F7F2\" style=\"border-bottom:1px solid #cccccc;\"><strong>Pos.</strong></td>\n <td bgcolor=\"#F7F7F2\" style=\"border-bottom:1px solid #cccccc;\"><strong>Art-Nr.</strong></td>\n <td bgcolor=\"#F7F7F2\" style=\"border-bottom:1px solid #cccccc;\"><strong>Quantities</strong></td>\n <td bgcolor=\"#F7F7F2\" style=\"border-bottom:1px solid #cccccc;\"><strong>Price</strong></td>\n <td bgcolor=\"#F7F7F2\" style=\"border-bottom:1px solid #cccccc;\"><strong>Total</strong></td>\n </tr>\n\n {foreach item=details key=position from=\$sOrderDetails}\n <tr>\n <td rowspan=\"2\" style=\"border-bottom:1px solid #cccccc;\">{if \$details.image.src.1}<img src=\"{\$details.image.src.1}\" alt=\"{\$details.articlename}\" />{else} {/if}</td>\n <td>{\$position+1|fill:4} </td>\n <td>{\$details.ordernumber|fill:20}</td>\n <td>{\$details.quantity|fill:6}</td>\n <td>{\$details.price|padding:8}{\$sCurrency}</td>\n <td>{\$details.amount|padding:8} {\$sCurrency}</td>\n </tr>\n <tr>\n <td colspan=\"5\" style=\"border-bottom:1px solid #cccccc;\">{\$details.articlename|wordwrap:80|indent:4}</td>\n </tr>\n {/foreach}\n\n </table>\n\n<p>\n <br/>\n <br/>\n Shipping costs:: {\$sShippingCosts}<br/>\n Total net: {\$sAmountNet}<br/>\n {if !\$sNet}\n Total gross: {\$sAmount}<br/>\n {/if}\n <br/>\n <br/>\n <strong>Selected payment type:</strong> {\$additional.payment.description}<br/>\n {\$additional.payment.additionaldescription}\n {if \$additional.payment.name == \"debit\"}\n Your bank connection:<br/>\n Account number: {\$sPaymentTable.account}<br/>\n BIN:{\$sPaymentTable.bankcode}<br/>\n We will withdraw the money from your bank account within the next days.<br/>\n {/if}\n <br/>\n <br/>\n {if \$additional.payment.name == \"prepayment\"}\n Our bank connection:<br/>\n {config name=bankAccount}\n {/if}\n <br/>\n <br/>\n <strong>Selected dispatch:</strong> {\$sDispatch.name}<br/>{\$sDispatch.description}\n</p>\n<p>\n {if \$sComment}\n <strong>Your comment:</strong><br/>\n {\$sComment}<br/>\n {/if}\n <br/>\n <br/>\n <strong>Billing address:</strong><br/>\n {\$billingaddress.company}<br/>\n {\$billingaddress.firstname} {\$billingaddress.lastname}<br/>\n {\$billingaddress.street}<br/>\n {\$billingaddress.zipcode} {\$billingaddress.city}<br/>\n {\$billingaddress.phone}<br/>\n {\$additional.country.countryname}<br/>\n <br/>\n <br/>\n <strong>Shipping address:</strong><br/>\n {\$shippingaddress.company}<br/>\n {\$shippingaddress.firstname} {\$shippingaddress.lastname}<br/>\n {\$shippingaddress.street}<br/>\n {\$shippingaddress.zipcode} {\$shippingaddress.city}<br/>\n {\$additional.countryShipping.countryname}<br/>\n <br/>\n {if \$billingaddress.ustid}\n Your VAT-ID: {\$billingaddress.ustid}<br/>\n In case of a successful order and if you are based in one of the EU countries, you will receive your goods exempt from turnover tax.\n {/if}</p>"
);
}
/** * Helper method to update the translations of a mail template * * @param string $name * @param string $content * @param string $contentHtml */