From 0895d03eb396a21d7f729820a82c881f28612349 Mon Sep 17 00:00:00 2001
From: zhouwenxuan <1175765986@qq.com>
Date: 星期五, 19 一月 2024 17:19:34 +0800
Subject: [PATCH] 导出
---
src/main.js | 4 ++
src/views/safetyReview/userManage/expertUsers/components/projectDialog.vue | 8 +++
src/views/safetyReview/projectManage/index.vue | 64 +++++++++++++++++++++++++++----
3 files changed, 66 insertions(+), 10 deletions(-)
diff --git a/src/main.js b/src/main.js
index c765f8f..d1504ce 100644
--- a/src/main.js
+++ b/src/main.js
@@ -45,6 +45,9 @@
import preReClick from "@/utils/preReClick";
+import vue3JsonExcel from 'vue3-json-excel';
+
+
import { Boot } from '@wangeditor/editor'
import attachmentModule from '@wangeditor/plugin-upload-attachment'
import loadMore from '@/utils/selectLoadMoreDirective'
@@ -71,6 +74,7 @@
app.component('RightToolbar', RightToolbar)
app.component('Editor', Editor)
+app.use(vue3JsonExcel)
app.use(router)
app.use(store)
app.use(plugins)
diff --git a/src/views/safetyReview/projectManage/index.vue b/src/views/safetyReview/projectManage/index.vue
index e59c9bd..f5abb09 100644
--- a/src/views/safetyReview/projectManage/index.vue
+++ b/src/views/safetyReview/projectManage/index.vue
@@ -2,17 +2,24 @@
<div class="project-container">
<div class="header">
<el-button type="success" icon="Plus" @click="toProcess('add',{})">新增</el-button>
- <el-button type="warning" >导出</el-button>
+ <vue3-json-excel
+ :json-data="dataList"
+ :fields="fields"
+ name="项目信息表.xlsx"
+ style="margin-right: 5px;margin-left: 5px"
+ >
+ <el-button type="warning">导出</el-button>
+ </vue3-json-excel>
<el-button type="primary" icon="Filter" @click="showDrawer = true">筛选</el-button>
</div>
<div class="middle">
<div class="card-box">
<div class="box-left" @click="choose('')">
- <class class="font-left">
+ <div class="font-left">
<div>项目</div>
<div>总数</div>
- </class>
- <class class="font-right">{{search.num.projectTotal}}</class>
+ </div>
+ <div class="font-right">{{search.num.projectTotal}}</div>
</div>
<div class="box-right">
<div class="inbox" @click="choose(1)" style="box-shadow: rgba(132, 122, 253, 0.2) 0 3px 5px 0;" :class="{btn1: chooseType === 1}">
@@ -65,7 +72,7 @@
<el-table-column label="委托单位" prop="client" align="center" :show-overflow-tooltip="true" width="180"/>
<el-table-column label="所属地市" align="center" width="250">
<template #default="scope">
- {{scope.row.province}}/{{scope.row.city}}
+ {{scope.row.area}}
</template>
</el-table-column>
<el-table-column label="评价类型" prop="estimateTypeName" align="center" width="150"/>
@@ -94,7 +101,13 @@
<el-table-column label="项目变更" prop="" align="center" width="120"/>
<el-table-column label="预估金额（万元）" prop="" align="center" width="130"/>
<el-table-column label="归档金额（万元）" prop="" align="center" width="130"/>
- <el-table-column label="缺失要件" prop="" align="center" width="150"/>
+ <el-table-column label="缺失要件" align="center" width="150">
+ <template #default="scope">
+ <div style="cursor:pointer;color: #3b82f6;" >
+ <span>{{scope.row.materialCnt}}</span>
+ </div>
+ </template>
+ </el-table-column>
<el-table-column label="归档确认" prop="" align="center" width="150"/>
<el-table-column fixed="right" label="操作" align="center" class-name="small-padding fixed-width" width="180">
<template #default="scope">
@@ -190,6 +203,7 @@
</div>
</template>
</el-drawer>
+
</div>
</template>
@@ -198,7 +212,6 @@
import {onMounted, reactive, ref} from "vue";
import {delProject, getProjectList, getProjectStatistics} from "@/api/projectManage/project";
import {ElMessage, ElMessageBox} from "element-plus";
-import {delMonitor} from "@/api/sysUsers";
import {getRegionTree} from "@/api/area";
import {getDict} from "@/api/login";
import {getDictList} from "@/api/backManage/evaluate";
@@ -284,8 +297,9 @@
dataList.value = res.data.list.map(item => {
return {
...item,
- process: item.reportProgress <=4 ? 1 : item.reportProgress >4 && item.reportProgress <=6 ? 2 : item.reportProgress >6 && item.reportProgress <=9 ? 3 :item.reportProgress >9 && item.reportProgress <=11 ? 4:5,
- leaderName: item.leader ? item.leader.name : ''
+ process: item.reportProgress <= 4 ? 1 : item.reportProgress > 4 && item.reportProgress <= 6 ? 2 : item.reportProgress > 6 && item.reportProgress <= 9 ? 3 : item.reportProgress > 9 && item.reportProgress <= 11 ? 4 : 5,
+ leaderName: item.leader ? item.leader.name : '',
+ area: item.district ? item.province + '/' + item.city + '/' + item.district : item.city?item.province + '/' + item.city:item.province ,
}
})
console.log('data',dataList.value)
@@ -412,6 +426,38 @@
search.queryParams.district = value[2]?value[2]:''
// }
}
+// 导出表格
+const fields = ref({
+ '项目名称':'name',
+ '委托单位':'client',
+ '所属地市': 'area',
+ '评价类型': 'estimateTypeName',
+ '业务范围': 'businessName',
+ '项目负责人': 'leaderName',
+ '项目阶段': {
+ field: 'process',
+ callback: (value) => {
+ if (value === 1) {
+ return '风险分析及计划评价'
+ } else if(value === 2){
+ return '现场勘验'
+ }else if(value === 3){
+ return '项目审核'
+ }else if(value === 4){
+ return '出具报告'
+ }else if(value === 5){
+ return '项目归档'
+ }
+ }
+ },
+ '项目实施天数': '',
+ '项目变更': '',
+ '预估金额（万元）': '',
+ '归档金额（万元）': '',
+ '缺失要件': 'materialCnt',
+ '归档确认': ''
+});
+
</script>
<style scoped lang="scss">
diff --git a/src/views/safetyReview/userManage/expertUsers/components/projectDialog.vue b/src/views/safetyReview/userManage/expertUsers/components/projectDialog.vue
index d604783..1bff3f6 100644
--- a/src/views/safetyReview/userManage/expertUsers/components/projectDialog.vue
+++ b/src/views/safetyReview/userManage/expertUsers/components/projectDialog.vue
@@ -42,7 +42,13 @@
<el-table-column label="项目变更" prop="" align="center" width="120"/>
<el-table-column label="预估金额（万元）" prop="" align="center" width="130"/>
<el-table-column label="归档金额（万元）" prop="" align="center" width="130"/>
- <el-table-column label="缺失要件" prop="" align="center" width="150"/>
+ <el-table-column label="缺失要件" prop="" align="center" width="150">
+ <template #default="scope">
+ <div style="cursor:pointer;color: #3b82f6;" >
+ <span>{{scope.row.materialCnt}}</span>
+ </div>
+ </template>
+ </el-table-column>
<el-table-column label="归档确认" prop="" align="center" width="150"/>
<el-table-column label="操作" fixed="right" align="center" class-name="small-padding fixed-width" width="180">
<template #default="scope">
--
Gitblit v1.9.2