WC_Customer_Download_Data_Store::get_downloads_for_customer │ public │ WC 1.0

Get a customers downloads.

Method of the class: WC_Customer_Download_Data_Store{}

No Hooks.

Returns

Array.

Usage

$WC_Customer_Download_Data_Store = new WC_Customer_Download_Data_Store();
$WC_Customer_Download_Data_Store->get_downloads_for_customer( $customer_id );

$customer_id(int) (required)

Customer ID.

WC_Customer_Download_Data_Store::get_downloads_for_customer() WC Customer Download Data Store::get downloads for customer code ^{WC 10.3.3}

public function get_downloads_for_customer( $customer_id ) {
	global $wpdb;

	return $wpdb->get_results(
		$wpdb->prepare(
			"SELECT * FROM {$wpdb->prefix}woocommerce_downloadable_product_permissions as permissions
			WHERE user_id = %d
			AND permissions.order_id > 0
			AND
				(
					permissions.downloads_remaining > 0
					OR permissions.downloads_remaining = ''
				)
			AND
				(
					permissions.access_expires IS NULL
					OR permissions.access_expires >= %s
					OR permissions.access_expires = '0000-00-00 00:00:00'
				)
			ORDER BY permissions.order_id, permissions.product_id, permissions.permission_id;",
			$customer_id,
			date( 'Y-m-d', current_time( 'timestamp' ) )  // phpcs:ignore WordPress.DateTime.RestrictedFunctions.date_date
		)
	);
}