object_seo.php

Go to the documentation of this file.

<?php

class Object_Seo extends oxAdminDetails
{
    public function render()
    {
        parent::render();

        if ( ( $oObject= $this->_getObject( oxConfig::getParameter( 'oxid' ) ) ) ) {

            $iShopId  = $this->getConfig()->getShopId();
            $oOtherLang = $oObject->getAvailableInLangs();
            if (!isset($oOtherLang[$this->_iEditLang])) {
                // echo "language entry doesn't exist! using: ".key($oOtherLang);
                $oObject->loadInLang( key( $oOtherLang ), oxConfig::getParameter( 'oxid' ) );
            }
            $this->_aViewData['edit'] = $oObject;

            $aLangs = oxLang::getInstance()->getLanguageNames();
            foreach ( $aLangs as $id => $language) {
                $oLang= new oxStdClass();
                $oLang->sLangDesc = $language;
                $oLang->selected = ($id == $this->_iEditLang);
                $this->_aViewData['otherlang'][$id] = clone $oLang;
            }

            // loading SEO part
            $this->_getSeoUrl( $oObject );
            $sQ = $this->_getSeoDataSql( $oObject, $iShopId, $this->_iEditLang );
            $aSeoData = oxDb::getDb(true)->getArray( $sQ );
            $aSeoData = ( is_array( $aSeoData ) && isset( $aSeoData[0] ) )?$aSeoData[0]:array();

            // passing to view
            $this->_aViewData['aSeoData'] = $aSeoData;
        }

        return 'object_seo.tpl';
    }

    protected function _getSeoDataSql( $oObject, $iShopId, $iLang )
    {
        return "select * from oxseo
               left join oxobject2seodata on
                   oxobject2seodata.oxobjectid = oxseo.oxobjectid and
                   oxobject2seodata.oxshopid = oxseo.oxshopid and
                   oxobject2seodata.oxlang = oxseo.oxlang
               where
                   oxseo.oxobjectid = ".oxDb::getDb()->quote( $oObject->getId() )." and
                   oxseo.oxshopid = '{$iShopId}' and oxseo.oxlang = {$iLang} ";
    }

    protected function _getSeoUrl( $oObject )
    {
        return oxDb::getDb()->getOne( $this->_getSeoUrlQuery( $oObject, $this->getConfig()->getShopId() ) );
    }

     protected function _getSeoUrlQuery( $oObject, $iShopId )
     {
        return "select oxseourl from oxseo where oxobjectid = '".$oObject->getId()."' and oxshopid = '{$iShopId}' and oxlang = {$this->_iEditLang} ";
     }

    protected function _getObject( $sOxid )
    {
        if ( $this->_oObject === null && ( $sType = $this->_getType() ) ) {
            $this->_oObject = false;

            // load object
            $oObject = oxNew( $sType );
            if ( $oObject->loadInLang( $this->_iEditLang, $sOxid ) ) {
                $this->_oObject = $oObject;
            }
        }
        return $this->_oObject;
    }

    protected function _getType()
    {
    }

    protected function _getStdUrl( $sOxid )
    {
        return $this->_getObject( $sOxid )->getBaseStdLink( $this->_iEditLang, true, false );
    }

    public function save()
    {
        // saving/updating seo params
        if ( ( $sOxid = $this->_getSeoEntryId() ) ) {
            $aSeoData = oxConfig::getParameter( 'aSeoData' );
            $iShopId  = $this->getConfig()->getShopId();

            // checkbox handling
            if ( !isset( $aSeoData['oxfixed'] ) ) {
                $aSeoData['oxfixed'] = 0;
            }

            $oEncoder = $this->_getEncoder();

            // marking self and page links as expired
            $oEncoder->markAsExpired( $sOxid, $iShopId, 1, $this->getEditLang() );

            // saving
            $oEncoder->addSeoEntry( $sOxid, $iShopId, $this->getEditLang(), $this->_getStdUrl( $sOxid ),
                                    $aSeoData['oxseourl'], $this->_getSeoEntryType(), $aSeoData['oxfixed'],
                                    trim( $aSeoData['oxkeywords'] ), trim( $aSeoData['oxdescription'] ), $this->processParam( $aSeoData['oxparams'] ), true, $this->_getAltSeoEntryId() );
        }
    }

    public function getEditLang()
    {
        return $this->_iEditLang;
    }

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

    protected function _getAltSeoEntryId()
    {
    }

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

    protected function _getSeoEntryType()
    {
        return $this->_getType();
    }

    public function processParam( $sParam )
    {
        return $sParam;
    }

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