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" );
        $sPwrSearchFld = $sPwrSearchFld ? strtolower( $sPwrSearchFld ) : "oxtitle";

        $oArticle = null;
        $oList = $this->getItemList();
        if ( $oList) {
            foreach ( $oList as $key => $oArticle ) {
                $sFieldName = "oxarticles__{$sPwrSearchFld}";

                // formatting view
                if ( !$myConfig->getConfigParam( 'blSkipFormatConversion' ) ) {
                    if ( $oArticle->$sFieldName->fldtype == "datetime" )
                        oxRegistry::get("oxUtilsDate")->convertDBDateTime( $oArticle->$sFieldName );
                    elseif ( $oArticle->$sFieldName->fldtype == "timestamp" )
                        oxRegistry::get("oxUtilsDate")->convertDBTimestamp( $oArticle->$sFieldName );
                    elseif ( $oArticle->$sFieldName->fldtype == "date" )
                        oxRegistry::get("oxUtilsDate")->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 ? $this->getSearchFields() : null;
        $this->_aViewData["pwrsearchfld"]    = strtoupper( $sPwrSearchFld );

        $aFilter = $this->getListFilter();
        if ( isset( $aFilter["oxarticles"][$sPwrSearchFld] ) ) {
            $this->_aViewData["pwrsearchinput"] = $aFilter["oxarticles"][$sPwrSearchFld];
        }

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

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

        // parent categorie tree
        $this->_aViewData["cattree"] = $this->getCategoryList($sType, $sValue);

        // manufacturer list
        $this->_aViewData["mnftree"] = $this->getManufacturerlist($sType, $sValue);

        // vendor list
        $this->_aViewData["vndtree"] = $this->getVendorList($sType, $sValue);

        return "article_list.tpl";
    }

    public function getSearchFields()
    {
        $aSkipFields = array("oxblfixedprice", "oxvarselect", "oxamitemid", "oxamtaskid", "oxpixiexport", "oxpixiexported") ;
        $oArticle = oxNew( "oxarticle" );
        return array_diff( $oArticle->getFieldNames(), $aSkipFields );
    }

    public function getCategoryList($sType, $sValue)
    {
        $myConfig = $this->getConfig();

        // parent categorie tree
        $oCatTree = oxNew( "oxCategoryList" );
        $oCatTree->loadList();
        if ( $sType === 'cat' ) {
            foreach ($oCatTree as $oCategory ) {
                if ( $oCategory->oxcategories__oxid->value == $sValue ) {
                    $oCategory->selected = 1;
                    break;
                }
            }
        }

        return $oCatTree;
    }

    public function getManufacturerList($sType, $sValue)
    {
        $oMnfTree = oxNew( "oxManufacturerList");
        $oMnfTree->loadManufacturerList();
        if ( $sType === 'mnf' ) {
            foreach ($oMnfTree as $oManufacturer ) {
                if ( $oManufacturer->oxmanufacturers__oxid->value == $sValue ) {
                    $oManufacturer->selected = 1;
                    break;
                }
            }
        }

        return $oMnfTree;
    }

    public function getVendorList($sType, $sValue)
    {
        $oVndTree = oxNew( "oxVendorList");
        $oVndTree->loadVendorList();
        if ( $sType === 'vnd' ) {
            foreach ($oVndTree as $oVendor ) {
                if ( $oVendor->oxvendor__oxid->value == $sValue ) {
                    $oVendor->selected = 1;
                    break;
                }
            }
        }

        return $oVndTree;
    }

    protected function _buildSelectString( $oListObject = null )
    {
        $sQ = parent::_buildSelectString( $oListObject );
        if ( $sQ ) {
            $sTable = getViewName( "oxarticles" );
            $sQ .= " and $sTable.oxparentid = '' ";

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

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

        return $sQ;
    }

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

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

        return $this->_aWhere;
    }

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

}