如何在WooCommerce 3中获取客户已支付订单的总金额

Alright, let's fix this discount eligibility logic. The main issue right now is that your code only grabs the current order's amount, but we need to tally up all the customer's fully paid orders to see if they hit that 50k threshold for the 50% discount. Here's how to adjust this:

First, you need to access the customer's order history and filter for orders that are actually paid. The exact status value will depend on your system—could be 'paid', 'completed', 'settled', etc. Make sure you exclude canceled, pending, or refunded orders from this calculation.

Replace the code that fetches just the current order amount with logic that sums all qualifying paid orders. Below are examples for common tech stacks:

SQL Backend Example #

If you're working directly with SQL, use an aggregate query to get the total:

SELECT SUM(order_total) AS total_paid
FROM customer_orders
WHERE customer_id = ? 
  AND order_status = 'paid'; -- Update this to match your system's paid status

Python (Django ORM) Example #

For Django projects, leverage the ORM to safely compute the total:

from myapp.models import Order

def get_customer_total_paid(customer):
    # Sum all paid orders, default to 0 if no orders exist
    total = Order.objects.filter(
        customer=customer,
        status='paid'
    ).aggregate(total_paid=models.Sum('total'))['total_paid'] or 0
    return total

JavaScript (Node.js + MongoDB) Example #

If you're using MongoDB with Node.js, use the aggregation pipeline:

async function getCustomerTotalPaid(customerId) {
    const result = await db.collection('orders').aggregate([
        { $match: { customerId: customerId, status: 'paid' } },
        { $group: { _id: null, totalPaid: { $sum: '$amount' } } }
    ]).toArray();
    return result.length > 0 ? result[0].totalPaid : 0;
}

Once you have the total paid amount, add the check to apply the 50% discount when it exceeds 50k:

# Using the Django function above
customer_total = get_customer_total_paid(current_customer)
discount_rate = 0.5 if customer_total > 50000 else 0
final_order_amount = current_order.total * (1 - discount_rate)

• Handle Edge Cases: Always account for customers with no paid orders (hence the or 0 in examples) to prevent None or undefined errors.
• Optimize Performance: If you have high-volume data, consider caching the total paid amount (e.g., with Redis) and updating it whenever a new order is paid—this avoids recalculating the sum every time a customer places an order.
• Validate Status Values: Double-check that your status filter is accurate—you don't want to include partial payments or pending orders in the total.

内容的提问来源于stack exchange，提问作者Muhammad Huzaifa