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;

    protected $_iViewListSize = 0;

    protected $_iDefViewListSize = 50;

    protected function _getViewListSize()
    {
        if ( !$this->_iViewListSize ) {
            $myConfig = $this->getConfig();
            if ( $aProfile = oxSession::getVar( 'profile' ) ) {
                if ( isset( $aProfile[1] ) ) {
                    $myConfig->setConfigParam( 'iAdminListSize', (int) $aProfile[1] );
                }
            }

            $this->_iViewListSize = (int) $myConfig->getConfigParam( 'iAdminListSize' );
            if ( !$this->_iViewListSize ) {
                $this->_iViewListSize = 10;
                $myConfig->setConfigParam( 'iAdminListSize', $this->_iViewListSize );
            }
        }

        return $this->_iViewListSize;
    }

    protected function _getUserDefListSize()
    {
        if ( !$this->_iViewListSize ) {
            if ( ! ($iViewListSize = (int) oxConfig::getParameter( 'viewListSize' ) ) ) {
                $iViewListSize = $this->_iDefViewListSize;
            }
            $this->_iViewListSize = $iViewListSize;
        }

        return $this->_iViewListSize;
    }

    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, $this->_getViewListSize() );

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

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

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

        // setting filter data back to view
        $this->_setFilterParams();

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

    protected function _setFilterParams()
    {
        // build where
        if ( is_array( $aWhere = oxConfig::getParameter( 'where' ) ) ) {

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

            $oSearchKeys = new oxStdClass();
            $sWhereParam = "";

            while ( list( $sName, $sValue ) = each( $aWhere ) ) {
                $sWhereParam .= "&amp;where[".$sName."]=".$sValue;
                $sFieldName = str_replace( getViewName( $sListTable ) . '.', $sListTable . '.', $sName );
                $sFieldName = $myUtils->getArrFldName( $sFieldName );
                $oSearchKeys->$sFieldName = $sValue;
            }

            $this->_aViewData['where'] = $oSearchKeys;

            //#M430: Pagination in admin list loses category parameter
            if ( $sChosenCat  = oxConfig::getParameter( "art_category") ) {
                $sWhereParam .= "&amp;art_category=".$sChosenCat;
            }
            $this->_aViewData['whereparam'] = $sWhereParam;
        }
    }

    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 )
    {
        $oStr = getStr();

        // count SQL
        $sSql = $oStr->preg_replace( '/select .* from/', 'select count(*) from ', $sSql );

        // removing order by
        $sSql = $oStr->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 = $this->_getViewListSize();

        $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 ) ? ', ' : '' ) ) . oxDb::getInstance()->escapeString( $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 )
    {
        $oStr = getStr();

        //removing % symbols
        $sFieldValue = $oStr->preg_replace( "/^%|%$/", "", trim( $sFieldValue ) );
        return $oStr->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;
        $oStr = getStr();
        if ( $oStr->preg_match( '/^%/', $sFieldValue ) && $oStr->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) {
                        // trying to search spec chars in search value
                        // if found, add cleaned search value to search sql
                        $sUml = $myUtilsString->prepareStrForSearch( $sVal );
                        if ($sUml) {
                            $sSqlBoolAction .= '(';
                        }

                        $sFieldName = oxDb::getInstance()->escapeString( $sFieldName );
                        $sqlFull .= " {$sSqlBoolAction} {$sFieldName} ";

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

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

                        if ( $sUml ) {
                            $sqlFull .= " or {$sFieldName} ";

                            $sqlFull .= $this->_buildFilter( $sUml, $blIsSearchValue );
                            $sqlFull .= ')'; // end of OR section
                        }
                    }

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

            $oStr = getStr();
            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( $oStr->preg_replace('/(.+)\./', '', $sName ) );
                        if ( $oListObject->isMultilingualField( $sFldName ) && $iLanguage ) {
                            $sName .=  "_$iLanguage";
                        }
                    }

                    // #M1260: if field is date
                    $sLocalDateFormat = $this->getConfig()->getConfigParam( 'sLocalDateFormat' );
                    if ( $sLocalDateFormat && $sLocalDateFormat != 'ISO') {
                        $sFldName = strtolower( $oStr->preg_replace('/(.+)\./', '', $sName ) );
                        $sLongName = $sTable."__".$sFldName;
                        $sFldType = $oListObject->$sLongName->fldtype;
                        if ( $sFldType && ( $sFldType == "datetime" || $sFldType == "date" ) ) {
                            $sValue = $this->_convertToDBDate( $sValue, $sFldType );
                        }
                    }

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

        return $this->_aWhere;
    }

    protected function _convertToDBDate( $sValue, $sFldType )
    {
        $oConvObject = new oxField();
        $oConvObject->setValue($sValue);
        if ( $sFldType == "datetime" ) {
            if ( strlen($sValue) == 10 || strlen($sValue) == 22 || ( strlen($sValue) == 19 && !stripos( $sValue, "m" ) ) ) {
                oxDb::getInstance()->convertDBDateTime( $oConvObject, true );
            } else {
                if ( strlen($sValue) > 10 ) {
                    return $this->_convertTime( $sValue );
                } else {
                    return $this->_convertDate( $sValue );
                }
            }
        } elseif ( $sFldType == "date" ) {
            if ( strlen($sValue) == 10 ) {
                oxDb::getInstance()->convertDBDate( $oConvObject, true);
            } else {
                return $this->_convertDate( $sValue );
            }
        }
        return $oConvObject->value;
    }

    protected function _convertDate( $sDate )
    {
        // regexps to validate input
        $aDatePatterns = array("/^([0-9]{2})\.([0-9]{4})/" => "EUR2",    // MM.YYYY
                               "/^([0-9]{2})\.([0-9]{2})/" => "EUR1",    // DD.MM
                               "/^([0-9]{2})\/([0-9]{4})/" => "USA2",    // MM.YYYY
                               "/^([0-9]{2})\/([0-9]{2})/" => "USA1"     // DD.MM
                              );

        // date/time formatting rules
        $aDFormats  = array("EUR1" => array(2, 1),
                            "EUR2" => array(2, 1),
                            "USA1" => array(1, 2),
                            "USA2" => array(2, 1)
                           );

        // looking for date field
        $aDateMatches = array();
        $oStr = getStr();
        foreach ( $aDatePatterns as $sPattern => $sType) {
            if ( $oStr->preg_match( $sPattern, $sDate, $aDateMatches)) {
                $sDate = $aDateMatches[$aDFormats[$sType][0]] . "-" . $aDateMatches[$aDFormats[$sType][1]];
                break;
            }
        }

        return $sDate;
    }

    protected function _convertTime( $sFullDate )
    {
        $sDate = substr( $sFullDate, 0, 10 );
        $oConvObject = new oxField();
        $oConvObject->setValue($sDate);
        oxDb::getInstance()->convertDBDate( $oConvObject, true);
        $oStr = getStr();

        // looking for time field
        $sTime = substr( $sFullDate, 11);
        if ( $oStr->preg_match( "/([0-9]{2}):([0-9]{2}) ([AP]{1}[M]{1})$/", $sTime, $aTimeMatches ) ) {
            if ( $aTimeMatches[3] == "PM") {
                $iIntVal = (int) $aTimeMatches[1];
                if ( $iIntVal < 13) {
                    $sTime = ($iIntVal + 12) . ":" . $aTimeMatches[2];
                }
            } else {
                $sTime = $aTimeMatches[1] . ":" . $aTimeMatches[2];
            }
        } elseif ( $oStr->preg_match( "/([0-9]{2}) ([AP]{1}[M]{1})$/", $sTime, $aTimeMatches ) ) {
            if ( $aTimeMatches[2] == "PM") {
                $iIntVal = (int) $aTimeMatches[1];
                if ( $iIntVal < 13) {
                    $sTime = ($iIntVal + 12);
                }
            } else {
                $sTime = $aTimeMatches[1];
            }
        } else {
            $sTime = str_replace(".", ":", $sTime);
        }

        return $oConvObject->value . " " . $sTime;
    }

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

        // list navigation
        $blShowNavigation = false;
        $iAdminListSize = $this->_getViewListSize();
        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 = $this->_getViewListSize();
        $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;
        }
    }

    public function getItemList()
    {
        return $this->_oList;
    }
}