@@ -15,7 +15,7 @@ |
||
15 | 15 | $dbCredentials = require('database.php'); |
16 | 16 | $var = $arguments[0]; |
17 | 17 | |
18 | - if(array_key_exists($var, $dbCredentials)){ |
|
18 | + if (array_key_exists($var, $dbCredentials)) { |
|
19 | 19 | return $dbCredentials[$var]; |
20 | 20 | } |
21 | 21 |
@@ -26,7 +26,7 @@ |
||
26 | 26 | |
27 | 27 | public function __call($method, $parameters) |
28 | 28 | { |
29 | - if($method== 'asArray'){ |
|
29 | + if ($method == 'asArray') { |
|
30 | 30 | // $obj = new Utils(); |
31 | 31 | } |
32 | 32 | } |
@@ -50,16 +50,16 @@ |
||
50 | 50 | return $destination; |
51 | 51 | } |
52 | 52 | |
53 | - /** |
|
54 | - * Turn the stadClass object to the type of calling Model |
|
55 | - * |
|
56 | - * @param String $destination |
|
57 | - * @param Object $sourceObject |
|
58 | - * @return Object $destination |
|
59 | - * |
|
60 | - * @author RN Kushwaha <[email protected]> |
|
61 | - * @since v0.0.5 |
|
62 | - */ |
|
53 | + /** |
|
54 | + * Turn the stadClass object to the type of calling Model |
|
55 | + * |
|
56 | + * @param String $destination |
|
57 | + * @param Object $sourceObject |
|
58 | + * @return Object $destination |
|
59 | + * |
|
60 | + * @author RN Kushwaha <[email protected]> |
|
61 | + * @since v0.0.5 |
|
62 | + */ |
|
63 | 63 | public function turnObjects($destination, $data) |
64 | 64 | { |
65 | 65 | $destination = new $destination(); |
@@ -28,7 +28,7 @@ discard block |
||
28 | 28 | public function turnObject($destination, $sourceObject) |
29 | 29 | { |
30 | 30 | $destination = new $destination(); |
31 | - if(!is_object($sourceObject)){ |
|
31 | + if (!is_object($sourceObject)) { |
|
32 | 32 | return $destination; |
33 | 33 | } |
34 | 34 | |
@@ -44,7 +44,7 @@ discard block |
||
44 | 44 | if ($destinationReflection->hasProperty($name)) { |
45 | 45 | $propDest = $destinationReflection->getProperty($name); |
46 | 46 | $propDest->setAccessible(true); |
47 | - $propDest->setValue($destination,$value); |
|
47 | + $propDest->setValue($destination, $value); |
|
48 | 48 | } else { |
49 | 49 | $destination->$name = $value; |
50 | 50 | } |
@@ -66,7 +66,7 @@ discard block |
||
66 | 66 | public function turnObjects($destination, $data) |
67 | 67 | { |
68 | 68 | $destination = new $destination(); |
69 | - if(count($data)){ |
|
69 | + if (count($data)) { |
|
70 | 70 | $destination->data = json_decode(json_encode($data, true)); |
71 | 71 | } |
72 | 72 |
@@ -17,7 +17,7 @@ discard block |
||
17 | 17 | { |
18 | 18 | private $qb; |
19 | 19 | |
20 | - public function __construct(){ |
|
20 | + public function __construct() { |
|
21 | 21 | $this->qb = new QueryBuilder(); |
22 | 22 | } |
23 | 23 | |
@@ -35,7 +35,7 @@ discard block |
||
35 | 35 | |
36 | 36 | foreach ($conditions as $where) { |
37 | 37 | $sign = '='; |
38 | - if(count($where)==3) { |
|
38 | + if (count($where) == 3) { |
|
39 | 39 | $sign = $where[1]; |
40 | 40 | } |
41 | 41 | if ($firstTime) { |
@@ -13,7 +13,7 @@ |
||
13 | 13 | class WhereQueryParser |
14 | 14 | { |
15 | 15 | |
16 | - protected function prepareArrayForWhere($bindKey, $bindVal = null){ |
|
16 | + protected function prepareArrayForWhere($bindKey, $bindVal = null) { |
|
17 | 17 | $ar = $conditionAr = array(); |
18 | 18 | // expecting a string like 'status = :status' |
19 | 19 | if ($this->checkWherePrepareUsed($bindKey)) { |
@@ -287,8 +287,8 @@ discard block |
||
287 | 287 | $this->results = $stmt->fetch(\PDO::FETCH_OBJ); |
288 | 288 | |
289 | 289 | if(count($this->results) ){ |
290 | - // now turn this stdClass object to the object type of calling model |
|
291 | - $rows = $util->turnObject($this->className, $this->results); |
|
290 | + // now turn this stdClass object to the object type of calling model |
|
291 | + $rows = $util->turnObject($this->className, $this->results); |
|
292 | 292 | } |
293 | 293 | // Reset class variables |
294 | 294 | $this->reset(); |
@@ -298,7 +298,7 @@ discard block |
||
298 | 298 | |
299 | 299 | $this->results = $stmt->fetchAll(\PDO::FETCH_ASSOC); |
300 | 300 | if(count($this->results) ){ |
301 | - $rows = $util->turnObjects($this->className, $this->results); |
|
301 | + $rows = $util->turnObjects($this->className, $this->results); |
|
302 | 302 | } |
303 | 303 | // Reset class variables |
304 | 304 | $this->reset(); |
@@ -72,7 +72,7 @@ discard block |
||
72 | 72 | protected $offset; |
73 | 73 | protected $results; |
74 | 74 | |
75 | - private function getFields(array $args, bool $quote = true){ |
|
75 | + private function getFields(array $args, bool $quote = true) { |
|
76 | 76 | $fldAr = array(); |
77 | 77 | $qb = new QueryBuilder(); |
78 | 78 | |
@@ -137,10 +137,10 @@ discard block |
||
137 | 137 | public function where() |
138 | 138 | { |
139 | 139 | $args = func_get_args(); |
140 | - if(func_num_args()===2){ |
|
140 | + if (func_num_args() === 2) { |
|
141 | 141 | $this->where = array_merge($this->where, [[$args[0], '=', $args[1]]]); |
142 | 142 | return $this; |
143 | - } elseif(func_num_args()===3){ |
|
143 | + } elseif (func_num_args() === 3) { |
|
144 | 144 | $this->where = array_merge($this->where, [[$args[0], $args[1], $args[2]]]); |
145 | 145 | return $this; |
146 | 146 | } |
@@ -286,7 +286,7 @@ discard block |
||
286 | 286 | if ($fetchRows == 'first') { |
287 | 287 | $this->results = $stmt->fetch(\PDO::FETCH_OBJ); |
288 | 288 | |
289 | - if(count($this->results) ){ |
|
289 | + if (count($this->results)) { |
|
290 | 290 | // now turn this stdClass object to the object type of calling model |
291 | 291 | $rows = $util->turnObject($this->className, $this->results); |
292 | 292 | } |
@@ -297,7 +297,7 @@ discard block |
||
297 | 297 | } |
298 | 298 | |
299 | 299 | $this->results = $stmt->fetchAll(\PDO::FETCH_ASSOC); |
300 | - if(count($this->results) ){ |
|
300 | + if (count($this->results)) { |
|
301 | 301 | $rows = $util->turnObjects($this->className, $this->results); |
302 | 302 | } |
303 | 303 | // Reset class variables |
@@ -382,7 +382,7 @@ discard block |
||
382 | 382 | |
383 | 383 | $row = $this->first(); |
384 | 384 | |
385 | - if($row == null ){ |
|
385 | + if ($row == null) { |
|
386 | 386 | throw new Exception("The record does not exists!"); |
387 | 387 | } |
388 | 388 | |
@@ -410,9 +410,9 @@ discard block |
||
410 | 410 | $qb = new QueryBuilder(); |
411 | 411 | $query = "TRUNCATE ".$this->table; |
412 | 412 | |
413 | - try{ |
|
413 | + try { |
|
414 | 414 | Connection::get()->query($qb->queryPrefix($query)); |
415 | - } catch(Exception $e){ |
|
415 | + } catch (Exception $e) { |
|
416 | 416 | throw new Exception($e->getMessage()); |
417 | 417 | } |
418 | 418 | |
@@ -448,14 +448,14 @@ discard block |
||
448 | 448 | $query = "UPDATE ".$this->table." SET "; |
449 | 449 | $ar = array(); |
450 | 450 | |
451 | - foreach($row as $key => $val){ |
|
451 | + foreach ($row as $key => $val) { |
|
452 | 452 | $ar[':'.$key] = $val; |
453 | - $query.= $qb->quote($key)." =:".$key.","; |
|
453 | + $query .= $qb->quote($key)." =:".$key.","; |
|
454 | 454 | } |
455 | 455 | |
456 | 456 | $query = rtrim($query, ","); |
457 | 457 | |
458 | - try{ |
|
458 | + try { |
|
459 | 459 | $whereQuery = $wqb->buildAllWhereQuery( |
460 | 460 | $this->where, |
461 | 461 | $this->whereRaw, |
@@ -464,11 +464,11 @@ discard block |
||
464 | 464 | $this->whereNull, |
465 | 465 | $this->whereNotNull |
466 | 466 | ); |
467 | - $query.= " ".join(" ", $whereQuery); |
|
467 | + $query .= " ".join(" ", $whereQuery); |
|
468 | 468 | $stmt = Connection::get()->prepare($qb->queryPrefix($query)); |
469 | 469 | $stmt->execute($ar); |
470 | 470 | $this->reset(); |
471 | - } catch(Exception $e){ |
|
471 | + } catch (Exception $e) { |
|
472 | 472 | throw new Exception($e->getMessage()); |
473 | 473 | } |
474 | 474 | |
@@ -488,7 +488,7 @@ discard block |
||
488 | 488 | $wqb = new WhereQueryBuilder(); |
489 | 489 | $query = "DELETE FROM ".$this->table; |
490 | 490 | |
491 | - try{ |
|
491 | + try { |
|
492 | 492 | $whereQuery = $wqb->buildAllWhereQuery( |
493 | 493 | $this->where, |
494 | 494 | $this->whereRaw, |
@@ -497,10 +497,10 @@ discard block |
||
497 | 497 | $this->whereNull, |
498 | 498 | $this->whereNotNull |
499 | 499 | ); |
500 | - $query.= " ".join(" ", $whereQuery); |
|
500 | + $query .= " ".join(" ", $whereQuery); |
|
501 | 501 | Connection::get()->query($qb->queryPrefix($query)); |
502 | 502 | $this->reset(); |
503 | - } catch(Exception $e){ |
|
503 | + } catch (Exception $e) { |
|
504 | 504 | throw new Exception($e->getMessage()); |
505 | 505 | } |
506 | 506 |
@@ -23,16 +23,16 @@ |
||
23 | 23 | } |
24 | 24 | |
25 | 25 | public function buildQueryStrSingleFromArr($row = array()){ |
26 | - $ar = []; |
|
27 | - $query = "UPDATE ".$this->table." SET "; |
|
28 | - foreach($row as $key => $val){ |
|
29 | - $ar[':'.$key] = $val; |
|
30 | - if($key == 'id') continue; |
|
31 | - $query.= $this->qb->quote($key)." =:".$key.","; |
|
32 | - } |
|
33 | - $query = rtrim($query, ","); |
|
26 | + $ar = []; |
|
27 | + $query = "UPDATE ".$this->table." SET "; |
|
28 | + foreach($row as $key => $val){ |
|
29 | + $ar[':'.$key] = $val; |
|
30 | + if($key == 'id') continue; |
|
31 | + $query.= $this->qb->quote($key)." =:".$key.","; |
|
32 | + } |
|
33 | + $query = rtrim($query, ","); |
|
34 | 34 | |
35 | - return ['ar' => $ar, 'query' => $query]; |
|
35 | + return ['ar' => $ar, 'query' => $query]; |
|
36 | 36 | } |
37 | 37 | public function createQuery($row){ |
38 | 38 | $ar = []; |
@@ -22,33 +22,33 @@ discard block |
||
22 | 22 | $this->qb = new QueryBuilder(); |
23 | 23 | } |
24 | 24 | |
25 | - public function buildQueryStrSingleFromArr($row = array()){ |
|
25 | + public function buildQueryStrSingleFromArr($row = array()) { |
|
26 | 26 | $ar = []; |
27 | 27 | $query = "UPDATE ".$this->table." SET "; |
28 | - foreach($row as $key => $val){ |
|
28 | + foreach ($row as $key => $val) { |
|
29 | 29 | $ar[':'.$key] = $val; |
30 | - if($key == 'id') continue; |
|
31 | - $query.= $this->qb->quote($key)." =:".$key.","; |
|
30 | + if ($key == 'id') continue; |
|
31 | + $query .= $this->qb->quote($key)." =:".$key.","; |
|
32 | 32 | } |
33 | 33 | $query = rtrim($query, ","); |
34 | 34 | |
35 | 35 | return ['ar' => $ar, 'query' => $query]; |
36 | 36 | } |
37 | - public function createQuery($row){ |
|
37 | + public function createQuery($row) { |
|
38 | 38 | $ar = []; |
39 | - if(isset($row) && isset($row->id) && $row->id > 0 ){ |
|
39 | + if (isset($row) && isset($row->id) && $row->id > 0) { |
|
40 | 40 | $mixedData = $this->buildQueryStrSingleFromArr($row); |
41 | - $query= $mixedData['query']." WHERE ".$this->qb->quote('id')."=:id"; |
|
41 | + $query = $mixedData['query']." WHERE ".$this->qb->quote('id')."=:id"; |
|
42 | 42 | |
43 | 43 | return ['query' => $query, 'data' => $mixedData['ar']]; |
44 | 44 | } |
45 | 45 | |
46 | 46 | $queryVal = ''; |
47 | 47 | $query = "INSERT INTO ".$this->table." ("; |
48 | - foreach($row as $key => $val){ |
|
49 | - $query.= $this->qb->quote($key).", "; |
|
48 | + foreach ($row as $key => $val) { |
|
49 | + $query .= $this->qb->quote($key).", "; |
|
50 | 50 | $ar[$key] = $val; |
51 | - $queryVal.= ":".$key.", "; |
|
51 | + $queryVal .= ":".$key.", "; |
|
52 | 52 | } |
53 | 53 | |
54 | 54 | $query = rtrim($query, ", ").") VALUES (".$queryVal.rtrim($query, ", ").") "; |
@@ -73,10 +73,10 @@ discard block |
||
73 | 73 | |
74 | 74 | list($query, $data) = $this->createQuery($row); |
75 | 75 | |
76 | - try{ |
|
76 | + try { |
|
77 | 77 | $stmt = Connection::get()->prepare($this->qb->queryPrefix($query)); |
78 | 78 | $stmt->execute($data); |
79 | - } catch(Exception $e){ |
|
79 | + } catch (Exception $e) { |
|
80 | 80 | throw new Exception($e->getMessage()); |
81 | 81 | } |
82 | 82 |
@@ -27,7 +27,9 @@ |
||
27 | 27 | $query = "UPDATE ".$this->table." SET "; |
28 | 28 | foreach($row as $key => $val){ |
29 | 29 | $ar[':'.$key] = $val; |
30 | - if($key == 'id') continue; |
|
30 | + if($key == 'id') { |
|
31 | + continue; |
|
32 | + } |
|
31 | 33 | $query.= $this->qb->quote($key)." =:".$key.","; |
32 | 34 | } |
33 | 35 | $query = rtrim($query, ","); |
@@ -78,21 +78,21 @@ |
||
78 | 78 | } |
79 | 79 | |
80 | 80 | private function buildLimitQuery($limit, $offset, $query = array()){ |
81 | - $limitQuery = []; |
|
82 | - if (!empty($limit)) { |
|
83 | - $query[] = 'LIMIT'; |
|
81 | + $limitQuery = []; |
|
82 | + if (!empty($limit)) { |
|
83 | + $query[] = 'LIMIT'; |
|
84 | 84 | |
85 | - if (!empty($offset)) { |
|
86 | - $query[] = $offset.','; |
|
87 | - } |
|
85 | + if (!empty($offset)) { |
|
86 | + $query[] = $offset.','; |
|
87 | + } |
|
88 | 88 | |
89 | - $query[] = $limit; |
|
90 | - } |
|
89 | + $query[] = $limit; |
|
90 | + } |
|
91 | 91 | |
92 | - if (count($limitQuery)) { |
|
93 | - $query = array_merge($query, $limitQuery); |
|
94 | - } |
|
95 | - return $query; |
|
92 | + if (count($limitQuery)) { |
|
93 | + $query = array_merge($query, $limitQuery); |
|
94 | + } |
|
95 | + return $query; |
|
96 | 96 | } |
97 | 97 | |
98 | 98 | public function buildQuery(array $params) |
@@ -68,7 +68,7 @@ discard block |
||
68 | 68 | return "'".$field."'"; |
69 | 69 | } |
70 | 70 | |
71 | - private function getQueryFields($fields, $tbl){ |
|
71 | + private function getQueryFields($fields, $tbl) { |
|
72 | 72 | $startQuery = join(', ', $fields); |
73 | 73 | if (empty($fields)) { |
74 | 74 | $startQuery = $this->quote($tbl).'.*'; |
@@ -77,7 +77,7 @@ discard block |
||
77 | 77 | return $startQuery; |
78 | 78 | } |
79 | 79 | |
80 | - private function buildLimitQuery($limit, $offset, $query = array()){ |
|
80 | + private function buildLimitQuery($limit, $offset, $query = array()) { |
|
81 | 81 | $limitQuery = []; |
82 | 82 | if (!empty($limit)) { |
83 | 83 | $query[] = 'LIMIT'; |
@@ -66,7 +66,7 @@ |
||
66 | 66 | } |
67 | 67 | |
68 | 68 | private function checkMultipleInsert($rows = array()){ |
69 | - return is_array($rows) && isset($rows[0]) && is_array($rows[0]); |
|
69 | + return is_array($rows) && isset($rows[0]) && is_array($rows[0]); |
|
70 | 70 | } |
71 | 71 | /** |
72 | 72 | * It inserts the new rows |
@@ -17,55 +17,55 @@ discard block |
||
17 | 17 | */ |
18 | 18 | class InsertQueryBuilder extends QueryBuilder |
19 | 19 | { |
20 | - public function buildInsert($table, $obj){ |
|
20 | + public function buildInsert($table, $obj) { |
|
21 | 21 | $qb = new QueryBuilder(); |
22 | 22 | $query = "INSERT INTO ".$table." ("; |
23 | - foreach($obj as $key => $val){ |
|
24 | - $query.= $qb->quote($key).", "; |
|
23 | + foreach ($obj as $key => $val) { |
|
24 | + $query .= $qb->quote($key).", "; |
|
25 | 25 | } |
26 | 26 | |
27 | 27 | $query = rtrim($query, ", "); |
28 | - $query.= ") VALUES "; |
|
28 | + $query .= ") VALUES "; |
|
29 | 29 | |
30 | 30 | return $query; |
31 | 31 | } |
32 | 32 | |
33 | - public function buildInsertPlaceholder($rows){ |
|
33 | + public function buildInsertPlaceholder($rows) { |
|
34 | 34 | $ar = array(); |
35 | 35 | $query = "("; |
36 | 36 | |
37 | - foreach($rows as $key => $val){ |
|
37 | + foreach ($rows as $key => $val) { |
|
38 | 38 | $ar[$key] = $val; |
39 | - $query.= ":".$key.", "; |
|
39 | + $query .= ":".$key.", "; |
|
40 | 40 | } |
41 | 41 | |
42 | 42 | $query = rtrim($query, ", "); |
43 | - $query.=") "; |
|
43 | + $query .= ") "; |
|
44 | 44 | |
45 | 45 | return ['query' => $query, 'array' => $ar]; |
46 | 46 | } |
47 | 47 | |
48 | - public function buildInsertPlaceholders($rows){ |
|
48 | + public function buildInsertPlaceholders($rows) { |
|
49 | 49 | $bindAr = array(); |
50 | 50 | $query = ""; |
51 | 51 | |
52 | - foreach($rows as $i => $row){ |
|
53 | - $query.="("; |
|
54 | - foreach($row as $key => $val){ |
|
55 | - $param = ":" . $key . $i; |
|
56 | - $query.= $param.", "; |
|
52 | + foreach ($rows as $i => $row) { |
|
53 | + $query .= "("; |
|
54 | + foreach ($row as $key => $val) { |
|
55 | + $param = ":".$key.$i; |
|
56 | + $query .= $param.", "; |
|
57 | 57 | $bindAr[$param] = $val; |
58 | 58 | } |
59 | 59 | |
60 | 60 | $query = rtrim($query, ", "); |
61 | - $query.="), "; |
|
61 | + $query .= "), "; |
|
62 | 62 | } |
63 | 63 | |
64 | 64 | $query = rtrim($query, ", "); |
65 | 65 | return ['query' => $query, 'array' => $bindAr]; |
66 | 66 | } |
67 | 67 | |
68 | - private function checkMultipleInsert($rows = array()){ |
|
68 | + private function checkMultipleInsert($rows = array()) { |
|
69 | 69 | return is_array($rows) && isset($rows[0]) && is_array($rows[0]); |
70 | 70 | } |
71 | 71 | /** |
@@ -85,21 +85,21 @@ discard block |
||
85 | 85 | $dataToBuild = $rows; |
86 | 86 | $methodToCall = 'buildInsertPlaceholder'; |
87 | 87 | |
88 | - if($this->checkMultipleInsert($rows)){ |
|
88 | + if ($this->checkMultipleInsert($rows)) { |
|
89 | 89 | $dataToBuild = $rows[0]; |
90 | 90 | $methodToCall = 'buildInsertPlaceholders'; |
91 | 91 | } |
92 | 92 | |
93 | 93 | $query = $this->buildInsert($table, $dataToBuild); |
94 | 94 | $dataRet = $this->$methodToCall($rows); |
95 | - $query.= $dataRet['query']; |
|
95 | + $query .= $dataRet['query']; |
|
96 | 96 | $bindAr = $dataRet['array']; |
97 | 97 | |
98 | - try{ |
|
98 | + try { |
|
99 | 99 | $stmt = $db->prepare($qb->queryPrefix($query)); |
100 | 100 | |
101 | - if($this->checkMultipleInsert($rows)){ |
|
102 | - foreach($bindAr as $param => $val){ |
|
101 | + if ($this->checkMultipleInsert($rows)) { |
|
102 | + foreach ($bindAr as $param => $val) { |
|
103 | 103 | $stmt->bindValue($param, $val); |
104 | 104 | } |
105 | 105 | |
@@ -109,7 +109,7 @@ discard block |
||
109 | 109 | |
110 | 110 | $stmt->execute($bindAr); |
111 | 111 | return $db->lastInsertId(); |
112 | - } catch(Exception $e){ |
|
112 | + } catch (Exception $e) { |
|
113 | 113 | throw new Exception($e->getMessage()); |
114 | 114 | } |
115 | 115 | } |