Code Coverage
 
Lines
Functions and Methods
Classes and Traits
Total
0.00% covered (danger)
0.00%
0 / 145
0.00% covered (danger)
0.00%
0 / 5
CRAP
0.00% covered (danger)
0.00%
0 / 1
OlzNewsListParams
n/a
0 / 0
n/a
0 / 0
0
n/a
0 / 0
OlzNewsList
0.00% covered (danger)
0.00%
0 / 145
0.00% covered (danger)
0.00%
0 / 5
930
0.00% covered (danger)
0.00%
0 / 1
 hasAccess
0.00% covered (danger)
0.00%
0 / 1
0.00% covered (danger)
0.00%
0 / 1
2
 searchSqlWhenHasAccess
0.00% covered (danger)
0.00%
0 / 14
0.00% covered (danger)
0.00%
0 / 1
2
 getPageTitle
0.00% covered (danger)
0.00%
0 / 1
0.00% covered (danger)
0.00%
0 / 1
2
 getPageDescription
0.00% covered (danger)
0.00%
0 / 1
0.00% covered (danger)
0.00%
0 / 1
2
 getHtmlWhenHasAccess
0.00% covered (danger)
0.00%
0 / 128
0.00% covered (danger)
0.00%
0 / 1
702
1<?php
2
3namespace Olz\News\Components\OlzNewsList;
4
5use Olz\Apps\OlzApps;
6use Olz\Common\Components\OlzFooter\OlzFooter;
7use Olz\Common\Components\OlzHeader\OlzHeader;
8use Olz\Common\Components\OlzRootComponent;
9use Olz\Common\Utils\HttpParams;
10use Olz\Entity\News\NewsEntry;
11use Olz\Entity\Roles\Role;
12use Olz\Entity\Termine\Termin;
13use Olz\Entity\Users\User;
14use Olz\News\Components\OlzNewsFilter\OlzNewsFilter;
15use Olz\News\Components\OlzNewsListItem\OlzNewsListItem;
16use Olz\News\Utils\NewsUtils;
17
18/** @extends HttpParams<array{
19 *   filter?: ?string,
20 *   seite?: ?numeric-string,
21 *   von?: ?string,
22 * }> */
23class OlzNewsListParams extends HttpParams {
24}
25
26/** @extends OlzRootComponent<array<string, mixed>> */
27class OlzNewsList extends OlzRootComponent {
28    public function hasAccess(): bool {
29        return true;
30    }
31
32    public function searchSqlWhenHasAccess(array $terms): string|array|null {
33        $format_options = NewsUtils::ALL_FORMAT_OPTIONS;
34        $queries = array_map(function ($format_option) use ($terms) {
35            $ident = $format_option['ident'];
36            $valid_filter = $this->newsUtils()->getValidFilter([
37                'format' => $ident,
38            ]);
39            return $this->searchUtils()->getStaticResultQuery([
40                'link' => $this->newsUtils()->getUrl($valid_filter),
41                'icon' => $this->newsUtils()->getNewsFormatIcon($ident),
42                'title' => "News: {$format_option['name']}",
43                'text' => $this->getPageDescription(),
44            ], $terms);
45        }, $format_options);
46        return $this->searchUtils()->unionAllQueries($queries);
47    }
48
49    public function getPageTitle(): string {
50        return "News";
51    }
52
53    public function getPageDescription(): string {
54        return "Aktuelle Beiträge, Berichte von Anlässen, Foto-Galerien und weitere Neuigkeiten vom Vorstand, Kaderläufern und anderen Mitgliedern der OL Zimmerberg.";
55    }
56
57    public static int $page_size = 25;
58
59    public function getHtmlWhenHasAccess(mixed $args): string {
60        $params = $this->httpUtils()->validateGetParams(OlzNewsListParams::class);
61        $db = $this->dbUtils()->getDb();
62        $entityManager = $this->dbUtils()->getEntityManager();
63        $code_href = $this->envUtils()->getCodeHref();
64
65        $news_utils = $this->newsUtils();
66        $current_filter = $news_utils->deserialize($params['filter'] ?? $this->session()->get('news_filter') ?? '');
67        $page_number = intval($params['seite'] ?? $this->session()->get('news_page') ?? 1);
68        $page_index = $page_number - 1;
69
70        $valid_filter = $news_utils->getValidFilter($current_filter);
71        $serialized_filter = $news_utils->serialize($valid_filter);
72
73        if (
74            !$news_utils->isValidFilter($current_filter)
75            || ($params['filter'] ?? '') !== $serialized_filter
76            || ($params['seite'] ?? '') !== "{$page_number}"
77        ) {
78            $is_backfill = empty($params['filter']) || empty($params['seite']);
79            $this->httpUtils()->redirect(
80                "{$code_href}news?filter={$serialized_filter}&seite={$page_number}",
81                ['status' => $is_backfill ? 308 : 410, 'no_cache' => true],
82            );
83        }
84
85        $this->session()->set('news_filter', $serialized_filter);
86        $this->session()->set('news_page', "{$page_number}");
87
88        $news_list_title = $news_utils->getTitleFromFilter($valid_filter);
89        $out = OlzHeader::render([
90            'title' => $news_list_title,
91            'description' => $this->getPageDescription(), // TODO: Filter-specific description?
92            'canonical_url' => "{$code_href}news?filter={$serialized_filter}&seite={$page_number}",
93        ]);
94
95        $out .= "<div class='content-right'>";
96        $out .= "<h2 class='optional'>Filter</h2>";
97        $out .= OlzNewsFilter::render(['currentFilter' => $valid_filter]);
98        $out .= "</div>";
99        $out .= "<div class='content-middle olz-news-list-middle'>";
100
101        $is_logged_in = $this->authUtils()->hasPermission('any');
102        $has_blog = $this->authUtils()->hasPermission('kaderblog');
103        $has_roles = !empty($this->authUtils()->getAuthenticatedRoles());
104        $json_mode = htmlentities(json_encode($has_roles ? ($has_blog ? 'account_with_all' : 'account_with_aktuell') : ($has_blog ? 'account_with_blog' : 'account')) ?: '');
105        $class = $is_logged_in ? ' btn-auth create-news-container' : ' btn-secondary dropdown-toggle';
106        $properties = $is_logged_in
107            ? <<<ZZZZZZZZZZ
108                onclick='return olz.initOlzEditNewsModal({$json_mode})'
109                ZZZZZZZZZZ
110            : <<<'ZZZZZZZZZZ'
111                type='button'
112                data-bs-toggle='dropdown'
113                aria-expanded='false'
114                ZZZZZZZZZZ;
115        if (!$is_logged_in) {
116            $out .= "<div class='dropdown create-news-container'>";
117        }
118        $out .= <<<ZZZZZZZZZZ
119            <button
120                id='create-news-button'
121                class='btn{$class}'
122                {$properties}
123            >
124                <img src='{$code_href}assets/icns/new_16.svg' class='noborder' />
125                Neuer Eintrag
126            </button>
127            ZZZZZZZZZZ;
128        if (!$is_logged_in) {
129            $out .= <<<'ZZZZZZZZZZ'
130                <div
131                    class='dropdown-menu dropdown-menu-end'
132                    aria-labelledby='create-news-button'
133                >
134                    <li><button
135                        class='dropdown-item'
136                        onclick='olz.loginAndReload({}); return false;'
137                    >
138                        Login
139                    </button></li>
140                    <li><hr class="dropdown-divider"></li>
141                    <li><div class='dropdown-item disabled should-login'>
142                        <b>Achtung</b>: Bild-Upload und nachträgliches Bearbeiten des Eintrags nur mit Login möglich!
143                    </div></li>
144                    <li><button
145                        id='create-anonymous-button'
146                        class='dropdown-item'
147                        onclick='return olz.initOlzEditNewsModal(&quot;anonymous&quot;)'
148                    >
149                        Forumseintrag ohne Login
150                    </button></li>
151                </div>
152                ZZZZZZZZZZ;
153            $out .= "</div>";
154        }
155
156        $newsletter_link = '';
157        $newsletter_app = OlzApps::getApp('Newsletter');
158        if ($newsletter_app) {
159            $newsletter_link = <<<ZZZZZZZZZZ
160                <a href='{$code_href}{$newsletter_app->getHref()}' class='newsletter-link'>
161                    <img
162                        src='{$newsletter_app->getIcon()}'
163                        alt='newsletter'
164                        class='newsletter-link-icon'
165                        title='Newsletter abonnieren!'
166                    />
167                </a>
168                ZZZZZZZZZZ;
169        } else {
170            $this->log()->error('Newsletter App does not exist!');
171        }
172        $out .= "<h1>{$news_list_title} {$newsletter_link}</h1>";
173
174        $filter_where = $news_utils->getSqlFromFilter($valid_filter);
175        $first_index = $page_index * $this::$page_size;
176        $sql = <<<ZZZZZZZZZZ
177            SELECT
178                COUNT(n.id) as count
179            FROM news n
180            WHERE
181                {$filter_where}
182                AND n.deleted_at IS NULL
183            ORDER BY published_date DESC, published_time DESC
184            ZZZZZZZZZZ;
185        // @phpstan-ignore-next-line
186        $count = intval($db->query($sql)->fetch_assoc()['count']);
187        $num_pages = intval($count / $this::$page_size) + 1;
188
189        $sql = <<<ZZZZZZZZZZ
190            SELECT
191                id,
192                owner_user_id,
193                owner_role_id,
194                published_date,
195                published_time,
196                format,
197                author_user_id,
198                author_role_id,
199                author_name,
200                author_email,
201                title,
202                teaser,
203                content,
204                image_ids,
205                termin_id
206            FROM news n
207            WHERE
208                {$filter_where}
209                AND n.deleted_at IS NULL
210            ORDER BY published_date DESC, published_time DESC
211            LIMIT {$first_index}, {$this::$page_size}
212            ZZZZZZZZZZ;
213        $res = $db->query($sql);
214
215        $user_repo = $entityManager->getRepository(User::class);
216        $role_repo = $entityManager->getRepository(Role::class);
217        $termin_repo = $entityManager->getRepository(Termin::class);
218
219        $page_content = '';
220        // @phpstan-ignore-next-line
221        for ($index = 0; $index < $res->num_rows; $index++) {
222            // @phpstan-ignore-next-line
223            $row = $res->fetch_assoc();
224
225            // TODO: Directly use doctrine to run the DB query.
226            // @phpstan-ignore-next-line
227            $owner_user = $row['owner_user_id'] ?
228                $user_repo->findOneBy(['id' => $row['owner_user_id']]) : null;
229            $owner_role = $row['owner_role_id'] ?
230                $role_repo->findOneBy(['id' => $row['owner_role_id']]) : null;
231            $author_user = $row['author_user_id'] ?
232                $user_repo->findOneBy(['id' => $row['author_user_id']]) : null;
233            $author_role = $row['author_role_id'] ?
234                $role_repo->findOneBy(['id' => $row['author_role_id']]) : null;
235
236            $news_entry = new NewsEntry();
237            $news_entry->setOwnerUser($owner_user);
238            $news_entry->setOwnerRole($owner_role);
239            // @phpstan-ignore-next-line
240            $news_entry->setPublishedDate(new \DateTime($row['published_date']));
241            // @phpstan-ignore-next-line
242            $news_entry->setFormat($row['format']);
243            $news_entry->setAuthorUser($author_user);
244            $news_entry->setAuthorRole($author_role);
245            // @phpstan-ignore-next-line
246            $news_entry->setAuthorName($row['author_name']);
247            // @phpstan-ignore-next-line
248            $news_entry->setAuthorEmail($row['author_email']);
249            // @phpstan-ignore-next-line
250            $news_entry->setTitle($row['title']);
251            // @phpstan-ignore-next-line
252            $news_entry->setTeaser($row['teaser']);
253            // @phpstan-ignore-next-line
254            $news_entry->setContent($row['content']);
255            $news_entry->setId(intval($row['id']));
256            // @phpstan-ignore-next-line
257            $news_entry->setImageIds($row['image_ids'] ? json_decode($row['image_ids'], true) : null);
258            $news_entry->setTermin($row['termin_id'] ? $termin_repo->findOneBy(['id' => $row['termin_id']]) : null);
259
260            $page_content .= OlzNewsListItem::render([
261                'json_mode' => $json_mode,
262                'news_entry' => $news_entry,
263            ]);
264        }
265        if ($page_content === '') {
266            $page_content = "<div class='no-entries'>Keine Einträge. Bitte Filter anpassen.</div>";
267        }
268        $out .= $page_content;
269        if ($num_pages > 1) {
270            $pages = '';
271            for ($page_number = 1; $page_number <= $num_pages; $page_number++) {
272                $is_current_page = $page_number === $page_index + 1;
273                $page_link_class = $is_current_page ? ' active' : '';
274                $pages .= <<<ZZZZZZZZZZ
275                    <li class='page-item'>
276                        <a
277                            class='page-link{$page_link_class}'
278                            href='?filter={$serialized_filter}&seite={$page_number}'
279                        >
280                            {$page_number}
281                        </a>
282                    </li>
283                    ZZZZZZZZZZ;
284            }
285            $out .= "<nav><ul class='no-style pagination justify-content-center'>{$pages}</ul></nav>";
286        }
287
288        $out .= "</div>";
289
290        $out .= OlzFooter::render();
291
292        return $out;
293    }
294}