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(true);
        $oRs = $oDb->Execute( "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(true);
        $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->execute( "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);
        }

        return $sUrl;
    }

    protected function _getSeoUrl($sObjectId, $iLang, $iShopId)
    {
        $oDb = oxDb::getDb(true);
        $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 ) );
                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 );
                oxLang::getInstance()->resetBaseLanguage();
            } elseif ( ( $sRedirectUrl = $this->_decodeOldUrl( $sParams ) ) ) {
                // in case SEO url was changed - redirecting to new location
                oxUtils::getInstance()->redirect( $this->getConfig()->getShopURL().$sRedirectUrl, false );
            } elseif ( ( $sRedirectUrl = $this->_decodeSimpleUrl( $sParams ) ) ) {
                // old type II seo urls
                oxUtils::getInstance()->redirect( $this->getConfig()->getShopURL().$sRedirectUrl, false );
            } else {
                // 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  = oxLang::getInstance()->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 );
        $sField  = "oxseoid".oxLang::getInstance()->getLanguageTag( $iLanguage );
        $sSeoUrl = null;

        // first checking of field exists at all
        if ( $oDb->getOne( "show columns from {$sTable} where field = '{$sField}'" ) ) {
            // if field exists - searching for object id
            if ( $sObjectId = $oDb->getOne( "select oxid from {$sTable} where {$sField} = ".$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 ) ) {
            oxUtils::getInstance()->redirect( $this->getConfig()->getShopURL() . $sParams . '/', false );
        }

        return $sParams;
    }

}