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