oxrecommlist.php

Go to the documentation of this file.

<?php

class oxRecommList extends oxBase
{
    protected $_sClassName = 'oxRecommList';

    protected $_oArticles  = null;

    protected $_sArticlesFilter = '';

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

    public function getArticles(  $iStart = null, $iNrofArticles = null, $blReload = false )
    {
        // cached ?
        if ( $this->_oArticles !== null && !$blReload ) {
            return $this->_oArticles;
        }

        $this->_oArticles = oxNew( 'oxarticlelist' );

        if ( $iStart !== null && $iNrofArticles !== null ) {
            $this->_oArticles->setSqlLimit( $iStart, $iNrofArticles );
        }

        // loading basket items
        $this->_oArticles->loadRecommArticles( $this->getId(), $this->_sArticlesFilter );

        return $this->_oArticles;
    }

    public function getArtCount()
    {
        $iCnt = 0;
        $sSelect = $this->_getArticleSelect();
        if ( $sSelect ) {
            $iCnt = oxDb::getDb()->getOne( $sSelect );
        }
        return $iCnt;
    }

    protected function _getArticleSelect()
    {
        $sArtView = getViewName( 'oxarticles' );
        $sSelect  = "select count(distinct $sArtView.oxid) from oxobject2list ";
        $sSelect .= "left join $sArtView on oxobject2list.oxobjectid = $sArtView.oxid ";
        $sSelect .= "where (oxobject2list.oxlistid = '".$this->getId()."') ";

        return $sSelect;
    }

    public function getFirstArticle()
    {
        $oArtList = oxNew( 'oxarticlelist' );
        $oArtList->setSqlLimit( 0, 1 );
        $oArtList->loadRecommArticles( $this->getId(), $this->_sArticlesFilter );
        $oArtList->rewind();
        return $oArtList->current();
    }

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

        if ( ( $blDelete = parent::delete( $sOXID ) ) ) {
            // cleaning up related data
            $sQ = "delete from oxobject2list where oxlistid = '$sOXID' ";
            oxDb::getDb()->execute( $sQ );
        }
        return $blDelete;
    }

    public function getArtDescription( $sOXID )
    {
        if ( !$sOXID ) {
            return false;
        }

        $sSelect = 'select oxdesc from oxobject2list where oxlistid = "'.$this->getId().'" and oxobjectid = "'.$sOXID.'"';
        $sDesc = oxDb::getDb()->getOne( $sSelect );
        return $sDesc;
    }

    public function removeArticle( $sOXID )
    {
        if ( !$sOXID ) {
            return false;
        }

        $sQ = "delete from oxobject2list where oxobjectid = '$sOXID' ";
        return oxDb::getDb()->execute( $sQ );
    }

    public function addArticle( $sOXID, $sDesc )
    {
        $blAdd = false;
        if ( $sOXID ) {
            $oDB = oxDb::getDb();
            if ( !$oDB->getOne( "select oxid from oxobject2list where oxobjectid='$sOXID' and oxlistid='".$this->getId()."'" ) ) {
                $sUid  = oxUtilsObject::getInstance()->generateUID();
                $sDesc = $oDB->quote( $sDesc );
                $sQ    = "insert into oxobject2list ( oxid, oxobjectid, oxlistid, oxdesc ) values ( '$sUid', '$sOXID', '".$this->getId()."', $sDesc )";
                $blAdd = $oDB->execute( $sQ );
            }
        }
        return $blAdd;
    }

    public function getRecommListsByIds( $aArticleIds )
    {
        if ( count( $aArticleIds ) ) {
            startProfile(__FUNCTION__);

            $aIds = array();
            foreach ( $aArticleIds as $iKey => $sVal ) {
                $aIds[$sVal] = mysql_real_escape_string($sVal);
            }

            $sIds = implode("','", $aIds);

            $oRecommList = oxNew( 'oxlist' );
            $oRecommList->init( 'oxrecommlist' );

            $iShopId = $this->getConfig()->getShopId();
            $iCnt = $this->getConfig()->getConfigParam( 'iNrofCrossellArticles' );

            $oRecommList->setSqlLimit( 0, $iCnt );

            $sSelect = "SELECT distinct lists.* FROM oxobject2list AS o2l_lists";
            $sSelect.= " LEFT JOIN oxobject2list AS o2l_count ON o2l_lists.oxlistid = o2l_count.oxlistid";
            $sSelect.= " LEFT JOIN oxrecommlists as lists ON o2l_lists.oxlistid = lists.oxid";
            $sSelect.= " WHERE o2l_lists.oxobjectid IN ('$sIds') and lists.oxshopid ='$iShopId'";
            $sSelect.= " GROUP BY lists.oxid order by (";
            $sSelect.= " SELECT count( order1.oxobjectid ) FROM oxobject2list AS order1";
            $sSelect.= " WHERE order1.oxobjectid IN ('$sIds') AND o2l_lists.oxlistid = order1.oxlistid";
            $sSelect.= " ) DESC, count( lists.oxid ) DESC";

            $oRecommList->selectString( $sSelect );

            stopProfile(__FUNCTION__);

            if ( $oRecommList->count() ) {
                startProfile('_loadFirstArticles');

                $this->_loadFirstArticles( $oRecommList, $aIds );

                stopProfile('_loadFirstArticles');

                return $oRecommList;
            }
        }
    }

    protected function _loadFirstArticles(oxList $oRecommList, $aIds)
    {
        $aPrevIds = array();
        $sArtView = getViewName( 'oxarticles' );
        foreach ($oRecommList as $key => $oRecomm) {
            $sIds = implode("','", $aIds);
            if (count($aPrevIds)) {
                $sNegateSql = " AND $sArtView.oxid not in ( '".implode("','", $aPrevIds)."' ) ";
            } else {
                $sNegateSql = '';
            }
            $sArticlesFilter = "$sNegateSql ORDER BY $sArtView.oxid in ( '$sIds' ) desc";
            $oRecomm->setArticlesFilter($sArticlesFilter);
            $oArtList = oxNew( 'oxarticlelist' );
            $oArtList->setSqlLimit( 0, 1 );
            $oArtList->loadRecommArticles( $oRecomm->getId(), $sArticlesFilter );

            if (count($oArtList) == 1) {
                $oArtList->rewind();
                $oArticle = $oArtList->current();
                $sId = $oArticle->getId();
                $aPrevIds[$sId] = $sId;
                unset($aIds[$sId]);
            } else {
                unset($oRecommList[$key]);
            }
        }
    }

    public function getSearchRecommLists( $sSearchStr )
    {
        if ( $sSearchStr ) {
            // sets active page
            $iActPage = (int) oxConfig::getParameter( 'pgNr' );
            $iActPage = ($iActPage < 0) ? 0 : $iActPage;

            // load only lists which we show on screen
            $iNrofCatArticles = $this->getConfig()->getConfigParam( 'iNrofCatArticles' );
            $iNrofCatArticles = $iNrofCatArticles ? $iNrofCatArticles : 10;

            $oRecommList = oxNew( 'oxlist' );
            $oRecommList->init( 'oxrecommlist' );
            $sSelect = $this->_getSearchSelect( $sSearchStr );
            $oRecommList->setSqlLimit( $iNrofCatArticles * $iActPage, $iNrofCatArticles );
            $oRecommList->selectString( $sSelect );

            return $oRecommList;
        }
    }

    public function getSearchRecommListCount( $sSearchStr )
    {
        $iCnt = 0;
        $sSelect = $this->_getSearchSelect( $sSearchStr );
        if ( $sSelect ) {

            $sPartial = substr( $sSelect, strpos( $sSelect, ' from ' ) );
            $sSelect  = "select count( distinct rl.oxid ) $sPartial ";
            $iCnt = oxDb::getDb()->getOne( $sSelect );
        }
        return $iCnt;
    }

    protected function _getSearchSelect( $sSearchStr )
    {
        $iShopId    = $this->getConfig()->getShopId();
        $sSearchStr = oxDb::getDb()->quote( "%$sSearchStr%" );

        $sSelect = "select distinct rl.* from oxrecommlists as rl";
        $sSelect.= " inner join oxobject2list as o2l on o2l.oxlistid = rl.oxid";
        $sSelect.= " where ( rl.oxtitle like $sSearchStr or rl.oxdesc like $sSearchStr";
        $sSelect.= " or o2l.oxdesc like $sSearchStr ) and rl.oxshopid = '$iShopId'";

        return $sSelect;
    }

    public function addToRatingAverage( $iRating)
    {
        $dOldRating = $this->oxrecommlists__oxrating->value;
        $dOldCnt    = $this->oxrecommlists__oxratingcnt->value;
        $this->oxrecommlists__oxrating    = new oxField(( $dOldRating * $dOldCnt + $iRating ) / ($dOldCnt + 1), oxField::T_RAW);
        $this->oxrecommlists__oxratingcnt = new oxField($dOldCnt + 1, oxField::T_RAW);
        $this->save();
    }

    public function getReviews()
    {
        $oReview = oxNew('oxreview');
        $oRevs = $oReview->loadList('oxrecommlist', $this->getId());
        //if no review found, return null
        if ( $oRevs->count() < 1 ) {
            return null;
        }
        return $oRevs;
    }

    public function getLink()
    {
        $sUrl = $this->getConfig()->getShopHomeURL().'cl=recommlist';
        if ( oxUtils::getInstance()->seoIsActive() ) {
            $oEncoder = oxSeoEncoder::getInstance();
            if ( ( $sStaticUrl = $oEncoder->getStaticUrl( $sUrl ) ) ) {
                $sUrl = $sStaticUrl;
            }
        }
        $sUrl .= ( ( strpos( $sUrl, '?' ) !== false ) ? "&amp;":"?" ) . "recommid=".$this->getId();

        return $sUrl;
    }

    public function setArticlesFilter($sArticlesFilter)
    {
        $this->_sArticlesFilter = $sArticlesFilter;
    }
}

---