Changeset 3864

Timestamp:

06/11/06 17:56:56 (3 years ago)

Author:

ryan

Message:

WP_User_Search from Mark Jaquith. #2793

Files:

• trunk/wp-admin/users.php (modified) (7 diffs)

trunk/wp-admin/users.php

@@ -20 +20 @@
-    $redirect = 'users.php';
-}
+
+
+// WP_User_Search class
+// by Mark Jaquith
+
+
+class WP_User_Search {
+    var $results;
+    var $search_term;
+    var $page;
+    var $raw_page;
+    var $users_per_page = 50;
+    var $first_user;
+    var $last_user;
+    var $query_limit;
+    var $query_from_where;
+    var $total_users_for_query = 0;
+    var $too_many_total_users = false;
+    var $search_errors;
+
+    function WP_User_Search ($search_term = '', $page = '') { // constructor
+        $this->search_term = $search_term;
+        $this->raw_page = ( '' == $page ) ? false : (int) $page;
+        $this->page = (int) ( '' == $page ) ? 1 : $page;
+
+        $this->prepare_query();
+        $this->query();
+        $this->prepare_vars_for_template_usage();
+        $this->do_paging();
+    }
+
+    function prepare_query() {
+        global $wpdb;
+        $this->first_user = ($this->page - 1) * $this->users_per_page;
+        $this->query_limit = 'LIMIT ' . $this->first_user . ',' . $this->users_per_page;
+        if ( $this->search_term ) {
+            $searches = array();
+            $search_sql = 'AND (';
+            foreach ( array('user_login', 'user_nicename', 'user_email', 'user_url', 'display_name') as $col )
+                $searches[] = $col . " LIKE '%$this->search_term%'";
+            $search_sql .= implode(' OR ', $searches);
+            $search_sql .= ')';
+        }
+        $this->query_from_where = "FROM $wpdb->users WHERE 1=1 $search_sql";
+
+        if ( !$_GET['update'] && !$this->search_term && !$this->raw_page && $wpdb->get_var("SELECT COUNT(ID) FROM $wpdb->users") > $this->users_per_page )
+            $this->too_many_total_users = sprintf(__('Because this blog has more than %s users, they cannot all be shown on one page.  Use the paging or search functionality in order to find the user you want to edit.'), $this->users_per_page);
+    }
+
+    function query() {
+        global $wpdb;
+        $this->results = $wpdb->get_col('SELECT ID ' . $this->query_from_where . $this->query_limit);
+
+        if ( $this->results )
+            $this->total_users_for_query = $wpdb->get_var('SELECT COUNT(ID) ' . $this->query_from_where); // no limit
+        else
+            $this->search_errors = new WP_Error('no_matching_users_found', __('No matching users were found!'));
+    }
+
+    function prepare_vars_for_template_usage() {
+        $this->search_term = stripslashes($this->search_term); // done with DB, from now on we want slashes gone
+    }
+
+    function do_paging() {
+        if ( $this->total_users_for_query > $this->users_per_page ) { // have to page the results
+            $prev_page = ( $this->page > 1) ? true : false;
+            $next_page = ( ($this->page * $this->users_per_page) < $this->total_users_for_query ) ? true : false;
+            $this->paging_text = '';
+            if ( $prev_page )
+                $this->paging_text .= '<p class="alignleft"><a href="' . add_query_arg(array('usersearch' => $this->search_term, 'userspage' => $this->page - 1), 'users.php?') . '">&laquo; Previous Page</a></p>';
+            if ( $next_page )
+                $this->paging_text .= '<p class="alignright"><a href="' . add_query_arg(array('usersearch' => $this->search_term, 'userspage' => $this->page + 1), 'users.php?') . '">Next Page &raquo;</a></p>';
+            if ( $prev_page || $next_page )
+                $this->paging_text .= '<br style="clear:both" />';
+        }
+    }
+
+    function get_results() {
+        return $this->results;
+    }
+
+    function page_links() {
+        echo $this->paging_text;
+    }
+
+    function results_are_paged() {
+        if ( $this->paging_text )
+            return true;
+        return false;
+    }
+
+    function is_search() {
+        if ( $this->search_term )
+            return true;
+        return false;
+    }
+}
+
-
-switch ($action) {
@@ -173 +271 @@
-    include('admin-header.php');
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
-
-    // Make the user objects
-(array) $userids
+$wp_user_search->get_results()
-        $tmp_user = new WP_User($userid);
-        $roles = $tmp_user->roles;
@@ -276 +327 @@
-<?php endif; ?>
-
-too_many
+wp_user_search->too_many_total
-    <div id="message" class="updated">
-too_many
+wp_user_search->too_many_total
-    </div>
-<?php endif; ?>
@@ -284 +335 @@
-<div class="wrap">
-
-search_term
-
+wp_user_search->is_search()
+wp_user_search->
-    <?php else : ?>
-        <h2><?php _e('User List by Role'); ?></h2>
@@ -291 +342 @@
-
-    <form action="" method="get" name="search" id="search">
-
+wp_user_search->
-    </form>
-
-
+wp_user_search->
-        <div class="error">
-            <ul>
-            <?php
-
+wp_user_search->
-                    echo "<li>$message</li>";
-            ?>
@@ -306 +357 @@
-
-
-userids
-
-search_term
+wp_user_search->get_results()
+
+wp_user_search->is_search()
-        <p><a href="users.php"><?php _e('&laquo; Back to All Users'); ?></a></p>
-    <?php endif; ?>
-
-starton + 1, min($starton + $users_per_page, $total_users_for_this_query), $total_users_for_this
-
-paging_text
-echo $paging_text
+wp_user_search->first_user + 1, min($wp_user_search->first_user + $wp_user_search->users_per_page, $wp_user_search->total_users_for_query), $wp_user_search->total_users_for
+
+wp_user_search->results_are_paged()
+$wp_user_search->page_links()
-    <?php endif; ?>
-
@@ -354 +405 @@
-</table>
-
-paging_text
-echo $paging_text
+wp_user_search->results_are_paged()
+$wp_user_search->page_links()
-<?php endif; ?>
-