| @@ -70,7 +70,7 @@ discard block | ||
| 70 | 70 |          if ($cfp->getDateCfpStart()->getTimestamp() < 10000) { | 
| 71 | 71 | $cfp->setDateCfpStart(new \DateTimeImmutable()); | 
| 72 | 72 | } | 
| 73 | - $statement = 'INSERT into `cfp`(`dateCfpStart`, `dateCfpEnd`, `dateEventStart`, `dateEventEnd`, `name`, `uri`, `hash`, `timezone`, `description`, `eventUri`, `iconUri`, `latitude`, `longitude`, `location`, `tags`, `lastUpdate`) ' . | |
| 73 | + $statement = 'INSERT into `cfp`(`dateCfpStart`, `dateCfpEnd`, `dateEventStart`, `dateEventEnd`, `name`, `uri`, `hash`, `timezone`, `description`, `eventUri`, `iconUri`, `latitude`, `longitude`, `location`, `tags`, `lastUpdate`) '. | |
| 74 | 74 | 'VALUES (:dateCfpStart, :dateCfpEnd, :dateEventStart, :dateEventEnd, :name, :uri, :hash, :timezone, :description, :eventUri, :iconUri, :latitude, :longitude, :location, :tags, :lastUpdate);'; | 
| 75 | 75 | $statement = $this->pdo->prepare($statement); | 
| 76 | 76 | |
| @@ -102,7 +102,7 @@ discard block | ||
| 102 | 102 | |
| 103 | 103 | public function update(Cfp $cfp, $fetchHash) | 
| 104 | 104 |      { | 
| 105 | -        if (! $fetchHash) { | |
| 105 | +        if (!$fetchHash) { | |
| 106 | 106 |              throw new \UnexpectedValueException('No Hash given', 400); | 
| 107 | 107 | } | 
| 108 | 108 | $oldValues = $this->select($fetchHash); | 
| @@ -132,17 +132,17 @@ discard block | ||
| 132 | 132 | ]; | 
| 133 | 133 | |
| 134 | 134 |          foreach ($options as $option) { | 
| 135 | - $method = 'get' . $option; | |
| 135 | + $method = 'get'.$option; | |
| 136 | 136 | // Merge values from tags and source before comparing! | 
| 137 | 137 |              if (in_array($option, ['tags', 'source'])) { | 
| 138 | - $setter = 'set' . $option; | |
| 138 | + $setter = 'set'.$option; | |
| 139 | 139 | $cfp->$setter(array_merge($oldValues->$method(), $cfp->$method())); | 
| 140 | 140 | } | 
| 141 | 141 |              if ($cfp->$method() !== $oldValues->$method()) { | 
| 142 | 142 |                  if ($option == 'dateCfpStart' && $cfp->$method()->getTimestamp() < 100000) { | 
| 143 | 143 | continue; | 
| 144 | 144 | } | 
| 145 | - $statementElements[] = '`' . $option . '` = :' . $option; | |
| 145 | + $statementElements[] = '`'.$option.'` = :'.$option; | |
| 146 | 146 | $values[$option] = $cfp->$method(); | 
| 147 | 147 |                  if ($values[$option] instanceof \DateTimeInterface) { | 
| 148 | 148 |                      $values[$option] = $values[$option]->format('c'); | 
| @@ -162,7 +162,7 @@ discard block | ||
| 162 | 162 | } | 
| 163 | 163 | |
| 164 | 164 | $statement = 'UPDATE `cfp` SET ' | 
| 165 | -                   . implode(',', $statementElements) . ',' | |
| 165 | +                   . implode(',', $statementElements).',' | |
| 166 | 166 | . '`lastUpdate` = :lastUpdate ' | 
| 167 | 167 | . 'WHERE `hash` = :fetchHash'; | 
| 168 | 168 | $statement = $this->pdo->prepare($statement); | 
| @@ -298,10 +298,10 @@ discard block | ||
| 298 | 298 | $values = []; | 
| 299 | 299 | $where = []; | 
| 300 | 300 |          foreach ($parameters as $key => $value) { | 
| 301 | -            if (! in_array($key, $fields)) { | |
| 301 | +            if (!in_array($key, $fields)) { | |
| 302 | 302 | continue; | 
| 303 | 303 | } | 
| 304 | -            if (! is_array($value)) { | |
| 304 | +            if (!is_array($value)) { | |
| 305 | 305 | $value = [$value]; | 
| 306 | 306 | } | 
| 307 | 307 |              foreach ($value as $itemkey => $item) { | 
| @@ -312,22 +312,22 @@ discard block | ||
| 312 | 312 | 'date_event_end', | 
| 313 | 313 | 'date_event_start' | 
| 314 | 314 |                  ])) { | 
| 315 | -                    if (array_key_exists($key . '_compare', $parameters) && isset($parameters[$key . '_compare'][$itemkey]) && in_array($parameters[$key . '_compare'][$itemkey], ['=', '<', '>', '<>'])) { | |
| 316 | - $compare = $parameters[$key . '_compare'][$itemkey]; | |
| 315 | +                    if (array_key_exists($key.'_compare', $parameters) && isset($parameters[$key.'_compare'][$itemkey]) && in_array($parameters[$key.'_compare'][$itemkey], ['=', '<', '>', '<>'])) { | |
| 316 | + $compare = $parameters[$key.'_compare'][$itemkey]; | |
| 317 | 317 | } | 
| 318 | - $where[] = $this->timezoneHelper->getUtcDateTime($transformer->transform($key)) . ' ' . $compare . ' :' . $key . '_' . $itemkey; | |
| 318 | + $where[] = $this->timezoneHelper->getUtcDateTime($transformer->transform($key)).' '.$compare.' :'.$key.'_'.$itemkey; | |
| 319 | 319 |                      $value = (new DateTime($item))->setTimezone(new \DateTimeZone('UTC'))->format('c'); | 
| 320 | 320 |                  } else { | 
| 321 | - $where[] = '`' . $transformer->transform($key) . '` ' . $compare . ' :' . $key; | |
| 321 | + $where[] = '`'.$transformer->transform($key).'` '.$compare.' :'.$key; | |
| 322 | 322 | } | 
| 323 | - $values[$key . '_' . $itemkey] = $value; | |
| 323 | + $values[$key.'_'.$itemkey] = $value; | |
| 324 | 324 | } | 
| 325 | 325 | } | 
| 326 | -        if (! $where) { | |
| 326 | +        if (!$where) { | |
| 327 | 327 |              throw new \UnexpectedValueException('No CFPs found', 404); | 
| 328 | 328 | } | 
| 329 | 329 | |
| 330 | -        $statement .= implode(' AND ', $where) . ' ORDER BY dateCfpEnd ASC'; | |
| 330 | +        $statement .= implode(' AND ', $where).' ORDER BY dateCfpEnd ASC'; | |
| 331 | 331 | |
| 332 | 332 | $statement = $this->pdo->prepare($statement); | 
| 333 | 333 | |