Last active
September 20, 2019 15:05
-
-
Save messica/a15c76e8900de12fc1dab3d6eef9976a to your computer and use it in GitHub Desktop.
Use most recent expiration date in Expired column in Members List.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?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