How does the \Magento\Rule\Model\Condition\Sql\Builder::_joinTablesToCollection() work?

dmitry_fedyuk · April 7, 2016, 3:04am

magento/magento2/blob/a89acbbfd/app/code/Magento/Rule/Model/Condition/Sql/Builder.php#L90-L110


/**
 * Join tables from conditions combination to collection
 *
 * @param \Magento\Eav\Model\Entity\Collection\AbstractCollection $collection
 * @param Combine $combine
 * @return $this
 */
protected function _joinTablesToCollection(
    \Magento\Eav\Model\Entity\Collection\AbstractCollection $collection,
    Combine $combine
) {
    foreach ($this->_getCombineTablesToJoin($combine) as $alias => $joinTable) {
        /** @var $condition AbstractCondition */
        $collection->getSelect()->joinLeft(
            [$alias => $collection->getResource()->getTable($joinTable['name'])],
            $joinTable['condition'],
            isset($joinTable['columns']) ? $joinTable['columns'] : '*'
        );
    }
    return $this;
}

github.com

magento/magento2/blob/a89acbbfd/app/code/Magento/Rule/Model/Condition/Sql/Builder.php#L54-L64


/**
 * Get tables to join for given conditions combination
 *
 * @param Combine $combine
 * @return array
 */
protected function _getCombineTablesToJoin(Combine $combine)
{
    $tables = $this->_getChildCombineTablesToJoin($combine);
    return $tables;
}

github.com

magento/magento2/blob/a89acbbfd/app/code/Magento/Rule/Model/Condition/Sql/Builder.php#L66-L75


/**
 * Get child for given conditions combination
 *
 * @param Combine $combine
 * @param array $tables
 * @return array
 */
protected function _getChildCombineTablesToJoin(Combine $combine, $tables = [])
{
    foreach ($combine->getConditions() as $condition) {

github.com

magento/magento2/blob/a89acbbfd/app/code/Magento/Rule/Model/Condition/Sql/Builder.php#L76-L80


if ($condition->getConditions()) {
    $tables = $this->_getChildCombineTablesToJoin($condition);
} else {
    /** @var $condition AbstractCondition */
    foreach ($condition->getTablesToJoin() as $alias => $table) {

github.com

magento/magento2/blob/a89acbbfd/app/code/Magento/Rule/Model/Condition/AbstractCondition.php#L173-L181


/**
 * Get tables to join
 *
 * @return array
 */
public function getTablesToJoin()
{
    return [];
}

dmitry_fedyuk · April 7, 2016, 3:04am