xref: /webtrees/app/Http/RequestHandlers/PendingChangesLogDownload.php (revision ac701fbd36864ec7630310142b9b16f78934a505) 
1<?php
2
3/**
4 * webtrees: online genealogy
5 * Copyright (C) 2021 webtrees development team
6 * This program is free software: you can redistribute it and/or modify
7 * it under the terms of the GNU General Public License as published by
8 * the Free Software Foundation, either version 3 of the License, or
9 * (at your option) any later version.
10 * This program is distributed in the hope that it will be useful,
11 * but WITHOUT ANY WARRANTY; without even the implied warranty of
12 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
13 * GNU General Public License for more details.
14 * You should have received a copy of the GNU General Public License
15 * along with this program. If not, see <https://www.gnu.org/licenses/>.
16 */
17
18declare(strict_types=1);
19
20namespace Fisharebest\Webtrees\Http\RequestHandlers;
21
22use Fig\Http\Message\StatusCodeInterface;
23use Fisharebest\Webtrees\Services\PendingChangesService;
24use Fisharebest\Webtrees\Tree;
25use Psr\Http\Message\ResponseInterface;
26use Psr\Http\Message\ServerRequestInterface;
27use Psr\Http\Server\RequestHandlerInterface;
28use stdClass;
29
30use function assert;
31use function response;
32
33/**
34 * Download pending changes.
35 */
36class PendingChangesLogDownload implements RequestHandlerInterface
37{
38    private PendingChangesService $pending_changes_service;
39
40    /**
41     * @param PendingChangesService $pending_changes_service
42     */
43    public function __construct(PendingChangesService $pending_changes_service)
44    {
45        $this->pending_changes_service = $pending_changes_service;
46    }
47
48    /**
49     * @param ServerRequestInterface $request
50     *
51     * @return ResponseInterface
52     */
53    public function handle(ServerRequestInterface $request): ResponseInterface
54    {
55        $tree = $request->getAttribute('tree');
56        assert($tree instanceof Tree);
57
58        $params         = $request->getQueryParams();
59        $params['tree'] = $tree->name();
60
61        $content = $this->pending_changes_service->changesQuery($params)
62            ->get()
63            ->map(static function (stdClass $row): string {
64                // Convert to CSV
65                return implode(',', [
66                    '"' . $row->change_time . '"',
67                    '"' . $row->status . '"',
68                    '"' . $row->xref . '"',
69                    '"' . str_replace('"', '""', $row->old_gedcom) . '"',
70                    '"' . str_replace('"', '""', $row->new_gedcom) . '"',
71                    '"' . str_replace('"', '""', $row->user_name) . '"',
72                    '"' . str_replace('"', '""', $row->gedcom_name) . '"',
73                ]);
74            })
75            ->implode("\n");
76
77        return response($content, StatusCodeInterface::STATUS_OK, [
78            'Content-Type'        => 'text/csv; charset=UTF-8',
79            'Content-Disposition' => 'attachment; filename="changes.csv"',
80        ]);
81    }
82}
83