是否可以按“count($getaffreferrals)”对$closerstring输出进行排序?
我附上了一张照片来显示它目前在我的网站上的输出。输出的屏幕截图
function affiliate_leaderboard_function() {
global $wpdb;
$getallreferrals = $wpdb->get_results( "SELECT * FROM `wp_affiliate_wp_referrals`");
$getallaffiliates = $wpdb->get_results( "SELECT * FROM `wp_affiliate_wp_affiliates`");
$current_month = date("m");
$current_year = date("Y");
$current_date = date("Y-m-d");
$lastday = date('t',strtotime($current_date));
function styleleaderboard() {
?>
<style>
span.numberofsales {
font-size:18px !important;
color : #666 !important;
}
.closerstring {
text-transform: capitalize;
}
</style>
<?php
}
add_action('wp_head', 'styleleaderboard');
styleleaderboard();
foreach ($getallaffiliates as $theaffiliate) {
$user_id = get_userdata( $theaffiliate->user_id );
$userfirstname = $user_id->first_name;
$userlastname = $user_id->last_name;
$totalreferrals = $theaffiliate->referrals;
$affiliate_id = $theaffiliate->affiliate_id;
$getaffreferrals = $wpdb->get_results( "SELECT `date` FROM `wp_affiliate_wp_referrals` WHERE `affiliate_id` = $affiliate_id AND `date` >= '$current_year-$current_month-01:00:00:00' AND `date` < '$current_year-$current_month-$lastday:23:59:59'");//Get all referrals by affiliate id
$closerstring = "<li class='closerstring'>".$userfirstname." ".$userlastname."<br><span class='numberofsales'>Sales: ".count($getaffreferrals)."</p></li>";
if(!empty($getaffreferrals) && $affiliate_id!='1'){
$return_array.= $closerstring;
}
}
return $return_array;
}
add_shortcode('affiliate_leaderboard' , 'affiliate_leaderboard_function');
1条答案
按热度按时间eivgtgni1#
如果将数据放在多维数组中,一个字段是字符串,另一个字段是要排序的字段,那么可以使用php的array\u multisort对该键进行排序。我还没有测试过这个代码,但应该是这样的: