Kdjykuj

I am calculating total order-count by a particular User and display it in my custom module grid according to customer EmailID.

Now I want to save order-count in my custom table according to the customer Email-ID.

How can I save Order-Count according to user Email-ID?

here, is the file how I am calculating the Order-Count and i am using MySQL database

<?php



namespace FeedbackAddonUiComponentListingColumns;





use MagentoFrameworkViewElementUiComponentFactory;

use MagentoFrameworkViewElementUiComponentContextInterface;



class OrderCount extends MagentoUiComponentListingColumnsColumn

{



    protected $_orderCollectionFactory;

    protected $orders;



    public function __construct

    (

        MagentoSalesModelResourceModelOrderCollectionFactory $orderCollectionFactory,

        UiComponentFactory $uiComponentFactory,

        ContextInterface $context,

        array $components = , 

        array $data = 

    ) 

    {

        $this->_orderCollectionFactory = $orderCollectionFactory;

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

    }   



    public function prepareDataSource(array $dataSource)

    {



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

        {   



            $fieldName = $this->getData('name');



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

            {



                if (isset($item['email'])) 

                {



                    $customerEmail = $item['email'];

                    $objectManager = MagentoFrameworkAppObjectManager::getInstance();

                    $CustomerModel = $objectManager->create('MagentoCustomerModelCustomer'); 

                    $CustomerModel->setWebsiteId(1); 

                    $CustomerModel->loadByEmail($customerEmail); 

                    $userId = $CustomerModel->getId();



                    $orders = count($this->_orderCollectionFactory->

                                     create()->addFieldToSelect('*')

                                     ->addFieldToFilter('customer_id', $userId)

                                     ->setOrder('created_at','desc'));                                      



                    $item[$fieldName] = $orders;





               }

            }

        }



        return $dataSource;

    }

}