@@ -216,8 +216,8 @@ discard block |
||
| 216 | 216 | $myQuery = clone $this->query; |
| 217 | 217 | $myQuery->orWhereHas($relation, function ($q) use ($column, $keyword, $query) { |
| 218 | 218 | $sql = $q->select($this->connection->raw('count(1)')) |
| 219 | - ->where($column, 'like', $keyword) |
|
| 220 | - ->toSql(); |
|
| 219 | + ->where($column, 'like', $keyword) |
|
| 220 | + ->toSql(); |
|
| 221 | 221 | $sql = "($sql) >= 1"; |
| 222 | 222 | $query->orWhereRaw($sql, [$keyword]); |
| 223 | 223 | }); |
@@ -397,8 +397,8 @@ discard block |
||
| 397 | 397 | } |
| 398 | 398 | if (! in_array($table, $joins)) { |
| 399 | 399 | $this->getQueryBuilder() |
| 400 | - ->leftJoin($table, $foreign, '=', $other) |
|
| 401 | - ->orderBy($orderBy, $orderable['direction']); |
|
| 400 | + ->leftJoin($table, $foreign, '=', $other) |
|
| 401 | + ->orderBy($orderBy, $orderable['direction']); |
|
| 402 | 402 | } |
| 403 | 403 | } else { |
| 404 | 404 | $this->getQueryBuilder()->orderBy($column, $orderable['direction']); |
@@ -84,7 +84,7 @@ discard block |
||
| 84 | 84 | $myQuery = clone $this->query; |
| 85 | 85 | // if its a normal query ( no union, having and distinct word ) |
| 86 | 86 | // replace the select with static text to improve performance |
| 87 | - if (! Str::contains(Str::lower($myQuery->toSql()), ['union', 'having', 'distinct', 'order by', 'group by'])) { |
|
| 87 | + if (!Str::contains(Str::lower($myQuery->toSql()), ['union', 'having', 'distinct', 'order by', 'group by'])) { |
|
| 88 | 88 | $row_count = $this->connection->getQueryGrammar()->wrap('row_count'); |
| 89 | 89 | $myQuery->select($this->connection->raw("'1' as {$row_count}")); |
| 90 | 90 | } |
@@ -395,7 +395,7 @@ discard block |
||
| 395 | 395 | foreach ((array) $this->getQueryBuilder()->joins as $key => $join) { |
| 396 | 396 | $joins[] = $join->table; |
| 397 | 397 | } |
| 398 | - if (! in_array($table, $joins)) { |
|
| 398 | + if (!in_array($table, $joins)) { |
|
| 399 | 399 | $this->getQueryBuilder() |
| 400 | 400 | ->leftJoin($table, $foreign, '=', $other) |
| 401 | 401 | ->orderBy($orderBy, $orderable['direction']); |