public function fused_get_all_products_ordered_by_user($user_id = false, $status = 'completed')
{
//echo "hiiiii".$user_id;
//exit();
$orders = Wooclass::fused_get_all_user_orders($user_id, $status);
//print_r($orders);
if (empty($orders)) {
return false;
}
$order_list = '(' . join(',', $orders) . ')';
//let us make a list for query
global $wpdb;
$query_select_order_items = "SELECT order_item_id as id FROM {$wpdb->prefix}woocommerce_order_items WHERE order_id IN {$order_list}";
$query_select_product_ids = "SELECT meta_value as product_id FROM {$wpdb->prefix}woocommerce_order_itemmeta WHERE meta_key=%s AND order_item_id IN ({$query_select_order_items})";
//echo "SELECT meta_value as product_id FROM {$wpdb->prefix}woocommerce_order_itemmeta WHERE meta_key=%s AND order_item_id IN ($query_select_order_items)";
//echo "hiiiiiiii".$query_select_product_ids;
$products = $wpdb->get_col($wpdb->prepare($query_select_product_ids, '_product_id'));
//print_r($products);
return $products;
}
