oxseodecoder.php

Go to the documentation of this file.

<?php

class oxSeoDecoder extends oxSuperCfg
{

    public function parseStdUrl($sUrl)
    {
        $oStr = getStr();
        $aRet = array();
        $sUrl = $oStr->html_entity_decode($sUrl);

        if (($iPos = strpos($sUrl, '?')) !== false) {
            parse_str($oStr->substr($sUrl, $iPos + 1), $aRet);
        }

        return $aRet;
    }

    protected function _getIdent($sSeoUrl, $blIgnore = false)
    {
        return md5(strtolower($sSeoUrl));
    }

    public function decodeUrl($sSeoUrl)
    {
        $oStr = getStr();
        $sBaseUrl = $this->getConfig()->getShopURL();
        if ($oStr->strpos($sSeoUrl, $sBaseUrl) === 0) {
            $sSeoUrl = $oStr->substr($sSeoUrl, $oStr->strlen($sBaseUrl));
        }
        $sSeoUrl = rawurldecode($sSeoUrl);
        $iShopId = $this->getConfig()->getShopId();

        $sKey = $this->_getIdent($sSeoUrl);
        $aRet = false;

        $oDb = oxDb::getDb(oxDb::FETCH_MODE_ASSOC);
        $oRs = $oDb->select("select oxstdurl, oxlang from oxseo where oxident=" . $oDb->quote($sKey) . " and oxshopid='$iShopId' limit 1");
        if (!$oRs->EOF) {
            // primary seo language changed ?
            $aRet = $this->parseStdUrl($oRs->fields['oxstdurl']);
            $aRet['lang'] = $oRs->fields['oxlang'];
        }

        return $aRet;
    }

    protected function _decodeOldUrl($sSeoUrl)
    {
        $oStr = getStr();
        $oDb = oxDb::getDb(oxDb::FETCH_MODE_ASSOC);
        $sBaseUrl = $this->getConfig()->getShopURL();
        if ($oStr->strpos($sSeoUrl, $sBaseUrl) === 0) {
            $sSeoUrl = $oStr->substr($sSeoUrl, $oStr->strlen($sBaseUrl));
        }
        $iShopId = $this->getConfig()->getShopId();
        $sSeoUrl = rawurldecode($sSeoUrl);

        $sKey = $this->_getIdent($sSeoUrl, true);

        $sUrl = false;
        $oRs = $oDb->select("select oxobjectid, oxlang from oxseohistory where oxident = " . $oDb->quote($sKey) . " and oxshopid = '{$iShopId}' limit 1");
        if (!$oRs->EOF) {
            // updating hit info (oxtimestamp field will be updated automatically)
            $oDb->execute("update oxseohistory set oxhits = oxhits + 1 where oxident = " . $oDb->quote($sKey) . " and oxshopid = '{$iShopId}' limit 1");

            // fetching new url
            $sUrl = $this->_getSeoUrl($oRs->fields['oxobjectid'], $oRs->fields['oxlang'], $iShopId);

            // appending with $_SERVER["QUERY_STRING"]
            $sUrl = $this->_addQueryString($sUrl);
        }

        return $sUrl;
    }

    protected function _addQueryString($sUrl)
    {
        if (($sQ = $_SERVER["QUERY_STRING"])) {
            $sUrl = rtrim($sUrl, "&?");
            $sQ = ltrim($sQ, "&?");

            $sUrl .= (strpos($sUrl, '?') === false) ? "?" : "&";
            $sUrl .= $sQ;
        }

        return $sUrl;
    }

    protected function _getSeoUrl($sObjectId, $iLang, $iShopId)
    {
        $oDb = oxDb::getDb(oxDb::FETCH_MODE_ASSOC);
        $aInfo = $oDb->getRow("select oxseourl, oxtype from oxseo where oxobjectid =  " . $oDb->quote($sObjectId) . " and oxlang =  " . $oDb->quote($iLang) . " and oxshopid = " . $oDb->quote($iShopId) . " order by oxparams limit 1");
        if ('oxarticle' == $aInfo['oxtype']) {
            $sMainCatId = $oDb->getOne("select oxcatnid from " . getViewName("oxobject2category") . " where oxobjectid = " . $oDb->quote($sObjectId) . " order by oxtime");
            if ($sMainCatId) {
                $sUrl = $oDb->getOne("select oxseourl from oxseo where oxobjectid =  " . $oDb->quote($sObjectId) . " and oxlang =  " . $oDb->quote($iLang) . " and oxshopid = " . $oDb->quote($iShopId) . " and oxparams = " . $oDb->quote($sMainCatId) . "  order by oxexpired");
                if ($sUrl) {
                    return $sUrl;
                }
            }
        }

        return $aInfo['oxseourl'];
    }

    public function processSeoCall($sRequest = null, $sPath = null)
    {
        // first - collect needed parameters
        if (!$sRequest) {
            if (isset($_SERVER['REQUEST_URI']) && $_SERVER['REQUEST_URI']) {
                $sRequest = $_SERVER['REQUEST_URI'];
            } else {
                // try something else
                $sRequest = $_SERVER['SCRIPT_URI'];
            }
        }

        $sPath = $sPath ? $sPath : str_replace('oxseo.php', '', $_SERVER['SCRIPT_NAME']);
        if (($sParams = $this->_getParams($sRequest, $sPath))) {

            // in case SEO url is actual
            if (is_array($aGet = $this->decodeUrl($sParams))) {
                $_GET = array_merge($aGet, $_GET);
                oxRegistry::getLang()->resetBaseLanguage();
            } elseif (($sRedirectUrl = $this->_decodeOldUrl($sParams))) {
                // in case SEO url was changed - redirecting to new location
                oxRegistry::getUtils()->redirect($this->getConfig()->getShopURL() . $sRedirectUrl, false);
            } elseif (($sRedirectUrl = $this->_decodeSimpleUrl($sParams))) {
                // old type II seo urls
                oxRegistry::getUtils()->redirect($this->getConfig()->getShopURL() . $sRedirectUrl, false);
            } else {
                oxRegistry::getSession()->start();
                // unrecognized url
                error_404_handler($sParams);
            }
        }
    }

    protected function _decodeSimpleUrl($sParams)
    {
        $oStr = getStr();
        $sLastParam = rtrim($sParams, '/');
        $sLastParam = $oStr->substr($sLastParam, (( int ) strrpos($sLastParam, '/')) - ($oStr->strlen($sLastParam)));
        $sLastParam = trim($sParams, '/');

        // active object id
        $sUrl = null;

        if ($sLastParam) {

            $iLanguage = oxRegistry::getLang()->getBaseLanguage();

            // article ?
            if (strpos($sLastParam, '.htm') !== false) {
                $sUrl = $this->_getObjectUrl($sLastParam, 'oxarticles', $iLanguage, 'oxarticle');
            } else {

                // category ?
                if (!($sUrl = $this->_getObjectUrl($sLastParam, 'oxcategories', $iLanguage, 'oxcategory'))) {
                    // maybe manufacturer ?
                    if (!($sUrl = $this->_getObjectUrl($sLastParam, 'oxmanufacturers', $iLanguage, 'oxmanufacturer'))) {
                        // then maybe vendor ?
                        $sUrl = $this->_getObjectUrl($sLastParam, 'oxvendor', $iLanguage, 'oxvendor');
                    }
                }
            }
        }

        return $sUrl;
    }

    protected function _getObjectUrl($sSeoId, $sTable, $iLanguage, $sType)
    {
        $oDb = oxDb::getDb();
        $sTable = getViewName($sTable, $iLanguage);
        $sSeoUrl = null;

        // first checking of field exists at all
        if ($oDb->getOne("show columns from {$sTable} where field = 'oxseoid'")) {
            // if field exists - searching for object id
            if ($sObjectId = $oDb->getOne("select oxid from {$sTable} where oxseoid = " . $oDb->quote($sSeoId))) {
                $sSeoUrl = $oDb->getOne("select oxseourl from oxseo where oxtype = " . $oDb->quote($sType) . " and oxobjectid = " . $oDb->quote($sObjectId) . " and oxlang = " . $oDb->quote($iLanguage) . " ");
            }
        }

        return $sSeoUrl;
    }

    protected function _getParams($sRequest, $sPath)
    {
        $oStr = getStr();

        $sParams = $oStr->preg_replace('/\?.*/', '', $sRequest);
        $sPath = preg_quote($sPath, '/');
        $sParams = $oStr->preg_replace("/^$sPath/", '', $sParams);

        // this should not happen on most cases, because this redirect is handled by .htaccess
        if ($sParams && !$oStr->preg_match('/\.html$/', $sParams) && !$oStr->preg_match('/\/$/', $sParams)) {
            oxRegistry::getUtils()->redirect($this->getConfig()->getShopURL() . $sParams . '/', false);
        }

        return $sParams;
    }
}