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
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
export function makeData(data){
var dataRowsMap=new Map();
var dataRows=new Array();
data.title.forEach(element => {
dataRowsMap.set(element.baseId, element)
});
//遍历map，生成dataRows数组
dataRowsMap.forEach(element=>{
//console.log(element.enName);
dataRows.push({
name:element.enName[0].toLowerCase()+element.enName.substring(1),
showName:element.alias,
fixed: false,
width: element.width,
color:element.backColor,
isVisible:element.isVisible
})
})
//遍历reaData，生成dataList数组
//data.realData.forEach(element=>{
// var tmp={
// rowIndex:element.rowIndex,
// supplyName:element.supplyName,
// name:element.name,
// gatherTime:element.gatherTime
// }
// //以baseId为属性名
// element.dataList.forEach(value =>{
// var tmpvalue;
// try{
// tmpvalue=Number(value.value).toFixed(dataRowsMap.get(value.key)['decimalPoint'])
// //
// }catch{
// tmpvalue=value.value
// }
// tmp[value.key+'']=tmpvalue
// })
// tableData.push(tmp);
//})
return {dataRows:dataRows,tableData:data.realData}
}
//trans
export function makeTitle(data){
//toLowerCase()将字符串中的所有大写字符转换为小写
//将field首字母转变为小写
var dataRows=new Array();
data.frozenList.forEach((element)=>{
//生成固定表头
dataRows.push({
//id:element.id,
name:element.field[0].toLowerCase()+element.field.substring(1),
showName:element.title,
fixed: true,
width: element.width,
haveSort:element.sortable,
haveFilter:element.filter,
filterType:2,
filterValue:'',
filterText:[{text:'',value:''}],
color:'B5E6FF',
isVisible:element.isVisible
})
})
//生成非固定表头
data.otherList.forEach((element)=>{
dataRows.push({
name:element.enName[0].toLowerCase()+element.enName.substring(1),
showName:element.alias,
fixed: false,
width: element.width,
haveSort:true,
haveFilter:true,
filterType:1,
filterValue:'',
filterText:[{text:'',value:''}],
color:element.backColor,
decimalPoint:element.decimalPoint,
isVisible:element.isVisible
})
})
return dataRows;
}
export function makeTransData(data){
let tableData=data.realData;
return tableData;
}
export function getFileName(name){
const now = new Date();
const year = now.getFullYear();
const month = (now.getMonth() + 1).toString().padStart(2, '0');
const day = now.getDate().toString().padStart(2, '0');
const hours = now.getHours().toString().padStart(2, '0');
const minutes = now.getMinutes().toString().padStart(2, '0');
const seconds = now.getSeconds().toString().padStart(2, '0');
return name+`_${year}${month}${day}${hours}${minutes}${seconds}.xls`;
}
export function getAllImgUrl(id){
if(id === 'af3616fd-ac99-4de4-8b92-7e2eab9a5a90' || id === '0d4ad9f6-75ee-4914-929a-bedfe13b2560'){
return '/imgs/artPage/AllBoilerArt_gangyi.jpg'
}
else{
return ''
}
}
export function getOneImgUrl(id){
if(id === 'af3616fd-ac99-4de4-8b92-7e2eab9a5a90' || id === '0d4ad9f6-75ee-4914-929a-bedfe13b2560'){
return '/imgs/artPage/BoilerArt_gangyi.jpg'
}
else{
return ''
}
}
// 定义时间格式化函数 yyyy-MM-dd HH:mm:ss
export function formatTime(date) {
const year = date.getFullYear();
const month = (date.getMonth() + 1).toString().padStart(2, '0');
const day = date.getDate().toString().padStart(2, '0');
const hours = date.getHours().toString().padStart(2, '0');
const minutes = date.getMinutes().toString().padStart(2, '0');
const seconds = date.getSeconds().toString().padStart(2, '0');
return `${year}-${month}-${day} ${hours}:${minutes}:${seconds}`;
}
// 定义时间格式化函数 yyyy-MM-dd HH
export function formatDateHour(date) {
const year = date.getFullYear();
const month = (date.getMonth() + 1).toString().padStart(2, '0');
const day = date.getDate().toString().padStart(2, '0');
const hours = date.getHours().toString().padStart(2, '0');
return `${year}-${month}-${day} ${hours}`;
}
// 定义时间格式化函数 yyyy-MM-dd
export function formatDate(date) {
const year = date.getFullYear();
const month = (date.getMonth() + 1).toString().padStart(2, '0');
const day = date.getDate().toString().padStart(2, '0');
return `${year}-${month}-${day}`;
}