private List<OrderInfo> initOs() {
Integer pageNo = 1;
Integer pageSize = 15;
CurrentPage<OrderInfo> currentPage =
dfShService.queryDataForReq(
pageNo, pageSize, uid, batchNo, ptype, tseq, mstate, bdate, edate);
return currentPage.getPageItems();
}
// 当天交易下载
public FileTransfer downloadToday(
String mid,
Integer gate,
Integer tstat,
Integer type,
String tseq,
String oid,
Integer gateRouteId,
String bkseq,
Integer mstate,
String begintrantAmt,
String endtrantAmt,
String p15)
throws Exception {
CurrentPage<OrderInfo> tlogListPage =
queryMerTodayDao.queryMerToday(
1,
-1,
mid,
gate,
tstat,
type,
tseq,
oid,
gateRouteId,
bkseq,
mstate,
begintrantAmt,
endtrantAmt,
p15);
List<OrderInfo> tlogList = tlogListPage.getPageItems();
ArrayList<String[]> list = new ArrayList<String[]>();
Map<Integer, String> gates = RYFMapUtil.getGateMap();
Map<Integer, String> gateRouteMap = RYFMapUtil.getGateRouteMap();
long totleAmount = 0;
long totleFeeAmt = 0;
long totleBankFee = 0;
list.add(
"序号,电银流水号,商户号,商户订单号,商户日期,交易金额(元),交易状态,交易类型,交易银行,支付渠道,系统手续费(元),银行手续费(元),系统时间,银行流水号,失败原因,接入方式"
.split(","));
int i = 0;
for (OrderInfo h : tlogList) {
String gateRoute = "";
if (h.getGid() != null && !String.valueOf(h.getGid()).equals("")) {
gateRoute = gateRouteMap.get(h.getGid());
}
String[] str = {
(i + 1) + "",
h.getTseq() + "",
h.getMid() + "",
h.getOid(),
h.getMdate() + "",
Ryt.div100(h.getAmount()),
AppParam.tlog_tstat.get(Integer.parseInt(h.getTstat() + "")),
AppParam.tlog_type.get(Integer.parseInt(h.getType() + "")),
gates.get(h.getGate()),
gateRoute,
Ryt.div100(h.getFeeAmt()),
Ryt.div100(h.getBankFee()),
h.getSysDate() + " " + DateUtil.getStringTime(h.getSysTime()),
h.getBk_seq1(),
h.getError_msg(),
h.getP15()
};
totleAmount += h.getAmount();
totleFeeAmt += h.getFeeAmt();
totleBankFee += h.getBankFee();
i += 1;
list.add(str);
}
String[] str = {
"总计:" + i + "条记录",
"",
"",
"",
"",
Ryt.div100(totleAmount) + "",
"",
"",
"",
"",
Ryt.div100(totleFeeAmt) + "",
Ryt.div100(totleBankFee) + "",
"",
"",
""
};
list.add(str);
String filename = "MERTLOG_" + DateUtil.today() + ".xlsx";
String name = "当天交易表";
return new DownloadFile().downloadXLSXFileBase(list, filename, name);
}