phpmyadmin/libraries/schema/Export_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 /**
  12  * This class is inherited by all schema classes
  13  * It contains those methods which are common in them
  14  * it works like factory pattern
  15  */
  16 class PMA_Export_Relation_Schema
  17 {
  18     private $_pageTitle;
  19     public $showGrid;
  20     public $showColor;
  21     public $tableDimension;
  22     public $sameWide;
  23     public $withDoc;
  24     public $showKeys;
  25     public $orientation;
  26     public $paper;
  27     public $pageNumber;
  28
  29     /**
  30      * Set Page Number
  31      *
  32      * @param integer $value Page Number of the document to be created
  33      *
  34      * @return void
  35      *
  36      * @access public
  37      */
  38     public function setPageNumber($value)
  39     {
  40         $this->pageNumber = isset($value) ? $value : 1;
  41     }
  42
  43     /**
  44      * Set Show Grid
  45      *
  46      * @param boolean $value show grid of the document or not
  47      *
  48      * @return void
  49      *
  50      * @access public
  51      */
  52     public function setShowGrid($value)
  53     {
  54         $this->showGrid = (isset($value) && $value == 'on') ? 1 : 0;
  55     }
  56
  57     /**
  58      * Sets showColor
  59      *
  60      * @param string $value 'on' to set the the variable
  61      *
  62      * @return void
  63      */
  64     public function setShowColor($value)
  65     {
  66         $this->showColor = (isset($value) && $value == 'on') ? 1 : 0;
  67     }
  68
  69     /**
  70      * Set Table Dimension
  71      *
  72      * @param boolean $value show table co-ordinates or not
  73      *
  74      * @return void
  75      *
  76      * @access public
  77      */
  78     public function setTableDimension($value)
  79     {
  80         $this->tableDimension = (isset($value) && $value == 'on') ? 1 : 0;
  81     }
  82
  83     /**
  84      * Set same width of All Tables
  85      *
  86      * @param boolean $value set same width of all tables or not
  87      *
  88      * @return void
  89      *
  90      * @access public
  91      */
  92     public function setAllTablesSameWidth($value)
  93     {
  94         $this->sameWide = (isset($value) && $value == 'on') ? 1 : 0;
  95     }
  96
  97     /**
  98      * Set Data Dictionary
  99      *
 100      * @param boolean $value show selected database data dictionary or not
 101      *
 102      * @return void
 103      *
 104      * @access public
 105      */
 106     public function setWithDataDictionary($value)
 107     {
 108         $this->withDoc = (isset($value) && $value == 'on') ? 1 : 0;
 109     }
 110
 111     /**
 112      * Set Show only keys
 113      *
 114      * @param boolean $value show only keys or not
 115      *
 116      * @return void
 117      *
 118      * @access public
 119      */
 120     public function setShowKeys($value)
 121     {
 122         $this->showKeys = (isset($value) && $value == 'on') ? 1 : 0;
 123     }
 124
 125     /**
 126      * Set Orientation
 127      *
 128      * @param string $value Orientation will be portrait or landscape
 129      *
 130      * @return void
 131      *
 132      * @access public
 133      */
 134     public function setOrientation($value)
 135     {
 136         $this->orientation = (isset($value) && $value == 'P') ? 'P' : 'L';
 137     }
 138
 139     /**
 140      * Set type of paper
 141      *
 142      * @param string $value paper type can be A4 etc
 143      *
 144      * @return void
 145      *
 146      * @access public
 147      */
 148     public function setPaper($value)
 149     {
 150         $this->paper = isset($value) ? $value : 'A4';
 151     }
 152
 153     /**
 154      * Set title of the page
 155      *
 156      * @param string $title title of the page displayed at top of the document
 157      *
 158      * @return void
 159      *
 160      * @access public
 161      */
 162     public function setPageTitle($title)
 163     {
 164         $this->_pageTitle=$title;
 165     }
 166
 167     /**
 168      * Set type of export relational schema
 169      *
 170      * @param string $value can be pdf,svg,dia,eps etc
 171      *
 172      * @return void
 173      *
 174      * @access public
 175      */
 176     public function setExportType($value)
 177     {
 178         $this->exportType=$value;
 179     }
 180
 181     /**
 182      * get all tables involved or included in page
 183      *
 184      * @param string  $db         name of the database
 185      * @param integer $pageNumber page no. whose tables will be fetched in an array
 186      *
 187      * @return Array an array of tables
 188      *
 189      * @access public
 190      */
 191     public function getAllTables($db, $pageNumber)
 192     {
 193         global $cfgRelation;
 194
 195         // Get All tables
 196         $tab_sql = 'SELECT table_name FROM '
 197             . PMA_Util::backquote($GLOBALS['cfgRelation']['db']) . '.'
 198             . PMA_Util::backquote($cfgRelation['table_coords'])
 199             . ' WHERE db_name = \'' . PMA_Util::sqlAddSlashes($db) . '\''
 200             . ' AND pdf_page_number = ' . $pageNumber;
 201
 202         $tab_rs = PMA_queryAsControlUser($tab_sql, null, PMA_DBI_QUERY_STORE);
 203         if (!$tab_rs || !PMA_DBI_num_rows($tab_rs) > 0) {
 204             $this->dieSchema('', __('This page does not contain any tables!'));
 205         }
 206         while ($curr_table = @PMA_DBI_fetch_assoc($tab_rs)) {
 207             $alltables[] = PMA_Util::sqlAddSlashes($curr_table['table_name']);
 208         }
 209         return $alltables;
 210     }
 211
 212     /**
 213      * Displays an error message
 214      *
 215      * @param integer $pageNumber    ID of the chosen page
 216      * @param string  $type          Schema Type
 217      * @param string  $error_message The error mesage
 218      *
 219      * @global array    the PMA configuration array
 220      * @global string   the current database name
 221      *
 222      * @access public
 223      *
 224      * @return void
 225      */
 226     function dieSchema($pageNumber, $type = '', $error_message = '')
 227     {
 228         global $db;
 229
 230         echo "<p><strong>" . __("SCHEMA ERROR: ") .  $type . "</strong></p>" . "\n";
 231         if (!empty($error_message)) {
 232             $error_message = htmlspecialchars($error_message);
 233         }
 234         echo '<p>' . "\n";
 235         echo '    ' . $error_message . "\n";
 236         echo '</p>' . "\n";
 237         echo '<a href="schema_edit.php?' . PMA_generate_common_url($db)
 238             . '&do=selectpage&chpage=' . $pageNumber . '&action_choose=0'
 239             . '">' . __('Back') . '</a>';
 240         echo "\n";
 241         exit;
 242     }
 243 }
 244 ?>