如何在Laravel Eloquent中计算价值? [英] How to count value in Laravel Eloquent?

问题描述

我无法计算laravel 8中的值.我想计算表中的所有值低于该价位，尚未有状态价.如何计算laravel雄辩中没有状态的值，按member_Code分组

I have trouble in counting values in laravel 8. I want to count all in the table below that have in and doesnt have a status out yet. How to count value that is doesnt have status out in laravel eloquent it is group by member_Code

推荐答案

您可以像这样使用 DB :: raw 进行计数:

you can count using DB::raw like this:

  $values=   MyModel::query()->where('status', '!=', 'out')
            ->select(['member_Code',DB::raw('count(*)')]) ->groupBy('member_Code')->get();

如果要计算尚未超时的所有成员，可以使用

if you want to count all member that don't time out yet, you can use distinct method:

 $inMemebersCount= MyModel::query()->where('status', '!=', 'out')
            ->select('member_Code')->distinct()->count();

这篇关于如何在Laravel Eloquent中计算价值?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！