oxcontent.php

Go to the documentation of this file.

<?php

class oxContent extends oxI18n implements oxIUrl
{
    protected $_sClassName = 'oxcontent';

    protected $_aSeoUrls = array();

    protected $_sParentCatId = null;

    protected $_blExpanded = null;

    protected $_blIsSeoObject = true;

    protected $_sCategoryId;

    public function __get( $sName )
    {
        switch ( $sName ) {
            case 'expanded':
                return $this->getExpanded();
                break;
        }
        return parent::__get( $sName );
    }

    public function __construct()
    {
        parent::__construct();
        $this->init( 'oxcontents' );
    }

    public function getExpanded()
    {
        if ( !isset( $this->_blExpanded ) ) {
            $this->_blExpanded = ( $this->getId() == oxConfig::getParameter( 'oxcid' ) );
        }
        return $this->_blExpanded;
    }

    public function setCategoryId( $sCategoryId )
    {
        $this->oxcontents__oxcatid = new oxField( $sCategoryId );
    }

    public function getCategoryId()
    {
        return $this->oxcontents__oxcatid->value;
    }


    protected function _loadFromDb( $sLoadId )
    {
        $sTable = $this->getViewName();
        $sShopId = $this->getShopId();
        $aParams = array( $sTable . '.oxloadid' => $sLoadId, $sTable . '.oxshopid' => $sShopId );

        $sSelect = $this->buildSelectString( $aParams );

        //Loads "credits" content object and its text (first available)
        if ( $sLoadId == 'oxcredits' ) {

            // fetching column names
            $sColQ = "SHOW COLUMNS FROM oxcontents WHERE field LIKE  'oxcontent%'";
            $aCols = oxDb::getDb()->getAll( $sColQ );

            // building subquery
            $sPattern = "IF ( %s != '', %s, %s ) ";
            $iCount = count( $aCols ) - 1;

            $sContQ = "SELECT {$sPattern}";
            foreach ( $aCols as $iKey => $aCol ) {
                $sContQ = sprintf( $sContQ, $aCol[0], $aCol[0], $iCount != $iKey ? $sPattern : "''" );
            }
            $sContQ .= " FROM oxcontents WHERE oxloadid = '{$sLoadId}' AND oxshopid = '{$sShopId}'";

            $sSelect = $this->buildSelectString( $aParams );
            $sSelect = str_replace( "`{$sTable}`.`oxcontent`", "( $sContQ ) as oxcontent", $sSelect );
        }

        $aData = oxDb::getDb( oxDb::FETCH_MODE_ASSOC )->getRow( $sSelect );

        return $aData;
    }

    public function loadByIdent( $sLoadId )
    {

            $aData = $this->_loadFromDb( $sLoadId );

        if ( $aData ) {
            $this->assign( $aData );
            return true;
        }

        return false;
    }


    public function getLoadId()
    {
        return $this->oxcontents__oxloadid->value;
    }

    public function isActive()
    {
        return $this->oxcontents__oxactive->value;
    }

    public function assign( $dbRecord )
    {

        parent::assign( $dbRecord );
        // workaround for firefox showing &lang= as &9001;= entity, mantis#0001272

        if ( $this->oxcontents__oxcontent ) {
            $this->oxcontents__oxcontent->setValue( str_replace( '&lang=', '&amp;lang=', $this->oxcontents__oxcontent->value ), oxField::T_RAW );
        }
    }

    public function getBaseSeoLink( $iLang )
    {
        return oxRegistry::get( "oxSeoEncoderContent" )->getContentUrl( $this, $iLang );
    }

    public function getLink( $iLang = null )
    {
        if ( !oxRegistry::getUtils()->seoIsActive() ) {
            return $this->getStdLink( $iLang );
        }

        if ( $iLang === null ) {
            $iLang = $this->getLanguage();
        }

        if ( !isset( $this->_aSeoUrls[$iLang] ) ) {
            $this->_aSeoUrls[$iLang] = $this->getBaseSeoLink( $iLang );
        }

        return $this->_aSeoUrls[$iLang];
    }

    public function getBaseStdLink( $iLang, $blAddId = true, $blFull = true )
    {
        $sUrl = '';
        if ( $blFull ) {
            //always returns shop url, not admin
            $sUrl = $this->getConfig()->getShopUrl( $iLang, false );
        }

        if ( $this->oxcontents__oxloadid->value === 'oxcredits' ) {
            $sUrl .= "index.php?cl=credits";
        } else {
            $sUrl .= "index.php?cl=content";
        }
        $sUrl .= '&amp;oxloadid=' . $this->getLoadId();

        if ( $blAddId ) {
            $sUrl .= "&amp;oxcid=" . $this->getId();
            // adding parent category if if available
            if ( $this->_sParentCatId !== false && $this->oxcontents__oxcatid->value && $this->oxcontents__oxcatid->value != 'oxrootid' ) {

                if ( $this->_sParentCatId === null ) {
                    $this->_sParentCatId = false;
                    $oDb = oxDb::getDb();
                    $sParentId = $oDb->getOne( "select oxparentid from oxcategories where oxid = " . $oDb->quote( $this->oxcontents__oxcatid->value ) );
                    if ( $sParentId && 'oxrootid' != $sParentId ) {
                        $this->_sParentCatId = $sParentId;
                    }
                }

                if ( $this->_sParentCatId ) {
                    $sUrl .= "&amp;cnid=" . $this->_sParentCatId;
                }
            }
        }

        //always returns shop url, not admin
        return $sUrl;
    }

    public function getStdLink( $iLang = null, $aParams = array() )
    {
        if ( $iLang === null ) {
            $iLang = $this->getLanguage();
        }

        return oxRegistry::get( "oxUtilsUrl" )->processUrl( $this->getBaseStdLink( $iLang ), true, $aParams, $iLang );
    }

    protected function _setFieldData( $sFieldName, $sValue, $iDataType = oxField::T_TEXT )
    {
        if ( 'oxcontent' === strtolower( $sFieldName ) || 'oxcontents__oxcontent' === strtolower( $sFieldName ) ) {
            $iDataType = oxField::T_RAW;
        }

        return parent::_setFieldData( $sFieldName, $sValue, $iDataType );
    }

    public function delete( $sOXID = null )
    {
        if ( !$sOXID ) {
            $sOXID = $this->getId();
        }

        if ( parent::delete( $sOXID ) ) {
            oxRegistry::get( "oxSeoEncoderContent" )->onDeleteContent( $sOXID );
            return true;
        }
        return false;
    }

    public function save()
    {
        $blSaved = parent::save();
        if ( $blSaved && $this->oxcontents__oxloadid->value === 'oxagb' ) {
            $sShopId = $this->getConfig()->getShopId();
            $sVersion = $this->oxcontents__oxtermversion->value;

            $oDb = oxDb::getDb();
            // dropping expired..
            $oDb->execute( "delete from oxacceptedterms where oxshopid='{$sShopId}' and oxtermversion != " . $oDb->quote( $sVersion ) );
        }
        return $blSaved;
    }

    public function getTermsVersion()
    {
        if ( $this->loadByIdent( 'oxagb' ) ) {
            return $this->oxcontents__oxtermversion->value;
        }
    }

    public function getType()
    {
        return $this->oxcontents__oxtype->value;
    }

}