oxcontent.php

Go to the documentation of this file.

<?php

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

    protected $_aSkipSaveFields = array( 'oxtimestamp' );

    protected $_aSeoUrls = array();

    protected $_sParentCatId = null;

    protected $_blExpanded = null;

    protected $_blIsSeoObject = true;

    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 loadByIdent( $sLoadId )
    {
        $sContentsTable = $this->getViewName();

        $sSelect = $this->buildSelectString( array( $sContentsTable.'.oxloadid' => $sLoadId,
                                                    $sContentsTable.'.oxactive' => '1',
                                                    $sContentsTable.'.oxshopid' => $this->getConfig()->getShopId() ) );

        return $this->assignRecord( $sSelect );
    }

    public function assign( $dbRecord )
    {

        parent::assign( $dbRecord );
        // workaround for firefox showing &lang= as &9001;= entity, mantis#0001272
        $this->oxcontents__oxcontent->setValue(str_replace( '&lang=', '&amp;lang=', $this->oxcontents__oxcontent->value ), oxField::T_RAW);
    }

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

    public function getLink( $iLang = null )
    {
        if ( !oxUtils::getInstance()->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";
        }

        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 oxUtilsUrl::getInstance()->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)) {
            oxSeoEncoderContent::getInstance()->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 loadCredits( $sCreditsId = "oxcredits" )
    {
        $sShopId = $this->getShopId();

        // 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 = '{$sCreditsId}' AND oxshopid = '{$sShopId}'";

        $sTable  = $this->getViewName();
        $aParams = array( "{$sTable}.oxloadid" => $sCreditsId,
                          "{$sTable}.oxshopid" => $sShopId );
        $sQ = $this->buildSelectString( $aParams );
        $sQ = str_replace( "{$sTable}.oxcontent", "( $sContQ ) as oxcontent", $sQ );

        return $this->assignRecord( $sQ );
    }
}