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
<template>
<div style="height: 70vh; overflow: auto;">
<a-table :dataSource="tableData" :columns="columns" :rowKey="(r, i) => i" :pagination="false" :loading="loading" bordered>
<template slot="evaluationInfo" slot-scope="record">
<a-tag v-if="!!record.auditState && record.auditState == 2" :color="'green'">{{record.totalScore}}</a-tag>
<a-tag v-else :color="'red'">未评审</a-tag>
</template>
</a-table>
</div>
</template>
<script>
import { getType } from '@/views/utils/auth'
import { mergeRow } from '@/views/utils/common'
export default {
name: "evaluationStatistic",
data() {
return {
loading: false,
columns: [
{ title: '项目编号', dataIndex: 'projNo', align: 'center', customRender: (text, row) => { return { children: `${text}`, attrs: { rowSpan: row.projNoRowSpan } } } },
{ title: '项目名称', dataIndex: 'projName', align: 'center', customRender: (text, row) => { return { children: row.projName, attrs: { rowSpan: row.projNoRowSpan } } } },
{ title: '证件号', dataIndex: 'certId', align: 'center' },
{ title: '专家姓名', dataIndex: 'personName', align: 'center' },
{ title: '手机号', dataIndex: 'mobile', align: 'center' },
{ title: '评分', scopedSlots: { customRender: 'evaluationInfo' }, align: 'center' },
{ title: '评审内容', dataIndex: 'remark', align: 'center', ellipsis: true },
{ title: '平均分', dataIndex: 'averageScore', align: 'center', customRender: (text, row) => { return { children: row.averageScore, attrs: { rowSpan: row.projNoRowSpan } } } },
],
tableData: [],
mergeList: [],
reportYear: null,
};
},
created() {
this.getYear()
},
methods: {
getYear () {
this.$api.batch.getCurrentYearBatch({ type: 1, projType: getType() }).then(({ data = {} }) => {
if (data) {
this.reportYear = data.year
this.getEvaluationStatistic()
}
}).catch(() => { })
},
getEvaluationStatistic () {
this.loading = true
const rowMarks = [ 'A', 'B', 'H' ]
this.$api.statistical.getEvaluationExportExcel({ reportYear: this.reportYear, startRow: 3, rowMarks: rowMarks }).then(({ data = {} }) => {
if (data) {
this.tableData = data.evaluationList
this.mergeList = data.mergeList
this.loading = false
}
}).catch(() => { this.loading = false })
},
exportData() {
import('@/views/utils/Export2Excel').then(excel => {
const multiHeader = [[ this.reportYear + '项目评审结果列表', '','']] // 标题
const header = ['项目编号', '项目名称', '证件号', '专家姓名', '手机号', '评分', '评审内容', '平均分'] // 表头
const filterVal = ['projNo', 'projName', 'certId', 'personName', 'mobile', 'totalScore', 'remark', 'averageScore'] // 数据属性
const list = this.tableData //请求来的数据
const merges = ['A1:H1'].concat(this.mergeList) //需要合并的单元格
const data = list.map(item => filterVal.map(j => item[j])) // 转换二维数组
const filename = '项目评审结果列表'
excel.exportJsonToExcel({
multiHeader, // 标题--非必要
header, // 表头
data, // 具体数据--二维数组
merges, // 合并--非必要
filename, // 下载文件名
autoWidth: true, // 不自动调整列宽
})
})
}
},
watch: {
tableData: {
handler (value) {
mergeRow('projNo', this.tableData) // 合并projNo
}
}
}
};
</script>