oxadminlist.php

Go to the documentation of this file.

<?php

class oxAdminList extends oxAdminView
{
    protected $_sListClass = null;

    protected $_sListType = 'oxlist';

    protected $_oList = null;

    protected $_iCurrListPos = 0;

    protected $_iListSize = 0;

    protected $_aWhere = null;

    protected $_sDefSort = null;

    protected $_aSort = array();

    protected $_blDesc = false;

    protected $_blEmployMultilanguage = null;

    protected $_iOverPos = null;

    public function __construct()
    {
        parent::__construct();

        $myConfig  = $this->getConfig();

        // #533
        if ( $aProfile = oxSession::getVar( 'profile' ) ) {
            if (isset($aProfile[1]))
                $myConfig->setConfigParam( 'iAdminListSize', (int) $aProfile[1] );
        }
        // list protection
        if ( !$myConfig->getConfigParam( 'iAdminListSize' ) )
            $myConfig->setConfigParam( 'iAdminListSize', 10 );

        //maybe somebody badly configured admin ?
        if ( !is_int( $myConfig->getConfigParam( 'iAdminListSize' ) ) )
            $myConfig->setConfigParam( 'iAdminListSize', 10 );
    }

    public function init()
    {
        parent::init();

        $myConfig = $this->getConfig();

        if ( $this->_sListClass ) {

            $this->_oList = oxNew( $this->_sListType, 'core' );
            $this->_oList->clear();
            $this->_oList->init( $this->_sListClass );

            $aWhere = $this->buildWhere();

            $oListObject = $this->_oList->getBaseObject();

            oxSession::setVar( 'tabelle', $this->_sListClass );
            $this->_aViewData['listTable'] = getViewName( $oListObject->getCoreTableName() );
            $myConfig->setGlobalParameter( 'ListCoreTable', $oListObject->getCoreTableName() );

            if ( $oListObject->isMultilang() ) { // is the object multilingual?
                $oListObject->setLanguage( oxLang::getInstance()->getBaseLanguage() );

                if ( isset( $this->_blEmployMultilanguage ) ) {
                    $oListObject->setEnableMultilang( $this->_blEmployMultilanguage );
                }
            }

            $sSql = $this->_buildSelectString( $oListObject );
            $sSql = $this->_prepareWhereQuery( $aWhere, $sSql );
            $sSql = $this->_prepareOrderByQuery( $sSql );
            $sSql = $this->_changeselect( $sSql );

            // calculates count of list items
            $this->_calcListItemsCount( $sSql );

            // setting current list position (page)
            $this->_setCurrentListPosition( oxConfig::getParameter( 'jumppage' ) );

            // settting additioan params for list: current list size
            $this->_oList->setSqlLimit( $this->_iCurrListPos, $myConfig->getConfigParam( 'iAdminListSize' ) );

            $this->_oList->selectString( $sSql );
        }
    }

    public function render()
    {
        $sReturn = parent::render();

        // assign our list
        if ( $this->_oList ) {
            $this->_aViewData['mylist'] = $this->_oList;
        }

        // build where
        $aWhere = oxConfig::getParameter( 'where' );

        $myConfig = $this->getConfig();
        $myUtils  = oxUtils::getInstance();
        $sListTable = $myConfig->getGlobalParameter( 'ListCoreTable' );

        $oSearchKeys = new oxStdClass();
        $sWhereParam = "";
        if ( is_array( $aWhere ) ) {
            while ( list( $sName, $sValue ) = each( $aWhere ) ) {
                $sWhereParam .= "&amp;where[".$sName."]=".$sValue;
                $sFieldName = str_replace( array( getViewName( $sListTable ) . '.', $sListTable . '.' ), $sListTable . '.', $sName );
                $sFieldName = $myUtils->getArrFldName( $sFieldName );
                $oSearchKeys->$sFieldName = $sValue;
            }
            $this->_aViewData['where'] = $oSearchKeys;
            //#M430: Pagination in admin list loses category parameter
            $sChosenCat  = oxConfig::getParameter( "art_category");
            if ( $sChosenCat ) {
                $sWhereParam .= "&amp;art_category=".$sChosenCat;
            }
            $this->_aViewData['whereparam'] = $sWhereParam;
        }

        // set navigation parameters
        $this->_setListNavigationParams();

        // sorting
        $this->_aSort[0] = oxConfig::getParameter( 'sort' );
        if ( !isset( $this->_aSort[0]) || !$this->_aSort[0] )
            $this->_aSort[0] = $this->_sDefSort;

        $this->_aViewData['sort'] = $this->_aSort[0];

        return $sReturn;
    }

    public function deleteEntry()
    {
        $oDelete = oxNew( $this->_sListClass );


        $blDelete = $oDelete->delete( oxConfig::getParameter( 'oxid' ) );

        // #A - we must reset object ID
        if ( $blDelete && isset( $_POST['oxid'] ) ) {
            $_POST['oxid'] = -1;
        }


        $this->init();
    }

    protected function _calcListItemsCount( $sSql )
    {
        // count SQL
        $sSql = preg_replace( '/select .* from/', 'select count(*) from ', $sSql );

        // removing order by
        $sSql = preg_replace( '/order by .*$/', '', $sSql );

        // con of list items which fits current search conditions
        $this->_iListSize = oxDb::getDb()->getOne( $sSql );

        // set it into session that other frames know about size of DB
        oxSession::setVar( 'iArtCnt', $this->_iListSize );
    }

    protected function _setCurrentListPosition( $sPage = null )
    {
        $iAdminListSize = (int) $this->getConfig()->getConfigParam( 'iAdminListSize' );

        $iJumpTo = $sPage?( (int) $sPage):( (int) ( (int) oxConfig::getParameter( 'lstrt' ) ) / $iAdminListSize );
        $iJumpTo = ( $sPage && $iJumpTo )?( $iJumpTo - 1 ):$iJumpTo;

        $iJumpTo = $iJumpTo * $iAdminListSize;
        if ( $iJumpTo < 1 ) {
            $iJumpTo = 0;
        } elseif ( $iJumpTo >= $this->_iListSize ) {
            $iJumpTo = floor( $this->_iListSize / $iAdminListSize - 1 ) * $iAdminListSize;
        }

        $this->_iCurrListPos = $this->_iOverPos = (int) $iJumpTo;
    }

    protected function _prepareOrderByQuery( $sSql = null )
    {
        // sorting
        $this->_aSort[0] = oxConfig::getParameter( 'sort' );

        if ( !isset( $this->_aSort[0]) || !$this->_aSort[0] )
            $this->_aSort[0] = $this->_sDefSort;

        $blSortDesc = $this->_blDesc;

        // add sorting
        if ( $this->_aSort && isset($this->_aSort[0] ) ) {

            $blSortDesc = oxConfig::getParameter( 'adminorder' );

            if ( !isset( $blSortDesc ) ) {
                $blSortDesc = $this->_blDesc;
            }

            // only add order by at full sql not for count(*)
            $sSql .= ' order by ';
            $blSep = false;
            $iLang = null;

            $oListObject = $this->_oList->getBaseObject();

            if ( $oListObject->isMultilang() ) {
                $iLang = $oListObject->getLanguage();
            }

            $sTable = $oListObject->getCoreTableName();
            $sViewName = getViewName( $sTable );

            foreach ( $this->_aSort as $orderColumn ) {

                //V oxactive field search always DESC
                if ( $orderColumn == "oxactive" ) {
                    $blSortDesc = true;
                }

                // multilanguage sorting
                if ( $iLang ) {
                    $sObjectField = "{$sTable}__{$orderColumn}";
                    if ( $oListObject instanceof oxI18n ) {
                        if ( $oListObject->isMultilingualField($orderColumn) ) {
                            $orderColumn .= "_{$iLang}";
                        }
                    }
                }

                //add table name to column name if no table name found attached to column name
                if ( strpos( $orderColumn, '.' ) === false ) {
                    $orderColumn = $sViewName . '.' . $orderColumn;
                }

                $sSql  .= ( ( ( $blSep ) ? ', ' : '' ) ) . $orderColumn;
                $blSep  = true;
            }

            if ( $blSortDesc ) {
                $sSql .= ' desc ';
            }
        }

        return $sSql;
    }

    protected function _buildSelectString( $oListObject = null )
    {
        $sSql = '';

        if ( $oListObject ) {
            $oBase = oxNew( 'oxBase' );
            $oBase->init( $oListObject->getCoreTableName() );
            $sSql = $oBase->buildSelectString( null );
        }

        return $sSql;
    }


    protected function _processFilter( $sFieldValue )
    {
        //removing % symbols
        $sFieldValue = preg_replace( "/^%|%$/", "", trim( $sFieldValue ) );
        return preg_replace( "/\s+/", " ", $sFieldValue);
    }

    protected function _buildFilter( $sVal, $blIsSearchValue )
    {
        if ( $blIsSearchValue ) {
            //is search string, using LIKE
            $sQ = " like '%{$sVal}%' ";
        } else {
            //not search string, values must be equal
            $sQ = " = ".oxDb::getDb()->quote( $sVal )." ";
        }

        return $sQ;
    }

    protected function _isSearchValue( $sFieldValue )
    {
        //check if this is search string (conatains % sign at begining and end of string)
        $blIsSearchValue = false;
        if ( preg_match( '/^%/', $sFieldValue ) && preg_match( '/%$/', $sFieldValue ) ) {
            $blIsSearchValue = true;
        }

        //removing % symbols
        return $blIsSearchValue;
    }

    protected function _prepareWhereQuery( $aWhere, $sqlFull )
    {
        if ( count($aWhere) ) {
            $myUtilsString = oxUtilsString::getInstance();
            while ( list($sFieldName, $sFieldValue) = each( $aWhere ) ) {
                $sFieldValue = trim( $sFieldValue );

                //check if this is search string (conatains % sign at begining and end of string)
                $blIsSearchValue = $this->_isSearchValue( $sFieldValue );

                //removing % symbols
                $sFieldValue = $this->_processFilter( $sFieldValue );

                if ( strlen($sFieldValue) ) {
                    $aVal = explode( ' ', $sFieldValue );

                    //for each search field using AND anction
                    $sSqlBoolAction = ' and (';

                    foreach ( $aVal as $sVal) {

                        $sqlFull .= " {$sSqlBoolAction} {$sFieldName} ";

                        //for search in same field for different values using AND
                        $sSqlBoolAction = ' and ';

                        $sqlFull .= $this->_buildFilter( $sVal, $blIsSearchValue );

                        // trying to search spec chars in search value
                        // if found, add cleaned search value to search sql
                        $sUml = $myUtilsString->prepareStrForSearch( $sVal );
                        if ( $sUml ) {
                            $sqlFull .= " or {$sFieldName} ";

                            $sqlFull .= $this->_buildFilter( $sUml, $blIsSearchValue );
                        }
                    }

                    // end for AND action
                    $sqlFull .= ' ) ';
                }
            }
        }

        return $sqlFull;
    }

    protected function _changeselect( $sSql )
    {
        return $sSql;
    }


    public function buildWhere()
    {
        $myConfig = $this->getConfig();
        $this->_aWhere = array();

        $iLanguage = oxLang::getInstance()->getBaseLanguage();
        $aWhere    = oxConfig::getParameter( 'where' );

        if ( !$this->_oList )
            return $this->_aWhere;

        $oListObject = $this->_oList->getBaseObject();
        $sTable = $oListObject->getCoreTableName();
        $sViewName = getViewName( $sTable );

        if ( $this->_oList && is_array( $aWhere ) ) {

            foreach ( $aWhere as $sName => $sValue ) {
                if ( $sValue || '0' === ( string ) $sValue ) {

                    if ( strpos( $sName, '.' ) === false ) {
                        // if no table name attached to field name, add it
                        $sName = "{$sTable}.{$sName}";
                    }


                    // test if field is multilang
                    if ( $oListObject instanceof oxI18n ) {
                        $sFldName = strtolower( preg_replace('/(.+)\./', '', $sName ) );
                        if ( $oListObject->isMultilingualField( $sFldName ) && $iLanguage ) {
                            $sName .=  "_$iLanguage";
                        }
                    }

                    $this->_aWhere[$sName] = "%{$sValue}%";
                }
            }
        }

        return $this->_aWhere;
    }

    protected function _setListNavigationParams()
    {
        $myConfig  = $this->getConfig();

        // list navigation
        $blShowNavigation = false;
        $iAdminListSize = (int) $myConfig->getConfigParam( 'iAdminListSize' );
        $iAdminListSize = $iAdminListSize ? $iAdminListSize : 1;

        if ( $this->_iListSize > $iAdminListSize ) {
            // yes, we need to build the navigation object
            $pagenavigation = new oxStdClass();
            $pagenavigation->pages    = round( ( ( $this->_iListSize - 1 ) / $iAdminListSize ) + 0.5, 0 );
            $pagenavigation->actpage  = ($pagenavigation->actpage > $pagenavigation->pages)? $pagenavigation->pages : round( ( $this->_iCurrListPos / $iAdminListSize ) + 0.5, 0 );
            $pagenavigation->lastlink = ( $pagenavigation->pages - 1 ) * $iAdminListSize;
            $pagenavigation->nextlink = null;
            $pagenavigation->backlink = null;

            $iPos = $this->_iCurrListPos + $iAdminListSize;
            if ( $iPos < $this->_iListSize ) {
                $pagenavigation->nextlink = $iPos = $this->_iCurrListPos + $iAdminListSize;
            }

            if ( ( $this->_iCurrListPos - $iAdminListSize ) >= 0 ) {
                $pagenavigation->backlink = $iPos = $this->_iCurrListPos - $iAdminListSize;
            }

            // calculating list start position
            $iStart = $pagenavigation->actpage - 5;
            $iStart = ( $iStart <= 0 ) ? 1 : $iStart;

            // calculating list end position
            $iEnd = $pagenavigation->actpage + 5;
            $iEnd = ( $iEnd < $iStart + 10) ? $iStart + 10 : $iEnd;
            $iEnd = ( $iEnd > $pagenavigation->pages ) ? $pagenavigation->pages : $iEnd;

            // once again adjusting start pos ..
            $iStart = ( $iEnd - 10 > 0 ) ? $iEnd - 10 : $iStart;
            $iStart = ( $pagenavigation->pages <= 11) ? 1 : $iStart;

            // navigation urls
            for ( $i = $iStart; $i <= $iEnd; $i++ ) {
                $page = new Oxstdclass();
                $page->selected = 0;
                if ( $i == $pagenavigation->actpage ) {
                    $page->selected = 1;
                }
                $pagenavigation->changePage[$i] = $page;
            }

            $this->_aViewData['pagenavi'] = $pagenavigation;

            if ( isset( $this->_iOverPos)) {
                $iPos = $this->_iOverPos;
                $this->_iOverPos = null;
            } else {
                $iPos = oxConfig::getParameter( 'lstrt' );
            }

            if ( !$iPos ) {
                $iPos = 0;
            }

            $this->_aViewData['lstrt']    = $iPos;
            $this->_aViewData['listsize'] = $this->_iListSize;
            $blShowNavigation = true;
        }

        // determine not used space in List
        $iShowListSize  = $this->_iListSize - $this->_iCurrListPos;
        $iAdminListSize = (int) $myConfig->getConfigParam( 'iAdminListSize' );
        $iNotUsed = $iAdminListSize - min( $iShowListSize, $iAdminListSize );
        $iSpace = $iNotUsed * 15;

        if ( !$blShowNavigation ) {
            $iSpace += 20;
        }

        $this->_aViewData['iListFillsize'] = $iSpace;
    }

    protected function _setupNavigation( $sNode )
    {
        // navigation according to class
        if ( $sNode ) {

            $myAdminNavig = $this->getNavigation();

            $sOxId = oxConfig::getParameter( 'oxid' );

            if( $sOxId == -1) {
                //on first call or when pressed creating new item button, reseting active tab
                $iActTab = $this->_iDefEdit;
            } else {
                // active tab
                $iActTab = oxConfig::getParameter( 'actedit' );
                $iActTab = $iActTab ? $iActTab : $this->_iDefEdit;
            }

            // tabs
            $this->_aViewData['editnavi'] = $myAdminNavig->getTabs( $sNode, $iActTab );

            // active tab
            $this->_aViewData['actlocation'] = $myAdminNavig->getActiveTab( $sNode, $iActTab );

            // default tab
            $this->_aViewData['default_edit'] = $myAdminNavig->getActiveTab( $sNode, $this->_iDefEdit );

            // passign active tab number
            $this->_aViewData['actedit'] = $iActTab;
        }
    }
}

---