@@ -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']); |