Helper.php

Go to the documentation of this file.

<?php
namespace Magento\Eav\Model\ResourceModel;

class Helper extends \Magento\Framework\DB\Helper
{
    public function __construct(\Magento\Framework\App\ResourceConnection $resource, $modulePrefix = 'Magento_Eav')
    {
        parent::__construct($resource, $modulePrefix);
    }

    protected $_ddlColumnTypes = [
        \Magento\Framework\DB\Ddl\Table::TYPE_BOOLEAN => 'bool',
        \Magento\Framework\DB\Ddl\Table::TYPE_SMALLINT => 'smallint',
        \Magento\Framework\DB\Ddl\Table::TYPE_INTEGER => 'int',
        \Magento\Framework\DB\Ddl\Table::TYPE_BIGINT => 'bigint',
        \Magento\Framework\DB\Ddl\Table::TYPE_FLOAT => 'float',
        \Magento\Framework\DB\Ddl\Table::TYPE_DECIMAL => 'decimal',
        \Magento\Framework\DB\Ddl\Table::TYPE_NUMERIC => 'decimal',
        \Magento\Framework\DB\Ddl\Table::TYPE_DATE => 'date',
        \Magento\Framework\DB\Ddl\Table::TYPE_TIMESTAMP => 'timestamp',
        \Magento\Framework\DB\Ddl\Table::TYPE_DATETIME => 'datetime',
        \Magento\Framework\DB\Ddl\Table::TYPE_TEXT => 'text',
        \Magento\Framework\DB\Ddl\Table::TYPE_BLOB => 'blob',
        \Magento\Framework\DB\Ddl\Table::TYPE_VARBINARY => 'blob',
    ];

    private $_groupableTypes = ['varchar', 'text', 'decimal', 'datetime', 'int'];

    public function getDdlTypeByColumnType($columnType)
    {
        switch ($columnType) {
            case 'char':
            case 'varchar':
                $columnType = 'text';
                break;
            case 'tinyint':
                $columnType = 'smallint';
                break;
            default:
                break;
        }

        return array_search($columnType, $this->_ddlColumnTypes);
    }

    public function getLoadAttributesSelectGroups($selects)
    {
        $mainGroup = [];

        foreach ($selects as $dataType => $selectGroup) {
            if (in_array($dataType, $this->_groupableTypes)) {
                $mainGroup['all'][] = $selectGroup;
                continue;
            }

            $mainGroup[$dataType] = $selectGroup;
        }

        if (array_key_exists('all', $mainGroup)) {
            // it is better to call array_merge once after loop instead of calling it on each loop
            $mainGroup['all'] = array_merge(...$mainGroup['all']);
        }

        return array_values($mainGroup);
    }
}