article_list.php

Go to the documentation of this file.

<?php

class Article_List extends oxAdminList
{
    protected $_sListClass = 'oxarticle';

    protected $_sListType = 'oxarticlelist';

    public function render()
    {
        $myConfig = $this->getConfig();
        $sPwrSearchFld = oxConfig::getParameter( "pwrsearchfld" );
        if ( !isset( $sPwrSearchFld ) ) {
            $sPwrSearchFld  = "oxtitle";
        }

        $oArticle = null;
        foreach ( $this->_oList as $key => $oArticle ) {
            $sFieldName = "oxarticles__".strtolower( $sPwrSearchFld );

            // formatting view
            if ( !$myConfig->getConfigParam( 'blSkipFormatConversion' ) ) {
                if ( $oArticle->$sFieldName->fldtype == "datetime")
                    oxDb::getInstance()->convertDBDateTime( $oArticle->$sFieldName );
                elseif ( $oArticle->$sFieldName->fldtype == "timestamp")
                    oxDb::getInstance()->convertDBTimestamp( $oArticle->$sFieldName );
                elseif ( $oArticle->$sFieldName->fldtype == "date")
                    oxDb::getInstance()->convertDBDate( $oArticle->$sFieldName );
            }

            $oArticle->pwrsearchval = $oArticle->$sFieldName->value;
            $this->_oList[$key] = $oArticle;
        }


        parent::render();

        // load fields
        if ( !$oArticle ) {
            $oArticle = $this->_oList->getBaseObject();
        }
        $this->_aViewData["pwrsearchfields"] = $oArticle->getSearchableFields();
        $this->_aViewData["pwrsearchfld"]    = strtoupper( $sPwrSearchFld );

        $aWhere = array();
        if ( isset( $this->_aViewData["where"] ) ) {
            $aWhere = &$this->_aViewData["where"];
            $sFieldName = "oxarticles__".strtoupper( $sPwrSearchFld );
            if ( isset( $aWhere->$sFieldName ) )
                $this->_aViewData["pwrsearchinput"] = $aWhere->$sFieldName;
        }

        // parent categorie tree
        $oCatTree = oxNew( "oxCategoryList");
        $oCatTree->buildList( $myConfig->getConfigParam( 'bl_perfLoadCatTree' ) );

        if ( ( $sChosenCat= oxConfig::getParameter( "art_category") ) ) {
            foreach ($oCatTree as $oCategory ) {
                if ( $oCategory->oxcategories__oxid->value == $sChosenCat ) {
                    $oCategory->selected = 1;
                    break;
                }
            }
        }

        $this->_aViewData["cattree"] = $oCatTree;
        return "article_list.tpl";
    }

    protected function _changeselect( $sSql )
    {
        // add category
        if ( ( $sChosenCat = oxConfig::getParameter( "art_category" ) ) ) {
            $sTable   = getViewName( "oxarticles" );
            $sO2CView = getViewName( "oxobject2category" );
            $sInsert  = "from $sTable left join $sO2CView on $sTable.oxid = $sO2CView.oxobjectid where $sO2CView.oxcatnid = '$sChosenCat' and ";
            $sSql = preg_replace( "/from\s+$sTable\s+where/i", $sInsert, $sSql);
        }

        return $sSql;
    }

    public function buildWhere()
    {
        // we override this to select only parent articles
        $this->_aWhere = parent::buildWhere();
        if ( !is_array( $this->_aWhere ) ) {
            $this->_aWhere = array();
        }

        // adding folder check
        $sFolder = oxConfig::getParameter( 'folder' );
        if ( $sFolder && $sFolder != '-1' ) {
            $sViewName = getViewName( 'oxarticles' );
            $this->_aWhere["$sViewName.oxfolder"] = $sFolder;
        }

        return $this->_aWhere;
    }

    protected function _prepareWhereQuery( $aWhere, $sQ )
    {
        $sQ = parent::_prepareWhereQuery( $aWhere, $sQ );
        //searching for empty oxfolder fields
        return $sQ . " and ".getViewName( 'oxarticles' ).".oxparentid = '' ";
    }

    public function deleteEntry()
    {
        $sOxId = oxConfig::getParameter( "oxid" );
        $oArticle = oxNew( "oxarticle");
        if ( $sOxId && $oArticle->load( $sOxId ) ) {
            parent::deleteEntry();
        }
    }

}

---