[2018-10-29 17:36:55][DEBUG][PaymentRepayConfirmServiceImpl.java:133] 还款确认--数据验证--开始处理
[2018-10-29 17:36:55][DEBUG][PaymentRepayConfirmServiceImpl.java:134] 还款确认--数据验证--1、判断当前期的还款是否还款或其它还款方式已经存在
[2018-10-29 17:36:55][DEBUG][PaymentRepayConfirmServiceImpl.java:146] 还款确认--验证是否可以还款--查询本次还款跟踪表
[2018-10-29 17:36:55][DEBUG][PaymentRepayConfirmServiceImpl.java:175] 还款确认--数据验证--2、读取实际还款费用
[2018-10-29 17:36:55][DEBUG][PaymentRepayConfirmServiceImpl.java:181] 还款确认--数据验证--3、读取还款计划
[2018-10-29 17:36:55][DEBUG][PaymentRepayConfirmServiceImpl.java:190] 还款确认--数据验证--4、验证还款总金额
[2018-10-29 17:36:55][DEBUG][PaymentRepayConfirmServiceImpl.java:214] 还款确认--数据验证--5、验证还款的产品
[2018-10-29 17:36:55][DEBUG][PaymentRepayConfirmServiceImpl.java:225] 还款确认--数据验证--6、验证还款的还款人
[2018-10-29 17:36:55][DEBUG][PaymentRepayConfirmServiceImpl.java:230] 还款确认--数据验证--7、验证还款的出借者收益数据
[2018-10-29 17:36:56][DEBUG][PaymentRepayConfirmServiceImpl.java:236] 还款确认--数据验证--8、统计额外费用项
[2018-10-29 17:36:56][DEBUG][PaymentRepayConfirmServiceImpl.java:249] 还款确认--数据验证--9、是否最后一期判断
[2018-10-29 17:36:56][DEBUG][PaymentRepayConfirmServiceImpl.java:254] 还款确认--数据验证--10、验证余额是否足够--NODO
[2018-10-29 17:36:56][DEBUG][PaymentRepayConfirmServiceImpl.java:258] 还款确认--数据验证--20、验证产品是否有债权转让
[2018-10-29 17:36:56][DEBUG][PaymentRepayConfirmServiceImpl.java:274] 还款确认--数据验证--处理结束
[2018-10-29 17:36:56][DEBUG][PaymentRepayConfirmServiceImpl.java:377] 构建还款数据--开始循环收款表数据
[2018-10-29 17:36:56][DEBUG][PaymentRepayConfirmServiceImpl.java:503] 封装分润数据 investMember.memberId=246c9bfa0adc442fbdb0cb5fca7c7d43, 分润总额=30528.00
[2018-10-29 17:36:56][DEBUG][PaymentRepayConfirmServiceImpl.java:503] 封装分润数据 investMember.memberId=246c9bfa0adc442fbdb0cb5fca7c7d43, 分润总额=167.90
[2018-10-29 17:36:56][DEBUG][PaymentRepayConfirmServiceImpl.java:503] 封装分润数据 investMember.memberId=cd6f063826c44d55acd19997b2609cf0, 分润总额=22584.61
[2018-10-29 17:36:56][DEBUG][PaymentRepayConfirmServiceImpl.java:503] 封装分润数据 investMember.memberId=0b622868900f45f78ca51dcc5590e1ce, 分润总额=10675.64
[2018-10-29 17:36:56][DEBUG][PaymentRepayConfirmServiceImpl.java:503] 封装分润数据 investMember.memberId=d9d5c638f85a4e0e9ce97a87af39214b, 分润总额=16531.93
[2018-10-29 17:36:56][DEBUG][PaymentRepayConfirmServiceImpl.java:503] 封装分润数据 investMember.memberId=8a9aee2d630b634801643b268c66301c, 分润总额=20352.00
[2018-10-29 17:36:56][DEBUG][PaymentRepayConfirmServiceImpl.java:503] 封装分润数据 investMember.memberId=fdb3947e19fd4241a1bd5c47bd352877, 分润总额=3744.77
[2018-10-29 17:36:56][DEBUG][PaymentRepayConfirmServiceImpl.java:503] 封装分润数据 investMember.memberId=d095fc3f82064333b21c3955f7887e72, 分润总额=3084.35
[2018-10-29 17:36:56][DEBUG][PaymentRepayConfirmServiceImpl.java:503] 封装分润数据 investMember.memberId=5778330e21a44f9087fa6eae9408da62, 分润总额=51405.08
[2018-10-29 17:36:56][DEBUG][PaymentRepayConfirmServiceImpl.java:503] 封装分润数据 investMember.memberId=8dc3547daa114b73899f31459e072013, 分润总额=40979.77
[2018-10-29 17:36:56][DEBUG][PaymentRepayConfirmServiceImpl.java:507] 还款确认:订单循环完毕
[2018-10-29 17:36:56][DEBUG][PaymentRepayConfirmServiceImpl.java:331] 调用PayAPI还款接口准备:RepaysRequest={"amount":200054.05,"callbackHost":"http://10.26.111.63:8780/pay/czbankCallback","complete":"1","memberAccount":"p1350","memberBankNo":"持卡人名称","memberIdCard":"500103001866567","memberKind":"11","memberRealName":"781011520000004322","period":1,"productCd":"P-180720135005655369","productId":"P-180720135005655369","projectName":"银票宝10024期","repayDate":1540805066000,"returnUrl":"","tradeDataList":[{"amount":"30528.00","currentOutsideOrderNo":"PJK2018102917242600104","currentOutsideSerialNo":"PJK2018102917242600103","extraInterest":"0","fee":"0","inAccount":"PP201704171718210007829534","inBankNo":"6210193310201761557","inIdCard":"32048119830404221X","inMemberId":"246c9bfa0adc442fbdb0cb5fca7c7d43","inMemberKind":"0","inRealName":"梁涛","orderId":"8a9aee2d630b63480164b6447e7f5e94","outAccount":"p1350","outBankNo":"695603432","outIdCard":"500103001866567","outMemberId":"ff8080814faaed76014fabcbf1a40030","outMemberKind":"11","outRealName":"平台账户","outsideOrderDate":"20180720","outsideOrderNo":"PJK2018072013581965335","outsideSerialNo":"PT1807230003961945","payType":"2","resultStatus":0,"shareProfitDatas":[]},{"amount":"167.90","currentOutsideOrderNo":"PJK2018102917242600105","currentOutsideSerialNo":"PJK2018102917242600103","extraInterest":"0","fee":"0","inAccount":"PP201704171718210007829534","inBankNo":"6210193310201761557","inIdCard":"32048119830404221X","inMemberId":"246c9bfa0adc442fbdb0cb5fca7c7d43","inMemberKind":"0","inRealName":"梁涛","orderId":"8a9aee2d630b63480164b646029a5e9b","outAccount":"p1350","outBankNo":"695603432","outIdCard":"500103001866567","outMemberId":"ff8080814faaed76014fabcbf1a40030","outMemberKind":"11","outRealName":"平台账户","outsideOrderDate":"20180720","outsideOrderNo":"PJK2018072013595865343","outsideSerialNo":"PT1807230003961949","payType":"2","resultStatus":0,"shareProfitDatas":[]},{"amount":"22584.61","currentOutsideOrderNo":"PJK2018102917242600106","currentOutsideSerialNo":"PJK2018102917242600103","extraInterest":"0","fee":"0","inAccount":"PP201703201156430007313774","inBankNo":"6210193310201465597","inIdCard":"120104195807180817","inMemberId":"cd6f063826c44d55acd19997b2609cf0","inMemberKind":"0","inRealName":"刘啟明","orderId":"8a9aee2d630b63480164b6505d975ea4","outAccount":"p1350","outBankNo":"695603432","outIdCard":"500103001866567","outMemberId":"ff8080814faaed76014fabcbf1a40030","outMemberKind":"11","outRealName":"平台账户","outsideOrderDate":"20180720","outsideOrderNo":"PJK2018072014111765357","outsideSerialNo":"PT1807230003961942","payType":"2","resultStatus":0,"shareProfitDatas":[]},{"amount":"10675.64","currentOutsideOrderNo":"PJK2018102917242600107","currentOutsideSerialNo":"PJK2018102917242600103","extraInterest":"0","fee":"0","inAccount":"PP201703201055280007309993","inBankNo":"6210193310201463816","inIdCard":"510402197111240928","inMemberId":"0b622868900f45f78ca51dcc5590e1ce","inMemberKind":"0","inRealName":"李莉","orderId":"8a9aee2d630b63480164b676740c5ee3","outAccount":"p1350","outBankNo":"695603432","outIdCard":"500103001866567","outMemberId":"ff8080814faaed76014fabcbf1a40030","outMemberKind":"11","outRealName":"平台账户","outsideOrderDate":"20180720","outsideOrderNo":"PJK2018072014525365404","outsideSerialNo":"PT1807230003961948","payType":"2","resultStatus":0,"shareProfitDatas":[]},{"amount":"16531.93","currentOutsideOrderNo":"PJK2018102917242600108","currentOutsideSerialNo":"PJK2018102917242600103","extraInterest":"0","fee":"0","inAccount":"PP201704171632400007826679","inBankNo":"6210193310201760849","inIdCard":"511002196508172526","inMemberId":"d9d5c638f85a4e0e9ce97a87af39214b","inMemberKind":"0","inRealName":"吕成琼","orderId":"8a9aee2d630b63480164b69e06345f25","outAccount":"p1350","outBankNo":"695603432","outIdCard":"500103001866567","outMemberId":"ff8080814faaed76014fabcbf1a40030","outMemberKind":"11","outRealName":"平台账户","outsideOrderDate":"20180720","outsideOrderNo":"PJK2018072015360665440","outsideSerialNo":"PT1807230003961943","payType":"2","resultStatus":0,"shareProfitDatas":[]},{"amount":"20352.00","currentOutsideOrderNo":"PJK2018102917242600109","currentOutsideSerialNo":"PJK2018102917242600103","extraInterest":"0","fee":"0","inAccount":"PP201806262137590057746036","inBankNo":"6210193310207715342","inIdCard":"130302197802213551","inMemberId":"8a9aee2d630b634801643b268c66301c","inMemberKind":"0","inRealName":"王兆杰","orderId":"8a9aee2d630b63480164b6a6f35d5f31","outAccount":"p1350","outBankNo":"695603432","outIdCard":"500103001866567","outMemberId":"ff8080814faaed76014fabcbf1a40030","outMemberKind":"11","outRealName":"平台账户","outsideOrderDate":"20180720","outsideOrderNo":"PJK2018072015455165458","outsideSerialNo":"PT1807230003961940","payType":"2","resultStatus":0,"shareProfitDatas":[]},{"amount":"3744.77","currentOutsideOrderNo":"PJK2018102917242600110","currentOutsideSerialNo":"PJK2018102917242600103","extraInterest":"0","fee":"0","inAccount":"PP201704111544090007708318","inBankNo":"6210193310201695771","inIdCard":"320681198207101020","inMemberId":"fdb3947e19fd4241a1bd5c47bd352877","inMemberKind":"0","inRealName":"朱海燕","orderId":"8a9aee2d630b63480164b6c18b785f3e","outAccount":"p1350","outBankNo":"695603432","outIdCard":"500103001866567","outMemberId":"ff8080814faaed76014fabcbf1a40030","outMemberKind":"11","outRealName":"平台账户","outsideOrderDate":"20180720","outsideOrderNo":"PJK2018072016145465502","outsideSerialNo":"PT1807230003961947","payType":"2","resultStatus":0,"shareProfitDatas":[]},{"amount":"3084.35","currentOutsideOrderNo":"PJK2018102917242600111","currentOutsideSerialNo":"PJK2018102917242600103","extraInterest":"0","fee":"0","inAccount":"PP201703211738120007344095","inBankNo":"6210193310201486130","inIdCard":"420683198403242839","inMemberId":"d095fc3f82064333b21c3955f7887e72","inMemberKind":"0","inRealName":"张俊楠","orderId":"8a9aee2d630b63480164b6c812515f47","outAccount":"p1350","outBankNo":"695603432","outIdCard":"500103001866567","outMemberId":"ff8080814faaed76014fabcbf1a40030","outMemberKind":"11","outRealName":"平台账户","outsideOrderDate":"20180720","outsideOrderNo":"PJK2018072016220265528","outsideSerialNo":"PT1807230003961944","payType":"2","resultStatus":0,"shareProfitDatas":[]},{"amount":"51405.08","currentOutsideOrderNo":"PJK2018102917242600112","currentOutsideSerialNo":"PJK2018102917242600103","extraInterest":"0","fee":"0","inAccount":"PP201703281506180007468458","inBankNo":"6210193310201564720","inIdCard":"610404198405311024","inMemberId":"5778330e21a44f9087fa6eae9408da62","inMemberKind":"0","inRealName":"周赟","orderId":"8a9aee2d630b63480164b6c8d8405f48","outAccount":"p1350","outBankNo":"695603432","outIdCard":"500103001866567","outMemberId":"ff8080814faaed76014fabcbf1a40030","outMemberKind":"11","outRealName":"平台账户","outsideOrderDate":"20180720","outsideOrderNo":"PJK2018072016225365535","outsideSerialNo":"PT1807230003961950","payType":"2","resultStatus":0,"shareProfitDatas":[]},{"amount":"40979.77","currentOutsideOrderNo":"PJK2018102917242600113","currentOutsideSerialNo":"PJK2018102917242600103","extraInterest":"0","fee":"0","inAccount":"PP201704061605070007616385","inBankNo":"6210193310201644043","inIdCard":"372328197301200103","inMemberId":"8dc3547daa114b73899f31459e072013","inMemberKind":"0","inRealName":"王敏","orderId":"8a9aee2d630b63480164b6db484c5f50","outAccount":"p1350","outBankNo":"695603432","outIdCard":"500103001866567","outMemberId":"ff8080814faaed76014fabcbf1a40030","outMemberKind":"11","outRealName":"平台账户","outsideOrderDate":"20180720","outsideOrderNo":"PJK2018072016430165558","outsideSerialNo":"PT1807230003961951","payType":"2","resultStatus":0,"shareProfitDatas":[]}],"unFreezeId":"PJK2018102917242600102"}
[2018-10-29 17:36:56][DEBUG][CzbRepayServiceImpl.java:238] 浙商银行接口--还款申请--处理开始
[2018-10-29 17:36:56][DEBUG][CzbRepayServiceImpl.java:251] 浙商银行接口--还款申请--第一步,验证是否包含还款数据
[2018-10-29 17:36:56][DEBUG][CzbRepayServiceImpl.java:256] 浙商银行接口--还款申请--第二步,通过对账查询浙商银行是否转账--处理开始
[2018-10-29 17:36:56][DEBUG][XMLUtils.java:165] 生成请求报文--reqMessage:
1.0.0
PJK
0020
20181029 17:36:56
PJK2018102917242600104
6
1
[2018-10-29 17:36:56][DEBUG][CzbQueryServiceImpl.java:70] 单笔流水查询--HttpClient请求结果:1.0.0CZBANK000160000无相应记录无相应记录
p4Ddqso1fnLDQigi/gAfFHcyx7g=
l9H907jVCiMAJzMyh5NsAqxyPJ/fz6HqRbDhBWM9zBEqPOZgoK8/+FTmU6IerjlJiGuoMtR2f3Tp
m8OvqbqUW+VDkdlHw+Z4yIEBzE+6O7PvQGoXB5T3Zp3VbtUV7Bjx7a2edKPd4/4ohlLsOtJL5EgO
yCJQMd05WQHotm9WdmgL+iTinKxPAyAyXQreIr4RgsHQJpfRj1ql2VNrvhIm1GZ9fSzXoHforghY
PJeUakAaiG70xDLsapa4qLrC3w4YVMGvILISszn13lL5+5Q9Pa+E705LycfoDbZQNHoYRKfujgNh
gmoKEU+ngRfTXLxdbgUkK57bkpHAKcsuuJZ5IQ==
---------
[2018-10-29 17:36:56][DEBUG][XMLUtils.java:165] 生成请求报文--reqMessage:
1.0.0
PJK
0020
20181029 17:36:56
PJK2018102917242600105
6
1
[2018-10-29 17:36:56][DEBUG][CzbQueryServiceImpl.java:70] 单笔流水查询--HttpClient请求结果:1.0.0CZBANK000160000无相应记录无相应记录
p4Ddqso1fnLDQigi/gAfFHcyx7g=
l9H907jVCiMAJzMyh5NsAqxyPJ/fz6HqRbDhBWM9zBEqPOZgoK8/+FTmU6IerjlJiGuoMtR2f3Tp
m8OvqbqUW+VDkdlHw+Z4yIEBzE+6O7PvQGoXB5T3Zp3VbtUV7Bjx7a2edKPd4/4ohlLsOtJL5EgO
yCJQMd05WQHotm9WdmgL+iTinKxPAyAyXQreIr4RgsHQJpfRj1ql2VNrvhIm1GZ9fSzXoHforghY
PJeUakAaiG70xDLsapa4qLrC3w4YVMGvILISszn13lL5+5Q9Pa+E705LycfoDbZQNHoYRKfujgNh
gmoKEU+ngRfTXLxdbgUkK57bkpHAKcsuuJZ5IQ==
---------
[2018-10-29 17:36:56][DEBUG][XMLUtils.java:165] 生成请求报文--reqMessage:
1.0.0
PJK
0020
20181029 17:36:56
PJK2018102917242600106
6
1
[2018-10-29 17:36:56][DEBUG][CzbQueryServiceImpl.java:70] 单笔流水查询--HttpClient请求结果:1.0.0CZBANK000160000无相应记录无相应记录
p4Ddqso1fnLDQigi/gAfFHcyx7g=
l9H907jVCiMAJzMyh5NsAqxyPJ/fz6HqRbDhBWM9zBEqPOZgoK8/+FTmU6IerjlJiGuoMtR2f3Tp
m8OvqbqUW+VDkdlHw+Z4yIEBzE+6O7PvQGoXB5T3Zp3VbtUV7Bjx7a2edKPd4/4ohlLsOtJL5EgO
yCJQMd05WQHotm9WdmgL+iTinKxPAyAyXQreIr4RgsHQJpfRj1ql2VNrvhIm1GZ9fSzXoHforghY
PJeUakAaiG70xDLsapa4qLrC3w4YVMGvILISszn13lL5+5Q9Pa+E705LycfoDbZQNHoYRKfujgNh
gmoKEU+ngRfTXLxdbgUkK57bkpHAKcsuuJZ5IQ==
---------
[2018-10-29 17:36:56][DEBUG][XMLUtils.java:165] 生成请求报文--reqMessage:
1.0.0
PJK
0020
20181029 17:36:56
PJK2018102917242600107
6
1
[2018-10-29 17:36:56][DEBUG][CzbQueryServiceImpl.java:70] 单笔流水查询--HttpClient请求结果:1.0.0CZBANK000160000无相应记录无相应记录
p4Ddqso1fnLDQigi/gAfFHcyx7g=
l9H907jVCiMAJzMyh5NsAqxyPJ/fz6HqRbDhBWM9zBEqPOZgoK8/+FTmU6IerjlJiGuoMtR2f3Tp
m8OvqbqUW+VDkdlHw+Z4yIEBzE+6O7PvQGoXB5T3Zp3VbtUV7Bjx7a2edKPd4/4ohlLsOtJL5EgO
yCJQMd05WQHotm9WdmgL+iTinKxPAyAyXQreIr4RgsHQJpfRj1ql2VNrvhIm1GZ9fSzXoHforghY
PJeUakAaiG70xDLsapa4qLrC3w4YVMGvILISszn13lL5+5Q9Pa+E705LycfoDbZQNHoYRKfujgNh
gmoKEU+ngRfTXLxdbgUkK57bkpHAKcsuuJZ5IQ==
---------
[2018-10-29 17:36:56][DEBUG][XMLUtils.java:165] 生成请求报文--reqMessage:
1.0.0
PJK
0020
20181029 17:36:56
PJK2018102917242600108
6
1
[2018-10-29 17:36:56][DEBUG][CzbQueryServiceImpl.java:70] 单笔流水查询--HttpClient请求结果:1.0.0CZBANK000160000无相应记录无相应记录
p4Ddqso1fnLDQigi/gAfFHcyx7g=
l9H907jVCiMAJzMyh5NsAqxyPJ/fz6HqRbDhBWM9zBEqPOZgoK8/+FTmU6IerjlJiGuoMtR2f3Tp
m8OvqbqUW+VDkdlHw+Z4yIEBzE+6O7PvQGoXB5T3Zp3VbtUV7Bjx7a2edKPd4/4ohlLsOtJL5EgO
yCJQMd05WQHotm9WdmgL+iTinKxPAyAyXQreIr4RgsHQJpfRj1ql2VNrvhIm1GZ9fSzXoHforghY
PJeUakAaiG70xDLsapa4qLrC3w4YVMGvILISszn13lL5+5Q9Pa+E705LycfoDbZQNHoYRKfujgNh
gmoKEU+ngRfTXLxdbgUkK57bkpHAKcsuuJZ5IQ==
---------
[2018-10-29 17:36:56][DEBUG][XMLUtils.java:165] 生成请求报文--reqMessage:
1.0.0
PJK
0020
20181029 17:36:56
PJK2018102917242600109
6
1
[2018-10-29 17:36:56][DEBUG][CzbQueryServiceImpl.java:70] 单笔流水查询--HttpClient请求结果:1.0.0CZBANK000160000无相应记录无相应记录
p4Ddqso1fnLDQigi/gAfFHcyx7g=
l9H907jVCiMAJzMyh5NsAqxyPJ/fz6HqRbDhBWM9zBEqPOZgoK8/+FTmU6IerjlJiGuoMtR2f3Tp
m8OvqbqUW+VDkdlHw+Z4yIEBzE+6O7PvQGoXB5T3Zp3VbtUV7Bjx7a2edKPd4/4ohlLsOtJL5EgO
yCJQMd05WQHotm9WdmgL+iTinKxPAyAyXQreIr4RgsHQJpfRj1ql2VNrvhIm1GZ9fSzXoHforghY
PJeUakAaiG70xDLsapa4qLrC3w4YVMGvILISszn13lL5+5Q9Pa+E705LycfoDbZQNHoYRKfujgNh
gmoKEU+ngRfTXLxdbgUkK57bkpHAKcsuuJZ5IQ==
---------
[2018-10-29 17:36:56][DEBUG][XMLUtils.java:165] 生成请求报文--reqMessage:
1.0.0
PJK
0020
20181029 17:36:56
PJK2018102917242600110
6
1
[2018-10-29 17:36:56][DEBUG][CzbQueryServiceImpl.java:70] 单笔流水查询--HttpClient请求结果:1.0.0CZBANK000160000无相应记录无相应记录
p4Ddqso1fnLDQigi/gAfFHcyx7g=
l9H907jVCiMAJzMyh5NsAqxyPJ/fz6HqRbDhBWM9zBEqPOZgoK8/+FTmU6IerjlJiGuoMtR2f3Tp
m8OvqbqUW+VDkdlHw+Z4yIEBzE+6O7PvQGoXB5T3Zp3VbtUV7Bjx7a2edKPd4/4ohlLsOtJL5EgO
yCJQMd05WQHotm9WdmgL+iTinKxPAyAyXQreIr4RgsHQJpfRj1ql2VNrvhIm1GZ9fSzXoHforghY
PJeUakAaiG70xDLsapa4qLrC3w4YVMGvILISszn13lL5+5Q9Pa+E705LycfoDbZQNHoYRKfujgNh
gmoKEU+ngRfTXLxdbgUkK57bkpHAKcsuuJZ5IQ==
---------
[2018-10-29 17:36:56][DEBUG][XMLUtils.java:165] 生成请求报文--reqMessage:
1.0.0
PJK
0020
20181029 17:36:56
PJK2018102917242600111
6
1
[2018-10-29 17:36:56][DEBUG][CzbQueryServiceImpl.java:70] 单笔流水查询--HttpClient请求结果:1.0.0CZBANK000160000无相应记录无相应记录
p4Ddqso1fnLDQigi/gAfFHcyx7g=
l9H907jVCiMAJzMyh5NsAqxyPJ/fz6HqRbDhBWM9zBEqPOZgoK8/+FTmU6IerjlJiGuoMtR2f3Tp
m8OvqbqUW+VDkdlHw+Z4yIEBzE+6O7PvQGoXB5T3Zp3VbtUV7Bjx7a2edKPd4/4ohlLsOtJL5EgO
yCJQMd05WQHotm9WdmgL+iTinKxPAyAyXQreIr4RgsHQJpfRj1ql2VNrvhIm1GZ9fSzXoHforghY
PJeUakAaiG70xDLsapa4qLrC3w4YVMGvILISszn13lL5+5Q9Pa+E705LycfoDbZQNHoYRKfujgNh
gmoKEU+ngRfTXLxdbgUkK57bkpHAKcsuuJZ5IQ==
---------
[2018-10-29 17:36:56][DEBUG][XMLUtils.java:165] 生成请求报文--reqMessage:
1.0.0
PJK
0020
20181029 17:36:56
PJK2018102917242600112
6
1
[2018-10-29 17:36:57][DEBUG][CzbQueryServiceImpl.java:70] 单笔流水查询--HttpClient请求结果:1.0.0CZBANK000160000无相应记录无相应记录
p4Ddqso1fnLDQigi/gAfFHcyx7g=
l9H907jVCiMAJzMyh5NsAqxyPJ/fz6HqRbDhBWM9zBEqPOZgoK8/+FTmU6IerjlJiGuoMtR2f3Tp
m8OvqbqUW+VDkdlHw+Z4yIEBzE+6O7PvQGoXB5T3Zp3VbtUV7Bjx7a2edKPd4/4ohlLsOtJL5EgO
yCJQMd05WQHotm9WdmgL+iTinKxPAyAyXQreIr4RgsHQJpfRj1ql2VNrvhIm1GZ9fSzXoHforghY
PJeUakAaiG70xDLsapa4qLrC3w4YVMGvILISszn13lL5+5Q9Pa+E705LycfoDbZQNHoYRKfujgNh
gmoKEU+ngRfTXLxdbgUkK57bkpHAKcsuuJZ5IQ==
---------
[2018-10-29 17:36:57][DEBUG][XMLUtils.java:165] 生成请求报文--reqMessage:
1.0.0
PJK
0020
20181029 17:36:57
PJK2018102917242600113
6
1
[2018-10-29 17:36:57][DEBUG][CzbQueryServiceImpl.java:70] 单笔流水查询--HttpClient请求结果:1.0.0CZBANK000160000无相应记录无相应记录
p4Ddqso1fnLDQigi/gAfFHcyx7g=
l9H907jVCiMAJzMyh5NsAqxyPJ/fz6HqRbDhBWM9zBEqPOZgoK8/+FTmU6IerjlJiGuoMtR2f3Tp
m8OvqbqUW+VDkdlHw+Z4yIEBzE+6O7PvQGoXB5T3Zp3VbtUV7Bjx7a2edKPd4/4ohlLsOtJL5EgO
yCJQMd05WQHotm9WdmgL+iTinKxPAyAyXQreIr4RgsHQJpfRj1ql2VNrvhIm1GZ9fSzXoHforghY
PJeUakAaiG70xDLsapa4qLrC3w4YVMGvILISszn13lL5+5Q9Pa+E705LycfoDbZQNHoYRKfujgNh
gmoKEU+ngRfTXLxdbgUkK57bkpHAKcsuuJZ5IQ==
---------
[2018-10-29 17:36:57][DEBUG][CzbRepayServiceImpl.java:284] 浙商银行接口--还款申请--第二步,通过对账查询浙商银行是否转账--处理结束
[2018-10-29 17:36:57][DEBUG][CzbRepayServiceImpl.java:285] 浙商银行接口--还款申请--第二步处理结果--本次不传输的转账数据:[]
[2018-10-29 17:36:57][DEBUG][CzbRepayServiceImpl.java:286] 浙商银行接口--还款申请--第二步处理结果--本次需要传输的转账数据:[{"amount":"30528.00","currentOutsideOrderNo":"PJK2018102917242600104","currentOutsideSerialNo":"PJK2018102917242600103","extraInterest":"0","fee":"0","inAccount":"PP201704171718210007829534","inBankNo":"6210193310201761557","inIdCard":"32048119830404221X","inMemberId":"246c9bfa0adc442fbdb0cb5fca7c7d43","inMemberKind":"0","inRealName":"梁涛","orderId":"8a9aee2d630b63480164b6447e7f5e94","outAccount":"p1350","outBankNo":"695603432","outIdCard":"500103001866567","outMemberId":"ff8080814faaed76014fabcbf1a40030","outMemberKind":"11","outRealName":"平台账户","outsideOrderDate":"20180720","outsideOrderNo":"PJK2018072013581965335","outsideSerialNo":"PT1807230003961945","payType":"2","resultStatus":0,"shareProfitDatas":[]},{"amount":"167.90","currentOutsideOrderNo":"PJK2018102917242600105","currentOutsideSerialNo":"PJK2018102917242600103","extraInterest":"0","fee":"0","inAccount":"PP201704171718210007829534","inBankNo":"6210193310201761557","inIdCard":"32048119830404221X","inMemberId":"246c9bfa0adc442fbdb0cb5fca7c7d43","inMemberKind":"0","inRealName":"梁涛","orderId":"8a9aee2d630b63480164b646029a5e9b","outAccount":"p1350","outBankNo":"695603432","outIdCard":"500103001866567","outMemberId":"ff8080814faaed76014fabcbf1a40030","outMemberKind":"11","outRealName":"平台账户","outsideOrderDate":"20180720","outsideOrderNo":"PJK2018072013595865343","outsideSerialNo":"PT1807230003961949","payType":"2","resultStatus":0,"shareProfitDatas":[]},{"amount":"22584.61","currentOutsideOrderNo":"PJK2018102917242600106","currentOutsideSerialNo":"PJK2018102917242600103","extraInterest":"0","fee":"0","inAccount":"PP201703201156430007313774","inBankNo":"6210193310201465597","inIdCard":"120104195807180817","inMemberId":"cd6f063826c44d55acd19997b2609cf0","inMemberKind":"0","inRealName":"刘啟明","orderId":"8a9aee2d630b63480164b6505d975ea4","outAccount":"p1350","outBankNo":"695603432","outIdCard":"500103001866567","outMemberId":"ff8080814faaed76014fabcbf1a40030","outMemberKind":"11","outRealName":"平台账户","outsideOrderDate":"20180720","outsideOrderNo":"PJK2018072014111765357","outsideSerialNo":"PT1807230003961942","payType":"2","resultStatus":0,"shareProfitDatas":[]},{"amount":"10675.64","currentOutsideOrderNo":"PJK2018102917242600107","currentOutsideSerialNo":"PJK2018102917242600103","extraInterest":"0","fee":"0","inAccount":"PP201703201055280007309993","inBankNo":"6210193310201463816","inIdCard":"510402197111240928","inMemberId":"0b622868900f45f78ca51dcc5590e1ce","inMemberKind":"0","inRealName":"李莉","orderId":"8a9aee2d630b63480164b676740c5ee3","outAccount":"p1350","outBankNo":"695603432","outIdCard":"500103001866567","outMemberId":"ff8080814faaed76014fabcbf1a40030","outMemberKind":"11","outRealName":"平台账户","outsideOrderDate":"20180720","outsideOrderNo":"PJK2018072014525365404","outsideSerialNo":"PT1807230003961948","payType":"2","resultStatus":0,"shareProfitDatas":[]},{"amount":"16531.93","currentOutsideOrderNo":"PJK2018102917242600108","currentOutsideSerialNo":"PJK2018102917242600103","extraInterest":"0","fee":"0","inAccount":"PP201704171632400007826679","inBankNo":"6210193310201760849","inIdCard":"511002196508172526","inMemberId":"d9d5c638f85a4e0e9ce97a87af39214b","inMemberKind":"0","inRealName":"吕成琼","orderId":"8a9aee2d630b63480164b69e06345f25","outAccount":"p1350","outBankNo":"695603432","outIdCard":"500103001866567","outMemberId":"ff8080814faaed76014fabcbf1a40030","outMemberKind":"11","outRealName":"平台账户","outsideOrderDate":"20180720","outsideOrderNo":"PJK2018072015360665440","outsideSerialNo":"PT1807230003961943","payType":"2","resultStatus":0,"shareProfitDatas":[]},{"amount":"20352.00","currentOutsideOrderNo":"PJK2018102917242600109","currentOutsideSerialNo":"PJK2018102917242600103","extraInterest":"0","fee":"0","inAccount":"PP201806262137590057746036","inBankNo":"6210193310207715342","inIdCard":"130302197802213551","inMemberId":"8a9aee2d630b634801643b268c66301c","inMemberKind":"0","inRealName":"王兆杰","orderId":"8a9aee2d630b63480164b6a6f35d5f31","outAccount":"p1350","outBankNo":"695603432","outIdCard":"500103001866567","outMemberId":"ff8080814faaed76014fabcbf1a40030","outMemberKind":"11","outRealName":"平台账户","outsideOrderDate":"20180720","outsideOrderNo":"PJK2018072015455165458","outsideSerialNo":"PT1807230003961940","payType":"2","resultStatus":0,"shareProfitDatas":[]},{"amount":"3744.77","currentOutsideOrderNo":"PJK2018102917242600110","currentOutsideSerialNo":"PJK2018102917242600103","extraInterest":"0","fee":"0","inAccount":"PP201704111544090007708318","inBankNo":"6210193310201695771","inIdCard":"320681198207101020","inMemberId":"fdb3947e19fd4241a1bd5c47bd352877","inMemberKind":"0","inRealName":"朱海燕","orderId":"8a9aee2d630b63480164b6c18b785f3e","outAccount":"p1350","outBankNo":"695603432","outIdCard":"500103001866567","outMemberId":"ff8080814faaed76014fabcbf1a40030","outMemberKind":"11","outRealName":"平台账户","outsideOrderDate":"20180720","outsideOrderNo":"PJK2018072016145465502","outsideSerialNo":"PT1807230003961947","payType":"2","resultStatus":0,"shareProfitDatas":[]},{"amount":"3084.35","currentOutsideOrderNo":"PJK2018102917242600111","currentOutsideSerialNo":"PJK2018102917242600103","extraInterest":"0","fee":"0","inAccount":"PP201703211738120007344095","inBankNo":"6210193310201486130","inIdCard":"420683198403242839","inMemberId":"d095fc3f82064333b21c3955f7887e72","inMemberKind":"0","inRealName":"张俊楠","orderId":"8a9aee2d630b63480164b6c812515f47","outAccount":"p1350","outBankNo":"695603432","outIdCard":"500103001866567","outMemberId":"ff8080814faaed76014fabcbf1a40030","outMemberKind":"11","outRealName":"平台账户","outsideOrderDate":"20180720","outsideOrderNo":"PJK2018072016220265528","outsideSerialNo":"PT1807230003961944","payType":"2","resultStatus":0,"shareProfitDatas":[]},{"amount":"51405.08","currentOutsideOrderNo":"PJK2018102917242600112","currentOutsideSerialNo":"PJK2018102917242600103","extraInterest":"0","fee":"0","inAccount":"PP201703281506180007468458","inBankNo":"6210193310201564720","inIdCard":"610404198405311024","inMemberId":"5778330e21a44f9087fa6eae9408da62","inMemberKind":"0","inRealName":"周赟","orderId":"8a9aee2d630b63480164b6c8d8405f48","outAccount":"p1350","outBankNo":"695603432","outIdCard":"500103001866567","outMemberId":"ff8080814faaed76014fabcbf1a40030","outMemberKind":"11","outRealName":"平台账户","outsideOrderDate":"20180720","outsideOrderNo":"PJK2018072016225365535","outsideSerialNo":"PT1807230003961950","payType":"2","resultStatus":0,"shareProfitDatas":[]},{"amount":"40979.77","currentOutsideOrderNo":"PJK2018102917242600113","currentOutsideSerialNo":"PJK2018102917242600103","extraInterest":"0","fee":"0","inAccount":"PP201704061605070007616385","inBankNo":"6210193310201644043","inIdCard":"372328197301200103","inMemberId":"8dc3547daa114b73899f31459e072013","inMemberKind":"0","inRealName":"王敏","orderId":"8a9aee2d630b63480164b6db484c5f50","outAccount":"p1350","outBankNo":"695603432","outIdCard":"500103001866567","outMemberId":"ff8080814faaed76014fabcbf1a40030","outMemberKind":"11","outRealName":"平台账户","outsideOrderDate":"20180720","outsideOrderNo":"PJK2018072016430165558","outsideSerialNo":"PT1807230003961951","payType":"2","resultStatus":0,"shareProfitDatas":[]}]
[2018-10-29 17:36:57][DEBUG][CzbRepayServiceImpl.java:287] 浙商银行接口--还款申请--第三步--判断本次是否有还款数据
[2018-10-29 17:36:57][DEBUG][CzbRepayServiceImpl.java:303] 浙商银行接口--还款申请--第四步--调用浙商银行本息还款接口
[2018-10-29 17:36:57][DEBUG][CzbRepayServiceImpl.java:389] 浙商银行接口--还款服务--线程睡眠5秒!--第[1]次调用还款
[2018-10-29 17:36:57][DEBUG][UserController.java:79] 登录提交失败:已经登录
[2018-10-29 17:36:57][DEBUG][UserController.java:155] 访问账号:liqiang,访问权限:null
[2018-10-29 17:36:58][DEBUG][BaseJdbcLogger.java:139] ==> Preparing: SELECT periodR, amount, itemTotalAmount, rate, periodP, periodType, repayStatus, repayMethodName, t1.productId, t1.productCd, t1.productNm, realNm, repayDate, c.companyNm AS companyNm, isNewSysProduct, t1. STATUS, t1.castQuantity, t1.borrowAmt, t1.unitPrice, t1.tenderStart, t1.repayPlayTime, t1.ticketAmt, t1.preSubsidyAmt, t1.interestEndTime, t1.totalPeriod, t1.preServiceFeeAmt, t1.sufServiceFeeAmt, t1.sufSubsidyAmt, ( SELECT IFNULL(sum(t.itemAmount), 0) FROM repayitemplan t WHERE t.productId = t1.productId AND t. STATUS = 0 ) noRepayTotalAmt, ass.spv AS spv, bc.borrowerCardName AS borrowerCardName FROM ( SELECT p.memberid AS memberid, p.unitPrice * p.castQuantity AS amount, t.itemTotalAmount, p.rate AS rate, p.period AS periodP, p.periodType AS periodType, p.repayMethodName AS repayMethodName, p.productId AS productId, p.productCd AS productCd, p.productNm AS productNm, p.assetId AS assetId, m.realNm AS realNm, periodR, repayDate, repayStatus, p.isNewSysProduct, p. STATUS, p.castQuantity, p.borrowAmt, p.unitPrice, p.tenderStart, p.repayPlayTime, p.ticketAmt, p.preSubsidyAmt, p.interestEndTime, p.totalPeriod, p.preServiceFeeAmt, p.sufServiceFeeAmt, p.sufSubsidyAmt FROM ( SELECT r.repayTotal AS itemTotalAmount, r.productid, rip.period AS periodR, rip.repayDate, r. STATUS repayStatus FROM repay r, repayitem ri, ( SELECT * FROM repayitemplan rip1 WHERE rip1. STATUS = 0 GROUP BY rip1.productId, rip1.period ) rip WHERE r.repayId = ri.repayId AND ri.repayItemPlanId = rip.repayItemPlanId AND r. STATUS = 1 AND r.repayKind = 0 AND ( r.advanceRepayFlag IS NULL OR r.advanceRepayFlag IN (0, 3) ) ) t, product p, member m WHERE t.productId = p.productId AND p. STATUS = 90 AND m.memberid = p.memberId ) t1 LEFT JOIN Company c ON t1.memberid = c.memberid LEFT JOIN asset ass ON ass.id = t1.assetId LEFT JOIN borrower_card bc ON bc.productId = t1.productId WHERE 1 = 1 ORDER BY repayDate limit ?,?
[2018-10-29 17:36:58][DEBUG][BaseJdbcLogger.java:139] ==> Parameters: 0(Integer), 1000000000(Integer)
[2018-10-29 17:36:58][DEBUG][BaseJdbcLogger.java:139] <== Total: 0
[2018-10-29 17:36:58][DEBUG][BaseJdbcLogger.java:139] ==> Preparing: SELECT count(1) FROM ( SELECT p.memberid AS memberid, p.unitPrice * p.castQuantity AS amount, t.itemTotalAmount, p.rate AS rate, p.period AS periodP, p.periodType AS periodType, p.repayMethodName AS repayMethodName, p.productId AS productId, p.productCd AS productCd, p.productNm AS productNm, p.assetId AS assetId, m.realNm AS realNm, periodR, repayDate, repayStatus, p.isNewSysProduct, p. STATUS, p.castQuantity, p.borrowAmt, p.unitPrice, p.tenderStart, p.repayPlayTime, p.ticketAmt, p.preSubsidyAmt, p.interestEndTime, p.totalPeriod FROM ( SELECT r.repayTotal AS itemTotalAmount, r.productid, rip.period AS periodR, rip.repayDate, r. STATUS repayStatus FROM repay r, repayitem ri, ( SELECT * FROM repayitemplan rip1 WHERE rip1. STATUS = 0 GROUP BY rip1.productId, rip1.period ) rip WHERE r.repayId = ri.repayId AND ri.repayItemPlanId = rip.repayItemPlanId AND r. STATUS = 1 AND r.repayKind = 0 AND ( r.advanceRepayFlag IS NULL OR r.advanceRepayFlag IN (0, 3) ) ) t, product p, member m WHERE t.productId = p.productId AND p. STATUS = 90 AND m.memberid = p.memberId ) t1 LEFT JOIN Company c ON t1.memberid = c.memberid LEFT JOIN asset ass ON ass.id = t1.assetId LEFT JOIN borrower_card bc ON bc.productId = t1.productId WHERE 1 = 1
[2018-10-29 17:36:58][DEBUG][BaseJdbcLogger.java:139] ==> Parameters:
[2018-10-29 17:36:58][DEBUG][BaseJdbcLogger.java:139] <== Total: 1
[2018-10-29 17:36:58][DEBUG][BaseJdbcLogger.java:139] ==> Preparing: SELECT periodR, amount, itemTotalAmount, rate, periodP, periodType, repayStatus, repayMethodName, t1.productId, t1.productCd, t1.productNm, realNm, repayDate, c.companyNm AS companyNm, isNewSysProduct, t1. STATUS, t1.castQuantity, t1.borrowAmt, t1.unitPrice, t1.tenderStart, t1.repayPlayTime, t1.ticketAmt, t1.preSubsidyAmt, t1.interestEndTime, t1.totalPeriod, t1.preServiceFeeAmt, t1.sufServiceFeeAmt, t1.sufSubsidyAmt, ( SELECT IFNULL(sum(t.itemAmount), 0) FROM repayitemplan t WHERE t.productId = t1.productId AND t. STATUS = 0 ) noRepayTotalAmt, ass.spv AS spv, bc.borrowerCardName AS borrowerCardName FROM ( SELECT p.memberid AS memberid, p.unitPrice * p.castQuantity AS amount, t.itemTotalAmount, p.rate AS rate, p.period AS periodP, p.periodType AS periodType, p.repayMethodName AS repayMethodName, p.productId AS productId, p.productCd AS productCd, p.productNm AS productNm, p.assetId AS assetId, m.realNm AS realNm, periodR, repayDate, repayStatus, p.isNewSysProduct, p. STATUS, p.castQuantity, p.borrowAmt, p.unitPrice, p.tenderStart, p.repayPlayTime, p.ticketAmt, p.preSubsidyAmt, p.interestEndTime, p.totalPeriod, p.preServiceFeeAmt, p.sufServiceFeeAmt, p.sufSubsidyAmt FROM ( SELECT r.repayTotal AS itemTotalAmount, r.productid, rip.period AS periodR, rip.repayDate, r. STATUS repayStatus FROM repay r, repayitem ri, ( SELECT * FROM repayitemplan rip1 WHERE rip1. STATUS = 0 GROUP BY rip1.productId, rip1.period ) rip WHERE r.repayId = ri.repayId AND ri.repayItemPlanId = rip.repayItemPlanId AND r. STATUS = 1 AND r.repayKind = 0 AND ( r.advanceRepayFlag IS NULL OR r.advanceRepayFlag IN (0, 3) ) ) t, product p, member m WHERE t.productId = p.productId AND p. STATUS = 90 AND m.memberid = p.memberId ) t1 LEFT JOIN Company c ON t1.memberid = c.memberid LEFT JOIN asset ass ON ass.id = t1.assetId LEFT JOIN borrower_card bc ON bc.productId = t1.productId WHERE 1 = 1 ORDER BY repayDate limit ?,?
[2018-10-29 17:36:58][DEBUG][BaseJdbcLogger.java:139] ==> Parameters: 0(Integer), 1000000000(Integer)
[2018-10-29 17:36:58][DEBUG][BaseJdbcLogger.java:139] <== Total: 0
[2018-10-29 17:36:58][DEBUG][BaseJdbcLogger.java:139] ==> Preparing: SELECT count(1) FROM ( SELECT p.memberid AS memberid, p.unitPrice * p.castQuantity AS amount, t.itemTotalAmount, p.rate AS rate, p.period AS periodP, p.periodType AS periodType, p.repayMethodName AS repayMethodName, p.productId AS productId, p.productCd AS productCd, p.productNm AS productNm, p.assetId AS assetId, m.realNm AS realNm, periodR, repayDate, repayStatus, p.isNewSysProduct, p. STATUS, p.castQuantity, p.borrowAmt, p.unitPrice, p.tenderStart, p.repayPlayTime, p.ticketAmt, p.preSubsidyAmt, p.interestEndTime, p.totalPeriod FROM ( SELECT r.repayTotal AS itemTotalAmount, r.productid, rip.period AS periodR, rip.repayDate, r. STATUS repayStatus FROM repay r, repayitem ri, ( SELECT * FROM repayitemplan rip1 WHERE rip1. STATUS = 0 GROUP BY rip1.productId, rip1.period ) rip WHERE r.repayId = ri.repayId AND ri.repayItemPlanId = rip.repayItemPlanId AND r. STATUS = 1 AND r.repayKind = 0 AND ( r.advanceRepayFlag IS NULL OR r.advanceRepayFlag IN (0, 3) ) ) t, product p, member m WHERE t.productId = p.productId AND p. STATUS = 90 AND m.memberid = p.memberId ) t1 LEFT JOIN Company c ON t1.memberid = c.memberid LEFT JOIN asset ass ON ass.id = t1.assetId LEFT JOIN borrower_card bc ON bc.productId = t1.productId WHERE 1 = 1
[2018-10-29 17:36:58][DEBUG][BaseJdbcLogger.java:139] ==> Parameters:
[2018-10-29 17:36:58][DEBUG][BaseJdbcLogger.java:139] <== Total: 1
[2018-10-29 17:36:58][DEBUG][BaseJdbcLogger.java:139] ==> Preparing: SELECT p.productId, p.productCd, p.productNm, m.realNm, c.companyNm, a.spv, p.borrowerName, bc.borrowerCardName, p.rate, p.periodType, p.period periodP, p.repayMethodName, p.amount, p.borrowAmt, p.unitPrice, p.status, p.castQuantity, p.tenderStart, p.repayPlayTime, p.ticketAmt, p.preSubsidyAmt, p.preServiceFeeAmt, p.sufServiceFeeAmt, p.sufSubsidyAmt, (select count(1) from repayitemplan t where t.productId = rip.productId and t.status != 2 and t.ItemTypeId = 100000) totalPeriod, (select count(1) from repayitemplan t where t.productId = rip.productId and t.status = 1 and t.ItemTypeId = 100000) repayedPeriodCnt, (select t.itemAmount+rip.itemAmount from repayitemplan t where t.productId=rip.productId and t.period=rip.period and t.status = 0 and t.ItemTypeId=100800) itemTotalAmount, rip.period periodR, (select ifnull(sum(t.itemAmount),0) from repayitemplan t where t.productId = rip.productId and t.status = 0) noRepayedAmt, p.interestEndTime, ifnull(a.ticketCode,'') ticketCode, ifnull(a.acceptedCompany,'') acceptedCompany, ptr.repayDelayDays FROM repayitemplan rip LEFT JOIN product p ON rip.productId = p.productId LEFT JOIN member m ON p.memberId = m.memberId LEFT JOIN company c ON c.memberId = m.memberId LEFT JOIN asset a ON p.assetId = a.id left join borrower_card bc on bc.productId = p.productId inner join producttyperule ptr on ptr.productTypeRuleId=p.productTypeRuleId WHERE rip.ItemTypeId = 100000 AND rip.STATUS = 0 and rip.repayDate < date_add(now(), interval -1*ptr.repayDelayDays day) and p.status = 90 AND NOT EXISTS ( SELECT 1 FROM repay r WHERE r.period = rip.period AND r.productId = rip.productId ) limit ?,?
[2018-10-29 17:36:58][DEBUG][BaseJdbcLogger.java:139] ==> Parameters: 0(Integer), 1000000000(Integer)
[2018-10-29 17:36:58][DEBUG][BaseJdbcLogger.java:139] ==> Preparing: SELECT p.productId, p.productCd, p.productNm, m.realNm, c.companyNm, a.spv, p.borrowerName, bc.borrowerCardName, p.rate, p.periodType, p.period periodP, p.repayMethodName, p.amount, p.borrowAmt, p.unitPrice, p.status, p.castQuantity, p.tenderStart, p.repayPlayTime, p.ticketAmt, p.preSubsidyAmt, p.preServiceFeeAmt, p.sufServiceFeeAmt, p.sufSubsidyAmt, (select count(1) from repayitemplan t where t.productId = rip.productId and t.status != 2 and t.ItemTypeId = 100000) totalPeriod, (select count(1) from repayitemplan t where t.productId = rip.productId and t.status = 1 and t.ItemTypeId = 100000) repayedPeriodCnt, (select t.itemAmount+rip.itemAmount from repayitemplan t where t.productId=rip.productId and t.period=rip.period and t.status = 0 and t.ItemTypeId=100800) itemTotalAmount, rip.period periodR, (select ifnull(sum(t.itemAmount),0) from repayitemplan t where t.productId = rip.productId and t.status = 0) noRepayedAmt, p.interestEndTime, ifnull(a.ticketCode,'') ticketCode, ifnull(a.acceptedCompany,'') acceptedCompany, ptr.repayDelayDays FROM repayitemplan rip LEFT JOIN product p ON rip.productId = p.productId LEFT JOIN member m ON p.memberId = m.memberId LEFT JOIN company c ON c.memberId = m.memberId LEFT JOIN asset a ON p.assetId = a.id left join borrower_card bc on bc.productId = p.productId inner join producttyperule ptr on ptr.productTypeRuleId=p.productTypeRuleId WHERE rip.ItemTypeId = 100000 AND rip.STATUS = 0 and rip.repayDate < date_add(now(), interval -1*ptr.repayDelayDays day) and p.status = 90 AND NOT EXISTS ( SELECT 1 FROM repay r WHERE r.period = rip.period AND r.productId = rip.productId ) limit ?,?
[2018-10-29 17:36:58][DEBUG][BaseJdbcLogger.java:139] ==> Parameters: 0(Integer), 1000000000(Integer)
[2018-10-29 17:36:58][DEBUG][BaseJdbcLogger.java:139] <== Total: 0
[2018-10-29 17:36:58][DEBUG][BaseJdbcLogger.java:139] ==> Preparing: SELECT count(1) FROM repayitemplan rip LEFT JOIN product p ON rip.productId = p.productId LEFT JOIN member m ON p.memberId = m.memberId LEFT JOIN company c ON c.memberId = m.memberId inner join producttyperule ptr on ptr.productTypeRuleId=p.productTypeRuleId WHERE rip.ItemTypeId = 100000 AND rip.STATUS = 0 and rip.repayDate < date_add(now(), interval -1*ptr.repayDelayDays day) and p.status = 90 AND NOT EXISTS ( SELECT 1 FROM repay r WHERE r.period = rip.period AND r.productId = rip.productId )
[2018-10-29 17:36:58][DEBUG][BaseJdbcLogger.java:139] ==> Parameters:
[2018-10-29 17:36:58][DEBUG][BaseJdbcLogger.java:139] <== Total: 0
[2018-10-29 17:36:58][DEBUG][BaseJdbcLogger.java:139] ==> Preparing: SELECT count(1) FROM repayitemplan rip LEFT JOIN product p ON rip.productId = p.productId LEFT JOIN member m ON p.memberId = m.memberId LEFT JOIN company c ON c.memberId = m.memberId inner join producttyperule ptr on ptr.productTypeRuleId=p.productTypeRuleId WHERE rip.ItemTypeId = 100000 AND rip.STATUS = 0 and rip.repayDate < date_add(now(), interval -1*ptr.repayDelayDays day) and p.status = 90 AND NOT EXISTS ( SELECT 1 FROM repay r WHERE r.period = rip.period AND r.productId = rip.productId )
[2018-10-29 17:36:58][DEBUG][BaseJdbcLogger.java:139] ==> Parameters:
[2018-10-29 17:36:58][DEBUG][BaseJdbcLogger.java:139] <== Total: 1
[2018-10-29 17:36:58][DEBUG][BaseJdbcLogger.java:139] <== Total: 1
[2018-10-29 17:37:00][INFO ][AbstractJob.java:77] 任务开始[1005]定时从已上架状态转为招标中状态
[2018-10-29 17:37:00][INFO ][ProductToTenderJob.java:32] 已上架-->招标中 产品数=0
[2018-10-29 17:37:00][INFO ][AbstractJob.java:89] 任务完成[1005]定时从已上架状态转为招标中状态
[2018-10-29 17:37:02][DEBUG][UserController.java:155] 访问账号:liqiang,访问权限:p2p.product
[2018-10-29 17:37:02][DEBUG][CzbRepayServiceImpl.java:396] 浙商银行接口--还款服务--调用支付的本息还款--处理开始
[2018-10-29 17:37:02][DEBUG][CzbRepayServiceImpl.java:397] 浙商银行接口--还款服务--调用支付的本息还款--数据验证
[2018-10-29 17:37:02][DEBUG][CzbRepayServiceImpl.java:399] 浙商银行接口--还款服务--调用支付的本息还款--生成HttpClient请求数据
[2018-10-29 17:37:02][DEBUG][XMLUtils.java:165] 生成请求报文--reqMessage:
1
0020
10
20181029 17:37:02
0
1
PJK
PJK-180720135005655369
156
0
0
PT1807230003961951
PJK2018102917242600113
2
4097977
0
156
0
0
PT1807230003961947
PJK2018102917242600110
2
374477
0
156
0
0
PT1807230003961944
PJK2018102917242600111
2
308435
0
156
0
0
PT1807230003961943
PJK2018102917242600108
2
1653193
0
156
0
0
PT1807230003961948
PJK2018102917242600107
2
1067564
0
156
0
0
PT1807230003961945
PJK2018102917242600104
2
3052800
0
156
0
0
PT1807230003961949
PJK2018102917242600105
2
16790
0
156
0
0
PT1807230003961942
PJK2018102917242600106
2
2258461
0
156
0
0
PT1807230003961950
PJK2018102917242600112
2
5140508
0
156
0
0
PT1807230003961940
PJK2018102917242600109
2
2035200
0
1
1.0.0
[2018-10-29 17:37:02][DEBUG][CzbRepayServiceImpl.java:401] 浙商银行接口--调用支付的本息还款--HttpClient请求
[2018-10-29 17:37:02][DEBUG][CzbRepayServiceImpl.java:403] HttpClient请求结果:1.0.0CZBANK0001102000540500PJK201810291724260011320FR1810290453388PJK201810291724260011020FR1810290453389PJK201810291724260011120FR1810290453390PJK201810291724260010820FR1810290453391PJK201810291724260010720FR1810290453392PJK201810291724260010420FR1810290453393PJK201810291724260010520FR1810290453394PJK201810291724260010620FR1810290453395PJK201810291724260011220FR1810290453396PJK201810291724260010920FR1810290453397
UCktnlpA6Gntkak8v7F2oMPWo+Y=
lAfX2eKzecBEn8HumR66A1AarOo0L/OiYjLYa28HxhCCL8i8CGSyysNP3kAhafMoTyPqP4UQSL9s
JxVU5AutGkZKNm6FE+cPt9xumP52S7VI6DeA16+DluzRkqbS2aSbWDFM48couEvybPnTj/MbmGe3
o4k8EuL8krnf5/njxIM0r8xloMTm9GwR5OopmGD94O31GyyQxWkpTCEQ5UNLwWlUx285+ISdulpN
gC7XYLDgVoCvFSR5SranYEWgq2cU97u1fiffIbQi8rE2PSU12ufJxj2ifUZTmVMCka+HmABZkyWO
PaesTxSKp1Pff6n11uk9ONNq82ItQ5icijlqKw==
---------
[2018-10-29 17:37:02][DEBUG][CzbRepayServiceImpl.java:404] 浙商银行接口--还款服务--调用支付的本息还款--装箱返回数据
[2018-10-29 17:37:02][DEBUG][CzbRepayServiceImpl.java:447] 浙商银行接口--还款服务--调用支付的本息还款--处理结束
[2018-10-29 17:37:02][DEBUG][CzbRepayServiceImpl.java:369] 浙商银行接口--还款申请--我方需求的返回数据:{"interactionCode":4,"needForward":false,"requestFlag":"1","successFlag":"","tradeDataList":[{"amount":"40979.77","currentOutsideOrderNo":"PJK2018102917242600113","currentOutsideSerialNo":"FR1810290453388","extraInterest":"0","fee":"0","inAccount":"PP201704061605070007616385","inBankNo":"6210193310201644043","inIdCard":"372328197301200103","inMemberId":"8dc3547daa114b73899f31459e072013","inMemberKind":"0","inRealName":"王敏","orderId":"8a9aee2d630b63480164b6db484c5f50","outAccount":"p1350","outBankNo":"695603432","outIdCard":"500103001866567","outMemberId":"ff8080814faaed76014fabcbf1a40030","outMemberKind":"11","outRealName":"平台账户","outsideOrderDate":"20180720","outsideOrderNo":"PJK2018072016430165558","outsideSerialNo":"PT1807230003961951","payType":"2","resultStatus":1,"shareProfitDatas":[]},{"amount":"51405.08","currentOutsideOrderNo":"PJK2018102917242600112","currentOutsideSerialNo":"FR1810290453396","extraInterest":"0","fee":"0","inAccount":"PP201703281506180007468458","inBankNo":"6210193310201564720","inIdCard":"610404198405311024","inMemberId":"5778330e21a44f9087fa6eae9408da62","inMemberKind":"0","inRealName":"周赟","orderId":"8a9aee2d630b63480164b6c8d8405f48","outAccount":"p1350","outBankNo":"695603432","outIdCard":"500103001866567","outMemberId":"ff8080814faaed76014fabcbf1a40030","outMemberKind":"11","outRealName":"平台账户","outsideOrderDate":"20180720","outsideOrderNo":"PJK2018072016225365535","outsideSerialNo":"PT1807230003961950","payType":"2","resultStatus":1,"shareProfitDatas":[]},{"amount":"3084.35","currentOutsideOrderNo":"PJK2018102917242600111","currentOutsideSerialNo":"FR1810290453390","extraInterest":"0","fee":"0","inAccount":"PP201703211738120007344095","inBankNo":"6210193310201486130","inIdCard":"420683198403242839","inMemberId":"d095fc3f82064333b21c3955f7887e72","inMemberKind":"0","inRealName":"张俊楠","orderId":"8a9aee2d630b63480164b6c812515f47","outAccount":"p1350","outBankNo":"695603432","outIdCard":"500103001866567","outMemberId":"ff8080814faaed76014fabcbf1a40030","outMemberKind":"11","outRealName":"平台账户","outsideOrderDate":"20180720","outsideOrderNo":"PJK2018072016220265528","outsideSerialNo":"PT1807230003961944","payType":"2","resultStatus":1,"shareProfitDatas":[]},{"amount":"22584.61","currentOutsideOrderNo":"PJK2018102917242600106","currentOutsideSerialNo":"FR1810290453395","extraInterest":"0","fee":"0","inAccount":"PP201703201156430007313774","inBankNo":"6210193310201465597","inIdCard":"120104195807180817","inMemberId":"cd6f063826c44d55acd19997b2609cf0","inMemberKind":"0","inRealName":"刘啟明","orderId":"8a9aee2d630b63480164b6505d975ea4","outAccount":"p1350","outBankNo":"695603432","outIdCard":"500103001866567","outMemberId":"ff8080814faaed76014fabcbf1a40030","outMemberKind":"11","outRealName":"平台账户","outsideOrderDate":"20180720","outsideOrderNo":"PJK2018072014111765357","outsideSerialNo":"PT1807230003961942","payType":"2","resultStatus":1,"shareProfitDatas":[]},{"amount":"16531.93","currentOutsideOrderNo":"PJK2018102917242600108","currentOutsideSerialNo":"FR1810290453391","extraInterest":"0","fee":"0","inAccount":"PP201704171632400007826679","inBankNo":"6210193310201760849","inIdCard":"511002196508172526","inMemberId":"d9d5c638f85a4e0e9ce97a87af39214b","inMemberKind":"0","inRealName":"吕成琼","orderId":"8a9aee2d630b63480164b69e06345f25","outAccount":"p1350","outBankNo":"695603432","outIdCard":"500103001866567","outMemberId":"ff8080814faaed76014fabcbf1a40030","outMemberKind":"11","outRealName":"平台账户","outsideOrderDate":"20180720","outsideOrderNo":"PJK2018072015360665440","outsideSerialNo":"PT1807230003961943","payType":"2","resultStatus":1,"shareProfitDatas":[]},{"amount":"20352.00","currentOutsideOrderNo":"PJK2018102917242600109","currentOutsideSerialNo":"FR1810290453397","extraInterest":"0","fee":"0","inAccount":"PP201806262137590057746036","inBankNo":"6210193310207715342","inIdCard":"130302197802213551","inMemberId":"8a9aee2d630b634801643b268c66301c","inMemberKind":"0","inRealName":"王兆杰","orderId":"8a9aee2d630b63480164b6a6f35d5f31","outAccount":"p1350","outBankNo":"695603432","outIdCard":"500103001866567","outMemberId":"ff8080814faaed76014fabcbf1a40030","outMemberKind":"11","outRealName":"平台账户","outsideOrderDate":"20180720","outsideOrderNo":"PJK2018072015455165458","outsideSerialNo":"PT1807230003961940","payType":"2","resultStatus":1,"shareProfitDatas":[]},{"amount":"3744.77","currentOutsideOrderNo":"PJK2018102917242600110","currentOutsideSerialNo":"FR1810290453389","extraInterest":"0","fee":"0","inAccount":"PP201704111544090007708318","inBankNo":"6210193310201695771","inIdCard":"320681198207101020","inMemberId":"fdb3947e19fd4241a1bd5c47bd352877","inMemberKind":"0","inRealName":"朱海燕","orderId":"8a9aee2d630b63480164b6c18b785f3e","outAccount":"p1350","outBankNo":"695603432","outIdCard":"500103001866567","outMemberId":"ff8080814faaed76014fabcbf1a40030","outMemberKind":"11","outRealName":"平台账户","outsideOrderDate":"20180720","outsideOrderNo":"PJK2018072016145465502","outsideSerialNo":"PT1807230003961947","payType":"2","resultStatus":1,"shareProfitDatas":[]},{"amount":"10675.64","currentOutsideOrderNo":"PJK2018102917242600107","currentOutsideSerialNo":"FR1810290453392","extraInterest":"0","fee":"0","inAccount":"PP201703201055280007309993","inBankNo":"6210193310201463816","inIdCard":"510402197111240928","inMemberId":"0b622868900f45f78ca51dcc5590e1ce","inMemberKind":"0","inRealName":"李莉","orderId":"8a9aee2d630b63480164b676740c5ee3","outAccount":"p1350","outBankNo":"695603432","outIdCard":"500103001866567","outMemberId":"ff8080814faaed76014fabcbf1a40030","outMemberKind":"11","outRealName":"平台账户","outsideOrderDate":"20180720","outsideOrderNo":"PJK2018072014525365404","outsideSerialNo":"PT1807230003961948","payType":"2","resultStatus":1,"shareProfitDatas":[]},{"amount":"30528.00","currentOutsideOrderNo":"PJK2018102917242600104","currentOutsideSerialNo":"FR1810290453393","extraInterest":"0","fee":"0","inAccount":"PP201704171718210007829534","inBankNo":"6210193310201761557","inIdCard":"32048119830404221X","inMemberId":"246c9bfa0adc442fbdb0cb5fca7c7d43","inMemberKind":"0","inRealName":"梁涛","orderId":"8a9aee2d630b63480164b6447e7f5e94","outAccount":"p1350","outBankNo":"695603432","outIdCard":"500103001866567","outMemberId":"ff8080814faaed76014fabcbf1a40030","outMemberKind":"11","outRealName":"平台账户","outsideOrderDate":"20180720","outsideOrderNo":"PJK2018072013581965335","outsideSerialNo":"PT1807230003961945","payType":"2","resultStatus":1,"shareProfitDatas":[]},{"amount":"167.90","currentOutsideOrderNo":"PJK2018102917242600105","currentOutsideSerialNo":"FR1810290453394","extraInterest":"0","fee":"0","inAccount":"PP201704171718210007829534","inBankNo":"6210193310201761557","inIdCard":"32048119830404221X","inMemberId":"246c9bfa0adc442fbdb0cb5fca7c7d43","inMemberKind":"0","inRealName":"梁涛","orderId":"8a9aee2d630b63480164b646029a5e9b","outAccount":"p1350","outBankNo":"695603432","outIdCard":"500103001866567","outMemberId":"ff8080814faaed76014fabcbf1a40030","outMemberKind":"11","outRealName":"平台账户","outsideOrderDate":"20180720","outsideOrderNo":"PJK2018072013595865343","outsideSerialNo":"PT1807230003961949","payType":"2","resultStatus":1,"shareProfitDatas":[]}]}
[2018-10-29 17:37:02][DEBUG][CzbRepayServiceImpl.java:370] 浙商银行接口--还款申请--处理结束
[2018-10-29 17:37:02][DEBUG][PaymentRepayConfirmServiceImpl.java:333] 调用PayAPI还款接口返回数据
[2018-10-29 17:37:02][DEBUG][PaymentRepayConfirmServiceImpl.java:515] 还款确认--保存支付返回的数据--开始处理
[2018-10-29 17:37:02][DEBUG][PaymentRepayConfirmServiceImpl.java:516] 还款确认--保存支付返回的数据--1、保存出借者收益表
[2018-10-29 17:37:02][DEBUG][PaymentRepayConfirmServiceImpl.java:520] 还款确认--保存支付返回的数据--处理结束