dongpao5261 2017-06-06 13:17
浏览 70
已采纳

laravel雄辩的计数与groupby

If I'd have the following table structure

ID      name   type    
1       John   Admin   
2       Johan  Admin
3       Sam    User
4       Rick   User

How would I use Laravels Eloquent with a groupBy query, but still grab each record, and also sum up per type how many records each type has?

Example result would be as follow

[
    'type' => 'Admin',
    'records' => 2
    'data' => [
        0 => [
            'name' => 'John'
        ],
        1 => [
            'name' => 'Johan'
        ]
    ]
], 
[
    'type' => 'User',
    'records' => 2
    'data' => [
        0 => [
            'name' => 'Sam'
        ],
        1 => [
            'name' => 'Rick'
        ]
    ]
]
  • 写回答

3条回答 默认 最新

  • doupo2157 2017-06-06 16:57
    关注

    Since you are querying all the users you should be doing the grouping after the query instead of grouping in query like:

    $users = User::all()->groupBy('type');
    

    Then you can do:

    foreach ($allUsers as $type => $users) {
        $type; // 'Admin'
        $users->count(); // Record Count
        foreach ($users as $user) {
            $user->name; // 
        }
    }
    

    If you want the data EXACTLY like your example then it would be:

    User::all()
        ->groupBy('type')
        ->map(function($users, $type) {
            return [
                'type'    => $type,
                'records' => $users->count(),
                'data'    => $users->pluck('name')
            ];
        })
        ->values();
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(2条)

报告相同问题?

悬赏问题

  • ¥20 画CAD几张图片内容如下1111111111111111111111111111111111111111111
  • ¥15 基于python的电影系统推荐
  • ¥20 springmvc重定向和返回json
  • ¥15 数学建模——参会安排怎么做
  • ¥15 电脑键盘实现触摸功能
  • ¥25 matlab无法将表达式转换为双数组怎么解决?
  • ¥15 单片机汇编语言相关程序
  • ¥20 家用射频美容仪技术规格
  • ¥15 大家帮我看看为什么错了
  • ¥15 unity互动琴弦抖动效果