BlueGit

projects-timfalken-com verhalenboek

Files

verhalenboek / web / lib / Feed.php

Feed.php

Feed.php 6.7 KiB Download Raw
1<?php
2declare(strict_types=1);
3
4// Atom-feed per lezer. Een beheerder zet de feed aan; daarna maakt elke lezer
5// een eigen geheime feed-sleutel. De feed toont dagen, nooit de wiki, en zet
6// niets op gelezen.
7
8const FEED_SETTING = 'feed_enabled';
9const FEED_LIMIT = 60;
10
11function appSetting(string $name, string $default = ''): string {
12 $value = query('SELECT value FROM app_settings WHERE name=?', [$name])->fetchColumn();
13 return is_string($value) ? $value : $default;
14}
15
16function setAppSetting(string $name, string $value): void {
17 query('INSERT INTO app_settings (name, value, updated) VALUES (?,?,?)
18 ON CONFLICT(name) DO UPDATE SET value=excluded.value, updated=excluded.updated', [$name, $value, time()]);
19}
20
21function feedEnabled(): bool {
22 return appSetting(FEED_SETTING, '0') === '1';
23}
24
25function setFeedEnabled(bool $enabled): array {
26 setAppSetting(FEED_SETTING, $enabled ? '1' : '0');
27 return feedAdminState();
28}
29
30function feedAdminState(): array {
31 return [
32 'enabled' => feedEnabled(),
33 'tokens' => (int)query('SELECT COUNT(*) FROM feed_tokens')->fetchColumn(),
34 ];
35}
36
37function feedUrl(string $token): string {
38 return baseUrl().'/feed.php?token='.rawurlencode($token);
39}
40
41function feedTokenState(string $userId): array {
42 $row = query('SELECT * FROM feed_tokens WHERE user_id=?', [$userId])->fetch();
43 if (!$row) return ['enabled' => true, 'token' => null];
44 $token = null;
45 try {
46 $plain = openToken((string)$row['token_cipher']);
47 if (hash_equals($row['token_hash'], hash('sha256', $plain))) $token = $plain;
48 } catch (Throwable $e) {
49 $token = null;
50 }
51 return ['enabled' => true, 'token' => [
52 'prefix' => $row['token_prefix'],
53 'created' => (int)$row['created'],
54 'url' => $token !== null ? feedUrl($token) : null,
55 ]];
56}
57
58function createFeedToken(string $userId): array {
59 $token = 'vbf_'.bin2hex(random_bytes(32));
60 transaction(function () use ($userId, $token): void {
61 query('DELETE FROM feed_tokens WHERE user_id=?', [$userId]);
62 query('INSERT INTO feed_tokens (user_id, token_hash, token_prefix, token_cipher, created) VALUES (?,?,?,?,?)', [
63 $userId, hash('sha256', $token), substr($token, 0, 12), sealToken($token), time(),
64 ]);
65 });
66 return feedTokenState($userId);
67}
68
69function revokeFeedToken(string $userId): array {
70 query('DELETE FROM feed_tokens WHERE user_id=?', [$userId]);
71 return feedTokenState($userId);
72}
73
74function feedUserForToken(mixed $token): ?string {
75 if (!is_string($token) || !preg_match('/^vbf_[a-f0-9]{64}$/', $token)) return null;
76 $userId = query('SELECT user_id FROM feed_tokens WHERE token_hash=?', [hash('sha256', $token)])->fetchColumn();
77 return is_string($userId) ? $userId : null;
78}
79
80function feedToday(): string {
81 return (new DateTimeImmutable('now', new DateTimeZone('Europe/Amsterdam')))->format('Y-m-d');
82}
83
84/** Dagen tot en met vandaag, nieuwste eerst, met hun verhalen. Leest alleen. */
85function feedDays(?string $today = null, int $limit = FEED_LIMIT): array {
86 $today = validDate($today ?? feedToday());
87 $days = query('SELECT id, date, title, created, updated FROM days WHERE date<=? ORDER BY date DESC LIMIT '.max(1, $limit), [$today])->fetchAll();
88 $out = [];
89 foreach ($days as $day) {
90 $stories = [];
91 foreach (query('SELECT id, position, title, updated FROM stories WHERE day_id=? ORDER BY position, id', [$day['id']])->fetchAll() as $story) {
92 $stories[] = [
93 'title' => $story['title'],
94 'paragraphs' => array_values(query('SELECT body FROM paragraphs WHERE story_id=? ORDER BY position, id', [$story['id']])->fetchAll(PDO::FETCH_COLUMN)),
95 'updated' => (int)$story['updated'],
96 ];
97 }
98 if ($stories === []) continue;
99 $updated = max([(int)$day['updated'], ...array_column($stories, 'updated')]);
100 $out[] = ['date' => $day['date'], 'title' => $day['title'], 'updated' => $updated, 'stories' => $stories];
101 }
102 return $out;
103}
104
105function feedEsc(string $value): string {
106 return htmlspecialchars($value, ENT_QUOTES | ENT_XML1 | ENT_SUBSTITUTE, 'UTF-8');
107}
108
109function feedDayHtml(array $day): string {
110 $html = '';
111 foreach ($day['stories'] as $story) {
112 $html .= '<h2>'.htmlspecialchars($story['title'], ENT_QUOTES | ENT_HTML5, 'UTF-8').'</h2>';
113 foreach ($story['paragraphs'] as $paragraph) {
114 $html .= '<p>'.nl2br(htmlspecialchars((string)$paragraph, ENT_QUOTES | ENT_HTML5, 'UTF-8'), false).'</p>';
115 }
116 }
117 return $html;
118}
119
120function feedDayLabel(string $date): string {
121 $months = ['januari', 'februari', 'maart', 'april', 'mei', 'juni', 'juli', 'augustus', 'september', 'oktober', 'november', 'december'];
122 $d = new DateTimeImmutable($date.' 00:00:00', new DateTimeZone('UTC'));
123 return (int)$d->format('j').' '.$months[(int)$d->format('n') - 1].' '.$d->format('Y');
124}
125
126function feedXml(string $selfUrl, array $days): string {
127 $base = baseUrl();
128 $host = parse_url($base, PHP_URL_HOST) ?: 'localhost';
129 $updated = $days !== [] ? max(array_column($days, 'updated')) : time();
130 $xml = '<?xml version="1.0" encoding="utf-8"?>'."\n";
131 $xml .= '<feed xmlns="http://www.w3.org/2005/Atom" xml:lang="nl">'."\n";
132 $xml .= ' <title>Verhalenboek</title>'."\n";
133 $xml .= ' <subtitle>Elke dag drie verhalen.</subtitle>'."\n";
134 $xml .= ' <id>tag:'.feedEsc($host).',2026:verhaaltjesboek</id>'."\n";
135 $xml .= ' <link rel="alternate" type="text/html" href="'.feedEsc($base.'/').'"/>'."\n";
136 $xml .= ' <link rel="self" type="application/atom+xml" href="'.feedEsc($selfUrl).'"/>'."\n";
137 $xml .= ' <icon>'.feedEsc($base.'/assets/icon-192.png').'</icon>'."\n";
138 $xml .= ' <updated>'.gmdate('Y-m-d\TH:i:s\Z', $updated).'</updated>'."\n";
139 $xml .= ' <author><name>Verhalenboek</name></author>'."\n";
140 foreach ($days as $day) {
141 $titles = implode(' · ', array_column($day['stories'], 'title'));
142 $xml .= ' <entry>'."\n";
143 $xml .= ' <id>tag:'.feedEsc($host).',2026:verhaaltjesboek/dag/'.feedEsc($day['date']).'</id>'."\n";
144 $xml .= ' <title>'.feedEsc(feedDayLabel($day['date']).': '.$day['title']).'</title>'."\n";
145 $xml .= ' <link rel="alternate" type="text/html" href="'.feedEsc($base.'/#/dag/'.$day['date']).'"/>'."\n";
146 $xml .= ' <published>'.feedEsc($day['date']).'T00:00:00+00:00</published>'."\n";
147 $xml .= ' <updated>'.gmdate('Y-m-d\TH:i:s\Z', $day['updated']).'</updated>'."\n";
148 $xml .= ' <summary>'.feedEsc($titles).'</summary>'."\n";
149 $xml .= ' <content type="html">'.feedEsc(feedDayHtml($day)).'</content>'."\n";
150 $xml .= ' </entry>'."\n";
151 }
152 return $xml.'</feed>'."\n";
153}