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

loadLocationEntries() public method

Loads list of aliases by given $locationId.
public loadLocationEntries ( mixed $locationId, boolean $custom = false, mixed $languageId = false ) : array
$locationId mixed
$custom boolean
$languageId mixed
return array
    public function loadLocationEntries($locationId, $custom = false, $languageId = false)
    {
        /** @var $query \eZ\Publish\Core\Persistence\Database\SelectQuery */
        $query = $this->dbHandler->createSelectQuery();
        $query->select($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'), $this->dbHandler->quoteColumn('text_md5'), $this->dbHandler->quoteColumn('action'))->from($this->dbHandler->quoteTable($this->table))->where($query->expr->lAnd($query->expr->eq($this->dbHandler->quoteColumn('action'), $query->bindValue("eznode:{$locationId}", 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($custom ? 1 : 0, null, \PDO::PARAM_INT))));
        if ($languageId !== false) {
            $query->where($query->expr->gt($query->expr->bitAnd($this->dbHandler->quoteColumn('lang_mask'), $query->bindValue($languageId, null, \PDO::PARAM_INT)), 0));
        }
        $statement = $query->prepare();
        $statement->execute();
        return $statement->fetchAll(\PDO::FETCH_ASSOC);
    }