php - Laravel - 如何在同一查询中使用 And 和 OR 进行嵌套

Question

我有以下问题

$updates = FolderLocker::where('created_at', 'like', $date . '%')
                ->orWhere('date_forwarded', 'like', $date . '%')
                ->orWhere('date_locked', 'like', $date . '%')
                ->orWhere('date_completed', 'like', $date . '%')
                ->whereIn('videographer_id', $videographerArray)
                ->orderBy('client_id', 'DESC')

                ->toSql();

产生

select * from `folder_lockers` where `created_at` like ? or `date_forwarded` like ? or `date_locked` like ? or `date_completed` like ? and `videographer_id` in (?, ?, ?, ?, ?, ?, ?) order by `client_id` desc

如何使 whereIn 子句成为主要子句，然后使所有 OR 子句成为另一个 AND 中的子句？

Answer 1

你可以将你的 wheres 分组在一个闭包中，像这样:

$updates = FolderLocker::whereIn('videographer_id', $videographerArray)
               ->where(function ($query) use ($date) {
                   $query->where('created_at', 'like', $date . '%')
                       ->orWhere('date_forwarded', 'like', $date . '%')
                       ->orWhere('date_locked', 'like', $date . '%')
                       ->orWhere('date_completed', 'like', $date . '%');
               })                
               ->orderBy('client_id', 'DESC');