xref: /webtrees/app/Module/FamilyTreeNewsModule.php (revision 0dc38e0894d9de8cdf9b2c6b316adf2938f519c5)
18c2e8227SGreg Roach<?php
23976b470SGreg Roach
38c2e8227SGreg Roach/**
48c2e8227SGreg Roach * webtrees: online genealogy
58fcd0d32SGreg Roach * Copyright (C) 2019 webtrees development team
68c2e8227SGreg Roach * This program is free software: you can redistribute it and/or modify
78c2e8227SGreg Roach * it under the terms of the GNU General Public License as published by
88c2e8227SGreg Roach * the Free Software Foundation, either version 3 of the License, or
98c2e8227SGreg Roach * (at your option) any later version.
108c2e8227SGreg Roach * This program is distributed in the hope that it will be useful,
118c2e8227SGreg Roach * but WITHOUT ANY WARRANTY; without even the implied warranty of
128c2e8227SGreg Roach * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
138c2e8227SGreg Roach * GNU General Public License for more details.
148c2e8227SGreg Roach * You should have received a copy of the GNU General Public License
158c2e8227SGreg Roach * along with this program. If not, see <http://www.gnu.org/licenses/>.
168c2e8227SGreg Roach */
17fcfa147eSGreg Roach
18e7f56f2aSGreg Roachdeclare(strict_types=1);
19e7f56f2aSGreg Roach
2076692c8bSGreg Roachnamespace Fisharebest\Webtrees\Module;
2176692c8bSGreg Roach
220e62c4b8SGreg Roachuse Fisharebest\Webtrees\Auth;
234459dc9aSGreg Roachuse Fisharebest\Webtrees\Carbon;
24d501c45dSGreg Roachuse Fisharebest\Webtrees\Exceptions\HttpAccessDeniedException;
258e0e1b25SGreg Roachuse Fisharebest\Webtrees\Http\RequestHandlers\TreePage;
260e62c4b8SGreg Roachuse Fisharebest\Webtrees\I18N;
2750d6f48cSGreg Roachuse Fisharebest\Webtrees\Services\HtmlService;
28fe8a65d1SGreg Roachuse Fisharebest\Webtrees\Tree;
29cef665d9SGreg Roachuse Illuminate\Database\Capsule\Manager as DB;
30*0dc38e08SGreg Roachuse Illuminate\Database\Query\Expression;
311e7a7a28SGreg Roachuse Illuminate\Support\Str;
326ccdf4f0SGreg Roachuse Psr\Http\Message\ResponseInterface;
336ccdf4f0SGreg Roachuse Psr\Http\Message\ServerRequestInterface;
34ca52a408SGreg Roachuse stdClass;
35f3874e19SGreg Roach
365229eadeSGreg Roachuse function assert;
378c2e8227SGreg Roach
388c2e8227SGreg Roach/**
398c2e8227SGreg Roach * Class FamilyTreeNewsModule
408c2e8227SGreg Roach */
4137eb8894SGreg Roachclass FamilyTreeNewsModule extends AbstractModule implements ModuleBlockInterface
42c1010edaSGreg Roach{
4349a243cbSGreg Roach    use ModuleBlockTrait;
4449a243cbSGreg Roach
4550d6f48cSGreg Roach    /** @var HtmlService */
4650d6f48cSGreg Roach    private $html_service;
4750d6f48cSGreg Roach
4850d6f48cSGreg Roach    /**
499e18e23bSGreg Roach     * HtmlBlockModule constructor.
5050d6f48cSGreg Roach     *
5150d6f48cSGreg Roach     * @param HtmlService $html_service
5250d6f48cSGreg Roach     */
539e18e23bSGreg Roach    public function __construct(HtmlService $html_service)
5450d6f48cSGreg Roach    {
5550d6f48cSGreg Roach        $this->html_service = $html_service;
5650d6f48cSGreg Roach    }
5750d6f48cSGreg Roach
5876692c8bSGreg Roach    /**
5976692c8bSGreg Roach     * A sentence describing what this module does.
6076692c8bSGreg Roach     *
6176692c8bSGreg Roach     * @return string
6276692c8bSGreg Roach     */
6349a243cbSGreg Roach    public function description(): string
64c1010edaSGreg Roach    {
65bbb76c12SGreg Roach        /* I18N: Description of the “News” module */
66bbb76c12SGreg Roach        return I18N::translate('Family news and site announcements.');
678c2e8227SGreg Roach    }
688c2e8227SGreg Roach
6976692c8bSGreg Roach    /**
7076692c8bSGreg Roach     * Generate the HTML content of this block.
7176692c8bSGreg Roach     *
72e490cd80SGreg Roach     * @param Tree     $tree
7376692c8bSGreg Roach     * @param int      $block_id
743caaa4d2SGreg Roach     * @param string   $context
753caaa4d2SGreg Roach     * @param string[] $config
7676692c8bSGreg Roach     *
7776692c8bSGreg Roach     * @return string
7876692c8bSGreg Roach     */
793caaa4d2SGreg Roach    public function getBlock(Tree $tree, int $block_id, string $context, array $config = []): string
80c1010edaSGreg Roach    {
81cef665d9SGreg Roach        $articles = DB::table('news')
82cef665d9SGreg Roach            ->where('gedcom_id', '=', $tree->id())
83cef665d9SGreg Roach            ->orderByDesc('updated')
84ca52a408SGreg Roach            ->get()
850b5fd0a6SGreg Roach            ->map(static function (stdClass $row): stdClass {
864459dc9aSGreg Roach                $row->updated = Carbon::make($row->updated);
87ca52a408SGreg Roach
88ca52a408SGreg Roach                return $row;
89ca52a408SGreg Roach            });
90d004f62cSGreg Roach
91147e99aaSGreg Roach        $content = view('modules/gedcom_news/list', [
92fe8a65d1SGreg Roach            'articles' => $articles,
93fe8a65d1SGreg Roach            'block_id' => $block_id,
94fe8a65d1SGreg Roach            'limit'    => 5,
95fd303cbfSGreg Roach            'tree'     => $tree,
96fe8a65d1SGreg Roach        ]);
978c2e8227SGreg Roach
983caaa4d2SGreg Roach        if ($context !== self::CONTEXT_EMBED) {
99147e99aaSGreg Roach            return view('modules/block-template', [
1001e7a7a28SGreg Roach                'block'      => Str::kebab($this->name()),
1019c6524dcSGreg Roach                'id'         => $block_id,
1029c6524dcSGreg Roach                'config_url' => '',
10349a243cbSGreg Roach                'title'      => $this->title(),
1049c6524dcSGreg Roach                'content'    => $content,
1059c6524dcSGreg Roach            ]);
1068c2e8227SGreg Roach        }
107b2ce94c6SRico Sonntag
108b2ce94c6SRico Sonntag        return $content;
1098c2e8227SGreg Roach    }
1108c2e8227SGreg Roach
1116ccdf4f0SGreg Roach    /**
1126ccdf4f0SGreg Roach     * How should this module be identified in the control panel, etc.?
1136ccdf4f0SGreg Roach     *
1146ccdf4f0SGreg Roach     * @return string
1156ccdf4f0SGreg Roach     */
1166ccdf4f0SGreg Roach    public function title(): string
1176ccdf4f0SGreg Roach    {
1186ccdf4f0SGreg Roach        /* I18N: Name of a module */
1196ccdf4f0SGreg Roach        return I18N::translate('News');
1206ccdf4f0SGreg Roach    }
1216ccdf4f0SGreg Roach
12250d6f48cSGreg Roach    /**
12350d6f48cSGreg Roach     * Should this block load asynchronously using AJAX?
12450d6f48cSGreg Roach     *
1253caaa4d2SGreg Roach     * Simple blocks are faster in-line, more complex ones can be loaded later.
12650d6f48cSGreg Roach     *
12750d6f48cSGreg Roach     * @return bool
12850d6f48cSGreg Roach     */
129c1010edaSGreg Roach    public function loadAjax(): bool
130c1010edaSGreg Roach    {
1318c2e8227SGreg Roach        return false;
1328c2e8227SGreg Roach    }
1338c2e8227SGreg Roach
13450d6f48cSGreg Roach    /**
13550d6f48cSGreg Roach     * Can this block be shown on the user’s home page?
13650d6f48cSGreg Roach     *
13750d6f48cSGreg Roach     * @return bool
13850d6f48cSGreg Roach     */
139c1010edaSGreg Roach    public function isUserBlock(): bool
140c1010edaSGreg Roach    {
1418c2e8227SGreg Roach        return false;
1428c2e8227SGreg Roach    }
1438c2e8227SGreg Roach
14450d6f48cSGreg Roach    /**
14550d6f48cSGreg Roach     * Can this block be shown on the tree’s home page?
14650d6f48cSGreg Roach     *
14750d6f48cSGreg Roach     * @return bool
14850d6f48cSGreg Roach     */
14963276d8fSGreg Roach    public function isTreeBlock(): bool
150c1010edaSGreg Roach    {
1518c2e8227SGreg Roach        return true;
1528c2e8227SGreg Roach    }
1538c2e8227SGreg Roach
15476692c8bSGreg Roach    /**
1556ccdf4f0SGreg Roach     * @param ServerRequestInterface $request
156fe8a65d1SGreg Roach     *
1576ccdf4f0SGreg Roach     * @return ResponseInterface
158fe8a65d1SGreg Roach     */
15957ab2231SGreg Roach    public function getEditNewsAction(ServerRequestInterface $request): ResponseInterface
160c1010edaSGreg Roach    {
16157ab2231SGreg Roach        $tree = $request->getAttribute('tree');
16275964c75SGreg Roach        assert($tree instanceof Tree);
16357ab2231SGreg Roach
164fe8a65d1SGreg Roach        if (!Auth::isManager($tree)) {
165d501c45dSGreg Roach            throw new HttpAccessDeniedException();
166fe8a65d1SGreg Roach        }
167fe8a65d1SGreg Roach
168ac5f8ed1SGreg Roach        $news_id = $request->getQueryParams()['news_id'] ?? '';
169fe8a65d1SGreg Roach
170ac5f8ed1SGreg Roach        if ($news_id !== '') {
171cef665d9SGreg Roach            $row = DB::table('news')
172cef665d9SGreg Roach                ->where('news_id', '=', $news_id)
173cef665d9SGreg Roach                ->where('gedcom_id', '=', $tree->id())
174cef665d9SGreg Roach                ->first();
175fe8a65d1SGreg Roach        } else {
176fe8a65d1SGreg Roach            $row = (object) [
177fe8a65d1SGreg Roach                'body'    => '',
178fe8a65d1SGreg Roach                'subject' => '',
179fe8a65d1SGreg Roach            ];
180fe8a65d1SGreg Roach        }
181fe8a65d1SGreg Roach
182fe8a65d1SGreg Roach        $title = I18N::translate('Add/edit a journal/news entry');
183fe8a65d1SGreg Roach
184147e99aaSGreg Roach        return $this->viewResponse('modules/gedcom_news/edit', [
185fe8a65d1SGreg Roach            'body'    => $row->body,
186fe8a65d1SGreg Roach            'news_id' => $news_id,
187fe8a65d1SGreg Roach            'subject' => $row->subject,
188fe8a65d1SGreg Roach            'title'   => $title,
189b3f0586eSGreg Roach            'tree'    => $tree,
190fe8a65d1SGreg Roach        ]);
191fe8a65d1SGreg Roach    }
192fe8a65d1SGreg Roach
193fe8a65d1SGreg Roach    /**
1946ccdf4f0SGreg Roach     * @param ServerRequestInterface $request
195fe8a65d1SGreg Roach     *
1966ccdf4f0SGreg Roach     * @return ResponseInterface
197fe8a65d1SGreg Roach     */
19857ab2231SGreg Roach    public function postEditNewsAction(ServerRequestInterface $request): ResponseInterface
199c1010edaSGreg Roach    {
20057ab2231SGreg Roach        $tree = $request->getAttribute('tree');
20175964c75SGreg Roach        assert($tree instanceof Tree);
20257ab2231SGreg Roach
203fe8a65d1SGreg Roach        if (!Auth::isManager($tree)) {
204d501c45dSGreg Roach            throw new HttpAccessDeniedException();
205fe8a65d1SGreg Roach        }
206fe8a65d1SGreg Roach
207ac5f8ed1SGreg Roach        $news_id = $request->getQueryParams()['news_id'] ?? '';
208b46c87bdSGreg Roach
209b46c87bdSGreg Roach        $params = (array) $request->getParsedBody();
210b46c87bdSGreg Roach
211b46c87bdSGreg Roach        $subject = $params['subject'];
212b46c87bdSGreg Roach        $body    = $params['body'];
213fe8a65d1SGreg Roach
21450d6f48cSGreg Roach        $subject = $this->html_service->sanitize($subject);
21550d6f48cSGreg Roach        $body    = $this->html_service->sanitize($body);
21650d6f48cSGreg Roach
217fe8a65d1SGreg Roach        if ($news_id > 0) {
218cef665d9SGreg Roach            DB::table('news')
219cef665d9SGreg Roach                ->where('news_id', '=', $news_id)
220cef665d9SGreg Roach                ->where('gedcom_id', '=', $tree->id())
221cef665d9SGreg Roach                ->update([
222fe8a65d1SGreg Roach                    'body'    => $body,
223cef665d9SGreg Roach                    'subject' => $subject,
224*0dc38e08SGreg Roach                    'updated' => new Expression('updated'), // See issue #3208
225fe8a65d1SGreg Roach                ]);
226fe8a65d1SGreg Roach        } else {
227cef665d9SGreg Roach            DB::table('news')->insert([
228fe8a65d1SGreg Roach                'body'      => $body,
229fe8a65d1SGreg Roach                'subject'   => $subject,
230cef665d9SGreg Roach                'gedcom_id' => $tree->id(),
231fe8a65d1SGreg Roach            ]);
232fe8a65d1SGreg Roach        }
233fe8a65d1SGreg Roach
2348e0e1b25SGreg Roach        $url = route(TreePage::class, ['tree' => $tree->name()]);
235fe8a65d1SGreg Roach
2366ccdf4f0SGreg Roach        return redirect($url);
237fe8a65d1SGreg Roach    }
238fe8a65d1SGreg Roach
239fe8a65d1SGreg Roach    /**
2406ccdf4f0SGreg Roach     * @param ServerRequestInterface $request
241fe8a65d1SGreg Roach     *
2426ccdf4f0SGreg Roach     * @return ResponseInterface
243fe8a65d1SGreg Roach     */
24457ab2231SGreg Roach    public function postDeleteNewsAction(ServerRequestInterface $request): ResponseInterface
245c1010edaSGreg Roach    {
24657ab2231SGreg Roach        $tree = $request->getAttribute('tree');
2474ea62551SGreg Roach        assert($tree instanceof Tree);
2484ea62551SGreg Roach
249ac5f8ed1SGreg Roach        $news_id = $request->getQueryParams()['news_id'];
250fe8a65d1SGreg Roach
251fe8a65d1SGreg Roach        if (!Auth::isManager($tree)) {
252d501c45dSGreg Roach            throw new HttpAccessDeniedException();
253fe8a65d1SGreg Roach        }
254fe8a65d1SGreg Roach
255cef665d9SGreg Roach        DB::table('news')
256cef665d9SGreg Roach            ->where('news_id', '=', $news_id)
257cef665d9SGreg Roach            ->where('gedcom_id', '=', $tree->id())
258cef665d9SGreg Roach            ->delete();
259fe8a65d1SGreg Roach
2608e0e1b25SGreg Roach        $url = route(TreePage::class, ['tree' => $tree->name()]);
261fe8a65d1SGreg Roach
2626ccdf4f0SGreg Roach        return redirect($url);
263fe8a65d1SGreg Roach    }
2648c2e8227SGreg Roach}
265