| @@ -57,7 +57,7 @@ | ||
| 57 | 57 | $i = 1; | 
| 58 | 58 |              foreach ($filters as $w_key => $w_value) { | 
| 59 | 59 |                  $qb->andWhere($qb->expr()->eq('tbl.' . $w_key, '?' . $i)) | 
| 60 | - ->setParameter($i, $w_value); | |
| 60 | + ->setParameter($i, $w_value); | |
| 61 | 61 | $i++; | 
| 62 | 62 | } | 
| 63 | 63 | } | 
| @@ -37,7 +37,7 @@ | ||
| 37 | 37 | |
| 38 | 38 | $query = $qb->getQuery(); | 
| 39 | 39 | |
| 40 | - return (int)$query->getSingleScalarResult(); | |
| 40 | + return (int) $query->getSingleScalarResult(); | |
| 41 | 41 | } | 
| 42 | 42 | |
| 43 | 43 | public function getStats(array $filters = [], array $sorting = [], int $limit = 0, int $offset = 0): array | 
| @@ -46,12 +46,12 @@ discard block | ||
| 46 | 46 | |
| 47 | 47 |          if (null !== $groupType) { | 
| 48 | 48 |              $qb->where('g.gtype = :gtype') | 
| 49 | -               ->setParameter('gtype', $groupType); | |
| 49 | +                ->setParameter('gtype', $groupType); | |
| 50 | 50 | } | 
| 51 | 51 | |
| 52 | 52 |          if (null !== $excludedState) { | 
| 53 | 53 |              $qb->andWhere('g.state != :state') | 
| 54 | -               ->setParameter('state', $excludedState); | |
| 54 | +                ->setParameter('state', $excludedState); | |
| 55 | 55 | } | 
| 56 | 56 | |
| 57 | 57 | $query = $qb->getQuery(); | 
| @@ -79,7 +79,7 @@ discard block | ||
| 79 | 79 | $i = 1; | 
| 80 | 80 |              foreach ($filters as $w_key => $w_value) { | 
| 81 | 81 |                  $qb->andWhere($qb->expr()->eq('g.' . $w_key, '?' . $i)) | 
| 82 | - ->setParameter($i, $w_value); | |
| 82 | + ->setParameter($i, $w_value); | |
| 83 | 83 | $i++; | 
| 84 | 84 | } | 
| 85 | 85 | } | 
| @@ -87,7 +87,7 @@ discard block | ||
| 87 | 87 | $i = 1; | 
| 88 | 88 |              foreach ($exclusions as $w_key => $w_value) { | 
| 89 | 89 |                  $qb->andWhere($qb->expr()->neq('g.' . $w_key, '?' . $i)) | 
| 90 | - ->setParameter($i, $w_value); | |
| 90 | + ->setParameter($i, $w_value); | |
| 91 | 91 | $i++; | 
| 92 | 92 | } | 
| 93 | 93 | } | 
| @@ -163,7 +163,7 @@ discard block | ||
| 163 | 163 | // already another group by that name. | 
| 164 | 164 |          if (is_numeric($excludedGroupId) && $excludedGroupId > 0) { | 
| 165 | 165 |              $qb->andWhere($qb->expr()->neq('g.gid', ':ggid')) | 
| 166 | -               ->setParameter('ggid', $excludedGroupId); | |
| 166 | +                ->setParameter('ggid', $excludedGroupId); | |
| 167 | 167 | } | 
| 168 | 168 | |
| 169 | 169 | $query = $qb->getQuery(); | 
| @@ -54,7 +54,7 @@ | ||
| 54 | 54 | |
| 55 | 55 | $query = $qb->getQuery(); | 
| 56 | 56 | |
| 57 | - return (int)$query->getSingleScalarResult(); | |
| 57 | + return (int) $query->getSingleScalarResult(); | |
| 58 | 58 | } | 
| 59 | 59 | |
| 60 | 60 | public function getGroups( | 
| @@ -41,8 +41,8 @@ | ||
| 41 | 41 | |
| 42 | 42 | $qb = $this->getEntityManager()->createQueryBuilder(); | 
| 43 | 43 | $qb->delete($this->mainEntityClass, 'tbl') | 
| 44 | -           ->where('tbl.bundle = :bundle') | |
| 45 | -           ->setParameter('bundle', $bundleName); | |
| 44 | +            ->where('tbl.bundle = :bundle') | |
| 45 | +            ->setParameter('bundle', $bundleName); | |
| 46 | 46 | $query = $qb->getQuery(); | 
| 47 | 47 | $query->execute(); | 
| 48 | 48 | } | 
| @@ -390,7 +390,7 @@ | ||
| 390 | 390 | ksort($menuCategories); | 
| 391 | 391 | $fullTemplateName = $mode . '.' . $template; | 
| 392 | 392 | |
| 393 | -        return $this->render("@ZikulaAdminModule/AdminInterface/${fullTemplateName}.html.twig", [ | |
| 393 | +        return $this->render("@ZikulaAdminModule/AdminInterface/${fulltemplatename}.html.twig", [ | |
| 394 | 394 |              'adminMenu' => ('categories' === $mode) ? $menuCategories : $menuModules, | 
| 395 | 395 | 'mode' => $mode, | 
| 396 | 396 | 'caller' => $caller | 
| @@ -250,7 +250,7 @@ | ||
| 250 | 250 |                  $menuText .= ' (<i class="fas fa-exclamation-triangle"></i> ' . $this->trans('invalid route') . ')'; | 
| 251 | 251 | } | 
| 252 | 252 | |
| 253 | - $moduleName = (string)$adminModule['name']; | |
| 253 | + $moduleName = (string) $adminModule['name']; | |
| 254 | 254 | $extensionMenu = $extensionMenuCollector->get($moduleName, ExtensionMenuInterface::TYPE_ADMIN); | 
| 255 | 255 |              if (isset($extensionMenu) && 'modules' === $mode && 'tabs' === $template) { | 
| 256 | 256 |                  $extensionMenu->setChildrenAttribute('class', 'dropdown-menu'); | 
| @@ -117,7 +117,7 @@ discard block | ||
| 117 | 117 |                  $qb->from('ZikulaUsersModule:UserEntity', 'u'); | 
| 118 | 118 |                  $qb->andWhere($qb->expr()->eq('tbl.user', 'u.uid')); | 
| 119 | 119 |                  $qb->andWhere($qb->expr()->eq('tbl.user', ':uid')) | 
| 120 | -                   ->setParameter('uid', $uid); | |
| 120 | +                    ->setParameter('uid', $uid); | |
| 121 | 121 | } | 
| 122 | 122 | } | 
| 123 | 123 | |
| @@ -126,7 +126,7 @@ discard block | ||
| 126 | 126 | $i = 1; | 
| 127 | 127 |              foreach ($filters as $w_key => $w_value) { | 
| 128 | 128 |                  $qb->andWhere($qb->expr()->eq('tbl.' . $w_key, '?' . $i)) | 
| 129 | - ->setParameter($i, $w_value); | |
| 129 | + ->setParameter($i, $w_value); | |
| 130 | 130 | $i++; | 
| 131 | 131 | } | 
| 132 | 132 | } | 
| @@ -153,12 +153,12 @@ discard block | ||
| 153 | 153 | |
| 154 | 154 |          if ('uid' === $fieldName) { | 
| 155 | 155 |              $qb->select('DISTINCT(u.' . $fieldName . ')') | 
| 156 | -               ->from('ZikulaUsersModule:UserEntity', 'u') | |
| 157 | -               ->where($qb->expr()->eq('tbl.user', 'u.uid')) | |
| 158 | -               ->addOrderBy('u.uname', 'ASC'); | |
| 156 | +                ->from('ZikulaUsersModule:UserEntity', 'u') | |
| 157 | +                ->where($qb->expr()->eq('tbl.user', 'u.uid')) | |
| 158 | +                ->addOrderBy('u.uname', 'ASC'); | |
| 159 | 159 |          } else { | 
| 160 | 160 |              $qb->select('DISTINCT(tbl.' . $fieldName . ')') | 
| 161 | -               ->addOrderBy('tbl.' . $fieldName, 'ASC'); | |
| 161 | +                ->addOrderBy('tbl.' . $fieldName, 'ASC'); | |
| 162 | 162 | } | 
| 163 | 163 | |
| 164 | 164 | $query = $qb->getQuery(); | 
| @@ -43,7 +43,7 @@ | ||
| 43 | 43 | |
| 44 | 44 | $query = $qb->getQuery(); | 
| 45 | 45 | |
| 46 | - return (int)$query->getSingleScalarResult(); | |
| 46 | + return (int) $query->getSingleScalarResult(); | |
| 47 | 47 | } | 
| 48 | 48 | |
| 49 | 49 | /** | 
| @@ -40,7 +40,7 @@ discard block | ||
| 40 | 40 | |
| 41 | 41 |          if ('' !== $sessionId) { | 
| 42 | 42 |              $qb->where('tbl.sesid = :sid') | 
| 43 | -               ->setParameter('sid', $sessionId); | |
| 43 | +                ->setParameter('sid', $sessionId); | |
| 44 | 44 | } | 
| 45 | 45 | |
| 46 | 46 | $query = $qb->getQuery(); | 
| @@ -63,7 +63,7 @@ discard block | ||
| 63 | 63 | $i = 1; | 
| 64 | 64 |              foreach ($filters as $w_key => $w_value) { | 
| 65 | 65 |                  $qb->andWhere($qb->expr()->eq('tbl.' . $w_key, '?' . $i)) | 
| 66 | - ->setParameter($i, $w_value); | |
| 66 | + ->setParameter($i, $w_value); | |
| 67 | 67 | $i++; | 
| 68 | 68 | } | 
| 69 | 69 | } | 
| @@ -99,7 +99,7 @@ discard block | ||
| 99 | 99 | |
| 100 | 100 |          if ('' !== $sessionId) { | 
| 101 | 101 |              $qb->orWhere('tbl.sesid = :sid') | 
| 102 | -               ->setParameter('sid', $sessionId); | |
| 102 | +                ->setParameter('sid', $sessionId); | |
| 103 | 103 | } | 
| 104 | 104 | |
| 105 | 105 | $query = $qb->getQuery(); | 
| @@ -42,7 +42,7 @@ | ||
| 42 | 42 | |
| 43 | 43 | $query = $qb->getQuery(); | 
| 44 | 44 | |
| 45 | - return (int)$query->getSingleScalarResult(); | |
| 45 | + return (int) $query->getSingleScalarResult(); | |
| 46 | 46 | } | 
| 47 | 47 | |
| 48 | 48 | public function getResults(array $filters = [], array $sorting = [], int $limit = 0, int $offset = 0): array | 
| @@ -120,9 +120,9 @@ discard block | ||
| 120 | 120 | |
| 121 | 121 | $qb = $this->getEntityManager()->createQueryBuilder(); | 
| 122 | 122 | $qb->update($this->mainEntityClass, 'tbl') | 
| 123 | -           ->set('tbl.createdBy', $newUserId) | |
| 124 | -           ->where('tbl.createdBy = :creator') | |
| 125 | -           ->setParameter('creator', $userId); | |
| 123 | +            ->set('tbl.createdBy', $newUserId) | |
| 124 | +            ->where('tbl.createdBy = :creator') | |
| 125 | +            ->setParameter('creator', $userId); | |
| 126 | 126 | $query = $qb->getQuery(); | 
| 127 | 127 | $query->execute(); | 
| 128 | 128 | |
| @@ -148,9 +148,9 @@ discard block | ||
| 148 | 148 | |
| 149 | 149 | $qb = $this->getEntityManager()->createQueryBuilder(); | 
| 150 | 150 | $qb->update($this->mainEntityClass, 'tbl') | 
| 151 | -           ->set('tbl.updatedBy', $newUserId) | |
| 152 | -           ->where('tbl.updatedBy = :editor') | |
| 153 | -           ->setParameter('editor', $userId); | |
| 151 | +            ->set('tbl.updatedBy', $newUserId) | |
| 152 | +            ->where('tbl.updatedBy = :editor') | |
| 153 | +            ->setParameter('editor', $userId); | |
| 154 | 154 | $query = $qb->getQuery(); | 
| 155 | 155 | $query->execute(); | 
| 156 | 156 | |
| @@ -175,8 +175,8 @@ discard block | ||
| 175 | 175 | |
| 176 | 176 | $qb = $this->getEntityManager()->createQueryBuilder(); | 
| 177 | 177 | $qb->delete($this->mainEntityClass, 'tbl') | 
| 178 | -           ->where('tbl.createdBy = :creator') | |
| 179 | -           ->setParameter('creator', $userId); | |
| 178 | +            ->where('tbl.createdBy = :creator') | |
| 179 | +            ->setParameter('creator', $userId); | |
| 180 | 180 | $query = $qb->getQuery(); | 
| 181 | 181 | $query->execute(); | 
| 182 | 182 | |
| @@ -201,8 +201,8 @@ discard block | ||
| 201 | 201 | |
| 202 | 202 | $qb = $this->getEntityManager()->createQueryBuilder(); | 
| 203 | 203 | $qb->delete($this->mainEntityClass, 'tbl') | 
| 204 | -           ->where('tbl.updatedBy = :editor') | |
| 205 | -           ->setParameter('editor', $userId); | |
| 204 | +            ->where('tbl.updatedBy = :editor') | |
| 205 | +            ->setParameter('editor', $userId); | |
| 206 | 206 | $query = $qb->getQuery(); | 
| 207 | 207 | $query->execute(); | 
| 208 | 208 | |
| @@ -280,7 +280,7 @@ discard block | ||
| 280 | 280 |      { | 
| 281 | 281 |          if (0 < count($exclusions)) { | 
| 282 | 282 |              $qb->andWhere('tbl.id NOT IN (:excludedIdentifiers)') | 
| 283 | -               ->setParameter('excludedIdentifiers', $exclusions); | |
| 283 | +                ->setParameter('excludedIdentifiers', $exclusions); | |
| 284 | 284 | } | 
| 285 | 285 | |
| 286 | 286 | return $qb; | 
| @@ -332,7 +332,7 @@ discard block | ||
| 332 | 332 | $offset = ($currentPage - 1) * $resultsPerPage; | 
| 333 | 333 | |
| 334 | 334 | $query->setFirstResult($offset) | 
| 335 | - ->setMaxResults($resultsPerPage); | |
| 335 | + ->setMaxResults($resultsPerPage); | |
| 336 | 336 | |
| 337 | 337 | return $query; | 
| 338 | 338 | } | 
| @@ -404,7 +404,7 @@ discard block | ||
| 404 | 404 | |
| 405 | 405 | $qb = $this->getEntityManager()->createQueryBuilder(); | 
| 406 | 406 | $qb->select($selection) | 
| 407 | - ->from($this->mainEntityClass, 'tbl'); | |
| 407 | + ->from($this->mainEntityClass, 'tbl'); | |
| 408 | 408 | |
| 409 | 409 |          if (true === $useJoins) { | 
| 410 | 410 | $this->addJoinsToFrom($qb); | 
| @@ -441,7 +441,7 @@ discard block | ||
| 441 | 441 |      { | 
| 442 | 442 | $qb = $this->getCountQuery(); | 
| 443 | 443 |          $qb->andWhere('tbl.' . $fieldName . ' = :' . $fieldName) | 
| 444 | - ->setParameter($fieldName, $fieldValue); | |
| 444 | + ->setParameter($fieldName, $fieldValue); | |
| 445 | 445 | |
| 446 | 446 |          if ($excludeId > 0) { | 
| 447 | 447 | $qb = $this->addExclusion($qb, [$excludeId]); | 
| @@ -477,7 +477,7 @@ discard block | ||
| 477 | 477 | |
| 478 | 478 | $qb = $this->getEntityManager()->createQueryBuilder(); | 
| 479 | 479 | $qb->select($selection) | 
| 480 | - ->from($this->mainEntityClass, 'tbl'); | |
| 480 | + ->from($this->mainEntityClass, 'tbl'); | |
| 481 | 481 | |
| 482 | 482 |          if (true === $useJoins) { | 
| 483 | 483 | $this->addJoinsToFrom($qb); | 
| @@ -500,7 +500,7 @@ discard block | ||
| 500 | 500 |          if ('RAND()' === $orderBy) { | 
| 501 | 501 | // random selection | 
| 502 | 502 |              $qb->addSelect('MOD(tbl.id, ' . random_int(2, 15) . ') AS HIDDEN randomIdentifiers') | 
| 503 | -               ->orderBy('randomIdentifiers'); | |
| 503 | +                ->orderBy('randomIdentifiers'); | |
| 504 | 504 | |
| 505 | 505 | return $qb; | 
| 506 | 506 | } | 
| @@ -519,12 +519,12 @@ discard block | ||
| 519 | 519 | } | 
| 520 | 520 |          if (false !== strpos($orderBy, 'tbl.createdBy')) { | 
| 521 | 521 |              $qb->addSelect('tblCreator') | 
| 522 | -               ->leftJoin('tbl.createdBy', 'tblCreator'); | |
| 522 | +                ->leftJoin('tbl.createdBy', 'tblCreator'); | |
| 523 | 523 |              $orderBy = str_replace('tbl.createdBy', 'tblCreator.uname', $orderBy); | 
| 524 | 524 | } | 
| 525 | 525 |          if (false !== strpos($orderBy, 'tbl.updatedBy')) { | 
| 526 | 526 |              $qb->addSelect('tblUpdater') | 
| 527 | -               ->leftJoin('tbl.updatedBy', 'tblUpdater'); | |
| 527 | +                ->leftJoin('tbl.updatedBy', 'tblUpdater'); | |
| 528 | 528 |              $orderBy = str_replace('tbl.updatedBy', 'tblUpdater.uname', $orderBy); | 
| 529 | 529 | } | 
| 530 | 530 |          $qb->add('orderBy', $orderBy); | 
| @@ -475,7 +475,7 @@ discard block | ||
| 475 | 475 | |
| 476 | 476 | $query = $qb->getQuery(); | 
| 477 | 477 | |
| 478 | - return (int)$query->getSingleScalarResult(); | |
| 478 | + return (int) $query->getSingleScalarResult(); | |
| 479 | 479 | } | 
| 480 | 480 | |
| 481 | 481 | |
| @@ -494,7 +494,7 @@ discard block | ||
| 494 | 494 | |
| 495 | 495 | $query = $qb->getQuery(); | 
| 496 | 496 | |
| 497 | - $count = (int)$query->getSingleScalarResult(); | |
| 497 | + $count = (int) $query->getSingleScalarResult(); | |
| 498 | 498 | |
| 499 | 499 | return 1 > $count; | 
| 500 | 500 | } | 
| @@ -332,7 +332,7 @@ | ||
| 332 | 332 | ->setDefaults([ | 
| 333 | 333 | // define class for underlying data (required for embedding forms) | 
| 334 | 334 | 'data_class' => RouteEntity::class, | 
| 335 | -                'empty_data' => function (FormInterface $form) { | |
| 335 | +                'empty_data' => function(FormInterface $form) { | |
| 336 | 336 | return $this->entityFactory->createRoute(); | 
| 337 | 337 | }, | 
| 338 | 338 | 'error_mapping' => [ | 
| @@ -54,7 +54,7 @@ | ||
| 54 | 54 | ->getMock(); | 
| 55 | 55 | $kernel | 
| 56 | 56 |              ->method('getModule') | 
| 57 | -            ->willReturnCallback(function ($moduleName) { | |
| 57 | +            ->willReturnCallback(function($moduleName) { | |
| 58 | 58 |                  if ('ExceptionModule' === $moduleName) { | 
| 59 | 59 | // mocks situation where module is not namespaced. | 
| 60 | 60 | throw new Exception(); |