tbl_tracking.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  * Table tracking page
   5  *
   6  * @package PhpMyAdmin
   7  */
   8
   9 // Run common work
  10 require_once './libraries/common.inc.php';
  11
  12 require_once './libraries/tbl_tracking.lib.php';
  13
  14 define('TABLE_MAY_BE_ABSENT', true);
  15 require './libraries/tbl_common.inc.php';
  16 $url_query .= '&amp;goto=tbl_tracking.php&amp;back=tbl_tracking.php';
  17 $url_params['goto'] = 'tbl_tracking.php';
  18 $url_params['back'] = 'tbl_tracking.php';
  19
  20 // Init vars for tracking report
  21 if (isset($_REQUEST['report']) || isset($_REQUEST['report_export'])) {
  22     $data = PMA_Tracker::getTrackedData(
  23         $_REQUEST['db'], $_REQUEST['table'], $_REQUEST['version']
  24     );
  25
  26     $selection_schema = false;
  27     $selection_data   = false;
  28     $selection_both  = false;
  29
  30     if (! isset($_REQUEST['logtype'])) {
  31         $_REQUEST['logtype'] = 'schema_and_data';
  32     }
  33     if ($_REQUEST['logtype'] == 'schema') {
  34         $selection_schema = true;
  35     } elseif ($_REQUEST['logtype'] == 'data') {
  36         $selection_data   = true;
  37     } else {
  38         $selection_both   = true;
  39     }
  40     if (! isset($_REQUEST['date_from'])) {
  41         $_REQUEST['date_from'] = $data['date_from'];
  42     }
  43     if (! isset($_REQUEST['date_to'])) {
  44         $_REQUEST['date_to'] = $data['date_to'];
  45     }
  46     if (! isset($_REQUEST['users'])) {
  47         $_REQUEST['users'] = '*';
  48     }
  49     $filter_ts_from = strtotime($_REQUEST['date_from']);
  50     $filter_ts_to   = strtotime($_REQUEST['date_to']);
  51     $filter_users   = array_map('trim', explode(',', $_REQUEST['users']));
  52 }
  53
  54 // Prepare export
  55 if (isset($_REQUEST['report_export'])) {
  56     $entries = PMA_getEntries($data, $filter_ts_from, $filter_ts_to, $filter_users);
  57 }
  58
  59 // Export as file download
  60 if (isset($_REQUEST['report_export'])
  61     && $_REQUEST['export_type'] == 'sqldumpfile'
  62 ) {
  63     PMA_exportAsFileDownload($entries);
  64 }
  65
  66 $html = '<br />';
  67
  68 /**
  69  * Actions
  70  */
  71
  72 // Create tracking version
  73 if (isset($_REQUEST['submit_create_version'])) {
  74     PMA_createTrackingVersion();
  75 }
  76
  77 // Deactivate tracking
  78 if (isset($_REQUEST['submit_deactivate_now'])) {
  79     PMA_deactivateTracking();
  80 }
  81
  82 // Activate tracking
  83 if (isset($_REQUEST['submit_activate_now'])) {
  84     PMA_activateTracking();
  85 }
  86
  87 // Export as SQL execution
  88 if (isset($_REQUEST['report_export']) && $_REQUEST['export_type'] == 'execution') {
  89     $sql_result = PMA_exportAsSQLExecution($entries);
  90 }
  91
  92 // Export as SQL dump
  93 if (isset($_REQUEST['report_export']) && $_REQUEST['export_type'] == 'sqldump') {
  94     PMA_exportAsSQLDump($entries);
  95 }
  96
  97 /*
  98  * Schema snapshot
  99  */
 100 if (isset($_REQUEST['snapshot'])) {
 101     $html .= PMA_getHtmlForSchemaSnapshot($url_query);
 102 }
 103 // end of snapshot report
 104
 105 /*
 106  *  Tracking report
 107  */
 108 if (isset($_REQUEST['report'])
 109     && (isset($_REQUEST['delete_ddlog']) || isset($_REQUEST['delete_dmlog']))
 110 ) {
 111     PMA_deleteTrackingReportRows($data);
 112 }
 113
 114 if (isset($_REQUEST['report']) || isset($_REQUEST['report_export'])) {
 115     $html .= PMA_getHtmlForTrackingReport(
 116         $url_query, $data, $url_params, $selection_schema, $selection_data,
 117         $selection_both, $filter_ts_to, $filter_ts_from, $filter_users
 118     );
 119 } // end of report
 120
 121
 122 /*
 123  * List selectable tables
 124  */
 125 $selectable_tables_sql_result = PMA_getSQLResultForSelectableTables();
 126 if ($GLOBALS['dbi']->numRows($selectable_tables_sql_result) > 0) {
 127     $html .= PMA_getHtmlForSelectableTables(
 128         $selectable_tables_sql_result, $url_query
 129     );
 130 }
 131 $html .= '<br />';
 132
 133 /*
 134  * List versions of current table
 135  */
 136 $sql_result = PMA_getListOfVersionsOfTable();
 137 $last_version = PMA_getTableLastVersionNumber($sql_result);
 138 if ($last_version > 0) {
 139     $html .= PMA_getHtmlForTableVersionDetails(
 140         $sql_result, $last_version, $url_params, $url_query
 141     );
 142 }
 143
 144 $html .= PMA_getHtmlForDataDefinitionAndManipulationStatements(
 145     $url_query, $last_version
 146 );
 147
 148 $html .= '<br class="clearfloat"/>';
 149
 150 $response = PMA_Response::getInstance();
 151 $response->addHTML($html);
 152
 153 ?>