@@ -529,7 +529,9 @@ |
||
| 529 | 529 | |
| 530 | 530 | $queryString = ""; |
| 531 | 531 | |
| 532 | - if (empty($queryParams["filters"])) return ""; |
|
| 532 | + if (empty($queryParams["filters"])) { |
|
| 533 | + return ""; |
|
| 534 | + } |
|
| 533 | 535 | |
| 534 | 536 | foreach ($queryParams["filters"] as $key => $filtro) { |
| 535 | 537 | if ($key === 0) { |
@@ -123,14 +123,14 @@ |
||
| 123 | 123 | $users = DB::table("users as u") |
| 124 | 124 | ->selectRaw("u . id as usuario, sub . street as rua") |
| 125 | 125 | ->leftJoinSub($address, 'sub', "sub . user_id = u.id AND 1 = ?", [1]); |
| 126 | -var_dump($users->get());die; |
|
| 126 | +var_dump($users->get()); die; |
|
| 127 | 127 | |
| 128 | 128 | /** |
| 129 | 129 | * Selecionar de uma subquery |
| 130 | 130 | * |
| 131 | 131 | * Select * from (select * from users) as sub |
| 132 | 132 | */ |
| 133 | -$dados = DB::fromSub(function (Query $query) { |
|
| 133 | +$dados = DB::fromSub(function(Query $query) { |
|
| 134 | 134 | return $query->from("users")->selectRaw('first_name')->limit(10); |
| 135 | 135 | }, 'sub') |
| 136 | 136 | ->order('first_name')->groupBy(['first_name']); |