yajra / laravel-datatables

src/Engines/QueryBuilderEngine.php

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 {