查询排行榜与关系

查询排行榜与关系

控制器:

$users = DB::table('users')
        ->join('uploads', 'users.id', '=', 'uploads.user_id')
        ->select(DB::raw('users.*, COUNT(*) AS total_uploads'))
        ->orderby('total_uploads', 'desc')
        ->groupby('users.id')
        ->take(5)
        ->get();

视图:
<?php $i = 1 ?>
@foreach($users as $user)
<tr>
    <td>{{ $i }}</td>
    <td><a href="user/{{ $user->username }}">{{ $user->username }}</a></td>
    <td>{{ $user->total_uploads }}</td>
</tr>
<?php $i++ ?>
@endforeach

预期产量:
 1  John  99
 2  Mary  78
 3  Jill  57
 3  Bill  57
 5  Hans  56

如何修改此项以考虑领带?

最佳答案

试试这个:

<?php $i = 0;
      $last_count = null;
?>
@foreach($users as $user)
<?php if($user->total_uploads != $last_count) $i++; ?>
<tr>
    <td>{{ $i }}</td>
    <td><a href="user/{{ $user->username }}">{{ $user->username }}</a></td>
    <td>{{ $user->total_uploads }}</td>
</tr>
<?php $last_count = $user->total_uploads; ?>
@endforeach

只有当当前用户的total_uploads与上一个用户的total_uploads不同时,计数器才会增加。

关于php - 查询排行榜与关系,我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/23090991/

10-11 00:16