View GitHub Repository Expendable

Schedule Inspection
Subscribe
Completed
Push — master ( b935a3...5dab40 )
by Maxime
20:04
created
Status
Category
Toggle Patches
src/Distilleries/Expendable/Models/BaseModel.php 1 patch
Spacing   +12 added lines, -12 removed lines patch added patch discarded remove patch 
@@ -30,16 +30,16 @@  discard block
 
 block discarded – undo
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
 
 block discarded – undo
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
 
 block discarded – undo
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
 
 block discarded – undo
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
Please login to merge, or discard this patch.