如何在laravel 5.2中编写条件查询 - How to write conditional query in laravel 5.2?

如何在laravel 5.2 eloquent或query builder中编写这种查询?

$query = Customers::leftjoin('Query string');    
if(condition)
    {
        //This part added to query   
    }
    else
    {
        //This part added to query
    }
->get();

您必须在变量中记住您的查询，例如:

$query = Customers::leftjoin('Query string');   
if(condation){
    $query = $query->where('something', '=', 'something');
} else {
    $query = $query->where('somethingelse', '=', 'somethingelse');
}
$query = $query->get();

通常你会有$query->where()-get();，这基本上是一样的，$query将保留你的->where()的结果，并允许你进一步链接$query