Dtyjlui

I am trying to add phone number column in my order grid.

I have added new column through sales_order_grid.xml in my ui_component directory. Code is below:

<?xml version="1.0" encoding="UTF-8"?>

<listing xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

         xsi:noNamespaceSchemaLocation="urn:magento:module:Magento_Ui:etc/ui_configuration.xsd">

    <columns name="sales_order_columns">

        <column name="telephone">

            <argument name="data" xsi:type="array">

                <item name="config" xsi:type="array">

                    <item name="filter" xsi:type="string">text</item>

                    <item name="label" xsi:type="string" translate="true">Phone Number</item>

                    <item name="sortOrder" xsi:type="number">6</item>

                </item>

            </argument>

        </column>

    </columns>

</listing>

What should I do in collection to get phone number?

You added the column in ui_component correctly

Just replace the _renderFiltersBefore function with my function in your module collection class

Path should be Vendor/Yourmodule/Model/ResourceModel/Order/Grid/Collection.php

protected function _renderFiltersBefore()

{

 $joinTable = $this->getTable('sales_order_address');

 $this->getSelect()->joinLeft($joinTable, 'main_table.entity_id = 

 sales_order_address.parent_id AND sales_order_address.address_type = "shipping"', 

 ['telephone']);

 parent::_renderFiltersBefore();

}

In Case if you miss it don't forgot to add this argument in your dependency injection di.xml

<argument name="collections" xsi:type="array">

<item name="sales_order_grid_data_source" xsi:type="string">VendorYourmoduleModelResourceModelOrderGridCollection</item>

</argument>

I hope this will help

Please add ui component class for your column as per below.

<?xml version="1.0" encoding="UTF-8"?>

<listing xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

         xsi:noNamespaceSchemaLocation="urn:magento:module:Magento_Ui:etc/ui_configuration.xsd">

    <columns name="sales_order_columns">

        <column name="telephone" class="VendorModuleUiComponentListingColumnTelephone">

            <argument name="data" xsi:type="array">

                <item name="config" xsi:type="array">

                    <item name="filter" xsi:type="string">text</item>

                    <item name="label" xsi:type="string" translate="true">Phone Number</item>

                    <item name="sortOrder" xsi:type="number">6</item>

                </item>

            </argument>

        </column>

    </columns>

</listing>

Now please add Telephone.php as below

namespace VendorModuleUiComponentListingColumn;



use MagentoSalesApiOrderRepositoryInterface;

use MagentoFrameworkViewElementUiComponentContextInterface;

use MagentoFrameworkViewElementUiComponentFactory;

use MagentoUiComponentListingColumnsColumn;

use MagentoFrameworkApiSearchCriteriaBuilder;



class Telephone extends Column

{

    protected $_orderRepository;

    protected $_searchCriteria;



    public function __construct(ContextInterface $context, UiComponentFactory $uiComponentFactory, OrderRepositoryInterface $orderRepository, SearchCriteriaBuilder $criteria, array $components = , array $data = )

    {

        $this->_orderRepository = $orderRepository;

        $this->_searchCriteria  = $criteria;

        parent::__construct($context, $uiComponentFactory, $components, $data);

    }



    public function prepareDataSource(array $dataSource)

    {

        if (isset($dataSource['data']['items'])) {

            foreach ($dataSource['data']['items'] as & $item) {



                $order  = $this->_orderRepository->get($item["entity_id"]);

                $telephone = $order->getBillingAddress()->getTelephone();



                // $this->getData('name') returns the name of the column so in this case it would return export_status

                $item[$this->getData('name')] = $telephone;

            }

        }



        return $dataSource;

    }

}

Please check and let me know if any issue.