Code Coverage
 
Lines
Functions and Methods
Classes and Traits
Total
0.00% covered (danger)
0.00%
0 / 105
0.00% covered (danger)
0.00%
0 / 2
CRAP
0.00% covered (danger)
0.00%
0 / 1
OlzICal
0.00% covered (danger)
0.00%
0 / 105
0.00% covered (danger)
0.00%
0 / 2
90
0.00% covered (danger)
0.00%
0 / 1
 getHtml
0.00% covered (danger)
0.00%
0 / 104
0.00% covered (danger)
0.00%
0 / 1
56
 escapeText
0.00% covered (danger)
0.00%
0 / 1
0.00% covered (danger)
0.00%
0 / 1
6
1<?php
2
3// =============================================================================
4// iCal-Datei generieren mit Terminen des aktuellen Jahres.
5// Dieses Script wird immer beim Sichern und beim Löschen eines Termins
6// aufgerufen.
7// =============================================================================
8
9namespace Olz\Termine\Components\OlzICal;
10
11use Olz\Common\Components\OlzComponent;
12use Olz\Entity\Termine\Termin;
13use Olz\Entity\Termine\TerminReaction;
14
15/** @extends OlzComponent<array<string, mixed>> */
16class OlzICal extends OlzComponent {
17    public function getHtml(mixed $args): string {
18        $jahr = $this->dateUtils()->getCurrentDateInFormat('Y');
19        $base_href = $this->envUtils()->getBaseHref();
20        $code_href = $this->envUtils()->getCodeHref();
21        $now_fmt = date('Ymd\THis\Z');
22        $host = $this->envUtils()->getEmailForwardingHost();
23        $user = $this->authUtils()->getTokenUser();
24
25        // Termine abfragen
26        $termin_class = Termin::class;
27        $termin_reaction_class = TerminReaction::class;
28        $accept_emojis = implode("', '", TerminReaction::ACCEPT_EMOJIS);
29        $decline_emojis = implode("', '", TerminReaction::DECLINE_EMOJIS);
30        $dql = <<<ZZZZZZZZZZ
31            SELECT t, MIN(tyes.emoji), MIN(tno.emoji)
32            FROM {$termin_class} t
33                LEFT JOIN {$termin_reaction_class} tyes ON (
34                    tyes.user = :user_id
35                    AND tyes.termin = t.id
36                    AND tyes.emoji IN ('{$accept_emojis}')
37                )
38                LEFT JOIN {$termin_reaction_class} tno ON (
39                    tno.user = :user_id
40                    AND tno.termin = t.id
41                    AND tno.emoji IN ('{$decline_emojis}')
42                )
43            WHERE
44                t.start_date >= :start_date
45                AND t.deleted_at IS NULL
46            GROUP BY t.id
47            HAVING MIN(tyes.emoji) IS NOT NULL OR MIN(tno.emoji) IS NULL
48            ORDER BY t.start_date ASC, t.start_time ASC
49            ZZZZZZZZZZ;
50        $termine = $this->entityManager()
51            ->createQuery($dql)
52            ->setParameter('user_id', $user?->getId())
53            ->setParameter('start_date', "{$jahr}-01-01")
54            ->getResult()
55        ;
56
57        // ical-Kalender
58        $ical = "BEGIN:VCALENDAR".
59        "\r\nPRODID:OL Zimmerberg Termine".
60        "\r\nVERSION:2.0".
61        "\r\nMETHOD:PUBLISH".
62        "\r\nCALSCALE:GREGORIAN".
63        "\r\nX-WR-CALNAME:OL Zimmerberg Termine".
64        "\r\nX-WR-TIMEZONE:Europe/Zurich";
65
66        // Termine
67        foreach ($termine as $termin_row) {
68            [$termin, $yes_emoji, $no_emoji] = $termin_row;
69
70            $id = $termin->getId();
71            $start_date = $termin->getStartDate();
72            $end_date = $termin->getEndDate() ?? $start_date;
73            $duration_days = ($end_date->getTimestamp() - $start_date->getTimestamp()) / 86400;
74            $should_split = $duration_days > 8;
75            $solv_id = $termin->getSolvId();
76
77            $olz_url = "{$base_href}{$code_href}termine/{$id}";
78            $solv_url = "https://www.o-l.ch/cgi-bin/fixtures?&mode=show&unique_id={$solv_id}";
79
80            $links = "OLZ-Termin: {$olz_url}";
81            $attach = "\r\nATTACH;FMTTYPE=text/html:{$olz_url}";
82            $links .= $solv_id ? "\nSOLV-Termin: {$solv_url}" : "";
83            $attach .= $solv_id ? "\r\nATTACH;FMTTYPE=text/html:{$solv_url}" : "";
84
85            $plus_one_day = \DateInterval::createFromDateString("+1 days");
86            $end_date_end = (new \DateTime($end_date->format('Y-m-d')))->add($plus_one_day);
87            $start_date_fmt = $this->dateUtils()->olzDate('jjjjmmtt', $start_date);
88            $end_date_fmt = $this->dateUtils()->olzDate('jjjjmmtt', $end_date);
89            $end_date_end_fmt = $this->dateUtils()->olzDate('jjjjmmtt', $end_date_end);
90            $modified_fmt = $termin->getLastModifiedAt()->format('Ymd\THis\Z');
91            $created_fmt = $termin->getCreatedAt()->format('Ymd\THis\Z');
92            $yes_emoji_prefix = $yes_emoji ? "{$yes_emoji} " : '';
93            $no_emoji_prefix = $no_emoji ? "{$no_emoji} " : '';
94            $title_fmt = "{$yes_emoji_prefix}{$no_emoji_prefix}{$termin->getTitle()}";
95            $description_fmt = $this->escapeText("{$termin->getText()}\n{$links}");
96            $label_idents = implode(', ', array_map(
97                fn ($label) => "{$label->getIdent()}",
98                [...$termin->getLabels()],
99            ));
100            if ($should_split) {
101                $ical .=
102                "\r\nBEGIN:VEVENT".
103                "\r\nDTSTART;VALUE=DATE:{$start_date_fmt}".
104                "\r\nDTEND;VALUE=DATE:{$start_date_fmt}".
105                "\r\nDTSTAMP:{$now_fmt}".
106                "\r\nLAST-MODIFIED:{$modified_fmt}".
107                "\r\nCREATED:{$created_fmt}".
108                "\r\nSUMMARY:{$title_fmt} (Beginn)".
109                "\r\nDESCRIPTION:{$description_fmt}".
110                "\r\nCATEGORIES:{$label_idents}".
111                $attach.
112                "\r\nCLASS:PUBLIC".
113                "\r\nUID:olz_termin_{$id}_start@{$host}".
114                "\r\nEND:VEVENT".
115                "\r\nBEGIN:VEVENT".
116                "\r\nDTSTART;VALUE=DATE:{$end_date_fmt}".
117                "\r\nDTEND;VALUE=DATE:{$end_date_fmt}".
118                "\r\nDTSTAMP:{$now_fmt}".
119                "\r\nLAST-MODIFIED:{$modified_fmt}".
120                "\r\nCREATED:{$created_fmt}".
121                "\r\nSUMMARY:{$title_fmt} (Ende)".
122                "\r\nDESCRIPTION:{$description_fmt}".
123                "\r\nCATEGORIES:{$label_idents}".
124                $attach.
125                "\r\nCLASS:PUBLIC".
126                "\r\nUID:olz_termin_{$id}_end@{$host}".
127                "\r\nEND:VEVENT";
128            } else {
129                $ical .=
130                "\r\nBEGIN:VEVENT".
131                "\r\nDTSTART;VALUE=DATE:{$start_date_fmt}".
132                "\r\nDTEND;VALUE=DATE:{$end_date_end_fmt}".
133                "\r\nDTSTAMP:{$now_fmt}".
134                "\r\nLAST-MODIFIED:{$modified_fmt}".
135                "\r\nCREATED:{$created_fmt}".
136                "\r\nSUMMARY:{$title_fmt}".
137                "\r\nDESCRIPTION:{$description_fmt}".
138                "\r\nCATEGORIES:{$label_idents}".
139                $attach.
140                "\r\nCLASS:PUBLIC".
141                "\r\nUID:olz_termin_{$id}@{$host}".
142                "\r\nEND:VEVENT";
143            }
144        }
145
146        $ical .= "\r\nEND:VCALENDAR";
147
148        return $ical;
149    }
150
151    protected function escapeText(string $text): string {
152        return preg_replace("/(\r\n|\n|\r)/", "\\n", $text) ?: '';
153    }
154}