phpmyadmin/libraries/schema/Svg_Relation_Schema.class.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  *
   5  * @package PhpMyAdmin
   6  */
   7 if (! defined('PHPMYADMIN')) {
   8     exit;
   9 }
  10
  11 require_once 'Export_Relation_Schema.class.php';
  12
  13 /**
  14  * This Class inherits the XMLwriter class and
  15  * helps in developing structure of SVG Schema Export
  16  *
  17  * @access public
  18  * @see http://php.net/manual/en/book.xmlwriter.php
  19  */
  20 class PMA_SVG extends XMLWriter
  21 {
  22     public $title;
  23     public $author;
  24     public $font;
  25     public $fontSize;
  26
  27     /**
  28      * The "PMA_SVG" constructor
  29      *
  30      * Upon instantiation This starts writing the Svg XML document
  31      *
  32      * @return void
  33      * @see XMLWriter::openMemory(),XMLWriter::setIndent(),XMLWriter::startDocument()
  34      */
  35     function __construct()
  36     {
  37         $this->openMemory();
  38         /*
  39          * Set indenting using three spaces,
  40          * so output is formatted
  41          */
  42
  43         $this->setIndent(true);
  44         $this->setIndentString('   ');
  45         /*
  46          * Create the XML document
  47          */
  48
  49         $this->startDocument('1.0', 'UTF-8');
  50         $this->startDtd(
  51             'svg', '-//W3C//DTD SVG 1.1//EN',
  52             'http://www.w3.org/Graphics/SVG/1.1/DTD/svg11.dtd'
  53         );
  54         $this->endDtd();
  55     }
  56
  57     /**
  58      * Set document title
  59      *
  60      * @param string $value sets the title text
  61      *
  62      * @return void
  63      * @access public
  64      */
  65     function setTitle($value)
  66     {
  67         $this->title = $value;
  68     }
  69
  70     /**
  71      * Set document author
  72      *
  73      * @param string $value sets the author
  74      *
  75      * @return void
  76      * @access public
  77      */
  78     function setAuthor($value)
  79     {
  80         $this->author = $value;
  81     }
  82
  83     /**
  84      * Set document font
  85      *
  86      * @param string $value sets the font e.g Arial, Sans-serif etc
  87      *
  88      * @return void
  89      * @access public
  90      */
  91     function setFont($value)
  92     {
  93         $this->font = $value;
  94     }
  95
  96     /**
  97      * Get document font
  98      *
  99      * @return string returns the font name
 100      * @access public
 101      */
 102     function getFont()
 103     {
 104         return $this->font;
 105     }
 106
 107     /**
 108      * Set document font size
 109      *
 110      * @param string $value sets the font size in pixels
 111      *
 112      * @return void
 113      * @access public
 114      */
 115     function setFontSize($value)
 116     {
 117         $this->fontSize = $value;
 118     }
 119
 120     /**
 121      * Get document font size
 122      *
 123      * @return string returns the font size
 124      * @access public
 125      */
 126     function getFontSize()
 127     {
 128         return $this->fontSize;
 129     }
 130
 131     /**
 132      * Starts Svg Document
 133      *
 134      * svg document starts by first initializing svg tag
 135      * which contains all the attributes and namespace that needed
 136      * to define the svg document
 137      *
 138      * @param integer $width  total width of the Svg document
 139      * @param integer $height total height of the Svg document
 140      *
 141      * @return void
 142      * @access public
 143      *
 144      * @see XMLWriter::startElement(),XMLWriter::writeAttribute()
 145      */
 146     function startSvgDoc($width,$height)
 147     {
 148         $this->startElement('svg');
 149         $this->writeAttribute('width', $width);
 150         $this->writeAttribute('height', $height);
 151         $this->writeAttribute('xmlns', 'http://www.w3.org/2000/svg');
 152         $this->writeAttribute('version', '1.1');
 153     }
 154
 155     /**
 156      * Ends Svg Document
 157      *
 158      * @return void
 159      * @access public
 160      * @see XMLWriter::endElement(),XMLWriter::endDocument()
 161      */
 162     function endSvgDoc()
 163     {
 164         $this->endElement();
 165         $this->endDocument();
 166     }
 167
 168     /**
 169      * output Svg Document
 170      *
 171      * svg document prompted to the user for download
 172      * Svg document saved in .svg extension and can be
 173      * easily changeable by using any svg IDE
 174      *
 175      * @param string $fileName file name
 176      *
 177      * @return void
 178      * @access public
 179      * @see XMLWriter::startElement(),XMLWriter::writeAttribute()
 180      */
 181     function showOutput($fileName)
 182     {
 183         //ob_get_clean();
 184         $output = $this->flush();
 185         PMA_Response::getInstance()->disable();
 186         PMA_downloadHeader($fileName . '.svg', 'image/svg+xml', strlen($output));
 187         print $output;
 188     }
 189
 190     /**
 191      * Draws Svg elements
 192      *
 193      * SVG has some predefined shape elements like rectangle & text
 194      * and other elements who have x,y co-ordinates are drawn.
 195      * specify their width and height and can give styles too.
 196      *
 197      * @param string  $name   Svg element name
 198      * @param integer $x      The x attr defines the left position of the element
 199      * (e.g. x="0" places the element 0 pixels from the left of the browser window)
 200      * @param integer $y      The y attribute defines the top position of the element
 201      * (e.g. y="0" places the element 0 pixels from the top of the browser window)
 202      * @param integer $width  The width attribute defines the width the element
 203      * @param integer $height The height attribute defines the height the element
 204      * @param string  $text   The text attribute defines the text the element
 205      * @param string  $styles The style attribute defines the style the element
 206      *  styles can be defined like CSS styles
 207      *
 208      * @return void
 209      * @access public
 210      *
 211      * @see XMLWriter::startElement(), XMLWriter::writeAttribute(),
 212      * XMLWriter::text(), XMLWriter::endElement()
 213      */
 214     function printElement($name, $x, $y, $width = '', $height = '', $text = '', $styles = '')
 215     {
 216         $this->startElement($name);
 217         $this->writeAttribute('width', $width);
 218         $this->writeAttribute('height', $height);
 219         $this->writeAttribute('x', $x);
 220         $this->writeAttribute('y', $y);
 221         $this->writeAttribute('style', $styles);
 222         if (isset($text)) {
 223             $this->writeAttribute('font-family', $this->font);
 224             $this->writeAttribute('font-size', $this->fontSize);
 225             $this->text($text);
 226         }
 227         $this->endElement();
 228     }
 229
 230     /**
 231      * Draws Svg Line element
 232      *
 233      * Svg line element is drawn for connecting the tables.
 234      * arrows are also drawn by specify its start and ending
 235      * co-ordinates
 236      *
 237      * @param string  $name   Svg element name i.e line
 238      * @param integer $x1     Defines the start of the line on the x-axis
 239      * @param integer $y1     Defines the start of the line on the y-axis
 240      * @param integer $x2     Defines the end of the line on the x-axis
 241      * @param integer $y2     Defines the end of the line on the y-axis
 242      * @param string  $styles The style attribute defines the style the element
 243      *                        styles can be defined like CSS styles
 244      *
 245      * @return void
 246      * @access public
 247      *
 248      * @see XMLWriter::startElement(), XMLWriter::writeAttribute(),
 249      * XMLWriter::endElement()
 250      */
 251     function printElementLine($name,$x1,$y1,$x2,$y2,$styles)
 252     {
 253         $this->startElement($name);
 254         $this->writeAttribute('x1', $x1);
 255         $this->writeAttribute('y1', $y1);
 256         $this->writeAttribute('x2', $x2);
 257         $this->writeAttribute('y2', $y2);
 258         $this->writeAttribute('style', $styles);
 259         $this->endElement();
 260     }
 261
 262     /**
 263      * get width of string/text
 264      *
 265      * Svg text element width is calcualted depending on font name
 266      * and font size. It is very important to know the width of text
 267      * because rectangle is drawn around it.
 268      *
 269      * This is a bit hardcore method. I didn't found any other than this.
 270      *
 271      * @param string  $text     string that width will be calculated
 272      * @param integer $font     name of the font like Arial,sans-serif etc
 273      * @param integer $fontSize size of font
 274      *
 275      * @return integer width of the text
 276      * @access public
 277      */
 278     function getStringWidth($text,$font,$fontSize)
 279     {
 280         /*
 281          * Start by counting the width, giving each character a modifying value
 282          */
 283         $count = 0;
 284         $count = $count + ((strlen($text) - strlen(str_replace(array("i", "j", "l"), "", $text))) * 0.23);//ijl
 285         $count = $count + ((strlen($text) - strlen(str_replace(array("f"), "", $text))) * 0.27);//f
 286         $count = $count + ((strlen($text) - strlen(str_replace(array("t", "I"), "", $text))) * 0.28);//tI
 287         $count = $count + ((strlen($text) - strlen(str_replace(array("r"), "", $text))) * 0.34);//r
 288         $count = $count + ((strlen($text) - strlen(str_replace(array("1"), "", $text))) * 0.49);//1
 289         $count = $count + ((strlen($text) - strlen(str_replace(array("c", "k", "s", "v", "x", "y", "z", "J"), "", $text))) * 0.5);//cksvxyzJ
 290         $count = $count + ((strlen($text) - strlen(str_replace(array("a", "b", "d", "e", "g", "h", "n", "o", "p", "q", "u", "L", "0", "2", "3", "4", "5", "6", "7", "8", "9"), "", $text))) * 0.56);//abdeghnopquL023456789
 291         $count = $count + ((strlen($text) - strlen(str_replace(array("F", "T", "Z"), "", $text))) * 0.61);//FTZ
 292         $count = $count + ((strlen($text) - strlen(str_replace(array("A", "B", "E", "K", "P", "S", "V", "X", "Y"), "", $text))) * 0.67);//ABEKPSVXY
 293         $count = $count + ((strlen($text) - strlen(str_replace(array("w", "C", "D", "H", "N", "R", "U"), "", $text))) * 0.73);//wCDHNRU
 294         $count = $count + ((strlen($text) - strlen(str_replace(array("G", "O", "Q"), "", $text))) * 0.78);//GOQ
 295         $count = $count + ((strlen($text) - strlen(str_replace(array("m", "M"), "", $text))) * 0.84);//mM
 296         $count = $count + ((strlen($text) - strlen(str_replace("W", "", $text))) * .95);//W
 297         $count = $count + ((strlen($text) - strlen(str_replace(" ", "", $text))) * .28);//" "
 298         $text  = str_replace(" ", "", $text);//remove the " "'s
 299         $count = $count + (strlen(preg_replace("/[a-z0-9]/i", "", $text)) * 0.3); //all other chrs
 300
 301         $modifier = 1;
 302         $font = strtolower($font);
 303         switch ($font) {
 304         /*
 305          * no modifier for arial and sans-serif
 306          */
 307         case 'arial':
 308         case 'sans-serif':
 309             break;
 310         /*
 311          * .92 modifer for time, serif, brushscriptstd, and californian fb
 312          */
 313         case 'times':
 314         case 'serif':
 315         case 'brushscriptstd':
 316         case 'californian fb':
 317             $modifier = .92;
 318             break;
 319         /*
 320          * 1.23 modifier for broadway
 321          */
 322         case 'broadway':
 323             $modifier = 1.23;
 324             break;
 325         }
 326         $textWidth = $count*$fontSize;
 327         return ceil($textWidth*$modifier);
 328     }
 329 }
 330
 331 /**
 332  * Table preferences/statistics
 333  *
 334  * This class preserves the table co-ordinates,fields
 335  * and helps in drawing/generating the Tables in SVG XML document.
 336  *
 337  * @name Table_Stats
 338  * @see PMA_SVG
 339  */
 340 class Table_Stats
 341 {
 342     /**
 343      * Defines properties
 344      */
 345
 346     private $_tableName;
 347     private $_showInfo = false;
 348
 349     public $width = 0;
 350     public $height;
 351     public $fields = array();
 352     public $heightCell = 0;
 353     public $currentCell = 0;
 354     public $x, $y;
 355     public $primary = array();
 356
 357     /**
 358      * The "Table_Stats" constructor
 359      *
 360      * @param string  $tableName        The table name
 361      * @param string  $font             Font face
 362      * @param integer $fontSize         The font size
 363      * @param integer $pageNumber       Page number
 364      * @param integer &$same_wide_width The max. with among tables
 365      * @param boolean $showKeys         Whether to display keys or not
 366      * @param boolean $showInfo         Whether to display table position or not
 367      *
 368      * @global object    The current SVG image document
 369      * @global integer   The current page number (from the
 370      *                   $cfg['Servers'][$i]['table_coords'] table)
 371      * @global array     The relations settings
 372      * @global string    The current db name
 373      *
 374      * @access private
 375      *
 376      * @see PMA_SVG, Table_Stats::Table_Stats_setWidth,
 377      *       Table_Stats::Table_Stats_setHeight
 378      */
 379     function __construct(
 380         $tableName, $font, $fontSize, $pageNumber,
 381         &$same_wide_width, $showKeys = false, $showInfo = false
 382     ) {
 383         global $svg, $cfgRelation, $db;
 384
 385         $this->_tableName = $tableName;
 386         $sql = 'DESCRIBE ' . PMA_Util::backquote($tableName);
 387         $result = PMA_DBI_try_query($sql, null, PMA_DBI_QUERY_STORE);
 388         if (! $result || ! PMA_DBI_num_rows($result)) {
 389             $svg->dieSchema(
 390                 $pageNumber,
 391                 "SVG",
 392                 sprintf(__('The %s table doesn\'t exist!'), $tableName)
 393             );
 394         }
 395
 396         /*
 397         * load fields
 398         * check to see if it will load all fields or only the foreign keys
 399         */
 400
 401         if ($showKeys) {
 402             $indexes = PMA_Index::getFromTable($this->_tableName, $db);
 403             $all_columns = array();
 404             foreach ($indexes as $index) {
 405                 $all_columns = array_merge(
 406                     $all_columns,
 407                     array_flip(array_keys($index->getColumns()))
 408                 );
 409             }
 410             $this->fields = array_keys($all_columns);
 411         } else {
 412             while ($row = PMA_DBI_fetch_row($result)) {
 413                 $this->fields[] = $row[0];
 414             }
 415         }
 416
 417         $this->_showInfo = $showInfo;
 418
 419         // height and width
 420         $this->_setHeightTable($fontSize);
 421
 422         // setWidth must me after setHeight, because title
 423         // can include table height which changes table width
 424         $this->_setWidthTable($font, $fontSize);
 425         if ($same_wide_width < $this->width) {
 426             $same_wide_width = $this->width;
 427         }
 428
 429         // x and y
 430         $sql = 'SELECT x, y FROM '
 431          . PMA_Util::backquote($GLOBALS['cfgRelation']['db']) . '.'
 432          . PMA_Util::backquote($cfgRelation['table_coords'])
 433          . ' WHERE db_name = \'' . PMA_Util::sqlAddSlashes($db) . '\''
 434          . ' AND   table_name = \'' . PMA_Util::sqlAddSlashes($tableName) . '\''
 435          . ' AND   pdf_page_number = ' . $pageNumber;
 436         $result = PMA_queryAsControlUser($sql, false, PMA_DBI_QUERY_STORE);
 437
 438         if (!$result || !PMA_DBI_num_rows($result)) {
 439             $svg->dieSchema(
 440                 $pageNumber,
 441                 "SVG",
 442                 sprintf(
 443                     __('Please configure the coordinates for table %s'),
 444                     $tableName
 445                 )
 446             );
 447         }
 448         list($this->x, $this->y) = PMA_DBI_fetch_row($result);
 449         $this->x = (double) $this->x;
 450         $this->y = (double) $this->y;
 451         // displayfield
 452         $this->displayfield = PMA_getDisplayField($db, $tableName);
 453         // index
 454         $result = PMA_DBI_query(
 455             'SHOW INDEX FROM ' . PMA_Util::backquote($tableName) . ';',
 456             null,
 457             PMA_DBI_QUERY_STORE
 458         );
 459         if (PMA_DBI_num_rows($result) > 0) {
 460             while ($row = PMA_DBI_fetch_assoc($result)) {
 461                 if ($row['Key_name'] == 'PRIMARY') {
 462                     $this->primary[] = $row['Column_name'];
 463                 }
 464             }
 465         }
 466     }
 467
 468     /**
 469      * Returns title of the current table,
 470      * title can have the dimensions/co-ordinates of the table
 471      *
 472      * @access private
 473      */
 474     private function _getTitle()
 475     {
 476         return ($this->_showInfo
 477             ? sprintf('%.0f', $this->width) . 'x' . sprintf('%.0f', $this->heightCell)
 478             : ''
 479         ) . ' ' . $this->_tableName;
 480     }
 481
 482     /**
 483      * Sets the width of the table
 484      *
 485      * @param string  $font     The font size
 486      * @param integer $fontSize The font size
 487      *
 488      * @global object    The current SVG image document
 489      *
 490      * @return void
 491      * @access private
 492      *
 493      * @see PMA_SVG
 494      */
 495     private function _setWidthTable($font,$fontSize)
 496     {
 497         global $svg;
 498
 499         foreach ($this->fields as $field) {
 500             $this->width = max(
 501                 $this->width,
 502                 $svg->getStringWidth($field, $font, $fontSize)
 503             );
 504         }
 505         $this->width += $svg->getStringWidth('  ', $font, $fontSize);
 506
 507         /*
 508          * it is unknown what value must be added, because
 509          * table title is affected by the tabe width value
 510          */
 511         while ($this->width < $svg->getStringWidth($this->_getTitle(), $font, $fontSize)) {
 512             $this->width += 7;
 513         }
 514     }
 515
 516     /**
 517      * Sets the height of the table
 518      *
 519      * @param integer $fontSize font size
 520      *
 521      * @return void
 522      * @access private
 523      */
 524     function _setHeightTable($fontSize)
 525     {
 526         $this->heightCell = $fontSize + 4;
 527         $this->height = (count($this->fields) + 1) * $this->heightCell;
 528     }
 529
 530     /**
 531      * draw the table
 532      *
 533      * @param boolean $showColor Whether to display color
 534      *
 535      * @global object The current SVG image document
 536      *
 537      * @access public
 538      * @return void
 539      *
 540      * @see PMA_SVG,PMA_SVG::printElement
 541      */
 542     public function tableDraw($showColor)
 543     {
 544         global $svg;
 545         //echo $this->_tableName.'<br />';
 546         $svg->printElement(
 547             'rect', $this->x, $this->y, $this->width,
 548             $this->heightCell, null, 'fill:red;stroke:black;'
 549         );
 550         $svg->printElement(
 551             'text', $this->x + 5, $this->y+ 14, $this->width, $this->heightCell,
 552             $this->_getTitle(), 'fill:none;stroke:black;'
 553         );
 554         foreach ($this->fields as $field) {
 555             $this->currentCell += $this->heightCell;
 556             $showColor    = 'none';
 557             if ($showColor) {
 558                 if (in_array($field, $this->primary)) {
 559                     $showColor = '#0c0';
 560                 }
 561                 if ($field == $this->displayfield) {
 562                     $showColor = 'none';
 563                 }
 564             }
 565             $svg->printElement(
 566                 'rect', $this->x, $this->y + $this->currentCell, $this->width,
 567                 $this->heightCell, null, 'fill:'.$showColor.';stroke:black;'
 568             );
 569             $svg->printElement(
 570                 'text', $this->x + 5, $this->y + 14 + $this->currentCell,
 571                 $this->width, $this->heightCell, $field, 'fill:none;stroke:black;'
 572             );
 573         }
 574     }
 575 }
 576
 577
 578 /**
 579  * Relation preferences/statistics
 580  *
 581  * This class fetches the table master and foreign fields positions
 582  * and helps in generating the Table references and then connects
 583  * master table's master field to foreign table's foreign key
 584  * in SVG XML document.
 585  *
 586  * @name Relation_Stats
 587  * @see PMA_SVG::printElementLine
 588  */
 589 class Relation_Stats
 590 {
 591     /**
 592      * Defines properties
 593      */
 594     public $xSrc, $ySrc;
 595     public $srcDir ;
 596     public $destDir;
 597     public $xDest, $yDest;
 598     public $wTick = 10;
 599
 600     /**
 601      * The "Relation_Stats" constructor
 602      *
 603      * @param string $master_table  The master table name
 604      * @param string $master_field  The relation field in the master table
 605      * @param string $foreign_table The foreign table name
 606      * @param string $foreign_field The relation field in the foreign table
 607      *
 608      * @return void
 609      *
 610      * @see Relation_Stats::_getXy
 611      */
 612     function __construct($master_table, $master_field, $foreign_table, $foreign_field)
 613     {
 614         $src_pos  = $this->_getXy($master_table, $master_field);
 615         $dest_pos = $this->_getXy($foreign_table, $foreign_field);
 616         /*
 617         * [0] is x-left
 618         * [1] is x-right
 619         * [2] is y
 620         */
 621         $src_left   = $src_pos[0] - $this->wTick;
 622         $src_right  = $src_pos[1] + $this->wTick;
 623         $dest_left  = $dest_pos[0] - $this->wTick;
 624         $dest_right = $dest_pos[1] + $this->wTick;
 625
 626         $d1 = abs($src_left - $dest_left);
 627         $d2 = abs($src_right - $dest_left);
 628         $d3 = abs($src_left - $dest_right);
 629         $d4 = abs($src_right - $dest_right);
 630         $d  = min($d1, $d2, $d3, $d4);
 631
 632         if ($d == $d1) {
 633             $this->xSrc    = $src_pos[0];
 634             $this->srcDir  = -1;
 635             $this->xDest   = $dest_pos[0];
 636             $this->destDir = -1;
 637         } elseif ($d == $d2) {
 638             $this->xSrc    = $src_pos[1];
 639             $this->srcDir  = 1;
 640             $this->xDest   = $dest_pos[0];
 641             $this->destDir = -1;
 642         } elseif ($d == $d3) {
 643             $this->xSrc    = $src_pos[0];
 644             $this->srcDir  = -1;
 645             $this->xDest   = $dest_pos[1];
 646             $this->destDir = 1;
 647         } else {
 648             $this->xSrc    = $src_pos[1];
 649             $this->srcDir  = 1;
 650             $this->xDest   = $dest_pos[1];
 651             $this->destDir = 1;
 652         }
 653         $this->ySrc   = $src_pos[2];
 654         $this->yDest = $dest_pos[2];
 655     }
 656
 657     /**
 658      * Gets arrows coordinates
 659      *
 660      * @param string $table  The current table name
 661      * @param string $column The relation column name
 662      *
 663      * @return array Arrows coordinates
 664      * @access private
 665      */
 666     function _getXy($table, $column)
 667     {
 668         $pos = array_search($column, $table->fields);
 669         // x_left, x_right, y
 670         return array(
 671             $table->x,
 672             $table->x + $table->width,
 673             $table->y + ($pos + 1.5) * $table->heightCell
 674         );
 675     }
 676
 677     /**
 678      * draws relation links and arrows shows foreign key relations
 679      *
 680      * @param boolean $changeColor Whether to use one color per relation or not
 681      *
 682      * @global object The current SVG image document
 683      *
 684      * @return void
 685      * @access public
 686      *
 687      * @see PMA_SVG
 688      */
 689     public function relationDraw($changeColor)
 690     {
 691         global $svg;
 692
 693         if ($changeColor) {
 694             $listOfColors = array(
 695                 'red',
 696                 'grey',
 697                 'black',
 698                 'yellow',
 699                 'green',
 700                 'cyan',
 701             '    orange'
 702             );
 703             shuffle($listOfColors);
 704             $color =  $listOfColors[0];
 705         } else {
 706             $color = 'black';
 707         }
 708
 709         $svg->printElementLine(
 710             'line', $this->xSrc, $this->ySrc,
 711             $this->xSrc + $this->srcDir * $this->wTick, $this->ySrc,
 712             'fill:' . $color . ';stroke:black;stroke-width:2;'
 713         );
 714         $svg->printElementLine(
 715             'line', $this->xDest + $this->destDir * $this->wTick,
 716             $this->yDest, $this->xDest, $this->yDest,
 717             'fill:' . $color . ';stroke:black;stroke-width:2;'
 718         );
 719         $svg->printElementLine(
 720             'line', $this->xSrc + $this->srcDir * $this->wTick, $this->ySrc,
 721             $this->xDest + $this->destDir * $this->wTick, $this->yDest,
 722             'fill:' . $color . ';stroke:' . $color . ';stroke-width:1;'
 723         );
 724         $root2 = 2 * sqrt(2);
 725         $svg->printElementLine(
 726             'line', $this->xSrc + $this->srcDir * $this->wTick * 0.75, $this->ySrc,
 727             $this->xSrc + $this->srcDir * (0.75 - 1 / $root2) * $this->wTick,
 728             $this->ySrc + $this->wTick / $root2,
 729             'fill:' . $color . ';stroke:black;stroke-width:2;'
 730         );
 731         $svg->printElementLine(
 732             'line', $this->xSrc + $this->srcDir * $this->wTick * 0.75, $this->ySrc,
 733             $this->xSrc + $this->srcDir * (0.75 - 1 / $root2) * $this->wTick,
 734             $this->ySrc - $this->wTick / $root2,
 735             'fill:' . $color . ';stroke:black;stroke-width:2;'
 736         );
 737         $svg->printElementLine(
 738             'line', $this->xDest + $this->destDir * $this->wTick / 2, $this->yDest,
 739             $this->xDest + $this->destDir * (0.5 + 1 / $root2) * $this->wTick,
 740             $this->yDest + $this->wTick / $root2,
 741             'fill:' . $color . ';stroke:black;stroke-width:2;'
 742         );
 743         $svg->printElementLine(
 744             'line', $this->xDest + $this->destDir * $this->wTick / 2, $this->yDest,
 745             $this->xDest + $this->destDir * (0.5 + 1 / $root2) * $this->wTick,
 746             $this->yDest - $this->wTick / $root2,
 747             'fill:' . $color . ';stroke:black;stroke-width:2;'
 748         );
 749     }
 750 }
 751 /*
 752 * end of the "Relation_Stats" class
 753 */
 754
 755 /**
 756  * Svg Relation Schema Class
 757  *
 758  * Purpose of this class is to generate the SVG XML Document because
 759  * SVG defines the graphics in XML format which is used for representing
 760  * the database diagrams as vector image. This class actually helps
 761  *  in preparing SVG XML format.
 762  *
 763  * SVG XML is generated by using XMLWriter php extension and this class
 764  * inherits Export_Relation_Schema class has common functionality added
 765  * to this class
 766  *
 767  * @name Svg_Relation_Schema
 768  */
 769 class PMA_Svg_Relation_Schema extends PMA_Export_Relation_Schema
 770 {
 771
 772     private $_tables = array();
 773     private $_relations = array();
 774     private $_xMax = 0;
 775     private $_yMax = 0;
 776     private $_xMin = 100000;
 777     private $_yMin = 100000;
 778     private $_tablewidth;
 779
 780     /**
 781      * The "PMA_Svg_Relation_Schema" constructor
 782      *
 783      * Upon instantiation This starts writing the SVG XML document
 784      * user will be prompted for download as .svg extension
 785      *
 786      * @return void
 787      * @see PMA_SVG
 788      */
 789     function __construct()
 790     {
 791         global $svg,$db;
 792
 793         $this->setPageNumber($_POST['pdf_page_number']);
 794         $this->setShowColor(isset($_POST['show_color']));
 795         $this->setShowKeys(isset($_POST['show_keys']));
 796         $this->setTableDimension(isset($_POST['show_table_dimension']));
 797         $this->setAllTablesSameWidth(isset($_POST['all_tables_same_width']));
 798         $this->setExportType($_POST['export_type']);
 799
 800         $svg = new PMA_SVG();
 801         $svg->setTitle(
 802             sprintf(
 803                 __('Schema of the %s database - Page %s'),
 804                 $db,
 805                 $this->pageNumber
 806             )
 807         );
 808         $svg->SetAuthor('phpMyAdmin ' . PMA_VERSION);
 809         $svg->setFont('Arial');
 810         $svg->setFontSize('16px');
 811         $svg->startSvgDoc('1000px', '1000px');
 812         $alltables = $this->getAllTables($db, $this->pageNumber);
 813
 814         foreach ($alltables AS $table) {
 815             if (! isset($this->_tables[$table])) {
 816                 $this->_tables[$table] = new Table_Stats(
 817                     $table, $svg->getFont(), $svg->getFontSize(), $this->pageNumber,
 818                     $this->_tablewidth, $this->showKeys, $this->tableDimension
 819                 );
 820             }
 821
 822             if ($this->sameWide) {
 823                 $this->_tables[$table]->width = $this->_tablewidth;
 824             }
 825             $this->_setMinMax($this->_tables[$table]);
 826         }
 827         $seen_a_relation = false;
 828         foreach ($alltables as $one_table) {
 829             $exist_rel = PMA_getForeigners($db, $one_table, '', 'both');
 830             if ($exist_rel) {
 831                 $seen_a_relation = true;
 832                 foreach ($exist_rel as $master_field => $rel) {
 833                     /* put the foreign table on the schema only if selected
 834                     * by the user
 835                     * (do not use array_search() because we would have to
 836                     * to do a === false and this is not PHP3 compatible)
 837                     */
 838                     if (in_array($rel['foreign_table'], $alltables)) {
 839                         $this->_addRelation(
 840                             $one_table, $svg->getFont(), $svg->getFontSize(),
 841                             $master_field, $rel['foreign_table'],
 842                             $rel['foreign_field'], $this->tableDimension
 843                         );
 844                     }
 845                 }
 846             }
 847         }
 848         if ($seen_a_relation) {
 849             $this->_drawRelations($this->showColor);
 850         }
 851
 852         $this->_drawTables($this->showColor);
 853         $svg->endSvgDoc();
 854         $svg->showOutput($db.'-'.$this->pageNumber);
 855         exit();
 856     }
 857
 858     /**
 859      * Sets X and Y minimum and maximum for a table cell
 860      *
 861      * @param string $table The table name
 862      *
 863      * @return void
 864      * @access private
 865      */
 866     private function _setMinMax($table)
 867     {
 868         $this->_xMax = max($this->_xMax, $table->x + $table->width);
 869         $this->_yMax = max($this->_yMax, $table->y + $table->height);
 870         $this->_xMin = min($this->_xMin, $table->x);
 871         $this->_yMin = min($this->_yMin, $table->y);
 872     }
 873
 874     /**
 875      * Defines relation objects
 876      *
 877      * @param string  $masterTable  The master table name
 878      * @param string  $font         The font face
 879      * @param int     $fontSize     Font size
 880      * @param string  $masterField  The relation field in the master table
 881      * @param string  $foreignTable The foreign table name
 882      * @param string  $foreignField The relation field in the foreign table
 883      * @param boolean $showInfo     Whether to display table position or not
 884      *
 885      * @access private
 886      * @return void
 887      *
 888      * @see _setMinMax,Table_Stats::__construct(),Relation_Stats::__construct()
 889      */
 890     private function _addRelation(
 891         $masterTable,$font,$fontSize, $masterField,
 892         $foreignTable, $foreignField, $showInfo
 893     ) {
 894         if (! isset($this->_tables[$masterTable])) {
 895             $this->_tables[$masterTable] = new Table_Stats(
 896                 $masterTable, $font, $fontSize, $this->pageNumber,
 897                 $this->_tablewidth, false, $showInfo
 898             );
 899             $this->_setMinMax($this->_tables[$masterTable]);
 900         }
 901         if (! isset($this->_tables[$foreignTable])) {
 902             $this->_tables[$foreignTable] = new Table_Stats(
 903                 $foreignTable, $font, $fontSize, $this->pageNumber,
 904                 $this->_tablewidth, false, $showInfo
 905             );
 906             $this->_setMinMax($this->_tables[$foreignTable]);
 907         }
 908         $this->_relations[] = new Relation_Stats(
 909             $this->_tables[$masterTable], $masterField,
 910             $this->_tables[$foreignTable], $foreignField
 911         );
 912     }
 913
 914     /**
 915      * Draws relation arrows and lines
 916      * connects master table's master field to
 917      * foreign table's forein field
 918      *
 919      * @param boolean $changeColor Whether to use one color per relation or not
 920      *
 921      * @return void
 922      * @access private
 923      *
 924      * @see Relation_Stats::relationDraw()
 925      */
 926     private function _drawRelations($changeColor)
 927     {
 928         foreach ($this->_relations as $relation) {
 929             $relation->relationDraw($changeColor);
 930         }
 931     }
 932
 933     /**
 934      * Draws tables
 935      *
 936      * @param boolean $changeColor Whether to show color for primary fields or not
 937      *
 938      * @return void
 939      * @access private
 940      *
 941      * @see Table_Stats::Table_Stats_tableDraw()
 942      */
 943     private function _drawTables($changeColor)
 944     {
 945         foreach ($this->_tables as $table) {
 946             $table->tableDraw($changeColor);
 947         }
 948     }
 949 }
 950 ?>