這是模型查詢的簡化版本：User::select('users.*') ->when(!empty($this->searchInput['search[term]']), function ($query) { return $query->where( 'biography', 'LIKE', '%' . $this->searchInput['search[term]'] . '%' ); }) ->when(!empty($this->searchInput['search[location]']), function ($query) { return $query->where( 'country_id', $this->searchInput['search[location]'] ); }) ->when(!empty($this->searchInput['engagement']), function ($query) { foreach ($this->searchInput['engagement'] as $key => $value) { if ($key === array_key_first($this->searchInput['engagement'])) { $query->whereBetween('engagement_rate', $value); } else { $query->orWhereBetween('engagement_rate', $value); } } });（如果您想知道，我正在使用$key === array_key_first以確保第一次BETWEEN使用AND，然后OR根據用戶的選擇使用）這等同于以下 SQL 查詢：SELECT `users`.*FROM `users`WHERE `country_id` = '31' AND `engagement_rate` BETWEEN '6' AND '20' OR `engagement_rate` BETWEEN '3.5' AND '6'in whereBetweenEloquent 不包含方括號，因此 country_id 選擇器會被忽略。我需要最終的 SQL 語句如下（帶括號）：SELECT `users`.*FROM `users`WHERE `country_id` = '31' AND (`engagement_rate` BETWEEN '6' AND '20' OR `engagement_rate` BETWEEN '3.5' AND '6')我的問題：如何更改我的 Eloquent 查詢以反映上述內容？
1 回答
MM們
TA貢獻1886條經驗 獲得超2個贊
在and子句中添加參數組：whereBetweenorWhereBetween
User::select('users.*')
// ...
->when(!empty($this->searchInput['engagement']), function ($query) {
? ? query->where(function ($q) {
? ? ? ? foreach ($this->searchInput['engagement'] as $key => $value) {
? ? ? ? ? ? if ($key === array_key_first($this->searchInput['engagement'])) {
? ? ? ? ? ? ? ? $q->whereBetween('engagement_rate', $value);
? ? ? ? ? ? } else {
? ? ? ? ? ? ? ? $q->orWhereBetween('engagement_rate', $value);
? ? ? ? ? ? }
? ? ? ? }
? ? });
});
- 1 回答
- 0 關注
- 169 瀏覽
添加回答
舉報
0/150
提交
取消