phpmyadmin working

1 files changed, 254 insertions, 0 deletions

diff --git a/srcs/phpmyadmin/libraries/classes/Plugins/Schema/Eps/EpsRelationSchema.php b/srcs/phpmyadmin/libraries/classes/Plugins/Schema/Eps/EpsRelationSchema.php
new file mode 100644
index 0000000..238af1b
--- /dev/null
+++ b/srcs/phpmyadmin/libraries/classes/Plugins/Schema/Eps/EpsRelationSchema.php
@@ -0,0 +1,254 @@
+<?php
+/* vim: set expandtab sw=4 ts=4 sts=4: */
+/**
+ * Classes to create relation schema in EPS format.
+ *
+ * @package PhpMyAdmin
+ */
+declare(strict_types=1);
+
+namespace PhpMyAdmin\Plugins\Schema\Eps;
+
+use PhpMyAdmin\Plugins\Schema\Dia\RelationStatsDia;
+use PhpMyAdmin\Plugins\Schema\Dia\TableStatsDia;
+use PhpMyAdmin\Plugins\Schema\ExportRelationSchema;
+use PhpMyAdmin\Plugins\Schema\Pdf\TableStatsPdf;
+use PhpMyAdmin\Plugins\Schema\Svg\TableStatsSvg;
+use PhpMyAdmin\Relation;
+
+/**
+ * EPS Relation Schema Class
+ *
+ * Purpose of this class is to generate the EPS Document
+ * which is used for representing the database diagrams.
+ * This class uses post script commands and with
+ * the combination of these commands actually helps in preparing EPS Document.
+ *
+ * This class inherits ExportRelationSchema class has common functionality added
+ * to this class
+ *
+ * @package PhpMyAdmin
+ * @name    Eps_Relation_Schema
+ */
+class EpsRelationSchema extends ExportRelationSchema
+{
+    /**
+     * @var TableStatsDia[]|TableStatsEps[]|TableStatsPdf[]|TableStatsSvg[]
+     */
+    private $_tables = [];
+
+    /** @var RelationStatsEps[] Relations */
+    private $_relations = [];
+
+    private $_tablewidth;
+
+    /**
+     * The "PMA_EPS_Relation_Schema" constructor
+     *
+     * Upon instantiation This starts writing the EPS document
+     * user will be prompted for download as .eps extension
+     *
+     * @param string $db database name
+     *
+     * @see PMA_EPS
+     */
+    public function __construct($db)
+    {
+        parent::__construct($db, new Eps());
+
+        $this->setShowColor(isset($_REQUEST['eps_show_color']));
+        $this->setShowKeys(isset($_REQUEST['eps_show_keys']));
+        $this->setTableDimension(isset($_REQUEST['eps_show_table_dimension']));
+        $this->setAllTablesSameWidth(isset($_REQUEST['eps_all_tables_same_width']));
+        $this->setOrientation($_REQUEST['eps_orientation']);
+
+        $this->diagram->setTitle(
+            sprintf(
+                __('Schema of the %s database - Page %s'),
+                $this->db,
+                $this->pageNumber
+            )
+        );
+        $this->diagram->setAuthor('phpMyAdmin ' . PMA_VERSION);
+        $this->diagram->setDate(date("j F Y, g:i a"));
+        $this->diagram->setOrientation($this->orientation);
+        $this->diagram->setFont('Verdana', '10');
+
+        $alltables = $this->getTablesFromRequest();
+
+        foreach ($alltables as $table) {
+            if (! isset($this->_tables[$table])) {
+                $this->_tables[$table] = new TableStatsEps(
+                    $this->diagram,
+                    $this->db,
+                    $table,
+                    $this->diagram->getFont(),
+                    $this->diagram->getFontSize(),
+                    $this->pageNumber,
+                    $this->_tablewidth,
+                    $this->showKeys,
+                    $this->tableDimension,
+                    $this->offline
+                );
+            }
+
+            if ($this->sameWide) {
+                $this->_tables[$table]->width = $this->_tablewidth;
+            }
+        }
+
+        $seen_a_relation = false;
+        foreach ($alltables as $one_table) {
+            $exist_rel = $this->relation->getForeigners($this->db, $one_table, '', 'both');
+            if (! $exist_rel) {
+                continue;
+            }
+
+            $seen_a_relation = true;
+            foreach ($exist_rel as $master_field => $rel) {
+                /* put the foreign table on the schema only if selected
+                * by the user
+                * (do not use array_search() because we would have to
+                * to do a === false and this is not PHP3 compatible)
+                */
+                if ($master_field != 'foreign_keys_data') {
+                    if (in_array($rel['foreign_table'], $alltables)) {
+                        $this->_addRelation(
+                            $one_table,
+                            $this->diagram->getFont(),
+                            $this->diagram->getFontSize(),
+                            $master_field,
+                            $rel['foreign_table'],
+                            $rel['foreign_field'],
+                            $this->tableDimension
+                        );
+                    }
+                    continue;
+                }
+
+                foreach ($rel as $one_key) {
+                    if (! in_array($one_key['ref_table_name'], $alltables)) {
+                        continue;
+                    }
+
+                    foreach ($one_key['index_list'] as $index => $one_field) {
+                        $this->_addRelation(
+                            $one_table,
+                            $this->diagram->getFont(),
+                            $this->diagram->getFontSize(),
+                            $one_field,
+                            $one_key['ref_table_name'],
+                            $one_key['ref_index_list'][$index],
+                            $this->tableDimension
+                        );
+                    }
+                }
+            }
+        }
+        if ($seen_a_relation) {
+            $this->_drawRelations();
+        }
+
+        $this->_drawTables();
+        $this->diagram->endEpsDoc();
+    }
+
+    /**
+     * Output Eps Document for download
+     *
+     * @return void
+     */
+    public function showOutput()
+    {
+        $this->diagram->showOutput($this->getFileName('.eps'));
+    }
+
+    /**
+     * Defines relation objects
+     *
+     * @param string  $masterTable    The master table name
+     * @param string  $font           The font
+     * @param int     $fontSize       The font size
+     * @param string  $masterField    The relation field in the master table
+     * @param string  $foreignTable   The foreign table name
+     * @param string  $foreignField   The relation field in the foreign table
+     * @param boolean $tableDimension Whether to display table position or not
+     *
+     * @return void
+     *
+     * @see _setMinMax,Table_Stats_Eps::__construct(),
+     * PhpMyAdmin\Plugins\Schema\Eps\RelationStatsEps::__construct()
+     */
+    private function _addRelation(
+        $masterTable,
+        $font,
+        $fontSize,
+        $masterField,
+        $foreignTable,
+        $foreignField,
+        $tableDimension
+    ) {
+        if (! isset($this->_tables[$masterTable])) {
+            $this->_tables[$masterTable] = new TableStatsEps(
+                $this->diagram,
+                $this->db,
+                $masterTable,
+                $font,
+                $fontSize,
+                $this->pageNumber,
+                $this->_tablewidth,
+                false,
+                $tableDimension
+            );
+        }
+        if (! isset($this->_tables[$foreignTable])) {
+            $this->_tables[$foreignTable] = new TableStatsEps(
+                $this->diagram,
+                $this->db,
+                $foreignTable,
+                $font,
+                $fontSize,
+                $this->pageNumber,
+                $this->_tablewidth,
+                false,
+                $tableDimension
+            );
+        }
+        $this->_relations[] = new RelationStatsEps(
+            $this->diagram,
+            $this->_tables[$masterTable],
+            $masterField,
+            $this->_tables[$foreignTable],
+            $foreignField
+        );
+    }
+
+    /**
+     * Draws relation arrows and lines connects master table's master field to
+     * foreign table's foreign field
+     *
+     * @return void
+     *
+     * @see Relation_Stats_Eps::relationDraw()
+     */
+    private function _drawRelations()
+    {
+        foreach ($this->_relations as $relation) {
+            $relation->relationDraw();
+        }
+    }
+
+    /**
+     * Draws tables
+     *
+     * @return void
+     *
+     * @see Table_Stats_Eps::Table_Stats_tableDraw()
+     */
+    private function _drawTables()
+    {
+        foreach ($this->_tables as $table) {
+            $table->tableDraw($this->showColor);
+        }
+    }
+}