Server : Apache System : Linux server2.corals.io 4.18.0-348.2.1.el8_5.x86_64 #1 SMP Mon Nov 15 09:17:08 EST 2021 x86_64 User : corals ( 1002) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system Directory :  /home/corals/old/vendor/mageworx/module-seoxtemplates/Model/ResourceModel/Product/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php
/**
 * Copyright © MageWorx. All rights reserved.
 * See LICENSE.txt for license details.
 */

namespace MageWorx\SeoXTemplates\Model\ResourceModel\Product;

use Magento\Store\Model\Store;

class Gallery extends \Magento\Catalog\Model\ResourceModel\Product\Gallery
{
    /**
     * Store manager
     *
     * @var \Magento\Store\Model\StoreManagerInterface
     */
    protected $storeManager;

    /**
     * Gallery constructor.
     *
     * @param \Magento\Framework\Model\ResourceModel\Db\Context $context
     * @param \Magento\Framework\EntityManager\MetadataPool $metadataPool
     * @param \Magento\Store\Model\StoreManagerInterface $singleStoreMode
     * @param string|null $connectionName
     */
    public function __construct(
        \Magento\Framework\Model\ResourceModel\Db\Context $context,
        \Magento\Framework\EntityManager\MetadataPool $metadataPool,
        \Magento\Store\Model\StoreManagerInterface $storeManager,
        string $connectionName = null
    ) {
        $this->storeManager = $storeManager;
        parent::__construct($context, $metadataPool, $connectionName);
    }


    /**
     * @param int $storeId
     * @param int $attributeId
     * @return \Magento\Framework\DB\Select
     * @throws \Magento\Framework\Exception\LocalizedException
     */
    public function createImageBatchBaseSelect($storeId, $attributeId)
    {
        $linkField      = $this->metadata->getLinkField();
        $mainTableAlias = $this->getMainTableAlias();

        $select = $this->getConnection()->select()->from(
            [$mainTableAlias => $this->getMainTable()],
            [
                'value_id',
                'file' => 'value',
                'media_type'
            ]
        )->joinInner(
            ['entity' => $this->getTable(self::GALLERY_VALUE_TO_ENTITY_TABLE)],
            $mainTableAlias . '.value_id = entity.value_id',
            [$linkField]
        )->joinLeft(
            ['value' => $this->getTable(self::GALLERY_VALUE_TABLE)],
            implode(
                ' AND ',
                [
                    $mainTableAlias . '.value_id = value.value_id',
                    $this->getConnection()->quoteInto('value.store_id = ?', (int)$storeId),
                ]
            ),
            ['label', 'position', 'disabled']
        )->joinLeft(
            ['default_value' => $this->getTable(self::GALLERY_VALUE_TABLE)],
            implode(
                ' AND ',
                [
                    $mainTableAlias . '.value_id = default_value.value_id',
                    $this->getConnection()->quoteInto('default_value.store_id = ?', Store::DEFAULT_STORE_ID),
                ]
            ),
            ['label_default' => 'label', 'position_default' => 'position', 'disabled_default' => 'disabled']
        )->where(
            $mainTableAlias . '.attribute_id = ?',
            $attributeId
        )->order(
            'entity.' . $linkField,
            'entity.value_id'
        );

        return $select;
    }

    /**
     * Add filter to product collection - products which has image(s) without image label on store level
     *
     * @param \Magento\Catalog\Model\ResourceModel\Product\Collection $collection
     * @throws \Magento\Framework\Exception\LocalizedException
     */
    public function addEmptyLabelFilter($collection)
    {
        /** @var $attribute \Magento\Catalog\Model\ResourceModel\Eav\Attribute */
        $attribute = $collection->getAttribute('media_gallery');

        $linkField = $this->metadata->getLinkField();

        $mainTableAlias = 'gallery';

        $collection->getSelect()
                   ->joinInner(
                       ['value_to_entity' => $this->getTable(self::GALLERY_VALUE_TO_ENTITY_TABLE)],
                       'value_to_entity.' . $linkField . ' = e.' . $linkField,
                       []
                   )
                   ->joinLeft(
                       [$mainTableAlias => $this->getMainTable()],
                       'gallery.value_id = value_to_entity.value_id',
                       []
                   )
                   ->joinLeft(
                       ['value' => $this->getTable(self::GALLERY_VALUE_TABLE)],
                       implode(
                           ' AND ',
                           [
                               $mainTableAlias . '.value_id = value.value_id',
                               $this->getConnection()->quoteInto(
                                   'value.store_id = ?',
                                   (int)$collection->getStoreId()
                               ),
                           ]
                       ),
                       ['label', 'position', 'disabled']
                   )
                   ->joinLeft(
                       ['default_value' => $this->getTable(self::GALLERY_VALUE_TABLE)],
                       implode(
                           ' AND ',
                           [
                               $mainTableAlias . '.value_id = default_value.value_id',
                               $this->getConnection()->quoteInto(
                                   'default_value.store_id = ?',
                                   Store::DEFAULT_STORE_ID
                               ),
                           ]
                       ),
                       ['label_default' => 'label', 'position_default' => 'position', 'disabled_default' => 'disabled']
                   )
                   ->where(
                       $mainTableAlias . '.attribute_id = ?',
                       $attribute->getAttributeId()
                   )

                   ->where("value.label IS NULL OR value.label = ''")
                   ->group('e.' . $linkField);

        if ($this->storeManager->isSingleStoreMode()) {
            $collection->getSelect()->where("default_value.label IS NULL OR default_value.label = ''");
        } else {
            $collection->getSelect()->where("value.label IS NULL OR value.label = ''");
        }

        $collection->getSelect()->group('e.' . $linkField);
    }

}