oxnewslist.php

Go to the documentation of this file.

<?php

class oxNewslist extends oxList
{
    protected $_sObjectsInListName = 'oxnews';

    protected $_oUser = null;

    public function loadNews( $iFrom = 0, $iLimit = 10 )
    {
        if ( $iLimit ) {
            $this->setSqlLimit( $iFrom, $iLimit );
        }

        $sNewsViewName = getViewName( 'oxnews' );
        $oBaseObject   = $this->getBaseObject();
        $sSelectFields = $oBaseObject->getSelectFields();

        if ( $oUser = $this->getUser() ) {
            // performance - only join if user is logged in
            $sSelect  = "select $sSelectFields from $sNewsViewName ";
            $sSelect .= "left join oxobject2group on oxobject2group.oxobjectid=$sNewsViewName.oxid where ";
            $sSelect .= "oxobject2group.oxgroupsid in ( select oxgroupsid from oxobject2group where oxobjectid='".$oUser->getId()."' ) or ";
            $sSelect .= "( oxobject2group.oxgroupsid is null ) ";
        } else {
            $sSelect  = "select $sSelectFields, oxobject2group.oxgroupsid from $sNewsViewName ";
            $sSelect .= "left join oxobject2group on oxobject2group.oxobjectid=$sNewsViewName.oxid where oxobject2group.oxgroupsid is null ";
        }

        $sSelect .= " and ".$oBaseObject->getSqlActiveSnippet();
        $sSelect .= " and $sNewsViewName.oxshortdesc <> '' ";
        $sSelect .= " group by $sNewsViewName.oxid order by $sNewsViewName.oxdate desc ";

        $this->selectString( $sSelect );
    }

    public function getCount()
    {
        $myConfig = $this->getConfig();
        $oDb = oxDb::getDb();

        $sNewsViewName = getViewName( 'oxnews' );
        $oBaseObject   = $this->getBaseObject();
        //$sSelectFields = $oBaseObject->getSelectFields();

        if ( $oUser = $this->getUser() ) {
            // performance - only join if user is logged in
            $sSelect  = "select COUNT($sNewsViewName.`oxid`) from $sNewsViewName ";
            $sSelect .= "left join oxobject2group on oxobject2group.oxobjectid=$sNewsViewName.oxid where ";
            $sSelect .= "oxobject2group.oxgroupsid in ( select oxgroupsid from oxobject2group where oxobjectid='".$oUser->getId()."' ) or ";
            $sSelect .= "( oxobject2group.oxgroupsid is null ) ";
        } else {
            $sSelect  = "select COUNT($sNewsViewName.`oxid`) from $sNewsViewName ";
            $sSelect .= "left join oxobject2group on oxobject2group.oxobjectid=$sNewsViewName.oxid where oxobject2group.oxgroupsid is null ";
        }

        $sSelect .= " and ".$oBaseObject->getSqlActiveSnippet();

        // loading only if there is some data
        $iRecCnt = (int) $oDb->getOne( $sSelect );

        return $iRecCnt;
    }

    public function setUser( $oUser )
    {
        $this->_oUser = $oUser;
    }

    public function getUser()
    {
        if ( $this->_oUser == null ) {
            $this->_oUser = parent::getUser();
        }

        return $this->_oUser;
    }
}