| ... | ... |
@@ -32,7 +32,7 @@ class TeamListController extends AbstractFrontendModuleController |
| 32 | 32 |
protected function getResponse(Template $template, ModuleModel $model, Request $request): Response |
| 33 | 33 |
{
|
| 34 | 34 |
$Team = $this->db->executeQuery( |
| 35 |
- "SELECT * FROM tl_eSM_team WHERE division IN (:division) AND pid = :group AND published = '1' ORDER BY division, lastname", |
|
| 35 |
+ "SELECT * FROM tl_esm_team WHERE division IN (:division) AND pid = :group AND published = '1' ORDER BY division, lastname", |
|
| 36 | 36 |
[ |
| 37 | 37 |
'division' => StringUtil::deserialize($model->eSM_team_divisions), |
| 38 | 38 |
'group' => $model->eSM_team_group |
| ... | ... |
@@ -45,8 +45,8 @@ class TeamListController extends AbstractFrontendModuleController |
| 45 | 45 |
$arrTeam = []; |
| 46 | 46 |
$figureBuilder = System::getContainer() |
| 47 | 47 |
->get(Studio::class) |
| 48 |
- ->createFigureBuilder() |
|
| 49 |
- ->enableLightbox(); |
|
| 48 |
+ ->createFigureBuilder(); |
|
| 49 |
+// ->enableLightbox(); |
|
| 50 | 50 |
|
| 51 | 51 |
foreach ($Team->fetchAllAssociative() as $member) |
| 52 | 52 |
{
|
| ... | ... |
@@ -6,16 +6,63 @@ namespace App\Controller\FrontendModule; |
| 6 | 6 |
|
| 7 | 7 |
use Contao\CoreBundle\Controller\FrontendModule\AbstractFrontendModuleController; |
| 8 | 8 |
use Contao\CoreBundle\DependencyInjection\Attribute\AsFrontendModule; |
| 9 |
+use Contao\CoreBundle\Image\Studio\Studio; |
|
| 9 | 10 |
use Contao\ModuleModel; |
| 11 |
+use Contao\StringUtil; |
|
| 12 |
+use Contao\System; |
|
| 10 | 13 |
use Contao\Template; |
| 14 |
+use Doctrine\DBAL\Connection; |
|
| 11 | 15 |
use Symfony\Component\HttpFoundation\Request; |
| 12 | 16 |
use Symfony\Component\HttpFoundation\Response; |
| 13 | 17 |
|
| 14 | 18 |
#[AsFrontendModule(category: "miscellaneous")] |
| 15 | 19 |
class TeamListController extends AbstractFrontendModuleController |
| 16 | 20 |
{
|
| 21 |
+ /** |
|
| 22 |
+ * @var Connection |
|
| 23 |
+ */ |
|
| 24 |
+ protected $db; |
|
| 25 |
+ |
|
| 26 |
+ public function __invoke(Request $request, ModuleModel $model, string $section, array $classes = null): Response |
|
| 27 |
+ {
|
|
| 28 |
+ $this->db = System::getContainer()->get('database_connection');
|
|
| 29 |
+ return parent::__invoke($request, $model, $section, $classes); // TODO: Change the autogenerated stub |
|
| 30 |
+ } |
|
| 31 |
+ |
|
| 17 | 32 |
protected function getResponse(Template $template, ModuleModel $model, Request $request): Response |
| 18 | 33 |
{
|
| 34 |
+ $Team = $this->db->executeQuery( |
|
| 35 |
+ "SELECT * FROM tl_eSM_team WHERE division IN (:division) AND pid = :group AND published = '1' ORDER BY division, lastname", |
|
| 36 |
+ [ |
|
| 37 |
+ 'division' => StringUtil::deserialize($model->eSM_team_divisions), |
|
| 38 |
+ 'group' => $model->eSM_team_group |
|
| 39 |
+ ], |
|
| 40 |
+ ['division' => Connection::PARAM_STR_ARRAY] |
|
| 41 |
+ ); |
|
| 42 |
+ |
|
| 43 |
+ if ($Team->rowCount()) |
|
| 44 |
+ {
|
|
| 45 |
+ $arrTeam = []; |
|
| 46 |
+ $figureBuilder = System::getContainer() |
|
| 47 |
+ ->get(Studio::class) |
|
| 48 |
+ ->createFigureBuilder() |
|
| 49 |
+ ->enableLightbox(); |
|
| 50 |
+ |
|
| 51 |
+ foreach ($Team->fetchAllAssociative() as $member) |
|
| 52 |
+ {
|
|
| 53 |
+ $arrTeam[] = array_merge($member,[ |
|
| 54 |
+ 'imageFigure' => $figureBuilder->fromUuid($member['singleSRC'])->setSize($model->imgSize)->build() |
|
| 55 |
+ ]); |
|
| 56 |
+ } |
|
| 57 |
+ |
|
| 58 |
+ shuffle($arrTeam); |
|
| 59 |
+ |
|
| 60 |
+ $template->teammembers = $arrTeam; |
|
| 61 |
+ |
|
| 62 |
+ $GLOBALS['TL_CSS']['swiper'] = 'bundles/esalesmediacontaoswiper/css/swiper-custom.css'; |
|
| 63 |
+ $GLOBALS['TL_JAVASCRIPT']['swiper'] = 'bundles/esalesmediacontaoswiper/js/lib/swiper/6.5.0/swiper-bundle.min.js'; // load swiper |
|
| 64 |
+ } |
|
| 65 |
+ |
|
| 19 | 66 |
return $template->getResponse(); |
| 20 | 67 |
} |
| 21 | 68 |
} |
| 1 | 1 |
new file mode 100644 |
| ... | ... |
@@ -0,0 +1,21 @@ |
| 1 |
+<?php |
|
| 2 |
+ |
|
| 3 |
+declare(strict_types=1); |
|
| 4 |
+ |
|
| 5 |
+namespace App\Controller\FrontendModule; |
|
| 6 |
+ |
|
| 7 |
+use Contao\CoreBundle\Controller\FrontendModule\AbstractFrontendModuleController; |
|
| 8 |
+use Contao\CoreBundle\DependencyInjection\Attribute\AsFrontendModule; |
|
| 9 |
+use Contao\ModuleModel; |
|
| 10 |
+use Contao\Template; |
|
| 11 |
+use Symfony\Component\HttpFoundation\Request; |
|
| 12 |
+use Symfony\Component\HttpFoundation\Response; |
|
| 13 |
+ |
|
| 14 |
+#[AsFrontendModule(category: "miscellaneous")] |
|
| 15 |
+class TeamListController extends AbstractFrontendModuleController |
|
| 16 |
+{
|
|
| 17 |
+ protected function getResponse(Template $template, ModuleModel $model, Request $request): Response |
|
| 18 |
+ {
|
|
| 19 |
+ return $template->getResponse(); |
|
| 20 |
+ } |
|
| 21 |
+} |