00001 <?php 00002 00006 class List_User extends oxAdminList 00007 { 00014 public function render() 00015 { 00016 $this->_oList = oxNew( "oxlist", "core" ); 00017 $this->_oList->setSqlLimit( 0, 5000 ); 00018 $this->_oList->init( "oxuser" ); 00019 00020 $aWhere = $this->buildWhere(); 00021 00022 $sSql = $this->_buildSelectString( $this->_oList->getBaseObject() ); 00023 $sSql = $this->_prepareWhereQuery( $aWhere, $sSql ); 00024 $sSql = $this->_prepareOrderByQuery( $sSql ); 00025 $sSql = $this->_changeselect( $sSql ); 00026 $this->_oList->selectString( $sSql ); 00027 00028 parent::render(); 00029 00030 $aWhere = oxConfig::getParameter( "where"); 00031 if ( is_array( $aWhere ) ) { 00032 foreach ( $aWhere as $sField => $sValue ) { 00033 $this->_aViewData["where"]->{str_replace( '.', '__', $sField )} = $sValue; 00034 } 00035 } 00036 00037 $this->_aViewData["menustructure"] = $this->getNavigation()->getDomXml()->documentElement->childNodes; 00038 00039 return "list_user.tpl"; 00040 } 00041 00045 protected function _prepareWhereQuery( $aWhere, $sSql ) 00046 { 00047 $sQ = parent::_prepareWhereQuery( $aWhere, $sSql ); 00048 00049 00050 return $sQ; 00051 } 00052 00056 protected function _buildSelectString( $oObject = null ) 00057 { 00058 return 'select oxuser.oxid, oxuser.oxfname, oxuser.oxlname, oxuser.oxusername, oxuser.oxregister from oxuser where 1 '; 00059 } 00060 00068 protected function _prepareOrderByQuery( $sSql = null ) 00069 { 00070 if ( $sSort = oxConfig::getParameter( "sort" ) ) { 00071 $sSql .= " order by $sSort "; 00072 } 00073 00074 return $sSql; 00075 } 00076 }