Category: magento 2.x

File Path as below

app/code/ Mage2db/John/Ui/Component/Listing/Column/Store.php

<?php
namespace Mage2db\John\Ui\Component\Listing\Column;

use Magento\Framework\View\Element\UiComponent\ContextInterface;
use Magento\Framework\View\Element\UiComponentFactory;
use Magento\Ui\Component\Listing\Columns\Column;
use Magento\Framework\UrlInterface;
use Magento\Cms\Block\Adminhtml\Page\Grid\Renderer\Action\UrlBuilder;
use Magento\Framework\Pricing\PriceCurrencyInterface;
use Magento\Store\Model\StoreManagerInterface;
/**
 * Class ProductActions
 */
class Store extends Column
{

    /**
     * @var UrlInterface
     */
    protected $urlBuilder;
    /**
     * @var PriceCurrencyInterface
     */
    protected $priceFormatter;
    /**
     * @var actionUrlBuilder
     */
    protected $actionUrlBuilder;
    /**
     * @var $_storeManager
     */
    protected $_storeManager;


    /**
     * @param ContextInterface $context
     * @param UiComponentFactory $uiComponentFactory
     * @param UrlInterface $urlBuilder
     * @param array $components
     * @param array $data
     */
    public function __construct(
        ContextInterface $context,
        UiComponentFactory $uiComponentFactory,
        UrlInterface $urlBuilder,
        UrlBuilder $actionUrlBuilder,
        PriceCurrencyInterface $priceFormatter,
        StoreManagerInterface $storeManager,
        array $components = [],
        array $data = []
    ) {
        $this->urlBuilder = $urlBuilder;
        $this->actionUrlBuilder = $actionUrlBuilder;
        $this->priceFormatter = $priceFormatter;
        $this->_storeManager = $storeManager;
        parent::__construct($context, $uiComponentFactory, $components, $data);
    }

    /**
     * Prepare Data Source
     *
     * @param array $dataSource
     * @return array
     */
    public function prepareDataSource(array $dataSource)
    {
        if (isset($dataSource['data']['items'])) {
			
            foreach ($dataSource['data']['items'] as & $item) {
	
 	            $Websites = $this->_storeManager->getWebsites();
				
                $WebsiteName="-";
			
                foreach ($Websites as $website) {
                    if($website->getId()==$item['website_id']){
                      /*put your custom column name instead of website_id */
                        $WebsiteName = $website->getName();
                    }
                }
                $item[$this->getData('name')] = $WebsiteName;
            }
        }
        return $dataSource;
    }
}

Step [2] – Add below code in Admin UI Component Grid Listing.

File Path as below

app/code/ Mage2db/John/view/adminhtml/ui_component/UIGridListing.xml

<column name="website_id" class="Mage2db\John\Ui\Component\Listing\Column\Store">
 <argument name="data" xsi:type="array">
 <item name="config" xsi:type="array">
 <item name="component" xsi:type="string">Mage2db_John/js/ui/grid/columns/html</item>
<item name="align" xsi:type="string">left</item>
 <item name="sortable" xsi:type="boolean">false</item>
<item name="label" xsi:type="string" translate="true">Store View</item>
<item name="sortOrder" xsi:type="number">60</item>
 </item>
 </argument>
</column>

Step [3] – Add below code in Admin UI Component Grid Entry Form

File Path as below

app/code/ Mage2db/John/view/adminhtml/ui_component/UIGridEntryForm.xml

<field name="website_id" formElement="select">
   <settings>
   <dataType>text</dataType>
    <label translate="true">Website</label>
    <dataScope>data_title</dataScope>
   </settings>
 <formElements>
  <select>
  <settings>
 <options>
 <option name="1" xsi:type="array">
    <item name="value" xsi:type="string">1</item>
    <item name="label" xsi:type="string">Main Website</item>
 </option>
 <option name="2" xsi:type="array">
 <item name="value" xsi:type="string">2</item>
 item name="label" xsi:type="string">Firstwebsite</item>
 </option>
 <option name="3" xsi:type="array">
 <item name="value" xsi:type="string">3</item>
 <item name="label" xsi:type="string">secondsite</item>
 </option>
 </options>
 <caption translate="true">-- Select Website --</caption>
 </settings>
 </select>
 </formElements>
 </field> 

Finally Website drop down has been added in Magento 2 Admin Grid Entry Form as well as It’s corressponding value displaying in Magento 2 Admin Grid Listing by using UI Component.

<?php
namespace Mage2db\John\Block;
class Index extends \Magento\Framework\View\Element\Template
{
    protected $_storeManager;    
    
    public function __construct(
        \Magento\Backend\Block\Template\Context $context,        
        \Magento\Store\Model\StoreManagerInterface $storeManager,        
        array $data = []
    )
    {        
        $this->_storeManager = $storeManager;        
        parent::__construct($context, $data);
    }
    
    /**
     * Get store identifier
     *
     * @return  int
     */
    public function getStoreId()
    {
        return $this->_storeManager->getStore()->getId();
    }
    
    /**
     * Get website identifier
     *
     * @return string|int|null
     */
    public function getWebsiteId()
    {
        return $this->_storeManager->getStore()->getWebsiteId();
    }
    
    /**
     * Get Store code
     *
     * @return string
     */
    public function getStoreCode()
    {
        return $this->_storeManager->getStore()->getCode();
    }
    
    /**
     * Get Store name
     *
     * @return string
     */
    public function getStoreName()
    {
        return $this->_storeManager->getStore()->getName();
    }
    
    /**
     * Get current url for store
     *
     * @param bool|string $fromStore Include/Exclude from_store parameter from URL
     * @return string     
     */
    public function getStoreUrl($fromStore = true)
    {
        return $this->_storeManager->getStore()->getCurrentUrl($fromStore);
    }
    
    /**
     * Check if store is active
     *
     * @return boolean
     */
    public function isStoreActive()
    {
        return $this->_storeManager->getStore()->isActive();
    }
}
?>

Call above block method inside template phtml file.

echo"<BR> Store ID=".$block->getStoreId();
echo"<BR> Store Code=".$block->getStoreCode();
echo"<BR> Store Website ID=".$block->getWebsiteId();
echo"<BR> Store Name=".$block->getStoreName();
echo"<BR> Store URL=".$block->getStoreUrl();
echo"<BR> Store Active Yes / No=". $block->isStoreActive();

/vendor/magento/framework/Setup/Declaration/Schema/Db/DefinitionAggregator.php

 fint fromDefinition() method and then add debug code to find column name as below , we have addedd (debugging) code inside

/* Starts Add Code for Debug */ and /* Code End for Debug */

public function fromDefinition(array $data)
    {
        $type = $data['type'];
        if (!isset($this->definitionProcessors[$type])) {

            /* Starts Add Code for Debug */

            echo "<pre>";
            print_r($data); exit();

            /* Code End for Debug  */

            throw new \InvalidArgumentException(
                sprintf("Cannot process definition to array for type %s", $type)
            );
        }

        $definitionProcessor = $this->definitionProcessors[$type];
        return $definitionProcessor->fromDefinition($data);
    }

<?php

\Magento\Framework\Component\ComponentRegistrar::register(
    \Magento\Framework\Component\ComponentRegistrar::MODULE,
    'Namespace_Modulename',
    __DIR__
);

<config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:framework:Module/etc/module.xsd">
<module name="Namespace_Modulename" setup_version="3.0.1"/> 
</config>

_{Namespace = Mage2db}

_{Modulename = John}

<config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:framework:Module/etc/module.xsd">
<module name="Mage2db_John" setup_version="3.0.1"/> 
</config>

The schema_version is no longer required since releasing Magento 2.3.3

Briefly Explain module.xml

namespace Mage2db/AllCustomers/Block;

use Magento\Backend\App\Action;


class AllCustomers extends Action
{

    protected $customerCollection;

    public function __construct(
        \Magento\Customer\Model\ResourceModel\Customer\CollectionFactory $customerCollection
    )
    {
        $this->customerCollection = $customerCollection;
    }

    public function getAllCustomers()
    {
            return $this->customerCollection->create();


    }
}

$allCustomersdata = $this->getAllCustomers();
foreach ($allCustomersdata as $customer) {
    echo $customer->getEmail();
    echo $customer->getFirstname();
    echo $customer->getLastname();
}