xref: /webtrees/app/Http/RequestHandlers/ModuleDeleteSettings.php (revision 9f667ff2169dfca16c3d1c0ebb87d36da533186b) 
1<?php
2
3/**
4 * webtrees: online genealogy
5 * Copyright (C) 2020 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 Fisharebest\Webtrees\FlashMessages;
23use Fisharebest\Webtrees\I18N;
24use Illuminate\Database\Capsule\Manager as DB;
25use Psr\Http\Message\ResponseInterface;
26use Psr\Http\Message\ServerRequestInterface;
27use Psr\Http\Server\RequestHandlerInterface;
28
29use function redirect;
30use function route;
31
32/**
33 * Delete the database settings for a deleted module.
34 */
35class ModuleDeleteSettings implements RequestHandlerInterface
36{
37    /**
38     * Delete the database settings for a deleted module.
39     *
40     * @param ServerRequestInterface $request
41     *
42     * @return ResponseInterface
43     */
44    public function handle(ServerRequestInterface $request): ResponseInterface
45    {
46        $params = (array) $request->getParsedBody();
47
48        $module_name = $params['module_name'] ?? '';
49
50        DB::table('block_setting')
51            ->join('block', 'block_setting.block_id', '=', 'block.block_id')
52            ->join('module', 'block.module_name', '=', 'module.module_name')
53            ->where('module.module_name', '=', $module_name)
54            ->delete();
55
56        DB::table('block')
57            ->join('module', 'block.module_name', '=', 'module.module_name')
58            ->where('module.module_name', '=', $module_name)
59            ->delete();
60
61        DB::table('module_setting')
62            ->where('module_name', '=', $module_name)
63            ->delete();
64
65        DB::table('module_privacy')
66            ->where('module_name', '=', $module_name)
67            ->delete();
68
69        DB::table('module')
70            ->where('module_name', '=', $module_name)
71            ->delete();
72
73        FlashMessages::addMessage(I18N::translate('The preferences for the module “%s” have been deleted.', $module_name), 'success');
74
75        return redirect(route('modules'));
76    }
77}
78