@@ -26,37 +26,37 @@ |
||
| 26 | 26 | ) |
| 27 | 27 | ->add( |
| 28 | 28 | 'content_WHAT', null, [ |
| 29 | - 'required' => true, |
|
| 30 | - 'data' => '*', |
|
| 31 | - 'attr' => [ |
|
| 32 | - 'style' => 'width: 300px;' |
|
| 33 | - ], |
|
| 34 | - 'disabled' => false, |
|
| 35 | - 'label' => false, |
|
| 36 | - 'trim' => true |
|
| 37 | - ] |
|
| 29 | + 'required' => true, |
|
| 30 | + 'data' => '*', |
|
| 31 | + 'attr' => [ |
|
| 32 | + 'style' => 'width: 300px;' |
|
| 33 | + ], |
|
| 34 | + 'disabled' => false, |
|
| 35 | + 'label' => false, |
|
| 36 | + 'trim' => true |
|
| 37 | + ] |
|
| 38 | 38 | ) |
| 39 | 39 | ->add( |
| 40 | 40 | 'content_FROM', ChoiceType::class, [ |
| 41 | - 'choices' => ['FROM' => 'FROM'], |
|
| 42 | - 'attr' => [ |
|
| 43 | - 'style' => 'width: 300px;' |
|
| 44 | - ], |
|
| 45 | - 'disabled' => true, |
|
| 46 | - 'label' => false, |
|
| 47 | - 'trim' => true |
|
| 48 | - ] |
|
| 41 | + 'choices' => ['FROM' => 'FROM'], |
|
| 42 | + 'attr' => [ |
|
| 43 | + 'style' => 'width: 300px;' |
|
| 44 | + ], |
|
| 45 | + 'disabled' => true, |
|
| 46 | + 'label' => false, |
|
| 47 | + 'trim' => true |
|
| 48 | + ] |
|
| 49 | 49 | ) |
| 50 | 50 | ->add( |
| 51 | 51 | 'content_TABLE', ChoiceType::class, [ |
| 52 | - 'choices' => ['caches' => 'caches', 'user' => 'user'], |
|
| 53 | - 'attr' => [ |
|
| 54 | - 'style' => 'width: 300px;' |
|
| 55 | - ], |
|
| 56 | - 'disabled' => false, |
|
| 57 | - 'label' => false, |
|
| 58 | - 'trim' => true |
|
| 59 | - ] |
|
| 52 | + 'choices' => ['caches' => 'caches', 'user' => 'user'], |
|
| 53 | + 'attr' => [ |
|
| 54 | + 'style' => 'width: 300px;' |
|
| 55 | + ], |
|
| 56 | + 'disabled' => false, |
|
| 57 | + 'label' => false, |
|
| 58 | + 'trim' => true |
|
| 59 | + ] |
|
| 60 | 60 | ) |
| 61 | 61 | ->add('Suchen', SubmitType::class, ['attr' => ['class' => 'btn btn-primary']]); |
| 62 | 62 | } |
@@ -19,19 +19,19 @@ |
||
| 19 | 19 | $builder |
| 20 | 20 | ->add( |
| 21 | 21 | 'content_support_searchfield', null, [ |
| 22 | - 'attr' => [ |
|
| 23 | - 'placeholder' => 'OC / GC / Name / Owner / %%%', |
|
| 24 | - 'autofocus' => 'autofocus', |
|
| 25 | - 'size' => '10%', |
|
| 26 | - 'minlength' => '3', |
|
| 27 | - 'maxlength' => '100', |
|
| 28 | - 'style' => 'width: 250px;' |
|
| 29 | - ], |
|
| 30 | - 'required' => true, |
|
| 31 | - 'disabled' => false, |
|
| 32 | - 'label' => false, |
|
| 33 | - 'trim' => true |
|
| 34 | - ] |
|
| 22 | + 'attr' => [ |
|
| 23 | + 'placeholder' => 'OC / GC / Name / Owner / %%%', |
|
| 24 | + 'autofocus' => 'autofocus', |
|
| 25 | + 'size' => '10%', |
|
| 26 | + 'minlength' => '3', |
|
| 27 | + 'maxlength' => '100', |
|
| 28 | + 'style' => 'width: 250px;' |
|
| 29 | + ], |
|
| 30 | + 'required' => true, |
|
| 31 | + 'disabled' => false, |
|
| 32 | + 'label' => false, |
|
| 33 | + 'trim' => true |
|
| 34 | + ] |
|
| 35 | 35 | ) |
| 36 | 36 | ->add( |
| 37 | 37 | 'search_All', SubmitType::class, [ |
@@ -90,9 +90,9 @@ discard block |
||
| 90 | 90 | |
| 91 | 91 | return $this->render( |
| 92 | 92 | 'backend/support/searchedCaches.html.twig', [ |
| 93 | - 'supportCachesForm' => $formSearch->createView(), |
|
| 94 | - 'foundCaches' => $fetchedCaches |
|
| 95 | - ] |
|
| 93 | + 'supportCachesForm' => $formSearch->createView(), |
|
| 94 | + 'foundCaches' => $fetchedCaches |
|
| 95 | + ] |
|
| 96 | 96 | ); |
| 97 | 97 | } |
| 98 | 98 | |
@@ -110,9 +110,9 @@ discard block |
||
| 110 | 110 | |
| 111 | 111 | return $this->render( |
| 112 | 112 | 'backend/support/reportedCaches.html.twig', [ |
| 113 | - 'supportCachesForm' => $formSearch->createView(), |
|
| 114 | - 'reportedCaches_by_id' => $fetchedReports |
|
| 115 | - ] |
|
| 113 | + 'supportCachesForm' => $formSearch->createView(), |
|
| 114 | + 'reportedCaches_by_id' => $fetchedReports |
|
| 115 | + ] |
|
| 116 | 116 | ); |
| 117 | 117 | } |
| 118 | 118 | |
@@ -150,10 +150,10 @@ discard block |
||
| 150 | 150 | |
| 151 | 151 | return $this->render( |
| 152 | 152 | 'backend/support/databaseQueries.html.twig', [ |
| 153 | - 'supportCachesForm' => $formSearch->createView(), |
|
| 154 | - 'SQLFlexForm' => $form->createView(), |
|
| 155 | - 'suppSQLqueryFlex' => $fetchedInformation |
|
| 156 | - ] |
|
| 153 | + 'supportCachesForm' => $formSearch->createView(), |
|
| 154 | + 'SQLFlexForm' => $form->createView(), |
|
| 155 | + 'suppSQLqueryFlex' => $fetchedInformation |
|
| 156 | + ] |
|
| 157 | 157 | ); |
| 158 | 158 | } |
| 159 | 159 | |
@@ -256,9 +256,9 @@ discard block |
||
| 256 | 256 | |
| 257 | 257 | return $this->render( |
| 258 | 258 | 'backend/support/databaseQueries.html.twig', [ |
| 259 | - 'supportCachesForm' => $formSearch->createView(), |
|
| 260 | - 'suppSQLquery1' => $qb->execute()->fetchAll() |
|
| 261 | - ] |
|
| 259 | + 'supportCachesForm' => $formSearch->createView(), |
|
| 260 | + 'suppSQLquery1' => $qb->execute()->fetchAll() |
|
| 261 | + ] |
|
| 262 | 262 | ); |
| 263 | 263 | } |
| 264 | 264 | |
@@ -282,9 +282,9 @@ discard block |
||
| 282 | 282 | |
| 283 | 283 | return $this->render( |
| 284 | 284 | 'backend/support/databaseQueries.html.twig', [ |
| 285 | - 'supportCachesForm' => $formSearch->createView(), |
|
| 286 | - 'suppSQLquery2' => $qb->execute()->fetchAll() |
|
| 287 | - ] |
|
| 285 | + 'supportCachesForm' => $formSearch->createView(), |
|
| 286 | + 'suppSQLquery2' => $qb->execute()->fetchAll() |
|
| 287 | + ] |
|
| 288 | 288 | ); |
| 289 | 289 | } |
| 290 | 290 | |
@@ -310,9 +310,9 @@ discard block |
||
| 310 | 310 | |
| 311 | 311 | return $this->render( |
| 312 | 312 | 'backend/support/databaseQueries.html.twig', [ |
| 313 | - 'supportCachesForm' => $formSearch->createView(), |
|
| 314 | - 'suppSQLquery4' => $qb->execute()->fetchAll() |
|
| 315 | - ] |
|
| 313 | + 'supportCachesForm' => $formSearch->createView(), |
|
| 314 | + 'suppSQLquery4' => $qb->execute()->fetchAll() |
|
| 315 | + ] |
|
| 316 | 316 | ); |
| 317 | 317 | } |
| 318 | 318 | |
@@ -138,7 +138,7 @@ |
||
| 138 | 138 | $fetchedInformation = $this->executeSQL_flexible($inputData['content_WHAT'], $inputData['content_TABLE']); |
| 139 | 139 | |
| 140 | 140 | $countFetched = count($fetchedInformation); |
| 141 | - for ($i = 0; $i < $countFetched; $i ++) { |
|
| 141 | + for ($i = 0; $i < $countFetched; $i++) { |
|
| 142 | 142 | if (array_key_exists('password', $fetchedInformation[$i])) { |
| 143 | 143 | $fetchedInformation[$i]['password'] = '-'; |
| 144 | 144 | } |