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 render()
    {
        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;
            }
        }

        return parent::render();
    }

    public function deleteEntry()
    {
        if ($this->_allowAdminEdit($this->getEditObjectId())) {
            $this->_oList = null;
            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;
    }

}