1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
|
public void queryAssetExportXls(Map<String, Object> paramMap, HttpServletResponse response) throws Exception {
//在内存中创建一个Excel文件（工作簿）
HSSFWorkbook excel = new HSSFWorkbook();
//创建一个工作表对象
Sheet sheet = excel.createSheet("Sheet1");
String codeType = (String) paramMap.get("codeType");
List<SmpMode> list = smpModeService.queryTbleModeByCodeType(codeType);
List<String> nameGbList = list.stream().filter(sm -> !"id".equals(sm.getNameGb())).map(smpMode -> smpMode.getNameGb()).collect(Collectors.toList());
List<String> nameCnList = list.stream().filter(sm -> !"唯一标识".equals(sm.getNameCn())).map(smpMode -> smpMode.getNameCn()).collect(Collectors.toList());
//查询字典值
List<SmpMode> smpModeList = list.stream().filter(smp -> smp.getEnumCodeType() != null).collect(Collectors.toList());
// List<String> stringList = smpModeList.stream().map(smpMode -> smpMode.getNameCn()).collect(Collectors.toList());
//存储字点值
Map<String, List<Map>> map1 = new HashMap<>();
Map<String, List<SysDictItem>> map2 = new HashMap<>();
for (SmpMode smpMode : smpModeList) {
if (smpMode.getEnumCodeType().contains("sys_") || smpMode.getEnumCodeType().contains("asset_m_")) {
List<Map> mapList = smpAssetsServingMapper.getTableData(smpMode.getEnumCodeType());
map1.put(smpMode.getEnumCodeType(), mapList);
} else {
List<SysDictItem> sysDictItems = sysDictItemService.selectByDictCode(smpMode.getEnumCodeType());
map2.put(smpMode.getEnumCodeType(), sysDictItems);
}
}
//查询codeType 表内数据
List<Map> maps = smpAssetsServingMapper.queryAssetExportXls(codeType, nameGbList);
List<Map> mapList = new ArrayList<>();
for (Map map : maps) {
for (Object key : map.keySet()) {
for (SmpMode smpMode : smpModeList) {
if (smpMode.getNameGb().equals(key)) {
if (smpMode.getEnumCodeType().contains("asset_m_")) {
List<Map> mapList1 = map1.get(smpMode.getEnumCodeType());
for (Map map3 : mapList1) {
for (Object key1 : map3.keySet()) {
if (map.get(key) != null && map.get(key).equals(String.valueOf((Long) map3.get("id")))) {
map.put(key, (String) map3.get("z_ciname"));
}
}
}
} else if (smpMode.getEnumCodeType().contains("sys_role")) {
List<Map> mapList1 = map1.get(smpMode.getEnumCodeType());
for (Map map3 : mapList1) {
for (Object key1 : map3.keySet()) {
if (map.get(key) != null && map.get(key).equals(String.valueOf((Long) map3.get("id")))) {
map.put(key, (String) map3.get("role_name"));
}
}
}
} else if (smpMode.getEnumCodeType().contains("sys_depart")) {
List<Map> mapList1 = map1.get(smpMode.getEnumCodeType());
for (Map map3 : mapList1) {
for (Object key1 : map3.keySet()) {
if (map.get(key) != null && map.get(key).equals(String.valueOf((Long) map3.get("id")))) {
map.put(key, (String) map3.get("depart_name"));
}
}
}
} else if (smpMode.getEnumCodeType().contains("sys_user")) {
List<Map> mapList1 = map1.get(smpMode.getEnumCodeType());
for (Map map3 : mapList1) {
for (Object key1 : map3.keySet()) {
if (map.get(key) != null && map.get(key).equals(String.valueOf((Long) map3.get("id")))) {
map.put(key, (String) map3.get("username"));
}
}
}
} else {
List<SysDictItem> sysDictItems = map2.get(smpMode.getEnumCodeType());
for (SysDictItem sysDictItem : sysDictItems) {
if (map.get(key) != null && map.get(key).equals(String.valueOf(sysDictItem.getItemValue()))) {
map.put(key, (String) sysDictItem.getItemText());
}
}
}
}
}
}
mapList.add(map);
}
//在工作表中创建行对象
Row title = sheet.createRow(0);
//在行中创建单元格对象
for (int i = 0; i < nameCnList.size(); i++) {
title.createCell(i).setCellValue(nameCnList.get(i));
}
for (int i = 0; i < mapList.size(); i++) {
Row dataRow = sheet.createRow(i + 1);
Map map = maps.get(i);
for (int j = 0; j < nameGbList.size(); j++) {
dataRow.createCell(j).setCellValue((String) map.get(nameGbList.get(j)));
}
}
//输出Excel文件
OutputStream output = response.getOutputStream();
long filename = System.currentTimeMillis();
SimpleDateFormat df = new SimpleDateFormat("yyyyMMddHHmmss");//设置日期格式
String fileName = df.format(new Date());// new Date()为获取当前系统时间
response.setContentType("application/force-download");// 设置强制下载不打开
response.addHeader("Content-Disposition", "attachment;fileName=" + new String((fileName + ".xls").getBytes("UTF-8"), "iso-8859-1"));
output.write(excel.getBytes());
response.flushBuffer();
}
|