Skip to content

Instantly share code, notes, and snippets.

@messica
Last active September 20, 2019 15:05
Show Gist options
  • Save messica/a15c76e8900de12fc1dab3d6eef9976a to your computer and use it in GitHub Desktop.
Save messica/a15c76e8900de12fc1dab3d6eef9976a to your computer and use it in GitHub Desktop.
Use most recent expiration date in Expired column in Members List.
<?php
/**
* Use most recent expiration date in Expired column in Members List.
*/
function my_pmpro_memberslist_expires_column( $enddate, $user ) {
global $wpdb;
$filter = sanitize_text_field( $_REQUEST['l'] );
$old_members_filters = array( 'oldmembers', 'cancelled', 'expired' );
if ( in_array( $filter, $old_members_filters ) ) {
$sql = "select enddate from {$wpdb->pmpro_memberships_users} where user_id = {$user->ID} and status != 'active' order by id desc limit 1";
$enddate = date_i18n( get_option( 'date_format' ), strtotime( $wpdb->get_var( $sql ) ) );
}
return $enddate;
}
add_filter( 'pmpro_memberslist_expires_column', 'my_pmpro_memberslist_expires_column', 10, 2 );
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment