如何处理微信小程序支付下载下来的对账单以及证书读取

拼搏现实的明天。 2022-03-08 08:54 213阅读 0赞

在网上稍微搜了一下,有一篇介绍了如何处理,但那时候的对账单数据与我现在下载下来的似乎有点误差,在这里我不谈论对方的方法对错,我只写下自己的处理过程.

首先,先看下获取的对账单数据:

2019-03-13 17:20:09,wx10796e586721729e,1526775301,0,,4200000257201903132495667456,555439938150072320,o-YLy5CNWR2\_tR-pzvgs5kzU-82g,JSAPI,SUCCESS,COMM\_CREDIT,CNY,1.00,0.00,0,0,0.00,0.00,,,天虹基金管理会,PAYMENT\_EXPERIENCE\_FEE,0.01000,0.60%,1.00,0.00,\\\\r\\\\n2019-03-13 17:33:55,wx10796e586721729e,1526775301,0,,4200000257201903132495667456,555439938150072320,o-YLy5CNWR2\_tR-pzvgs5kzU-82g,JSAPI,REFUND,COMM\_CREDIT,CNY,0.00,0.00,50000010172019031308710710739,1038374382019031324956674561552469612,1.00,0.00,ORIGINAL,SUCCESS,天虹基金管理会,PAYMENT\_EXPERIENCE\_FEE,-0.01000,0.60%,0.00,1.00,\\\\r\\\\n

如上,这是稍加处理的数据,把文字头去掉以及后面汇总数据还有单点\`符号(后面会贴处理代码).

拿到这样的一份数据,其实大家应该都能看出来只需要截取\\\\r\\\\n就可以取出两份字符串数组了,但是今天在截取这个"回车换行"符的时候着实折腾了半天,算是与大家分享一下自己踩得坑吧.我在网上搜了半天,找到说用"\\r?\\n"或者"\\\\r?\\\\n"代替的,但是最终都没有实现.最终,我还是在群里问了一下,说是先用replace方法把"\\\\r\\\\n"替换掉,再去用替换的字符分割,还有就是千万不要用string的replaceAll方法,而是用replace方法...

@Scheduled(cron = "0 0 10 * * ?")
    	public void doDownloadBill() throws Exception {
    		WXPay wxpay = new WXPay(WXPayConfigImpl.getInstance());
    		HashMap<String, String> data = new HashMap<String, String>();
    		data.put("bill_date", DateTimeUtil.getTimeShortString(DateUtils.addDateDays(new Date(), -1)));
    		data.put("bill_type", "ALL");
    		try {
    			Map<String, String> r = wxpay.downloadBill(data);
    			String result = JsonMapper.obj2String(r);
    			String tradeMsg = result.substring(result.indexOf("`"));
    			String tradeInfo = tradeMsg.substring(0, tradeMsg.indexOf("总"))
    					.replace("`", "");// 去掉汇总数据，并且去掉'`'
    			String[] tradeArray = tradeInfo.replace("\\r\\n", " wc").split("wc"); // i wanna say nothing
    			for (String tradeDetailInfo : tradeArray) {
    				String[] tradeDetailArray = tradeDetailInfo.split(",");
    				BillEntity bill = BillEntity.builder().id(IdGenerator.nextId())
    						.tradedate(DateUtils.stringToDate(tradeDetailArray[0]))
    						.commonid(tradeDetailArray[1])
    						.businessno(tradeDetailArray[2])
    						.specialbusinessno(tradeDetailArray[3])
    						.deviceno(tradeDetailArray[4])
    						.wxorderno(tradeDetailArray[5])
    						.businessorderno(Long.valueOf(tradeDetailArray[6]))
    						.usertype(tradeDetailArray[7])
    						.tradetype(tradeDetailArray[8])
    						.tradestatus(tradeDetailArray[9])
    						.paybank(tradeDetailArray[10])
    						.moneytype(tradeDetailArray[11])
    						.payordermoney(new BigDecimal(tradeDetailArray[12]))
    						.paperreplacemoney(new BigDecimal(tradeDetailArray[13]))
    						.wxrefundno(tradeDetailArray[14])
    						.businessrefundno(tradeDetailArray[15])
    						.refundamount(new BigDecimal(tradeDetailArray[16]))
    						.rechargerefundamount(
    								new BigDecimal(tradeDetailArray[17]))
    						.refundtype(tradeDetailArray[18])
    						.refundstatus(tradeDetailArray[19])
    						.businessname(tradeDetailArray[20])
    						.businessdata(tradeDetailArray[21])
    						.fee(new BigDecimal(tradeDetailArray[22]))
    						.feerate(tradeDetailArray[23])
    						.orderamount(new BigDecimal(tradeDetailArray[24]))
    						.applyrefundamount(new BigDecimal(tradeDetailArray[25]))
    						.feeratenote(tradeDetailArray[26])
    						.createdate(new Date()).build();
    				billMapper.insert(bill);
    			}
    		} catch (Exception e) {
    			e.printStackTrace();
    		}
    	}

[微信小程序支付sdk二次封装(开箱即用)][sdk]

最近,做微信退款时遇到点小问题,就直接在这下面更新:由于拉取对账单不需要证书,因此我就项目中初始化了一下并没有注意,现在退款需要读取证书内容转化为字节数组.之前,我是将证书放在服务器上固定路径,代码中直接读取文件,后来由于线上环境麻烦,因此就讲证书放在了项目下的resource文件中,因而遇到了读取不到的问题

[这里有一篇介绍读取springboot中resource下文件的介绍][springboot_resource]

下面贴出我在微信支付sdk中初始化证书时的操作:

private WXPayConfigImpl() throws Exception {
            String certPath = WXPayConstants.APICLIENT_CERT;
            // File file = new File( certPath );
            ClassPathResource resource = new ClassPathResource( certPath );
            // File file = ResourceUtils.getFile( certPath );
            // InputStream certStream = new FileInputStream( file );
            InputStream certStream = resource.getInputStream();
            byte[] buffer = new byte[1024];
            int len = 0;
            ByteArrayOutputStream bos = new ByteArrayOutputStream();
            while( ( len = certStream.read( buffer ) ) != -1 ) {
                bos.write( buffer, 0, len );
            }
            bos.flush();
            // this.certData = new byte[(int) file.length()];
            // certStream.read( this.certData );
            this.certData = bos.toByteArray();
            certStream.close();
        }

希望对大家有用^\_^

[sdk]: https://download.csdn.net/download/weixin_41103806/11016798
[springboot_resource]: https://www.jianshu.com/p/7d7e5e4e8ae3