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