@@ -53,13 +53,13 @@ |
||
53 | 53 | $myQuery = clone $this->query; |
54 | 54 | // if its a normal query ( no union, having and distinct word ) |
55 | 55 | // replace the select with static text to improve performance |
56 | - if (! Str::contains(Str::lower($myQuery->toSql()), ['union', 'having', 'distinct', 'order by', 'group by'])) { |
|
56 | + if (!Str::contains(Str::lower($myQuery->toSql()), ['union', 'having', 'distinct', 'order by', 'group by'])) { |
|
57 | 57 | $row_count = $this->wrap('row_count'); |
58 | 58 | $myQuery->select($this->connection->raw("'1' as {$row_count}")); |
59 | 59 | } |
60 | 60 | |
61 | 61 | // check for select soft deleted records |
62 | - if (! $this->withTrashed && ! $this->onlyTrashed && $this->modelUseSoftDeletes()) { |
|
62 | + if (!$this->withTrashed && !$this->onlyTrashed && $this->modelUseSoftDeletes()) { |
|
63 | 63 | $myQuery->whereNull($myQuery->getModel()->getQualifiedDeletedAtColumn()); |
64 | 64 | } |
65 | 65 |
@@ -99,7 +99,7 @@ discard block |
||
99 | 99 | $myQuery = clone $this->query; |
100 | 100 | // if its a normal query ( no union, having and distinct word ) |
101 | 101 | // replace the select with static text to improve performance |
102 | - if (! Str::contains(Str::lower($myQuery->toSql()), ['union', 'having', 'distinct', 'order by', 'group by'])) { |
|
102 | + if (!Str::contains(Str::lower($myQuery->toSql()), ['union', 'having', 'distinct', 'order by', 'group by'])) { |
|
103 | 103 | $row_count = $this->wrap('row_count'); |
104 | 104 | $myQuery->select($this->connection->raw("'1' as {$row_count}")); |
105 | 105 | } |
@@ -142,7 +142,7 @@ discard block |
||
142 | 142 | $columnDef = $this->columnDef['filter'][$columnName]; |
143 | 143 | // check if global search should be applied for the specific column |
144 | 144 | $applyGlobalSearch = count($columnDef['parameters']) == 0 || end($columnDef['parameters']) !== false; |
145 | - if (! $applyGlobalSearch) { |
|
145 | + if (!$applyGlobalSearch) { |
|
146 | 146 | continue; |
147 | 147 | } |
148 | 148 | |
@@ -388,7 +388,7 @@ discard block |
||
388 | 388 | $q = $query; |
389 | 389 | } |
390 | 390 | |
391 | - if (! $q->from instanceof Expression) { |
|
391 | + if (!$q->from instanceof Expression) { |
|
392 | 392 | // Get table from query and add it. |
393 | 393 | $column = $q->from . '.' . $column; |
394 | 394 | } |
@@ -447,7 +447,7 @@ discard block |
||
447 | 447 | $columns = (array) $this->request->input('columns'); |
448 | 448 | |
449 | 449 | foreach ($columns as $index => $column) { |
450 | - if (! $this->request->isColumnSearchable($index)) { |
|
450 | + if (!$this->request->isColumnSearchable($index)) { |
|
451 | 451 | continue; |
452 | 452 | } |
453 | 453 | |
@@ -569,7 +569,7 @@ discard block |
||
569 | 569 | $joins[] = $join->table; |
570 | 570 | } |
571 | 571 | |
572 | - if (! in_array($table, $joins)) { |
|
572 | + if (!in_array($table, $joins)) { |
|
573 | 573 | $this->getQueryBuilder()->join($table, $foreign, '=', $other); |
574 | 574 | } |
575 | 575 | } |
@@ -600,10 +600,10 @@ discard block |
||
600 | 600 | protected function regexColumnSearch($column, $keyword) |
601 | 601 | { |
602 | 602 | if ($this->isOracleSql()) { |
603 | - $sql = ! $this->isCaseInsensitive() ? 'REGEXP_LIKE( ' . $column . ' , ? )' : 'REGEXP_LIKE( LOWER(' . $column . ') , ?, \'i\' )'; |
|
603 | + $sql = !$this->isCaseInsensitive() ? 'REGEXP_LIKE( ' . $column . ' , ? )' : 'REGEXP_LIKE( LOWER(' . $column . ') , ?, \'i\' )'; |
|
604 | 604 | $this->query->whereRaw($sql, [$keyword]); |
605 | 605 | } else { |
606 | - $sql = ! $this->isCaseInsensitive() ? $column . ' REGEXP ?' : 'LOWER(' . $column . ') REGEXP ?'; |
|
606 | + $sql = !$this->isCaseInsensitive() ? $column . ' REGEXP ?' : 'LOWER(' . $column . ') REGEXP ?'; |
|
607 | 607 | $this->query->whereRaw($sql, [Str::lower($keyword)]); |
608 | 608 | } |
609 | 609 | } |
@@ -648,7 +648,7 @@ discard block |
||
648 | 648 | |
649 | 649 | if (in_array($relation, $eagerLoads)) { |
650 | 650 | $relationship = $this->query->getRelation($relation); |
651 | - if (! ($relationship instanceof MorphToMany)) { |
|
651 | + if (!($relationship instanceof MorphToMany)) { |
|
652 | 652 | $column = $this->joinEagerLoadedColumn($relation, $relationColumn); |
653 | 653 | } else { |
654 | 654 | $valid = 0; |