使用时如何按姓氏ASC列出用户WP_User_Query?
有一个orderby参数，但在core中，它不接受对我的用户元进行排序。有人知道如何扩展WP以允许按姓氏排序吗？
在WP_USER_QUERY中按姓氏列出用户
3 个回复
最合适的回答,由SO网友:magi182 整理而成
有一个better way to do this as of Wordpress version 3.7. 使用Wordpress属性meta\\u键选择姓氏属性，然后按升序选择orderby=>meta\\u值。
<?php
$args = array(
\'meta_key\' => \'last_name\',
\'orderby\' => \'meta_value\',
\'order\' => \'ASC\'
);
$user_query = new WP_User_Query( $args );
if ( ! empty( $user_query->results ) ) {
foreach ( $user_query->results as $author ) {
// Line below display the author data.
// Use print_r($author); to display the complete author object.
?>
<a href="<?php echo get_author_posts_url($author->ID); ?>" class="author"><?php echo get_avatar($author->ID, 96); ?><?php echo $author->display_name; ?></a>
<?php
}
}
?>
SO网友:Scott
我自己做了一些东西：
Page template file:
<?php
$paged = (get_query_var(\'paged\')) ? get_query_var(\'paged\') : 1;
$paged -= 1;
$limit = 20;
$offset = $paged * $limit;
$args = array(
\'number\' => $limit,
\'offset\' => $offset,
);
// Create the WP_User_Query object
global $wp_query;
$wp_query = new WP_User_Query($args);
// Get the results
$authors = $wp_query->get_results();
if($authors): ?>
<div id="staffmembers" class="clearfix">
<?php foreach($authors as $author) : ?>
<a href="<?php echo get_author_posts_url($author->ID); ?>" class="author"><?php echo get_avatar($author->ID, 96); ?><?php echo $author->display_name; ?></a>
<?php endforeach; ?>
</div>
<?php else: ?>
<div class="post">
<p>Sorry, no posts matched your criteria.</p>
</div>
<?php endif; ?>
<?php wp_pagenavi(); ?>
functions.php file:
add_action(\'pre_user_query\', \'sort_connect_author_list_by_last_name\' );
function sort_connect_author_list_by_last_name(&$object) {
global $wp, $wpdb;
if(preg_match( "/^connect(\\/.+)?$/", $wp->request )) {
// Sub query
$sql = "
(SELECT
`{$wpdb->users}`.`ID` AS `c_user_id`,
MAX(CASE WHEN `{$wpdb->usermeta}`.`meta_key` = \'location\' THEN `{$wpdb->usermeta}`.`meta_value` END ) AS `c_location`,
MAX(CASE WHEN `{$wpdb->usermeta}`.`meta_key` = \'last_name\' THEN `{$wpdb->usermeta}`.`meta_value` END ) AS `c_last_name`,
MAX(CASE WHEN `{$wpdb->usermeta}`.`meta_key` = \'first_name\' THEN `{$wpdb->usermeta}`.`meta_value` END ) AS `c_first_name`
FROM
`{$wpdb->users}`
LEFT JOIN `{$wpdb->usermeta}` ON ( `{$wpdb->users}`.`ID` = `{$wpdb->usermeta}`.`user_id` )
WHERE
1=1
GROUP BY
`{$wpdb->users}`.`ID`
) AS `C`
";
// Modify existing query
$object->query_fields = "SQL_CALC_FOUND_ROWS `{$wpdb->users}`.`ID`, `{$wpdb->users}`.`display_name`";
$object->query_from .= " RIGHT JOIN {$sql} ON ( `{$wpdb->users}`.`ID` = `C`.`c_user_id` )";
$object->query_orderby = "ORDER BY `C`.`c_last_name` ASC";
}
}
SO网友:fuxia
筛选字符串\'query\' 并更改ORDER BY 部分看见https://gist.github.com/1281778#L160 例如。
结束