Distilleries / Expendable

src/Distilleries/Expendable/Models/BaseModel.php

Spacing +11 added lines, -11 removed lines

@@ -520,16 +520,16 @@ 
     public function scopeSearch($query, $searchQuery)
     {
 
-        return $query->where(function ($query) use ($searchQuery) {
+        return $query->where(function($query) use ($searchQuery) {
             $columns = $this->getAllColumnsNames();
 
             foreach ($columns as $column) {
-                $column = $this->isReserved($column) ? '"' . $column . '"' : $column;
+                $column = $this->isReserved($column) ? '"'.$column.'"' : $column;
 
                 if ((DB::connection()->getDriverName()) == 'oracle') {
-                    $query->orWhereRaw('LOWER(' . $column . ') like ? ESCAPE \'\\\'', ['%' . Security::escapeLike(strtolower($searchQuery)) . '%']);
+                    $query->orWhereRaw('LOWER('.$column.') like ? ESCAPE \'\\\'', ['%'.Security::escapeLike(strtolower($searchQuery)).'%']);
                 } else {
-                    $query->orwhere($column, 'like', '%' . Security::escapeLike($searchQuery,'\\\'') . '%');
+                    $query->orwhere($column, 'like', '%'.Security::escapeLike($searchQuery, '\\\'').'%');
                 }
 
             }
@@ -540,13 +540,13 @@ 
     {
         switch (DB::connection()->getDriverName()) {
             case 'pgsql':
-                $query       = "SELECT column_name FROM information_schema.columns WHERE table_name = '" . $this->getTable() . "'";
+                $query       = "SELECT column_name FROM information_schema.columns WHERE table_name = '".$this->getTable()."'";
                 $column_name = 'column_name';
                 $reverse     = true;
                 break;
 
             case 'mysql':
-                $query       = 'SHOW COLUMNS FROM ' . $this->getTable();
+                $query       = 'SHOW COLUMNS FROM '.$this->getTable();
                 $column_name = 'Field';
                 $reverse     = false;
                 break;
@@ -555,17 +555,17 @@ 
                 $parts       = explode('.', $this->getTable());
                 $num         = (count($parts) - 1);
                 $table       = $parts[$num];
-                $query       = "SELECT column_name FROM " . DB::connection()->getConfig('database') . ".INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = N'" . $table . "'";
+                $query       = "SELECT column_name FROM ".DB::connection()->getConfig('database').".INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = N'".$table."'";
                 $column_name = 'column_name';
                 $reverse     = false;
                 break;
             case 'oracle':
-                $query       = 'SELECT COLUMN_NAME from ALL_TAB_COLUMNS WHERE TABLE_NAME=\'' . strtoupper($this->getTable()) . '\' AND DATA_TYPE <> \'CLOB\' AND DATA_TYPE <> \'NUMBER\' AND DATA_TYPE <> \'TIMESTAMP\'';
+                $query       = 'SELECT COLUMN_NAME from ALL_TAB_COLUMNS WHERE TABLE_NAME=\''.strtoupper($this->getTable()).'\' AND DATA_TYPE <> \'CLOB\' AND DATA_TYPE <> \'NUMBER\' AND DATA_TYPE <> \'TIMESTAMP\'';
                 $column_name = 'column_name';
                 $reverse     = false;
                 break;
             default:
-                $error = 'Database driver not supported: ' . DB::connection()->getConfig('driver');
+                $error = 'Database driver not supported: '.DB::connection()->getConfig('driver');
                 throw new Exception($error);
         }
 
@@ -584,12 +584,12 @@ 
 
     public function scopeBetweenCreate($query, $start, $end)
     {
-        return $query->whereBetween($this->getTable() . '.created_at', [$start, $end]);
+        return $query->whereBetween($this->getTable().'.created_at', [$start, $end]);
     }
 
     public function scopeBetweenUpdate($query, $start, $end)
     {
-        return $query->whereBetween($this->getTable() . '.updated_at', [$start, $end]);
+        return $query->whereBetween($this->getTable().'.updated_at', [$start, $end]);
     }