eZ\Publish\Core\Persistence\Legacy\Content\UrlAlias\Gateway\DoctrineDatabase::listGlobalEntries PHP Method

listGlobalEntries() public method

Loads paged list of global aliases.
public listGlobalEntries ( string | null $languageCode = null, integer $offset, integer $limit ) : array
$languageCode string | null
$offset integer
$limit integer
return array
    public function listGlobalEntries($languageCode = null, $offset = 0, $limit = -1)
    {
        $limit = $limit === -1 ? self::MAX_LIMIT : $limit;
        /** @var $query \eZ\Publish\Core\Persistence\Database\SelectQuery */
        $query = $this->dbHandler->createSelectQuery();
        $query->select($this->dbHandler->quoteColumn('action'), $this->dbHandler->quoteColumn('id'), $this->dbHandler->quoteColumn('link'), $this->dbHandler->quoteColumn('is_alias'), $this->dbHandler->quoteColumn('alias_redirects'), $this->dbHandler->quoteColumn('lang_mask'), $this->dbHandler->quoteColumn('is_original'), $this->dbHandler->quoteColumn('parent'), $this->dbHandler->quoteColumn('text_md5'))->from($this->dbHandler->quoteTable($this->table))->where($query->expr->lAnd($query->expr->eq($this->dbHandler->quoteColumn('action_type'), $query->bindValue('module', null, \PDO::PARAM_STR)), $query->expr->eq($this->dbHandler->quoteColumn('is_original'), $query->bindValue(1, null, \PDO::PARAM_INT)), $query->expr->eq($this->dbHandler->quoteColumn('is_alias'), $query->bindValue(1, null, \PDO::PARAM_INT))))->limit($limit, $offset);
        if (isset($languageCode)) {
            $query->where($query->expr->gt($query->expr->bitAnd($this->dbHandler->quoteColumn('lang_mask'), $query->bindValue($this->languageMaskGenerator->generateLanguageIndicator($languageCode, false), null, \PDO::PARAM_INT)), 0));
        }
        $statement = $query->prepare();
        $statement->execute();
        return $statement->fetchAll(\PDO::FETCH_ASSOC);
    }