@@ -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 |