zikula / core

src/system/RoutesModule/Entity/Repository/Base/AbstractRouteRepository.php

Indentation +17 added lines, -17 removed lines

@@ -120,9 +120,9 @@ 
     
         $qb = $this->getEntityManager()->createQueryBuilder();
         $qb->update($this->mainEntityClass, 'tbl')
-           ->set('tbl.createdBy', $newUserId)
-           ->where('tbl.createdBy = :creator')
-           ->setParameter('creator', $userId);
+            ->set('tbl.createdBy', $newUserId)
+            ->where('tbl.createdBy = :creator')
+            ->setParameter('creator', $userId);
         $query = $qb->getQuery();
         $query->execute();
     
@@ -153,9 +153,9 @@ 
     
         $qb = $this->getEntityManager()->createQueryBuilder();
         $qb->update($this->mainEntityClass, 'tbl')
-           ->set('tbl.updatedBy', $newUserId)
-           ->where('tbl.updatedBy = :editor')
-           ->setParameter('editor', $userId);
+            ->set('tbl.updatedBy', $newUserId)
+            ->where('tbl.updatedBy = :editor')
+            ->setParameter('editor', $userId);
         $query = $qb->getQuery();
         $query->execute();
     
@@ -185,8 +185,8 @@ 
     
         $qb = $this->getEntityManager()->createQueryBuilder();
         $qb->delete($this->mainEntityClass, 'tbl')
-           ->where('tbl.createdBy = :creator')
-           ->setParameter('creator', $userId);
+            ->where('tbl.createdBy = :creator')
+            ->setParameter('creator', $userId);
         $query = $qb->getQuery();
         $query->execute();
     
@@ -216,8 +216,8 @@ 
     
         $qb = $this->getEntityManager()->createQueryBuilder();
         $qb->delete($this->mainEntityClass, 'tbl')
-           ->where('tbl.updatedBy = :editor')
-           ->setParameter('editor', $userId);
+            ->where('tbl.updatedBy = :editor')
+            ->setParameter('editor', $userId);
         $query = $qb->getQuery();
         $query->execute();
     
@@ -309,7 +309,7 @@ 
     {
         if (0 < count($exclusions)) {
             $qb->andWhere('tbl.id NOT IN (:excludedIdentifiers)')
-               ->setParameter('excludedIdentifiers', $exclusions);
+                ->setParameter('excludedIdentifiers', $exclusions);
         }
     
         return $qb;
@@ -418,7 +418,7 @@ 
     
         $qb = $this->getEntityManager()->createQueryBuilder();
         $qb->select($selection)
-           ->from($this->mainEntityClass, 'tbl');
+            ->from($this->mainEntityClass, 'tbl');
     
         if (true === $useJoins) {
             $this->addJoinsToFrom($qb);
@@ -454,7 +454,7 @@ 
     {
         $qb = $this->getCountQuery();
         $qb->andWhere('tbl.' . $fieldName . ' = :' . $fieldName)
-           ->setParameter($fieldName, $fieldValue);
+            ->setParameter($fieldName, $fieldValue);
     
         if ($excludeId > 0) {
             $qb = $this->addExclusion($qb, [$excludeId]);
@@ -494,7 +494,7 @@ 
     
         $qb = $this->getEntityManager()->createQueryBuilder();
         $qb->select($selection)
-           ->from($this->mainEntityClass, 'tbl');
+            ->from($this->mainEntityClass, 'tbl');
     
         if (true === $useJoins) {
             $this->addJoinsToFrom($qb);
@@ -517,7 +517,7 @@ 
         if ('RAND()' === $orderBy) {
             // random selection
             $qb->addSelect('MOD(tbl.id, ' . random_int(2, 15) . ') AS HIDDEN randomIdentifiers')
-               ->orderBy('randomIdentifiers');
+                ->orderBy('randomIdentifiers');
     
             return $qb;
         }
@@ -536,12 +536,12 @@ 
         }
         if (false !== mb_strpos($orderBy, 'tbl.createdBy')) {
             $qb->addSelect('tblCreator')
-               ->leftJoin('tbl.createdBy', 'tblCreator');
+                ->leftJoin('tbl.createdBy', 'tblCreator');
             $orderBy = str_replace('tbl.createdBy', 'tblCreator.uname', $orderBy);
         }
         if (false !== mb_strpos($orderBy, 'tbl.updatedBy')) {
             $qb->addSelect('tblUpdater')
-               ->leftJoin('tbl.updatedBy', 'tblUpdater');
+                ->leftJoin('tbl.updatedBy', 'tblUpdater');
             $orderBy = str_replace('tbl.updatedBy', 'tblUpdater.uname', $orderBy);
         }
         $qb->add('orderBy', $orderBy);

src/system/RoutesModule/Helper/Base/AbstractCollectionFilterHelper.php

Indentation +6 added lines, -6 removed lines

@@ -162,17 +162,17 @@ 
                 $v = (string) $v;
                 if ('workflowState' === $k && 0 === mb_strpos($v, '!')) {
                     $qb->andWhere('tbl.' . $k . ' != :' . $k)
-                       ->setParameter($k, mb_substr($v, 1));
+                        ->setParameter($k, mb_substr($v, 1));
                 } elseif (0 === mb_strpos($v, '%')) {
                     $qb->andWhere('tbl.' . $k . ' LIKE :' . $k)
-                       ->setParameter($k, '%' . mb_substr($v, 1) . '%');
+                        ->setParameter($k, '%' . mb_substr($v, 1) . '%');
                 } elseif (in_array($k, ['schemes', 'methods'], true)) {
                     // multi list filter
                     $qb->andWhere('tbl.' . $k . ' LIKE :' . $k)
-                       ->setParameter($k, '%' . $v . '%');
+                        ->setParameter($k, '%' . $v . '%');
                 } else {
                     $qb->andWhere('tbl.' . $k . ' = :' . $k)
-                       ->setParameter($k, $v);
+                        ->setParameter($k, $v);
                 }
             }
         }
@@ -205,7 +205,7 @@ 
             // per default we show approved routes only
             $onlineStates = ['approved'];
             $qb->andWhere('tbl.workflowState IN (:onlineStates)')
-               ->setParameter('onlineStates', $onlineStates);
+                ->setParameter('onlineStates', $onlineStates);
         }
     
         return $qb;
@@ -272,7 +272,7 @@ 
         }
     
         $qb->andWhere('tbl.createdBy = :userId')
-           ->setParameter('userId', $userId);
+            ->setParameter('userId', $userId);
     
         return $qb;
     }