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); } } }