样本智能分析平台优惠卷

def validate_coupon(coupon_code, user_info, order_total):
    # 模拟数据库查询优惠券信息
    coupon_info = get_coupon_info_from_db(coupon_code)
    
    if not coupon_info:
        return "优惠券不存在"
    
    if coupon_info['expiry_date'] < datetime.now():
        return "优惠券已过期"
    
    if coupon_info['min_purchase'] > order_total:
        return "订单金额未达到使用条件"
    
    if coupon_info['user_type'] != user_info['user_type']:
        return "用户类型不符"
    
    # 计算抵扣金额
    discount_amount = order_total * (coupon_info['discount_rate'] / 100)
    return f"优惠券有效，抵扣金额: {discount_amount}"

def get_coupon_info_from_db(coupon_code):
    # 模拟从数据库获取优惠券信息
    # 实际应用中应连接数据库查询
    coupons = {
        'SAVE20': {'expiry_date': datetime(2023, 12, 31), 'min_purchase': 100, 'discount_rate': 20, 'user_type': 'new'},
        'DISCOUNT50': {'expiry_date': datetime(2023, 11, 30), 'min_purchase': 500, 'discount_rate': 10, 'user_type': 'all'}
    }
    return coupons.get(coupon_code, None)