2020-10-30

<div class="layui-input-inline" style="width: 220px">
                                        <button type="button" class="layui-btn layuiadmin-btn-list layui-btn-sm" id="daochu">导出</button>
                                    </div>

$('#daochu').click(function (){
            var status = $("#status option:selected").val();
            var nameId = $("#nameId option:selected").val();
            var search  = $("#search").val();
            var pubDate  = $("#pubDate").val();
            var pubDateSplit = pubDate.split(' - ');
            var startTime = pubDateSplit ? pubDateSplit[0] : null;
            var endTime =pubDateSplit ? pubDateSplit[1] : null;
            window.open(setter.domain + '/pay-jour/daochu?status='+status+'&nameId='+nameId+'&search='+search+'&startTime='+startTime+'&endTime='+endTime,'_self');
        });

IMemberPayJourService：

List<RspPayJour> getAll(ReqPayJour req);

IMemberPayJourServiceImpl：

@Override
    public List<RspPayJour> getAll(ReqPayJour req) {
        List<RspPayJour>  resultList = payJourMapper.findList(req);
        return resultList;
    }

PayJourController:

@Override
    public List<RspPayJour> getAll(ReqPayJour req) {
        List<RspPayJour>  resultList = payJourMapper.findList(req);
        return resultList;
    }

MemberPayJourMapping:
List<RspPayJour> findList( @Param( "req" ) ReqPayJour req );

 

 

RspPayJour

private String id;

@Excel(name = "订单号", orderNum = "2")
private String order_no;

@Excel(name = "支付平台名称", orderNum = "4")
private String payment_code;

@Excel(name = "请求金额", orderNum = "2")
private BigDecimal money;

@Excel(name = "实际金额", orderNum = "7")
private BigDecimal sub_money;

@Excel(name = "上游订单号", orderNum = "3")
private String trade_sn;

@Excel(name = "", orderNum = "")
private String payment_time;

@Excel(name = "商户下单时间", orderNum = "6")
private String pay_time;

@Excel(name = "订单状态", orderNum = "8")
private String status;

@Excel(name = "备注", orderNum = "9")
private String remark;

@Excel(name = "会员id", orderNum = "0")
private String member_id;

@Excel(name = "", orderNum = "")
private String user_name;

@Excel(name = "", orderNum = "")
private String platform_id;

@Excel(name = "", orderNum = "")
private String platform_name;

@Excel(name = "", orderNum = "")
private Boolean is_patch_order;

@Excel(name = "支付通道id", orderNum = "5")
private String channel_id;

@Excel(name = "", orderNum = "")
private String channel_name;

@Excel(name = "", orderNum = "")
private String update_time;