WC_Customer_Download_Data_Store::get_downloads_for_customer( int $customer_id )
Get a customers downloads.
Description Description
Parameters Parameters
- $customer_id
-
(Required) Customer ID.
Return Return
(array)
Source Source
File: includes/data-stores/class-wc-customer-download-data-store.php
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' ) )
)
);
}