oxcontentlist.php

Go to the documentation of this file.

<?php

class oxContentList extends oxList
{
    const TYPE_INFORMATION_CONTENTS = 0;

    const TYPE_MAIN_MENU_LIST = 1;

    const TYPE_CATEGORY_MENU = 2;

    const TYPE_SERVICE_LIST = 3;

    protected $_aServiceKeys = array( 'oximpressum', 'oxagb', 'oxsecurityinfo', 'oxdeliveryinfo', 'oxrightofwithdrawal', 'oxorderinfo', 'oxcredits' );

    public function setServiceKeys( $aServiceKeys )
    {
        $this->_aServiceKeys = $aServiceKeys;
    }

    public function getServiceKeys()
    {
        return $this->_aServiceKeys;
    }

    public function __construct( $sObjectsInListName = 'oxcontent' )
    {
        parent::__construct( 'oxcontent' );
    }

    public function loadMainMenulist()
    {
        $this->_load( self::TYPE_MAIN_MENU_LIST );
    }

    public function loadCatMenues()
    {
        $this->_load( self::TYPE_CATEGORY_MENU );
        $aArray = array();

        if ( $this->count() ) {
            foreach ( $this as $oContent ) {
                // add into category tree
                if ( !isset( $aArray[$oContent->getCategoryId()] ) ) {
                    $aArray[$oContent->getCategoryId()] = array();
                }

                $aArray[$oContent->oxcontents__oxcatid->value][] = $oContent;
            }
        }

        $this->_aArray = $aArray;
    }


    protected function _loadFromDb( $iType )
    {
        $sSql = $this->_getSQLByType( $iType );
        $aData = oxDb::getDb( oxDb::FETCH_MODE_ASSOC )->getAll( $sSql );

        return $aData;
    }

    protected function _load( $iType )
    {

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

        $this->assignArray( $aData );
    }


    public function loadServices()
    {
        $this->_load( self::TYPE_SERVICE_LIST );
        $this->_extractListToArray();
    }

    protected function _extractListToArray()
    {
        $aExtractedContents = array();
        foreach ( $this as $oContent ) {
            $aExtractedContents[$oContent->getLoadId()] = $oContent;
        }

        $this->_aArray = $aExtractedContents;
    }

    protected function _getSQLByType( $iType )
    {
        $sSQLAdd = '';
        $oDb = oxDb::getDb();
        $sSQLType = " AND `oxtype` = " . $oDb->quote( $iType );

        if ( $iType == self::TYPE_CATEGORY_MENU ) {
            $sSQLAdd = " AND `oxcatid` IS NOT NULL AND `oxsnippet` = '0'";
        }

        if ( $iType == self::TYPE_SERVICE_LIST ) {
            $sIdents = implode( ", ", oxDb::getInstance()->quoteArray( $this->getServiceKeys() ) );
            $sSQLAdd = " AND OXLOADID IN (" . $sIdents . ")";
            $sSQLType = '';
        }
        $sViewName = $this->getBaseObject()->getViewName();
        $sSql = "SELECT * FROM {$sViewName} WHERE `oxactive` = '1' $sSQLType AND `oxshopid` = " . $oDb->quote( $this->_sShopID ) . " $sSQLAdd ORDER BY `oxloadid`";

        return $sSql;
    }
}