yajra / laravel-datatables

src/Engines/QueryBuilderEngine.php

Spacing +11 added lines, -11 removed lines

@@ -96,13 +96,13 @@ 
         $myQuery = clone $this->query;
         // if its a normal query ( no union, having and distinct word )
         // replace the select with static text to improve performance
-        if (! Str::contains(Str::lower($myQuery->toSql()), ['union', 'having', 'distinct', 'order by', 'group by'])) {
+        if (!Str::contains(Str::lower($myQuery->toSql()), ['union', 'having', 'distinct', 'order by', 'group by'])) {
             $row_count = $this->wrap('row_count');
             $myQuery->select($this->connection->raw("'1' as {$row_count}"));
         }
 
         // check for select soft deleted records
-        if (! $this->withTrashed && $this->modelUseSoftDeletes()) {
+        if (!$this->withTrashed && $this->modelUseSoftDeletes()) {
             $myQuery->whereNull($myQuery->getModel()->getTable() . '.deleted_at');
         }
 
@@ -158,7 +158,7 @@ 
                         $columnDef = $this->columnDef['filter'][$columnName];
                         // check if global search should be applied for the specific column
                         $applyGlobalSearch = count($columnDef['parameters']) == 0 || end($columnDef['parameters']) !== false;
-                        if (! $applyGlobalSearch) {
+                        if (!$applyGlobalSearch) {
                             continue;
                         }
 
@@ -271,7 +271,7 @@ 
      */
     protected function compileRelationSearch($query, $relation, $column, $keyword)
     {
-        $myQuery      = clone $this->query;
+        $myQuery = clone $this->query;
 
         /**
          * For compile nested relation, we need store all nested relation as array
@@ -436,7 +436,7 @@ 
         $columns = $this->request->get('columns', []);
 
         foreach ($columns as $index => $column) {
-            if (! $this->request->isColumnSearchable($index)) {
+            if (!$this->request->isColumnSearchable($index)) {
                 continue;
             }
 
@@ -517,7 +517,7 @@ 
             $pivotPK = $model->getForeignKey();
             $pivotFK = $model->getQualifiedParentKeyName();
 
-            if (! in_array($pivot, $joins)) {
+            if (!in_array($pivot, $joins)) {
                 $this->getQueryBuilder()->leftJoin($pivot, $pivotPK, '=', $pivotFK);
             }
 
@@ -526,7 +526,7 @@ 
             $tablePK = $related->getForeignKey();
             $tableFK = $related->getQualifiedKeyName();
 
-            if (! in_array($table, $joins)) {
+            if (!in_array($table, $joins)) {
                 $this->getQueryBuilder()->leftJoin($table, $pivot . '.' . $tablePK, '=', $tableFK);
             }
         } else {
@@ -539,7 +539,7 @@ 
                 $other   = $model->getQualifiedOtherKeyName();
             }
 
-            if (! in_array($table, $joins)) {
+            if (!in_array($table, $joins)) {
                 $this->getQueryBuilder()->leftJoin($table, $foreign, '=', $other);
             }
         }
@@ -575,10 +575,10 @@ 
     protected function regexColumnSearch($column, $keyword)
     {
         if ($this->isOracleSql()) {
-            $sql = ! $this->isCaseInsensitive() ? 'REGEXP_LIKE( ' . $column . ' , ? )' : 'REGEXP_LIKE( LOWER(' . $column . ') , ?, \'i\' )';
+            $sql = !$this->isCaseInsensitive() ? 'REGEXP_LIKE( ' . $column . ' , ? )' : 'REGEXP_LIKE( LOWER(' . $column . ') , ?, \'i\' )';
             $this->query->whereRaw($sql, [$keyword]);
         } else {
-            $sql = ! $this->isCaseInsensitive() ? $column . ' REGEXP ?' : 'LOWER(' . $column . ') REGEXP ?';
+            $sql = !$this->isCaseInsensitive() ? $column . ' REGEXP ?' : 'LOWER(' . $column . ') REGEXP ?';
             $this->query->whereRaw($sql, [Str::lower($keyword)]);
         }
     }
@@ -623,7 +623,7 @@ 
 
                     if (in_array($relation, $eagerLoads)) {
                         $relationship = $this->query->getRelation($relation);
-                        if (! ($relationship instanceof MorphToMany)) {
+                        if (!($relationship instanceof MorphToMany)) {
                             $column = $this->joinEagerLoadedColumn($relation, $relationColumn);
                         } else {
                             $valid = 0;