@@ -11,12 +11,12 @@ discard block |
||
11 | 11 | protected ?string $table = null; |
12 | 12 | protected ?string $primary = null; |
13 | 13 | protected array $data = []; |
14 | - protected array $where = [''=> ["1",'=',"1"] ]; |
|
14 | + protected array $where = [''=> ["1", '=', "1"]]; |
|
15 | 15 | |
16 | - public function __set(string $prop,$value) |
|
16 | + public function __set(string $prop, $value) |
|
17 | 17 | { |
18 | 18 | |
19 | - if(is_array($value)){ |
|
19 | + if (is_array($value)) { |
|
20 | 20 | $attr = array_keys($value)[0]; |
21 | 21 | $this->data[$prop][$attr] = $value[$attr]; |
22 | 22 | return $this; |
@@ -51,7 +51,7 @@ discard block |
||
51 | 51 | $deniable = (is_array($deniable)) ? $deniable : [$deniable]; |
52 | 52 | |
53 | 53 | foreach ($deniable as $field) { |
54 | - if(!array_key_exists($field,$this->data)){ |
|
54 | + if (!array_key_exists($field, $this->data)) { |
|
55 | 55 | throw new Exception("{$field} field does not exist in the table {$this->table}."); |
56 | 56 | } |
57 | 57 | |
@@ -71,9 +71,9 @@ discard block |
||
71 | 71 | |
72 | 72 | public function orderBy(string $field, string $ord = 'ASC') |
73 | 73 | { |
74 | - $this->isSettable( str_replace(['asc','ASC','desc','DESC',' '],'',$field) ); |
|
74 | + $this->isSettable(str_replace(['asc', 'ASC', 'desc', 'DESC', ' '], '', $field)); |
|
75 | 75 | |
76 | - $ord = (strpos(strtolower($field),'asc') || strpos(strtolower($field),'desc')) ? '' : $ord; |
|
76 | + $ord = (strpos(strtolower($field), 'asc') || strpos(strtolower($field), 'desc')) ? '' : $ord; |
|
77 | 77 | |
78 | 78 | $this->order = " ORDER BY {$field} {$ord} "; |
79 | 79 | return $this; |
@@ -97,11 +97,11 @@ discard block |
||
97 | 97 | |
98 | 98 | public function where(array $where) |
99 | 99 | { |
100 | - $this->where['AND'] = (array_key_exists('AND',$this->where)) ?? ''; |
|
100 | + $this->where['AND'] = (array_key_exists('AND', $this->where)) ?? ''; |
|
101 | 101 | $w = []; |
102 | 102 | foreach ($where as $condition => $values) { |
103 | 103 | |
104 | - if(!is_array($values)){ |
|
104 | + if (!is_array($values)) { |
|
105 | 105 | $w['AND'][] = $values; |
106 | 106 | continue; |
107 | 107 | } |
@@ -112,7 +112,7 @@ discard block |
||
112 | 112 | |
113 | 113 | } |
114 | 114 | |
115 | - $this->where = array_merge($this->where,$w); |
|
115 | + $this->where = array_merge($this->where, $w); |
|
116 | 116 | |
117 | 117 | return $this; |
118 | 118 | } |
@@ -166,7 +166,7 @@ discard block |
||
166 | 166 | $string = ''; |
167 | 167 | foreach ($this->data as $key => $value) { |
168 | 168 | |
169 | - if(gettype($value)==='object'){ |
|
169 | + if (gettype($value) === 'object') { |
|
170 | 170 | $value = $value->getData()[$this->primary]['value']; |
171 | 171 | } |
172 | 172 | |
@@ -177,19 +177,19 @@ discard block |
||
177 | 177 | |
178 | 178 | public function remove(?bool $exec = false) |
179 | 179 | { |
180 | - if(!$exec){ |
|
180 | + if (!$exec) { |
|
181 | 181 | $this->clause = 'remove'; |
182 | 182 | return $this; |
183 | 183 | } |
184 | 184 | |
185 | 185 | $this->clause = null; |
186 | 186 | |
187 | - if(count($this->where) == 1){ |
|
187 | + if (count($this->where) == 1) { |
|
188 | 188 | $this->removeById(); |
189 | 189 | return $this; |
190 | 190 | } |
191 | 191 | |
192 | - $this->delete($this->mountRemove()['where'], substr( $this->mountRemove()['data'] ,0,-1) ); |
|
192 | + $this->delete($this->mountRemove()['where'], substr($this->mountRemove()['data'], 0, -1)); |
|
193 | 193 | |
194 | 194 | $this->check_fail(); |
195 | 195 | |
@@ -198,7 +198,7 @@ discard block |
||
198 | 198 | |
199 | 199 | private function removeById(): bool |
200 | 200 | { |
201 | - $delete = $this->delete("{$this->primary}=:{$this->primary}","{$this->primary}={$this->getData()[$this->primary]['value']}"); |
|
201 | + $delete = $this->delete("{$this->primary}=:{$this->primary}", "{$this->primary}={$this->getData()[$this->primary]['value']}"); |
|
202 | 202 | |
203 | 203 | $this->check_fail(); |
204 | 204 | |
@@ -212,7 +212,7 @@ discard block |
||
212 | 212 | $data = []; |
213 | 213 | |
214 | 214 | foreach ($this->data as $key => $value) { |
215 | - if(strstr($this->data[$key]['extra'],'auto_increment')){ |
|
215 | + if (strstr($this->data[$key]['extra'], 'auto_increment')) { |
|
216 | 216 | continue; |
217 | 217 | } |
218 | 218 | |
@@ -224,7 +224,7 @@ discard block |
||
224 | 224 | } |
225 | 225 | |
226 | 226 | $this->transaction('begin'); |
227 | - try{ |
|
227 | + try { |
|
228 | 228 | |
229 | 229 | $id = $this->insert($data); |
230 | 230 | |
@@ -234,7 +234,7 @@ discard block |
||
234 | 234 | |
235 | 235 | $this->transaction('commit'); |
236 | 236 | |
237 | - }catch(Exception $er){ |
|
237 | + } catch (Exception $er) { |
|
238 | 238 | $this->transaction('rollback'); |
239 | 239 | throw $er; |
240 | 240 | } |
@@ -244,13 +244,13 @@ discard block |
||
244 | 244 | |
245 | 245 | public function toEntity() |
246 | 246 | { |
247 | - if($this->getCount() === 0){ |
|
247 | + if ($this->getCount() === 0) { |
|
248 | 248 | return null; |
249 | 249 | } |
250 | 250 | |
251 | 251 | $entity = $this->setByDatabase($this->result[0]); |
252 | 252 | |
253 | - if(count($this->result) > 1){ |
|
253 | + if (count($this->result) > 1) { |
|
254 | 254 | $entity = []; |
255 | 255 | foreach ($this->result as $key => $value) { |
256 | 256 | $entity[] = $this->setByDatabase($value); |
@@ -262,12 +262,12 @@ discard block |
||
262 | 262 | |
263 | 263 | public function findById($id) |
264 | 264 | { |
265 | - return $this->where([$this->primary,'=',$id]); |
|
265 | + return $this->where([$this->primary, '=', $id]); |
|
266 | 266 | } |
267 | 267 | |
268 | 268 | public function execute() |
269 | 269 | { |
270 | - if(!is_null($this->clause) && $this->clause == 'remove'){ |
|
270 | + if (!is_null($this->clause) && $this->clause == 'remove') { |
|
271 | 271 | return $this->remove(true); |
272 | 272 | } |
273 | 273 | |
@@ -275,7 +275,7 @@ discard block |
||
275 | 275 | |
276 | 276 | $this->mountSelect(); |
277 | 277 | |
278 | - $where = substr($this->mountWhereExec()['where'],0,-1); |
|
278 | + $where = substr($this->mountWhereExec()['where'], 0, -1); |
|
279 | 279 | $this->query .= " WHERE {$where} "; |
280 | 280 | |
281 | 281 | $this->query .= $this->order; |
@@ -303,7 +303,7 @@ discard block |
||
303 | 303 | { |
304 | 304 | $this->transaction('begin'); |
305 | 305 | |
306 | - try{ |
|
306 | + try { |
|
307 | 307 | $this->update( |
308 | 308 | $this->mountSave()['data'], |
309 | 309 | "{$this->primary}=:{$this->primary}", |
@@ -313,7 +313,7 @@ discard block |
||
313 | 313 | $this->check_fail(); |
314 | 314 | |
315 | 315 | $this->transaction('commit'); |
316 | - }catch(Exception $er){ |
|
316 | + } catch (Exception $er) { |
|
317 | 317 | $this->transaction('rollback'); |
318 | 318 | throw $er; |
319 | 319 | } |
@@ -2,7 +2,7 @@ discard block |
||
2 | 2 | |
3 | 3 | namespace HnrAzevedo\Datamanager; |
4 | 4 | |
5 | -trait DataTrait{ |
|
5 | +trait DataTrait { |
|
6 | 6 | use CrudTrait, CheckTrait; |
7 | 7 | |
8 | 8 | protected ?string $table = null; |
@@ -24,14 +24,14 @@ discard block |
||
24 | 24 | protected function mountRemove(): array |
25 | 25 | { |
26 | 26 | $return = ['data' => '', 'where' => '']; |
27 | - foreach($this->where as $clause => $condition){ |
|
28 | - if(strlen($clause) === 0){ |
|
27 | + foreach ($this->where as $clause => $condition) { |
|
28 | + if (strlen($clause) === 0) { |
|
29 | 29 | $return['where'] .= " {$clause} {$condition[0]} {$condition[1]} :q_{$condition[0]} "; |
30 | 30 | $return['data'] .= "q_{$condition[0]}={$condition[2]}&"; |
31 | 31 | continue; |
32 | 32 | } |
33 | 33 | |
34 | - foreach($condition as $value){ |
|
34 | + foreach ($condition as $value) { |
|
35 | 35 | $return['where'] .= " {$clause} {$value[0]} {$value[1]} :q_{$value[0]} "; |
36 | 36 | $return['data'] .= "q_{$value[0]}={$value[2]}&"; |
37 | 37 | } |
@@ -44,11 +44,11 @@ discard block |
||
44 | 44 | $return = ['data' => []]; |
45 | 45 | |
46 | 46 | foreach ($this->data as $key => $value) { |
47 | - if(strstr($this->data[$key]['extra'],'auto_increment') && $key !== $this->primary){ |
|
47 | + if (strstr($this->data[$key]['extra'], 'auto_increment') && $key !== $this->primary) { |
|
48 | 48 | continue; |
49 | 49 | } |
50 | 50 | |
51 | - if(($this->data[$key]['changed'] && $this->data[$key]['upgradeable']) || $this->primary === $key){ |
|
51 | + if (($this->data[$key]['changed'] && $this->data[$key]['upgradeable']) || $this->primary === $key) { |
|
52 | 52 | $return['data'][$key] = $this->data[$key]['value']; |
53 | 53 | } |
54 | 54 | } |
@@ -64,7 +64,7 @@ discard block |
||
64 | 64 | |
65 | 65 | $key = (!$key) ? '' : " {$key} "; |
66 | 66 | |
67 | - if(is_array($value[0])){ |
|
67 | + if (is_array($value[0])) { |
|
68 | 68 | |
69 | 69 | foreach ($value as $k => $v) { |
70 | 70 | $return['where'] .= " {$key} {$v[0]} {$v[1]} :q_{$v[0]} "; |
@@ -83,21 +83,21 @@ discard block |
||
83 | 83 | |
84 | 84 | protected function mountSelect() |
85 | 85 | { |
86 | - $select = implode(',',array_keys($this->select)); |
|
86 | + $select = implode(',', array_keys($this->select)); |
|
87 | 87 | |
88 | - $this->query = str_replace('*', $select,$this->query); |
|
88 | + $this->query = str_replace('*', $select, $this->query); |
|
89 | 89 | } |
90 | 90 | |
91 | 91 | protected function mountLimit() |
92 | 92 | { |
93 | - if(!is_null($this->limit)){ |
|
93 | + if (!is_null($this->limit)) { |
|
94 | 94 | $this->query .= " LIMIT {$this->limit}"; |
95 | 95 | } |
96 | 96 | } |
97 | 97 | |
98 | 98 | protected function mountOffset() |
99 | 99 | { |
100 | - if(!is_null($this->offset)){ |
|
100 | + if (!is_null($this->offset)) { |
|
101 | 101 | $this->query .= " OFFSET {$this->offset}"; |
102 | 102 | } |
103 | 103 | } |