filter() 集合在子查询中不起作用

Question

我正在尝试获取具有地址的用户，并且该地址的创建时间不应超过 7 天：$users = User::whereHas('address', function($q) {        $q->where(function ($query) {             $query->get()->filter(function ($address) {                 return Carbon::now() < Carbon::parse($address->getOriginal('created_at'))->addDays(7);             });         });     });作品正确，filter()但我无法返回其结果，我的结果是所有有地址的用户。

Answer 1

你可以whereDate这样使用：

$users = User::whereHas('address', function ($q) {

    $q->whereDate('created_at', '>', Carbon::now()->subDays(7));

})->get();

Answer 2

你可以试试这样

$user = User::where('address',date('Y-m-d', strtotime('-7 days')))->where('created_at',date('Y-m-d', strtotime('-7 days')))->get();

Answer 3

使用注释更改您的代码

$users = User::whereHas('address', function ($q): void {

    $q->where(function ($query): void {

        /**

         * Subqueries use Eloquent Builder class here to add some wrapped filters 

         * But your code takes all addresses, filter them for nothing

         * You should add SQL filters to builder something like that:

         **/

        $query->whereDate(Carbon::now()->subDays(7), '<', 'created_at');

    })

    /** To get users by your filters */

    ->get();