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;
        $oList = $this->getItemList();
        if ( $oList) {
            foreach ( $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;
                $oList[$key] = $oArticle;
            }
        }

        parent::render();

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

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

        $sType  = '';
        $sValue = '';

        $sArtCat= oxConfig::getParameter( "art_category" );
        if ( $sArtCat && strstr( $sArtCat, "@@" ) !== false ) {
            list( $sType, $sValue ) = explode( "@@", $sArtCat );
        }

        // parent categorie tree
        $oCatTree = oxNew( "oxCategoryList");
        $oCatTree->buildList( $myConfig->getConfigParam( 'bl_perfLoadCatTree' ) );
        if ( $sType === 'cat' ) {
            foreach ($oCatTree as $oCategory ) {
                if ( $oCategory->oxcategories__oxid->value == $sValue ) {
                    $oCategory->selected = 1;
                    break;
                }
            }
        }
        $this->_aViewData["cattree"] = $oCatTree;

       // manufacturer list
        $oMnfTree = oxNew( "oxManufacturerList");
        $oMnfTree->loadManufacturerList();
        if ( $sType === 'mnf' ) {
            foreach ($oMnfTree as $oManufacturer ) {
                if ( $oManufacturer->oxmanufacturers__oxid->value == $sValue ) {
                    $oManufacturer->selected = 1;
                    break;
                }
            }
        }
        $this->_aViewData["mnftree"] = $oMnfTree;

        // vendor list
        $oVndTree = oxNew( "oxVendorList");
        $oVndTree->loadVendorList();
        if ( $sType === 'vnd' ) {
            foreach ($oVndTree as $oVendor ) {
                if ( $oVendor->oxvendor__oxid->value == $sValue ) {
                    $oVendor->selected = 1;
                    break;
                }
            }
        }
        $this->_aViewData["vndtree"] = $oVndTree;

        return "article_list.tpl";
    }

    protected function _changeselect( $sSql )
    {
        $sArtCat= oxConfig::getParameter("art_category");
        if ( $sArtCat && strstr($sArtCat, "@@") !== false ) {
            list($sType, $sValue) = explode("@@", $sArtCat);
        }

        $sTable   = getViewName( "oxarticles" );
        switch ($sType) {
            // add category
            case 'cat':
                $sO2CView = getViewName( "oxobject2category" );
                $sInsert  = "from $sTable left join $sO2CView on $sTable.oxid = $sO2CView.oxobjectid where $sO2CView.oxcatnid = ".oxDb::getDb()->quote($sValue)." and ";
                $sSql = preg_replace( "/from\s+$sTable\s+where/i", $sInsert, $sSql);
                break;
            // add category
            case 'mnf':
                $sSql.= " and $sTable.oxmanufacturerid = ".oxDb::getDb()->quote($sValue);
                break;
            // add vendor
            case 'vnd':
                $sSql.= " and $sTable.oxvendorid = ".oxDb::getDb()->quote($sValue);
                break;
        }
        return $sSql;
    }

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

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

        return $sQ . " and ".getViewName( 'oxarticles' ).".oxparentid = '' ";
    }

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

}