Imbo\EventListener\ImageVariations\Database\Doctrine::getBestMatch PHP Method

getBestMatch() public method

public getBestMatch ( $user, $imageIdentifier, $width )
    public function getBestMatch($user, $imageIdentifier, $width)
    {
        $qb = $this->getConnection()->createQueryBuilder();
        $qb->select('width', 'height')->from($this->params['tableName'], 'iv')->where('iv.user = :user')->andWhere('iv.imageIdentifier = :imageIdentifier')->andWhere('iv.width >= :width')->setMaxResults(1)->orderBy('iv.width', 'ASC')->setParameters([':user' => $user, ':imageIdentifier' => $imageIdentifier, ':width' => $width]);
        $stmt = $qb->execute();
        $row = $stmt->fetch(PDO::FETCH_ASSOC);
        return $row ? array_map('intval', $row) : null;
    }