plugin table wordpress

plugin.php

<?php
/**
 * Custom AJAX List Table Example
 *
 * Custom AJAX List Table Example is a WordPress Plugin example of WP_List_Table
 * AJAX implementation. It is a fork of Matt Van Andel's Custom List Table Example
 * plugin.
 *
 * Plugin Name: Custom AJAX List Table Example
 * Plugin URI:  https://github.com/Askelon/Custom-AJAX-List-Table-Example
 * Description: A highly documented plugin that demonstrates how to create custom AJAX admin list-tables using official WordPress techniques.
 * Version:     1.4
 * Author:      Charlie MERLAND
 * Author URI:  http://www.caercam.org/
 * License:     GPL-2.0
 * License URI: http://www.gnu.org/licenses/gpl-2.0.txt
 * GitHub Plugin URI: https://github.com/Askelon/Custom-AJAX-List-Table-Example
 */

/**
	Copyright 2014 Charlie MERLAND (email : charlie.merland@gmail.com)

	This program is free software; you can redistribute it and/or modify
	it under the terms of the GNU General Public License, version 2, as
	published by the Free Software Foundation.

	This program is distributed in the hope that it will be useful,
	but WITHOUT ANY WARRANTY; without even the implied warranty of
	MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
	GNU General Public License for more details.

	You should have received a copy of the GNU General Public License
	along with this program; if not, write to the Free Software
	Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA  02110-1301  USA
*/

/** == NOTICE ==================================================================
 * Please do not alter this file. Instead: make a copy of the entire plugin,
 * rename it, and work inside the copy. If you modify this plugin directly and
 * an update is released, your changes will be lost!
 * ========================================================================== */



/** ************************* LOAD THE BASE CLASS ******************************
 *
 * The WP_List_Table class isn't automatically available to plugins, so we need
 * to check if it's available and load it if necessary. In this tutorial, we are
 * going to use the WP_List_Table class directly from WordPress core.
 *
 * IMPORTANT:
 * Please note that the WP_List_Table class technically isn't an official API,
 * and it could change at some point in the distant future. Should that happen,
 * I will update this plugin with the most current techniques for your reference
 * immediately.
 *
 * If you are really worried about future compatibility, you can make a copy of
 * the WP_List_Table class (file path is shown just below) to use and distribute
 * with your plugins. If you do that, just remember to change the name of the
 * class to avoid conflicts with core.
 *
 * Since I will be keeping this tutorial up-to-date for the foreseeable future,
 * I am going to work with the copy of the class provided in WordPress core.
 */
if ( ! class_exists( 'WP_List_Table' ) )
	require_once( ABSPATH . 'wp-admin/includes/class-wp-list-table.php' );

/* Hide notices to avoid AJAX errors
 * Sometimes the Class throws a notice about 'hook_suffix' being undefined,
 * which breaks every AJAX call.
 */
error_reporting( ~E_NOTICE );





class TT_Example_List_Table extends WP_List_Table {

	/**
	 * Normally we would be querying data from a database and manipulating that
	 * for use in your list table. For this example, we're going to simplify it
	 * slightly and create a pre-built array. Think of this as the data that might
	 * be returned by $wpdb->query().
	 *
	 * @var array
	 */

	public $example_data = array(
		array(
			'ID'		=> 1,
			'title'		=> '300',
			'rating'	=> 'R',
			'director'	=> 'Zach Snyder'
		),
		array(
			'ID'		=> 2,
			'title'		=> 'Eyes Wide Shut',
			'rating'	=> 'R',
			'director'	=> 'Stanley Kubrick'
		),
		array(
			'ID'		=> 3,
			'title'		=> 'Moulin Rouge!',
			'rating'	=> 'PG-13',
			'director'	=> 'Baz Luhrman'
		),
		array(
			'ID'		=> 4,
			'title'		=> 'Snow White',
			'rating'	=> 'G',
			'director'	=> 'Walt Disney'
		),
		array(
			'ID'		=> 5,
			'title'		=> 'Super 8',
			'rating'	=> 'PG-13',
			'director'	=> 'JJ Abrams'
		),
		array(
			'ID'		=> 6,
			'title'		=> 'The Fountain',
			'rating'	=> 'PG-13',
			'director'	=> 'Darren Aronofsky'
		),
		array(
			'ID'		=> 7,
			'title'		=> 'Watchmen',
			'rating'	=> 'R',
			'director'	=> 'Zach Snyder'
		),
		array(
			'ID'		=> 8,
			'title'		=> 'The Descendants',
			'rating'	=> 'R',
			'director'	=> 'Alexander Payne'
		),
		array(
			'ID'		=> 9,
			'title'		=> 'Moon',
			'rating'	=> 'R',
			'director'	=> 'Duncan Jones'
		),
		array(
			'ID'		=> 10,
			'title'		=> 'Elysium',
			'rating'	=> 'R',
			'director'	=> 'Neill Blomkamp'
		),
		array(
			'ID'		=> 11,
			'title'		=> 'Source Code',
			'rating'	=> 'PG-13',
			'director'	=> 'Duncan Jones'
		),
		array(
			'ID'		=> 12,
			'title'		=> 'Django Unchained',
			'rating'	=> 'R',
			'director'	=> 'Quentin Tarantino'
		)
	);


	/**
	 * REQUIRED. Set up a constructor that references the parent constructor. We
	 * use the parent reference to set some default configs.
	 */
	function __construct() {

		global $status, $page;

		//Set parent defaults
		parent::__construct(
			array(
				//singular name of the listed records
				'singular'	=> 'movie',
				//plural name of the listed records
				'plural'	=> 'movies',
				//does this table support ajax?
				'ajax'		=> true
			)
		);
	}

	public function asm_getDataById($idComment)
	{
		global $wpdb;
		$table_name = $this->tableName;

		$meta_key = $idComment;
		$thepost = $wpdb->get_row($wpdb->prepare(
			"
				SELECT ans_content, estado
				FROM $table
				WHERE id = %s
			",
			$meta_key
		));

		return $thepost;
	}


	/**
	 * Recommended. This method is called when the parent class can't find a method
	 * specifically build for a given column. Generally, it's recommended to include
	 * one method for each column you want to render, keeping your package class
	 * neat and organized. For example, if the class needs to process a column
	 * named 'title', it would first see if a method named $this->column_title()
	 * exists - if it does, that method will be used. If it doesn't, this one will
	 * be used. Generally, you should try to use custom column methods as much as
	 * possible.
	 *
	 * Since we have defined a column_title() method later on, this method doesn't
	 * need to concern itself with any column with a name of 'title'. Instead, it
	 * needs to handle everything else.
	 *
	 * For more detailed insight into how columns are handled, take a look at
	 * WP_List_Table::single_row_columns()
	 *
	 * @param array $item A singular item (one full row's worth of data)
	 * @param array $column_name The name/slug of the column to be processed
	 *
	 * @return string Text or HTML to be placed inside the column <td>
	 */
	function column_default( $item, $column_name ) {

		switch ( $column_name ) {

			case 'rating':
			case 'director':
				return $item[ $column_name ];
			default:
				//Show the whole array for troubleshooting purposes
				return print_r( $item, true );
		}
	}


	/**
	 * Recommended. This is a custom column method and is responsible for what
	 * is rendered in any column with a name/slug of 'title'. Every time the class
	 * needs to render a column, it first looks for a method named
	 * column_{$column_title} - if it exists, that method is run. If it doesn't
	 * exist, column_default() is called instead.
	 *
	 * This example also illustrates how to implement rollover actions. Actions
	 * should be an associative array formatted as 'slug'=>'link html' - and you
	 * will need to generate the URLs yourself. You could even ensure the links
	 *
	 * @see WP_List_Table::single_row_columns()
	 *
	 * @param array $item A singular item (one full row's worth of data)
	 *
	 * @return string Text to be placed inside the column <td> (movie title only)
	 */
	function column_title( $item ) {

		//Build row actions
		$actions = array(
			'responder'		=> sprintf( '<a href="javascript:makeAction(\'%s\', \'%s\');">Responder</a>', 'responder', $item['ID'] ),
			'aprobar'	=> sprintf( '<a href="javascript:makeAction(\'%s\', \'%s\');">Aprobar</a>', 'aprobar', $item['ID'] ),
		);

		//Return the title contents
		return sprintf('%1$s <span style="color:silver">(id:%2$s)</span>%3$s',
			/*$1%s*/ $item['title'],
			/*$2%s*/ $item['ID'],
			/*$3%s*/ $this->row_actions( $actions )
		);
	}


	/**
	 * REQUIRED if displaying checkboxes or using bulk actions! The 'cb' column
	 * is given special treatment when columns are processed. It ALWAYS needs to
	 * have it's own method.
	 *
	 * @see WP_List_Table::single_row_columns()
	 *
	 * @param array $item A singular item (one full row's worth of data)
	 *
	 * @return string Text to be placed inside the column <td> (movie title only)
	 */
	function column_cb( $item ) {

		return sprintf(
			'<input type="checkbox" name="%1$s[]" value="%2$s" />',
			/*$1%s*/ $this->_args['singular'],  	//Let's simply repurpose the table's singular label ("movie")
			/*$2%s*/ $item['ID']			//The value of the checkbox should be the record's id
		);
	}


	/**
	 * REQUIRED! This method dictates the table's columns and titles. This should
	 * return an array where the key is the column slug (and class) and the value
	 * is the column's title text. If you need a checkbox for bulk actions, refer
	 * to the $columns array below.
	 *
	 * The 'cb' column is treated differently than the rest. If including a checkbox
	 * column in your table you must create a column_cb() method. If you don't need
	 * bulk actions or checkboxes, simply leave the 'cb' entry out of your array.
	 *
	 * @see WP_List_Table::single_row_columns()
	 *
	 * @return array An associative array containing column information: 'slugs'=>'Visible Titles'
	 */
	function get_columns() {

		return $columns = array(
			'cb'		=> '<input type="checkbox" />', //Render a checkbox instead of text
			'title'		=> 'Title',
			'rating'	=> 'Rating',
			'director'	=> 'Director'
		);
	}


	/**
	 * Optional. If you want one or more columns to be sortable (ASC/DESC toggle),
	 * you will need to register it here. This should return an array where the
	 * key is the column that needs to be sortable, and the value is db column to
	 * sort by. Often, the key and value will be the same, but this is not always
	 * the case (as the value is a column name from the database, not the list table).
	 *
	 * This method merely defines which columns should be sortable and makes them
	 * clickable - it does not handle the actual sorting. You still need to detect
	 * the ORDERBY and ORDER querystring variables within prepare_items() and sort
	 * your data accordingly (usually by modifying your query).
	 *
	 * @return array An associative array containing all the columns that should be sortable: 'slugs'=>array('data_values',bool)
	 */
	function get_sortable_columns() {

		return $sortable_columns = array(
			'title'	 	=> array( 'title', false ),	//true means it's already sorted
			'rating'	=> array( 'rating', false ),
			'director'	=> array( 'director', false )
		);
	}


	/**
	 * Optional. If you need to include bulk actions in your list table, this is
	 * the place to define them. Bulk actions are an associative array in the format
	 * 'slug'=>'Visible Title'
	 *
	 * If this method returns an empty value, no bulk action will be rendered. If
	 * you specify any bulk actions, the bulk actions box will be rendered with
	 * the table automatically on display().
	 *
	 * Also note that list tables are not automatically wrapped in <form> elements,
	 * so you will need to create those manually in order for bulk actions to function.
	 *
	 * @return array An associative array containing all the bulk actions: 'slugs'=>'Visible Titles'
	 */
	function get_bulk_actions() {

		return $actions = array(
			'delete'	=> 'Delete'
		);
	}


	/**
	 * Optional. You can handle your bulk actions anywhere or anyhow you prefer.
	 * For this example package, we will handle it in the class to keep things
	 * clean and organized.
	 *
	 * @see $this->prepare_items()
	 */
	function process_bulk_action() {

		//Detect when a bulk action is being triggered...
		if( 'delete'=== $this->current_action() ) {
			wp_die( 'Items deleted (or they would be if we had items to delete)!' );
		}

	}


	/**
	 * REQUIRED! This is where you prepare your data for display. This method will
	 * usually be used to query the database, sort and filter the data, and generally
	 * get it ready to be displayed. At a minimum, we should set $this->items and
	 * $this->set_pagination_args(), although the following properties and methods
	 * are frequently interacted with here...
	 *
	 * @global WPDB $wpdb
	 * @uses $this->_column_headers
	 * @uses $this->items
	 * @uses $this->get_columns()
	 * @uses $this->get_sortable_columns()
	 * @uses $this->get_pagenum()
	 * @uses $this->set_pagination_args()
	 */
	function prepare_items() {

		global $wpdb; //This is used only if making any database queries

		/**
		 * First, lets decide how many records per page to show
		 */
		$per_page = 4;


		/**
		 * REQUIRED. Now we need to define our column headers. This includes a complete
		 * array of columns to be displayed (slugs & titles), a list of columns
		 * to keep hidden, and a list of columns that are sortable. Each of these
		 * can be defined in another method (as we've done here) before being
		 * used to build the value for our _column_headers property.
		 */
		$columns = $this->get_columns();
		$hidden = array();
		$sortable = $this->get_sortable_columns();


		/**
		 * REQUIRED. Finally, we build an array to be used by the class for column
		 * headers. The $this->_column_headers property takes an array which contains
		 * 3 other arrays. One for all columns, one for hidden columns, and one
		 * for sortable columns.
		 */
		$this->_column_headers = array($columns, $hidden, $sortable);


		/**
		 * Optional. You can handle your bulk actions however you see fit. In this
		 * case, we'll handle them within our package just to keep things clean.
		 */
		$this->process_bulk_action();


		/**
		 * Instead of querying a database, we're going to fetch the example data
		 * property we created for use in this plugin. This makes this example
		 * package slightly different than one you might build on your own. In
		 * this example, we'll be using array manipulation to sort and paginate
		 * our data. In a real-world implementation, you will probably want to
		 * use sort and pagination data to build a custom query instead, as you'll
		 * be able to use your precisely-queried data immediately.
		 */
		$data = $this->example_data;


		/**
		 * This checks for sorting input and sorts the data in our array accordingly.
		 *
		 * In a real-world situation involving a database, you would probably want
		 * to handle sorting by passing the 'orderby' and 'order' values directly
		 * to a custom query. The returned data will be pre-sorted, and this array
		 * sorting technique would be unnecessary.
		 */
		function usort_reorder( $a, $b ) {

			//If no sort, default to title
			$orderby = ( ! empty( $_REQUEST['orderby'] ) ) ? $_REQUEST['orderby'] : 'title';
			//If no order, default to asc
			$order = ( ! empty( $_REQUEST['order'] ) ) ? $_REQUEST['order'] : 'asc';
			 //Determine sort order
			$result = strcmp( $a[ $orderby ], $b[ $orderby ] );
			//Send final sort direction to usort
			return ( 'asc' === $order ) ? $result : -$result;
		}
		usort( $data, 'usort_reorder' );


		/***********************************************************************
		 * ---------------------------------------------------------------------
		 * vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv
		 *
		 * In a real-world situation, this is where you would place your query.
		 *
		 * For information on making queries in WordPress, see this Codex entry:
		 * http://codex.wordpress.org/Class_Reference/wpdb
		 *
		 * ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
		 * ---------------------------------------------------------------------
		 **********************************************************************/


		/**
		 * REQUIRED for pagination. Let's figure out what page the user is currently
		 * looking at. We'll need this later, so you should always include it in
		 * your own package classes.
		 */
		$current_page = $this->get_pagenum();

		/**
		 * REQUIRED for pagination. Let's check how many items are in our data array.
		 * In real-world use, this would be the total number of items in your database,
		 * without filtering. We'll need this later, so you should always include it
		 * in your own package classes.
		 */
		$total_items = count($data);


		/**
		 * The WP_List_Table class does not handle pagination for us, so we need
		 * to ensure that the data is trimmed to only the current page. We can use
		 * array_slice() to
		 */
		$data = array_slice($data,(($current_page-1)*$per_page),$per_page);



		/**
		 * REQUIRED. Now we can add our *sorted* data to the items property, where
		 * it can be used by the rest of the class.
		 */
		$this->items = $data;


		/**
		 * REQUIRED. We also have to register our pagination options & calculations.
		 */
		$this->set_pagination_args(
			array(
				//WE have to calculate the total number of items
				'total_items'	=> $total_items,
				//WE have to determine how many items to show on a page
				'per_page'	=> $per_page,
				//WE have to calculate the total number of pages
				'total_pages'	=> ceil( $total_items / $per_page ),
				// Set ordering values if needed (useful for AJAX)
				'orderby'	=> ! empty( $_REQUEST['orderby'] ) && '' != $_REQUEST['orderby'] ? $_REQUEST['orderby'] : 'title',
				'order'		=> ! empty( $_REQUEST['order'] ) && '' != $_REQUEST['order'] ? $_REQUEST['order'] : 'asc'
			)
		);
	}

	/**
	 * Display the table
	 * Adds a Nonce field and calls parent's display method
	 *
	 * @since 3.1.0
	 * @access public
	 */
	function display() {

		wp_nonce_field( 'ajax-custom-list-nonce', '_ajax_custom_list_nonce' );

		echo '<input type="hidden" id="order" name="order" value="' . $this->_pagination_args['order'] . '" />';
		echo '<input type="hidden" id="orderby" name="orderby" value="' . $this->_pagination_args['orderby'] . '" />';

		parent::display();
	}

	/**
	 * Handle an incoming ajax request (called from admin-ajax.php)
	 *
	 * @since 3.1.0
	 * @access public
	 */
	function ajax_response() {

		check_ajax_referer( 'ajax-custom-list-nonce', '_ajax_custom_list_nonce' );

		$this->prepare_items();

		extract( $this->_args );
		extract( $this->_pagination_args, EXTR_SKIP );

		ob_start();
		if ( ! empty( $_REQUEST['no_placeholder'] ) )
			$this->display_rows();
		else
			$this->display_rows_or_placeholder();
		$rows = ob_get_clean();

		ob_start();
		$this->print_column_headers();
		$headers = ob_get_clean();

		ob_start();
		$this->pagination('top');
		$pagination_top = ob_get_clean();

		ob_start();
		$this->pagination('bottom');
		$pagination_bottom = ob_get_clean();

		$response = array( 'rows' => $rows );
		$response['pagination']['top'] = $pagination_top;
		$response['pagination']['bottom'] = $pagination_bottom;
		$response['column_headers'] = $headers;

		if ( isset( $total_items ) )
			$response['total_items_i18n'] = sprintf( _n( '1 item', '%s items', $total_items ), number_format_i18n( $total_items ) );

		if ( isset( $total_pages ) ) {
			$response['total_pages'] = $total_pages;
			$response['total_pages_i18n'] = number_format_i18n( $total_pages );
		}

		die( json_encode( $response ) );
	}


}





/** ************************ REGISTER THE TEST PAGE ****************************
 *******************************************************************************
 * Now we just need to define an admin page. For this example, we'll add a top-level
 * menu item to the bottom of the admin menus.
 */
function tt_add_menu_items(){
	add_menu_page('Example Plugin List Table', 'List Table Example', 'activate_plugins', 'tt_list_test', 'tt_render_list_page');
} add_action('admin_menu', 'tt_add_menu_items');





/** *************************** RENDER TEST PAGE ********************************
 *******************************************************************************
 * This function renders the admin page and the example list table. Although it's
 * possible to call prepare_items() and display() from the constructor, there
 * are often times where you may need to include logic here between those steps,
 * so we've instead called those methods explicitly. It keeps things flexible, and
 * it's the way the list tables are used in the WordPress core.
 */
function tt_render_list_page(){

	//Create an instance of our package class...
	$testListTable = new TT_Example_List_Table();
	//Fetch, prepare, sort, and filter our data...
	$testListTable->prepare_items();

	?>
	<div class="wrap">

		<div id="icon-users" class="icon32"><br/></div>
		<h2>List Table Test</h2>

		<div style="background:#ECECEC;border:1px solid #CCC;padding:0 10px;margin-top:5px;border-radius:5px;-moz-border-radius:5px;-webkit-border-radius:5px;">
			<p>This page demonstrates the use of the <tt><a href="http://codex.wordpress.org/Class_Reference/WP_List_Table" target="_blank" style="text-decoration:none;">WP_List_Table</a></tt> class in plugins.</p>
			<p>For a detailed explanation of using the <tt><a href="http://codex.wordpress.org/Class_Reference/WP_List_Table" target="_blank" style="text-decoration:none;">WP_List_Table</a></tt>
			class in your own plugins, you can view this file <a href="<?php echo admin_url( 'plugin-editor.php?plugin='.plugin_basename(__FILE__) ); ?>" style="text-decoration:none;">in the Plugin Editor</a> or simply open <tt style="color:gray;"><?php echo __FILE__ ?></tt> in the PHP editor of your choice.</p>
			<p>Additional class details are available on the <a href="http://codex.wordpress.org/Class_Reference/WP_List_Table" target="_blank" style="text-decoration:none;">WordPress Codex</a>.</p>
		</div>

		<!-- Forms are NOT created automatically, so you need to wrap the table in one to use features like bulk actions -->
		<form id="movies-filter" method="get">
			<!-- For plugins, we also need to ensure that the form posts back to our current page -->
			<input type="hidden" name="page" value="<?php echo $_REQUEST['page'] ?>" />
			<!-- Now we can render the completed list table -->
			<?php $testListTable->display() ?>
		</form>

		<div id="edit-self-comment" style="display:none; border:1px solid red">
			<form action="" method="post">
				<input type="hidden" name="action" value="">
				<input type="text" name="id" value="" readonly="readonly">
				<div id="responder" style="display:none">
					<textarea name="respuesta" rows="4" cols="50"></textarea><br/>
					<p>Al guardar se aprobara este comentario.</p>
				</div>

				<div id="aprobar" style="display:none">
					Aprobar : <input type="text" name="estado" value="" readonly="readonly"><br>
				</div>

				<button type="submit" class="button action button-primary">Guardar</button>
			</form>
		</div>
		<!-- loading -->
		<div id="loading" class="modal" style="display: none; z-index:1000">
			<div class="modal-content modal-suscription" style="border-radius:0">
				Cargando...
			</div>
		</div><!-- end loading-->
		<style media="screen">
			.modal-content {
				background-color: #e8e8e8;
				margin: 10% auto 0 auto;
				padding: 20px 30px;
				width: 80%;
				position: relative;
				border-radius: 0 0 50px 0;
			}
			.modal-suscription {
				max-width: 450px;
				text-align: center;
			}

			#responder {
				border:1px solid blue;
			}
			#aprobar {
				border:1px solid black;
			}
		</style>
		<script type="text/javascript">
			// Primera accion
			function makeAction(nameAction, idPost) {
				// reset form
				var inputForm = jQuery('#edit-self-comment form');
				inputForm[0].reset();

				var containderId = jQuery('#edit-self-comment');
				containderId.find("form input[name='action']").val(nameAction);
				containderId.find("form input[name='id']").val(idPost);
				containderId.show();
				containderId.find('#responder, #aprobar').hide();

				if (nameAction == 'responder')  {
					containderId.find('#responder').show();
				} else if(nameAction == 'aprobar') {
					containderId.find('#aprobar').show();
					containderId.find("form input[name='estado']").val(1);
				}
			}

			// Event click
			jQuery('#edit-self-comment form').submit(function(event){
				event.preventDefault();
				var url = '/wp-admin/admin-ajax.php?action=vt_ajax_request';
				var containderId = jQuery('#edit-self-comment');

				var inputForm = jQuery(this);
				var dataForm = jQuery(this).serializeArray();
				jQuery.ajax({
					url : url,
					dataType: 'json',
					data: dataForm,
					method: 'POST',
					beforeSend : function(){
						jQuery('#loading').show();
					},
					success: function(rs){
						jQuery('#loading').hide();
						if (rs.success === true) {
							//ocualtar popups
							containderId.hide();
							containderId.find('#responder, #aprobar').hide();

							inputForm[0].reset();

						} else if (rs.success === false && rs.hasOwnProperty('message') && rs.message.length > 0) {
							jQuery('#loading').show();
							jQuery('#loading div').html(rs.message);
							setTimeout(function(){ jQuery('#loading').fadeOut(); }, 1500);
							// inputForm.find('input[name=email]').val('').focus();
						} else {
							alert("Datos incorrectos");
						}
					}
				});

			});


			function getData(){

			}
		</script>
	</div>
	<?php
}

/**
 * Callback function for 'wp_ajax__ajax_fetch_custom_list' action hook.
 *
 * Loads the Custom List Table Class and calls ajax_response method
 */
function _ajax_fetch_custom_list_callback() {

	$wp_list_table = new TT_Example_List_Table();
	$wp_list_table->ajax_response();
}
// add_action('wp_ajax__ajax_fetch_custom_list', '_ajax_fetch_custom_list_callback');

/**
 * This function adds the jQuery script to the plugin's page footer
 */
function ajax_script() {

	$screen = get_current_screen();
	if ( 'toplevel_page_tt_list_test' != $screen->id )
		return false;
?>
<script type="text/javascript">
(function($) {

list = {

	/**
	 * Register our triggers
	 *
	 * We want to capture clicks on specific links, but also value change in
	 * the pagination input field. The links contain all the information we
	 * need concerning the wanted page number or ordering, so we'll just
	 * parse the URL to extract these variables.
	 *
	 * The page number input is trickier: it has no URL so we have to find a
	 * way around. We'll use the hidden inputs added in TT_Example_List_Table::display()
	 * to recover the ordering variables, and the default paged input added
	 * automatically by WordPress.
	 */
	init: function() {

		// This will have its utility when dealing with the page number input
		var timer;
		var delay = 500;

		// Pagination links, sortable link
		$('.tablenav-pages a, .manage-column.sortable a, .manage-column.sorted a').on('click', function(e) {
			// We don't want to actually follow these links
			e.preventDefault();
			// Simple way: use the URL to extract our needed variables
			var query = this.search.substring( 1 );

			var data = {
				paged: list.__query( query, 'paged' ) || '1',
				order: list.__query( query, 'order' ) || 'asc',
				orderby: list.__query( query, 'orderby' ) || 'title'
			};
			list.update( data );
		});

		// Page number input
		$('input[name=paged]').on('keyup', function(e) {

			// If user hit enter, we don't want to submit the form
			// We don't preventDefault() for all keys because it would
			// also prevent to get the page number!
			if ( 13 == e.which )
				e.preventDefault();

			// This time we fetch the variables in inputs
			var data = {
				paged: parseInt( $('input[name=paged]').val() ) || '1',
				order: $('input[name=order]').val() || 'asc',
				orderby: $('input[name=orderby]').val() || 'title'
			};

			// Now the timer comes to use: we wait half a second after
			// the user stopped typing to actually send the call. If
			// we don't, the keyup event will trigger instantly and
			// thus may cause duplicate calls before sending the intended
			// value
			window.clearTimeout( timer );
			timer = window.setTimeout(function() {
				list.update( data );
			}, delay);
		});
	},

	/** AJAX call
	 *
	 * Send the call and replace table parts with updated version!
	 *
	 * @param    object    data The data to pass through AJAX
	 */
	update: function( data ) {
		$.ajax({
			// /wp-admin/admin-ajax.php
			url: ajaxurl,
			// Add action and nonce to our collected data
			data: $.extend(
				{
					_ajax_custom_list_nonce: $('#_ajax_custom_list_nonce').val(),
					action: '_ajax_fetch_custom_list',
				},
				data
			),
			// Handle the successful result
			success: function( response ) {

				// WP_List_Table::ajax_response() returns json
				var response = $.parseJSON( response );

				// Add the requested rows
				if ( response.rows.length )
					$('#the-list').html( response.rows );
				// Update column headers for sorting
				if ( response.column_headers.length )
					$('thead tr, tfoot tr').html( response.column_headers );
				// Update pagination for navigation
				if ( response.pagination.bottom.length )
					$('.tablenav.top .tablenav-pages').html( $(response.pagination.top).html() );
				if ( response.pagination.top.length )
					$('.tablenav.bottom .tablenav-pages').html( $(response.pagination.bottom).html() );

				// Init back our event handlers
				list.init();
			}
		});
	},

	/**
	 * Filter the URL Query to extract variables
	 *
	 * @see http://css-tricks.com/snippets/javascript/get-url-variables/
	 *
	 * @param    string    query The URL query part containing the variables
	 * @param    string    variable Name of the variable we want to get
	 *
	 * @return   string|boolean The variable value if available, false else.
	 */
	__query: function( query, variable ) {

		var vars = query.split("&");
		for ( var i = 0; i <vars.length; i++ ) {
			var pair = vars[ i ].split("=");
			if ( pair[0] == variable )
				return pair[1];
		}
		return false;
	},
}

// Show time!
list.init();

})(jQuery);
</script>
<?php
}
// add_action('admin_footer', 'ajax_script');




add_action('wp_ajax_nopriv_vt_ajax_request',  'vt_ajax_request');
add_action('wp_ajax_vt_ajax_request',  'vt_ajax_request');

function vt_ajax_request() {
	global $wpdb; // this is how you get access to the database
echo "aaa";exit;
	$errors = array();
	$data['success'] = false;
	$idComment = '';
	$respuesta = '';
	$estado = '';
	//
	$action = empty($_POST['action']) ? '' : strip_tags($_POST['action']);
	if (!empty($_POST['id'])) {
		$idComment = strip_tags($_POST['id']);
	} else {
		$errors['id'] = 'Id is required.';
	}

	if (!empty($_POST['respuesta'])) {
		$respuesta = strip_tags($_POST['respuesta']);
	} else {
		$errors['respuesta'] = 'Respuesta es requerido.';
	}

	if (!empty($_POST['estado'])) {
		$estado = strip_tags($_POST['estado']);
	} else {
		$errors['estado'] = 'Estado es requerido.';
	}

	// 01 : Obtener datos data ajax *respuesta, estado*
	if ($action == 'get-respuesta' || $action == 'get-estado') {
		// exist email
		if (!empty($idComment)) {
			$data['success'] = true;
			$data['message'] = $this->asm_getDataById($idComment);
		}
	}

	// 02 : Guardar datos
	$table_name = $this->tableName;
	if (count($errors) == 0) {
		if (!empty($respuesta)) {
			$updated = $wpdb->update(
				$table_name,
				array(
					'ans_content' => $respuesta,
					'ans_status' => 1
				),
				array( 'ID' => $idComment)
			);

			if (false === $updated) {// There was an error.
				$data['message'] = 'Error al actualizar';
			} else {
				$data['success'] = true;
			}
		} else if (!empty($estado)) {
			$updated = $wpdb->update(
				$table_name,
				array(
					'ans_status' => $estado
				),
				array( 'ID' => $idComment)
			);

			if (false === $updated) {// There was an error.
				$data['message'] = 'Error al actualizar';
			} else {
				$data['success'] = true;
			}
		}
	} else {
		$data['errors'] = $errors;
	}

	echo json_encode($data);
	wp_die(); // this is required to terminate immediately and return a proper response
}