'ap_moderate_list', // Singular name of the listed records
'plural' => 'ap_moderate_lists', // Plural name of the listed records
'ajax' => false // Does this table support ajax?
) );
$this->process_bulk_action();
$this->get_posts_counts();
$this->current_status = isset($_GET['status']) ? sanitize_text_field($_GET['status']) : 'publish' ;
}
public function search_box( $text, $input_id ) {
if ( empty( $_REQUEST['s'] ) && !$this->has_items() )
return;
$input_id = $input_id . '-search-input';
if ( ! empty( $_REQUEST['orderby'] ) )
echo '
:
search_box( __( 'Search', 'ap' ), 'ap-moderates' ); ?>
(' . $this->total_count . ')';
$published_count = ' (' . $this->published_count . ') ';
$pending_count = ' (' . $this->pending_count . ') ';
$draft_count = ' (' . $this->draft_count . ') ';
$trash_count = ' (' . $this->trash_count . ') ';
$moderate_count = ' (' . $this->moderate_count . ') ';
$views = array(
'publish' => sprintf( '%s ', add_query_arg( array( 'status' => 'publish', 'paged' => FALSE ) ), $current === 'publish' ? ' class="current"' : '', __('Publish', 'ap') . $published_count ),
'pending' => sprintf( '%s ', add_query_arg( array( 'status' => 'pending', 'paged' => FALSE ) ), $current === 'pending' ? ' class="current"' : '', __('Pending', 'ap') . $pending_count ),
'moderate' => sprintf( '%s ', add_query_arg( array( 'status' => 'moderate', 'paged' => FALSE ) ), $current === 'moderate' ? ' class="current"' : '', __('Moderate', 'ap') . $moderate_count ),
'draft' => sprintf( '%s ', add_query_arg( array( 'status' => 'draft', 'paged' => FALSE ) ), $current === 'draft' ? ' class="current"' : '', __('Draft', 'ap') . $draft_count ),
'trash' => sprintf( '%s ', add_query_arg( array( 'status' => 'trash', 'paged' => FALSE ) ), $current === 'trash' ? ' class="current"' : '', __('Trash', 'ap') . $trash_count )
);
return apply_filters( 'ap_moderate_table_views', $views );
}
/**
* Retrieve the table columns
*/
public function get_columns() {
$columns = array(
'cb' => ''.$post->post_title.' ';
else
$title = ''. ap_truncate_chars(strip_tags($post->post_content), 80).' ';
if('trash' == $this->current_status){
$actions = array(
'untrash' => sprintf('%s ', ap_untrash_post($post->ID), __('Restore', 'ap')),
'delete' => sprintf('%s ', get_delete_post_link($post->ID, null, true), __('Delete permanently', 'ap')),
);
}else{
$actions = array(
'edit' => sprintf('%s ', get_edit_post_link($post->ID), __('Edit', 'ap')),
'trash' => sprintf('%s ', get_delete_post_link($post->ID), __('Trash', 'ap')),
'view' => sprintf('%s ', get_permalink($post->ID), __('View', 'ap'))
);
}
return sprintf('%1$s %2$s', $title, $this->row_actions($actions) );
}
public function column_flag( $post ) {
$flag_count = get_post_meta($post->ID, ANSPRESS_FLAG_META, true);
return '' . $flag_count . ' ';
}
public function column_category( $post ) {
/* Get the genres for the post. */
$category = get_the_terms($post->ID, ANSPRESS_CAT_TAX);
/* If terms were found. */
if (!empty($category)) {
$out = array();
/* Loop through each term, linking to the 'edit posts' page for the specific term. */
foreach ($category as $cat) {
$out[] = edit_term_link($cat->name, '', '', $cat, false);
}
/* Join the terms, separating them with a comma. */
return join(', ', $out);
}
/* If no terms were found, output a default message. */
else {
return __('--');
}
}
/**
* Retrieve the bulk actions
*/
public function get_bulk_actions() {
$status = isset($_GET['status']) ? sanitize_text_field($_GET['status']) : 'publish' ;
if('trash' == $status){
$actions = array(
'restore' => __( 'Restore', 'ap' ),
'delete' => __( 'Delete permanently', 'ap' ),
);
}else{
$actions = array(
'publish' => __( 'Published', 'ap' ),
'pending' => __( 'Pending', 'ap' ),
'trash' => __( 'Move to trash', 'ap' ),
);
}
return apply_filters( 'ap_moderate_table_bulk_actions', $actions );
}
/**
* Process the bulk actions
*/
public function process_bulk_action() {
$ids = isset( $_GET['post'] ) ? $_GET['post'] : false;
$action = $this->current_action();
if ( ! is_array( $ids ) )
$ids = array( $ids );
if( empty( $action ) )
return;
foreach ( $ids as $id ) {
// Detect when a bulk action is being triggered...
if ( 'trash' === $this->current_action() ) {
wp_trash_post( $id );
}
if ( 'publish' === $this->current_action() ) {
wp_publish_post( $id );
}
if ( 'pending' === $this->current_action() ) {
// Update post
$u_post = array();
$u_post['ID'] = $id;
$u_post['post_status'] = 'pending';
// Update the post into the database
wp_update_post( $u_post );
}
if ( 'delete' === $this->current_action() ) {
wp_delete_post( $id, true );
}
if ( 'restore' === $this->current_action() ) {
wp_untrash_post( $id);
}
do_action( 'ap_moderate_table_do_bulk_action', $id, $this->current_action() );
}
}
/**
* Retrieve the posts counts
*/
public function get_posts_counts() {
global $wp_query;
$counts = ap_flagged_posts_count();
$this->published_count = $counts->publish;
$this->pending_count = $counts->pending;
$this->trash_count = $counts->trash;
$this->draft_count = $counts->draft;
$this->moderate_count = $counts->moderate;
foreach( $counts as $count ) {
$this->total_count += $count;
}
}
public function posts_data() {
global $wpdb;
$status = isset($_GET['status']) ? sanitize_text_field($_GET['status']) : 'publish' ;
$paged = isset( $_GET['paged'] ) ? sanitize_text_field($_GET['paged']) : 1;
// Preparing your query
$query = "SELECT p.*, v.apmeta_userid as vote_user, v.apmeta_value as vote_value, v.apmeta_param as vote_note, v.apmeta_date FROM $wpdb->posts p INNER JOIN ".$wpdb->prefix."ap_meta v ON v.apmeta_actionid = p.ID AND v.apmeta_type='flag' WHERE (p.post_type = 'answer' OR p.post_type = 'question') AND p.post_status = '$status' ";
//adjust the query to take pagination
if(!empty($paged) && !empty($this->per_page)){
$offset=($paged-1)*$this->per_page;
$query.=' LIMIT '.(int)$offset.','.$this->per_page;
}
return $wpdb->get_results($query);
}
/**
* Setup the final data for the table
* @return void
*/
public function prepare_items() {
wp_reset_vars( array( 'action', 'post', 'orderby', 'order', 's' ) );
$columns = $this->get_columns();
$hidden = array(); // No hidden columns
$sortable = $this->get_sortable_columns();
$data = $this->posts_data();
$status = isset( $_GET['status'] ) ? $_GET['status'] : 'publish';
$this->_column_headers = array( $columns, $hidden, $sortable );
switch ( $status ) {
case 'publish':
$total_items = $this->published_count;
break;
case 'pending':
$total_items = $this->pending_count;
break;
case 'draft':
$total_items = $this->draft_count;
break;
case 'trash':
$total_items = $this->trash_count;
break;
}
$this->items = $data;
$this->set_pagination_args( array(
'total_items' => $total_items,
'per_page' => $this->per_page,
'total_pages' => ceil( $total_items / $this->per_page )
)
);
}
}