taobao.item_fee API:精准计算快递费用,提升用户购物体验

taobao.item_fee API 允许淘宝/天猫的开发者根据商品ID、收货地址等信息,精确计算商品的快递费用,这对于提升用户的购物体验至关重要,因为用户能够在购物过程中获得实时的运费估算,从而做出更明智的购买决策。

以下是一个使用 taobao.item_fee API 进行快递费用计算的示例代码(以 Python 为例):

import requests  
import json  
  
# 替换为你的App Key和App Secret  
APP_KEY = '你的AppKey'  
APP_SECRET = '你的AppSecret'  
SESSION_KEY = '你的SessionKey'  
  
# 商品ID和收货地址信息  
ITEM_ID = '商品ID'  
DEST_CITY = '目的地城市'  
DEST_POSTCODE = '目的地邮编'  
  
# 请求URL  
url = 'https://gw.api.taobao.com/router/rest'  
  
# 构建请求参数  
params = {  
    'app_key': APP_KEY,  
    'timestamp': int(time.time()),  
    'format': 'json',  
    'v': '2.0',  
    'sign_method': 'md5',  
    'method': 'taobao.item.fee',  
    'fields': 'fee',  
    'num_iid': ITEM_ID,  
    'dest_id': DEST_CITY,  
    'post_fee': '1',  
    'is_logistics_online': 'true',  
    'session': SESSION_KEY,  
    # 其他可能的参数...  
}  
  
# 生成签名  
from hashlib import md5  
import time  
  
def get_sign(params
PROCEDURE PROC_SETT_ADJUST_CHECK(P_ID IN t_Settlement_adjust.Id_t_Settlement_Adjust%TYPE, P_STATUS IN VARCHAR2) IS cursor cur_get_adjust_info is select * from t_settlement_adjust a where a.id_t_settlement_adjust = P_ID; cursor cur_old_charge_info(c_charge_id number) is select * from t_gls_commision_fee a where a.charge_id = c_charge_id; cursor cur_old_fee_info(c_charge_id number) is select * from t_agency_commision_fee a where a.related_id = c_charge_id; r_get_adjust_info cur_get_adjust_info%ROWTYPE; r_charge_info cur_old_charge_info%ROWTYPE; r_fee_info cur_old_fee_info%ROWTYPE; v_charge_id t_gls_commision_fee.charge_id%TYPE; v_old_charge_id t_gls_commision_fee.charge_id%TYPE; v_fee_amount t_gls_commision_fee.fee_amount%TYPE; BEGIN update t_settlement_adjust a set a.status = P_STATUS where a.id_t_settlement_adjust = P_ID; IF P_STATUS = '2' THEN return; else open cur_get_adjust_info; fetch cur_get_adjust_info into r_get_adjust_info; open cur_old_charge_info(r_get_adjust_info.charge_id); fetch cur_old_charge_info into r_charge_info; select S_AGENCY_COMM_CHARGE__ID.NEXTVAL into v_charge_id from dual; --调整需要对冲,追加不需要 if r_get_adjust_info.alter_type = '2' then v_old_charge_id := r_charge_info.charge_id; r_charge_info.charge_id := v_charge_id; r_charge_info.policy_year := r_get_adjust_info.policy_year; r_charge_info.commision_type := r_get_adjust_info.alter_type; v_fee_amount := r_charge_info.fee_amount; r_charge_info.fee_amount := -v_fee_amount; r_charge_info.commision := -r_charge_info.commision; r_charge_info.fee_status := 0; r_charge_info.policy_period := r_get_adjust_info.policy_period; r_charge_info.adjust_charge_id := r_get_adjust_info.charge_id; insert into t_gls_commision_fee values r_charge_info; --处理财务数据 open cur_old_fee_info(v_old_charge_id); fetch cur_old_fee_info into r_fee_info; r_fee_info.agency_fee_id := S_AGENCY_COMM_FEE__ID.NEXTVAL; r_fee_info.money := -r_fee_info.money; r_fee_info.related_id := v_charge_id; r_fee_info.finish_time := sysdate; r_fee_info.insert_time := sysdate; r_fee_info.update_time := sysdate; r_fee_info.posted := 'N'; r_fee_info.policy_year := r_get_adjust_info.policy_year; r_fee_info.policy_period := r_get_adjust_info.policy_period; insert into t_agency_commision_fee values r_fee_info; close cur_old_fee_info; end if; if r_get_adjust_info.adjust_rate != 0 then v_old_charge_id := nvl(v_old_charge_id, r_charge_info.charge_id); select S_AGENCY_COMM_CHARGE__ID.NEXTVAL into v_charge_id from dual; r_charge_info.charge_id := v_charge_id; r_charge_info.policy_year := r_get_adjust_info.policy_year; r_charge_info.commision_type := r_get_adjust_info.alter_type; r_charge_info.rate := r_get_adjust_info.adjust_rate; r_charge_info.fee_amount := nvl(v_fee_amount, r_charge_info.fee_amount); r_charge_info.commision := round(nvl(v_fee_amount, r_charge_info.fee_amount) * r_get_adjust_info.adjust_rate, 2); r_charge_info.fee_status := 0; r_charge_info.policy_period := r_get_adjust_info.policy_period; r_charge_info.adjust_charge_id := r_get_adjust_info.charge_id; insert into t_gls_commision_fee values r_charge_info; open cur_old_fee_info(v_old_charge_id); fetch cur_old_fee_info into r_fee_info; r_fee_info.agency_fee_id := S_AGENCY_COMM_FEE__ID.NEXTVAL; r_fee_info.money := round(nvl(v_fee_amount, r_charge_info.fee_amount) * r_get_adjust_info.adjust_rate, 2); r_fee_info.related_id := v_charge_id; r_fee_info.finish_time := sysdate; r_fee_info.insert_time := sysdate; r_fee_info.update_time := sysdate; r_fee_info.posted := 'N'; r_fee_info.policy_year := r_get_adjust_info.policy_year; r_fee_info.policy_period := r_get_adjust_info.policy_period; insert into t_agency_commision_fee values r_fee_info; close cur_old_fee_info; end if; close cur_old_charge_info; close cur_get_adjust_info; END IF; exception when others then ROLLBACK; update t_settlement_adjust a set a.status = '3' where a.id_t_settlement_adjust = P_ID; END PROC_SETT_ADJUST_CHECK; r_get_adjust_info.adjust_rate是要存rate和计算commision、money的100倍,应该怎么修改代码
最新发布
10-10
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值