/**
* 导入前： 1.读取excel文件表头 2.保存导入记录（文件）到数据库
*
* @param request
* @return
*/
@RequestMapping(params = "method=uploadExcel")
public void getExcelHeader(HttpServletRequest request, HttpServletResponse response) {
IImportService importService = ServiceManager.getService(IImportService.class);
IPrivilegeService privilegeService = ServiceManager.getService(IPrivilegeService.class);
Map result = new HashMap();
try {
MultipartHttpServletRequest multipartRequest = (MultipartHttpServletRequest) request;
MultipartFile multipartFile = multipartRequest.getFile("selectfile");
String fileName = multipartFile.getOriginalFilename();
if (!validateOrderType(fileName)) { // todo 不起作用
response.setHeader("Charset", "UTF-8");
response.setContentType("text/html;charset=UTF-8");
PrintWriter writer = response.getWriter();
result.put("orderImportMsg", "上传文件名无法识别，请使用标准模板名！");
String resultStr = JsonUtil.mapToJson(result);
writer.write(resultStr);
writer.flush();
writer.close();
return;
}
InputStream inputStream = multipartFile.getInputStream();
if (inputStream.available() > ImportConstants.UPLOAD_FILE_MAX_SIZE) {
PrintWriter writer = response.getWriter();
writer.write(
"上传文件大小不能超过" + NumberUtil.byteToMillion(ImportConstants.UPLOAD_FILE_MAX_SIZE) + "M！");
writer.flush();
writer.close();
return;
}
byte[] fileContent = IOUtil.readFromStream(inputStream);
// 先读取表头
ImportContext importContext = new ImportContext();
importContext.setFileContent(fileContent);
importContext.setFileName(fileName);
List<String> headList = importService.parseHead(importContext);
if (headList == null || headList.isEmpty()) {
result.put("message", "解析导入文件头部失败！");
} else {
result.put("headList", headList);
}
// 再存入数据库
ImportRecordDTO importRecordDTO = new ImportRecordDTO();
importRecordDTO.setShopId(WebUtil.getShopId(request));
importRecordDTO.setStatus(ImportConstants.Status.STATUS_WAITING);
importRecordDTO.setType(ImportConstants.Type.TYPE_ORDER);
importRecordDTO.setFileName(fileName);
importRecordDTO.setFileContent(fileContent);
importRecordDTO = importService.createImportRecord(importRecordDTO);
if (importRecordDTO == null || importRecordDTO.getId() == null) {
result.put("message", "保存导入记录出错！");
} else {
result.put("importRecordId", String.valueOf(importRecordDTO.getId()));
}
result.put(
"systemFieldList",
getOrderFieldList(
PrivilegeRequestProxy.verifierShopVersionResourceProxy(
request, LogicResource.WEB_VERSION_WHOLESALERS)));
String resultStr = JsonUtil.mapToJson(result);
response.setHeader("Charset", "UTF-8");
response.setContentType("text/html;charset=UTF-8");
PrintWriter writer = response.getWriter();
writer.write(resultStr);
writer.flush();
writer.close();
} catch (Exception e) {
LOG.error("上传文件出现异常！");
LOG.error(e.getMessage(), e);
}
}
