@@ -20,8 +20,7 @@ |
||
20 | 20 | if (count($this->pk) == 1) { |
21 | 21 | $pk = end($this->pk); |
22 | 22 | return $this->array[$this->iterator]->$pk; |
23 | - } |
|
24 | - else { |
|
23 | + } else { |
|
25 | 24 | $current = $this->current(); |
26 | 25 | return array_map(function($pkName) use ($current) { |
27 | 26 | return $current->$pkName; |
@@ -7,17 +7,23 @@ |
||
7 | 7 | |
8 | 8 | if (isset($options['offset'])) { |
9 | 9 | $offset = ' OFFSET ' . $options['offset']; |
10 | - if (!$limit) $limit = ' LIMIT 1000'; |
|
10 | + if (!$limit) { |
|
11 | + $limit = ' LIMIT 1000'; |
|
12 | + } |
|
13 | + } else { |
|
14 | + $offset = ''; |
|
11 | 15 | } |
12 | - else $offset = ''; |
|
13 | 16 | |
14 | 17 | $order = isset($options['order']) ? ' ORDER BY ' . $options['order'] : ''; |
15 | 18 | return new Query('SELECT * FROM ' . $table . ' ' . $where . $order . $limit . $offset, $args); |
16 | 19 | } |
17 | 20 | |
18 | 21 | public function aggregate($table, $function, $field, $where, $args, $group) { |
19 | - if ($group == true) $groupBy = ' GROUP BY ' . $field; |
|
20 | - else $groupBy = ''; |
|
22 | + if ($group == true) { |
|
23 | + $groupBy = ' GROUP BY ' . $field; |
|
24 | + } else { |
|
25 | + $groupBy = ''; |
|
26 | + } |
|
21 | 27 | return new Query('SELECT ' . $function . '(' . $field . ') as val, ' . $field . ' FROM ' . $table . ($where != null ? ' WHERE ' . $where : '') . ' ' . $groupBy, $args); |
22 | 28 | } |
23 | 29 | } |
@@ -9,8 +9,7 @@ |
||
9 | 9 | if ($object instanceof \stdclass) { |
10 | 10 | $this->readClosure = function() use ($object) { return $object; }; |
11 | 11 | $this->writeClosure = function ($field, $value) use ($object) { $object->$field = $value; }; |
12 | - } |
|
13 | - else { |
|
12 | + } else { |
|
14 | 13 | $visOverride = $this; |
15 | 14 | $this->readClosure = function() use ($visOverride) { |
16 | 15 | return (object) array_filter(get_object_vars($this), [$visOverride, 'isReturnableDataType']); |
@@ -21,14 +21,18 @@ |
||
21 | 21 | |
22 | 22 | public function wrap($relations, $object, $siblings = []) { |
23 | 23 | //see if any relations need overwriting |
24 | - foreach ($relations as $name => $relation) $this->addRelationData($object, $name, $relation, $siblings); |
|
24 | + foreach ($relations as $name => $relation) { |
|
25 | + $this->addRelationData($object, $name, $relation, $siblings); |
|
26 | + } |
|
25 | 27 | return $object; |
26 | 28 | } |
27 | 29 | |
28 | 30 | private function addRelationData($object, $name, $relation, $siblings) { |
29 | 31 | if (isset($object->$name) && !($object->$name instanceof \Maphper\Relation) ) { |
30 | 32 | //After overwriting the relation, does the parent object ($object) need overwriting as well? |
31 | - if ($relation->overwrite($object, $object->$name)) $this->parent[] = $object; |
|
33 | + if ($relation->overwrite($object, $object->$name)) { |
|
34 | + $this->parent[] = $object; |
|
35 | + } |
|
32 | 36 | } |
33 | 37 | |
34 | 38 | $object->$name = $relation->getData($object, $siblings); |
@@ -19,10 +19,15 @@ discard block |
||
19 | 19 | //For dates with times set, search on time, if the time is not set, search on date only. |
20 | 20 | //E.g. searching for all records posted on '2015-11-14' should return all records that day, not just the ones posted at 00:00:00 on that day |
21 | 21 | if ($value instanceof \DateTime) { |
22 | - if ($value->format('H:i:s') == '00:00:00') $value = $value->format('Y-m-d'); |
|
23 | - else $value = $value->format('Y-m-d H:i:s'); |
|
22 | + if ($value->format('H:i:s') == '00:00:00') { |
|
23 | + $value = $value->format('Y-m-d'); |
|
24 | + } else { |
|
25 | + $value = $value->format('Y-m-d H:i:s'); |
|
26 | + } |
|
27 | + } |
|
28 | + if (is_object($value)) { |
|
29 | + continue; |
|
24 | 30 | } |
25 | - if (is_object($value)) continue; |
|
26 | 31 | if ($prependField){ |
27 | 32 | $sql[] = $this->quote($field) . ' = :' . $field; |
28 | 33 | } else { |
@@ -41,7 +46,9 @@ discard block |
||
41 | 46 | public function update($table, array $primaryKey, $data) { |
42 | 47 | $query = $this->buildSaveQuery($data, true); |
43 | 48 | $where = []; |
44 | - foreach($primaryKey as $field) $where[] = $this->quote($field) . ' = :' . $field; |
|
49 | + foreach($primaryKey as $field) { |
|
50 | + $where[] = $this->quote($field) . ' = :' . $field; |
|
51 | + } |
|
45 | 52 | return new Query('UPDATE ' . $this->quote($table) . ' SET ' . implode(', ', $query['sql']). ' WHERE '. implode(' AND ', $where), $query['args']); |
46 | 53 | } |
47 | 54 | } |
@@ -21,8 +21,11 @@ discard block |
||
21 | 21 | foreach ($fields as $key => $val) { |
22 | 22 | $currentFieldResult = $this->getIfFieldMatches($key, $val, $data, $mode); |
23 | 23 | |
24 | - if (Maphper::FIND_OR & $mode && $currentFieldResult === true) return true; |
|
25 | - else if (Maphper::FIND_OR ^ $mode && $currentFieldResult === false) return false; |
|
24 | + if (Maphper::FIND_OR & $mode && $currentFieldResult === true) { |
|
25 | + return true; |
|
26 | + } else if (Maphper::FIND_OR ^ $mode && $currentFieldResult === false) { |
|
27 | + return false; |
|
28 | + } |
|
26 | 29 | } |
27 | 30 | return (bool)(Maphper::FIND_OR ^ $mode); |
28 | 31 | }; |
@@ -31,12 +34,13 @@ discard block |
||
31 | 34 | private function getIfFieldMatches($key, $val, $data, $mode) { |
32 | 35 | if ($this->shouldRunDeepSearch($key, $val)) { |
33 | 36 | return $this->getSearchFieldFunction($val, $key)($data); |
37 | + } else if (!isset($data->$key)) { |
|
38 | + return false; |
|
39 | + } else if ($this->isInArraySearch($mode, $key, $val)) { |
|
40 | + return in_array($data->$key, $val); |
|
41 | + } else { |
|
42 | + return $this->processFilter($mode, $val, $data->$key); |
|
34 | 43 | } |
35 | - else if (!isset($data->$key)) return false; |
|
36 | - else if ($this->isInArraySearch($mode, $key, $val)) |
|
37 | - return in_array($data->$key, $val); |
|
38 | - else |
|
39 | - return $this->processFilter($mode, $val, $data->$key); |
|
40 | 44 | } |
41 | 45 | |
42 | 46 | private function shouldRunDeepSearch($key, $val) { |
@@ -48,13 +52,21 @@ discard block |
||
48 | 52 | } |
49 | 53 | |
50 | 54 | private function processFilter($mode, $expected, $actual) { |
51 | - if (Maphper::FIND_NOT & $mode) return $expected != $actual; |
|
52 | - else if ((Maphper::FIND_GREATER | Maphper::FIND_EXACT) === $mode) return $expected <= $actual; |
|
53 | - else if ((Maphper::FIND_LESS | Maphper::FIND_EXACT) === $mode) return $expected >= $actual; |
|
54 | - else if (Maphper::FIND_GREATER & $mode) return $expected < $actual; |
|
55 | - else if (Maphper::FIND_LESS & $mode) return $expected > $actual; |
|
56 | - else if (Maphper::FIND_BETWEEN & $mode) return $expected[0] <= $actual && $actual <= $expected[1]; |
|
57 | - else if (Maphper::FIND_NOCASE & $mode) return strtolower($expected) == strtolower($actual); |
|
55 | + if (Maphper::FIND_NOT & $mode) { |
|
56 | + return $expected != $actual; |
|
57 | + } else if ((Maphper::FIND_GREATER | Maphper::FIND_EXACT) === $mode) { |
|
58 | + return $expected <= $actual; |
|
59 | + } else if ((Maphper::FIND_LESS | Maphper::FIND_EXACT) === $mode) { |
|
60 | + return $expected >= $actual; |
|
61 | + } else if (Maphper::FIND_GREATER & $mode) { |
|
62 | + return $expected < $actual; |
|
63 | + } else if (Maphper::FIND_LESS & $mode) { |
|
64 | + return $expected > $actual; |
|
65 | + } else if (Maphper::FIND_BETWEEN & $mode) { |
|
66 | + return $expected[0] <= $actual && $actual <= $expected[1]; |
|
67 | + } else if (Maphper::FIND_NOCASE & $mode) { |
|
68 | + return strtolower($expected) == strtolower($actual); |
|
69 | + } |
|
58 | 70 | return $expected == $actual; |
59 | 71 | } |
60 | 72 | } |
@@ -8,7 +8,9 @@ |
||
8 | 8 | |
9 | 9 | public function getSql($key, $value, $mode) { |
10 | 10 | $nullSql = $key . ' IS '; |
11 | - if (\Maphper\Maphper::FIND_NOT & $mode) $nullSql .= 'NOT '; |
|
11 | + if (\Maphper\Maphper::FIND_NOT & $mode) { |
|
12 | + $nullSql .= 'NOT '; |
|
13 | + } |
|
12 | 14 | $sql = [$nullSql . 'NULL']; |
13 | 15 | |
14 | 16 | return ['args' => [], 'sql' => $sql]; |
@@ -16,8 +16,12 @@ |
||
16 | 16 | } |
17 | 17 | |
18 | 18 | private function getValue($value, $mode) { |
19 | - if ((Maphper::FIND_LIKE | Maphper::FIND_ENDS) & $mode) $value = '%' . $value; |
|
20 | - if ((Maphper::FIND_LIKE | Maphper::FIND_STARTS) & $mode) $value .= '%'; |
|
19 | + if ((Maphper::FIND_LIKE | Maphper::FIND_ENDS) & $mode) { |
|
20 | + $value = '%' . $value; |
|
21 | + } |
|
22 | + if ((Maphper::FIND_LIKE | Maphper::FIND_STARTS) & $mode) { |
|
23 | + $value .= '%'; |
|
24 | + } |
|
21 | 25 | return $value; |
22 | 26 | } |
23 | 27 | } |
@@ -16,8 +16,11 @@ discard block |
||
16 | 16 | } |
17 | 17 | |
18 | 18 | private function getOperator($mode) { |
19 | - if (\Maphper\Maphper::FIND_BIT & $mode) return '&'; |
|
20 | - else if (\Maphper\Maphper::FIND_NOT & $mode) return '!='; |
|
19 | + if (\Maphper\Maphper::FIND_BIT & $mode) { |
|
20 | + return '&'; |
|
21 | + } else if (\Maphper\Maphper::FIND_NOT & $mode) { |
|
22 | + return '!='; |
|
23 | + } |
|
21 | 24 | |
22 | 25 | return $this->getEqualsOperators($mode); |
23 | 26 | } |
@@ -25,10 +28,15 @@ discard block |
||
25 | 28 | private function getEqualsOperators($mode) { |
26 | 29 | $operator = ""; |
27 | 30 | |
28 | - if (\Maphper\Maphper::FIND_GREATER & $mode) $operator = '>'; |
|
29 | - else if (\Maphper\Maphper::FIND_LESS & $mode) $operator = '<'; |
|
31 | + if (\Maphper\Maphper::FIND_GREATER & $mode) { |
|
32 | + $operator = '>'; |
|
33 | + } else if (\Maphper\Maphper::FIND_LESS & $mode) { |
|
34 | + $operator = '<'; |
|
35 | + } |
|
30 | 36 | |
31 | - if (\Maphper\Maphper::FIND_EXACT & $mode) $operator .= '='; |
|
37 | + if (\Maphper\Maphper::FIND_EXACT & $mode) { |
|
38 | + $operator .= '='; |
|
39 | + } |
|
32 | 40 | |
33 | 41 | return $operator; |
34 | 42 | } |