1<?php 2 3/** 4 * webtrees: online genealogy 5 * Copyright (C) 2022 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\FlashMessages; 23use Fisharebest\Webtrees\I18N; 24use Fisharebest\Webtrees\Validator; 25use Illuminate\Database\Capsule\Manager as DB; 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