@@ -27,8 +27,12 @@ discard block |
||
27 | 27 | list($columns, $order) = explode(' ', $options['order']); |
28 | 28 | usort($filteredArray, $this->getOrderFunction($order, $columns)); |
29 | 29 | } |
30 | - if (isset($options['offset'])) $filteredArray = array_slice($filteredArray, $options['offset']); |
|
31 | - if (isset($options['limit'])) $filteredArray = array_slice($filteredArray, 0, $options['limit']); |
|
30 | + if (isset($options['offset'])) { |
|
31 | + $filteredArray = array_slice($filteredArray, $options['offset']); |
|
32 | + } |
|
33 | + if (isset($options['limit'])) { |
|
34 | + $filteredArray = array_slice($filteredArray, 0, $options['limit']); |
|
35 | + } |
|
32 | 36 | return $filteredArray; |
33 | 37 | } |
34 | 38 | |
@@ -37,8 +41,11 @@ discard block |
||
37 | 41 | foreach ($fields as $key => $val) { |
38 | 42 | $currentFieldResult = $this->getIfFieldMatches($key, $val, $data, $mode); |
39 | 43 | |
40 | - if (Maphper::FIND_OR & $mode && $currentFieldResult === true) return true; |
|
41 | - else if (!(Maphper::FIND_OR & $mode) && $currentFieldResult === false) return false; |
|
44 | + if (Maphper::FIND_OR & $mode && $currentFieldResult === true) { |
|
45 | + return true; |
|
46 | + } else if (!(Maphper::FIND_OR & $mode) && $currentFieldResult === false) { |
|
47 | + return false; |
|
48 | + } |
|
42 | 49 | } |
43 | 50 | return !(Maphper::FIND_OR & $mode); |
44 | 51 | }; |
@@ -47,12 +54,13 @@ discard block |
||
47 | 54 | private function getIfFieldMatches($key, $val, $data, $mode) { |
48 | 55 | if (is_numeric($key) && is_array($val)) { |
49 | 56 | return $this->getSearchFieldFunction($val, $key)($data); |
57 | + } else if (!isset($data->$key)) { |
|
58 | + return false; |
|
59 | + } else if (!(Maphper::FIND_BETWEEN & $mode) && !is_numeric($key) && is_array($val)) { |
|
60 | + return in_array($data->$key, $val); |
|
61 | + } else { |
|
62 | + return $this->processFilter($mode, $val, $data->$key); |
|
50 | 63 | } |
51 | - else if (!isset($data->$key)) return false; |
|
52 | - else if (!(Maphper::FIND_BETWEEN & $mode) && !is_numeric($key) && is_array($val)) |
|
53 | - return in_array($data->$key, $val); |
|
54 | - else |
|
55 | - return $this->processFilter($mode, $val, $data->$key); |
|
56 | 64 | } |
57 | 65 | |
58 | 66 | public function findAggregate($function, $field, $group = null, array $criteria = [], array $options = []) { |
@@ -65,14 +73,15 @@ discard block |
||
65 | 73 | } |
66 | 74 | |
67 | 75 | public function deleteByField(array $fields) { |
68 | - foreach ($this->findByField($fields) as $val) unset($this->data[$val->{$this->id[0]}]); |
|
76 | + foreach ($this->findByField($fields) as $val) { |
|
77 | + unset($this->data[$val->{$this->id[0]}]); |
|
78 | + } |
|
69 | 79 | } |
70 | 80 | |
71 | 81 | public function save($data) { |
72 | 82 | if (isset($data->{$this->id[0]})) { |
73 | 83 | $id = $data->{$this->id[0]}; |
74 | - } |
|
75 | - else { |
|
84 | + } else { |
|
76 | 85 | $id = count($this->data); |
77 | 86 | $data->{$this->id[0]} = $id; |
78 | 87 | } |
@@ -92,23 +101,35 @@ discard block |
||
92 | 101 | if ($aColumn === $bColumn) { |
93 | 102 | $sortVal = 0; |
94 | 103 | continue; |
104 | + } else { |
|
105 | + $sortVal = ($aColumn < $bColumn) ? -1 : 1; |
|
95 | 106 | } |
96 | - else $sortVal = ($aColumn < $bColumn) ? -1 : 1; |
|
97 | 107 | break; |
98 | 108 | } |
99 | - if ($order === 'desc') return -$sortVal; |
|
100 | - else return $sortVal; |
|
109 | + if ($order === 'desc') { |
|
110 | + return -$sortVal; |
|
111 | + } else { |
|
112 | + return $sortVal; |
|
113 | + } |
|
101 | 114 | }; |
102 | 115 | } |
103 | 116 | |
104 | 117 | private function processFilter($mode, $expected, $actual) { |
105 | - if (Maphper::FIND_NOT & $mode) return $expected != $actual; |
|
106 | - else if (Maphper::FIND_GREATER & $mode && Maphper::FIND_EXACT & $mode) return $expected <= $actual; |
|
107 | - else if (Maphper::FIND_LESS & $mode && Maphper::FIND_EXACT & $mode) return $expected >= $actual; |
|
108 | - else if (Maphper::FIND_GREATER & $mode) return $expected < $actual; |
|
109 | - else if (Maphper::FIND_LESS & $mode) return $expected > $actual; |
|
110 | - else if (Maphper::FIND_BETWEEN & $mode) return $expected[0] <= $actual && $actual <= $expected[1]; |
|
111 | - else if (Maphper::FIND_NOCASE & $mode) return strtolower($expected) == strtolower($actual); |
|
118 | + if (Maphper::FIND_NOT & $mode) { |
|
119 | + return $expected != $actual; |
|
120 | + } else if (Maphper::FIND_GREATER & $mode && Maphper::FIND_EXACT & $mode) { |
|
121 | + return $expected <= $actual; |
|
122 | + } else if (Maphper::FIND_LESS & $mode && Maphper::FIND_EXACT & $mode) { |
|
123 | + return $expected >= $actual; |
|
124 | + } else if (Maphper::FIND_GREATER & $mode) { |
|
125 | + return $expected < $actual; |
|
126 | + } else if (Maphper::FIND_LESS & $mode) { |
|
127 | + return $expected > $actual; |
|
128 | + } else if (Maphper::FIND_BETWEEN & $mode) { |
|
129 | + return $expected[0] <= $actual && $actual <= $expected[1]; |
|
130 | + } else if (Maphper::FIND_NOCASE & $mode) { |
|
131 | + return strtolower($expected) == strtolower($actual); |
|
132 | + } |
|
112 | 133 | return $expected == $actual; |
113 | 134 | } |
114 | 135 | } |
@@ -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; |
@@ -9,17 +9,23 @@ discard block |
||
9 | 9 | |
10 | 10 | if (isset($options['offset'])) { |
11 | 11 | $offset = ' OFFSET ' . $options['offset']; |
12 | - if (!$limit) $limit = ' LIMIT 1000'; |
|
12 | + if (!$limit) { |
|
13 | + $limit = ' LIMIT 1000'; |
|
14 | + } |
|
15 | + } else { |
|
16 | + $offset = ''; |
|
13 | 17 | } |
14 | - else $offset = ''; |
|
15 | 18 | |
16 | 19 | $order = isset($options['order']) ? ' ORDER BY ' . $options['order'] : ''; |
17 | 20 | return new Query('SELECT * FROM ' . $table . ' ' . $where . $order . $limit . $offset, $args); |
18 | 21 | } |
19 | 22 | |
20 | 23 | public function aggregate($table, $function, $field, $where, $args, $group) { |
21 | - if ($group == true) $groupBy = ' GROUP BY ' . $field; |
|
22 | - else $groupBy = ''; |
|
24 | + if ($group == true) { |
|
25 | + $groupBy = ' GROUP BY ' . $field; |
|
26 | + } else { |
|
27 | + $groupBy = ''; |
|
28 | + } |
|
23 | 29 | return new Query('SELECT ' . $function . '(' . $field . ') as val, ' . $field . ' FROM ' . $table . ($where[0] != null ? ' WHERE ' : '') . implode(' AND ', $where) . ' ' . $groupBy, $args); |
24 | 30 | } |
25 | 31 | |
@@ -32,64 +38,82 @@ discard block |
||
32 | 38 | foreach ($fields as $key => $value) { |
33 | 39 | if (is_numeric($key) && is_array($value)) { |
34 | 40 | $result = $this->createSql($value, $key); |
35 | - foreach ($result['args'] as $arg_key => $arg) $args[$arg_key] = $arg; |
|
36 | - foreach ($result['sql'] as $arg) $sql[] = $arg; |
|
37 | - } |
|
38 | - else if (\Maphper\Maphper::FIND_BETWEEN & $mode) { |
|
41 | + foreach ($result['args'] as $arg_key => $arg) { |
|
42 | + $args[$arg_key] = $arg; |
|
43 | + } |
|
44 | + foreach ($result['sql'] as $arg) { |
|
45 | + $sql[] = $arg; |
|
46 | + } |
|
47 | + } else if (\Maphper\Maphper::FIND_BETWEEN & $mode) { |
|
39 | 48 | $sql[] = $key . '>= :' . $key . 'from'; |
40 | 49 | $sql[] = $key . ' <= :' . $key . 'to'; |
41 | 50 | |
42 | 51 | $args[$key . 'from'] = $value[0]; |
43 | 52 | $args[$key . 'to'] = $value[1]; |
44 | - } |
|
45 | - else if (!is_numeric($key) && is_array($value)) { |
|
53 | + } else if (!is_numeric($key) && is_array($value)) { |
|
46 | 54 | $inSql = []; |
47 | 55 | $count = count($value); |
48 | 56 | for ($i = 0; $i < $count; $i++) { |
49 | 57 | $args[$key . $i] = $value[$i]; |
50 | 58 | $inSql[] = ':' . $key . $i; |
51 | 59 | } |
52 | - if (count($inSql) == 0) return []; |
|
53 | - else $sql[] = $key . ' IN ( ' . implode(', ', $inSql) . ')'; |
|
54 | - } |
|
55 | - else if ($value === NULL) { |
|
60 | + if (count($inSql) == 0) { |
|
61 | + return []; |
|
62 | + } else { |
|
63 | + $sql[] = $key . ' IN ( ' . implode(', ', $inSql) . ')'; |
|
64 | + } |
|
65 | + } else if ($value === NULL) { |
|
56 | 66 | $nullSql = $key . ' IS '; |
57 | - if (\Maphper\Maphper::FIND_NOT & $mode) $nullSql .= 'NOT '; |
|
67 | + if (\Maphper\Maphper::FIND_NOT & $mode) { |
|
68 | + $nullSql .= 'NOT '; |
|
69 | + } |
|
58 | 70 | $sql[] = $nullSql . 'NULL'; |
59 | - } |
|
60 | - else { |
|
71 | + } else { |
|
61 | 72 | |
62 | 73 | if (\Maphper\Maphper::FIND_LIKE & $mode) { |
63 | 74 | $operator = 'LIKE'; |
64 | 75 | $value = '%' . $value . '%'; |
65 | - } |
|
66 | - else if (\Maphper\Maphper::FIND_STARTS & $mode) { |
|
76 | + } else if (\Maphper\Maphper::FIND_STARTS & $mode) { |
|
67 | 77 | $operator = 'LIKE'; |
68 | 78 | $value = $value . '%'; |
79 | + } else { |
|
80 | + $operator = $this->getOperator($mode); |
|
69 | 81 | } |
70 | - else $operator = $this->getOperator($mode); |
|
71 | 82 | |
72 | 83 | $args[$key] = $value; |
73 | 84 | $sql[] = $key . ' ' . $operator . ' :' . $key; |
74 | 85 | } |
75 | 86 | } |
76 | 87 | |
77 | - if (\Maphper\Maphper::FIND_OR & $mode) $query = implode(' OR ', $sql); |
|
78 | - else $query = implode(' AND ', $sql); |
|
79 | - if (!empty($query)) $query = '(' . $query . ')'; |
|
88 | + if (\Maphper\Maphper::FIND_OR & $mode) { |
|
89 | + $query = implode(' OR ', $sql); |
|
90 | + } else { |
|
91 | + $query = implode(' AND ', $sql); |
|
92 | + } |
|
93 | + if (!empty($query)) { |
|
94 | + $query = '(' . $query . ')'; |
|
95 | + } |
|
80 | 96 | return ['args' => $args, 'sql' => [$query]]; |
81 | 97 | } |
82 | 98 | |
83 | 99 | private function getOperator($mode) { |
84 | 100 | $operator = ""; |
85 | 101 | |
86 | - if (\Maphper\Maphper::FIND_NOCASE & $mode) $operator = 'LIKE'; |
|
87 | - else if (\Maphper\Maphper::FIND_BIT & $mode) $operator = '&'; |
|
88 | - else if (\Maphper\Maphper::FIND_GREATER & $mode) $operator = '>'; |
|
89 | - else if (\Maphper\Maphper::FIND_LESS & $mode) $operator = '<'; |
|
90 | - else if (\Maphper\Maphper::FIND_NOT & $mode) $operator = '!='; |
|
102 | + if (\Maphper\Maphper::FIND_NOCASE & $mode) { |
|
103 | + $operator = 'LIKE'; |
|
104 | + } else if (\Maphper\Maphper::FIND_BIT & $mode) { |
|
105 | + $operator = '&'; |
|
106 | + } else if (\Maphper\Maphper::FIND_GREATER & $mode) { |
|
107 | + $operator = '>'; |
|
108 | + } else if (\Maphper\Maphper::FIND_LESS & $mode) { |
|
109 | + $operator = '<'; |
|
110 | + } else if (\Maphper\Maphper::FIND_NOT & $mode) { |
|
111 | + $operator = '!='; |
|
112 | + } |
|
91 | 113 | |
92 | - if (\Maphper\Maphper::FIND_EXACT & $mode) $operator .= '='; |
|
114 | + if (\Maphper\Maphper::FIND_EXACT & $mode) { |
|
115 | + $operator .= '='; |
|
116 | + } |
|
93 | 117 | |
94 | 118 | return $operator; |
95 | 119 | } |
@@ -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 | } |
@@ -25,8 +25,11 @@ |
||
25 | 25 | |
26 | 26 | public function offsetGet($key) { |
27 | 27 | $depth = $this->getDepth()+1; |
28 | - if (count($this->primaryKey)-1 == $depth) return $this->mapper->filter([$this->primaryKey[$depth] => $key])->item(0); |
|
29 | - else return new MultiPk($this->mapper, $key, $this->primaryKey, $this); |
|
28 | + if (count($this->primaryKey)-1 == $depth) { |
|
29 | + return $this->mapper->filter([$this->primaryKey[$depth] => $key])->item(0); |
|
30 | + } else { |
|
31 | + return new MultiPk($this->mapper, $key, $this->primaryKey, $this); |
|
32 | + } |
|
30 | 33 | } |
31 | 34 | |
32 | 35 | public function offsetSet($key, $value) { |
@@ -6,7 +6,9 @@ discard block |
||
6 | 6 | private $localField; |
7 | 7 | |
8 | 8 | public function __construct(\Maphper\Maphper $mapper, $parentField, $localField, array $critiera = []) { |
9 | - if ($critiera) $mapper->filter($critiera); |
|
9 | + if ($critiera) { |
|
10 | + $mapper->filter($critiera); |
|
11 | + } |
|
10 | 12 | $this->mapper = $mapper; |
11 | 13 | $this->parentField = $parentField; |
12 | 14 | $this->localField = $localField; |
@@ -14,17 +16,24 @@ discard block |
||
14 | 16 | |
15 | 17 | |
16 | 18 | public function getData($parentObject) { |
17 | - if (!isset($parentObject->{$this->parentField})) $mapper = $this->mapper; |
|
18 | - else $mapper = $this->mapper->filter([$this->localField => $parentObject->{$this->parentField}]); |
|
19 | + if (!isset($parentObject->{$this->parentField})) { |
|
20 | + $mapper = $this->mapper; |
|
21 | + } else { |
|
22 | + $mapper = $this->mapper->filter([$this->localField => $parentObject->{$this->parentField}]); |
|
23 | + } |
|
19 | 24 | |
20 | 25 | return $mapper; |
21 | 26 | } |
22 | 27 | |
23 | 28 | |
24 | 29 | public function overwrite($key, &$mapper) { |
25 | - if (!isset($key->{$this->parentField})) return false; |
|
30 | + if (!isset($key->{$this->parentField})) { |
|
31 | + return false; |
|
32 | + } |
|
26 | 33 | foreach ($mapper as $k => $val) { |
27 | - if (!empty($val->{$this->localField}) && $val->{$this->localField} == $key->{$this->parentField}) continue; |
|
34 | + if (!empty($val->{$this->localField}) && $val->{$this->localField} == $key->{$this->parentField}) { |
|
35 | + continue; |
|
36 | + } |
|
28 | 37 | $val->{$this->localField} = $key->{$this->parentField}; |
29 | 38 | $this->mapper[] = $val; |
30 | 39 | } |
@@ -31,7 +31,9 @@ discard block |
||
31 | 31 | public function overwrite($parentObject, &$data) { |
32 | 32 | $this->results = $data; |
33 | 33 | $this->object = $parentObject; |
34 | - foreach ($data as $dt) $this[] = $dt; |
|
34 | + foreach ($data as $dt) { |
|
35 | + $this[] = $dt; |
|
36 | + } |
|
35 | 37 | } |
36 | 38 | |
37 | 39 | //bit hacky, breaking encapsulation, but simplest way to work out the info for the other side of the many:many relationship. |
@@ -92,15 +94,13 @@ discard block |
||
92 | 94 | $record->$valueField = $this->object->{$relatedField}; |
93 | 95 | $this->intermediateMapper[] = $record; |
94 | 96 | |
95 | - } |
|
96 | - else { |
|
97 | + } else { |
|
97 | 98 | $record = $value; |
98 | 99 | if (isset($record->{$this->parentField}) && isset($value->{$this->intermediateName}) && |
99 | 100 | $record->{$this->parentField} == $value->{$this->intermediateName}->{$this->localField} && |
100 | 101 | $record->$valueField == $this->object->{$relatedField}) { |
101 | 102 | return; |
102 | - } |
|
103 | - else { |
|
103 | + } else { |
|
104 | 104 | $record->{$this->parentField} = $value->{$this->intermediateName}->{$this->localField}; |
105 | 105 | $record->$valueField = $this->object->{$relatedField}; |
106 | 106 | $this->intermediateMapper[] = $record; |
@@ -30,7 +30,9 @@ discard block |
||
30 | 30 | private function lazyLoad() { |
31 | 31 | if (!isset($this->data)) { |
32 | 32 | |
33 | - if ($this->parentObject == null) throw new \Exception('Error, no object set'); |
|
33 | + if ($this->parentObject == null) { |
|
34 | + throw new \Exception('Error, no object set'); |
|
35 | + } |
|
34 | 36 | |
35 | 37 | $this->eagerLoad(); |
36 | 38 | |
@@ -47,8 +49,11 @@ discard block |
||
47 | 49 | |
48 | 50 | $recordsToLoad = array_unique($recordsToLoad); |
49 | 51 | //Fetch the results so they're in the cache for the corresponding maphper object |
50 | - if ($this->criteria) $results = $this->mapper->filter($this->criteira)->filter([$this->localField => $recordsToLoad]); |
|
51 | - else $results = $this->mapper->filter([$this->localField => $recordsToLoad]); |
|
52 | + if ($this->criteria) { |
|
53 | + $results = $this->mapper->filter($this->criteira)->filter([$this->localField => $recordsToLoad]); |
|
54 | + } else { |
|
55 | + $results = $this->mapper->filter([$this->localField => $recordsToLoad]); |
|
56 | + } |
|
52 | 57 | |
53 | 58 | $cache = []; |
54 | 59 | foreach ($results as $result) { |
@@ -68,13 +73,18 @@ discard block |
||
68 | 73 | } |
69 | 74 | |
70 | 75 | public function __call($func, array $args = []) { |
71 | - if ($this->lazyLoad() == null) return ''; |
|
76 | + if ($this->lazyLoad() == null) { |
|
77 | + return ''; |
|
78 | + } |
|
72 | 79 | return call_user_func_array([$this->lazyLoad(), $func], $args); |
73 | 80 | } |
74 | 81 | |
75 | 82 | public function __get($name) { |
76 | - if ($this->lazyLoad()) return $this->lazyLoad()->$name; |
|
77 | - else return null; |
|
83 | + if ($this->lazyLoad()) { |
|
84 | + return $this->lazyLoad()->$name; |
|
85 | + } else { |
|
86 | + return null; |
|
87 | + } |
|
78 | 88 | } |
79 | 89 | |
80 | 90 | public function __isset($name) { |
@@ -12,7 +12,9 @@ |
||
12 | 12 | } |
13 | 13 | |
14 | 14 | public function current() { |
15 | - if ($this->intermediateName) return $this->iterator->current()->{$this->intermediateName}; |
|
15 | + if ($this->intermediateName) { |
|
16 | + return $this->iterator->current()->{$this->intermediateName}; |
|
17 | + } |
|
16 | 18 | return $this->iterator->current(); |
17 | 19 | } |
18 | 20 |