5

create custom module

view/adminhtml/layout/customer_index_edit.xml

<referenceBlock name="customer_form">           
             <block class="vender\module\Block\Adminhtml\Customer\Customerproduct" name="custom_edit_tab_view" />   

            <action method="setTabLabel">
                  <argument name="label" xsi:type="string">Products</argument>
              </action>           

        </referenceBlock>

Now Vender/MOdule/Block/Adminhtml/Customer

<?php
/**
 * @copyright Copyright (c) 2016 www.magebuzz.com
 */
namespace Vender\Module\Block\Adminhtml\Customer;

use Magento\Ui\Component\Layout\Tabs\TabWrapper;
use Magento\Ui\Component\Layout\Tabs\TabInterface; 
use Magento\Customer\Controller\RegistryConstants;
use Magento\Backend\Block\Widget\Form;
use Magento\Backend\Block\Widget\Form\Generic;


class Customerproduct extends Generic implements TabInterface
{

    /*
     *
     * @var \Magento\Framework\Registry
     */
    protected $_coreRegistry;



    /**
     * @var \Magento\Store\Model\System\Store
     */
    protected $_systemStore;
    /**
     * Core registry
     *
     * @var \Magento\Framework\Registry
     */

    public function __construct(
        \Magento\Backend\Block\Template\Context $context,
        \Magento\Framework\Registry $registry,
        \Magento\Framework\Data\FormFactory $formFactory,
        \Magento\Store\Model\System\Store $systemStore,

        array $data = []
    ) {
        $this->_coreRegistry = $registry;
        $this->_systemStore = $systemStore;
        parent::__construct($context, $registry, $formFactory, $data);
    }



    /**
     * @return string|null
     */
    public function getCustomerId()
    {
        return $this->_coreRegistry->registry(RegistryConstants::CURRENT_CUSTOMER_ID);
    }

    /**
     * @return \Magento\Framework\Phrase
     */ 
    public function getTabLabel()
    {
        return __('Products');
    }


    /**
     * @return \Magento\Framework\Phrase
     */
    public function getTabTitle()
    {
        return __('Products');
    }


    /**
     * @return bool
     */
    public function canShowTab()
    {
        //echo $this->getCustomerId();
        if ($this->getCustomerId()) {
            return true;
        }
        return false;
    }



     /**
     * @return bool
     */
    public function isHidden()
    {
        if ($this->getCustomerId()) {
            return false;
        }
        return true;
    }

    /**
     * Tab class getter
     *
     * @return string
     */
    public function getTabClass()
    {
        return '';
    }


    /**
     * Return URL link to Tab content
     *
     * @return string
     */

    public function getTabUrl()
    {
        return $this->getUrl('module/*/customerproduct', ['_current' => true]);

    }

     /**
     * Tab should be loaded trough Ajax call
     *
     * @return bool
     */

    public function isAjaxLoaded()
    {
        return true;
    }


}

Now Vender/Module/view/adminhtml/layout/module_index_customerproduct.xml

<?xml version="1.0"?>
<layout xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:framework:View/Layout/etc/layout_generic.xsd">
    <container name="root" label="Root">
        <block class="Vender\Module\Block\Adminhtml\Product\Edit\Tab\Customerproduct" name="edit.tab.customerproduct"/>
        <block class="Magento\Backend\Block\Widget\Grid\Serializer" name="customerproduct_grid_serializer">
            <arguments>                
                <argument name="grid_block" xsi:type="string">edit.tab.customerproduct</argument>
                <argument name="callback" xsi:type="string">getSelectedProducts</argument>              
                <argument name="input_element_name" xsi:type="string">customerproduct_ids</argument>
                <argument name="reload_param_name" xsi:type="string">contact_products</argument>               
            </arguments>
        </block>
    </container>
</layout>

Vender/Module/view/adminhtml/layout/module_index_customerproductgrid.xml

<?xml version="1.0" encoding="UTF-8"?>
<layout xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:framework:View/Layout/etc/layout_generic.xsd">
    <container name="root" label="Root">
        <block class="Vender\Module\Block\Adminhtml\Product\Edit\Tab\Customerproduct" name="edit.tab.customerproduct"/>        
    </container>
</layout>

Now Vender/Module/Block/Adminhtml/Product/Edit/Tab

<?php
/**
 * Copyright © 2016 Magento. All rights reserved.
 * See COPYING.txt for license details.
 */

namespace Vender\Module\Block\Adminhtml\Product\Edit\Tab;

use Magento\Backend\Block\Widget\Grid\Column;
use Magento\Backend\Block\Widget\Grid\Extended;



class Customerproduct extends Extended
{

    /**
     * Core registry
     *
     * @var \Magento\Framework\Registry
     */
    protected $_coreRegistry = null;

    /**
     * @var \Magento\Catalog\Model\Product\LinkFactory
     */
    protected $_linkFactory;

    /**
     * @var \Magento\Eav\Model\ResourceModel\Entity\Attribute\Set\CollectionFactory]
     */
    protected $_setsFactory;

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

    /**
     * @var \Magento\Catalog\Model\Product\Type
     */
    protected $_type;

    /**
     * @var \Magento\Catalog\Model\Product\Attribute\Source\Status
     */
    protected $_status;

    /**
     * @var \Magento\Catalog\Model\Product\Visibility
     */
    protected $_visibility;

    protected $_ScopeConfigInterface;

    protected $_abcproduct;
    /**
     * @param \Magento\Backend\Block\Template\Context $context
     * @param \Magento\Backend\Helper\Data $backendHelper
     * @param \Magento\Catalog\Model\Product\LinkFactory $linkFactory
     * @param \Magento\Eav\Model\ResourceModel\Entity\Attribute\Set\CollectionFactory $setsFactory
     * @param \Magento\Catalog\Model\ProductFactory $productFactory
     * @param \Magento\Catalog\Model\Product\Type $type
     * @param \Magento\Catalog\Model\Product\Attribute\Source\Status $status
     * @param \Magento\Catalog\Model\Product\Visibility $visibility
     * @param \Magento\Framework\Registry $coreRegistry
     * @param array $data
     *
     * @SuppressWarnings(PHPMD.ExcessiveParameterList)
     */
    public function __construct(
        \Magento\Backend\Block\Template\Context $context,
        \Magento\Backend\Helper\Data $backendHelper,
        \Magento\Catalog\Model\Product\LinkFactory $linkFactory,
        \Magento\Eav\Model\ResourceModel\Entity\Attribute\Set\CollectionFactory $setsFactory,
        \Magento\Catalog\Model\ResourceModel\Product\CollectionFactory $productFactory,
        \Magento\Catalog\Model\Product\Type $type,
        \Magento\Catalog\Model\Product\Attribute\Source\Status $status,
        \Magento\Catalog\Model\Product\Visibility $visibility,
        \Magento\Framework\Registry $coreRegistry,
        \Magento\Framework\App\Config\ScopeConfigInterface $ScopeConfigInterface,
        \Vendor\Modulw\Model\AbcproductFactory $abcproduct,
        \Magento\Framework\ObjectManagerInterface $objectManager,
        array $data = []
    ) {
        $this->_linkFactory = $linkFactory;
        $this->_setsFactory = $setsFactory;
        $this->_productFactory = $productFactory;
        $this->_type = $type;
        $this->_status = $status;
        $this->_visibility = $visibility;
        $this->_coreRegistry = $coreRegistry;
        $this->_ScopeConfigInterface = $ScopeConfigInterface;
        $this->_abcproduct= $abcproduct;
        $this->_objectManager = $objectManager;
        parent::__construct($context, $backendHelper, $data);
    }

    /**
     * _construct
     * @return void
     */
    protected function _construct()
    {

        parent::_construct();
        $this->setId('customerproduct_ids');
        $this->setDefaultSort('entity_id');
        $this->setDefaultDir('DESC');
        $this->setSaveParametersInSession(true);
        $this->setFilterVisibility(true);
        $this->setUseAjax(true);

        //$this->setVarNameFilter('product_filter');

        $this->setUseAjax(true);
        if ($this->getRequest()->getParam('id')) {
            $this->setDefaultFilter(array('in_product' => 1));
        }



    }   

    /**
     * add Column Filter To Collection
     */
    protected function _addColumnFilterToCollection($column)
    {
        if ($column->getId() == 'in_product') {
            $productIds = $this->_getSelectedProducts();

            if (empty($productIds)) {
                $productIds = 0;
            }
            if ($column->getFilter()->getValue()) {
                $this->getCollection()->addFieldToFilter('entity_id', array('in' => $productIds));
            } else {
                if ($productIds) {
                    $this->getCollection()->addFieldToFilter('entity_id', array('nin' => $productIds));
                }
            }
        } else {
            parent::_addColumnFilterToCollection($column);
        }

        return $this;
    }


    /**
     * prepare collection
     */
    protected function _prepareCollection()
    {
       // $collection = $this->productCollectionFactory->create();
        $collection = $this->_productFactory->create();
        $collection->addAttributeToSelect('name');
        $collection->addAttributeToSelect('sku');
        $collection->addAttributeToSelect('price');
        $this->setCollection($collection);
        return parent::_prepareCollection();
    }




    /**
     * @return $this
     */
    protected function _prepareColumns()
    {


        $this->addColumn(
            'in_product',
            [
                'header_css_class' => 'a-center',
                'type' => 'checkbox',
                'name' => 'in_product',
                'align' => 'center',
                'index' => 'entity_id',
                'values' => $this->_getSelectedProducts(),
                //'field_name' => 'selectedproducts[]'
            ]
        );


        $this->addColumn(
            'entity_id',
            [
                'header' => __('ID'),
                'type' => 'number',
                'index' => 'entity_id',
                'header_css_class' => 'col-id',
                'column_css_class' => 'col-id',
            ]
        );
        $this->addColumn(
            'name',
            [
                'header' => __('Name'),
                'index' => 'name',
                'class' => 'xxx',
                'width' => '50px',
            ]
        );
        $this->addColumn(
            'sku',
            [
                'header' => __('Sku'),
                'index' => 'sku',
                'class' => 'xxx',
                'width' => '50px',
            ]
        );
        $this->addColumn(
            'price',
            [
                'header' => __('Price'),
                'type' => 'currency',
                'index' => 'price',
                'width' => '50px',
            ]
        );

        return parent::_prepareColumns();
    }

    /**
     * @return string
     */
    public function getGridUrl()
    {
        return $this->getUrl('*/*/customerproductgrid', ['_current' => true]);
    }



    /**
     * @param  object $row
     * @return string
     */
    public function getRowUrl($row)
    {
        return '';
    }

    protected function _getSelectedProducts()
    {
        $contact = $this->getContact();

    //  print_r($contact->getProducts($contact));

        return  $contact;


    }

    /**
     * Retrieve selected products
     *
     * @return array
     */
    public function getSelectedProducts()
    {
        $contact = $this->getContact();

        return $contact;


    }

    protected function getContact()
    {
        $products = [];
        $customerId = $this->getRequest()->getParam('id');



        if ($customerId) {           

            $contacts = $this->_abcproduct->create()->getCollection();  
            $contacts->addFieldToSelect('*')->addFieldToFilter("customer_id", ['eq' =>$customerId ]);           

        }

         foreach ($contacts as $product) {

            $products[] = $product->getProductId();
        }

        return $products;   


    }


}

http://www.ibnab.com/en/blog/magento-2/magento-2-backend-create-custom-tab-in-customer-view-and-load-grid-inside-admin

Add new tab in customer specific product in customer tab and get all list of product but I can't save,

Because it's not being added in form How to add checkbox in form and save?

enter image description here

How to save data plz help me

solution How do i add product grid in customer admin section and save the checkbox values to database

  • Ref : webkul.com/blog/… i have product grid and i want save it – Nikhil Vaghela Nov 14 '16 at 11:06
  • yes, wait a min. – Ronak Chauhan Nov 14 '16 at 11:12
  • are you trying to save product Ids in your custom table? – Ronak Chauhan Nov 14 '16 at 11:13
  • yes i want save products ids in custom table, which is checked – Nikhil Vaghela Nov 14 '16 at 11:15
  • have you checked what are you getting in data at save method? – Ronak Chauhan Nov 14 '16 at 11:16
1

Save class execute method :

public function execute()
{
    $data = $this->getRequest()->getPostValue();

    if ($data) {
        ...
        ...

        $model->setData($data);
        ...
        ...

        try {
            $model->save();
            $this->saveProducts($model, $data);
            ...
    }
    return $resultRedirect->setPath('*/*/');
}

public function saveProducts($model, $post)
{
    // Attach the attachments to contact
    if (isset($post['products'])) {
        $productIds = $this->_jsHelper->decodeGridSerializedInput($post['products']);
        try {
            $oldProducts = (array) $model->getProducts($model);
            $newProducts = (array) $productIds;

            $this->_resources = \Magento\Framework\App\ObjectManager::getInstance()->get('Magento\Framework\App\ResourceConnection');
            $connection = $this->_resources->getConnection();

            $table = $this->_resources->getTableName(\<namespace\<module_name\Model\ResourceModel\<model_name>::TBL_ATT_PRODUCT);
            $insert = array_diff($newProducts, $oldProducts);
            $delete = array_diff($oldProducts, $newProducts);

            if ($delete) {
                $where = ['id = ?' => (int)$model->getId(), 'product_id IN (?)' => $delete];
                $connection->delete($table, $where);
            }

            if ($insert) {
                $data = [];
                foreach ($insert as $product_id) {
                    $data[] = ['id' => (int)$model->getId(), 'product_id' => (int)$product_id];
                }
                $connection->insertMultiple($table, $data);
            }
        } catch (Exception $e) {
            $this->messageManager->addException($e, __('Something went wrong while saving The Item.'));
        }
    }

}

TBL_ATT_PRODUCT will contain your connectivity with product and your table. Hope it will Help You.

  • ver_dump($data) but data not get – Nikhil Vaghela Nov 14 '16 at 11:27
  • then there is some issue in your form – Ronak Chauhan Nov 14 '16 at 11:28
  • ibnab.com/en/blog/magento-2/… --- follow above step and i got list of product but data not add in form , how to add checkbox checked data in form – Nikhil Vaghela Nov 14 '16 at 11:32
  • Add this column: $this->addColumn( 'in_product', [ 'header_css_class' => 'a-center', 'type' => 'checkbox', 'name' => 'in_product', 'align' => 'center', 'index' => 'entity_id', 'values' => $this->_getSelectedProducts(), ] ); – Ronak Chauhan Nov 14 '16 at 11:34
  • Same thing i was added, but not get in form--- protected function _prepareColumns() { $this->addColumn( 'in_product', [ 'header_css_class' => 'a-center', 'type' => 'checkbox', 'name' => 'in_product', 'align' => 'center', 'index' => 'entity_id', 'values' => $this->_getSelectedProducts(), ] ); – Nikhil Vaghela Nov 14 '16 at 11:37
0

Try this solution. It will add new tab with product grid in magento admin customer section and also save selected product with checkbox into database.

Add Product Grid To Admin

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.