pjk-20181029check/logs/日志2/日志/9181/2.txt

[2018-01-04 11:30:59][DEBUG][CzbProductManageServiceImpl.java:35] 浙商银行接口--项目登记--处理开始
[2018-01-04 11:30:59][DEBUG][CzbProductManageServiceImpl.java:43] 浙商银行接口--项目登记--第一步、请求参数:{"acctName":"上海统硕贸易有限公司","acctNo":"121917493410101","bankBranchNo":"308290003556","borrowIdNo":"92510100MA6CML1A42","borrowIdType":"2","borrowType":"1","curCode":"001","idCard":"92510100MA6CML1A42","interestBeginDate":"20180103","interestEndDate":"20180214","investDuration":"42","isCurrentBankFlag":"1","isPersonFlag":"1","payType":"1","platformPoundage":"10300","platformPoundageRate":"103.00","productAmount":"99281.0000","productId":"P-180103130936267461","productName":"银票宝9181期","projectBeginTime":"20180103","projectEndDate":"20180103","rate":"6.20","repayDate":"20180214","repayRate":"6.20","repayType":"729.72","returnUrl":""}
[2018-01-04 11:30:59][DEBUG][CzbProductManageServiceImpl.java:105] 浙商银行接口--项目登记--第二步、验证数据
[2018-01-04 11:30:59][DEBUG][CzbProductManageServiceImpl.java:108] 浙商银行接口--项目登记--处理--第三步：生成HttpClient请求数据
[2018-01-04 11:30:59][DEBUG][XMLUtils.java:164] 生成请求报文--reqMessage:<Finance><Message id="2018010411305902258"><PIReq id="PIReq">
    <version>1.0.0</version>
    <instId>PJK</instId>
    <certId>0020</certId>
    <date>20180104 11:30:59</date>
    <ProjectId>PJK-180103130936267461</ProjectId>
    <ProjectName>银票宝9181期</ProjectName>
    <ProjectBeginTime>20180103</ProjectBeginTime>
    <ProjectEndDate>20180103</ProjectEndDate>
    <InterestBeginDate>20180103</InterestBeginDate>
    <InterestEndDate>20180214</InterestEndDate>
    <RepayDate>20180214</RepayDate>
    <InvestDuration>42</InvestDuration>
    <Rate>6.20</Rate>
    <Amount>9928100</Amount>
    <RepayType>72972</RepayType>
    <RepayRate>6.20</RepayRate>
    <RepayName>上海统硕贸易有限公司</RepayName>
    <RepayAcct>121917493410101</RepayAcct>
    <Person>1</Person>
    <Flag>1</Flag>
    <certType>2</certType>
    <certNo>92510100MA6CML1A42</certNo>
    <JKRtype>1</JKRtype>
    <BankBranchNo>308290003556</BankBranchNo>
    <AdvanceRepayment>1</AdvanceRepayment>
    <OverdueRepayment>1</OverdueRepayment>
    <AdvanceDay>365</AdvanceDay>
    <OverdueDay>365</OverdueDay>
    <IsTransfer>1</IsTransfer>
    <GatherFee>1</GatherFee>
    <GatherFeePoint>0</GatherFeePoint>
    <GatherFeeType>0</GatherFeeType>
    <GatherFeeContent>103.00</GatherFeeContent>
    <extension></extension>
</PIReq></Message></Finance>
[2018-01-04 11:30:59][DEBUG][CzbProductManageServiceImpl.java:111] 浙商银行接口--项目登记--处理--第四步：HttpClient请求
[2018-01-04 11:30:59][DEBUG][CzbProductManageServiceImpl.java:113] 浙商银行接口--项目登记--返回参数：<Finance><Message id="2018010411305902258"><PIRes id="PIRes"><version>1.0.0</version><instId>CZBANK</instId><certId>0001</certId><Riskstt>1</Riskstt></PIRes><ds:Signature xmlns:ds="http://www.w3.org/2000/09/xmldsig#">
<ds:SignedInfo>
<ds:CanonicalizationMethod Algorithm="http://www.w3.org/TR/2001/REC-xml-c14n-20010315"></ds:CanonicalizationMethod>
<ds:SignatureMethod Algorithm="http://www.w3.org/2000/09/xmldsig#rsa-sha1"></ds:SignatureMethod>
<ds:Reference URI="#PIRes">
<ds:Transforms>
<ds:Transform Algorithm="http://www.w3.org/2000/09/xmldsig#enveloped-signature"></ds:Transform>
</ds:Transforms>
<ds:DigestMethod Algorithm="http://www.w3.org/2000/09/xmldsig#sha1"></ds:DigestMethod>
<ds:DigestValue>ke4X3m3UIFPu0b7pbOgKmT+A2w8=</ds:DigestValue>
</ds:Reference>
</ds:SignedInfo>
<ds:SignatureValue>
VgIh1liPEUYmVmY6oFtRG9gw/2wwNkL7fhBamQd9AA7stw0JazH/H/tvNHwpixWDGX9hSuQPVFsJ
DQY5PK9b/0RsF/JosogymYVX2lFO7hEADJjozSLWJpZmswwjZKVAlySV0DVxXsyLbsbpgf/x5/Ws
R3IWXvY8cbeK8bKI8n0wRIFvmZX/UtLj4i4Tb+OwXK+OP2uxJtAEcjvYk+/Xd7HsYSMzy0ttujvn
am2ObeutxW6MrglzVjkzVKWS48QCmd13dkNl5BNCZo70TsdgceyMiOqwCTxQ+W2PMIjVG+T5TuGp
7EdXh6tbOcJUxtcJ1d2fxuvpNyMSNZze4/7ULA==
</ds:SignatureValue>
</ds:Signature></Message></Finance>---------
[2018-01-04 11:30:59][DEBUG][CzbProductManageServiceImpl.java:114] 浙商银行接口--项目登记--处理--第五步：装箱返回数据
[2018-01-04 11:30:59][DEBUG][CzbProductManageServiceImpl.java:130] 浙商银行接口--项目登记--结果：BaseResponse [interactionCode=4, interactionDesc=成功, resultDataJson=null, needForward=false, requestUrl=null, requestMap={riskstt=1}, successFlag=, requestFlag=1]
[2018-01-04 11:30:59][DEBUG][CzbProductManageServiceImpl.java:131] 浙商银行接口--项目登记--处理结束
[2018-01-04 11:30:59][INFO ][FinancialManagementServiceImpl.java:796] 非订单模式，放款阶段生成申请放款记录。
[2018-01-04 11:30:59][INFO ][FinancialManagementServiceImpl.java:1224] 放款时，费用计算开始！
[2018-01-04 11:30:59][INFO ][FeeCalcTemplateFactory.java:53] 取得计算后产品费用列表开始。
[2018-01-04 11:30:59][INFO ][FeeCalcTemplateFactory.java:96] 方法getProInfoForFeeCalcModel，资金数据开始封装。
[2018-01-04 11:30:59][DEBUG][ProductListener.java:40] product status changed:80->80, productId=8a9aee2d6092e3cf0160ba6cbb8b3272, productNm=银票宝9181期
[2018-01-04 11:30:59][INFO ][FeeCalcTemplateFactory.java:178] 方法getProInfoForFeeCalcModel，资金数据结束封装。
[2018-01-04 11:30:59][INFO ][FeeCalcTemplateFactory.java:64] 取得计算后产品费用列表结束。
[2018-01-04 11:30:59][INFO ][FinancialManagementServiceImpl.java:1311] 投资人账号:PP201703191649570007300952
[2018-01-04 11:30:59][INFO ][FinancialManagementServiceImpl.java:1311] 投资人账号:PP201703301034370007502747
[2018-01-04 11:30:59][INFO ][FinancialManagementServiceImpl.java:1311] 投资人账号:PP201703251851490007423795
[2018-01-04 11:30:59][INFO ][FinancialManagementServiceImpl.java:1311] 投资人账号:PP201703211058520007333647
[2018-01-04 11:30:59][INFO ][FinancialManagementServiceImpl.java:1485] 放款时，费用计算结束！
[2018-01-04 11:30:59][INFO ][FinancialManagementServiceImpl.java:801] 开始调用放款支付接口！
[2018-01-04 11:30:59][DEBUG][CzbLoanServiceImpl.java:154] 浙商银行接口--放款服务--处理开始
[2018-01-04 11:30:59][DEBUG][CzbLoanServiceImpl.java:209] 浙商银行接口--放款服务--第一步，通过单笔流水查询判断本次需要传递的数据
[2018-01-04 11:30:59][DEBUG][XMLUtils.java:164] 生成请求报文--reqMessage:<Finance><Message id="2018010411305902259"><TSQReq id="TSQReq">
    <version>1.0.0</version>
    <instId>PJK</instId>
    <certId>0020</certId>
    <date>20180104 11:30:59</date>
    <orderNo>PJK2018010313372506958</orderNo>
    <type>5</type>
</TSQReq></Message></Finance>
[2018-01-04 11:30:59][DEBUG][CzbQueryServiceImpl.java:70] 单笔流水查询--HttpClient请求结果：<Finance><Message id="2018010411305902259"><Error id="Error"><version>1.0.0</version><instId>CZBANK</instId><certId>0001</certId><errorCode>60000</errorCode><errorMessage>无相应记录</errorMessage><errorDetail>无相应记录</errorDetail></Error><ds:Signature xmlns:ds="http://www.w3.org/2000/09/xmldsig#">
<ds:SignedInfo>
<ds:CanonicalizationMethod Algorithm="http://www.w3.org/TR/2001/REC-xml-c14n-20010315"></ds:CanonicalizationMethod>
<ds:SignatureMethod Algorithm="http://www.w3.org/2000/09/xmldsig#rsa-sha1"></ds:SignatureMethod>
<ds:Reference URI="#Error">
<ds:Transforms>
<ds:Transform Algorithm="http://www.w3.org/2000/09/xmldsig#enveloped-signature"></ds:Transform>
</ds:Transforms>
<ds:DigestMethod Algorithm="http://www.w3.org/2000/09/xmldsig#sha1"></ds:DigestMethod>
<ds:DigestValue>p4Ddqso1fnLDQigi/gAfFHcyx7g=</ds:DigestValue>
</ds:Reference>
</ds:SignedInfo>
<ds:SignatureValue>
l9H907jVCiMAJzMyh5NsAqxyPJ/fz6HqRbDhBWM9zBEqPOZgoK8/+FTmU6IerjlJiGuoMtR2f3Tp
m8OvqbqUW+VDkdlHw+Z4yIEBzE+6O7PvQGoXB5T3Zp3VbtUV7Bjx7a2edKPd4/4ohlLsOtJL5EgO
yCJQMd05WQHotm9WdmgL+iTinKxPAyAyXQreIr4RgsHQJpfRj1ql2VNrvhIm1GZ9fSzXoHforghY
PJeUakAaiG70xDLsapa4qLrC3w4YVMGvILISszn13lL5+5Q9Pa+E705LycfoDbZQNHoYRKfujgNh
gmoKEU+ngRfTXLxdbgUkK57bkpHAKcsuuJZ5IQ==
</ds:SignatureValue>
</ds:Signature></Message></Finance>---------
[2018-01-04 11:30:59][DEBUG][XMLUtils.java:164] 生成请求报文--reqMessage:<Finance><Message id="2018010411305902260"><TSQReq id="TSQReq">
    <version>1.0.0</version>
    <instId>PJK</instId>
    <certId>0020</certId>
    <date>20180104 11:30:59</date>
    <orderNo>PJK2018010314491407077</orderNo>
    <type>5</type>
</TSQReq></Message></Finance>
[2018-01-04 11:30:59][DEBUG][CzbQueryServiceImpl.java:70] 单笔流水查询--HttpClient请求结果：<Finance><Message id="2018010411305902260"><Error id="Error"><version>1.0.0</version><instId>CZBANK</instId><certId>0001</certId><errorCode>60000</errorCode><errorMessage>无相应记录</errorMessage><errorDetail>无相应记录</errorDetail></Error><ds:Signature xmlns:ds="http://www.w3.org/2000/09/xmldsig#">
<ds:SignedInfo>
<ds:CanonicalizationMethod Algorithm="http://www.w3.org/TR/2001/REC-xml-c14n-20010315"></ds:CanonicalizationMethod>
<ds:SignatureMethod Algorithm="http://www.w3.org/2000/09/xmldsig#rsa-sha1"></ds:SignatureMethod>
<ds:Reference URI="#Error">
<ds:Transforms>
<ds:Transform Algorithm="http://www.w3.org/2000/09/xmldsig#enveloped-signature"></ds:Transform>
</ds:Transforms>
<ds:DigestMethod Algorithm="http://www.w3.org/2000/09/xmldsig#sha1"></ds:DigestMethod>
<ds:DigestValue>p4Ddqso1fnLDQigi/gAfFHcyx7g=</ds:DigestValue>
</ds:Reference>
</ds:SignedInfo>
<ds:SignatureValue>
l9H907jVCiMAJzMyh5NsAqxyPJ/fz6HqRbDhBWM9zBEqPOZgoK8/+FTmU6IerjlJiGuoMtR2f3Tp
m8OvqbqUW+VDkdlHw+Z4yIEBzE+6O7PvQGoXB5T3Zp3VbtUV7Bjx7a2edKPd4/4ohlLsOtJL5EgO
yCJQMd05WQHotm9WdmgL+iTinKxPAyAyXQreIr4RgsHQJpfRj1ql2VNrvhIm1GZ9fSzXoHforghY
PJeUakAaiG70xDLsapa4qLrC3w4YVMGvILISszn13lL5+5Q9Pa+E705LycfoDbZQNHoYRKfujgNh
gmoKEU+ngRfTXLxdbgUkK57bkpHAKcsuuJZ5IQ==
</ds:SignatureValue>
</ds:Signature></Message></Finance>---------
[2018-01-04 11:30:59][DEBUG][XMLUtils.java:164] 生成请求报文--reqMessage:<Finance><Message id="2018010411305902261"><TSQReq id="TSQReq">
    <version>1.0.0</version>
    <instId>PJK</instId>
    <certId>0020</certId>
    <date>20180104 11:30:59</date>
    <orderNo>PJK2018010314523207099</orderNo>
    <type>5</type>
</TSQReq></Message></Finance>
[2018-01-04 11:30:59][DEBUG][CzbQueryServiceImpl.java:70] 单笔流水查询--HttpClient请求结果：<Finance><Message id="2018010411305902261"><Error id="Error"><version>1.0.0</version><instId>CZBANK</instId><certId>0001</certId><errorCode>60000</errorCode><errorMessage>无相应记录</errorMessage><errorDetail>无相应记录</errorDetail></Error><ds:Signature xmlns:ds="http://www.w3.org/2000/09/xmldsig#">
<ds:SignedInfo>
<ds:CanonicalizationMethod Algorithm="http://www.w3.org/TR/2001/REC-xml-c14n-20010315"></ds:CanonicalizationMethod>
<ds:SignatureMethod Algorithm="http://www.w3.org/2000/09/xmldsig#rsa-sha1"></ds:SignatureMethod>
<ds:Reference URI="#Error">
<ds:Transforms>
<ds:Transform Algorithm="http://www.w3.org/2000/09/xmldsig#enveloped-signature"></ds:Transform>
</ds:Transforms>
<ds:DigestMethod Algorithm="http://www.w3.org/2000/09/xmldsig#sha1"></ds:DigestMethod>
<ds:DigestValue>p4Ddqso1fnLDQigi/gAfFHcyx7g=</ds:DigestValue>
</ds:Reference>
</ds:SignedInfo>
<ds:SignatureValue>
l9H907jVCiMAJzMyh5NsAqxyPJ/fz6HqRbDhBWM9zBEqPOZgoK8/+FTmU6IerjlJiGuoMtR2f3Tp
m8OvqbqUW+VDkdlHw+Z4yIEBzE+6O7PvQGoXB5T3Zp3VbtUV7Bjx7a2edKPd4/4ohlLsOtJL5EgO
yCJQMd05WQHotm9WdmgL+iTinKxPAyAyXQreIr4RgsHQJpfRj1ql2VNrvhIm1GZ9fSzXoHforghY
PJeUakAaiG70xDLsapa4qLrC3w4YVMGvILISszn13lL5+5Q9Pa+E705LycfoDbZQNHoYRKfujgNh
gmoKEU+ngRfTXLxdbgUkK57bkpHAKcsuuJZ5IQ==
</ds:SignatureValue>
</ds:Signature></Message></Finance>---------
[2018-01-04 11:30:59][DEBUG][XMLUtils.java:164] 生成请求报文--reqMessage:<Finance><Message id="2018010411305902262"><TSQReq id="TSQReq">
    <version>1.0.0</version>
    <instId>PJK</instId>
    <certId>0020</certId>
    <date>20180104 11:30:59</date>
    <orderNo>PJK2018010315572807173</orderNo>
    <type>5</type>
</TSQReq></Message></Finance>
[2018-01-04 11:30:59][DEBUG][CzbQueryServiceImpl.java:70] 单笔流水查询--HttpClient请求结果：<Finance><Message id="2018010411305902262"><Error id="Error"><version>1.0.0</version><instId>CZBANK</instId><certId>0001</certId><errorCode>60000</errorCode><errorMessage>无相应记录</errorMessage><errorDetail>无相应记录</errorDetail></Error><ds:Signature xmlns:ds="http://www.w3.org/2000/09/xmldsig#">
<ds:SignedInfo>
<ds:CanonicalizationMethod Algorithm="http://www.w3.org/TR/2001/REC-xml-c14n-20010315"></ds:CanonicalizationMethod>
<ds:SignatureMethod Algorithm="http://www.w3.org/2000/09/xmldsig#rsa-sha1"></ds:SignatureMethod>
<ds:Reference URI="#Error">
<ds:Transforms>
<ds:Transform Algorithm="http://www.w3.org/2000/09/xmldsig#enveloped-signature"></ds:Transform>
</ds:Transforms>
<ds:DigestMethod Algorithm="http://www.w3.org/2000/09/xmldsig#sha1"></ds:DigestMethod>
<ds:DigestValue>p4Ddqso1fnLDQigi/gAfFHcyx7g=</ds:DigestValue>
</ds:Reference>
</ds:SignedInfo>
<ds:SignatureValue>
l9H907jVCiMAJzMyh5NsAqxyPJ/fz6HqRbDhBWM9zBEqPOZgoK8/+FTmU6IerjlJiGuoMtR2f3Tp
m8OvqbqUW+VDkdlHw+Z4yIEBzE+6O7PvQGoXB5T3Zp3VbtUV7Bjx7a2edKPd4/4ohlLsOtJL5EgO
yCJQMd05WQHotm9WdmgL+iTinKxPAyAyXQreIr4RgsHQJpfRj1ql2VNrvhIm1GZ9fSzXoHforghY
PJeUakAaiG70xDLsapa4qLrC3w4YVMGvILISszn13lL5+5Q9Pa+E705LycfoDbZQNHoYRKfujgNh
gmoKEU+ngRfTXLxdbgUkK57bkpHAKcsuuJZ5IQ==
</ds:SignatureValue>
</ds:Signature></Message></Finance>---------
[2018-01-04 11:30:59][DEBUG][CzbLoanServiceImpl.java:245] 浙商银行接口--放款服务--第二步处理结果--已经登记数据:[]
[2018-01-04 11:30:59][DEBUG][CzbLoanServiceImpl.java:246] 浙商银行接口--放款服务--第二步处理结果--本次需要登记数据:[{"amount":"5000.00","inAccount":"","inBankNo":"121917493410101","inMemberId":"8a80d78557576efe015757bd59d30029","inMemberKind":"1","inRealCd":"17717554963","inRealName":"上海统硕贸易有限公司","interestCapital":"36.75","orderId":"8a9aee2d6092e4640160ba8635051ac6","outAccount":"PP201703191649570007300952","outBankNo":"6210193310201457347","outIdCard":"510702197310041282","outMemberId":"8a80d78557576efe015757bd59d30029","outMemberKind":"0","outRealName":"朱莉","outsideOrderDate":"20180103","outsideOrderNo":"PJK2018010313372506958","outsideSerialNo":"PP1801033141525","resultStatus":0,"shareProfitDatas":[]},{"amount":"25848.00","inAccount":"","inBankNo":"121917493410101","inMemberId":"8a80d78557576efe015757bd59d30029","inMemberKind":"1","inRealCd":"17717554963","inRealName":"上海统硕贸易有限公司","interestCapital":"189.98","orderId":"8a9aee2d6092e4640160bac7f5261b1a","outAccount":"PP201703301034370007502747","outBankNo":"6210193310201584579","outIdCard":"310106199012272810","outMemberId":"8a80d78557576efe015757bd59d30029","outMemberKind":"0","outRealName":"虞嘉骏","outsideOrderDate":"20180103","outsideOrderNo":"PJK2018010314491407077","outsideSerialNo":"PP1801033142791","resultStatus":0,"shareProfitDatas":[]},{"amount":"48779.00","inAccount":"","inBankNo":"121917493410101","inMemberId":"8a80d78557576efe015757bd59d30029","inMemberKind":"1","inRealCd":"17717554963","inRealName":"上海统硕贸易有限公司","interestCapital":"358.53","orderId":"8a9aee2d6092e4640160bacaf9071b29","outAccount":"PP201703251851490007423795","outBankNo":"6210193310201539599","outIdCard":"342322195511182043","outMemberId":"8a80d78557576efe015757bd59d30029","outMemberKind":"0","outRealName":"张家英","outsideOrderDate":"20180103","outsideOrderNo":"PJK2018010314523207099","outsideSerialNo":"PP1801033142830","resultStatus":0,"shareProfitDatas":[]},{"amount":"19654.00","inAccount":"","inBankNo":"121917493410101","inMemberId":"8a80d78557576efe015757bd59d30029","inMemberKind":"1","inRealCd":"17717554963","inRealName":"上海统硕贸易有限公司","interestCapital":"144.46","orderId":"8a9aee2d6092e4640160bb066bbe1b81","outAccount":"PP201703211058520007333647","outBankNo":"6210193310201478012","outIdCard":"110108195801294913","outMemberId":"8a80d78557576efe015757bd59d30029","outMemberKind":"0","outRealName":"熊晓牧","outsideOrderDate":"20180103","outsideOrderNo":"PJK2018010315572807173","outsideSerialNo":"PP1801033143517","resultStatus":0,"shareProfitDatas":[]}]
[2018-01-04 11:30:59][DEBUG][CzbLoanServiceImpl.java:261] 浙商银行接口--放款服务--第四步，验证每一笔投资的资金冻结流水号
[2018-01-04 11:30:59][DEBUG][CzbLoanServiceImpl.java:357] 浙商银行接口--放款服务--线程睡眠5秒！--第[1]次调用还款
[2018-01-04 11:31:00][INFO ][AbstractJob.java:77] 任务开始[1005]定时从已上架状态转为招标中状态
[2018-01-04 11:31:00][INFO ][ProductToTenderJob.java:32] 已上架-->招标中 产品数=0
[2018-01-04 11:31:00][INFO ][AbstractJob.java:89] 任务完成[1005]定时从已上架状态转为招标中状态
[2018-01-04 11:31:01][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-01-04 11:31:01][DEBUG][BaseJdbcLogger.java:139] ==> Parameters: 0(Integer), 1000000000(Integer)
[2018-01-04 11:31:01][DEBUG][BaseJdbcLogger.java:139] <==      Total: 0
[2018-01-04 11:31:01][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-01-04 11:31:01][DEBUG][BaseJdbcLogger.java:139] ==> Parameters: 
[2018-01-04 11:31:01][DEBUG][BaseJdbcLogger.java:139] <==      Total: 1
[2018-01-04 11:31:01][DEBUG][BaseJdbcLogger.java:139] ==>  Preparing: SELECT p.productId, p.productCd, p.productNm, m.realNm, c.companyNm, a.spv, 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-01-04 11:31:01][DEBUG][BaseJdbcLogger.java:139] ==> Parameters: 0(Integer), 1000000000(Integer)
[2018-01-04 11:31:01][DEBUG][BaseJdbcLogger.java:139] <==      Total: 0
[2018-01-04 11:31:01][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 WHERE rip.ItemTypeId = 100000 AND rip.STATUS = 0 and rip.repayDate < now() and p.status = 90 AND NOT EXISTS ( SELECT 1 FROM repay r WHERE r.period = rip.period AND r.productId = rip.productId ) 
[2018-01-04 11:31:01][DEBUG][BaseJdbcLogger.java:139] ==> Parameters: 
[2018-01-04 11:31:01][DEBUG][BaseJdbcLogger.java:139] <==      Total: 1
[2018-01-04 11:31:03][INFO ][AbstractJob.java:77] 任务开始[1003]定时从待上架状态转为满标或流标状态
[2018-01-04 11:31:03][INFO ][ProductToFullOrFlowScaleJob.java:28] 招标中-->流标待处理 产品数=0
[2018-01-04 11:31:03][INFO ][AbstractJob.java:89] 任务完成[1003]定时从待上架状态转为满标或流标状态
[2018-01-04 11:31:04][INFO ][AbstractJob.java:77] 任务开始[1004]定时从待上架状态转为已上架状态
[2018-01-04 11:31:04][INFO ][ProductToGroundJob.java:32] 待上架-->已上架 产品数=0
[2018-01-04 11:31:04][INFO ][AbstractJob.java:89] 任务完成[1004]定时从待上架状态转为已上架状态
[2018-01-04 11:31:04][DEBUG][CzbLoanServiceImpl.java:364] 浙商银行接口--放款服务--调用支付的项目投资信息登记--处理开始
[2018-01-04 11:31:04][DEBUG][CzbLoanServiceImpl.java:365] 浙商银行接口--放款服务--调用支付的项目投资信息登记--数据验证
[2018-01-04 11:31:04][DEBUG][CzbLoanServiceImpl.java:367] 浙商银行接口--放款服务--调用支付的项目投资信息登记--生成HttpClient请求数据
[2018-01-04 11:31:04][DEBUG][XMLUtils.java:164] 生成请求报文--reqMessage:<Finance><Message id="2018010411310402263"><PTRReq id="PTRReq">
    <Amout>9928100</Amout>
    <BatchFlag>1</BatchFlag>
    <certId>0020</certId>
    <Count>4</Count>
    <date>20180104 11:31:04</date>
    <instId>PJK</instId>
    <List>
        <Record>
            <P2PserialNo>PJK2018010314523207099</P2PserialNo>
            <Realname>张家英</Realname>
            <certType>1</certType>
            <certNo>342322195511182043</certNo>
            <bindSerialNo>PP201703251851490007423795</bindSerialNo>
            <PayNum>PP1801033142830</PayNum>
            <InvestmentAmount>4877900</InvestmentAmount>
            <InterestCapital>35853</InterestCapital>
            <currency>156</currency>
            <Type>0</Type>
            <AccountBankNumber></AccountBankNumber>
            <AccountName></AccountName>
            <BankBranchNo></BankBranchNo>
        </Record>
        <Record>
            <P2PserialNo>PJK2018010315572807173</P2PserialNo>
            <Realname>熊晓牧</Realname>
            <certType>1</certType>
            <certNo>110108195801294913</certNo>
            <bindSerialNo>PP201703211058520007333647</bindSerialNo>
            <PayNum>PP1801033143517</PayNum>
            <InvestmentAmount>1965400</InvestmentAmount>
            <InterestCapital>14446</InterestCapital>
            <currency>156</currency>
            <Type>0</Type>
            <AccountBankNumber></AccountBankNumber>
            <AccountName></AccountName>
            <BankBranchNo></BankBranchNo>
        </Record>
        <Record>
            <P2PserialNo>PJK2018010314491407077</P2PserialNo>
            <Realname>虞嘉骏</Realname>
            <certType>1</certType>
            <certNo>310106199012272810</certNo>
            <bindSerialNo>PP201703301034370007502747</bindSerialNo>
            <PayNum>PP1801033142791</PayNum>
            <InvestmentAmount>2584800</InvestmentAmount>
            <InterestCapital>18998</InterestCapital>
            <currency>156</currency>
            <Type>0</Type>
            <AccountBankNumber></AccountBankNumber>
            <AccountName></AccountName>
            <BankBranchNo></BankBranchNo>
        </Record>
        <Record>
            <P2PserialNo>PJK2018010313372506958</P2PserialNo>
            <Realname>朱莉</Realname>
            <certType>1</certType>
            <certNo>510702197310041282</certNo>
            <bindSerialNo>PP201703191649570007300952</bindSerialNo>
            <PayNum>PP1801033141525</PayNum>
            <InvestmentAmount>500000</InvestmentAmount>
            <InterestCapital>3675</InterestCapital>
            <currency>156</currency>
            <Type>0</Type>
            <AccountBankNumber></AccountBankNumber>
            <AccountName></AccountName>
            <BankBranchNo></BankBranchNo>
        </Record>
    </List>
    <ProjectId>PJK-180103130936267461</ProjectId>
    <ProjectName>银票宝9181期</ProjectName>
    <ProjectStatus>1</ProjectStatus>
    <RepayAcct>121917493410101</RepayAcct>
    <RepayName>上海统硕贸易有限公司</RepayName>
    <version>1.0.0</version>
</PTRReq></Message></Finance>
[2018-01-04 11:31:04][DEBUG][CzbLoanServiceImpl.java:369] 浙商银行接口--调用支付的项目投资信息登记--HttpClient请求
[2018-01-04 11:31:04][DEBUG][CzbLoanServiceImpl.java:371] HttpClient请求结果：<Finance><Message id="2018010411310402263"><PTRRes id="PTRRes"><version>1.0.0</version><instId>CZBANK</instId><certId>0001</certId><succount>4</succount><sucsum>9928100</sucsum><failcount>0</failcount><failsum>0</failsum><List><Record><P2PserialNo>PJK2018010314523207099</P2PserialNo><InvestmentStatus>20</InvestmentStatus><InvestmentSerialNo>PT1801043653990</InvestmentSerialNo></Record><Record><P2PserialNo>PJK2018010315572807173</P2PserialNo><InvestmentStatus>20</InvestmentStatus><InvestmentSerialNo>PT1801043653991</InvestmentSerialNo></Record><Record><P2PserialNo>PJK2018010314491407077</P2PserialNo><InvestmentStatus>20</InvestmentStatus><InvestmentSerialNo>PT1801043653992</InvestmentSerialNo></Record><Record><P2PserialNo>PJK2018010313372506958</P2PserialNo><InvestmentStatus>20</InvestmentStatus><InvestmentSerialNo>PT1801043653993</InvestmentSerialNo></Record></List></PTRRes><ds:Signature xmlns:ds="http://www.w3.org/2000/09/xmldsig#">
<ds:SignedInfo>
<ds:CanonicalizationMethod Algorithm="http://www.w3.org/TR/2001/REC-xml-c14n-20010315"></ds:CanonicalizationMethod>
<ds:SignatureMethod Algorithm="http://www.w3.org/2000/09/xmldsig#rsa-sha1"></ds:SignatureMethod>
<ds:Reference URI="#PTRRes">
<ds:Transforms>
<ds:Transform Algorithm="http://www.w3.org/2000/09/xmldsig#enveloped-signature"></ds:Transform>
</ds:Transforms>
<ds:DigestMethod Algorithm="http://www.w3.org/2000/09/xmldsig#sha1"></ds:DigestMethod>
<ds:DigestValue>sgIu3xT4b5R9Wxh/Q5ko08R7CPU=</ds:DigestValue>
</ds:Reference>
</ds:SignedInfo>
<ds:SignatureValue>
T4LZfbTtrN87HxpcG6QrNKr5PE+VqRXETSLTCBfLJq7uIdXvqDM1GmHLuJGwmEt2sm6F1SWLlk8Q
CspiI85qaBtitSHjVJQzk6n3VfszE7eVcsv5Zsz4ncoLwi7mqsD73OuqhW+SAs2TN1BmyY3d1x4w
3Y+PTDVx4lcuGNnZgf/mv7iFHOX6x3zUwINLrY/Eg9pjlCU/GeMK7JiD2Efx+ncmDrggljzNHcXf
SHlA4hCRWFlb9jRV9u/g/+RmJhqveLsYOXEEVjLJG14R2T6v6KmKsQzif8DKQlNdAO6/cLXLk+Ms
C56TVhqapFVr8WGsASg/H86cmaT4ufTDKxGETg==
</ds:SignatureValue>
</ds:Signature></Message></Finance>---------
[2018-01-04 11:31:04][DEBUG][CzbLoanServiceImpl.java:372] 浙商银行接口--放款服务--调用支付的项目投资信息登记--装箱返回数据
[2018-01-04 11:31:04][DEBUG][CzbLoanServiceImpl.java:408] 浙商银行接口--放款服务--调用支付的项目投资信息登记--处理结束
[2018-01-04 11:31:04][DEBUG][CzbLoanServiceImpl.java:343] 浙商银行接口--放款服务--处理结束