@@ -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 |
@@ -36,12 +36,12 @@ |
||
| 36 | 36 | |
| 37 | 37 | if ($parentId > 0) { |
| 38 | 38 | $qb->andWhere('c.parent = :parentid') |
| 39 | - ->setParameter('parentid', $parentId); |
|
| 39 | + ->setParameter('parentid', $parentId); |
|
| 40 | 40 | } |
| 41 | 41 | |
| 42 | 42 | if ($excludedId > 0) { |
| 43 | 43 | $qb->andWhere('c.id != :id') |
| 44 | - ->setParameter('id', $excludedId); |
|
| 44 | + ->setParameter('id', $excludedId); |
|
| 45 | 45 | } |
| 46 | 46 | |
| 47 | 47 | $query = $qb->getQuery(); |
@@ -62,7 +62,7 @@ |
||
| 62 | 62 | |
| 63 | 63 | $query = $qb->getQuery(); |
| 64 | 64 | |
| 65 | - return (int)$query->getSingleScalarResult(); |
|
| 65 | + return (int) $query->getSingleScalarResult(); |
|
| 66 | 66 | } |
| 67 | 67 | |
| 68 | 68 | public function getLastByParent(int $parentId = 0): ?CategoryEntity |
@@ -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' => [ |