2020-01-10对账单测试流程

请求字段解释： channelType 通道 ：1(微信)，2（支付宝），3（汇付）

bagentId (渠道商号/appId): 取 mypay_oem_channel_config 表bagent_id

汇付通道：

1、先在1.0跑 接口对账单MQ

TP_SC_NSPOSB_TRANS_ORDER_FILE_6116

{"transDate":"20191217"} --后面接跑的日期

B7023交易对账单接口.jmx 这个脚本可以下载对账单文件

校验数据库表是否有值：SELECT * FROM NSPOS_TRANS_ORD_FILE i WHERE i.trans_date ='20190625'; -- 交易对账单文件表

2、在跑2.0的 汇付通道对账MQ：MYPAY_RMS_SCHEDULE_CHINAPNR_VERIFY_TOPIC_TEST

请求地址：

http://192.168.16.107:9999/mypaydcs/task/scheduler?topic=MYPAY_RMS_SCHEDULE_CHINAPNR_VERIFY_TOPIC_TEST&message={"verifyDate":"20191224","bagentId":"030147443000001973","channelType":"3"}

--> 自动触发：对账MQ -- MYPAY_TCF_TMS_REFUND_ASYN_NOTIFY

查看：mypayrms 日志

数据库： mypay_chinapnr_verify_record 、mypay_verify_result_record 校验数据的正确性

交易数据：mypay_ord_log_base、mypay_ref_log

支付宝：

直接请求地址：

http://192.168.16.107:9999/mypaydcs/task/scheduler?topic=MYPAY_RMS_SCHEDULE_ALIPAY_VERIFY_TOPIC_TEST&message={"verifyDate":"20200110","bagentId":"2019091967580486","channelType":"2"}

查看：mypayrms 日志

数据库校验：mypay_alipay_verify_record、mypay_verify_result_record

微信：

直接请求地址：

http://192.168.16.107:9999/mypaydcs/task/scheduler?topic=MYPAY_RMS_SCHEDULE_WECHAT_VERIFY_TOPIC_TEST&message={"verifyDate":"20191224","bagentId":"wxd1dd2568e271839c","channelType":"1"}

查看：mypayrms 日志

数据库校验：mypay_weichart_verify_record、mypay_verify_result_record

MYPAY_TCF_TMS_REFUND_ASYN_NOTIFY -- 中间对账MQ

YPAY_TCF_WECHAR_VERIFY_NOTIFY_TOPIC_DEV

http://192.168.16.107:9999/mypaydcs/task/scheduler?topic=MYPAY_TCF_TMS_REFUND_ASYN_NOTIFY&message={"notifyBody":"{"bagentId":"2019091967580486","channelType":"2","verifyDate":"20191121"}","notifyType":12,"ordId":"2019091967580486","traceNo":"668c0483f083473f9fa26413a4119e3e","unitId":"C0"}

http://192.168.16.107:9999/mypaydcs/task/scheduler?topic=MYPAY_TCF_TMS_REFUND_ASYN_NOTIFY&message={"notifyBody":"{"bagentId":"030147443000001973","channelType":"3","verifyDate":"20191218"}","notifyType":12,"ordId":"030147443000001973","traceNo":"mypaytcf-c0a819ad-437979-2186","unitId":"C0"}

--汇付：

{"notifyBody":"{"bagentId":"030147443000001973","channelType":"3","downloadUrl":"http://jarvisfile-test.oss-cn-shanghai.aliyuncs.com/app-a8187ae7-5671-4888-4321-2cc8c4d476ba%2F0cd67476-216b-11ea-9ccd-0242ac110005.zip?OSSAccessKeyId=LTAIazOFLTVBmUh9&Expires=1576730228&Signature=Qy%2FJ1xJRLMFQjhGP7obB7YqOSzs%3D","verifyDate":"20191218"}","notifyType":10,"traceNo":"mypaytcf-c0a819ad-437979-2186","unitId":"A0"}

http://192.168.16.107:9999/mypaydcs/task/scheduler?topic=MYPAY_TCF_TMS_REFUND_ASYN_NOTIFY&message={"notifyBody":"{"bagentId":"030147443000001973","channelType":"3","verifyDate":"20191218"}","notifyType":12,"ordId":"030147443000001973","traceNo":"mypaytcf-c0a819ad-438003-1505","unitId":"C0"}

--支付宝

{"notifyBody":"{"bagentId":"2019091967580486","channelType":"2","verifyDate":"20191219"}","notifyType":12,"ordId":"2019091967580486","traceNo":"9dbeebe46fc7428a9046fe31efcfe665","unitId":"C0"}

注意金额：下单金额，结算金额，手续费，退款金额，现金支付金额