@@ -41,7 +41,7 @@ discard block |
||
41 | 41 | $i = 1; |
42 | 42 | foreach ($filters as $w_key => $w_value) { |
43 | 43 | $qb->andWhere($qb->expr()->eq('tbl.' . $w_key, '?' . $i)) |
44 | - ->setParameter($i, $w_value); |
|
44 | + ->setParameter($i, $w_value); |
|
45 | 45 | $i++; |
46 | 46 | } |
47 | 47 | } |
@@ -64,7 +64,7 @@ discard block |
||
64 | 64 | |
65 | 65 | if ('' !== $sessionId) { |
66 | 66 | $qb->orWhere('tbl.sesid = :sid') |
67 | - ->setParameter('sid', $sessionId); |
|
67 | + ->setParameter('sid', $sessionId); |
|
68 | 68 | } |
69 | 69 | |
70 | 70 | $query = $qb->getQuery(); |
@@ -38,7 +38,7 @@ |
||
38 | 38 | |
39 | 39 | $query = $qb->getQuery(); |
40 | 40 | |
41 | - return (int)$query->getSingleScalarResult(); |
|
41 | + return (int) $query->getSingleScalarResult(); |
|
42 | 42 | } |
43 | 43 | |
44 | 44 | public function getStats(array $filters = [], array $sorting = [], int $page = 1, int $pageSize = 25): Paginator |
@@ -75,7 +75,7 @@ discard block |
||
75 | 75 | $qb->from('ZikulaUsersModule:UserEntity', 'u'); |
76 | 76 | $qb->andWhere($qb->expr()->eq('tbl.user', 'u.uid')); |
77 | 77 | $qb->andWhere($qb->expr()->eq('tbl.user', ':uid')) |
78 | - ->setParameter('uid', $uid); |
|
78 | + ->setParameter('uid', $uid); |
|
79 | 79 | } |
80 | 80 | } |
81 | 81 | |
@@ -84,7 +84,7 @@ discard block |
||
84 | 84 | $i = 1; |
85 | 85 | foreach ($filters as $w_key => $w_value) { |
86 | 86 | $qb->andWhere($qb->expr()->eq('tbl.' . $w_key, '?' . $i)) |
87 | - ->setParameter($i, $w_value); |
|
87 | + ->setParameter($i, $w_value); |
|
88 | 88 | $i++; |
89 | 89 | } |
90 | 90 | } |
@@ -107,12 +107,12 @@ discard block |
||
107 | 107 | |
108 | 108 | if ('uid' === $fieldName) { |
109 | 109 | $qb->select('DISTINCT(u.uname)') |
110 | - ->from('ZikulaUsersModule:UserEntity', 'u') |
|
111 | - ->where($qb->expr()->eq('tbl.user', 'u.uid')) |
|
112 | - ->addOrderBy('u.uname', 'ASC'); |
|
110 | + ->from('ZikulaUsersModule:UserEntity', 'u') |
|
111 | + ->where($qb->expr()->eq('tbl.user', 'u.uid')) |
|
112 | + ->addOrderBy('u.uname', 'ASC'); |
|
113 | 113 | } else { |
114 | 114 | $qb->select('DISTINCT(tbl.' . $fieldName . ')') |
115 | - ->addOrderBy('tbl.' . $fieldName, 'ASC'); |
|
115 | + ->addOrderBy('tbl.' . $fieldName, 'ASC'); |
|
116 | 116 | } |
117 | 117 | |
118 | 118 | return $qb->getQuery()->getResult(); |
@@ -88,7 +88,7 @@ |
||
88 | 88 | |
89 | 89 | |
90 | 90 | // number of items to show |
91 | - $pageSize = (int)$this->getVar('pagesize', 25); |
|
91 | + $pageSize = (int) $this->getVar('pagesize', 25); |
|
92 | 92 | |
93 | 93 | // get data |
94 | 94 | $paginator = $repository->getIntrusions($where, $sorting, $page, $pageSize); |
@@ -45,12 +45,12 @@ discard block |
||
45 | 45 | |
46 | 46 | if (null !== $groupType) { |
47 | 47 | $qb->where('g.gtype = :gtype') |
48 | - ->setParameter('gtype', $groupType); |
|
48 | + ->setParameter('gtype', $groupType); |
|
49 | 49 | } |
50 | 50 | |
51 | 51 | if (null !== $excludedState) { |
52 | 52 | $qb->andWhere('g.state != :state') |
53 | - ->setParameter('state', $excludedState); |
|
53 | + ->setParameter('state', $excludedState); |
|
54 | 54 | } |
55 | 55 | |
56 | 56 | $query = $qb->getQuery(); |
@@ -139,7 +139,7 @@ discard block |
||
139 | 139 | // already another group by that name. |
140 | 140 | if (is_numeric($excludedGroupId) && $excludedGroupId > 0) { |
141 | 141 | $qb->andWhere($qb->expr()->neq('g.gid', ':ggid')) |
142 | - ->setParameter('ggid', $excludedGroupId); |
|
142 | + ->setParameter('ggid', $excludedGroupId); |
|
143 | 143 | } |
144 | 144 | |
145 | 145 | $query = $qb->getQuery(); |