GC_User_Search
最后更新于:2021-11-26 02:26:18
GC_User_SearchGeChiUI User Search class.
源文件
文件: gc-admin/includes/deprecated.php
class GC_User_Search {
/**
* {@internal Missing Description}}
*
* @since 2.1.0
* @access private
* @var mixed
*/
var $results;
/**
* {@internal Missing Description}}
*
* @since 2.1.0
* @access private
* @var string
*/
var $search_term;
/**
* Page number.
*
* @since 2.1.0
* @access private
* @var int
*/
var $page;
/**
* Role name that users have.
*
* @since 2.5.0
* @access private
* @var string
*/
var $role;
/**
* Raw page number.
*
* @since 2.1.0
* @access private
* @var int|bool
*/
var $raw_page;
/**
* Amount of users to display per page.
*
* @since 2.1.0
* @access public
* @var int
*/
var $users_per_page = 50;
/**
* {@internal Missing Description}}
*
* @since 2.1.0
* @access private
* @var int
*/
var $first_user;
/**
* {@internal Missing Description}}
*
* @since 2.1.0
* @access private
* @var int
*/
var $last_user;
/**
* {@internal Missing Description}}
*
* @since 2.1.0
* @access private
* @var string
*/
var $query_limit;
/**
* {@internal Missing Description}}
*
* @since 3.0.0
* @access private
* @var string
*/
var $query_orderby;
/**
* {@internal Missing Description}}
*
* @since 3.0.0
* @access private
* @var string
*/
var $query_from;
/**
* {@internal Missing Description}}
*
* @since 3.0.0
* @access private
* @var string
*/
var $query_where;
/**
* {@internal Missing Description}}
*
* @since 2.1.0
* @access private
* @var int
*/
var $total_users_for_query = 0;
/**
* {@internal Missing Description}}
*
* @since 2.1.0
* @access private
* @var bool
*/
var $too_many_total_users = false;
/**
* {@internal Missing Description}}
*
* @since 2.1.0
* @access private
* @var GC_Error
*/
var $search_errors;
/**
* {@internal Missing Description}}
*
* @since 2.7.0
* @access private
* @var string
*/
var $paging_text;
/**
* PHP5 Constructor - Sets up the object properties.
*
* @since 2.1.0
*
* @param string $search_term Search terms string.
* @param int $page Optional. Page ID.
* @param string $role Role name.
* @return GC_User_Search
*/
function __construct( $search_term = '', $page = '', $role = '' ) {
_deprecated_function( __FUNCTION__, '3.1.0', 'GC_User_Query' );
$this->search_term = gc_unslash( $search_term );
$this->raw_page = ( '' == $page ) ? false : (int) $page;
$this->page = ( '' == $page ) ? 1 : (int) $page;
$this->role = $role;
$this->prepare_query();
$this->query();
$this->do_paging();
}
/**
* PHP4 Constructor - Sets up the object properties.
*
* @since 2.1.0
*
* @param string $search_term Search terms string.
* @param int $page Optional. Page ID.
* @param string $role Role name.
* @return GC_User_Search
*/
public function GC_User_Search( $search_term = '', $page = '', $role = '' ) {
self::__construct( $search_term, $page, $role );
}
/**
* Prepares the user search query (legacy).
*
* @since 2.1.0
* @access public
*/
public function prepare_query() {
global $gcdb;
$this->first_user = ($this->page - 1) * $this->users_per_page;
$this->query_limit = $gcdb->prepare(" LIMIT %d, %d", $this->first_user, $this->users_per_page);
$this->query_orderby = ' ORDER BY user_login';
$search_sql = '';
if ( $this->search_term ) {
$searches = array();
$search_sql = 'AND (';
foreach ( array('user_login', 'user_nicename', 'user_email', 'user_url', 'display_name') as $col )
$searches[] = $gcdb->prepare( $col . ' LIKE %s', '%' . like_escape($this->search_term) . '%' );
$search_sql .= implode(' OR ', $searches);
$search_sql .= ')';
}
$this->query_from = " FROM $gcdb->users";
$this->query_where = " WHERE 1=1 $search_sql";
if ( $this->role ) {
$this->query_from .= " INNER JOIN $gcdb->usermeta ON $gcdb->users.ID = $gcdb->usermeta.user_id";
$this->query_where .= $gcdb->prepare(" AND $gcdb->usermeta.meta_key = '{$gcdb->prefix}capabilities' AND $gcdb->usermeta.meta_value LIKE %s", '%' . $this->role . '%');
} elseif ( is_multisite() ) {
$level_key = $gcdb->prefix . 'capabilities'; // GCMU site admins don't have user_levels.
$this->query_from .= ", $gcdb->usermeta";
$this->query_where .= " AND $gcdb->users.ID = $gcdb->usermeta.user_id AND meta_key = '{$level_key}'";
}
do_action_ref_array( 'pre_user_search', array( &$this ) );
}
/**
* Executes the user search query.
*
* @since 2.1.0
* @access public
*/
public function query() {
global $gcdb;
$this->results = $gcdb->get_col("SELECT DISTINCT($gcdb->users.ID)" . $this->query_from . $this->query_where . $this->query_orderby . $this->query_limit);
if ( $this->results )
$this->total_users_for_query = $gcdb->get_var("SELECT COUNT(DISTINCT($gcdb->users.ID))" . $this->query_from . $this->query_where); // No limit.
else
$this->search_errors = new GC_Error('no_matching_users_found', __('No users found.'));
}
/**
* Prepares variables for use in templates.
*
* @since 2.1.0
* @access public
*/
function prepare_vars_for_template_usage() {}
/**
* Handles paging for the user search query.
*
* @since 2.1.0
* @access public
*/
public function do_paging() {
if ( $this->total_users_for_query > $this->users_per_page ) { // Have to page the results.
$args = array();
if ( ! empty($this->search_term) )
$args['usersearch'] = urlencode($this->search_term);
if ( ! empty($this->role) )
$args['role'] = urlencode($this->role);
$this->paging_text = paginate_links( array(
'total' => ceil($this->total_users_for_query / $this->users_per_page),
'current' => $this->page,
'base' => 'users.php?%_%',
'format' => 'userspage=%#%',
'add_args' => $args
) );
if ( $this->paging_text ) {
$this->paging_text = sprintf(
/* translators: 1: Starting number of users on the current page, 2: Ending number of users, 3: Total number of users. */
'<span class="displaying-num">' . __( 'Displaying %1$s–%2$s of %3$s' ) . '</span>%s',
number_format_i18n( ( $this->page - 1 ) * $this->users_per_page + 1 ),
number_format_i18n( min( $this->page * $this->users_per_page, $this->total_users_for_query ) ),
number_format_i18n( $this->total_users_for_query ),
$this->paging_text
);
}
}
}
/**
* Retrieves the user search query results.
*
* @since 2.1.0
* @access public
*
* @return array
*/
public function get_results() {
return (array) $this->results;
}
/**
* Displaying paging text.
*
* @see do_paging() Builds paging text.
*
* @since 2.1.0
* @access public
*/
function page_links() {
echo $this->paging_text;
}
/**
* Whether paging is enabled.
*
* @see do_paging() Builds paging text.
*
* @since 2.1.0
* @access public
*
* @return bool
*/
function results_are_paged() {
if ( $this->paging_text )
return true;
return false;
}
/**
* Whether there are search terms.
*
* @since 2.1.0
* @access public
*
* @return bool
*/
function is_search() {
if ( $this->search_term )
return true;
return false;
}
}