user_list.php

Go to the documentation of this file.

<?php

class User_List extends oxAdminList
{
    protected $_sListClass = 'oxuser';

    protected $_sDefSortField = "oxusername";

    protected $_sListType = 'oxuserlist';

    protected $_sThisTemplate = 'user_list.tpl';

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

        // set mark for blacklists
        foreach ( $this->getItemList() as $sId => $oUser ) {
            if ( $oUser->inGroup( "oxidblacklist" ) || $oUser->inGroup( "oxidblocked" ) ) {
                $oUser->blacklist = "1";
            }
            $oUser->blPreventDelete = false;
            if ( !$this->_allowAdminEdit( $sId ) ) {
                $oUser->blPreventDelete = true;
            }
        }
    }

    public function deleteEntry()
    {
        if ( $this->_allowAdminEdit( $this->getEditObjectId() ) ) {
            return parent::deleteEntry();
        }
    }

    public function _prepareWhereQuery( $aWhere, $sQueryFull )
    {
        $aNameWhere = null;
        if ( isset( $aWhere['oxuser.oxlname'] ) && ( $sName = $aWhere['oxuser.oxlname'] ) ) {
            // check if this is search string (contains % sign at begining and end of string)
            $blIsSearchValue = $this->_isSearchValue( $sName );
            $sName = $this->_processFilter( $sName );
            $aNameWhere['oxuser.oxfname'] = $aNameWhere['oxuser.oxlname'] = $sName;

            // unsetting..
            unset( $aWhere['oxuser.oxlname'] );
        }
        $sQ = parent::_prepareWhereQuery( $aWhere, $sQueryFull );

        if ( $aNameWhere ) {

            $aVal = explode( ' ', $sName );
            $sQ .= ' and (';
            $sSqlBoolAction = '';
            $myUtilsString = oxRegistry::get("oxUtilsString");

            foreach ( $aNameWhere as $sFieldName => $sValue ) {

                //for each search field using AND anction
                foreach ( $aVal as $sVal ) {

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

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

                    $sQ .= $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 ) {
                        $sQ .= " or {$sFieldName} ";
                        $sQ .= $this->_buildFilter( $sUml, $blIsSearchValue );
                    }
                }
            }

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


        return $sQ;
    }

}