phpmyadmin/tbl_chart.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  * handles creation of the chart
   5  *
   6  * @package PhpMyAdmin
   7  */
   8
   9 require_once 'libraries/common.inc.php';
  10 require_once 'libraries/tbl_chart.lib.php';
  11 /*
  12  * Execute the query and return the result
  13  */
  14 if (isset($_REQUEST['ajax_request'])
  15     && isset($_REQUEST['pos'])
  16     && isset($_REQUEST['session_max_rows'])
  17 ) {
  18     $response = PMA_Response::getInstance();
  19
  20     if (strlen($GLOBALS['table']) && strlen($GLOBALS['db'])) {
  21         include './libraries/tbl_common.inc.php';
  22     }
  23
  24     $sql_with_limit = 'SELECT * FROM( ' . $sql_query . ' ) AS `temp_res` LIMIT '
  25         . $_REQUEST['pos'] . ', ' . $_REQUEST['session_max_rows'];
  26     $data = array();
  27     $result = $GLOBALS['dbi']->tryQuery($sql_with_limit);
  28     while ($row = $GLOBALS['dbi']->fetchAssoc($result)) {
  29         $data[] = $row;
  30     }
  31
  32     if (empty($data)) {
  33         $response->isSuccess(false);
  34         $response->addJSON('message', __('No data to display'));
  35         exit;
  36     }
  37     $sanitized_data = array();
  38
  39     foreach ($data as $data_row_number => $data_row) {
  40         $tmp_row = array();
  41         foreach ($data_row as $data_column => $data_value) {
  42             $tmp_row[htmlspecialchars($data_column)] = htmlspecialchars($data_value);
  43         }
  44         $sanitized_data[] = $tmp_row;
  45     }
  46     $response->isSuccess(true);
  47     $response->addJSON('message', null);
  48     $response->addJSON('chartData', json_encode($sanitized_data));
  49     unset($sanitized_data);
  50     exit;
  51 }
  52
  53 $response = PMA_Response::getInstance();
  54 // Throw error if no sql query is set
  55 if (! isset($sql_query) || $sql_query == '') {
  56     $response->isSuccess(false);
  57     $response->addHTML(
  58         PMA_Message::error(__('No SQL query was set to fetch data.'))
  59     );
  60     exit;
  61 }
  62 $header   = $response->getHeader();
  63 $scripts  = $header->getScripts();
  64 $scripts->addFile('chart.js');
  65 $scripts->addFile('tbl_chart.js');
  66 $scripts->addFile('jqplot/jquery.jqplot.js');
  67 $scripts->addFile('jqplot/plugins/jqplot.barRenderer.js');
  68 $scripts->addFile('jqplot/plugins/jqplot.canvasAxisLabelRenderer.js');
  69 $scripts->addFile('jqplot/plugins/jqplot.canvasTextRenderer.js');
  70 $scripts->addFile('jqplot/plugins/jqplot.categoryAxisRenderer.js');
  71 $scripts->addFile('jqplot/plugins/jqplot.dateAxisRenderer.js');
  72 $scripts->addFile('jqplot/plugins/jqplot.pointLabels.js');
  73 $scripts->addFile('jqplot/plugins/jqplot.pieRenderer.js');
  74 $scripts->addFile('jqplot/plugins/jqplot.highlighter.js');
  75
  76 /**
  77  * Runs common work
  78  */
  79 if (strlen($GLOBALS['table'])) {
  80     $url_params['goto'] = $cfg['DefaultTabTable'];
  81     $url_params['back'] = 'tbl_sql.php';
  82     include 'libraries/tbl_common.inc.php';
  83     include 'libraries/tbl_info.inc.php';
  84 } elseif (strlen($GLOBALS['db'])) {
  85     $url_params['goto'] = $cfg['DefaultTabDatabase'];
  86     $url_params['back'] = 'sql.php';
  87     include 'libraries/db_common.inc.php';
  88     include 'libraries/db_info.inc.php';
  89 } else {
  90     $url_params['goto'] = $cfg['DefaultTabServer'];
  91     $url_params['back'] = 'sql.php';
  92     include 'libraries/server_common.inc.php';
  93 }
  94
  95 $data = array();
  96
  97 $result = $GLOBALS['dbi']->tryQuery($sql_query);
  98 $fields_meta = $GLOBALS['dbi']->getFieldsMeta($result);
  99 while ($row = $GLOBALS['dbi']->fetchAssoc($result)) {
 100     $data[] = $row;
 101 }
 102
 103 $keys = array_keys($data[0]);
 104
 105 $numeric_types = array('int', 'real');
 106 $numeric_column_count = 0;
 107 foreach ($keys as $idx => $key) {
 108     if (in_array($fields_meta[$idx]->type, $numeric_types)) {
 109         $numeric_column_count++;
 110     }
 111 }
 112 if ($numeric_column_count == 0) {
 113     $response->isSuccess(false);
 114     $response->addJSON(
 115         'message',
 116         __('No numeric columns present in the table to plot.')
 117     );
 118     exit;
 119 }
 120
 121 // get settings if any posted
 122 $chartSettings = array();
 123 if (PMA_isValid($_REQUEST['chartSettings'], 'array')) {
 124     $chartSettings = $_REQUEST['chartSettings'];
 125 }
 126
 127 $url_params['db'] = $GLOBALS['db'];
 128 $url_params['reload'] = 1;
 129
 130 /**
 131  * Displays the page
 132  */
 133 $htmlString = PMA_getHtmlForTableChartDisplay(
 134     $url_query, $url_params, $keys, $fields_meta, $numeric_types,
 135     $numeric_column_count, $sql_query
 136 );
 137
 138 $response->addHTML($htmlString);
 139 ?>