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() == oxRegistry::getConfig()->getRequestParameter('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);
    }

    protected function _getFieldData($sFieldName)
    {
        return $this->{$sFieldName}->value;
    }

    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 setType($sValue)
    {
        $this->_setFieldData('oxcontents__oxtype', $sValue);
    }

    public function getType()
    {
        return (int) $this->_getFieldData('oxcontents__oxtype');
    }

    public function setTitle($sValue)
    {
        $this->_setFieldData('oxcontents__oxtitle', $sValue);
    }

    public function getTitle()
    {
        return (string) $this->_getFieldData('oxcontents__oxtitle');
    }
}