Stockbase\Integration\Model\ResourceModel\ProductImage

Complexity

Total Complexity

3

Size/Duplication

Total Lines	46
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	0

Importance

Changes	1
Bugs	0	Features	0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	_construct()	0	4	1
A	imageExists()	0	9	1
A	getProcessedEans()	0	9	1

<?php

namespace Stockbase\Integration\Model\ResourceModel;

/**
 * Class StockItem
 * @package Stockbase\Integration\Model\ResourceModel
 */
class ProductImage extends \Magento\Framework\Model\ResourceModel\Db\AbstractDb
{

    /**
     * @var \Magento\Framework\EntityManager\EntityManager
     */
    protected $entityManager;

    /**
     * Constructor.
     */
    protected function _construct()
    {
        $this->_init('stockbase_product_images', 'id');
    }

    /**
     * @param $imageName
     * @param $productId
     * @param $ean
     * @return mixed
     */
    public function imageExists($imageName, $productId, $ean)
    {
        $connection = $this->getConnection();
        $query = $connection->select()
            ->from(['s' => $this->getMainTable()], ['s.ean'])
            ->where('s.image = \''.$imageName.'\' AND s.product_id = '.$productId.' AND s.ean=\''.$ean.'\'');
        $eans = $connection->fetchAll($query);
        return $eans;
    }

    /**
     * @return mixed
     */
    public function getProcessedEans()
    {
        $connection = $this->getConnection();
        $query = $connection->select()
            ->from(['s' => $this->getMainTable()], ['s.ean'])
            ->group('s.ean');
        $eans = $connection->fetchAll($query);
        return $eans;
    }

}