Laravel 4 循环中的前进位置子句 - Laravel 4 Advance Where clause in a loop

Laravel 4 Advance Where clause in a loop

我需要按如下方式查询：

SELECT * FROM table WHERE (field1 = "value" OR field2 = "value" OR filed3 = "value") AND ( price between 1 and 100  OR price between 101 and 200)

$priceArray = array(
    array(1,100),
    array(101,200)
);
$query->where('title',"like", '%test%')
      ->orWhere('subtitle',"like", '%test%')
      ->orWhere('author',"like", '%test%');
$query->where(function($query) use ($priceArray) {
    for ($i = 0; $i < count($priceArray); i++) {
        if ($i == 0) {
            $query->whereBetween('price', $priceArray[$i])
        }
        else {
            $query->orWhereBetween('price',$priceArray[$i])
        }
    }
})

但是，这执行为（主查询和价格在 1-100 之间）或过程在 101 -200 之间相反，它应该作为主查询和（价格在 1-100 之间或价格在 101 -200 之间）

请建议

这应该有效：

$priceArray = array(
    array(  1, 100),
    array(101, 200)
);
$query->where(function($query) {
    $query->where('title', 'like', '%test%')
          ->orWhere('subtitle', 'like', '%test%')
          ->orWhere('author', 'like', '%test%');
})->where(function($query) use ($priceArray) {
    for ($i = 0; $i < count($priceArray); $i++) { 
        $query->orWhereBetween('price', $priceArray[$i]);
    }
});