ULTRA [ vsambulanceservice.com ]

Linux vps122157.inmotionhosting.com 4.18.0 #1 SMP Mon Sep 30 15:36:27 MSK 2024 x86_64

Apache/2.4.65 (Unix) OpenSSL/1.1.1k

199.250.210.201 | Your IP: 216.73.216.16

Cant read [ /etc/named.conf ]

[ drwxr-xr-x ]

/ proc / 3 / root / proc / 2 / cwd / usr / local / cwpsrv / var / services / pma / libraries / classes / Controllers /

Home Upload Mass Deface Mass Delete Back Connect Notify

NormalizationController.php

<?php

declare(strict_types=1);

namespace PhpMyAdmin\Controllers;

use PhpMyAdmin\Core;
use PhpMyAdmin\Normalization;
use PhpMyAdmin\Response;
use PhpMyAdmin\Template;
use PhpMyAdmin\Url;
use function intval;
use function json_decode;
use function json_encode;
use function min;

/**
 * Normalization process (temporarily specific to 1NF).
 */
class NormalizationController extends AbstractController
{
    /** @var Normalization */
    private $normalization;

/**
     * @param Response $response
     */
    public function __construct($response, Template $template, Normalization $normalization)
    {
        parent::__construct($response, $template);
        $this->normalization = $normalization;
    }

public function index(): void
    {
        global $db, $table;

if (isset($_POST['getColumns'])) {
            $html = '<option selected disabled>' . __('Select one…') . '</option>'
                . '<option value="no_such_col">' . __('No such column') . '</option>';
            //get column whose datatype falls under string category
            $html .= $this->normalization->getHtmlForColumnsList(
                $db,
                $table,
                _pgettext('string types', 'String')
            );
            echo $html;

return;
        }
        if (isset($_POST['splitColumn'])) {
            $num_fields = min(4096, intval($_POST['numFields']));
            $html = $this->normalization->getHtmlForCreateNewColumn($num_fields, $db, $table);
            $html .= Url::getHiddenInputs($db, $table);
            echo $html;

return;
        }
        if (isset($_POST['addNewPrimary'])) {
            $num_fields = 1;
            $columnMeta = [
                'Field' => $table . '_id',
                'Extra' => 'auto_increment',
            ];
            $html = $this->normalization->getHtmlForCreateNewColumn(
                $num_fields,
                $db,
                $table,
                $columnMeta
            );
            $html .= Url::getHiddenInputs($db, $table);
            echo $html;

return;
        }
        if (isset($_POST['findPdl'])) {
            $html = $this->normalization->findPartialDependencies($table, $db);
            echo $html;

return;
        }

if (isset($_POST['getNewTables2NF'])) {
            $partialDependencies = json_decode($_POST['pd'], true);
            $html = $this->normalization->getHtmlForNewTables2NF($partialDependencies, $table);
            echo $html;

return;
        }

if (isset($_POST['getNewTables3NF'])) {
            $dependencies = json_decode($_POST['pd']);
            $tables = json_decode($_POST['tables'], true);
            $newTables = $this->normalization->getHtmlForNewTables3NF($dependencies, $tables, $db);
            $this->response->disable();
            Core::headerJSON();
            echo json_encode($newTables);

return;
        }

$this->addScriptFiles(['normalization.js', 'vendor/jquery/jquery.uitablefilter.js']);

$normalForm = '1nf';
        if (Core::isValid($_POST['normalizeTo'], ['1nf', '2nf', '3nf'])) {
            $normalForm = $_POST['normalizeTo'];
        }
        if (isset($_POST['createNewTables2NF'])) {
            $partialDependencies = json_decode($_POST['pd'], true);
            $tablesName = json_decode($_POST['newTablesName']);
            $res = $this->normalization->createNewTablesFor2NF($partialDependencies, $tablesName, $table, $db);
            $this->response->addJSON($res);

return;
        }
        if (isset($_POST['createNewTables3NF'])) {
            $newtables = json_decode($_POST['newTables'], true);
            $res = $this->normalization->createNewTablesFor3NF($newtables, $db);
            $this->response->addJSON($res);

return;
        }
        if (isset($_POST['repeatingColumns'])) {
            $repeatingColumns = $_POST['repeatingColumns'];
            $newTable = $_POST['newTable'];
            $newColumn = $_POST['newColumn'];
            $primary_columns = $_POST['primary_columns'];
            $res = $this->normalization->moveRepeatingGroup(
                $repeatingColumns,
                $primary_columns,
                $newTable,
                $newColumn,
                $table,
                $db
            );
            $this->response->addJSON($res);

return;
        }
        if (isset($_POST['step1'])) {
            $html = $this->normalization->getHtmlFor1NFStep1($db, $table, $normalForm);
            $this->response->addHTML($html);
        } elseif (isset($_POST['step2'])) {
            $res = $this->normalization->getHtmlContentsFor1NFStep2($db, $table);
            $this->response->addJSON($res);
        } elseif (isset($_POST['step3'])) {
            $res = $this->normalization->getHtmlContentsFor1NFStep3($db, $table);
            $this->response->addJSON($res);
        } elseif (isset($_POST['step4'])) {
            $res = $this->normalization->getHtmlContentsFor1NFStep4($db, $table);
            $this->response->addJSON($res);
        } elseif (isset($_POST['step']) && $_POST['step'] == '2.1') {
            $res = $this->normalization->getHtmlFor2NFstep1($db, $table);
            $this->response->addJSON($res);
        } elseif (isset($_POST['step']) && $_POST['step'] == '3.1') {
            $tables = $_POST['tables'];
            $res = $this->normalization->getHtmlFor3NFstep1($db, $tables);
            $this->response->addJSON($res);
        } else {
            $this->response->addHTML($this->normalization->getHtmlForNormalizeTable());
        }
    }
}

Name	Type	Size	Owner/Group	Permission	Last Modified	Actions
.	dir	-	cwpsvc/cwpsvc	drwxr-xr-x	2021-06-04 07:16:14
..	dir	-	cwpsvc/cwpsvc	drwxr-xr-x	2021-06-04 07:16:14
Database	dir	-	cwpsvc/cwpsvc	drwxr-xr-x	2021-06-04 07:16:10
Preferences	dir	-	cwpsvc/cwpsvc	drwxr-xr-x	2021-06-04 07:16:12
Server	dir	-	cwpsvc/cwpsvc	drwxr-xr-x	2021-06-04 07:16:12
Setup	dir	-	cwpsvc/cwpsvc	drwxr-xr-x	2021-06-04 07:16:12
Table	dir	-	cwpsvc/cwpsvc	drwxr-xr-x	2021-06-04 07:16:14
AbstractController.php	text/x-php	2.34 KB	cwpsvc/cwpsvc	-rw-r--r--	2021-06-04 07:16:08
BrowseForeignersController.php	text/x-php	2.27 KB	cwpsvc/cwpsvc	-rw-r--r--	2021-06-04 07:16:08
ChangeLogController.php	text/x-php	3.52 KB	cwpsvc/cwpsvc	-rw-r--r--	2021-06-04 07:16:08
CheckRelationsController.php	text/x-php	1.48 KB	cwpsvc/cwpsvc	-rw-r--r--	2021-06-04 07:16:08
ColumnController.php	text/x-php	908 B	cwpsvc/cwpsvc	-rw-r--r--	2021-06-04 07:16:08
ConfigController.php	text/x-php	1.34 KB	cwpsvc/cwpsvc	-rw-r--r--	2021-06-04 07:16:08
DatabaseController.php	text/x-php	270 B	cwpsvc/cwpsvc	-rw-r--r--	2021-06-04 07:16:10
ErrorReportController.php	text/x-php	5.89 KB	cwpsvc/cwpsvc	-rw-r--r--	2021-06-04 07:16:10
ExportController.php	text/x-php	23.5 KB	cwpsvc/cwpsvc	-rw-r--r--	2021-06-04 07:16:10
ExportTemplateController.php	text/x-php	4.11 KB	cwpsvc/cwpsvc	-rw-r--r--	2021-06-04 07:16:10
GisDataEditorController.php	text/x-php	4.79 KB	cwpsvc/cwpsvc	-rw-r--r--	2021-06-04 07:16:10
HomeController.php	text/x-php	17.82 KB	cwpsvc/cwpsvc	-rw-r--r--	2021-06-04 07:16:10
ImportController.php	text/x-php	31.77 KB	cwpsvc/cwpsvc	-rw-r--r--	2021-06-04 07:16:10
ImportStatusController.php	text/x-php	2.26 KB	cwpsvc/cwpsvc	-rw-r--r--	2021-06-04 07:16:10
JavaScriptMessagesController.php	text/x-php	36.53 KB	cwpsvc/cwpsvc	-rw-r--r--	2021-06-04 07:16:10
LicenseController.php	text/x-php	968 B	cwpsvc/cwpsvc	-rw-r--r--	2021-06-04 07:16:10
LintController.php	text/x-php	1.73 KB	cwpsvc/cwpsvc	-rw-r--r--	2021-06-04 07:16:10
LogoutController.php	text/x-php	407 B	cwpsvc/cwpsvc	-rw-r--r--	2021-06-04 07:16:10
NavigationController.php	text/x-php	3.26 KB	cwpsvc/cwpsvc	-rw-r--r--	2021-06-04 07:16:10
NormalizationController.php	text/x-php	5.54 KB	cwpsvc/cwpsvc	-rw-r--r--	2021-06-04 07:16:10
PhpInfoController.php	text/x-php	681 B	cwpsvc/cwpsvc	-rw-r--r--	2021-06-04 07:16:10
SchemaExportController.php	text/x-php	1.1 KB	cwpsvc/cwpsvc	-rw-r--r--	2021-06-04 07:16:12
SqlController.php	text/x-php	11.29 KB	cwpsvc/cwpsvc	-rw-r--r--	2021-06-04 07:16:12
TableController.php	text/x-php	867 B	cwpsvc/cwpsvc	-rw-r--r--	2021-06-04 07:16:14
ThemesController.php	text/x-php	776 B	cwpsvc/cwpsvc	-rw-r--r--	2021-06-04 07:16:14
TransformationOverviewController.php	text/x-php	1.75 KB	cwpsvc/cwpsvc	-rw-r--r--	2021-06-04 07:16:14
TransformationWrapperController.php	text/x-php	7.3 KB	cwpsvc/cwpsvc	-rw-r--r--	2021-06-04 07:16:14
UserPasswordController.php	text/x-php	3.29 KB	cwpsvc/cwpsvc	-rw-r--r--	2021-06-04 07:16:14
VersionCheckController.php	text/x-php	1.21 KB	cwpsvc/cwpsvc	-rw-r--r--	2021-06-04 07:16:14
ViewCreateController.php	text/x-php	9.4 KB	cwpsvc/cwpsvc	-rw-r--r--	2021-06-04 07:16:14
ViewOperationsController.php	text/x-php	3.26 KB	cwpsvc/cwpsvc	-rw-r--r--	2021-06-04 07:16:14