Add the Donation amount to the Members List CSV Export

pmpro-add-donation-amount-to-member-list-csv.php

<?php

function my_pmpro_members_list_csv_extra_columns($columns)
{
	$columns["donation"] = "my_extra_column_donation";
	
	return $columns;
}
add_filter("pmpro_members_list_csv_extra_columns", "my_pmpro_members_list_csv_extra_columns", 10);

function my_extra_column_donation($user)
{
	$order_id = getFirstMemberOrder($user->ID);
	
	$order = new MemberOrder();
	$order->getMemberOrderByID($order_id);
		
	if(!empty($order))
	{
		$donation = pmprodon_getPriceComponents($order)['donation'];
		return $donation;
	}
	else
	{
		return "";
	}
}

function getFirstMemberOrder($user_id = NULL, $status = 'success', $membership_id = NULL, $gateway = NULL, $gateway_environment = NULL)
{
	global $current_user, $wpdb;
	if(!$user_id)
		$user_id = $current_user->ID;

	if(!$user_id)
		return false;

	//build query
	$sqlQuery = "SELECT id FROM $wpdb->pmpro_membership_orders WHERE user_id = '" . $user_id . "' ";
	if(!empty($status) && is_array($status))
		$sqlQuery .= "AND status IN('" . implode("','", $status) . "') ";
	elseif(!empty($status))
		$sqlQuery .= "AND status = '" . esc_sql($status) . "' ";
	if(!empty($membership_id))
		$sqlQuery .= "AND membership_id = '" . $membership_id . "' ";
	
	if(!empty($gateway))
		$sqlQuery .= "AND gateway = '" . esc_sql($gateway) . "' ";

	if(!empty($gateway_environment))
		$sqlQuery .= "AND gateway_environment = '" . esc_sql($gateway_environment) . "' ";

	$sqlQuery .= "ORDER BY timestamp ASC LIMIT 1";

	//get id
	$id = $wpdb->get_var($sqlQuery);

	return $id;
}