@@ -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 !(Maphper::FIND_OR & $mode); |
| 28 | 31 | }; |
@@ -31,22 +34,31 @@ discard block |
||
| 31 | 34 | private function getIfFieldMatches($key, $val, $data, $mode) { |
| 32 | 35 | if (is_numeric($key) && is_array($val)) { |
| 33 | 36 | return $this->getSearchFieldFunction($val, $key)($data); |
| 37 | + } else if (!isset($data->$key)) { |
|
| 38 | + return false; |
|
| 39 | + } else if (!(Maphper::FIND_BETWEEN & $mode) && !is_numeric($key) && is_array($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 (!(Maphper::FIND_BETWEEN & $mode) && !is_numeric($key) && is_array($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 processFilter($mode, $expected, $actual) { |
| 43 | - if (Maphper::FIND_NOT & $mode) return $expected != $actual; |
|
| 44 | - else if (Maphper::FIND_GREATER & $mode && Maphper::FIND_EXACT & $mode) return $expected <= $actual; |
|
| 45 | - else if (Maphper::FIND_LESS & $mode && Maphper::FIND_EXACT & $mode) return $expected >= $actual; |
|
| 46 | - else if (Maphper::FIND_GREATER & $mode) return $expected < $actual; |
|
| 47 | - else if (Maphper::FIND_LESS & $mode) return $expected > $actual; |
|
| 48 | - else if (Maphper::FIND_BETWEEN & $mode) return $expected[0] <= $actual && $actual <= $expected[1]; |
|
| 49 | - else if (Maphper::FIND_NOCASE & $mode) return strtolower($expected) == strtolower($actual); |
|
| 47 | + if (Maphper::FIND_NOT & $mode) { |
|
| 48 | + return $expected != $actual; |
|
| 49 | + } else if (Maphper::FIND_GREATER & $mode && Maphper::FIND_EXACT & $mode) { |
|
| 50 | + return $expected <= $actual; |
|
| 51 | + } else if (Maphper::FIND_LESS & $mode && Maphper::FIND_EXACT & $mode) { |
|
| 52 | + return $expected >= $actual; |
|
| 53 | + } else if (Maphper::FIND_GREATER & $mode) { |
|
| 54 | + return $expected < $actual; |
|
| 55 | + } else if (Maphper::FIND_LESS & $mode) { |
|
| 56 | + return $expected > $actual; |
|
| 57 | + } else if (Maphper::FIND_BETWEEN & $mode) { |
|
| 58 | + return $expected[0] <= $actual && $actual <= $expected[1]; |
|
| 59 | + } else if (Maphper::FIND_NOCASE & $mode) { |
|
| 60 | + return strtolower($expected) == strtolower($actual); |
|
| 61 | + } |
|
| 50 | 62 | return $expected == $actual; |
| 51 | 63 | } |
| 52 | 64 | } |
@@ -25,8 +25,12 @@ discard block |
||
| 25 | 25 | list($columns, $order) = explode(' ', $options['order']); |
| 26 | 26 | usort($filteredArray, $this->getOrderFunction($order, $columns)); |
| 27 | 27 | } |
| 28 | - if (isset($options['offset'])) $filteredArray = array_slice($filteredArray, $options['offset']); |
|
| 29 | - if (isset($options['limit'])) $filteredArray = array_slice($filteredArray, 0, $options['limit']); |
|
| 28 | + if (isset($options['offset'])) { |
|
| 29 | + $filteredArray = array_slice($filteredArray, $options['offset']); |
|
| 30 | + } |
|
| 31 | + if (isset($options['limit'])) { |
|
| 32 | + $filteredArray = array_slice($filteredArray, 0, $options['limit']); |
|
| 33 | + } |
|
| 30 | 34 | return $filteredArray; |
| 31 | 35 | } |
| 32 | 36 | |
@@ -39,14 +43,15 @@ discard block |
||
| 39 | 43 | } |
| 40 | 44 | |
| 41 | 45 | public function deleteByField(array $fields, array $options) { |
| 42 | - foreach ($this->findByField($fields, $options) as $val) unset($this->data[$val->{$this->id[0]}]); |
|
| 46 | + foreach ($this->findByField($fields, $options) as $val) { |
|
| 47 | + unset($this->data[$val->{$this->id[0]}]); |
|
| 48 | + } |
|
| 43 | 49 | } |
| 44 | 50 | |
| 45 | 51 | public function save($data) { |
| 46 | 52 | if (isset($data->{$this->id[0]})) { |
| 47 | 53 | $id = $data->{$this->id[0]}; |
| 48 | - } |
|
| 49 | - else { |
|
| 54 | + } else { |
|
| 50 | 55 | $id = count($this->data); |
| 51 | 56 | $data->{$this->id[0]} = $id; |
| 52 | 57 | } |
@@ -66,12 +71,16 @@ discard block |
||
| 66 | 71 | if ($aColumn === $bColumn) { |
| 67 | 72 | $sortVal = 0; |
| 68 | 73 | continue; |
| 74 | + } else { |
|
| 75 | + $sortVal = ($aColumn < $bColumn) ? -1 : 1; |
|
| 69 | 76 | } |
| 70 | - else $sortVal = ($aColumn < $bColumn) ? -1 : 1; |
|
| 71 | 77 | break; |
| 72 | 78 | } |
| 73 | - if ($order === 'desc') return -$sortVal; |
|
| 74 | - else return $sortVal; |
|
| 79 | + if ($order === 'desc') { |
|
| 80 | + return -$sortVal; |
|
| 81 | + } else { |
|
| 82 | + return $sortVal; |
|
| 83 | + } |
|
| 75 | 84 | }; |
| 76 | 85 | } |
| 77 | 86 | } |
@@ -14,8 +14,11 @@ |
||
| 14 | 14 | $args[$key . $i] = $value[$i]; |
| 15 | 15 | $inSql[] = ':' . $key . $i; |
| 16 | 16 | } |
| 17 | - if (count($inSql) == 0) return []; |
|
| 18 | - else $sql = [$key . ' IN ( ' . implode(', ', $inSql) . ')']; |
|
| 17 | + if (count($inSql) == 0) { |
|
| 18 | + return []; |
|
| 19 | + } else { |
|
| 20 | + $sql = [$key . ' IN ( ' . implode(', ', $inSql) . ')']; |
|
| 21 | + } |
|
| 19 | 22 | |
| 20 | 23 | return ['args' => $args, 'sql' => $sql]; |
| 21 | 24 | } |
@@ -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 | } |
@@ -13,7 +13,9 @@ discard block |
||
| 13 | 13 | 'Maphper\Lib\Sql\GeneralOperator' |
| 14 | 14 | ]; |
| 15 | 15 | |
| 16 | - foreach ($defaultConditionals as $conditional) $this->addConditional(new $conditional); |
|
| 16 | + foreach ($defaultConditionals as $conditional) { |
|
| 17 | + $this->addConditional(new $conditional); |
|
| 18 | + } |
|
| 17 | 19 | } |
| 18 | 20 | |
| 19 | 21 | public function addConditional(WhereConditional $conditional) { |
@@ -27,11 +29,12 @@ discard block |
||
| 27 | 29 | foreach ($fields as $key => $value) { |
| 28 | 30 | $value = $this->convertDates($value); |
| 29 | 31 | |
| 30 | - if (is_object($value)) continue; |
|
| 32 | + if (is_object($value)) { |
|
| 33 | + continue; |
|
| 34 | + } |
|
| 31 | 35 | if (is_numeric($key) && is_array($value)) { |
| 32 | 36 | $result = $this->createSql($value, $key); |
| 33 | - } |
|
| 34 | - else { |
|
| 37 | + } else { |
|
| 35 | 38 | $result = $this->getConditional($key, $value, $mode); |
| 36 | 39 | } |
| 37 | 40 | $sql = array_merge($sql, (array)$result['sql']); |
@@ -42,24 +45,33 @@ discard block |
||
| 42 | 45 | } |
| 43 | 46 | |
| 44 | 47 | private function sqlArrayToString($sql, $mode) { |
| 45 | - if (\Maphper\Maphper::FIND_OR & $mode) $query = implode(' OR ', $sql); |
|
| 46 | - else $query = implode(' AND ', $sql); |
|
| 47 | - if (!empty($query)) $query = '(' . $query . ')'; |
|
| 48 | + if (\Maphper\Maphper::FIND_OR & $mode) { |
|
| 49 | + $query = implode(' OR ', $sql); |
|
| 50 | + } else { |
|
| 51 | + $query = implode(' AND ', $sql); |
|
| 52 | + } |
|
| 53 | + if (!empty($query)) { |
|
| 54 | + $query = '(' . $query . ')'; |
|
| 55 | + } |
|
| 48 | 56 | return $query; |
| 49 | 57 | } |
| 50 | 58 | |
| 51 | 59 | private function getConditional($key, $value, $mode) { |
| 52 | 60 | foreach ($this->conditionals as $conditional) { |
| 53 | - if ($conditional->matches($key, $value, $mode)) |
|
| 54 | - return $conditional->getSql($key, $value, $mode); |
|
| 61 | + if ($conditional->matches($key, $value, $mode)) { |
|
| 62 | + return $conditional->getSql($key, $value, $mode); |
|
| 63 | + } |
|
| 55 | 64 | } |
| 56 | 65 | throw new \Exception("Invalid WHERE query"); |
| 57 | 66 | } |
| 58 | 67 | |
| 59 | 68 | private function convertDates($value) { |
| 60 | 69 | if ($value instanceof \DateTime) { |
| 61 | - if ($value->format('H:i:s') == '00:00:00') $value = $value->format('Y-m-d'); |
|
| 62 | - else $value = $value->format('Y-m-d H:i:s'); |
|
| 70 | + if ($value->format('H:i:s') == '00:00:00') { |
|
| 71 | + $value = $value->format('Y-m-d'); |
|
| 72 | + } else { |
|
| 73 | + $value = $value->format('Y-m-d H:i:s'); |
|
| 74 | + } |
|
| 63 | 75 | } |
| 64 | 76 | return $value; |
| 65 | 77 | } |
@@ -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 | } |