支付宝即时到账批量退款接口详解及安全规则

需积分: 22 10 下载量 193 浏览量 更新于2024-09-15 收藏 326KB PDF 举报
即时到账批量退款有密接口(refund_fastpay_by_platform_pwd)是支付宝提供的一个高级服务,旨在实现实时退款功能,特别适用于对资金流转速度有高要求的商户。这个接口允许商户通过平台专用的密码进行操作,以确保交易的安全性和合规性。 文档说明部分详细阐述了该接口的使用背景和目的,强调了其在技术接入和使用中的重要性。商户在操作前需要理解文档内容,以避免潜在风险。文档提供了详细的业务术语定义,如“请求”和“返回”,以及“敏感词”和“特殊字符”的概念,这些都是接口操作的基础知识。 在责任归属方面,文档明确了商户在接入和使用过程中的责任。商户必须确保配置的合作者身份ID和安全校验码key与签约信息一致,以防止接口使用问题和资金损失。同时,商户需要妥善保护这些关键信息,防止账户被非法利用,保障资金安全。 技术接入规则规定了严格的准入标准,例如账号的验证流程,目的是为了防止由于信息不匹配或安全漏洞造成的接口故障和资金风险。商户在接入时必须严格按照支付宝提供的官方文档、代码示例和接入指南操作,否则由接口不当使用产生的风险和后果,商户需自行承担。 即时到账批量退款有密接口是一个需要商户高度关注和谨慎操作的服务,因为它涉及资金流转和信息安全。通过遵循文档中的规则,商户能够确保快速、安全地进行退款操作,同时最大限度地降低潜在风险。

SELECT t1.supplier_id, t1.ky_count, t1.ky_amount, IFNULL(t2.ky_refund_count,0) as ky_refund_count, IFNULL(t2.ky_refund_amount,0) as ky_refund_amount FROM ( SELECT a.supplier_id, count( DISTINCT c.order_no ) AS ky_count, SUM( IFNULL( c.record_amount, 0 )) / 100 AS ky_amount FROM settle_order a INNER JOIN settle_order_receipt b ON a.order_id = b.order_id INNER JOIN cash_withdrawal_record c ON b.third_trade_no = c.order_no WHERE a.is_del = 0 AND a.order_time >= '2023-05-28 00:00:00' AND a.order_time < '2023-05-29 00:00:00' AND a.order_type in (70,75) AND a.supplier_id IN (78,63,58,57,64,72,71,74,83,77,70,69,67,82,65,87,73,59,66,60,86,85,79,80,84,90) AND b.channel_code = 61 AND c.con_bank_account_no IN ( 247, 325 ) AND c.record_status = 1 AND c.record_time > '2023-05-01 00:00:00' GROUP BY a.supplier_id ) t1 LEFT JOIN ( SELECT a.supplier_id, count( DISTINCT b.order_no ) AS ky_refund_count, SUM( IFNULL( b.record_amount, 0 )) / 100 AS ky_refund_amount FROM settle_order_refund a INNER JOIN cash_withdrawal_record b ON a.third_refund_id = b.order_no WHERE a.is_del = 0 AND a.order_type in (70,75) AND a.apply_time >= '2023-05-28 00:00:00' AND a.apply_time < '2023-05-29 00:00:00' AND a.supplier_id IN (78,63,58,57,64,72,71,74,83,77,70,69,67,82,65,87,73,59,66,60,86,85,79,80,84,90) AND a.channel_code = 61 AND b.con_bank_account_no IN ( 247, 325 ) AND b.record_status = 5 AND b.record_time > '2023-05-01 00:00:00' GROUP BY a.supplier_id ) t2 ON t1.supplier_id = t2.supplier_id order by t1.supplier_id asc

2023-06-10 上传