10.淘宝天猫相关
10.1 G_Trade_Query(页码,[订单号],[订单状态],[开始时间],[结束时间],[买家眤称])
说明：此api只有企业版才可使用
作用: 订单查询
参数说明：页码: 此api一次只返回一页的订单数据（20条)，若想获取更多，输入页码，多次查询
订单号：指定订单号查询
订单状态：可选值：等待买家付款，买家已付款，卖家已发货，交易成功，交易关闭 中任一
开始时间、结束时间:下单的时间。格式：yyyy-mm-dd hh:mi:ss 例如：2017-07-01 12:01:30
买家眤称：指定买家查询
返回值：订单查询结果，用12.2 G_Trade_GetQueryResult 获取
例子：
Func Example1()
local $queryResult = G_Trade_Query(1)
if @error then
J_MsgBox(J_GetErrorMsg())
return
endif
;结果的提取请查看12.2
EndFunc ;==>Example1
10.2 G_Trade_GetQueryResult(交易订单查询结果,提取值类型,订单序号)
说明：此api只有企业版才可使用
作用: 订单结果提取
参数说明：交易订单查询结果: 10.1的查询结果
提取值类型：总页数，订单个数，订单编号，订单状态，下单时间，付款时间，实收款，邮费，旗帜颜色，备注，买家昵称，发货时间，收货人姓名，收货人地址，收货人手机，子订单数量，子订单商品标题
订单序号:订单查询结果中的第几个订单。 当提取值类型=总页数，订单个数时不需要指定
返回值：返回相应的提取值类型值
旗帜颜色：返回红、黄、蓝、绿、紫、无
交易状态：等待买家付款、买家已付款、卖家已发货、买家已签收、交易成功、交易关闭、交易被淘宝关闭、卖家部分发货
例子:
Func Example2()
local $queryResult = G_Trade_Query(1)
if @error then
J_MsgBox(J_GetErrorMsg())
return
endif
;将查询结果写入excel:
local $oExcel = J_Excel_Create()
J_Excel_Write($oExcel, 1, 1, '订单编号')
J_Excel_Write($oExcel, 1, 2, '订单状态')
J_Excel_Write($oExcel, 1, 3, '下单时间')
J_Excel_Write($oExcel, 1, 4, '付款时间')
J_Excel_Write($oExcel, 1, 5, '实付金额')
J_Excel_Write($oExcel, 1, 6, '邮费')
J_Excel_Write($oExcel, 1, 7, '旗帜颜色')
J_Excel_Write($oExcel, 1, 8, '备注')
J_Excel_Write($oExcel, 1, 9, '买家昵称')
J_Excel_Write($oExcel, 1, 10, '发货时间')
J_Excel_Write($oExcel, 1, 11, '收货人姓名')
J_Excel_Write($oExcel, 1, 12, '收货人地址')
J_Excel_Write($oExcel, 1, 13, '收货人手机')
J_Excel_Write($oExcel, 1, 14, '子订单数量')
J_Excel_Write($oExcel, 1, 15, '子订单商品标题')
local $excelRow = 2;表头是第一行
;获取总页数
local $pageSize = G_trade_getQueryResult($queryResult, '总页数')
j_log('总页数：' & $pageSize)
;第一层循环分页:
for $pageNum = 1 to $pageSize
j_Log('处理页数:' & $pageSize)
;第二层循环读取数据：
local $orderCount = G_trade_getQueryResult($queryResult, '订单个数')
for $orderSeq = 1 to $orderCount
;获取值
local $orderId = G_trade_getQueryResult($queryResult, '订单编号', $orderSeq)
local $orderStatus = G_trade_getQueryResult($queryResult, '订单状态', $orderSeq)
local $createDt = G_trade_getQueryResult($queryResult, '下单时间', $orderSeq)
local $payDt = G_trade_getQueryResult($queryResult, '付款时间', $orderSeq)
local $payMoney = G_trade_getQueryResult($queryResult, '实付金额', $orderSeq)
local $postage = G_trade_getQueryResult($queryResult, '邮费', $orderSeq)
local $flagColor = G_trade_getQueryResult($queryResult, '旗帜颜色', $orderSeq)
local $remark = G_trade_getQueryResult($queryResult, '备注', $orderSeq)
local $buyer = G_trade_getQueryResult($queryResult, '买家昵称', $orderSeq)
local $sendGoodDt = G_trade_getQueryResult($queryResult, '发货时间', $orderSeq)
local $receiverName = G_trade_getQueryResult($queryResult, '收货人姓名', $orderSeq)
local $receiverAddress = G_trade_getQueryResult($queryResult, '收货人地址', $orderSeq)
local $receiverPhone = G_trade_getQueryResult($queryResult, '收货人手机', $orderSeq)
local $subOrderCount = G_trade_getQueryResult($queryResult, '子订单数量', $orderSeq)
local $subOrderTitle = G_trade_getQueryResult($queryResult, '子订单商品标题', $orderSeq)
J_Excel_Write($oExcel, $excelRow, 1, $orderId)
J_Excel_Write($oExcel, $excelRow, 2, $orderStatus)
J_Excel_Write($oExcel, $excelRow, 3, $createDt)
J_Excel_Write($oExcel, $excelRow, 4, $payDt)
J_Excel_Write($oExcel, $excelRow, 5, $payMoney)
J_Excel_Write($oExcel, $excelRow, 6, $postage)
J_Excel_Write($oExcel, $excelRow, 7, $flagColor)
J_Excel_Write($oExcel, $excelRow, 8, $remark)
J_Excel_Write($oExcel, $excelRow, 9, $buyer)
J_Excel_Write($oExcel, $excelRow, 10, $sendGoodDt)
J_Excel_Write($oExcel, $excelRow, 11, $receiverName)
J_Excel_Write($oExcel, $excelRow, 12, $receiverAddress)
J_Excel_Write($oExcel, $excelRow, 13, $receiverPhone)
J_Excel_Write($oExcel, $excelRow, 14, $subOrderCount)
J_Excel_Write($oExcel, $excelRow, 15, $subOrderTitle)
$excelRow += 1
next
;下一页结果查询
if $pageNum < $pageSize then
$queryResult = G_Trade_Query($pageNum+1)
endif
next
J_Excel_save($oExcel, @desktopdir & '\order.xlsx')
j_excel_close($oExcel)
EndFunc ;==>Example2
10.3 G_Trade_Memo(订单编号，备注信息，旗帜颜色，动作[追加/覆盖])
说明：此api只有企业版才可使用
作用: 修改订单备注（追加、覆盖）
参数说明:旗帜颜色：可空，若不空，填写：红、黄、蓝、绿、紫。若空，不修改旗帜的颜色
动作：追加-备注信息添加到原备注内容后。 覆盖-用备注信息替换原备注内容
返回值：0失败，1成功
例子：
Func Example3()
local $result = G_Trade_Memo('41059511420334262', '已沟通add by叶子', '红','追加')
if $result = 0 then
j_log('修改备注失败:' & J_GetErrorMsg())
endif
endfunc;==>Example3
10.4 G_Trade_DelayReceiveTime(订单编号，延长时长)
说明：此api只有企业版才可使用
作用: 延长收货时长
参数说明:：延长时长:单位天。可选值 3,5,7,10
返回值：0失败，1成功
例子：
Func Example4()
local $result = G_Trade_DelayReceiveTime('41465828873334262', 3)
if $result = 0 then
j_log('修改收货时长失败:' & J_GetErrorMsg())
endif
endfunc;==>Example4
10.5 G_Refund_Query(页码,[退款编号],[退款状态],[开始时间],[结束时间],[买家眤称])
说明：此api只有企业版才可使用
作用: 退款订单查询
参数说明：页码: 此api一次只返回一页的订单数据（20条)，若想获取更多，输入页码，多次查询
退款编写：指定退款编号查询
退款状态：可选值：退款待处理，待买家发货，待商家收货，已拒绝退款，退款关闭 退款成功 中任一
开始时间、结束时间:下单的时间。格式：yyyy-mm-dd hh:mi:ss 例如：2017-07-01 12:01:30
买家眤称：指定买家查询
返回值：订单查询结果，用12.6 G_Refund_GetQueryResult 获取
例子：
Func Example5()
local $queryResult = G_Refund_Query(1)
if @error then
J_MsgBox(J_GetErrorMsg())
return
endif
;结果的提取请查看12.2
EndFunc ;==>Example5
10.6 G_Refund_GetQueryResult(退款订单查询结果,提取值类型,订单序号)
说明：此api只有企业版才可使用
作用: 退款订单结果提取
参数说明：退款订单查询结果: 10.5的查询结果
提取值类型：总页数，订单个数，退款编号，订单号，交易金额，退款金额，买家昵称，申请时间，退款状态，发货状态
是否需要退货，退款原因，退款说明，退款阶段，商品标题，商品SKU，退货物流公司名称，退货运单号，退货时间，卖家收货地址
订单序号:订单查询结果中的第几个订单。 当提取值类型=总页数，订单个数时不需要指定
返回值：返回相应的提取值类型值
退款状态：退款待处理、待买家发货、待商家收货、已拒绝退款、退款关闭、退款成功
退款阶段：售中、售后
例子:
Func Example6()
local $queryResult = G_refund_query(1)
if @error then
J_MsgBox(J_GetErrorMsg())
return
endif
;将查询结果写入excel:
local $oExcel = J_Excel_Create()
J_Excel_Write($oExcel, 1, 1, '退款编号')
J_Excel_Write($oExcel, 1, 2, '订单号')
J_Excel_Write($oExcel, 1, 3, '交易金额')
J_Excel_Write($oExcel, 1, 4, '退款金额')
J_Excel_Write($oExcel, 1, 5, '买家昵称')
J_Excel_Write($oExcel, 1, 6, '申请时间')
J_Excel_Write($oExcel, 1, 7, '退款状态')
J_Excel_Write($oExcel, 1, 8, '发货状态')
J_Excel_Write($oExcel, 1, 9, '是否需要退货')
J_Excel_Write($oExcel, 1, 10, '退款原因')
J_Excel_Write($oExcel, 1, 11, '退款说明')
J_Excel_Write($oExcel, 1, 12, '退款阶段')
J_Excel_Write($oExcel, 1, 13, '商品标题')
J_Excel_Write($oExcel, 1, 14, '商品SKU')
J_Excel_Write($oExcel, 1, 15, '退货物流公司名称')
J_Excel_Write($oExcel, 1, 16, '退货运单号')
J_Excel_Write($oExcel, 1, 17, '退货时间')
J_Excel_Write($oExcel, 1, 18, '卖家收货地址')
local $excelRow = 2;表头是第一行
local $pageSize = G_refund_getQueryResult($queryResult, '总页数')
j_log('总页数：' & $pageSize)
;第一层循环分页:
for $pageNum = 1 to $pageSize
j_Log('处理页数:' & $pageSize)
;第二层循环读取数据：
local $orderCount = G_refund_getQueryResult($queryResult, '退款个数')
j_log('退款个数:' & $orderCount)
for $orderSeq = 1 to $orderCount
;获取值
local $refundId = G_refund_getQueryResult($queryResult, '退款编号', $orderSeq)
local $orderId = G_refund_getQueryResult($queryResult, '订单号', $orderSeq)
local $payMoney = G_refund_getQueryResult($queryResult, '交易金额', $orderSeq)
local $refundMoney = G_refund_getQueryResult($queryResult, '退款金额', $orderSeq)
local $nick = G_refund_getQueryResult($queryResult, '买家昵称', $orderSeq)
local $createDt = G_refund_getQueryResult($queryResult, '申请时间', $orderSeq)
local $refundStatus = G_refund_getQueryResult($queryResult, '退款状态', $orderSeq)
local $goodStatus = G_refund_getQueryResult($queryResult, '发货状态', $orderSeq)
local $isNeedGood = G_refund_getQueryResult($queryResult, '是否需要退货', $orderSeq)
local $refundReason = G_refund_getQueryResult($queryResult, '退款原因', $orderSeq)
local $refundDesc = G_refund_getQueryResult($queryResult, '退款说明', $orderSeq)
local $refundPhase = G_refund_getQueryResult($queryResult, '退款阶段', $orderSeq)
local $offerTitle = G_refund_getQueryResult($queryResult, '商品标题', $orderSeq)
local $offerSky = G_refund_getQueryResult($queryResult, '商品SKU', $orderSeq)
local $refundLogisticsCompary = G_refund_getQueryResult($queryResult, '退货物流公司名称', $orderSeq)
local $refundLogisticsId = G_refund_getQueryResult($queryResult, '退货运单号', $orderSeq)
local $refundDt = G_refund_getQueryResult($queryResult, '退货时间', $orderSeq)
local $returnAddress = G_refund_getQueryResult($queryResult, '卖家收货地址', $orderSeq)
J_Excel_Write($oExcel, $excelRow, 1, $refundId)
J_Excel_Write($oExcel, $excelRow, 2, $orderId)
J_Excel_Write($oExcel, $excelRow, 3, $payMoney)
J_Excel_Write($oExcel, $excelRow, 4, $refundMoney)
J_Excel_Write($oExcel, $excelRow, 5, $nick)
J_Excel_Write($oExcel, $excelRow, 6, $createDt)
J_Excel_Write($oExcel, $excelRow, 7, $refundStatus)
J_Excel_Write($oExcel, $excelRow, 8, $goodStatus)
J_Excel_Write($oExcel, $excelRow, 9, $isNeedGood)
J_Excel_Write($oExcel, $excelRow, 10, $refundReason)
J_Excel_Write($oExcel, $excelRow, 11, $refundDesc)
J_Excel_Write($oExcel, $excelRow, 12, $refundPhase)
J_Excel_Write($oExcel, $excelRow, 13, $offerTitle)
J_Excel_Write($oExcel, $excelRow, 14, $offerSky)
J_Excel_Write($oExcel, $excelRow, 15, $refundLogisticsCompary)
J_Excel_Write($oExcel, $excelRow, 16, $refundLogisticsId)
J_Excel_Write($oExcel, $excelRow, 17, $refundDt)
J_Excel_Write($oExcel, $excelRow, 18, $returnAddress)
$excelRow += 1
next
;下一页结果查询
if $pageNum < $pageSize then
$queryResult = G_refund_query($pageNum+1)
endif
next
J_Excel_save($oExcel, @desktopdir & '\refund.xlsx')
j_excel_close($oExcel)
endfunc
10.7 G_Refund_AgreeRefund(退款编号)
说明：此api只有企业版才可使用
作用: 同意退款
返回值：失败0，成功1
例子:
Func Example7()
local $result = G_Refund_AgreeRefund('2359364023332656')
if $result = 0 then
j_log('同意退款失败：' & J_GetErrorMsg())
endif
endfunc
10.8 G_Refund_Audit(退款编号,是否通过)
说明：此api只有企业版才可使用
作用: 审核退款单
参数说明：是否通过：true,false
返回值：失败0，成功1
例子:
Func Example8()
local $result = G_Refund_Audit('2359364023332656',true) ;通过
if $result = 0 then
j_log('审核退款单失败：' & J_GetErrorMsg())
endif
endfunc
10.9 G_Refund_AddMsg(退款编号,留言内容，留言凭证)
说明：此api只有企业版才可使用
作用: 退款留言
参数说明：留言凭证 : 本地图片
返回值：失败0，成功1
例子:
Func Example9()
local $refundId = '2378207863845705'
G_Refund_AddMsg($refundId, '亲,很快便处理', @desktopdir & '\高级api.png')
if $result = 0 then
j_log('退款留言失败：' & J_GetErrorMsg())
endif
endfunc