list_review.php

Go to the documentation of this file.

<?php

class List_Review extends oxAdminList
{
    public function render()
    {
        $this->_oList = oxNew( "oxlist", "core" );
        $this->_oList->setSqlLimit( 0, 5000 );
        $this->_oList->init( "oxreview" );

        $aWhere = $this->buildWhere();
        //$aWhere['oxreviews.oxlang'] = $this->_iEditLang;

        $sSql = $this->_buildSelectString( $this->_oList->getBaseObject() );
        $sSql = $this->_prepareWhereQuery( $aWhere, $sSql );
        $sSql = $this->_prepareOrderByQuery( $sSql );
        $sSql = $this->_changeselect( $sSql );
        //$this->_oList->setAssignCallback( array( oxNew("List_Review"), 'formatArticleTitle'));
        $this->_oList->selectString( $sSql );

        parent::render();

        $aWhere = oxConfig::getParameter( "where");
        if ( is_array( $aWhere ) ) {
            foreach ( $aWhere as $sField => $sValue ) {
                $this->_aViewData["where"]->{str_replace( '.', '__', $sField )} = $sValue;
            }
        }

        $this->_aViewData["menustructure"] =  $this->getNavigation()->getDomXml()->documentElement->childNodes;

        return "list_review.tpl";
    }


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

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

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

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

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

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

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

        return $sSql;
    }
}

---