source/Core/SeoEncoder.php
public function fetchSeoUrl($standardUrl, $languageId = null)
    {
        $database = \OxidEsales\Eshop\Core\DatabaseProvider::getDb();
        $languageId = isset($languageId) ? ((int) $languageId) : \OxidEsales\Eshop\Core\Registry::getLang()->getBaseLanguage();

        $shopId = \OxidEsales\Eshop\Core\Registry::getConfig()->getShopId();

        $utilsUrl = \OxidEsales\Eshop\Core\Registry::getUtilsUrl();
        $urlParameters = $utilsUrl->stringToParamsArray($standardUrl);
        $noPageNrStandardUrl = $utilsUrl->cleanUrlParams($utilsUrl->cleanUrl($standardUrl, ['pgNr']));
        $postfix = isset($urlParameters['pgNr']) ? 'pgNr=' . $urlParameters['pgNr'] : '';

        $query = "SELECT `oxseourl` FROM `oxseo` WHERE `oxstdurl` = ? AND `oxlang` = ? AND `oxshopid` = ? LIMIT 1";
        $result = $database->getOne($query, [$noPageNrStandardUrl, $languageId, $shopId]);
        $result = ((false !== $result) && !empty($postfix)) ? $utilsUrl->appendParamSeparator($result) . $postfix : $result;

        return $result;
    }
public function fetchSeoUrl($standardUrl, $languageId = null)
    {
        $database = \OxidEsales\Eshop\Core\DatabaseProvider::getDb();
        $languageId = isset($languageId) ? ((int) $languageId) : \OxidEsales\Eshop\Core\Registry::getLang()->getBaseLanguage();

        $shopId = \OxidEsales\Eshop\Core\Registry::getConfig()->getShopId();

        $utilsUrl = \OxidEsales\Eshop\Core\Registry::getUtilsUrl();
        $urlParameters = $utilsUrl->stringToParamsArray($standardUrl);
        $noPageNrStandardUrl = $utilsUrl->cleanUrlParams($utilsUrl->cleanUrl($standardUrl, ['pgNr']));
        $postfix = isset($urlParameters['pgNr']) ? 'pgNr=' . $urlParameters['pgNr'] : '';

        $query = "SELECT `oxseourl` FROM `oxseo` WHERE `oxstdurl` = ? AND `oxlang` = ? AND `oxshopid` = ? LIMIT 1";
        $result = $database->getOne($query, [$noPageNrStandardUrl, $languageId, $shopId]);
        $result = ((false !== $result) && !empty($postfix)) ? $utilsUrl->appendParamSeparator($result) . $postfix : $result;

        return $result;
    }
public function fetchSeoUrl ( $ standardUrl , $ languageId = null ) { $ database = \ OxidEsales \ Eshop \ Core \ DatabaseProvider :: getDb ( ) ; $ languageId = isset ( $ languageId ) ? ( ( int ) $ languageId ) : \ OxidEsales \ Eshop \ Core \ Registry :: getLang ( ) -> getBaseLanguage ( ) ; $ shopId = \ OxidEsales \ Eshop \ Core \ Registry :: getConfig ( ) -> getShopId ( ) ; $ utilsUrl = \ OxidEsales \ Eshop \ Core \ Registry :: getUtilsUrl ( ) ; $ urlParameters = $ utilsUrl -> stringToParamsArray ( $ standardUrl ) ; $ noPageNrStandardUrl = $ utilsUrl -> cleanUrlParams ( $ utilsUrl -> cleanUrl ( $ standardUrl , [ 'pgNr' ] ) ) ; $ postfix = isset ( $ urlParameters [ 'pgNr' ] ) ? 'pgNr=' . $ urlParameters [ 'pgNr' ] : '' ; $ query = "SELECT `oxseourl` FROM `oxseo` WHERE `oxstdurl` = ? AND `oxlang` = ? AND `oxshopid` = ? LIMIT 1" ; $ result = $ database -> getOne ( $ query , [ $ noPageNrStandardUrl , $ languageId , $ shopId ] ) ; $ result = ( ( false !== $ result ) && ! empty ( $ postfix ) ) ? $ utilsUrl -> appendParamSeparator ( $ result ) . $ postfix : $ result ; return $ result ; }
Searches for seo url in seo table. If not found - FALSE is returned

@param string $standardUrl
@param int    $languageId

@return string|false
Searches for seo url in seo table . If not found - FALSE is returned