article_seo.php

Go to the documentation of this file.

<?php

class Article_Seo extends Object_Seo
{
    protected $_sActCatId = null;

    protected $_sActCatType = null;

    protected $_iActCatLang = null;

    protected $_oArtCategories = null;

    protected $_oArtVendors = null;

    protected $_oArtManufacturers = null;

    protected $_oArticle = null;

    protected $_sNoCategoryId = '__nonecatid';

    public function render()
    {
        $oArticle = $this->_getObject( oxConfig::getParameter( 'oxid' ) );

        $this->_aViewData["edit"] = $oArticle;
        $this->_aViewData["blShowCatSelect"] = true;
        $this->_aViewData["oCategories"]     = $this->_getCategoryList( $oArticle );
        $this->_aViewData["oVendors"]        = $this->_getVendorList( $oArticle );
        $this->_aViewData["oManufacturers"]  = $this->_getManufacturerList( $oArticle );
        $this->_aViewData["oTags"]           = $this->_getTagList( $oArticle );
        $this->_aViewData["sCatId"]          = $this->getSelectedCategoryId();
        $this->_aViewData["sCatType"]        = $this->getActCatType();
        $this->_aViewData["sCatLang"]        = $this->getActCategoryLang();

        return parent::render();
    }

    protected function _getSeoDataSql( $oObject, $iShopId, $iLang )
    {
        $oDb = oxDb::getDb();
        if ( $this->getActCatType() == 'oxtag' ) {
            $sObjectId = $this->_getEncoder()->getDynamicObjectId( $iShopId, $oObject->getStdTagLink( $this->getTag() ) );
            $sQ = "select * from oxseo
                   left join oxobject2seodata on
                       oxobject2seodata.oxobjectid = ".$oDb->quote( $oObject->getId() ) . " and
                       oxobject2seodata.oxshopid = oxseo.oxshopid and
                       oxobject2seodata.oxlang = oxseo.oxlang
                   where
                       oxseo.oxobjectid = ".$oDb->quote( $sObjectId ) ."
                       and oxseo.oxshopid = '{$iShopId}' and oxseo.oxlang = ".$this->getActCategoryLang();
        } else {
            $sParam = ( $sCat = $this->getSelectedCategoryId() ) ? " and oxseo.oxparams = '$sCat' " : '';
            $sQ = "select * from oxseo
                   left join oxobject2seodata on
                       oxobject2seodata.oxobjectid = oxseo.oxobjectid and
                       oxobject2seodata.oxshopid = oxseo.oxshopid and
                       oxobject2seodata.oxlang = oxseo.oxlang
                    where oxseo.oxobjectid = ".$oDb->quote( $oObject->getId() ) . "
                    and oxseo.oxshopid = '{$iShopId}' and oxseo.oxlang = {$iLang} {$sParam} ";
        }
        return $sQ;
    }

    protected function _getCategoryList( $oArticle )
    {
        if ( $this->_oArtCategories === null && $oArticle ) {
            // adding categories
            $sO2CView = getViewName( 'oxobject2category');
            $oDb = oxDb::getDb( true );
            $sQ = "select oxobject2category.oxcatnid as oxid from $sO2CView as oxobject2category where oxobject2category.oxobjectid="
                  . $oDb->quote( $oArticle->getId() ) . " union ".$oArticle->getSqlForPriceCategories('oxid');

            $iLang = $this->getEditLang();
            $this->_oArtCategories = oxNew( "oxList" );
            $rs = $oDb->execute( $sQ );
            if ( $rs != false && $rs->recordCount() > 0 ) {
                while ( !$rs->EOF ) {
                    $oCat = oxNew('oxcategory');
                    $oCat->setLanguage( $iLang );
                    if ( $oCat->load( current( $rs->fields ) ) ) {
                        $this->_oArtCategories->offsetSet( $oCat->getId(), $oCat );
                    }
                    $rs->moveNext();
                }
            }

            $this->_setMainCategory( $oArticle, $this->_oArtCategories);
        }

        return $this->_oArtCategories;
    }

    protected function _setMainCategory( $oProduct, $oCatList )
    {
        // loading main category
        if ( !( $oMainCat = $oProduct->getCategory() ) ) {
            $sTitle = oxLang::getInstance()->translateString( '(no category)', $this->_iEditLang );
            $oMainCat = oxNew( "oxCategory" );
            $oMainCat->setId( $this->_sNoCategoryId );
            $oMainCat->oxcategories__oxtitle = new oxField( $sTitle, oxField::T_RAW );
        }

        $sSuffix = oxLang::getInstance()->translateString( '(main category)', $this->_iEditLang );
        $oMainCat->oxcategories__oxtitle = new oxField( $oMainCat->oxcategories__oxtitle->getRawValue()." ".$sSuffix, oxField::T_RAW );

        // overriding
        $oCatList->offsetSet( $oMainCat->getId(), $oMainCat );
    }

    protected function _getVendorList( $oArticle )
    {
        if ( $this->_oArtVendors === null ) {
            $this->_oArtVendors = false;

            if ( $oArticle->oxarticles__oxvendorid->value ) {
                $oVendor = oxNew( 'oxvendor' );
                if ( $oVendor->loadInLang( $this->_iEditLang, $oArticle->oxarticles__oxvendorid->value ) ) {
                    $this->_oArtVendors = oxNew( 'oxList', 'oxvendor' );
                    $this->_oArtVendors[] = $oVendor;
                }
            }
        }
        return $this->_oArtVendors;
    }

    protected function _getManufacturerList( $oArticle )
    {
        if ( $this->_oArtManufacturers === null ) {
            $this->_oArtManufacturers = false;

            if ( $oArticle->oxarticles__oxmanufacturerid->value ) {
                $oManufacturer = oxNew( 'oxmanufacturer' );
                if ( $oManufacturer->loadInLang( $this->_iEditLang, $oArticle->oxarticles__oxmanufacturerid->value ) ) {
                    $this->_oArtManufacturers = oxNew( 'oxList', 'oxmanufacturer' );
                    $this->_oArtManufacturers[] = $oManufacturer;
                }
            }
        }
        return $this->_oArtManufacturers;
    }

    protected function _getTagList( $oArticle )
    {
        $oTagCloud = oxNew("oxTagCloud");
        $aLangs = $oArticle ? $oArticle->getAvailableInLangs() : array();

        $aLangTags = array();
        foreach ( $aLangs as $iLang => $sLangTitle ) {
            if ( count( $aTags = $oTagCloud->getTags( $oArticle->getId(), false, $iLang ) ) ) {
                $aLangTags[$iLang] = array();
                foreach ($aTags as $sTitle => $sValue) {
                    $aLangTags[$iLang][$oTagCloud->getTagTitle($sTitle)] = $sValue;
                }
            }
        }

        return $aLangTags;
    }

    public function getSelectedCategoryId()
    {
        if ( $this->_sActCatId === null) {
            $this->_sActCatId   = false;
            $this->_sActCatType = false;

            $aSeoData = oxConfig::getParameter( 'aSeoData' );
            if ( $aSeoData && isset( $aSeoData['oxparams'] ) ) {
                if ( $sData = $aSeoData['oxparams'] ) {
                    $this->_sActCatId = substr( $sData, strpos( $sData, '#' ) + 1 );
                    if ( strpos( $this->_sActCatId, '#' ) !== false ) {
                        $this->_sActCatId = substr( $this->_sActCatId, 0, strpos( $this->_sActCatId, '#' ) );
                    }
                    $this->_iActCatLang = substr( $sData, strrpos( $sData, '#' ) + 1 );
                    $this->_sActCatType = substr( $sData, 0, strpos( $sData, '#' ) );
                }
            } else {
                $oArticle = $this->_getObject( oxConfig::getParameter( 'oxid' ) );
                if ( ( $oList = $this->_getCategoryList( $oArticle ) ) && $oList->count() ) {
                    $this->_sActCatType = 'oxcategories';
                    $this->_sActCatId   = $oList->current()->getId();
                } elseif ( ( $oList = $this->_getVendorList( $oArticle ) ) && $oList->count() ) {
                    $this->_sActCatType = 'oxvendor';
                    $this->_sActCatId   = $oList->current()->getId();
                } elseif ( ( $oList = $this->_getManufacturerList( $oArticle ) ) && $oList->count() ) {
                    $this->_sActCatType = 'oxmanufacturer';
                    $this->_sActCatId   = $oList->current()->getId();
                } elseif ( ( $aTagList = $this->_getTagList( $oArticle ) ) && count( $aTagList ) ) {
                    $this->_sActCatType = 'oxtag';
                    $this->_sActCatId   = key( $aTagList );
                }
            }
        }

        return $this->_sActCatId;
    }

    protected function _getSeoUrl( $oArticle )
    {
        // setting cat type and id ..
        $this->getSelectedCategoryId();

        // choosing type
        switch ( $this->getActCatType() ) {
            case 'oxvendor':
                $sType = OXARTICLE_LINKTYPE_VENDOR;
                break;
            case 'oxmanufacturer':
                $sType = OXARTICLE_LINKTYPE_MANUFACTURER;
                break;
            case 'oxtag':
                $sType = OXARTICLE_LINKTYPE_TAG;
                break;
            default:
                $sType = OXARTICLE_LINKTYPE_CATEGORY;
                $oCat = oxNew( 'oxcategory' );
                $oCat->load( $this->_sActCatId );
                if ( $oCat->isPriceCategory() ) {
                    $sType = OXARTICLE_LINKTYPE_PRICECATEGORY;
                }
                break;
        }

        $this->_getEncoder()->getArticleUrl( $oArticle, $this->getEditLang(), $sType );
        return parent::_getSeoUrl( $oArticle );
    }

    public function getActCategory()
    {
        $oCat = oxNew( 'oxcategory' );
        return ( $oCat->load( $this->_sActCatId ) ) ? $oCat : null;
    }

    public function getTag()
    {
        $sTag = $this->getSelectedCategoryId();
        return ( $this->getActCatType() == 'oxtag' ) ? $sTag : null;
    }

    public function getActVendor()
    {
        $oVendor = oxNew( 'oxvendor' );
        return ( $this->getActCatType() == 'oxvendor' && $oVendor->load( $this->_sActCatId ) ) ? $oVendor : null;
    }

    public function getActManufacturer()
    {
        $oManufacturer = oxNew( 'oxmanufacturer' );
        return ( $this->getActCatType() == 'oxmanufacturer' && $oManufacturer->load( $this->_sActCatId ) ) ? $oManufacturer : null;
    }

    public function getListType()
    {
        $sListType = '';
        switch ( $this->getActCatType() ) {
            case 'oxvendor':
                $sListType = 'vendor';
                break;
            case 'oxmanufacturer':
                $sListType = 'manufacturer';
                break;
            case 'oxtag':
                $sListType = 'tag';
                break;
            default:
                break;
        }
        return $sListType;
    }

    protected function _getSeoUrlQuery( $oObject, $iShopId )
    {
        $oDb = oxDb::getDb();

         // tag type urls are loaded differently from others..
        if ( ( $sTag = $this->getTag() ) ) {

            $sStdUrl = "index.php?cl=details&amp;anid=".$oObject->getId()."&amp;listtype=tag&amp;searchtag=".rawurlencode( $sTag );
            $sObjectId = md5( strtolower( $oObject->getShopId() . $sStdUrl ) );
            $sQ = "select oxseourl from oxseo where oxobjectid = ".$oDb->quote( $sObjectId ).
                  " and oxshopid = '{$iShopId}' and oxlang = ".$this->getActCategoryLang();
        } else {
            $sCatId = ( $this->_sActCatId == $this->_sNoCategoryId ) ? '' : $this->_sActCatId;
            $sQ = "select oxseourl from oxseo where oxobjectid = ".$oDb->quote( $oObject->getId() ).
                  " and oxshopid = '{$iShopId}' and oxlang = {$this->_iEditLang}".
                  " and oxparams = '{$sCatId}' ";
        }

        return $sQ;
    }

    public function getEditLang()
    {
        $iLang = $this->_iEditLang;
        if ( $this->getTag() ) {
            $iLang = $this->getActCategoryLang();
        }
        return $iLang;
    }

    public function getActCategoryLang()
    {
        return (int) $this->_iActCatLang;
    }

    protected function _getSeoEntryId()
    {
        $sId = '';
        if ( $sTag = $this->getTag() ) {
            $oObject = $this->_getObject( oxConfig::getParameter( 'oxid' ) );
            $sId = md5( strtolower( $oObject->getShopId() . $this->_getStdUrl( $oObject->getId() ) ) );
        } else {
            $sId = parent::_getSeoEntryId();
        }
        return $sId;
    }

    protected function _getAltSeoEntryId()
    {
        return oxConfig::getParameter( 'oxid' );
    }

    protected function getSeoEntryId()
    {
        return $this->_getSeoEntryId();
    }

    protected function _getSeoEntryType()
    {
        if ( $this->getTag() ) {
            return 'dynamic';
        } else {
            return $this->_getType();
        }
    }

    protected function _getType()
    {
        return 'oxarticle';
    }

    protected function _getStdUrl( $sOxid )
    {
        $oArticle = oxNew( 'oxarticle' );
        $oArticle->loadInLang( $this->_iEditLang, $sOxid );
        $sStdLink = $oArticle->getBaseStdLink( $this->_iEditLang, true, false );
        if ( $sListType = $this->getListType() ) {
            $sStdLink .= "&amp;listtype={$sListType}";
        }

        $sCatId = $this->getSelectedCategoryId();
        $sCatId = ( $sCatId == $this->_sNoCategoryId ) ? false : $sCatId;

        // adding vendor or manufacturer id
        switch ( $this->getActCatType() ) {
            case 'oxvendor':
                $sStdLink .= "&amp;cnid=v_{$sCatId}";
                break;
            case 'oxmanufacturer':
                $sStdLink .= "&amp;mnid={$sCatId}";
                break;
            case 'oxtag':
                $sStdLink .= "&amp;searchtag=".rawurlencode( $this->getTag() );
                break;
            default:
                $sStdLink .= "&amp;cnid={$sCatId}";
                break;
        }

        return $sStdLink;
    }

    public function getActCatType()
    {
        return $this->_sActCatType;
    }

    public function processParam( $sParam )
    {
        if ($this->getTag()) {
            return '';
        } else {
            return trim( substr( $sParam, strpos( $sParam, '#') ), '#' );
        }
    }

    public function getNoCatId()
    {
        return $this->_sNoCategoryId;
    }

    protected function _getEncoder()
    {
        return oxSeoEncoderArticle::getInstance();
    }
}