| @@ -54,7 +54,7 @@ discard block | ||
| 54 | 54 | |
| 55 | 55 |          if (count($where) > 0) { | 
| 56 | 56 |              foreach ($where as $column => $value) { | 
| 57 | - $queryBuilder->andWhere($column . ' = ' . $queryBuilder->createNamedParameter($value)); | |
| 57 | + $queryBuilder->andWhere($column . ' = ' . $queryBuilder->createNamedParameter($value)); | |
| 58 | 58 | } | 
| 59 | 59 | } | 
| 60 | 60 | |
| @@ -97,7 +97,7 @@ discard block | ||
| 97 | 97 | $databaseArray | 
| 98 | 98 | ); | 
| 99 | 99 | |
| 100 | - $entity->id = (int) $this->connection->lastInsertId(); | |
| 100 | + $entity->id = (int)$this->connection->lastInsertId(); | |
| 101 | 101 | |
| 102 | 102 | return $entity; | 
| 103 | 103 | } | 
| @@ -125,7 +125,7 @@ discard block | ||
| 125 | 125 | ['id' => $entity->id] | 
| 126 | 126 | ); | 
| 127 | 127 | |
| 128 | - $entity->id = (int) $this->connection->lastInsertId(); | |
| 128 | + $entity->id = (int)$this->connection->lastInsertId(); | |
| 129 | 129 | |
| 130 | 130 | return $entity; | 
| 131 | 131 | } | 
| @@ -169,7 +169,7 @@ discard block | ||
| 169 | 169 | 'page_id' => $entity->pageId, | 
| 170 | 170 | 'title' => $entity->title, | 
| 171 | 171 | 'html' => $entity->html, | 
| 172 | - 'position' => (int) $entity->position, | |
| 172 | + 'position' => (int)$entity->position, | |
| 173 | 173 | 'updated_at' => $entity->updatedAt->format(DateTime::ATOM), | 
| 174 | 174 | 'active' => $entity->active | 
| 175 | 175 | ]; | 
| @@ -185,13 +185,13 @@ discard block | ||
| 185 | 185 | public function getEntityFromDatabaseArray(array $data) | 
| 186 | 186 |      { | 
| 187 | 187 | $entity = new BlockEntity(); | 
| 188 | - $entity->id = (int) $data['id']; | |
| 189 | - $entity->pageId = (int) $data['page_id']; | |
| 190 | - $entity->title = (string) $data['title']; | |
| 191 | - $entity->html = (string) $data['html']; | |
| 192 | - $entity->position = (int) $data['position']; | |
| 188 | + $entity->id = (int)$data['id']; | |
| 189 | + $entity->pageId = (int)$data['page_id']; | |
| 190 | + $entity->title = (string)$data['title']; | |
| 191 | + $entity->html = (string)$data['html']; | |
| 192 | + $entity->position = (int)$data['position']; | |
| 193 | 193 | $entity->updatedAt = new DateTime($data['updated_at']); | 
| 194 | - $entity->active = (bool) $data['active']; | |
| 194 | + $entity->active = (bool)$data['active']; | |
| 195 | 195 | |
| 196 | 196 | return $entity; | 
| 197 | 197 | } | 
| @@ -25,7 +25,7 @@ | ||
| 25 | 25 |      { | 
| 26 | 26 | $this->setViolations($violations); | 
| 27 | 27 | |
| 28 | - parent::__construct((string) $this); | |
| 28 | + parent::__construct((string)$this); | |
| 29 | 29 | } | 
| 30 | 30 | |
| 31 | 31 | /** | 
| @@ -79,9 +79,9 @@ discard block | ||
| 79 | 79 | public function fetchOneBy(array $where = []) | 
| 80 | 80 |      { | 
| 81 | 81 | $queryBuilder = $this->connection->createQueryBuilder() | 
| 82 | -             ->select('*') | |
| 83 | - ->from(self::TABLE) | |
| 84 | - ->setMaxResults(1); | |
| 82 | +                ->select('*') | |
| 83 | + ->from(self::TABLE) | |
| 84 | + ->setMaxResults(1); | |
| 85 | 85 | |
| 86 | 86 |          if (count($where) > 0) { | 
| 87 | 87 |              foreach ($where as $column => $value) { | 
| @@ -112,8 +112,8 @@ discard block | ||
| 112 | 112 | public function fetchBy(array $where = []) | 
| 113 | 113 |      { | 
| 114 | 114 | $queryBuilder = $this->connection->createQueryBuilder() | 
| 115 | -             ->select('*') | |
| 116 | - ->from(self::TABLE); | |
| 115 | +                ->select('*') | |
| 116 | + ->from(self::TABLE); | |
| 117 | 117 | |
| 118 | 118 |          if (count($where) > 0) { | 
| 119 | 119 |              foreach ($where as $column => $value) { | 
| @@ -85,7 +85,7 @@ discard block | ||
| 85 | 85 | |
| 86 | 86 |          if (count($where) > 0) { | 
| 87 | 87 |              foreach ($where as $column => $value) { | 
| 88 | - $queryBuilder->andWhere($column . ' = ' . $queryBuilder->createNamedParameter($value)); | |
| 88 | + $queryBuilder->andWhere($column . ' = ' . $queryBuilder->createNamedParameter($value)); | |
| 89 | 89 | } | 
| 90 | 90 | } | 
| 91 | 91 | |
| @@ -117,7 +117,7 @@ discard block | ||
| 117 | 117 | |
| 118 | 118 |          if (count($where) > 0) { | 
| 119 | 119 |              foreach ($where as $column => $value) { | 
| 120 | - $queryBuilder->andWhere($column . ' = ' . $queryBuilder->createNamedParameter($value)); | |
| 120 | + $queryBuilder->andWhere($column . ' = ' . $queryBuilder->createNamedParameter($value)); | |
| 121 | 121 | } | 
| 122 | 122 | } | 
| 123 | 123 | |
| @@ -292,27 +292,27 @@ discard block | ||
| 292 | 292 | public function getEntityFromDatabaseArray(array $data) | 
| 293 | 293 |      { | 
| 294 | 294 | $entity = new GeoCacheLogEntity(); | 
| 295 | - $entity->id = (int) $data['id']; | |
| 296 | - $entity->uuid = (string) $data['uuid']; | |
| 297 | - $entity->node = (int) $data['node']; | |
| 295 | + $entity->id = (int)$data['id']; | |
| 296 | + $entity->uuid = (string)$data['uuid']; | |
| 297 | + $entity->node = (int)$data['node']; | |
| 298 | 298 | $entity->dateCreated = new DateTime($data['date_created']); | 
| 299 | 299 | $entity->entryLastModified = new DateTime($data['entry_last_modified']); | 
| 300 | 300 | $entity->lastModified = new DateTime($data['last_modified']); | 
| 301 | - $entity->okapiSyncbase = (int) $data['okapi_syncbase']; | |
| 301 | + $entity->okapiSyncbase = (int)$data['okapi_syncbase']; | |
| 302 | 302 | $entity->logLastModified = new DateTime($data['log_last_modified']); | 
| 303 | - $entity->cacheId = (int) $data['cache_id']; | |
| 304 | - $entity->userId = (int) $data['user_id']; | |
| 305 | - $entity->type = (int) $data['type']; | |
| 306 | - $entity->ocTeamComment = (bool) $data['oc_team_comment']; | |
| 303 | + $entity->cacheId = (int)$data['cache_id']; | |
| 304 | + $entity->userId = (int)$data['user_id']; | |
| 305 | + $entity->type = (int)$data['type']; | |
| 306 | + $entity->ocTeamComment = (bool)$data['oc_team_comment']; | |
| 307 | 307 | $entity->date = new DateTime($data['date']); | 
| 308 | 308 | $entity->orderDate = new DateTime($data['order_date']); | 
| 309 | - $entity->needsMaintenance = (bool) $data['needs_maintenance']; | |
| 310 | - $entity->listingOutdated = (bool) $data['listing_outdated']; | |
| 311 | - $entity->text = (string) $data['text']; | |
| 312 | - $entity->textHtml = (bool) $data['text_html']; | |
| 313 | - $entity->textHtmledit = (bool) $data['text_htmledit']; | |
| 314 | - $entity->ownerNotified = (bool) $data['owner_notified']; | |
| 315 | - $entity->picture = (int) $data['picture']; | |
| 309 | + $entity->needsMaintenance = (bool)$data['needs_maintenance']; | |
| 310 | + $entity->listingOutdated = (bool)$data['listing_outdated']; | |
| 311 | + $entity->text = (string)$data['text']; | |
| 312 | + $entity->textHtml = (bool)$data['text_html']; | |
| 313 | + $entity->textHtmledit = (bool)$data['text_htmledit']; | |
| 314 | + $entity->ownerNotified = (bool)$data['owner_notified']; | |
| 315 | + $entity->picture = (int)$data['picture']; | |
| 316 | 316 | |
| 317 | 317 | return $entity; | 
| 318 | 318 | } | 
| @@ -80,9 +80,9 @@ discard block | ||
| 80 | 80 | public function fetchOneBy(array $where = []) | 
| 81 | 81 |      { | 
| 82 | 82 | $queryBuilder = $this->connection->createQueryBuilder() | 
| 83 | -             ->select('*') | |
| 84 | - ->from(self::TABLE) | |
| 85 | - ->setMaxResults(1); | |
| 83 | +                ->select('*') | |
| 84 | + ->from(self::TABLE) | |
| 85 | + ->setMaxResults(1); | |
| 86 | 86 | |
| 87 | 87 |          if (count($where) > 0) { | 
| 88 | 88 |              foreach ($where as $column => $value) { | 
| @@ -113,8 +113,8 @@ discard block | ||
| 113 | 113 | public function fetchBy(array $where = []) | 
| 114 | 114 |      { | 
| 115 | 115 | $queryBuilder = $this->connection->createQueryBuilder() | 
| 116 | -             ->select('*') | |
| 117 | - ->from(self::TABLE); | |
| 116 | +                ->select('*') | |
| 117 | + ->from(self::TABLE); | |
| 118 | 118 | |
| 119 | 119 |          if (count($where) > 0) { | 
| 120 | 120 |              foreach ($where as $column => $value) { | 
| @@ -86,7 +86,7 @@ discard block | ||
| 86 | 86 | |
| 87 | 87 |          if (count($where) > 0) { | 
| 88 | 88 |              foreach ($where as $column => $value) { | 
| 89 | - $queryBuilder->andWhere($column . ' = ' . $queryBuilder->createNamedParameter($value)); | |
| 89 | + $queryBuilder->andWhere($column . ' = ' . $queryBuilder->createNamedParameter($value)); | |
| 90 | 90 | } | 
| 91 | 91 | } | 
| 92 | 92 | |
| @@ -118,7 +118,7 @@ discard block | ||
| 118 | 118 | |
| 119 | 119 |          if (count($where) > 0) { | 
| 120 | 120 |              foreach ($where as $column => $value) { | 
| 121 | - $queryBuilder->andWhere($column . ' = ' . $queryBuilder->createNamedParameter($value)); | |
| 121 | + $queryBuilder->andWhere($column . ' = ' . $queryBuilder->createNamedParameter($value)); | |
| 122 | 122 | } | 
| 123 | 123 | } | 
| 124 | 124 | |
| @@ -310,40 +310,40 @@ discard block | ||
| 310 | 310 | public function getEntityFromDatabaseArray(array $data) | 
| 311 | 311 |      { | 
| 312 | 312 | $entity = new GeoCacheEntity(); | 
| 313 | - $entity->cacheId = (string) $data['cache_id']; | |
| 314 | - $entity->uuid = (string) $data['uuid']; | |
| 315 | - $entity->node = (int) $data['node']; | |
| 313 | + $entity->cacheId = (string)$data['cache_id']; | |
| 314 | + $entity->uuid = (string)$data['uuid']; | |
| 315 | + $entity->node = (int)$data['node']; | |
| 316 | 316 | $entity->dateCreated = new DateTime($data['date_created']); | 
| 317 | - $entity->isPublishdate = (bool) $data['is_publishdate']; | |
| 317 | + $entity->isPublishdate = (bool)$data['is_publishdate']; | |
| 318 | 318 | $entity->lastModified = new DateTime($data['last_modified']); | 
| 319 | - $entity->okapiSyncbase = (int) $data['okapi_syncbase']; | |
| 319 | + $entity->okapiSyncbase = (int)$data['okapi_syncbase']; | |
| 320 | 320 | $entity->listingLastModified = new DateTime($data['listing_last_modified']); | 
| 321 | 321 | $entity->metaLastModified = new DateTime($data['meta_last_modified']); | 
| 322 | - $entity->userId = (int) $data['user_id']; | |
| 323 | - $entity->name = (string) $data['name']; | |
| 324 | - $entity->longitude = (double) $data['longitude']; | |
| 325 | - $entity->latitude = (double) $data['latitude']; | |
| 326 | - $entity->type = (int) $data['type']; | |
| 327 | - $entity->status = (int) $data['status']; | |
| 328 | - $entity->country = (string) $data['country']; | |
| 322 | + $entity->userId = (int)$data['user_id']; | |
| 323 | + $entity->name = (string)$data['name']; | |
| 324 | + $entity->longitude = (double)$data['longitude']; | |
| 325 | + $entity->latitude = (double)$data['latitude']; | |
| 326 | + $entity->type = (int)$data['type']; | |
| 327 | + $entity->status = (int)$data['status']; | |
| 328 | + $entity->country = (string)$data['country']; | |
| 329 | 329 | $entity->dateHidden = new DateTime($data['date_hidden']); | 
| 330 | - $entity->size = (int) $data['size']; | |
| 331 | - $entity->difficulty = (int) $data['difficulty']; | |
| 332 | - $entity->terrain = (int) $data['terrain']; | |
| 333 | - $entity->logpw = (string) $data['logpw']; | |
| 334 | - $entity->searchTime = (float) $data['search_time']; | |
| 335 | - $entity->wayLength = (float) $data['way_length']; | |
| 336 | - $entity->wpGc = (string) $data['wp_gc']; | |
| 337 | - $entity->wpGcMaintained = (string) $data['wp_gc_maintained']; | |
| 338 | - $entity->wpOc = (string) $data['wp_oc']; | |
| 339 | - $entity->descLanguages = (string) $data['desc_languages']; | |
| 340 | - $entity->defaultDesclang = (string) $data['default_desclang']; | |
| 330 | + $entity->size = (int)$data['size']; | |
| 331 | + $entity->difficulty = (int)$data['difficulty']; | |
| 332 | + $entity->terrain = (int)$data['terrain']; | |
| 333 | + $entity->logpw = (string)$data['logpw']; | |
| 334 | + $entity->searchTime = (float)$data['search_time']; | |
| 335 | + $entity->wayLength = (float)$data['way_length']; | |
| 336 | + $entity->wpGc = (string)$data['wp_gc']; | |
| 337 | + $entity->wpGcMaintained = (string)$data['wp_gc_maintained']; | |
| 338 | + $entity->wpOc = (string)$data['wp_oc']; | |
| 339 | + $entity->descLanguages = (string)$data['desc_languages']; | |
| 340 | + $entity->defaultDesclang = (string)$data['default_desclang']; | |
| 341 | 341 | $entity->dateActivate = new DateTime($data['date_activate']); | 
| 342 | - $entity->needNpaRecalc = (bool) $data['need_npa_recalc']; | |
| 343 | - $entity->showCachelists = (bool) $data['show_cachelists']; | |
| 344 | - $entity->protectOldCoords = (bool) $data['protect_old_coords']; | |
| 345 | - $entity->needsMaintenance = (bool) $data['needs_maintenance']; | |
| 346 | - $entity->listingOutdated = (bool) $data['listing_outdated']; | |
| 342 | + $entity->needNpaRecalc = (bool)$data['need_npa_recalc']; | |
| 343 | + $entity->showCachelists = (bool)$data['show_cachelists']; | |
| 344 | + $entity->protectOldCoords = (bool)$data['protect_old_coords']; | |
| 345 | + $entity->needsMaintenance = (bool)$data['needs_maintenance']; | |
| 346 | + $entity->listingOutdated = (bool)$data['listing_outdated']; | |
| 347 | 347 | $entity->flagsLastModified = new DateTime($data['flags_last_modified']); | 
| 348 | 348 | |
| 349 | 349 | return $entity; | 
| @@ -90,7 +90,7 @@ discard block | ||
| 90 | 90 | ->from(self::TABLE); | 
| 91 | 91 | |
| 92 | 92 |          foreach ($where as $column => $value) { | 
| 93 | - $queryBuilder->andWhere($column . ' = ' . $queryBuilder->createNamedParameter($value)); | |
| 93 | + $queryBuilder->andWhere($column . ' = ' . $queryBuilder->createNamedParameter($value)); | |
| 94 | 94 | } | 
| 95 | 95 | |
| 96 | 96 |          foreach ($order as $field => $direction) { | 
| @@ -132,7 +132,7 @@ discard block | ||
| 132 | 132 | |
| 133 | 133 |          if (count($where) > 0) { | 
| 134 | 134 |              foreach ($where as $column => $value) { | 
| 135 | - $queryBuilder->andWhere($column . ' = ' . $queryBuilder->createNamedParameter($value)); | |
| 135 | + $queryBuilder->andWhere($column . ' = ' . $queryBuilder->createNamedParameter($value)); | |
| 136 | 136 | } | 
| 137 | 137 | } | 
| 138 | 138 | |
| @@ -286,7 +286,7 @@ discard block | ||
| 286 | 286 | public function getEntityFromDatabaseArray(array $data) | 
| 287 | 287 |      { | 
| 288 | 288 | $entity = new FieldNoteEntity(); | 
| 289 | - $entity->id = (string) $data['id']; | |
| 289 | + $entity->id = (string)$data['id']; | |
| 290 | 290 | $entity->userId = $data['user_id']; | 
| 291 | 291 | $entity->geocacheId = $data['geocache_id']; | 
| 292 | 292 | $entity->type = $data['type']; | 
| @@ -49,8 +49,8 @@ discard block | ||
| 49 | 49 | $fieldNoteService = AppKernel::Container()->get(FieldNoteService::class); | 
| 50 | 50 | |
| 51 | 51 | $fieldNote = $fieldNoteService->fetchOneBy([ | 
| 52 | - 'id' => (int) $_GET['fieldnoteid'], | |
| 53 | - 'user_id' => (int) $user->getUserId() | |
| 52 | + 'id' => (int)$_GET['fieldnoteid'], | |
| 53 | + 'user_id' => (int)$user->getUserId() | |
| 54 | 54 | ]); | 
| 55 | 55 | |
| 56 | 56 |      if ($fieldNote !== null) { | 
| @@ -171,7 +171,7 @@ discard block | ||
| 171 | 171 | // get log text editor mode (from form or from userprofile) | 
| 172 | 172 | // 1 = text; 2 = HTML; 3 = tinyMCE | 
| 173 | 173 |      if (isset($_POST['descMode'])) { | 
| 174 | - $descMode = $_POST['descMode'] + 0; // Ocprop: 2 | |
| 174 | + $descMode = $_POST['descMode'] + 0; // Ocprop: 2 | |
| 175 | 175 |          if (($descMode < 1) || ($descMode > 3)) { | 
| 176 | 176 | $descMode = 3; | 
| 177 | 177 | } | 
| @@ -313,7 +313,7 @@ discard block | ||
| 313 | 313 |              if (isset($_REQUEST['fieldnoteid']) && $_REQUEST['fieldnoteid']) { | 
| 314 | 314 | sql( | 
| 315 | 315 | 'DELETE FROM field_note WHERE `id` = &1 AND `user_id` = &2', | 
| 316 | - (int) $_REQUEST['fieldnoteid'], | |
| 316 | + (int)$_REQUEST['fieldnoteid'], | |
| 317 | 317 | $user->getUserId() | 
| 318 | 318 | ); | 
| 319 | 319 | |