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