list_review.php

Go to the documentation of this file.

<?php

class List_Review extends Article_List
{
    protected $_sListType  = 'oxlist';

    protected $_sListClass = 'oxreview';

    protected function _getViewListSize()
    {
        return $this->_getUserDefListSize();
    }

    public function render()
    {
        oxAdminList::render();

        $this->_aViewData["viewListSize"]  = $this->_getViewListSize();
        $this->_aViewData["whereparam"]    = $this->_aViewData["whereparam"] . '&amp;viewListSize='.$this->_getViewListSize();
        $this->_aViewData["menustructure"] = $this->getNavigation()->getDomXml()->documentElement->childNodes;
        $this->_aViewData["articleListTable"] = getViewName('oxarticles');

        return "list_review.tpl";
    }

    protected function _setFilterParams()
    {
        parent::_setFilterParams();

        // build where
        if ( is_array( $aWhere = oxConfig::getParameter( 'where' ) ) ) {

            $myUtils  = oxUtils::getInstance();
            $sTable = 'oxarticles';

            $oSearchKeys = isset( $this->_aViewData['where'] ) ? $this->_aViewData['where'] : new oxStdClass();

            while ( list( $sName, $sValue ) = each( $aWhere ) ) {
                $sFieldName = str_replace( getViewName( $sTable ) . '.', $sTable . '.', $sName );
                $sFieldName = $myUtils->getArrFldName( $sFieldName );
                $oSearchKeys->$sFieldName = $sValue;
            }
            $this->_aViewData['where'] = $oSearchKeys;
        }
    }

    protected function _buildSelectString( $oObject = null )
    {
        $sArtTable = getViewName('oxarticles');
        $sLangTag = oxLang::getInstance()->getLanguageTag( $this->_iEditLang );

        $sSql  = "select oxreviews.oxid, oxreviews.oxcreate, oxreviews.oxtext, oxreviews.oxobjectid, {$sArtTable}.oxparentid, {$sArtTable}.oxtitle{$sLangTag} as oxtitle, {$sArtTable}.oxvarselect{$sLangTag} as oxvarselect, oxparentarticles.oxtitle{$sLangTag} as parenttitle, ";
        $sSql .= "concat( {$sArtTable}.oxtitle{$sLangTag}, if(isnull(oxparentarticles.oxtitle{$sLangTag}), '', oxparentarticles.oxtitle{$sLangTag}), {$sArtTable}.oxvarselect{$sLangTag}) as arttitle from oxreviews ";
        $sSql .= "left join $sArtTable as {$sArtTable} on {$sArtTable}.oxid=oxreviews.oxobjectid and 'oxarticle' = oxreviews.oxtype ";
        $sSql .= "left join $sArtTable as oxparentarticles on oxparentarticles.oxid = {$sArtTable}.oxparentid ";
        $sSql .= "where 1 and oxreviews.oxlang = '{$this->_iEditLang}' ";
        return $sSql;
    }

    protected function _prepareWhereQuery( $aWhere, $sSql )
    {
        $sArtTable = getViewName('oxarticles');
        $sArtTitleField = "{$sArtTable}.oxtitle";
        $sSqlForTitle = null;
        $sLangTag = oxLang::getInstance()->getLanguageTag( $this->_iEditLang );

        $sSql = parent::_prepareWhereQuery( $aWhere, $sSql );

        //removing parent id checking from sql
        $sStr = "/\s+and\s+".getViewName( 'oxarticles' )."\.oxparentid\s*=\s*''/";
        $sSql = preg_replace( $sStr, " ", $sSql );

        // if searching in article title field, updating sql for this case
        if ( $this->_aWhere[$sArtTitleField] ) {
            $sSqlForTitle = " (CONCAT( {$sArtTable}.oxtitle{$sLangTag}, if(isnull(oxparentarticles.oxtitle{$sLangTag}), '', oxparentarticles.oxtitle{$sLangTag}), {$sArtTable}.oxvarselect{$sLangTag})) ";
            $sSql = preg_replace( "/{$sArtTable}\.oxtitle\s+like/", "$sSqlForTitle like", $sSql );
        }

        return " $sSql and {$sArtTable}.oxid is not null ";
    }

    protected function _prepareOrderByQuery( $sSql = null )
    {
        if ( $sSort = oxConfig::getParameter( "sort" ) ) {
            $sSql .= " order by ".oxDb::getInstance()->escapeString( $sSort ) ." ";
        }

        return $sSql;
    }
}