@@ -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 | }  | 
                                                        
@@ -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();  | 
                                                        
@@ -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();  | 
                                                        
@@ -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 | }  | 
                                                        
@@ -44,7 +44,7 @@  | 
                                                    ||
| 44 | 44 |      { | 
                                                        
| 45 | 45 | $text = preg_replace_callback(  | 
                                                        
| 46 | 46 | '/<a [^>]*href\s*=\s*\"?([^>\"]*)\"?[^>]*>(.*?)<\/a.*?>/i',  | 
                                                        
| 47 | -            function ($matches) { | 
                                                        |
| 47 | +            function($matches) { | 
                                                        |
| 48 | 48 | $this->links[] = html_entity_decode($matches[1]);  | 
                                                        
| 49 | 49 | // return the replaced link  | 
                                                        
| 50 | 50 | return '<strong><em>' . $matches[2] . '</em></strong> <small>[' . count($this->links) . ']</small>';  | 
                                                        
@@ -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  | 
                                                        
@@ -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();  | 
                                                        
@@ -56,7 +56,7 @@  | 
                                                    ||
| 56 | 56 | return $value->getUid();  | 
                                                        
| 57 | 57 | }  | 
                                                        
| 58 | 58 | |
| 59 | - return (int) $value;  | 
                                                        |
| 59 | + return (int)$value;  | 
                                                        |
| 60 | 60 | }  | 
                                                        
| 61 | 61 | |
| 62 | 62 | /**  | 
                                                        
@@ -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();  |