Stockbase-Connect / magento2-module

     * @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 = ? AND s.product_id = ? AND s.ean= ?', $imageName, $productId, $ean);

        $eans = $connection->fetchAll($query);

        return $eans;

    }

    /**

     * @return mixed

    /**

     * @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;

    }

}