xref: /webtrees/app/Http/RequestHandlers/PendingChangesLogDownload.php (revision 9b152ff9230017d2c03aa1bf603a98b18250446d) 
1<?php
2
3/**
4 * webtrees: online genealogy
5 * Copyright (C) 2019 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 <http://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    /** @var PendingChangesService */
39    private $pending_changes_service;
40
41    /**
42     * @param PendingChangesService $pending_changes_service
43     */
44    public function __construct(PendingChangesService $pending_changes_service)
45    {
46        $this->pending_changes_service = $pending_changes_service;
47    }
48
49    /**
50     * @param ServerRequestInterface $request
51     *
52     * @return ResponseInterface
53     */
54    public function handle(ServerRequestInterface $request): ResponseInterface
55    {
56        $tree = $request->getAttribute('tree');
57        assert($tree instanceof Tree);
58
59        $params = $request->getQueryParams();
60        $params['tree'] = $tree->name();
61
62        $content = $this->pending_changes_service->changesQuery($params)
63            ->get()
64            ->map(static function (stdClass $row): string {
65                // Convert to CSV
66                return implode(',', [
67                    '"' . $row->change_time . '"',
68                    '"' . $row->status . '"',
69                    '"' . $row->xref . '"',
70                    '"' . str_replace('"', '""', $row->old_gedcom) . '"',
71                    '"' . str_replace('"', '""', $row->new_gedcom) . '"',
72                    '"' . str_replace('"', '""', $row->user_name) . '"',
73                    '"' . str_replace('"', '""', $row->gedcom_name) . '"',
74                ]);
75            })
76            ->implode("\n");
77
78        return response($content, StatusCodeInterface::STATUS_OK, [
79            'Content-Type'        => 'text/csv; charset=utf-8',
80            'Content-Disposition' => 'attachment; filename="changes.csv"',
81        ]);
82    }
83}
84