更新时间:2023-02-14 11:36:28
您可以像这样使用 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();