article_list.php

Go to the documentation of this file.

<?php

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

    protected $_sListType = 'oxarticlelist';

    public function init()
    {
        //loading article
        $soxId = oxConfig::getParameter( "oxid");
        if ($soxId && $soxId != -1) {
            $oArticle = oxNew( "oxarticle");
            $oArticle->load( $soxId);
            $oArticle->getAdminVariants();
        }

        parent::init();
    }

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

        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
        $oArticle = oxNew("oxarticle");
        $this->_aViewData["pwrsearchfields"] = $oArticle->getSearchableFields();
        $this->_aViewData["pwrsearchfld"] =  strtoupper($sPwrSearchFld);

        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' ));

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

            /*
            while (list($key, $val) = each($oCatTree)) {
                echo " AAAAA ";
                if ( $val->oxcategories__oxid->value == $sChosenCat) {
                    $val->selected = 1;
                    $oCatTree[$key] = $val;
                }
            }
            */
        }
        $this->_aViewData["cattree"] =  $oCatTree;

        return "article_list.tpl";
    }

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

        return $sSql;
    }

    public function buildWhere()
    {
        // we override this to select only parent articles
        $sViewName = getViewName( 'oxarticles' );
        $this->_aWhere = parent::buildWhere();
        if ( !is_array($this->_aWhere))
            $this->_aWhere = array();
        // adding folder check
        $sFolder = oxConfig::getParameter( 'folder' );
        if ( $sFolder && $sFolder != '-1' ) {
            $this->_aWhere["$sViewName.oxfolder"] = $sFolder;
        }
        return $this->_aWhere;
    }

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

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

}

---