'subscriber',
'plural' => 'subscribers',
'ajax' => false,
]
);
}
public function get_table_classes() {
return [ 'widefat', 'fixed', 'striped', $this->_args['plural'] ];
}
/**
* Message to show if no designation found
*
* @return void
*/
public function no_items() {
esc_html_e( 'No subscribers found', 'wp-user-frontend' );
}
/**
* Get the column names
*
* @return array
*/
public function get_columns() {
$columns = [
'cb' => '',
'id' => __( 'User ID', 'wp-user-frontend' ),
'name' => __( 'User Name', 'wp-user-frontend' ),
'subscription_id' => __( 'Subscription ID', 'wp-user-frontend' ),
'status' => __( 'Status', 'wp-user-frontend' ),
'gateway' => __( 'Gateway', 'wp-user-frontend' ),
'transaction_id' => __( 'Transaction ID', 'wp-user-frontend' ),
'starts_from' => __( 'Starts from', 'wp-user-frontend' ),
'expire' => __( 'Expire date', 'wp-user-frontend' ),
];
return $columns;
}
/**
* Default column values if no callback found
*
* @param object $item
* @param string $column_name
*
* @return string
*/
public function column_default( $item, $column_name ) {
switch ( $column_name ) {
case 'id':
return $item->user_id;
case 'name':
return $item->name;
case 'subscription_id':
return $item->subscribtion_id;
case 'status':
return $item->subscribtion_status;
case 'gateway':
return $item->gateway;
case 'transaction_id':
return $item->transaction_id;
case 'starts_from':
return $item->starts_from;
case 'expire':
return $item->expire;
default:
return isset( $item->$column_name ) ? $item->$column_name : '';
}
}
/**
* Get sortable columns
*
* @return array
*/
public function get_sortable_columns() {
$sortable_columns = [
'id' => [ 'id', true ],
];
return $sortable_columns;
}
/**
* Render the checkbox column
*
* @param object $item
*
* @return string
*/
public function column_cb( $item ) {
// Verify nonce for security
if ( ! $this->verify_nonce() ) {
if ( defined( 'WP_DEBUG' ) && WP_DEBUG ) {
error_log( 'WPUF Subscribers: Nonce verification failed for column_cb function' );
}
}
$post_ID = isset( $_REQUEST['post_ID'] ) ? intval( wp_unslash( $_REQUEST['post_ID'] ) ) : 0;
return sprintf(
'', $post_ID
);
}
/**
* Set the views
*
* @return array
*/
public function get_views() {
// Verify nonce for security
if ( ! $this->verify_nonce() ) {
if ( defined( 'WP_DEBUG' ) && WP_DEBUG ) {
error_log( 'WPUF Subscribers: Nonce verification failed for get_views function' );
}
}
$status_links = [];
$post_ID = isset( $_REQUEST['post_ID'] ) ? intval( wp_unslash( $_REQUEST['post_ID'] ) ) : 0;
$base_link = admin_url( 'admin.php?page=wpuf_subscribers&pack=' . $post_ID );
$subscribers_count = count( wpuf()->subscription->subscription_pack_users( $post_ID ) );
$subscriptions_active_count = count( wpuf()->subscription->subscription_pack_users( $post_ID ) );
$subscriptions_cancel_count = count( wpuf()->subscription->subscription_pack_users( $post_ID ) );
$status = isset( $_REQUEST['status'] ) ? sanitize_text_field( wp_unslash( $_REQUEST['status'] ) ) : 'all';
$status_links['all'] = sprintf( '%s (%s)', add_query_arg( [ 'status' => 'all' ], $base_link ), ( $status == 'all' ) ? 'current' : '', __( 'All', 'wp-user-frontend' ), $subscribers_count );
$status_links['Completed'] = sprintf( '%s (%s)', add_query_arg( [ 'status' => 'Completed' ], $base_link ), ( $status == 'pending' ) ? 'current' : '', __( 'Completed', 'wp-user-frontend' ), $subscriptions_active_count );
$status_links['Cancel'] = sprintf( '%s (%s)', add_query_arg( [ 'status' => 'Cancel' ], $base_link ), ( $status == 'Cancel' ) ? 'current' : '', __( 'Cancel', 'wp-user-frontend' ), $subscriptions_cancel_count );
return $status_links;
}
/**
* Prepare the class items
*
* @return void
*/
public function prepare_items() {
global $wpdb;
// Verify nonce for security
if ( ! $this->verify_nonce() ) {
if ( defined( 'WP_DEBUG' ) && WP_DEBUG ) {
error_log( 'WPUF Subscribers: Nonce verification failed for prepare_items function' );
}
}
$columns = $this->get_columns();
$hidden = [];
$sortable = $this->get_sortable_columns();
$this->_column_headers = [ $columns, $hidden, $sortable ];
$per_page = 20;
$current_page = $this->get_pagenum();
$offset = ( $current_page - 1 ) * $per_page;
$this->page_status = isset( $_GET['status'] ) ? sanitize_text_field( wp_unslash( $_GET['status'] ) ) : '2';
// only ncessary because we have sample data
$args = [
'offset' => $offset,
'number' => $per_page,
];
if ( isset( $_REQUEST['orderby'] ) && isset( $_REQUEST['order'] ) ) {
$args['orderby'] = sanitize_text_field( wp_unslash( $_REQUEST['orderby'] ) ) ;
$args['order'] = sanitize_text_field( wp_unslash( $_REQUEST['order'] ) );
}
// Build the query with proper placeholders
$base_sql = 'SELECT * FROM ' . $wpdb->prefix . 'wpuf_subscribers';
$prepare_values = [];
$where_clause = '';
// Add conditional WHERE clauses if params exist
$post_id = ! empty( $_REQUEST['post_ID'] ) ? intval( sanitize_text_field( wp_unslash( $_REQUEST['post_ID'] ) ) ) : '';
$status = ! empty( $_REQUEST['status'] ) ? sanitize_text_field( wp_unslash( $_REQUEST['status'] ) ) : '';
if ( $post_id && $status ) {
$where_clause = ' WHERE subscribtion_id = %d AND subscribtion_status = %s';
$prepare_values = [ $post_id, $status ];
} elseif ( $post_id ) {
$where_clause = ' WHERE subscribtion_id = %d';
$prepare_values = [ $post_id ];
} elseif ( $status ) {
$where_clause = ' WHERE subscribtion_status = %s';
$prepare_values = [ $status ];
}
// Get total count for pagination
$count_sql = 'SELECT COUNT(*) FROM ' . $wpdb->prefix . 'wpuf_subscribers' . $where_clause;
if ( ! empty( $prepare_values ) ) {
$total_items = (int) $wpdb->get_var( $wpdb->prepare( $count_sql, ...$prepare_values ) );
} else {
$total_items = (int) $wpdb->get_var( $count_sql );
}
// Build ORDER BY clause with whitelisted columns
$order_by = 'id';
$order = 'DESC';
if ( ! empty( $args['orderby'] ) ) {
$allowed_cols = [ 'id', 'user_id', 'subscribtion_id', 'subscribtion_status', 'starts_from', 'expire' ];
$candidate = sanitize_key( $args['orderby'] );
if ( in_array( $candidate, $allowed_cols, true ) ) {
$order_by = $candidate;
}
}
if ( ! empty( $args['order'] ) && in_array( strtoupper( $args['order'] ), [ 'ASC', 'DESC' ], true ) ) {
$order = strtoupper( $args['order'] );
}
// Build final query with ORDER BY, LIMIT, and OFFSET
$sql = $base_sql . $where_clause . " ORDER BY {$order_by} {$order} LIMIT %d OFFSET %d";
$prepare_values[] = (int) $per_page;
$prepare_values[] = (int) $offset;
// Execute the paginated query
if ( ! empty( $prepare_values ) ) {
$this->items = $wpdb->get_results( $wpdb->prepare( $sql, ...$prepare_values ) );
} else {
// This should not happen as we always have LIMIT and OFFSET
$this->items = [];
}
$this->set_pagination_args( [
'total_items' => $total_items,
'per_page' => $per_page,
] );
}
}