Vue相关:
1,
将文件拖到此处,或 点击上传 是否更新已经存在的用户数据 下载模板 提示:仅允许导入“xls”或“xlsx”格式文件!确 定 取 消
2,
return {
//导入相关的值–start
// upload_ownerId: null,
upload_url: null,
upload: {
orderType: null,
// 是否显示弹出层(用户导入)
open: false,
// 弹出层标题(用户导入)
title: ‘’,
// 是否禁用上传
isUploading: false,
// 是否更新已经存在的用户数据
updateSupport: 0,
// 设置上传的请求头部
headers: {
Authorization: 'Bearer ’ + getToken()
},
// 上传的地址
url: process.env.VUE_APP_BASE_API + ‘/aaa/bbb/ccc/’
},
//—end
3,
// 导入操作
handleImport() {
this.upload.title = this.td(‘订单导入’)
this.upload.open = true
},
// 下载模板操作
importTemplate() {
window.open(‘/excel_model/xxx导入模板.xlsx’, ‘_blank’)}, // 文件上传中处理 handleFileUploadProgress(event, file, fileList) { this.upload.isUploading = true }, // 文件上传成功处理 handleFileSuccess(response, file, fileList) { this.upload.open = false this.upload.isUploading = false this.$refs.upload.clearFiles() this.$alert(response.msg, this.td('导入结果'), { dangerouslyUseHTMLString: true }) this.getList() }, // 提交上传文件 submitFileForm() { this.$refs.upload.submit() }
重点在后端:
1,这一步主要是把excel内容转化成java实体类对应的内容,关键在OrderImport
@PostMapping(“/xxx/{orderType}”) public AjaxResult
importTmsOrder(MultipartFile file,@PathVariable String orderType,
boolean updateSupport) throws Exception {System.err.println(orderType); ExcelUtilutil = new ExcelUtil (OrderImport.class); List orderImportList = util.importExcel(file.getInputStream());
2,实体类样式
@Data public class OrderImport implements Serializable {
private static final long serialVersionUID = 1L;@Excel(name = "名字")//这个name值和excel导入的字段名要一致 private String xxxx;
3,
@Transactional
@Override public String importTmsOrder(ListorderImportList, String orderType, boolean updateSupport) { if (StringUtils.isNull(orderImportList) || orderImportList.size() == 0) { throw new ServiceException("导入数据不能为空!"); } int successNum = 0; int failureNum = 0; int failureSameNum = 0; StringBuilder successMsg = new StringBuilder(); StringBuilder failureMsg = new StringBuilder(); StringBuilder failureSameMsg = new StringBuilder(); //先分类--1 Set setList = new HashSet<>(); for (OrderImport orderImport : orderImportList) { String expressNumber = orderImport.getExpressNumber(); if (expressNumber != null && !"".equals(expressNumber)) { setList.add(expressNumber); } } //归类--2 Map > map = new HashMap<>(); for (String expressNumberSet : setList) { List orderImports = new ArrayList (); for (OrderImport orderImport : orderImportList) { String expressNumber = orderImport.getExpressNumber(); if (expressNumber != null && !"".equals(expressNumber) && expressNumberSet.equals(expressNumber)) { orderImports.add(orderImport); } } map.put(expressNumberSet, orderImports); } //可以进行分类处理了--3 for (Map.Entry > entry : map.entrySet()) { String expressNumber = entry.getKey(); List value = entry.getValue(); TmsOrder tmsOrder = new TmsOrder();//抽取第一条作为主表数据 tmsOrder.setAddressee(value.get(0).getContactMsg());//收件人 tmsOrder.setAreaId(value.get(0).getDistrict());//街道/分区/小区 tmsOrder.setOrderType(orderType);//可以动态填写 tmsOrder.setDataSource(1l); TmsOrder countExpressIdm = tmsOrderMapper.getCountExpressIdm(expressNumber); int i=0; if (countExpressIdm!=null){ tmsOrder.setOrderId(countExpressIdm.getOrderId()); i=tmsOrderMapper.updateTmsOrder(tmsOrder); tmsOrderMapper.deleteTmsOrderPackByOrderId(countExpressIdm.getOrderId()); }else { i=tmsOrderMapper.insertTmsOrder(tmsOrder); } if (i>0){ for (int j=0;j " + successNum + "、Express_number: " + value.get(j).getExpressNumber() + " 导入成功"); }catch (Exception e) { failureNum++; String msg = "
" + failureNum + "、Express_number: " + value.get(j).getExpressNumber() + " 导入失败:"; failureMsg.append(msg + e.getMessage()); log.error(msg, e); } } } } if (failureNum > 0) { failureMsg.insert(0, "很抱歉,导入失败!共 " + failureNum + " 条数据不正确,错误如下:"); throw new ServiceException(failureMsg.toString()); } else if (failureSameNum > 0) { failureSameMsg.insert(0, "恭喜您,数据导入成功,共" + successNum + " 条"); return failureSameMsg.toString(); } else { successMsg.insert(0, "恭喜您,数据已全部导入成功!共 " + successNum + " 条"); return successMsg.toString(); } }
`



