yajra / laravel-datatables

src/Engines/QueryBuilderEngine.php

Indentation +2 added lines, -2 removed lines

@@ -216,8 +216,8 @@
         $myQuery = clone $this->query;
         $myQuery->orWhereHas($relation, function ($q) use ($column, $keyword, $query) {
             $sql = $q->select($this->connection->raw('count(1)'))
-                     ->where($column, 'like', $keyword)
-                     ->toSql();
+                        ->where($column, 'like', $keyword)
+                        ->toSql();
             $sql = "($sql) >= 1";
             $query->orWhereRaw($sql, [$keyword]);
         });

Spacing +7 added lines, -7 removed lines

@@ -93,7 +93,7 @@ 
         $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->connection->getQueryGrammar()->wrap('row_count');
             $myQuery->select($this->connection->raw("'1' as {$row_count}"));
         }
@@ -125,7 +125,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;
                         }
 
@@ -297,7 +297,7 @@ 
         $columns = $this->request->get('columns', []);
 
         foreach ($columns as $index => $column) {
-            if (! $this->request->isColumnSearchable($index)) {
+            if (!$this->request->isColumnSearchable($index)) {
                 continue;
             }
 
@@ -337,7 +337,7 @@ 
                 $keyword         = $this->getSearchKeyword($index);
                 $caseInsensitive = $this->isCaseInsensitive();
 
-                if (! $caseInsensitive) {
+                if (!$caseInsensitive) {
                     $column = strstr($column, '(') ? $this->connection->raw($column) : $column;
                 }
 
@@ -471,7 +471,7 @@ 
             $pivotPK = $model->getForeignKey();
             $pivotFK = $model->getQualifiedParentKeyName();
 
-            if (! in_array($pivot, $joins)) {
+            if (!in_array($pivot, $joins)) {
                 $this->getQueryBuilder()->leftJoin($pivot, $pivotPK, '=', $pivotFK);
             }
 
@@ -480,14 +480,14 @@ 
             $tablePK = $related->getForeignKey();
             $tableFK = $related->getQualifiedKeyName();
 
-            if (! in_array($table, $joins)) {
+            if (!in_array($table, $joins)) {
                 $this->getQueryBuilder()->leftJoin($table, $pivot . '.' . $tablePK, '=', $tableFK);
             }
         } else {
             $table   = $model->getRelated()->getTable();
             $foreign = $model->getQualifiedForeignKey();
             $other   = $model->getQualifiedOtherKeyName();
-            if (! in_array($table, $joins)) {
+            if (!in_array($table, $joins)) {
                 $this->getQueryBuilder()->leftJoin($table, $foreign, '=', $other);
             }
         }