'user', //singular name of the listed records 'plural' => 'users', //plural name of the listed records 'ajax' => false //does this table support ajax? )); } /** ************************************************************************ * Recommended. This method is called when the parent class can't find a method * specifically build for a given column. Generally, it's recommended to include * one method for each column you want to render, keeping your package class * neat and organized. For example, if the class needs to process a column * named 'title', it would first see if a method named $this->column_title() * exists - if it does, that method will be used. If it doesn't, this one will * be used. Generally, you should try to use custom column methods as much as * possible. * * Since we have defined a column_title() method later on, this method doesn't * need to concern itself with any column with a name of 'title'. Instead, it * needs to handle everything else. * * For more detailed insight into how columns are handled, take a look at * WP_List_Table::single_row_columns() * * @param array $item A singular item (one full row's worth of data) * @param array $column_name The name/slug of the column to be processed * @return string Text or HTML to be placed inside the column **************************************************************************/ public function column_default($item, $column_name) { return $item->{$column_name}; } /** ************************************************************************ * Recommended. This is a custom column method and is responsible for what * is rendered in any column with a name/slug of 'title'. Every time the class * needs to render a column, it first looks for a method named * column_{$column_title} - if it exists, that method is run. If it doesn't * exist, column_default() is called instead. * * This example also illustrates how to implement rollover actions. Actions * should be an associative array formatted as 'slug'=>'link html' - and you * will need to generate the URLs yourself. You could even ensure the links * * * @see WP_List_Table::::single_row_columns() * @param array $item A singular item (one full row's worth of data) * @return string Text to be placed inside the column (movie title only) **************************************************************************/ public function column_user_login($item) { global $pagenow; //Build row actions $actions = array( 'edit' => sprintf('Edit', $item->ID), 'delete' => sprintf('Delete', 'delete', $item->ID, wp_create_nonce('bulk-users') ) ); return sprintf('%1$s%3$s', /*$1%s*/ $item->user_login, /*$2%s*/ $item->ID, /*$3%s*/ $this->row_actions($actions) ); } /** ************************************************************************ * REQUIRED if displaying checkboxes or using bulk actions! The 'cb' column * is given special treatment when columns are processed. It ALWAYS needs to * have it's own method. * * @see WP_List_Table::::single_row_columns() * @param array $item A singular item (one full row's worth of data) * @return string Text to be placed inside the column (movie title only) **************************************************************************/ public function column_cb($item) { return sprintf( '', /*$1%s*/ $this->_args['plural'], //Let's simply repurpose the table's singular label ("movie") /*$2%s*/ $item->ID //The value of the checkbox should be the record's id ); } public function column_post_count($item) { $text = $item->post_count; if ($text > 0) { $text = sprintf('%1$s', $item->post_count, $item->ID); } return $text; } /** ************************************************************************ * REQUIRED! This method dictates the table's columns and titles. This should * return an array where the key is the column slug (and class) and the value * is the column's title text. If you need a checkbox for bulk actions, refer * to the $columns array below. * * The 'cb' column is treated differently than the rest. If including a checkbox * column in your table you must create a column_cb() method. If you don't need * bulk actions or checkboxes, simply leave the 'cb' entry out of your array. * * @see WP_List_Table::::single_row_columns() * @return array An associative array containing column information: 'slugs'=>'Visible Titles' **************************************************************************/ public function get_columns() { $columns = array( 'cb' => '', //Render a checkbox instead of text 'user_login' => 'Username', 'display_name' => 'Name', 'page_visibility' => 'Page visibility', 'post_count' => 'Posts', 'comment_count' => 'Comments', 'recent_post_published' => 'Recent post published' ); return $columns; } /** ************************************************************************ * Optional. If you want one or more columns to be sortable (ASC/DESC toggle), * you will need to register it here. This should return an array where the * key is the column that needs to be sortable, and the value is db column to * sort by. Often, the key and value will be the same, but this is not always * the case (as the value is a column name from the database, not the list table). * * This method merely defines which columns should be sortable and makes them * clickable - it does not handle the actual sorting. You still need to detect * the ORDERBY and ORDER querystring variables within prepare_items() and sort * your data accordingly (usually by modifying your query). * * @return array An associative array containing all the columns that should be sortable: 'slugs'=>array('data_values',bool) **************************************************************************/ public function get_sortable_columns() { $sortable_columns = array( 'user_login' => array('user_login', false), //true means it's already sorted 'display_name' => array('display_name', false), 'page_visibility' => array('page_visibility', false), 'post_count' => array('post_count', false), 'comment_count' => array('comment_count', false), 'recent_post_published' => array('recent_post_published', false) ); return $sortable_columns; } /** ************************************************************************ * Optional. If you need to include bulk actions in your list table, this is * the place to define them. Bulk actions are an associative array in the format * 'slug'=>'Visible Title' * * If this method returns an empty value, no bulk action will be rendered. If * you specify any bulk actions, the bulk actions box will be rendered with * the table automatically on display(). * * Also note that list tables are not automatically wrapped in
elements, * so you will need to create those manually in order for bulk actions to public function. * * @return array An associative array containing all the bulk actions: 'slugs'=>'Visible Titles' **************************************************************************/ public function get_bulk_actions() { $actions = array( 'delete' => 'Delete' ); return $actions; } /** ************************************************************************ * Optional. You can handle your bulk actions anywhere or anyhow you prefer. * For this example package, we will handle it in the class to keep things * clean and organized. * * @see $this->prepare_items() **************************************************************************/ public function process_bulk_action() { //Detect when a bulk action is being triggered... if ('delete' === $this->current_action()) { } } /** ************************************************************************ * REQUIRED! This is where you prepare your data for display. This method will * usually be used to query the database, sort and filter the data, and generally * get it ready to be displayed. At a minimum, we should set $this->items and * $this->set_pagination_args(), although the following properties and methods * are frequently interacted with here... * * @global WPDB $wpdb * @uses $this->_column_headers * @uses $this->items * @uses $this->get_columns() * @uses $this->get_sortable_columns() * @uses $this->get_pagenum() * @uses $this->set_pagination_args() **************************************************************************/ public function prepare_items() { global $wpdb; //This is used only if making any database queries /** * First, lets decide how many records per page to show */ $per_page = 10; $columns = $this->get_columns(); $hidden = array(); $sortable = $this->get_sortable_columns(); /** * REQUIRED. Finally, we build an array to be used by the class for column * headers. The $this->_column_headers property takes an array which contains * 3 other arrays. One for all columns, one for hidden columns, and one * for sortable columns. */ $this->_column_headers = array($columns, $hidden, $sortable); $data = get_users('role=author'); $args = array( 'public' => true, '_builtin' => false ); // Adding `post_count`, `comment_count` property array_walk($data, function($d) { $_link_to_author_name = get_user_meta($d->ID, 'abp_author_show_link', true); $_global_link_to_author_name = get_option('abp_sf_all_author_link'); $post_count = count_user_posts($d->ID); $comment_count = abp_count_user_all_post_comments($d->ID); $recent_post_published = abp_get_most_recent_post_of_user($d->ID); $recent_post_published = (isset($recent_post_published['post_gmt_ts'])) ? 'Published
' . date('Y/m/d', $recent_post_published['post_gmt_ts']) : 'None'; $d->page_visibility = (!empty($_global_link_to_author_name) || !empty($_link_to_author_name)) ? 'Yes' : 'No'; $d->post_count = $post_count; $d->comment_count = $comment_count; $d->recent_post_published = $recent_post_published; }); function usort_reorder($a, $b) { $orderby = (!empty($_REQUEST['orderby'])) ? $_REQUEST['orderby'] : 'user_login'; //If no sort, default to title $order = (!empty($_REQUEST['order'])) ? $_REQUEST['order'] : 'asc'; //If no order, default to asc $result = strcmp($a->{$orderby}, $b->{$orderby}); //Determine sort order return ($order === 'asc') ? $result : -$result; //Send final sort direction to usort } usort($data, 'usort_reorder'); /** * REQUIRED for pagination. Let's figure out what page the user is currently * looking at. We'll need this later, so you should always include it in * your own package classes. */ $current_page = $this->get_pagenum(); $total_items = count($data); /** * The WP_List_Table class does not handle pagination for us, so we need * to ensure that the data is trimmed to only the current page. We can use * array_slice() to */ $data = array_slice($data, (($current_page - 1) * $per_page), $per_page); /** * REQUIRED. Now we can add our *sorted* data to the items property, where * it can be used by the rest of the class. */ $this->items = $data; /** * REQUIRED. We also have to register our pagination options & calculations. */ $this->set_pagination_args(array( 'total_items' => $total_items, //WE have to calculate the total number of items 'per_page' => $per_page, //WE have to determine how many items to show on a page 'total_pages' => ceil($total_items / $per_page) //WE have to calculate the total number of pages )); } }