user_list.php

Go to the documentation of this file.

<?php

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

    protected $_sDefSort = "oxuser.oxusername";

    protected $_sListType = 'oxuserlist';

    protected $_sThisTemplate = 'user_list.tpl';

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

        // set mark for blacklists
        foreach ( $this->_oList as $name => $value ) {
            if ( $value->inGroup( "oxidblacklist") || $value->inGroup( "oxidblocked")) {
                $value->blacklist = "1";
                $this->_oList[$name] = $value;
            }
            $this->_oList[$name]->blPreventDelete = false;
            if (!$this->_allowAdminEdit($name)) {
                $this->_oList[$name]->blPreventDelete = true;
            }
        }
    }

    public function deleteEntry()
    {
        $soxId = oxConfig::getParameter( "oxid");
        if (!$this->_allowAdminEdit($soxId))
            return;

        return parent::deleteEntry();
    }

    public function _prepareWhereQuery( $aWhere, $sqlFull )
    {
        $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, $sqlFull );

        if ( $aNameWhere ) {

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

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

}

---