I've override the default.phtml file in for order success mail for dynamic value of storename. The below code will work when we send the order from admin panel but same code is not working when we placed the order the store name is missing on the mail.
Please help where i'm doing mistake.
File location -
/home/top10/public_html/app/design/frontend/Magento/Vendorname/Magento_Sales/templates/email/items/order/default.phtml
<?php
/** @var $block \Magento\Sales\Block\Order\Email\Items\DefaultItems */
/** @var $_item \Magento\Sales\Model\Order\Item */
$_item = $block->getItem();
$_order = $_item->getOrder();
$objectManager = \Magento\Framework\App\ObjectManager::getInstance();
if ($_order->getShippingMethod() == 'customerpickup_customerpickup') {
$resource = $objectManager->get('Magento\Framework\App\ResourceConnection');
$connection = $resource->getConnection();
$order_id = $_order->getIncrementId();
$sql = "SELECT `name` FROM `stores` WHERE `store_id` = (select store_id from clickncollect where order_id = '".$order_id."')";
$result=$connection->fetchOne($sql);
$store_name = "Click and Collect From ".$result;
}else{
$store_name = "";
}
?>
)
on this line ` $store_name = "Click and Collect From ".$result);` – Divya Sekar Oct 15 '19 at 10:30else{ $store_name = "test"; }
– Divya Sekar Oct 15 '19 at 10:33