Magento 2 – How to Send Order Confirmation Email Template

email-templatesmagento2order-emailsales-order

I am trying to send an order email confirmation with adding extra attributes values to Admin, But it's not working for me.

Here I have 2 Email templates.

1) It's a default email template

2) Customized email template

First one is the default, and it will send Magento by default.

For the second one I tried below code, it's printing as it is table format.

<?php

namespace ABCSolutions\AvailableStore\Observer;

use Magento\Catalog\Api\ProductRepositoryInterface;
use Magento\Store\Model\StoreManagerInterface;


class AfterPlaceOrderObserver implements \Magento\Framework\Event\ObserverInterface{


    /**
     * Store model manager
     *
     * @var StoreManagerInterface
     */
    protected $storeManager;

    /**
     * @var \Magento\Framework\Translate\Inline\StateInterface
     */
    protected $_inlineTranslation;

    /**
     * @var \Magento\Framework\Mail\Template\TransportBuilder
     */
    protected $_transportBuilder;

    /**
     * @var \Magento\Catalog\Model\ProductFactory
     */
    protected $_productLoader;

    /**
     * @var \Magento\Catalog\Api\ProductRepositoryInterface
     */
    protected $productRepository;

    /**
     * @var \Magento\Sales\Model\Order
     */
    protected $_order;

    /**
     * @var \Magento\Sales\Model\OrderNotifier
     */
    protected $_orderNotifier;

    /**
     * @param \Magento\Framework\Translate\Inline\StateInterface $inlineTranslation
     * @param \Magento\Framework\Mail\Template\TransportBuilder $transportBuilder
     * @param ProductRepositoryInterface $productRepository
     * @param StoreManagerInterface $storeManager
     * @param \Magento\Sales\Model\Order $order
     * @param \Magento\Sales\Model\OrderNotifier $orderNotifier
     */
    public function __construct(
        \Magento\Framework\Translate\Inline\StateInterface $inlineTranslation,
        \Magento\Framework\Mail\Template\TransportBuilder $transportBuilder,
        //\Magento\Catalog\Model\ProductFactory $_productLoader
        ProductRepositoryInterface $productRepository,
        StoreManagerInterface $storeManager,
        \Magento\Sales\Model\Order $order,
    \Magento\Sales\Model\OrderNotifier $orderNotifier
    ){
        $this->_inlineTranslation = $inlineTranslation;
        $this->_transportBuilder = $transportBuilder;
        //$this->_productLoader = $_productLoader;
        $this->productRepository = $productRepository;
        $this->storeManager = $storeManager;
        $this->_order = $order;
        $this->_orderNotifier = $orderNotifier;
    }

    /**
     * @param \Magento\Framework\Event\Observer $observer
     */
    public function execute(\Magento\Framework\Event\Observer $observer)
    {
        /* @var $order \Magento\Sales\Model\Order */
        $order = $observer->getEvent()->getOrder();

        $templateOptions = array('area' => \Magento\Framework\App\Area::AREA_FRONTEND,'store' => 1);
        $mediaPath = $this->storeManager->getStore(1)->getBaseURL(\Magento\Framework\UrlInterface::URL_TYPE_MEDIA) . 'catalog/product';

        $table = "";
        $table .= "<table>";
        $table .= "<thead>";
        $table .= "<tr>";
        $table .= "<th>";
        $table .= "Product Image";
        $table .= "</th>";
        $table .= "<th>";
        $table .= "Product Name";
        $table .= "</th>";
        $table .= "<th>";
        $table .= "Qty.";
        $table .= "</th>";
        $table .= "<th>";
        $table .= "Price";
        $table .= "</th>";
        $table .= "</tr>";
        $table .= "</thead>";
        //start foreach for items
        foreach($order->getAllItems() as $_items){

            $_product = $this->productRepository->getById($_items->getProductId());
            $imageThumbNail = $mediaPath . $_product->getThumbnail();
            $pSKU=$_product->getSku();
            $productName = $_product->getName();
            $QtyOrdered = $_items->getQtyOrdered();
            $pPrice = $_product->getPrice();
            $CAField = $_product->getCustomAttributeField();

            $table .= "<tr>";
            $table .= "<td style='width: 120px;text-align: center;'>";
            $table .= "<img src='$imageThumbNail' title='$productName' style='width: 70px;height: 70px;' />";
            $table .= "</td>";
            $table .= "<td style='width: 200px;'>";
            $table .= "<table>";
            $table .= "<tr>";
            $table .= "<td>";
            $table .= "<span style='color: Blue;'>SKU: </span>";
            $table .= "</td>";
            $table .= "<td>";
            $table .= " <span>$pSKU</span>";
            $table .= "</td>";
            $table .= "</tr>";
            $table .= "<tr>";
            $table .= "<td>";
            $table .= "<span style='color: Blue;'>Cust. Attr. Field: </span>";
            $table .= "</td>";
            $table .= "<td>";
            $table .= "<span style='font-size: 14px;'>$CAField</span>";
            $table .= "</td>";
            $table .= "</tr>";
            $table .= "</table>";
            $table .= "</td>";
            $table .= "<td style='width: 50px;text-align: center;'>";
            $table .= "<span>$QtyOrdered</span>";
            $table .= "</td>";
            $table .= "<td style='text-align: center;'>";
            $table .= "<span>$pPrice</span>";
            $table .= "</td>";
            $table .= "</tr>";

        }

        //end foreach
        $table .= "</table>";

        $mass = $table;

        $templateVars = array(
            'store' => 1,
            'orderNumber' => $order->getIncrementId(),
            'customer_name' => $order->getCustomerName(),
            'message'  => $mass
        );

        $from = array(
            'email' => 'info@gmail.com',
            'name' => 'Customer Care'
        );

        $to = "abc@gmail.com";
        try {
            $this->_inlineTranslation->suspend();
            $to = array($to);
            $transport = $this->_transportBuilder->setTemplateIdentifier('custom_email_template')
                ->setTemplateOptions($templateOptions)
                ->setTemplateVars($templateVars)
                ->setFrom($from)
                ->addTo($to)
                ->getTransport();
            $transport->sendMessage();
            $this->_inlineTranslation->resume(); 
        }
        catch (\Exception $e)
        {
            echo $e->getMessage();
        }
    }

}

It's printing table format, like below image.

Please suggest us to send the email of order email copy with extra attributes?

Best Answer

Solved my self, for the Reference of Thread.

create email_templates.xml file from etc folder and paste below code.

<?xml version="1.0"?>
<config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../../Email/etc/email_templates.xsd">
    <template id="available_store_template" label="Available Store" file="available_store.html" type="html" module="ABCSolutions_AvailableStore" area="frontend"/>
</config>

Create available_store.html file from view/frontend/email folder and paste below code.

<!--@subject Available Stores for the Order of : {{var orderNumber}} @-->
<!--@vars
{"store url=\"\"":"Store Url",
"skin url=\"images/logo_email.gif\" _area='frontend'":"Email Logo Image"}
@-->
<!--@styles
body,td { color:#2f2f2f; font:11px/1.35em Verdana, Arial, Helvetica, sans-serif; }
@-->
{{template config_path="design/email/header_template"}}
<div style="background:#F6F6F6; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:12px; margin:0; padding:0;">
    <table cellspacing="0" cellpadding="0" border="0" width="100%">
        <tr>
            <td align="center" valign="top" style="padding:20px 0 20px 0">
                <table bgcolor="#FFFFFF" cellspacing="0" cellpadding="10" border="0" width="650" style="border:1px solid #E0E0E0;">
                    <tr>
                        <td valign="top">
                            <h1 style="font-size:22px;font-weight:normal;line-height:22px;margin:0 0 11px 0;">{{trans "Hello Supervisor"}},</h1>
                        </td>
                    </tr>
                    <tr>
                        <td valign="top">
                            <h1 style="font-size:22px;font-weight:normal;line-height:22px;margin:0 0 11px 0;">{{trans "Please find below order information."}}</h1>
                        </td>
                    </tr>
                    <tr>
                        <td>
                            {{layout handle="email_product_list" items=$items area="frontend"}}
                        </td>
                    </tr>
                    <tr>
                        <td valign="top">
                            <h1 style="font-size:22px;font-weight:normal;line-height:22px;margin:0 0 11px 0;">{{trans "If you have any queries, Please contact Admin: +91 9949906633"}}</h1>
                        </td>
                    </tr>
                </table>
            </td>
        </tr>
    </table>
</div>
 {{template config_path="design/email/footer_template"}}

Create events.xml file from etc folder and paste below code.

<?xml version="1.0"?> 
<config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:framework:Event/etc/events.xsd">
    <event name="sales_order_place_after">
        <observer name="send_available_store_order_items" instance="ABCSolutions\AvailableStore\Observer\AfterPlaceOrderObserver" />
    </event>
</config>

Create AfterPlaceOrderObserver.php file from Observer folder and paste below code.

public function execute(\Magento\Framework\Event\Observer $observer)
    {
        /* @var $order \Magento\Sales\Model\Order */
        $order = $observer->getEvent()->getOrder();

        $templateOptions = array('area' => \Magento\Framework\App\Area::AREA_FRONTEND,'store' => 1); 

        $templateVars = array(
            'store' => 1,
            'orderNumber' => $order->getIncrementId(),
            'customer_name' => $order->getCustomerName(),
            'items'=> $order->getAllItems(),
        );

        $from = array(
            'email' => 'info@gmail.in',
            'name' => 'Customer Care'
        );

        $to = "abc@gmail.com";
        try {
            $this->_inlineTranslation->suspend();
            $to = array($to);
            $transport = $this->_transportBuilder->setTemplateIdentifier('available_store_template')
                ->setTemplateOptions($templateOptions)
                ->setTemplateVars($templateVars)
                ->setFrom($from)
                ->addTo($to)
                ->getTransport();
            $transport->sendMessage();
            $this->_inlineTranslation->resume();
        }
        catch (\Exception $e)
        {
            echo $e->getMessage();
        }
    }

create layout file email_product_list.xml from view/frontend/layout and paste below code.

<?xml version="1.0"?>
<page xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:framework:View/Layout/etc/page_configuration.xsd" label="Email Product List" design_abstraction="custom">
    <body>
        <block class="Magento\Framework\View\Element\Template" name="additional.product.info" template="ABCSolutions_AvailableStore::email/product.phtml"/>
    </body>
</page>

And create product.phtml file from view/frontend/templates/email and paste below code.

<?php $_items = $block->getItems() ?>
<table class="email-items">
    <thead>
    <tr>
        <th class="item-info">
            <?= /* @escapeNotVerified */  __('Product Image'); ?>
        </th>
        <th class="item-info">
            <?= /* @escapeNotVerified */  __('Product Name'); ?>
        </th>
        <th class="item-qty">
            <?= /* @escapeNotVerified */  __('Qty'); ?>
        </th>
        <th class="item-qty">
            <?= /* @escapeNotVerified */  __('Each Price'); ?>
        </th>
        <th class="item-price">
            <?= /* @escapeNotVerified */  __('Total Price'); ?>
        </th>
    </tr>
    </thead>
    <tbody>
    <?php
        $om = \Magento\Framework\App\ObjectManager::getInstance();
        $storeManager = $om->create('\Magento\Store\Model\StoreManagerInterface');
        $thumbNail =  $storeManager->getStore()->getBaseUrl(\Magento\Framework\UrlInterface::URL_TYPE_MEDIA) . 'catalog/product';
        $productRepository = $storeManager = $om->create('\Magento\Catalog\Api\ProductRepositoryInterface');
        $totalAmount = 0;
    ?>
    <?php foreach ($_items as $_item): ?>
        <?php $_product = $productRepository->getById($_item->getProductId()); ?>
        <tr>
            <td>
                <?php $product_image_url =  $thumbNail . $_product->getThumbnail();?>
                <img id='image' src="<?php echo $product_image_url; ?>" style='border-width:0px;height:80px;width:80px;'>
            </td>
            <td>
                <a href="<?php echo $block->getBaseUrl() . $_item->getProduct()->getUrlKey(); ?>">
                    <p class="product-name"><?php echo $block->escapeHtml($_item->getName()) ?></p>
                </a>
                <p class="sku">
                    <b><?php /* @escapeNotVerified */ echo  __('SKU') . ' : '  ?></b>
                    <a href="<?php echo $block->getBaseUrl() . $_item->getProduct()->getUrlKey(); ?>">
                        <?php echo $block->escapeHtml($_item->getSku()); ?>
                    </a>
                </p>
                <p class="sku">
                    <b><?php /* @escapeNotVerified */ echo  __('Available Store') . ' : '  ?></b>
                    <?php echo $block->escapeHtml($_product->getAvailableStore()); ?>
                </p>
            </td>
            <td class="item-qty">
                <span><?php echo $_item->getQtyOrdered() ?></span>
            </td>
            <td class="item-price">
                <span><?php echo $_item->getOriginalPrice() ?></span>
            </td>
            <td class="item-price">
                <span><?php echo $_item->getQtyOrdered() * $_item->getOriginalPrice() ?></span>
            </td>
            <?php
            $tAmount = $_item->getQtyOrdered() * $_item->getOriginalPrice();
            $totalAmount += $tAmount;
            ?>
        </tr>
    <?php endforeach; ?>
        <tr>
            <td colspan="4" style="text-align: right;font-size: 16px;font-weight: bold;">
                <span>Total: </span>
            </td>
            <td style="text-align: right;font-size: 16px;font-weight: bold;">
               <span><?php echo $totalAmount ?></span>
            </td>
        </tr>
    </tbody>
</table>

Related Solutions

Magento 2 Email Templates – How to Add Email in CC for Order Confirmation Email Template

cc function existed in zend_mail class in lib folder.

public function addCc($email, $name='')
        {
            if (!is_array($email)) {
                $email = array($name => $email);
            }

            foreach ($email as $n => $recipient) {
                $this->_addRecipientAndHeader('Cc', $recipient, is_int($n) ? '' : $n);
            }

            return $this;
        }

For now i just edited core files.but we need to override to our local/community folder.I have created 2 arrays & 4 new functions for cc in info.php

<?php
class Mage_Core_Model_Email_Info extends Varien_Object
{
    /**
     * Name list of "Bcc" recipients
     *
     * @var array
     */
    protected $_bccNames = array();
    protected $_ccNames=array();

    /**
     * Email list of "Bcc" recipients
     *
     * @var array
     */
    protected $_bccEmails = array();
    protected $_ccEmails = array();
    /**
     * Name list of "To" recipients
     *
     * @var array
     */
    protected $_toNames = array();

    /**
     * Email list of "To" recipients
     *
     * @var array
     */
    protected $_toEmails = array();


    /**
     * Add new "Bcc" recipient to current email
     *
     * @param string $email
     * @param string|null $name
     * @return Mage_Core_Model_Email_Info
     */
    public function addBcc($email, $name = null)
    {
        array_push($this->_bccNames, $name);
        array_push($this->_bccEmails, $email);
        return $this;
    }
 public function addCc($email, $name = null)
    {
        array_push($this->_ccNames, $name);
        array_push($this->_ccEmails, $email);
        return $this;
    }
    /**
     * Add new "To" recipient to current email
     *
     * @param string $email
     * @param string|null $name
     * @return Mage_Core_Model_Email_Info
     */
    public function addTo($email, $name = null)
    {
        array_push($this->_toNames, $name);
        array_push($this->_toEmails, $email);
        return $this;
    }

    /**
     * Get the name list of "Bcc" recipients
     *
     * @return array
     */
    public function getBccNames()
    {
        return $this->_bccNames;
    }

    /**
     * Get the email list of "Bcc" recipients
     *
     * @return array
     */
    public function getBccEmails()
    {
        return $this->_bccEmails;
    }
/**
     * Get the name list of "cc" recipients
     *
     * @return array
     */
    public function getccNames()
    {
        return $this->_ccNames;
    }

    /**
     * Get the email list of "Bcc" recipients
     *
     * @return array
     */
    public function getccEmails()
    {
        return $this->_ccEmails;
    }
    /**
     * Get the name list of "To" recipients
     *
     * @return array
     */
    public function getToNames()
    {
        return $this->_toNames;
    }

    /**
     * Get the email list of "To" recipients
     *
     * @return array
     */
    public function getToEmails()
    {
        return $this->_toEmails;
    }
}

In Mage_Core_Model_Email_Template_Mailer

public function send()
    {
        $emailTemplate = Mage::getModel('core/email_template');
        // Send all emails from corresponding list
        while (!empty($this->_emailInfos)) {
            $emailInfo = array_pop($this->_emailInfos);
            // Handle "Bcc" recepients of the current email
            $emailTemplate->addBcc($emailInfo->getBccEmails());
            $emailTemplate->addCc($emailInfo->getccEmails());
            // Set required design parameters and delegate email sending to Mage_Core_Model_Email_Template
            $emailTemplate->setDesignConfig(array('area' => 'frontend', 'store' => $this->getStoreId()))
                ->sendTransactional(
                $this->getTemplateId(),
                $this->getSender(),
                $emailInfo->getToEmails(),
                $emailInfo->getToNames(),
                $this->getTemplateParams(),
                $this->getStoreId()
            );
        }
        return $this;
    }

add this function in Mage_Core_Model_Email_Template

public function addCc($cc)
    {
        if (is_array($cc)) {
            foreach ($cc as $email) {
                $this->getMail()->addCc($email);
            }
        }
        elseif ($cc) {
            $this->getMail()->addCc($cc);
        }
        return $this;
    }

Magento – Unit Test for overwrite collection class in magento2

First of all better to do not mock class under test.

Second one, better to use plugins instead of class overwrite.

And last, you must pass all parameters of parent constructor to your class.

Simplest way to instantiate class is using objectMangerHelper

    $objectManager = new \Magento\Framework\TestFramework\Unit\Helper\ObjectManager($this);
    $this->collection = $objectManager->getObject(
        'SR\RewriteSales\Model\Resource\Order\Collection',
        [
            'resource' => $resource, 
            'connection' => $connection,

        ]
    );

Best Answer

Related Solutions

Magento 2 Email Templates – How to Add Email in CC for Order Confirmation Email Template

Magento – Unit Test for overwrite collection class in magento2

Related Topic