Gsyfuy

I'm doing "Banner Sliders" module in magento 2.2.5, so i'm using module-catalog as example to do that.

You can see that in Admin page->Catalog->Category->Products In Category and you will see something like this:

So what i'm doing is almost exactly like that.

Here is what i've done til now.

But my search and filter doesn't work at all.

When ever i click on "Search" and "Reset Filter" button, it throw this error:

So i want to know how this search work, so i can fix this. Because i'm kinda new to magento.

Here is my code:

C:xampphtdocsmagentoappcodeAhtBannerSliderBlockAdminhtmlBannerTabSlide.php (This file is after module-catalogBlockAdminhtmlCategoryTabProduct.php)

<?php

/**

 * Copyright © Magento, Inc. All rights reserved.

 * See COPYING.txt for license details.

 */



/**

 * Slide in banner grid

 *

 * @author      Magento Core Team <core@magentocommerce.com>

 */

namespace AhtBannerSliderBlockAdminhtmlBannerTab;



use MagentoBackendBlockWidgetGrid;

use MagentoBackendBlockWidgetGridColumn;

use MagentoBackendBlockWidgetGridExtended;



class Slide extends MagentoBackendBlockWidgetGridExtended

{

    /**

     * Core registry

     *

     * @var MagentoFrameworkRegistry

     */

    protected $_coreRegistry = null;



    /**

     * @var AhtBannerSliderModelSlideFactory

     */

    protected $_slideFactory;



    public function __construct(

        MagentoBackendBlockTemplateContext $context,

        MagentoBackendHelperData $backendHelper,

        AhtBannerSliderModelSlideFactory $slideFactory,

        MagentoFrameworkRegistry $coreRegistry,

        array $data = []

    ) {

        $this->_slideFactory = $slideFactory;

        $this->_coreRegistry = $coreRegistry;

        parent::__construct($context, $backendHelper, $data);

    }



    /**

     * @return void

     */

    protected function _construct()

    {

        parent::_construct();

        $this->setId('banner_slider_banner_slide');

        $this->setDefaultSort('id');

        $this->setUseAjax(true);

    }



    /**

     * @return array|null

     */

    public function getBanner()

    {

        return $this->_coreRegistry->registry('banner');

    }



    /**

     * @param Column $column

     * @return $this

     */

    protected function _addColumnFilterToCollection($column)

    {

//        // Set custom filter for in category flag

//        if ($column->getId() == 'in_banner') {

//            $slideIds = $this->_getSelectedSlide();

//            if (empty($slideIds)) {

//                $slideIds = 0;

//            }

//            if ($column->getFilter()->getValue()) {

//                $this->getCollection()->addFieldToFilter('main_table.id', ['in' => $slideIds]);

//            } elseif (!empty($slideIds)) {

//                $this->getCollection()->addFieldToFilter('main_table.id', ['nin' => $slideIds]);

//            }

//        } else {

//            parent::_addColumnFilterToCollection($column);

//        }

        return $this;

    }



    /**

     * @return Grid

     */

    protected function _prepareCollection()

    {

        $collection = $this->_slideFactory->create()->getCollection();

//            ->addFieldToSelect(array('id', 'name', 'image'));



        if ($this->getBanner()->getId()) {

            $this->setDefaultFilter(['in_banner' => 1]);



//            main_table được lấy tự động.

            $collection->getSelect()

                ->joinInner(['banner_slide' => 'banner_slide'], 'main_table.id = banner_slide.slide_id', ['banner_slide_id' => 'banner_slide.id'])

                ->where('banner_id = ?', $this->getBanner()->getId());

//            hiển thị câu lệnh sql:

//            echo $collection->getSelect();die();

        }





        $this->setCollection($collection);



        return parent::_prepareCollection();

    }



    /**

     * @return Extended

     */

    protected function _prepareColumns()

    {

        $this->addColumn(

            'in_banner',

            [

                'type' => 'checkbox',

                'name' => 'in_banner',

                'values' => $this->_getSelectedSlide(),

                'index' => 'id',

                'header_css_class' => 'col-select col-massaction',

                'column_css_class' => 'col-select col-massaction'

            ]

        );

        $this->addColumn(

            'id',

            [

                'header' => __('ID'),

                'sortable' => true,

                'index' => 'id',

                'header_css_class' => 'col-id',

                'column_css_class' => 'col-id'

            ]

        );

        $this->addColumn('name', ['header' => __('Name'), 'index' => 'name']);

        $this->addColumn('url', ['header' => __('URL'), 'index' => 'url']);

        $this->addColumn('image', ['header' => __('Image'), 'index' => 'image']);

        $this->addColumn('created_at', ['header' => __('Created Time'), 'index' => 'created_at']);

        $this->addColumn('updated_at', ['header' => __('Last Update'), 'index' => 'updated_at']);



        return parent::_prepareColumns();

    }



    /**

     * @return string

     */

//    public function getGridUrl()

//    {

//        return $this->getUrl('*/*/grid', ['_current' => true]);

//    }



    /**

     * @return array

     */

    protected function _getSelectedSlide()

    {

        $slide = $this->getRequest()->getPost('selected_slide');

        return $slide;

    }

}

I've 3 table.

1. Banner

2. Slide

3. Banner_Slide