cellList.add(PltmRefundStatus.getStatus(refund.getPltmRefundStatus()).getName());//平台退款状态
@RequestMapping("exportRefund")
public void exportRefund(HttpServletRequest request, HttpServletResponse response) {
if(!VerificationCode.checkPrivacy(request)){
try {
response.setContentType("text/html;charset=UTF-8");
response.getWriter().write("未通过隐私校验,请联系管理员");
} catch (IOException e) {
e.printStackTrace();
}
return;
}
List<PropertyFilter> filters = buildFilterProperties(request);
List<OmsShopRefund> shopRefund = scRefundService.findFiltersX(filters, OmsShopRefund.class);
String headers[][] = {
{"店铺名称",null},{"退款单号",null},{"来源退款单号",null},
{"申请时间","DATETIME"},{"退货时间","DATETIME"},{"签收时间","DATETIME"},{"签收人",null},{"退款原因",null},{"退款说明",null},{"商品名称",null},
{"配货单号",null},{"配货单快递",null},{"配货单快递号",null},{"配货单收货人",null},
{"配货单收货地址",null},{"订单是否处理",null},{"配货单是否处理",null},{"店铺退款是否处理",null},{"退单类型",null}
};
ArrayList<ArrayList<?>> data = new ArrayList<ArrayList<?>>();
try {
for (int i=0;i<shopRefund.size();i++) {
OmsShopRefund refund = shopRefund.get(i);
Long minCount = 0L;
ArrayList<Object> cellList = new ArrayList<Object>();
cellList.add(refund.getShopname());//店铺名称
cellList.add(refund.getRefundno());//退款单号
cellList.add(refund.getSourceno());//来源退款单号
cellList.add(refund.getSourceOrderno());//来源订单号
cellList.add(refund.getSourceItemno());//来源子单号
cellList.add(refund.getBuyerNick());//买家昵称
cellList.add(refund.getTotalFee());//订单总额
cellList.add(PltmRefundStatus.getStatus(refund.getPltmRefundStatus()).getName());//平台退款状态
cellList.add(refund.getType());
cellList.add(minCount);
data.add(cellList);
}
OmsModuleOperatingLog log = RequestUtil.getOmsModuleOperatingLog(request.getRemoteAddr(),"发货单管理-导出发货单",data.size());
scRefundService.save(log);
XLSXExportUtil exportUtil = new XLSXExportUtil("退款退货单", headers, "退款退货单");
OutputStream os = response.getOutputStream();
String filename = new String("退款退货单.xlsx".getBytes("gbk"), "iso8859-1");
response.setHeader("Content-disposition","attachment; filename="+filename);
response.setContentType("application/vnd.ms-excel;charset=utf-8");
exportUtil.PoiWriteExcel_To2007(data, os);
} catch (Exception e) {
e.printStackTrace();
}
}