@@ -30,16 +30,16 @@ discard block |
||
| 30 | 30 | public function scopeSearch($query, $searchQuery) |
| 31 | 31 | { |
| 32 | 32 | |
| 33 | - return $query->where(function ($query) use ($searchQuery) { |
|
| 33 | + return $query->where(function($query) use ($searchQuery) { |
|
| 34 | 34 | $columns = $this->getAllColumnsNames(); |
| 35 | 35 | |
| 36 | 36 | foreach ($columns as $column) { |
| 37 | - $column = $this->isReserved($column) ? '"' . $column . '"' : $column; |
|
| 37 | + $column = $this->isReserved($column) ? '"'.$column.'"' : $column; |
|
| 38 | 38 | |
| 39 | 39 | if ((DB::connection()->getDriverName()) == 'oracle') { |
| 40 | - $query->orWhereRaw('LOWER(' . $column . ') like ? ESCAPE \'\\\'', ['%' . Security::escapeLike(strtolower($searchQuery)) . '%']); |
|
| 40 | + $query->orWhereRaw('LOWER('.$column.') like ? ESCAPE \'\\\'', ['%'.Security::escapeLike(strtolower($searchQuery)).'%']); |
|
| 41 | 41 | } else { |
| 42 | - $query->orwhere($column, 'like', '%' . Security::escapeLike($searchQuery,'\\\'') . '%'); |
|
| 42 | + $query->orwhere($column, 'like', '%'.Security::escapeLike($searchQuery, '\\\'').'%'); |
|
| 43 | 43 | } |
| 44 | 44 | |
| 45 | 45 | } |
@@ -50,20 +50,20 @@ discard block |
||
| 50 | 50 | { |
| 51 | 51 | switch (DB::connection()->getDriverName()) { |
| 52 | 52 | case 'pgsql': |
| 53 | - $query = "SELECT column_name FROM information_schema.columns WHERE table_name = '" . $this->getTable() . "'"; |
|
| 53 | + $query = "SELECT column_name FROM information_schema.columns WHERE table_name = '".$this->getTable()."'"; |
|
| 54 | 54 | $column_name = 'column_name'; |
| 55 | 55 | $reverse = true; |
| 56 | 56 | break; |
| 57 | 57 | |
| 58 | 58 | case 'sqlite': |
| 59 | - $query = "PRAGMA table_info('" . $this->getTable()."')"; |
|
| 59 | + $query = "PRAGMA table_info('".$this->getTable()."')"; |
|
| 60 | 60 | $column_name = 'name'; |
| 61 | 61 | $reverse = true; |
| 62 | 62 | break; |
| 63 | 63 | |
| 64 | 64 | |
| 65 | 65 | case 'mysql': |
| 66 | - $query = 'SHOW COLUMNS FROM ' . $this->getTable(); |
|
| 66 | + $query = 'SHOW COLUMNS FROM '.$this->getTable(); |
|
| 67 | 67 | $column_name = 'Field'; |
| 68 | 68 | $reverse = false; |
| 69 | 69 | break; |
@@ -72,17 +72,17 @@ discard block |
||
| 72 | 72 | $parts = explode('.', $this->getTable()); |
| 73 | 73 | $num = (count($parts) - 1); |
| 74 | 74 | $table = $parts[$num]; |
| 75 | - $query = "SELECT column_name FROM " . DB::connection()->getConfig('database') . ".INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = N'" . $table . "'"; |
|
| 75 | + $query = "SELECT column_name FROM ".DB::connection()->getConfig('database').".INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = N'".$table."'"; |
|
| 76 | 76 | $column_name = 'column_name'; |
| 77 | 77 | $reverse = false; |
| 78 | 78 | break; |
| 79 | 79 | case 'oracle': |
| 80 | - $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\''; |
|
| 80 | + $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\''; |
|
| 81 | 81 | $column_name = 'column_name'; |
| 82 | 82 | $reverse = false; |
| 83 | 83 | break; |
| 84 | 84 | default: |
| 85 | - $error = 'Database driver not supported: ' . DB::connection()->getConfig('driver'); |
|
| 85 | + $error = 'Database driver not supported: '.DB::connection()->getConfig('driver'); |
|
| 86 | 86 | throw new Exception($error); |
| 87 | 87 | } |
| 88 | 88 | |
@@ -101,12 +101,12 @@ discard block |
||
| 101 | 101 | |
| 102 | 102 | public function scopeBetweenCreate($query, $start, $end) |
| 103 | 103 | { |
| 104 | - return $query->whereBetween($this->getTable() . '.created_at', [$start, $end]); |
|
| 104 | + return $query->whereBetween($this->getTable().'.created_at', [$start, $end]); |
|
| 105 | 105 | } |
| 106 | 106 | |
| 107 | 107 | public function scopeBetweenUpdate($query, $start, $end) |
| 108 | 108 | { |
| 109 | - return $query->whereBetween($this->getTable() . '.updated_at', [$start, $end]); |
|
| 109 | + return $query->whereBetween($this->getTable().'.updated_at', [$start, $end]); |
|
| 110 | 110 | } |
| 111 | 111 | |
| 112 | 112 | |