197 lines
7.1 KiB
PHP
197 lines
7.1 KiB
PHP
<?php
|
|
/**
|
|
* Export Pods Table View
|
|
*
|
|
* @package tablepress-pods
|
|
* @author Tobias Bäthge
|
|
* @author Glen Whitney
|
|
* @since 0.2.6
|
|
*/
|
|
|
|
// Prohibit direct script loading.
|
|
defined( 'ABSPATH' ) || die( 'No direct script access allowed!' );
|
|
|
|
/**
|
|
* Export Pods Table View class
|
|
* @package tablepress-pods
|
|
* @author Tobias Bäthge
|
|
* @author Glen Whitney
|
|
* @since 0.2.6
|
|
*/
|
|
class TablePress_ExportPods_View extends TablePress_View {
|
|
|
|
/**
|
|
* Set up the view with data and do things that are specific for this view.
|
|
*
|
|
* @since 0.2.6
|
|
*
|
|
* @param string $action Action for this view.
|
|
* @param array $data Data for this view.
|
|
*/
|
|
public function setup( $action, array $data ) {
|
|
parent::setup( $action, $data );
|
|
|
|
$this->process_action_messages( array(
|
|
'error_export' => __( 'Error: The export failed.', 'tablepress' ),
|
|
'error_load_table' => __( 'Error: This table could not be loaded!', 'tablepress' ),
|
|
'error_table_corrupted' => __( 'Error: The internal data of this table is corrupted!', 'tablepress' ),
|
|
) );
|
|
|
|
$this->add_text_box( 'head', array( $this, 'textbox_head' ), 'normal' );
|
|
if ( 0 === $data['tables_count'] ) {
|
|
$this->add_meta_box( 'no-tables', __( 'Export Tables', 'tablepress' ), array( $this, 'postbox_no_tables' ), 'normal' );
|
|
} else {
|
|
$this->admin_page->enqueue_script( 'export', array( 'jquery' ) );
|
|
$this->add_meta_box( 'export-form', __( 'Export Pods Tables', 'tablepress' ), array( $this, 'postbox_export_form' ), 'normal' );
|
|
$this->data['submit_button_caption'] = _x( 'Download Pods Export File', 'button', 'tablepress' );
|
|
$this->add_text_box( 'submit', array( $this, 'textbox_submit_button' ), 'submit' );
|
|
}
|
|
}
|
|
|
|
/**
|
|
* Print the screen head text.
|
|
*
|
|
* @since 0.2.6
|
|
*
|
|
* @param array $data Data for this screen.
|
|
* @param array $box Information about the text box.
|
|
*/
|
|
public function textbox_head( array $data, array $box ) {
|
|
?>
|
|
<p>
|
|
<?php _e( 'Exporting a PODS table allows you to use it in other programs, like spreadsheets applications.', 'tablepress' ); ?>
|
|
<?php _e( 'Regularly exporting tables is also recommended as a backup of your data.', 'tablepress' ); ?>
|
|
</p>
|
|
<p>
|
|
<?php _e( 'To export, select the table, the PODS parameters, and the desired export format.', 'tablepress' ); ?>
|
|
<br />
|
|
<?php _e( 'Be aware that for the CSV and HTML formats only the table data, but no table options are exported!', 'tablepress' ); ?>
|
|
<?php _e( 'For the JSON format, the table data and the table options are exported.', 'tablepress' ); ?>
|
|
</p>
|
|
<?php
|
|
}
|
|
|
|
/**
|
|
* Print the content of the "No tables found" post meta box.
|
|
*
|
|
* @since 0.2.6
|
|
*
|
|
* @param array $data Data for this screen.
|
|
* @param array $box Information about the meta box.
|
|
*/
|
|
public function postbox_no_tables( array $data, array $box ) {
|
|
$add_url = TablePress::url( array( 'action' => 'add' ) );
|
|
$import_url = TablePress::url( array( 'action' => 'import' ) );
|
|
?>
|
|
<p><?php _e( 'No tables found.', 'tablepress' ); ?></p>
|
|
<p><?php printf( __( 'You should <a href="%1$s">add</a> or <a href="%2$s">import</a> a table to get started!', 'tablepress' ), $add_url, $import_url ); ?></p>
|
|
<?php
|
|
}
|
|
|
|
/**
|
|
* Print the content of the "Export Tables" post meta box.
|
|
*
|
|
* @since 0.2.6
|
|
*
|
|
* @param array $data Data for this screen.
|
|
* @param array $box Information about the meta box.
|
|
*/
|
|
public function postbox_export_form( array $data, array $box ) {
|
|
?>
|
|
<table class="tablepress-postbox-table fixed">
|
|
<tbody>
|
|
<tr>
|
|
<th class="column-1 top-align" scope="row">
|
|
<label for="tables-export"><?php _e( 'Table to Export', 'tablepress' ); ?>:</label>
|
|
</th>
|
|
<td class="column-2">
|
|
<input type="hidden" name="export[tables_list]" id="tables-export-list" value="" />
|
|
<?php
|
|
$select_size = $data['tables_count'] + 1; // to show at least one empty row in the select
|
|
$select_size = max( $select_size, 3 );
|
|
$select_size = min( $select_size, 12 );
|
|
?>
|
|
<select id="tables-export" name="export[tables][]"<?php echo $size_multiple; ?>>
|
|
<?php
|
|
foreach ( $data['table_ids'] as $table_id ) {
|
|
// Load table, without table data, options, and visibility settings.
|
|
$table = TablePress::$model_table->load( $table_id, false, false );
|
|
if ( ! current_user_can( 'tablepress_export_table', $table['id'] ) ) {
|
|
continue;
|
|
}
|
|
if ( '' === trim( $table['name'] ) ) {
|
|
$table['name'] = __( '(no name)', 'tablepress' );
|
|
}
|
|
$text = esc_html( sprintf( __( 'ID %1$s: %2$s', 'tablepress' ), $table['id'], $table['name'] ) );
|
|
$selected = selected( true, in_array( $table['id'], $data['export_ids'], true ), false );
|
|
echo "<option{$selected} value=\"{$table['id']}\">{$text}</option>";
|
|
}
|
|
?>
|
|
</select>
|
|
</td>
|
|
</tr>
|
|
<tr>
|
|
<th class="column-1" scope="row"><label for="tables-export-format"><?php _e( 'Export Format', 'tablepress' ); ?>:</label></th>
|
|
<td class="column-2">
|
|
<select id="tables-export-format" name="export[format]">
|
|
<?php
|
|
foreach ( $data['export_formats'] as $format => $name ) {
|
|
$selected = selected( $format, $data['export_format'], false );
|
|
echo "<option{$selected} value=\"{$format}\">{$name}</option>";
|
|
}
|
|
?>
|
|
</select>
|
|
</td>
|
|
</tr>
|
|
<tr>
|
|
<th class="column-1" scope="row"><label for="tables-export-csv-delimiter"><?php _e( 'CSV Delimiter', 'tablepress' ); ?>:</label></th>
|
|
<td class="column-2">
|
|
<select id="tables-export-csv-delimiter" name="export[csv_delimiter]">
|
|
<?php
|
|
foreach ( $data['csv_delimiters'] as $delimiter => $name ) {
|
|
$selected = selected( $delimiter, $data['csv_delimiter'], false );
|
|
echo "<option{$selected} value=\"{$delimiter}\">{$name}</option>";
|
|
}
|
|
?>
|
|
</select> <span id="tables-export-csv-delimiter-description" class="description hide-if-js"><?php _e( '(Only needed for CSV export.)', 'tablepress' ); ?></span>
|
|
</td>
|
|
</tr>
|
|
<tr>
|
|
<th class="column-1" scope="row"><label for="tables-export-pod-name"><?php _e( 'Pod name', 'tablepress'); ?>:</label></th>
|
|
<td class="column-2">
|
|
<select id="tables-export-pod-name" name="export[pod_name]">
|
|
<?php
|
|
foreach ( $data['pods'] as $pod) {
|
|
$pod_name = $pod['name'];
|
|
$selected = selected( $pod_name, $data['pod_name'], false );
|
|
echo "<option{$selected} value=\"{$pod_name}\">{$pod_name}</option>";
|
|
}
|
|
?>
|
|
</select>
|
|
</td>
|
|
</tr>
|
|
<tr>
|
|
<th class="column-1" scope="row"><label for="tables-export-pod-where"><?php _e( 'Pod "where" clause', 'tablepress'); ?>:</label></th>
|
|
<td class="column-2">
|
|
<input id="tables-export-pod-where" name="export[pod_where]" value="" />
|
|
<span id="tables-export-pod-where-description" class="description">
|
|
<?php _e( '(Optional Pod "where" parameter to filter results.)', 'tablepress' ); ?>
|
|
</span>
|
|
</td>
|
|
</tr>
|
|
<tr>
|
|
<th class="column-1" scope="row"><label for="tables-export-pod-dump"><?php _e( 'Dump Pod?', 'tablepress'); ?></label></th>
|
|
<td class="column-2">
|
|
<input type="checkbox" id="tables-export-pod-dump" name="export[pod_dump]" />
|
|
<span id="tables-export-pod-dump-description" class="description">
|
|
<?php _e( '(If checked, ignores the table and dumps all Pod fields.)', 'tablepress' ); ?>
|
|
</span>
|
|
</td>
|
|
</tr>
|
|
</tbody>
|
|
</table>
|
|
<?php
|
|
}
|
|
|
|
} // class TablePress_ExportPods_View
|