2

I have to pass a FK parameter from GridView Master to GridView Details.

GridView Master (GVM):

enter image description here

GridView Details (GVD): enter image description here

PROBLEM: After click on 'Questions' on GVM for ID = 22, in GVD is showed all details of table (I want show only details linked to parent for ID = 22).

For GVD I have this controller called after click on action 'Questions' (ion method execute I registry the FK):

/app/code/Alkemy/ChatBot/Controller/Adminhtml/QuestionSetFlow/Index.php

<?php

namespace Alkemy\ChatBot\Controller\Adminhtml\QuestionSetFlow;

class Index extends \Alkemy\ChatBot\Controller\Adminhtml\QuestionSetFlow
{
    /**
     * Backend session
     *
     * @var \Magento\Backend\Model\Session
     */
    protected $_backendSession;

    /**
     * Page result factory
     *
     * @var \Magento\Framework\View\Result\PageFactory
     */
    protected $_resultPageFactory;

    /**
     * Page factory
     *
     * @var \Magento\Backend\Model\View\Result\Page
     */
    protected $_resultPage;

    /**
     * QuestionSet ID
     *
     */
    protected $_questionSetId;

    /**
     * constructor
     *
     * @param \Magento\Framework\View\Result\PageFactory $resultPageFactory
     * @param \Magento\Backend\App\Action\Context $context
     */
    public function __construct(
        \Magento\Backend\Model\Session $backendSession,
        \Magento\Framework\View\Result\PageFactory $resultPageFactory,
        \Magento\Framework\Controller\Result\JsonFactory $resultJsonFactory,
        \Alkemy\ChatBot\Model\QuestionSetFlowFactory $questionsetflowFactory,
        \Magento\Framework\Registry $registry,
        \Magento\Backend\Model\View\Result\RedirectFactory $resultRedirectFactory,
        \Magento\Backend\App\Action\Context $context
    )
    {
        $this->_backendSession    = $backendSession;
        $this->_resultPageFactory = $resultPageFactory;
        $this->_resultJsonFactory = $resultJsonFactory;
        parent::__construct($questionsetflowFactory, $registry, $resultRedirectFactory, $context);
    }

    /**
     * execute the action
     *
     * @return \Magento\Backend\Model\View\Result\Page|\Magento\Framework\View\Result\Page
     */
    public function execute()
    {
        //recupero ID of question set
        $id = $this->getRequest()->getParam('questionset_id');
        //Registry Question Set Id selected
        $questionsetId  = (int) $this->getRequest()->getParam('questionset_id');
        $this->_coreRegistry->register('questionset_id', $questionsetId); 
        //$this->saveQuestionSetIdSelected();
        $questionsetFlow = $this->_questionsetFlowFactory->create();
        $questionset = $questionsetFlow->selectQuestionSetById($id);
        if (!isset($questionset) || sizeof($questionset) == 0 ) {
                $this->messageManager->addError(__('This Question set no longer exists.'));
                $resultRedirect = $this->_resultRedirectFactory->create();
                $resultRedirect->setPath('alkemy_chatbot/questionset/index', ['questionset_id' => $id]);
                $this->_questionSetId = $id;
                return $resultRedirect;

        }
//        $qustionSetFlowModel = $this->_objectManager->create('Alkemy\ChatBot\Model\QuestionSetFlow');
//        $qustionSetFlowModel->getCollection()->addFilter('questionset_id', $id);
        $this->_setPageData($questionset);
        return $this->getResultPage();
    }

    /**
     * instantiate result page object
     *
     * @return \Magento\Backend\Model\View\Result\Page|\Magento\Framework\View\Result\Page
     */
    public function getResultPage()
    {
        if (is_null($this->_resultPage)) {
            $this->_resultPage = $this->_resultPageFactory->create();
        }
        return $this->_resultPage;
    }

    /**
     * set page data
     *
     * @return $this
     */
    protected function _setPageData($questionset)
    {
        $resultPage = $this->getResultPage();
        //mostro il nome della Question Set come titolo
        $name = $questionset;
        if (isset($questionset) && is_array($questionset)){
            $temp = array_values($questionset)[0];
            $name = $temp['name'];
        }
        $resultPage->getConfig()->getTitle()->prepend((__($name)));
        return $this;
    }
}

Model for GVD is (in construct I set the FK):

/app/code/Alkemy/ChatBot/Model/QuestionSetFlow.php

<?php

namespace Alkemy\ChatBot\Model;

class QuestionSetFlow extends \Magento\Framework\Model\AbstractModel implements \Alkemy\ChatBot\Api\Data\QuestionSetFlowInterface,
    \Magento\Framework\DataObject\IdentityInterface
{
    const CACHE_TAG = 'alkemy_chatbot_questionsetflow';
    protected $_cacheTag = 'alkemy_chatbot_questionsetflow';
    protected $_eventPrefix = 'alkemy_chatbot_questionsetflow';

    //Id di QuestionSet
    protected $_questionSetId;

    public function __construct(\Magento\Framework\Model\Context $context,
                                \Magento\Framework\Registry $registry,
                                \Magento\Framework\Model\ResourceModel\AbstractResource $resource = null,
                                \Magento\Framework\Data\Collection\AbstractDb $resourceCollection = null,
                                array $data = [])
    {

        array_push($data, $registry->registry('questionset_id'));
        parent::__construct($context, $registry, $resource, $resourceCollection, $data);
        //setto id del padre (FK)
        $this->setFK($registry->registry('questionset_id'));
    }

    /**
     *
     */
    protected function _construct()
    {
        $this->_init('Alkemy\ChatBot\Model\ResourceModel\QuestionSetFlow');
    }

    public function selectQuestionSetById($id)
    {
        return $this->getResource()->selectQuestionSetById($id);
    }

    /**
     * @param $id
     */
    public function setFK($id)
    {
        $this->_questionSetId = $id;
        //call Resource MOdel
        $this->getResource()->setQuestionSetId($id);
    }

}

Resource Model for GVD is:

/app/code/Alkemy/ChatBot/Model/ResourceModel/QuestionSetFlow.php

namespace Alkemy\ChatBot\Model\ResourceModel;

class QuestionSetFlow extends \Magento\Framework\Model\ResourceModel\Db\AbstractDb
{


    protected $_date;

    //FK
    protected $_questionSetId;

    public function __construct(
        \Magento\Framework\Stdlib\DateTime\DateTime $date,
        \Magento\Framework\Model\ResourceModel\Db\Context $context
    )
    {
        $this->_date = $date;
        parent::__construct($context);
    }

    protected function _construct()
    {
        $this->_init('alkemy_chatbot_questionsetflow', 'questionsetflow_id');
    }


    public function selectQuestionSetById($id)
    {
        $dbh = $this->getConnection();
        $tableName = $this->getTable(\Alkemy\ChatBot\Setup\InstallSchema::alkemy_chatbot_questionset);
        $binds = ['id' => (int)$id];
        $select = $dbh->select()->from($tableName)
            ->where('questionset_id = :id')
        ;
        return $dbh->fetchAll($select, $binds);
    }


    public function setQuestionSetId($questionSetId)
    {
        $this->_questionSetId = $questionSetId;
    }

}

Then I have Collection for GVD:

/app/code/Alkemy/ChatBot/Model/ResourceModel/QuestionSetFlow/Collection.php

namespace Alkemy\ChatBot\Model\ResourceModel\QuestionSetFlow;

use Alkemy\ChatBot\Model\QuestionSetFlow;

class Collection extends \Magento\Framework\Model\ResourceModel\Db\Collection\AbstractCollection
{


    protected $_idFieldName = 'questionsetflow_id';

    protected $_eventPrefix = 'alkemy_chatbot_questionsetflow_collection';

    protected $_eventObject = 'questionsetflow_collection';


    protected function _construct()
    {
        $this->_init('Alkemy\ChatBot\Model\QuestionSetFlow', 'Alkemy\ChatBot\Model\ResourceModel\QuestionSetFlow');
    }


    protected function _renderFiltersBefore()
    {
        //find model
        $questionSetFlowModel = $this->_entityFactory->create(QuestionSetFlow::class);
        //fin fk in model
        $fk = $questionSetFlowModel->getFK();
        //set parent (FK) for filter
        $this->addFilter('questionset_id', $fk );
        //view only questions for filter
        $this->addFieldToFilter('question', [['notnull' => true]]);
        parent::_renderFiltersBefore();
    }
}

In DEBUG, I verified that method _renderFiltersBefore is called two time:

FIRST TIME:

$fk = 22
route = alkemy_chatbot
path = /admin/alkemy_chatbot/questionsetflow/index/questionset_id/22/key/7d1db25520ab7012a61f01e9b1b8c8e4b8ec97264003eef8dc41512a80eaa2dd/

SECOND TIME:

 $fk = null
route = mui
path: /admin/mui/index/render/handle/bulk_bulk_details_modal/buttons/1/key/ee8f7151c618aebb613d21b0870ae0d6e8a910d6947ac9e9cdc57ce4c1925e65/

Why? Help me please :(

Your Answer

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

Browse other questions tagged or ask your own question.