Elep

<?php

declare(strict_types=1);

namespace PhpMyAdmin\Controllers\Database\Structure;

use PhpMyAdmin\ConfigStorage\RelationCleanup;
use PhpMyAdmin\Controllers\AbstractController;
use PhpMyAdmin\Controllers\Database\StructureController;
use PhpMyAdmin\Current;
use PhpMyAdmin\DatabaseInterface;
use PhpMyAdmin\Http\ServerRequest;
use PhpMyAdmin\Message;
use PhpMyAdmin\ResponseRenderer;
use PhpMyAdmin\Template;
use PhpMyAdmin\Util;
use PhpMyAdmin\Utils\ForeignKey;

use function __;

final class DropTableController extends AbstractController
{
    public function __construct(
        ResponseRenderer $response,
        Template $template,
        private DatabaseInterface $dbi,
        private RelationCleanup $relationCleanup,
        private StructureController $structureController,
    ) {
        parent::__construct($response, $template);
    }

public function __invoke(ServerRequest $request): void
    {
        $GLOBALS['reload'] = $_POST['reload'] ?? $GLOBALS['reload'] ?? null;
        $multBtn = $_POST['mult_btn'] ?? '';
        /** @var string[] $selected */
        $selected = $_POST['selected'] ?? [];

if ($multBtn !== __('Yes')) {
            $GLOBALS['message'] = Message::success(__('No change'));

unset($_POST['mult_btn']);

($this->structureController)($request);

return;
        }

$defaultFkCheckValue = ForeignKey::handleDisableCheckInit();
        $GLOBALS['sql_query'] = '';
        $sqlQueryViews = '';

foreach ($selected as $selectedValue) {
            $this->relationCleanup->table(Current::$database, $selectedValue);

if ($this->dbi->getTable(Current::$database, $selectedValue)->isView()) {
                $sqlQueryViews .= ($sqlQueryViews === '' ? 'DROP VIEW ' : ', ') . Util::backquote($selectedValue);
            } else {
                $GLOBALS['sql_query'] .= (empty($GLOBALS['sql_query']) ? 'DROP TABLE ' : ', ')
                    . Util::backquote($selectedValue);
            }

$GLOBALS['reload'] = 1;
        }

if (! empty($GLOBALS['sql_query'])) {
            $GLOBALS['sql_query'] .= ';';
        } elseif ($sqlQueryViews !== '') {
            $GLOBALS['sql_query'] = $sqlQueryViews . ';';
            $sqlQueryViews = '';
        }

// Unset cache values for tables count, issue #14205
        if (isset($_SESSION['tmpval'])) {
            if (isset($_SESSION['tmpval']['table_limit_offset'])) {
                unset($_SESSION['tmpval']['table_limit_offset']);
            }

if (isset($_SESSION['tmpval']['table_limit_offset_db'])) {
                unset($_SESSION['tmpval']['table_limit_offset_db']);
            }
        }

$GLOBALS['message'] = Message::success();

$this->dbi->selectDb(Current::$database);
        $result = $this->dbi->tryQuery($GLOBALS['sql_query']);

if (! $result) {
            $GLOBALS['message'] = Message::error($this->dbi->getError());
        }

if ($result && $sqlQueryViews !== '') {
            $GLOBALS['sql_query'] .= ' ' . $sqlQueryViews . ';';
            $result = $this->dbi->tryQuery($sqlQueryViews);
            unset($sqlQueryViews);
        }

if (! $result) {
            $GLOBALS['message'] = Message::error($this->dbi->getError());
        }

ForeignKey::handleDisableCheckCleanup($defaultFkCheckValue);

unset($_POST['mult_btn']);

($this->structureController)($request);
    }
}