后端:代码;
/**
* 导出excel
*
* @param request
* @param prProject
*/
@RequestMapping(value = "/exportXls")
//@RequiresPermissions("prProject:exportXls")
public void exportXls(HttpServletRequest request,HttpServletResponse response, PrProject prProject) {
log.debug("开始导出_______________________" + System.currentTimeMillis());
IPage<Map<String, Object>> datasPage = iPrCommonService.getSheetData(prProject.getName(), prProject.getProjectType(), 1, 10);
List<Map<String, Object>> newData = new ArrayList<>();
String temProjectId = "";
for (Map<String, Object> data : datasPage.getRecords()) {
if (data.get("project_id").equals(temProjectId)) {
String subListString = (String) newData.get(newData.size() - 1).get("subList");
List<Map> subList = JSONArray.parseArray(subListString, Map.class);
subList.add(data);
newData.get(newData.size() - 1).put("subList", JSON.toJSONString(subList));
} else {
temProjectId = data.get("project_id").toString();
List<Map<String, Object>> subList = new ArrayList<>();
subList.add(data);
data.put("subList", JSON.toJSONString(subList));
newData.add(data);
}
// }
}
IPage ipage = new Page();
ipage.setSize(datasPage.getSize());
ipage.setRecords(newData);
ipage.setPages(datasPage.getPages());
ipage.setTotal(datasPage.getTotal());
ipage.setCurrent(datasPage.getCurrent());
List<Map<String, Object>> fieldData2 = ipage.getRecords();
/* for (Map msp : fieldData2) {
System.out.println("____________" + msp.toString());
}
*/
/*得到表头*/
List<PrStepField> prStepFields = new ArrayList<>();
List<PrStep> prSteps = iPrStepService.getByProjectType(prProject.getProjectType());
for (PrStep step : prSteps)