限制按最新帖子功能对用户进行排序后返回的用户数

时间：2017-05-31 作者：user7835952

我在此使用此线程中的以下代码片段：Order the users by the date of their latest post . 但我需要将“number”和“offset”传递到$args中，以分页并限制返回的用户数。当我将这些参数传递到get\\u users\\u ordered\\u by\\u post\\u date（）中时，该函数不再按用户最新帖子的日期对用户进行排序。任何解决方案，使这项工作将不胜感激！

    function get_users_ordered_by_post_date($args = \'\') {
// Prepare arguments
if (is_string($args) && \'\' !== $args)
    parse_str($args, $args);
$asc = (isset($args[\'order\']) && \'ASC\' === strtoupper($args[\'order\']));
unset($args[\'orderby\']);
unset($args[\'order\']);

// Get ALL users
$users = get_users($args);
$post_dates = array();
if ($users) {
    // For EACH user ...
    foreach ($users as $user) {
        $ID = $user->ID;

        // ... get ALL posts (per default sorted by post_date), ...
        $posts = get_posts(\'author=\'.$ID);
        $post_dates[$ID] = \'\';

        // ... then use only the first (= newest) post
        if ($posts) $post_dates[$ID] = $posts[0]->post_date;
    }
}

// Sort dates (according to order), ...
if (! $asc)
    arsort($post_dates);

// ... then set up user array
$users = array();
foreach ($post_dates as $key => $value) {
    // $user = get_userdata($key);
    // $users[] = $user->ID;
    $users[] = get_userdata($key);
}
return $users;
    }
******更新：我刚刚意识到上面的功能对我的情况不起作用，我不想限制用户数量，然后只对他们进行排序。所以这个函数可能不是我想要的解决方案。我要找的是在首页上显示6个用户（按其最新帖子排序），在显示所有用户的页面上，对该页面分页。但我不知道如何做到这一点，因此我将用我当前的代码更新这个问题：

//display each author\'s name, avatar and their one latest post
add_action (\'genesis_before_content_sidebar_wrap\', \'pc_author_posts\', 15);
//NEED A FUNCTION THAT SORT USERS BY THEIR LATEST POSTS\' DATES HERE


function pc_author_posts() {
if( (is_front_page()) | (is_page(\'latest-posts-from-our-readers\')) ) {
?>
<div class="pc-author-outer">
<?php
if(is_front_page()) {
echo \'<div class="pc-author-heading-line">\';
echo \'<h4 class="pc-author-heading">Latest Posts From Our Readers</h4>\';
echo \'
<h6 class="pc-author-more"><a href="http://localhost/.../latest-posts-from-our-readers/" alt="See all latest posts from all of our readers">
More >></a></h6>\';
echo \'</div>\';
$authors=get_users(\'number=6\');
}
elseif(is_page(\'all-latest-posts\')) {
$number = 9;
$paged = (get_query_var(\'paged\')) ? get_query_var(\'paged\') : 1;
$offset = ($paged - 1) * $number;
$usersnumber=get_users();
$authors= get_users(\'offset=\'.$offset.\'&number=\'.$number.\'&order=DESC\');
$total_users = count($usersnumber);
$total_query = count($query);
$total_pages = intval($total_users / $number) + 1;
}
$i=0;
//get all users list
foreach($authors as $author){
$authorList[$i][\'id\']=$author->data->ID;
$authorList[$i][\'name\']=$author->data->display_name;
$authorList[$i][\'url\']=get_author_posts_url($author->ID);
$authorList[$i][\'avatar\'] = get_avatar($author->ID, 70);
$i++;
}
?>
<ul class="pc-authors-wrap" id="pc-authors-wrap">
<?php
foreach($authorList as $author){
$args=array(
\'showposts\'=>1,
\'author\'=>$author[\'id\'],
);
$query = new WP_Query($args);
if($query->have_posts() ) {
while ($query->have_posts()){
$query->the_post();
?>

<li class="pc-authors one-third">
<!--<div class="pc-post-line"> -->

<div class="pc-author-line">
<h2 class="pc-author-title"><a href="<?php echo get_permalink(); ?>"> <?php echo get_the_title(); ?></a></h2>
<div class="pc-rating">
<?php
$pid = $post->ID;
if(function_exists("kk_star_ratings")) : echo kk_star_ratings($pid);
endif; 
?>
</div>

<div class="pc-author-avatar"><a href="<?php echo $author[\'url\']; ?>"><?php echo $author[\'avatar\']; ?></a></div>

<small><a href="<?php echo $author[\'url\']; ?>"><?php echo $author[\'name\']; ?></a></small>
<p><a href="<?php echo get_permalink(); ?>"> <?php echo excerpt(40); ?> ... [read more]</a></p>
</div>
<a class="pc-author-img" href="<?php echo get_permalink(); ?>"><?php echo the_post_thumbnail(\'post-small\'); ?></a>

</li>
<?php
}
}
wp_reset_postdata();
}
?>
<li class="pc-authors clearfix"></li>
</ul>
<?php
if ($total_users > $total_query) {
echo \'<div id="pagination" class="author-pagination">\';
$current_page = max(1, get_query_var(\'paged\'));
echo paginate_links(array(
\'base\' => get_pagenum_link(1) . \'%_%\',
\'format\' => \'page/%#%/\',
\'current\' => $current_page,
\'total\' => $total_pages,
\'prev_next\'    => true,
\'prev_text\'          => __(\'« Previous Page\'),
\'next_text\'          => __(\'Next Page »\'),
\'type\'         => \'plain\',
));
echo \'</div>\';
?>
</div>
<?php
}
?>
<?php
}
}
****第二次更新：成功！我正在使用@inarilo的代码，并对代码进行了如下修改：

//display each author\'s name, avatar and their one latest post
add_action (\'genesis_before_content_sidebar_wrap\', \'pc_author_posts\', 15);
//SORTING FUNCTION
function get_users_ordered_by_post_date($offs=0, $lim=10, $ord=\'DESC\') {
  global $wpdb;
  if(!is_numeric($offs) || !is_numeric($lim) || !in_array(strtoupper($ord), array(\'ASC\',\'DESC\'))) return array();
  $q = "SELECT DISTINCT post_author FROM {$wpdb->posts} WHERE post_status = \'publish\' AND post_type = \'post\' ORDER BY post_date {$ord} LIMIT {$offs}, {$lim}";
  $users = $wpdb->get_results($q, ARRAY_N);
  foreach($users as $i => $u) $users[$i] = get_userdata($users[$i][0]);
  return $users;
}

function pc_author_posts() {
if( (is_front_page()) | (is_page(\'all-latest-posts\')) ) {
?>
<div class="pc-author-outer">
<?php
if(is_front_page()) {
echo \'<div class="pc-author-heading-line">\';
echo \'<h4 class="pc-author-heading">All Latest Posts</h4>\';
echo \'
<h6 class="pc-author-more"><a href="http://localhost/.../latest-posts-from-our-readers/" alt="See all latest posts">
More >></a></h6>\';
echo \'</div>\';

$authors = get_users_ordered_by_post_date(0,6);

}
elseif(is_page(\'latest-posts-from-our-readers\')) {
$lim = 9;
$paged = (get_query_var(\'paged\')) ? get_query_var(\'paged\') : 1;
$offs = ($paged - 1) * $lim;
$users= get_users_ordered_by_post_date(0,9999);
$authors= get_users_ordered_by_post_date($offs,$lim);
$total_users = count($users);
$total_query = count($query);
$total_pages = intval($total_users / $lim) + 1;
}
$i=0;
//get all users list
foreach($authors as $author){
$authorList[$i][\'id\']=$author->data->ID;
$authorList[$i][\'name\']=$author->data->display_name;
$authorList[$i][\'url\']=get_author_posts_url($author->ID);
$authorList[$i][\'avatar\'] = get_avatar($author->ID, 70);
$i++;
}
?>
<ul class="pc-authors-wrap" id="pc-authors-wrap">
<?php
foreach($authorList as $author){
$args=array(
\'showposts\'=>1,
\'author\'=>$author[\'id\'],
);
$query = new WP_Query($args);
if($query->have_posts() ) {
while ($query->have_posts()){
$query->the_post();
?>

<li class="pc-authors one-third">
<!--<div class="pc-post-line"> -->

<div class="pc-author-line">
<h2 class="pc-author-title"><a href="<?php echo get_permalink(); ?>"> <?php echo get_the_title(); ?></a></h2>
<div class="pc-rating">
<?php
$pid = $post->ID;
if(function_exists("kk_star_ratings")) : echo kk_star_ratings($pid);
endif; 
?>
</div>

<div class="pc-author-avatar"><a href="<?php echo $author[\'url\']; ?>"><?php echo $author[\'avatar\']; ?></a></div>

<small><a href="<?php echo $author[\'url\']; ?>"><?php echo $author[\'name\']; ?></a></small>
<p><a href="<?php echo get_permalink(); ?>"> <?php echo excerpt(40); ?> ... [read more]</a></p>
</div>
<a class="pc-author-img" href="<?php echo get_permalink(); ?>"><?php echo the_post_thumbnail(\'post-small\'); ?></a>

</li>
<?php
}
}
wp_reset_postdata();
}
?>
<li class="pc-authors clearfix"></li>
</ul>
<?php
if ($total_users > $total_query) {
echo \'<div id="pagination" class="author-pagination">\';
$current_page = max(1, get_query_var(\'paged\'));
echo paginate_links(array(
\'base\' => get_pagenum_link(1) . \'%_%\',
\'format\' => \'page/%#%/\',
\'current\' => $current_page,
\'total\' => $total_pages,
\'prev_next\'    => true,
\'prev_text\'          => __(\'« Previous Page\'),
\'next_text\'          => __(\'Next Page »\'),
\'type\'         => \'plain\',
));
echo \'</div>\';
?>
</div>
<?php
}
?>
<?php
}
}

1 个回复
最合适的回答,由SO网友:inarilo 整理而成

function get_users_ordered_by_post_date($offs=0, $lim=10, $ord=\'DESC\') {
  global $wpdb;
  if(!is_numeric($offs) || !is_numeric($lim) || !in_array(strtoupper($ord), array(\'ASC\',\'DESC\'))) return array();
  $q = "SELECT DISTINCT post_author FROM {$wpdb->posts} WHERE post_status = \'publish\' AND post_type = \'post\' ORDER BY post_date {$ord} LIMIT {$offs}, {$lim}";
  $users = $wpdb->get_results($q, ARRAY_N);
  foreach($users as $i => $u) $users[$i] = get_userdata($users[$i][0]);
  return $users;
}
ARRAY\\N将返回类型设置为非关联数组的数组。

结束
标签： users   小码农  

相关推荐

与wp_USERS一起查询wp_usermeta

我想使用WordPress查询功能，而不需要外部插件。以下是我目前掌握的情况：add_filter(\'user_search_columns\', \'user_search_columns_bd\' , 10, 3); function user_search_columns_bd($search_columns, $search, $this){ if(!in_array(\'display_name\', $search_columns)){