yajra / laravel-datatables

src/Engines/BaseEngine.php

Indentation +1 added lines, -1 removed lines

@@ -856,7 +856,7 @@
         return $this;
     }
 	
-	/**
+    /**
      * Check if the current sql language is based on oracle syntax.
      *
      * @return bool

src/Engines/QueryBuilderEngine.php

Indentation +10 added lines, -10 removed lines

@@ -270,22 +270,22 @@
                     $column = $this->castColumn($column);
                     if ($this->isCaseInsensitive()) {
                         if ($this->request->isRegex($i)) {
-							if($this->isOracleSql()){
-								$this->query->whereRaw(' REGEXP_LIKE( LOWER('.$column.') , ?, \'i\' )', [$keyword]);
-							}else{
-								$this->query->whereRaw('LOWER(' . $column . ') REGEXP ?', [Str::lower($keyword)]);
-							}
+                            if($this->isOracleSql()){
+                                $this->query->whereRaw(' REGEXP_LIKE( LOWER('.$column.') , ?, \'i\' )', [$keyword]);
+                            }else{
+                                $this->query->whereRaw('LOWER(' . $column . ') REGEXP ?', [Str::lower($keyword)]);
+                            }
                         } else {
                             $this->query->whereRaw('LOWER(' . $column . ') LIKE ?', [Str::lower($keyword)]);
                         }
                     } else {
                         $col = strstr($column, '(') ? $this->connection->raw($column) : $column;
                         if ($this->request->isRegex($i)) {
-							if($this->isOracleSql()){
-								$this->query->whereRaw(' REGEXP_LIKE( '.$col.' , ? )', [$keyword]);
-							}else{
-								$this->query->whereRaw($col . ' REGEXP ?', [$keyword]);
-							}
+                            if($this->isOracleSql()){
+                                $this->query->whereRaw(' REGEXP_LIKE( '.$col.' , ? )', [$keyword]);
+                            }else{
+                                $this->query->whereRaw($col . ' REGEXP ?', [$keyword]);
+                            }
                         } else {
                             $this->query->whereRaw($col . ' LIKE ?', [$keyword]);
                         }

Spacing +7 added lines, -7 removed lines

@@ -85,7 +85,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}"));
         }
@@ -270,9 +270,9 @@ 
                     $column = $this->castColumn($column);
                     if ($this->isCaseInsensitive()) {
                         if ($this->request->isRegex($i)) {
-							if($this->isOracleSql()){
-								$this->query->whereRaw(' REGEXP_LIKE( LOWER('.$column.') , ?, \'i\' )', [$keyword]);
-							}else{
+							if ($this->isOracleSql()) {
+								$this->query->whereRaw(' REGEXP_LIKE( LOWER(' . $column . ') , ?, \'i\' )', [$keyword]);
+							} else {
 								$this->query->whereRaw('LOWER(' . $column . ') REGEXP ?', [Str::lower($keyword)]);
 							}
                         } else {
@@ -281,9 +281,9 @@ 
                     } else {
                         $col = strstr($column, '(') ? $this->connection->raw($column) : $column;
                         if ($this->request->isRegex($i)) {
-							if($this->isOracleSql()){
-								$this->query->whereRaw(' REGEXP_LIKE( '.$col.' , ? )', [$keyword]);
-							}else{
+							if ($this->isOracleSql()) {
+								$this->query->whereRaw(' REGEXP_LIKE( ' . $col . ' , ? )', [$keyword]);
+							} else {
 								$this->query->whereRaw($col . ' REGEXP ?', [$keyword]);
 							}
                         } else {

Braces +2 added lines, -2 removed lines

@@ -272,7 +272,7 @@ 
                         if ($this->request->isRegex($i)) {
 							if($this->isOracleSql()){
 								$this->query->whereRaw(' REGEXP_LIKE( LOWER('.$column.') , ?, \'i\' )', [$keyword]);
-							}else{
+							} else{
 								$this->query->whereRaw('LOWER(' . $column . ') REGEXP ?', [Str::lower($keyword)]);
 							}
                         } else {
@@ -283,7 +283,7 @@ 
                         if ($this->request->isRegex($i)) {
 							if($this->isOracleSql()){
 								$this->query->whereRaw(' REGEXP_LIKE( '.$col.' , ? )', [$keyword]);
-							}else{
+							} else{
 								$this->query->whereRaw($col . ' REGEXP ?', [$keyword]);
 							}
                         } else {

src/config/config.php

Indentation +1 added lines, -1 removed lines

@@ -2,7 +2,7 @@
 
 return [
 
-	'oracle_sql' => false,
+    'oracle_sql' => false,
 
     'search'          => [
         'case_insensitive' => true,