Laravel 不同状态数量查询

$model = YunUserCostSummary::with(['cost', 'subsidy'])
            ->leftjoin('yun_company', 'yun_user_cost_summaries.company_id', '=', 'yun_company.id')
            ->when($created_at, function ($query) use ($created_at) {
                return $query->whereDate('yun_user_cost_summaries.interview_date', $created_at);
            })
            ->where('yun_user_cost_summaries.status', 1)
            ->where('yun_company.type_id', $type_id);

        $count = $model->select(DB::raw('
                count(check_status=0 or null) as unconfirmed_count,
                count(check_status=1 or null) as confirmed_count,
                count(check_status=2 or null) as reject_count'))
            ->first()->toArray();

        $list = $model->when(isset($check_status), function ($query) use ($check_status) {
                return $query->where('yun_user_cost_summaries.check_status', $check_status);
            })
            ->select('yun_user_cost_summaries.*',
                'yun_company.company_name',
                'yun_company.area_name',
                'yun_company.shu_song_type'
            )
            ->orderBy('yun_user_cost_summaries.id', 'desc')
            ->paginate($limit)
            ->toArray();

本作品采用《CC 协议》，转载必须注明作者和本文链接