java微信对账单解析为bean

最近发现对账单的 格式变了 重新写了一下

官网地址: https://pay.weixin.qq.com/wiki/doc/api/wxa/wxa_api.php?chapter=9_6

有问题留言

import java.util.ArrayList;
import java.util.List;

/**
 * @Author: liangkesai
 * @CreateDate: 2019/05/20 11:25
 */
public class Bill {

    private String date;//交易时间
    private String appId;//公众账号ID
    private String mch_id;//商户号
    private String subMch_id;//子商户号 特约商户号
    private String device_info;//设备号
    private String weiXinOrderNo;//微信订单号
    private String mchOrderNo;//商户订单号
    private String userId;//用户标识
    private String type;//交易类型
    private String status;//交易状态
    private String bank;//付款银行
    private String currency;//货币种类
    private String amount;//总金额
    private String envelopeAmount;//企业红包金额 代金券金额
    private String name;//商品名称
    private String packet;//商户数据包
    private String poundage;//手续费
    private String rate;//费率
    private String orderAmount; //订单金额

    public String getOrderAmount() {
        return orderAmount;
    }

    public void setOrderAmount(String orderAmount) {
        this.orderAmount = orderAmount;
    }

    public String getDate() {
        return date;
    }

    public void setDate(String date) {
        this.date = date;
    }

    public String getAppId() {
        return appId;
    }

    public void setAppId(String appId) {
        this.appId = appId;
    }

    public String getMch_id() {
        return mch_id;
    }

    public void setMch_id(String mch_id) {
        this.mch_id = mch_id;
    }

    public String getSubMch_id() {
        return subMch_id;
    }

    public void setSubMch_id(String subMch_id) {
        this.subMch_id = subMch_id;
    }

    public String getDevice_info() {
        return device_info;
    }

    public void setDevice_info(String device_info) {
        this.device_info = device_info;
    }

    public String getWeiXinOrderNo() {
        return weiXinOrderNo;
    }

    public void setWeiXinOrderNo(String weiXinOrderNo) {
        this.weiXinOrderNo = weiXinOrderNo;
    }

    public String getMchOrderNo() {
        return mchOrderNo;
    }

    public void setMchOrderNo(String mchOrderNo) {
        this.mchOrderNo = mchOrderNo;
    }

    public String getUserId() {
        return userId;
    }

    public void setUserId(String userId) {
        this.userId = userId;
    }

    public String getType() {
        return type;
    }

    public void setType(String type) {
        this.type = type;
    }

    public String getStatus() {
        return status;
    }

    public void setStatus(String status) {
        this.status = status;
    }

    public String getBank() {
        return bank;
    }

    public void setBank(String bank) {
        this.bank = bank;
    }

    public String getCurrency() {
        return currency;
    }

    public void setCurrency(String currency) {
        this.currency = currency;
    }

    public String getAmount() {
        return amount;
    }

    public void setAmount(String amount) {
        this.amount = amount;
    }

    public String getEnvelopeAmount() {
        return envelopeAmount;
    }

    public void setEnvelopeAmount(String envelopeAmount) {
        this.envelopeAmount = envelopeAmount;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getPacket() {
        return packet;
    }

    public void setPacket(String packet) {
        this.packet = packet;
    }

    public String getPoundage() {
        return poundage;
    }

    public void setPoundage(String poundage) {
        this.poundage = poundage;
    }

    public String getRate() {
        return rate;
    }

    public void setRate(String rate) {
        this.rate = rate;
    }
    
    
    //date 为账单时间 格式 2018-12-25
    //result  接口返回数据
    public static List<Bill> analyze(String result ,String date){
        List<Bill> bills = new ArrayList<Bill>();
        String tradeMsg = result.substring(result.indexOf("`")); //去标题
        String tradeInfo = tradeMsg.substring(0, tradeMsg.indexOf("总")).replaceFirst(date,"").replaceAll("`","");;// 去掉汇总数据
        String[] tradeArray = tradeInfo.split(date); //通过交易时间分隔   订单数
        for(String trade : tradeArray){
            String[] order = trade.split(",");
            Bill bill = new Bill();
            bill.setDate(date+order[0]);
            bill.setAppId(order[1]);
            bill.setMch_id(order[2]);
            bill.setSubMch_id(order[3]);
            bill.setDevice_info(order[4]);
            bill.setWeiXinOrderNo(order[5]);
            bill.setMchOrderNo(order[6]);
            bill.setUserId(order[7]);
            bill.setType(order[8]);
            bill.setStatus(order[9]);
            bill.setBank(order[10]);
            bill.setCurrency(order[11]);
            bill.setAmount(order[12]);
            bill.setEnvelopeAmount(order[13]);
            bill.setName(order[14]);
            bill.setPacket(order[15]);
            bill.setPoundage(order[16]);
            bill.setRate(order[17]);
            bill.setOrderAmount(order[18]);
            bills.add(bill);
        }
        return bills;
    }

    public static void main(String[] args) {
        String result = "交易时间,公众账号ID,商户号,特约商户号,设备号,微信订单号,商户订单号,用户标识,交易类型,交易状态,付款银行,货币种类,应结订单金额,代金券金额,商品名称,商户数据包,手续费,费率,订单金额,费率备注" +
                "`2018-12-25 11:24:26,`wx5c60835f5f7a3f8a,`1270239901,`0,`,`4200000225201812255017455831,`D20181225101152818265,`oXlfr0LZH7Yuic1RseBqRHYQFryE,`JSAPI,`SUCCESS,`CFT,`CNY,`0.01,`0.00," +
                "`会员开通,`,`0.00000,`0.60%,`0.01,``2018-12-25 11:08:51,`wx5c60835f5f7a3f8a,`1270239901,`0,`,`4200000233201812252592864627,`D20181225101063139810,`oXlfr0LZH7Yuic1RseBqRHYQFryE,`" +
                "JSAPI,`SUCCESS,`CFT,`CNY,`0.01,`0.00,`会员开通,`,`0.00000,`0.60%,`0.01,`总交易单数,应结订单总金额,退款总金额,充值券退款总金额,手续费总金额,订单总金额,申请退款总金额`2,`0.02,`0.00,`0.00,`0.00000,`0.02,`0.00";
        List<Bill> bills = Bill.analyze(result,"2018-12-25");

    }
}