/** * Add JOIN to warehouse data to calculate qty. * * @param \Magento\Catalog\Model\ResourceModel\Product\Collection $subject * @param \Closure $proceed * @return \Magento\Framework\DB\Select */ public function aroundGetSelectCountSql(\Magento\Catalog\Model\ResourceModel\Product\Collection $subject, \Closure $proceed) { /** @var \Magento\Framework\DB\Select $result */ $result = $proceed(); $this->_queryModGrid->modifySelect($result); return $result; }
/** * @param Subject $subject * @param \Closure $proceed * @param \Magento\Catalog\Model\ResourceModel\Product\Collection $collection * @param $field * @param null $alias * @throws \Magento\Framework\Exception\LocalizedException */ public function aroundAddField(Subject $subject, \Closure $proceed, \Magento\Catalog\Model\ResourceModel\Product\Collection $collection) { $select = $collection->getSelect(); $this->_queryModGrid->modifySelect($select); return; }