Browse code

Progress live

Benjamin Roth authored on12/12/2022 09:28:15
Showing1 changed files
... ...
@@ -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
Browse code

Remote Progress

Benjamin Roth authored on16/11/2022 12:13:51
Showing1 changed files
... ...
@@ -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
             {
Browse code

Progress

Benjamin Roth authored on14/11/2022 23:17:53
Showing1 changed files
... ...
@@ -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
 }
Browse code

Remote Progress

Benjamin Roth authored on08/11/2022 14:32:22
Showing1 changed files
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
+}