yajra / laravel-datatables

src/Engines/QueryBuilderEngine.php

Doc Comments +1 added lines, -1 removed lines

@@ -309,7 +309,7 @@
      * Perform case insensitive column search.
      *
      * @param int $i
-     * @param mixed $column
+     * @param string $column
      * @param string $keyword
      */
     protected function caseInsensitiveColumnSearch($i, $column, $keyword)

Spacing +9 added lines, -9 removed lines

@@ -94,7 +94,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->wrap('row_count');
             $myQuery->select($this->connection->raw("'1' as {$row_count}"));
         }
@@ -136,7 +136,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;
                         }
 
@@ -286,7 +286,7 @@ 
             $keyword = "%$keyword%";
         }
 
-        $query->{$relation .'WhereRaw'}($sql, [$keyword]);
+        $query->{$relation . 'WhereRaw'}($sql, [$keyword]);
     }
 
     /**
@@ -317,7 +317,7 @@ 
         $columns = $this->request->get('columns', []);
 
         foreach ($columns as $index => $column) {
-            if (! $this->request->isColumnSearchable($index)) {
+            if (!$this->request->isColumnSearchable($index)) {
                 continue;
             }
 
@@ -404,10 +404,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)]);
         }
     }
@@ -479,7 +479,7 @@ 
             $pivotPK = $model->getForeignKey();
             $pivotFK = $model->getQualifiedParentKeyName();
 
-            if (! in_array($pivot, $joins)) {
+            if (!in_array($pivot, $joins)) {
                 $this->getQueryBuilder()->leftJoin($pivot, $pivotPK, '=', $pivotFK);
             }
 
@@ -488,7 +488,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 {
@@ -501,7 +501,7 @@ 
                 $other   = $model->getQualifiedOtherKeyName();
             }
 
-            if (! in_array($table, $joins)) {
+            if (!in_array($table, $joins)) {
                 $this->getQueryBuilder()->leftJoin($table, $foreign, '=', $other);
             }
         }