MemberPress: Export a CSV File for All Corporate Accounts with Subaccounts in MemberPress

add_action('admin_init', function() {

	global $wpdb;

	if (! isset( $_GET['export_subaccounts'] ) ) {

		return;

	}

	$corp_ids = $wpdb->get_results("SELECT id FROM {$wpdb->prefix}mepr_corporate_accounts");

	$csv_results = array();

	foreach ( $corp_ids as $corp ) {

		// Get corp object

		$ca = new MPCA_Corporate_Account( $corp->id );

		// Get corp owner

		$ca_owner = $ca->user();

		// Get sub users

		$sub_accounts = $ca->sub_users();

		foreach($sub_accounts as $sub_account) {

		  $csv_results[] = array(

			'Owner Name'         => $ca_owner->full_name(),

			'Owner Email'        => $ca_owner->user_email,			  

			'Subacc. Email'      => $sub_account->user_email,

			'Subacc. Username'   => $sub_account->user_login,

			'Subacc. First Name' => $sub_account->first_name,

			'Subacc. Last Name'  => $sub_account->last_name,

		  );

		}

	}

	$filename = 'subaccounts-'.time();

	MeprUtils::render_csv( $csv_results, $filename );

});