From 72cd0674ad6380807ed4767386e2d2f5b180e678 Mon Sep 17 00:00:00 2001
From: zhouwx <1175765986@qq.com>
Date: 星期四, 13 十一月 2025 17:10:10 +0800
Subject: [PATCH] 修改
---
src/views/safetyReview/projectManage/index.vue | 761 ++++++++++++++++++++++++++++++++--------------------------
1 files changed, 416 insertions(+), 345 deletions(-)
diff --git a/src/views/safetyReview/projectManage/index.vue b/src/views/safetyReview/projectManage/index.vue
index 7cc3172..9ae2c56 100644
--- a/src/views/safetyReview/projectManage/index.vue
+++ b/src/views/safetyReview/projectManage/index.vue
@@ -2,15 +2,15 @@
<div class="project-container">
<div class="header">
<el-button type="success" icon="Plus" @click="toProcess('add',{})">新增</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>
+ <!-- <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">
@@ -19,116 +19,73 @@
<div>项目</div>
<div>总数</div>
</div>
- <div class="font-right">{{search.num.projectTotal}}</div>
+ <div class="font-right">{{ search.num.total }}</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}">
+ <div class="inbox" @click="choose(1)" style="box-shadow: rgba(132, 122, 253, 0.2) 0 3px 5px 0;"
+ :class="{btn1: chooseType === 1}">
<div class="top" style="background: linear-gradient(90deg, rgb(127, 118, 253), rgb(218, 180, 246));">
- <span class="top-right-font">风险分析及计划评价</span>
+ <span class="top-right-font">基本信息</span>
</div>
<div class="bottom">
- <span class="top-right-font-bottom">{{search.num.riskTotal}}</span>
+ <span class="top-right-font-bottom">{{ search.num.staging }}</span>
</div>
</div>
- <div class="inbox" @click="choose(2)" style="box-shadow: rgba(255, 142, 139, 0.15) 0 3px 5px 0;" :class="{btn2: chooseType === 2}">
+ <div class="inbox" @click="choose(2)" style="box-shadow: rgba(255, 142, 139, 0.15) 0 3px 5px 0;"
+ :class="{btn2: chooseType === 2}">
<div class="top" style="background: linear-gradient(90deg, rgb(255, 140, 138), rgb(239, 186, 141));">
- <span class="top-right-font">现场勘验</span>
+ <span class="top-right-font">专家选用</span>
</div>
<div class="bottom">
- <span class="top-right-font-bottom">{{search.num.investigationTotal}}</span>
+ <span class="top-right-font-bottom">{{ search.num.expert }}</span>
</div>
</div>
- <div class="inbox" @click="choose(3)" style="box-shadow: rgba(222, 106, 169, 0.15) 0 3px 5px 0;" :class="{btn3: chooseType === 3}">
+ <div class="inbox" @click="choose(3)" style="box-shadow: rgba(222, 106, 169, 0.15) 0 3px 5px 0;"
+ :class="{btn3: chooseType === 3}">
<div class="top" style="background: linear-gradient(90deg, rgb(229, 119, 180), rgb(249, 159, 192));">
- <span class="top-right-font">项目审核</span>
+ <span class="top-right-font">项目审批</span>
</div>
<div class="bottom">
- <span class="top-right-font-bottom">{{search.num.reviewTotal}}</span>
+ <span class="top-right-font-bottom">{{ search.num.approval }}</span>
</div>
</div>
- <div class="inbox" @click="choose(4)" style="box-shadow: rgba(109, 177, 254, 0.2) 0 3px 5px 0;" :class="{btn4: chooseType === 4}">
+ <div class="inbox" @click="choose(4)" style="box-shadow: rgba(109, 177, 254, 0.2) 0 3px 5px 0;"
+ :class="{btn4: chooseType === 4}">
<div class="top" style="background: linear-gradient(90deg, rgb(54, 115, 255), rgb(124, 196, 242));">
- <span class="top-right-font">出具报告</span>
- </div>
- <div class="bottom">
- <span class="top-right-font-bottom">{{search.num.reportTotal}}</span>
- </div>
- </div>
- <div class="inbox" @click="choose(5)" style="box-shadow: rgba(88, 211, 137, 0.2) 0 3px 5px 0;" :class="{btn5: chooseType === 5}">
- <div class="top" style="background: linear-gradient(90deg, rgb(0, 195, 151), rgb(114, 232, 200));">
<span class="top-right-font">项目归档</span>
</div>
<div class="bottom">
- <span class="top-right-font-bottom">{{search.num.archiveTotal}}</span>
+ <span class="top-right-font-bottom">{{ search.num.end }}</span>
</div>
</div>
</div>
</div>
</div>
<!-- 表格数据 -->
- <el-table v-loading="loading" :data="dataList" :border="true" ref="tableRef" :height="tableHeight" style="width: 100%;">
- <el-table-column label="序号" width="80" align="center" type="index" ></el-table-column>
- <el-table-column label="项目名称" prop="name" align="center" :show-overflow-tooltip="true" width="180" />
- <el-table-column label="委托单位" prop="client" align="center" :show-overflow-tooltip="true" width="180"/>
- <el-table-column label="所属地市" align="center" width="250">
+ <el-table v-loading="loading" :data="dataList" :border="true" ref="tableRef" :height="tableHeight"
+ style="width: 100%;">
+ <el-table-column label="序号" width="80" align="center" type="index"></el-table-column>
+ <el-table-column label="项目编码" width="180" align="center" prop="projectCode"></el-table-column>
+ <el-table-column label="申请时间" prop="createTime" align="center" :show-overflow-tooltip="true" width="180"/>
+ <el-table-column label="出差事由" prop="projectName" align="center" :show-overflow-tooltip="true" />
+ <el-table-column label="部门" prop="deptName" align="center" width="180"/>
+ <el-table-column label="专家组组长" prop="expertName" align="center" width="120"/>
+ <el-table-column label="专家组人数" prop="expertNum" align="center" width="120"/>
+ <el-table-column label="当前状态" prop="state" align="center" width="200">
<template #default="scope">
- {{scope.row.area}}
- </template>
- </el-table-column>
- <el-table-column label="评价类型" prop="estimateTypeName" align="center" width="150"/>
- <el-table-column label="业务范围" prop="businessName" align="center" :show-overflow-tooltip="true" width="150"/>
- <el-table-column label="项目负责人" prop="leaderName" align="center" width="120" :show-overflow-tooltip="true"/>
- <el-table-column label="项目阶段" align="center" width="200">
- <template #default="scope">
- <div v-if="scope.row.process === 1" class="process1">
- <span>风险分析及计划评价</span>
- </div>
- <div v-else-if="scope.row.process === 2" class="process1 process2">
- <span>现场勘验</span>
- </div>
- <div v-else-if="scope.row.process === 3" class="process1 process3">
- <span>项目审核</span>
- </div>
- <div v-else-if="scope.row.process === 4" class="process1 process4">
- <span>出具报告</span>
- </div>
- <div v-else class="process1 process5">
- <span>项目归档</span>
- </div>
- </template>
- </el-table-column>
- <el-table-column label="项目实施天数" prop="filingDate" align="center" width="150"/>
-<!-- <el-table-column label="项目变更" prop="" align="center" width="120">-->
-<!-- <template #default="scope">-->
-<!-- <div style="cursor:pointer;color: #3b82f6;" >-->
-<!-- <span v-if="scope.row.process !== 1" @click="goMenu('toFive',scope.row)">{{}}</span>-->
-<!-- <span v-else></span>-->
-<!-- </div>-->
-<!-- </template>-->
-<!-- </el-table-column>-->
- <el-table-column label="预估金额（万元）" prop="contractMoney" align="center" width="130"/>
- <el-table-column label="归档金额（万元）" prop="actualContractMoney" align="center" width="130"/>
- <el-table-column label="缺失要件" align="center" width="150">
- <template #default="scope">
- <div style="cursor:pointer;color: #3b82f6;" >
- <span v-if="scope.row.process === 5" @click="goMenu('toTwelve',scope.row)">{{scope.row.missingMaterialCnt}}</span>
- <span v-else></span>
- </div>
- </template>
- </el-table-column>
- <el-table-column label="归档确认" prop="" align="center" width="150">
- <template #default="scope">
- <div style="cursor:pointer;color: #3b82f6;" >
- <span @click="goMenu('toThirteen',scope.row)">{{scope.row.activeConfirm}}</span>
-<!-- <span v-else></span>-->
- </div>
+ <span>{{
+ scope.row.state === 0 ? '暂存' : scope.row.state === 1 ? '选取专家' : scope.row.state === 2 ? '生成审批单' : scope.row.state === 3 ? '审批通过' : '完结'
+ }}</span>
</template>
</el-table-column>
<el-table-column fixed="right" label="操作" align="center" class-name="small-padding fixed-width" width="180">
<template #default="scope">
<el-button link type="primary" @click="toProcess('view',scope.row)">查看</el-button>
- <el-button link type="primary" @click="toProcess('edit',scope.row)">编辑</el-button>
- <el-button link type="danger" @click="del(scope.row)">删除</el-button>
+ <el-button link type="primary" v-if="scope.row.step !== 4" @click="toProcess('edit',scope.row)">编辑
+ </el-button>
+ <el-button link type="danger" v-if="scope.row.step !== 4" @click="del(scope.row)">删除</el-button>
+ <el-button link v-if="scope.row.state === 4" type="primary" @click="downloadExcel(scope.row)">导出报销表
+ </el-button>
</template>
</el-table-column>
</el-table>
@@ -144,10 +101,10 @@
@current-change="handleCurrentChange"
/>
</div>
- <el-drawer v-model="showDrawer" :direction="direction" :with-header="false" :size="size" >
+ <el-drawer v-model="showDrawer" :direction="direction" :with-header="false" :size="size">
<template #default>
- <div class="drawer">
- <el-form ref="drawerRef" class="register-form" label-position="top">
+ <div class="drawer">
+ <el-form ref="drawerRef" class="register-form" label-position="top">
<el-form-item label="时间选择">
<el-date-picker
v-model="searchTime"
@@ -159,78 +116,59 @@
value-format="YYYY-MM-DD"
/>
</el-form-item>
- <el-form-item label="所属区域">
- <el-cascader
- v-model="area"
- :options="addressList"
- :props="props"
- @change="handleChange"
- style="width: 100%"
- size="large"
- />
- </el-form-item>
- <el-form-item label="项目名称" >
- <el-input v-model="search.queryParams.name" placeholder="请输入项目名称"></el-input>
- </el-form-item>
- <el-form-item label="委托单位">
- <el-input v-model="search.queryParams.client" placeholder="委托单位"></el-input>
- </el-form-item>
- <el-form-item label="业务范围">
- <el-select v-model="search.queryParams.business" class="m-2" size="large" placeholder="请选择" style="width: 100%" >
- <el-option
- v-for="item in businessList"
- :key="item.id"
- :label="item.label"
- :value="item.id"
- />
- </el-select>
- </el-form-item>
- <el-form-item label="评价类型">
- <el-select v-model="search.queryParams.estimateType" class="m-2" size="large" placeholder="请选择" style="width: 100%" >
- <el-option
- v-for="item in estimateTypeList"
- :key="item.id"
- :label="item.label"
- :value="item.id"
- />
- </el-select>
- </el-form-item>
- <el-form-item label="缺失要件">
- <el-select v-model="search.queryParams.params.lostMaterial" class="m-2" size="large" placeholder="请选择" style="width: 100%" >
- <el-option
- v-for="item in missingList"
- :key="item.id"
- :label="item.label"
- :value="item.id"
- />
- </el-select>
- </el-form-item>
-
- </el-form>
- </div>
+ <el-form-item label="项目名称">
+ <el-input v-model.trim="search.queryParams.projectName" placeholder="请输入项目名称"></el-input>
+ </el-form-item>
+ <el-form-item label="部门名称">
+<!-- <el-input v-model.trim="search.queryParams.deptName" placeholder="请输入部门名称"></el-input>-->
+ <el-cascader
+ style="width: 100%"
+ clearable
+ v-model.trim="search.queryParams.deptIds"
+ :show-all-levels="false"
+ placeholder="请选择部门"
+ :options="deptList"
+ :props="{ value: 'deptId',label: 'deptName',emitPath: false,checkStrictly: true,multiple:true}"></el-cascader>
+ </el-form-item>
+ <el-form-item label="项目编码">
+ <el-input v-model.trim="search.queryParams.projectCode" placeholder="请输入项目编码"></el-input>
+ </el-form-item>
+ </el-form>
+ </div>
</template>
<template #footer>
- <div style="flex: auto">
- <el-button type="primary" @click="searchClick">查询</el-button>
- <el-button type="warning" @click="reset">重置</el-button>
- <el-button @click="confirmClick">取消</el-button>
+ <div style="display: flex;align-items: center;justify-content: space-between">
+ <vue3-json-excel
+ :json-data="expertList"
+ :fields="fields"
+ name="专家汇总表.xlsx"
+ >
+ <el-button type="primary" plain @click="handleExport">导出专家汇总表</el-button>
+ </vue3-json-excel>
+ <div>
+ <el-button type="primary" @click="searchClick">查询</el-button>
+ <el-button type="warning" @click="reset">重置</el-button>
+ <el-button @click="confirmClick">取消</el-button>
+ </div>
</div>
</template>
</el-drawer>
-
</div>
</template>
<script setup>
import {onMounted, reactive, ref} from "vue";
-import {delProject, getProjectList, getProjectStatistics} from "@/api/projectManage/project";
+// import {delProject, getProjectList, getProjectStatistics} from "@/api/projectManage/project";
import {ElMessage, ElMessageBox} from "element-plus";
-import {getRegionTree} from "@/api/area";
-import {getDict} from "@/api/login";
-import {getDictList} from "@/api/backManage/evaluate";
import Cookies from "js-cookie"
+import {delProject, exportData, exportExpertData, getProjectList, getProjectNum} from "@/api/projectManage";
+// import * as XLSX from 'xlsx';
+import XLSX from 'xlsx-js-style';
+import {listDept} from "@/api/system/dept";
+const { proxy } = getCurrentInstance();
+
const router = useRouter();
const loading = ref(false);
@@ -246,96 +184,135 @@
queryParams: {
pageNum: 1,
pageSize: 20,
- name: '',
- client: '',
- province: '',
- city: '',
- district: '',
- business: '',
- estimateType: '',
- phase: '',
- params:{
- lostMaterial: null
- }
+ projectName: '',
+ projectDateStart: '',
+ projectDateEnd: '',
+ step: null,
+ deptId: null,
+ projectCode: ''
},
num: {
- projectTotal: 0,
- riskTotal: 0,
- investigationTotal: 0,
- reviewTotal: 0,
- reportTotal: 0,
- archiveTotal: 0
+ approval: 0,
+ end: 0,
+ expert: 0,
+ staging: 0,
+ total: 0
}
});
+
+const expertList = ref([])
+// 导出表格
+const fields = ref({
+ '姓名':'expertName',
+ '处室':'deptName',
+ '发票金额': 'expertFee',
+ '交通费': 'travelExpenses',
+ '住宿费':'accommodationFee',
+ '申请时间': 'createTime',
+ '事由': 'projectName',
+ '发现重大隐患':'majorDangers',
+ '发现一般隐患': 'generalHazards'
+
+});
+
const searchTime = ref([]);
const area = ref([]);
-const businessList = ref([]);
-const addressList = ref([]);
-const estimateTypeList = ref([]);
-const missingList = ref([
+const stateList = ref([
{
id: 1,
- label: '是'
+ label: '基本信息'
},
{
- id: 0,
- label: '否'
- }
+ id: 2,
+ label: '专家选用'
+ },
+ {
+ id: 3,
+ label: '项目审批'
+ },
+ {
+ id: 4,
+ label: '项目归档'
+ },
])
-const tableRef = ref(null);
+const tableRef = ref(null);
const tableHeight = ref(0);
const dataList = ref([]);
+const deptList = ref([])
const total = ref(0);
-
+const isAgency = ref(false);
onMounted(() => {
Cookies.remove('projectId')
- getList();
- getStatistics();
- getArea();
- getBusinessList();
- getRiskList();
+ Cookies.remove('end')
+ Cookies.remove('btn')
+ getList()
+ getDeptList()
+ getStatistics()
+ exportEData()
+ // getArea();
+ // getBusinessList();
+ // getRiskList();
tableHeight.value = window.innerHeight - tableRef.value.$el.offsetTop - 170;
// 监听浏览器高度变化
window.onresize = () => {
tableHeight.value = window.innerHeight - tableRef.value.$el.offsetTop - 170;
};
+ // const userInfo = JSON.parse(Cookies.get('userInfo'))
+ // isAgency.value = userInfo.identity === 1;
});
const chooseType = ref('');
const choose = (val) => {
chooseType.value = val;
- search.queryParams.phase = val;
+ search.queryParams.step = val;
getList();
}
const getList = async () => {
loading.value = true;
const res = await getProjectList(search.queryParams);
- if(res.code == 200){
- 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 : '',
- area: item.district ? item.province + '/' + item.city + '/' + item.district : item.city?item.province + '/' + item.city:item.province ,
- filingDate: item.filingDate ? conversionDays(item.filingDate,item.createTime) : conversionDays('',item.createTime),
- contractMoney: item.contract ? item.contract.contractMoney : '',
- actualContractMoney: item.contract ? item.contract.actualContractMoney : '',
- activeConfirm: item.personRecognition ? item.personRecognition.recognitionCnt + '/' + item.personRecognition.personCnt: '',
- missingMaterialCnt: 3-item.materialCnt
- }
- })
- total.value = res.data.total
+ if (res.code == 200) {
+ dataList.value = res.rows
+ total.value = res.total
loading.value = false;
- }else{
+ } else {
ElMessage.warning(res.message)
}
}
+
+const exportEData = async () => {
+ const {pageSize,pageNum,step,...data} = search.queryParams
+ const res = await exportExpertData(data);
+ if (res.code == 200) {
+
+ if(res.data && res.data.length > 0){
+ expertList.value = res.data
+ }else {
+ expertList.value = []
+ }
+ } else {
+ ElMessage.warning(res.message)
+ }
+}
+const handleExport = () => {
+ if(expertList.value && expertList.value.length == 0){
+ ElMessage.warning('暂无数据导出')
+ }
+}
+function getDeptList() {
+ listDept({
+ deptName: undefined,
+ status: undefined
+ }).then(response => {
+ deptList.value = proxy.handleTree(response.data, "deptId",'parentId','children');
+ });
+ console.log(deptList.value,999)
+}
+
const getStatistics = async () => {
- const {pageNum,pageSize, ...data} = JSON.parse(JSON.stringify(search.queryParams))
- const res = await getProjectStatistics(data);
- if(res.code == 200){
+ const res = await getProjectNum();
+ if (res.code == 200) {
search.num = res.data
- }else{
+ } else {
ElMessage.warning(res.message)
}
}
@@ -348,35 +325,9 @@
search.queryParams.pageNum = val
getList()
}
-const toProcess = (type,value,toPath) => {
+const toProcess = (type, value, toPath) => {
value.type = type;
- router.push({ path: '/process', query: {id: value.id, type: type, toPath: toPath, process: value.reportProgress}});
-}
-
-const getArea = async ()=>{
- const type = 1
- const res = await getRegionTree({name: '',parentId: null,regionType: type})
- if(res.code == 200){
- addressList.value = res.data
- }else{
- ElMessage.warning(res.message)
- }
-}
-const getBusinessList = async () => {
- const res = await getDict({dictType: 'sys_business_scope'})
- if(res.code === 200){
- businessList.value = res.data
- }else{
- ElMessage.warning(res.message)
- }
-}
-const getRiskList = async () => {
- const res = await getDictList({dictType: "sys_assess_type"});
- if(res.code === 200){
- estimateTypeList.value = res.data.list
- }else{
- ElMessage.warning(res.message)
- }
+ router.push({path: '/process', query: {id: value.id, type: type, toPath: toPath, process: value.step}});
}
const del = (val) => {
@@ -388,153 +339,248 @@
cancelButtonText: '取消',
type: 'warning',
})
- .then( async() => {
- const res = await delProject(val)
- if(res.code == 200){
+ .then(async () => {
+ const res = await delProject(val.id)
+ if (res.code == 200) {
ElMessage.success('数据删除成功')
- getList()
- getStatistics()
+ await getList()
+ await getStatistics()
- }else{
- ElMessage.warning(res.message)
+ } else {
+ ElMessage.warning(res.msg)
}
})
}
const confirmClick = () => {
+ reset()
showDrawer.value = false;
}
-const changeTime=(value)=>{
- if(!value){
- search.queryParams.params.endTime = ""
- search.queryParams.params.startTime = ""
+const changeTime = (value) => {
+ if (!value) {
+ search.queryParams.projectDateStart = ""
+ search.queryParams.projectDateEnd = ""
}
}
+
+const downloadExcel = async (row) => {
+ const res = await exportData({projectId: row.id})
+ if (res.code == 200) {
+ // 定义标题
+ const title = [[`自治区应急管理厅外聘专家劳务费发放表（项目编码${row.projectCode}）`]]
+ // 固定一行：填报处室和单位
+ const fixedHeader = [
+ ["填报处室：" + row.deptName, "", "", "", "", "单位：元", "", "", "","", "制表日期："+row.updateTime,"", "",""]
+ ]
+ if(res.data && res.data[0] && Array.isArray(res.data[0].projectExpertExportResps) && res.data[0].projectExpertExportResps.length>0){
+ let mainData = res.data[0].projectExpertExportResps
+ const data = mainData.map((item,index)=>{
+ return [index+1,item.name,item.companyName,item.title,item.idCard,item.freightBasis,item.billingDuration,item.taxExpertFee,item.incomeTaxPayable,(item.taxExpertFee-item.incomeTaxPayable).toFixed(2),item.travelExpenses,item.accommodationFee,item.openBank,item.bankCard]
+ })
+ console.log(data,'data')
+ // 定义表头
+ const headers = [
+ ["序号", "姓名", "工作单位", "职称", "身份证号", "计费标准", "计费时长", "发票金额", "应缴税费","发放金额", "交通费", "住宿费","开户银行", "卡号"]
+ ]
+ // 固定一行：经办人和负责人
+ const footer = [
+ ["经办人：", "", "", "", "", "处室负责人：", "", `合计：${data.reduce((accumulator, currentValue) => {
+ return accumulator + currentValue[7]
+ }, 0).toFixed(2)}`,`合计：${data.reduce((accumulator, currentValue) => {
+ return accumulator + currentValue[8]
+ }, 0).toFixed(2)}`,`合计：${data.reduce((accumulator, currentValue) => {
+ return accumulator + Number(currentValue[9])
+ }, 0).toFixed(2)}`,"",""],
+ ]
+ // 创建工作表
+ const ws = XLSX.utils.aoa_to_sheet([
+ ...title, // 标题
+ ...fixedHeader, // 填报处室和单位
+ ...headers, // 表头
+ ...data, // 数据
+ ...footer // 经办人和负责人
+ ])
+ // 获取数据的总行数
+ const dataRowCount = data.length;
+ // 合并单元格的范围
+ ws['!merges'] = [
+ { s: { r: 0, c: 0 }, e: { r: 0, c: 12 } }, // 合并标题：第1行 0列到12列
+ { s: { r: 1, c: 0 }, e: { r: 1, c: 4 } }, // 合并填报处室：第2行 第0列到4列
+ { s: { r: 1, c: 5 }, e: { r: 1, c: 9 } }, // 合并单位：第2行 第5列到8列
+ { s: { r: 1, c: 10 }, e: { r: 1, c: 13 } }, // 合并单位：第2行 第5列到8列
+ { s: { r: 3 + dataRowCount, c: 0 }, e: { r: 3 + dataRowCount, c: 4 } }, // 合并经办人：最后一行的第0列到4列
+ { s: { r: 3 + dataRowCount, c: 5 }, e: { r: 3 + dataRowCount, c: 6} }, // 合并负责人：最后一行的第5列到+6列
+ ]
+ // 设置标题
+ if (!ws['A1']) ws['A1'] = {}; // 确保 A1 单元格存在
+ ws['A1'].s = {
+ alignment: { horizontal: 'center', vertical: 'center' },
+ font: { bold: true, sz: 16 }
+ }
+ // 设置填报处室和单位左对齐
+ if (!ws['A2']) ws['A2'] = {} // 填报处室第一列
+ if (!ws['F2']) ws['F2'] = {} // 单位第一列
+ if (!ws['J2']) ws['J2'] = {} // 单位第一列
+ ws['A2'].s = ws['F2'].s = ws['J2'].s ={
+ alignment: { horizontal: 'left', vertical: 'center' }
+ };
+ // 设置数据区（包括填报处室、单位、数据行和最后一行）为左对齐
+ const totalRows = 3 + dataRowCount + 1; // 标题、固定行和数据行的总数
+ for (let r = 3; r <= totalRows; r++) { // 遍历每一行
+ for (let c = 0; c < 14; c++) { // 遍历每一列
+ const cellRef = `${String.fromCharCode(65 + c)}${r}`;
+ if (!ws[cellRef]) ws[cellRef] = {}; // 确保单元格存在
+ ws[cellRef].s = {
+ alignment: { horizontal: 'center', vertical: 'center' } // 设置居中对齐
+ };
+ }
+ }
+ // 设置表头居中并加粗
+ const colCount = headers[0].length; // 表头的列数
+ for (let i = 0; i < colCount; i++) {
+ const cellRef = `${String.fromCharCode(65 + i)}3`; // 从第3行开始设置表头
+ if (!ws[cellRef]) ws[cellRef] = {}; // 确保单元格存在
+ ws[cellRef].s = {
+ alignment: { horizontal: 'center', vertical: 'center' }, // 表头居中
+ font: { bold: true } // 设置加粗
+ };
+ }
+ // 设置最后一行（经办人、负责人）左对齐
+ const lastRowStart = 3 + dataRowCount;
+ for (let c = 0; c < 14; c++) {
+ const cellRef = `${String.fromCharCode(65 + c)}${lastRowStart + 1}`;
+ console.log(cellRef,'ref')
+ if (!ws[cellRef]) ws[cellRef] = {}; // 确保单元格存在
+ if(cellRef == 'H'+ (4 + dataRowCount) || cellRef == 'I'+ (4 + dataRowCount) || cellRef == 'J'+ (4 + dataRowCount)){
+ ws[cellRef].s = {
+ alignment: { horizontal: 'center', vertical: 'center' } // 设置居中对齐
+ }
+ }else{
+ ws[cellRef].s = {
+ alignment: { horizontal: 'left', vertical: 'center' } // 设置为左对齐
+ }
+ }
+ }
+ // 设置列宽，计算每列的最大宽度
+ const MIN_COL_WIDTH = 60;
+ const colWidths = [];
+ for (let c = 0; c < 14; c++) {
+ let maxLength = 0;
+ // 计算每列最大单元格内容长度
+ for (let r = 0; r < totalRows; r++) {
+ const cellRef = `${String.fromCharCode(65 + c)}${r + 1}`; // 获取每个单元格的引用
+ const cell = ws[cellRef];
+ if (cell && cell.v) {
+ if(cell.v == '序号'){
+ maxLength = 1
+ }else if(cell.v == '交通费'){
+ maxLength = 3
+ } else {
+ maxLength = Math.max(maxLength, cell.v.toString().length);
+ }
+
+ }
+ }
+ // 根据最大长度设置列宽，添加额外的空间
+ colWidths[c] = { wpx: Math.max(maxLength * 15, MIN_COL_WIDTH) }; // 你可以根据需要调整乘数
+ }
+
+ // 设置工作表的列宽
+ ws['!cols'] = colWidths;
+
+ // 设置行高，统一调整上下间距
+ const rowHeight = 28; // 设置每一行的行高（可以根据需要调整）
+ for (let r = 0; r < totalRows; r++) {
+ ws['!rows'] = ws['!rows'] || [];
+ ws['!rows'][r] = { hpx: rowHeight }; // 设置行高，单位是像素
+ }
+ // 创建工作簿
+ const wb = XLSX.utils.book_new();
+ XLSX.utils.book_append_sheet(wb, ws, "Sheet1")
+ // 使用 Blob 和 URL 触发文件下载
+ const wbout = XLSX.write(wb, { bookType: 'xlsx', type: 'array' })
+ const blob = new Blob([wbout], { type: 'application/octet-stream' })
+ const url = URL.createObjectURL(blob)
+ // 创建下载链接并触发下载
+ const a = document.createElement('a')
+ a.href = url;
+ a.download = `${row.deptName}-${row.updateTime.substring(0,10)}.xlsx` // 设置下载文件名
+ document.body.appendChild(a)
+ a.click();
+ document.body.removeChild(a)
+ // 释放 URL 对象
+ URL.revokeObjectURL(url)
+ }
+ } else {
+ ElMessage.warning(res.msg)
+ }
+}
+
const searchClick = () => {
- if(searchTime.value && searchTime.value.length>0){
- search.queryParams.params.startTime = searchTime.value[0]
- search.queryParams.params.endTime = searchTime.value[1]
+ if (searchTime.value && searchTime.value.length > 0) {
+ search.queryParams.projectDateStart = searchTime.value[0]
+ search.queryParams.projectDateEnd = searchTime.value[1]
}
getList();
getStatistics();
+ exportEData()
showDrawer.value = false;
}
const reset = () => {
searchTime.value = [];
- area.value = [];
search.queryParams = {
pageNum: 1,
pageSize: 20,
- name: '',
- client: '',
- province: '',
- city: '',
- district: '',
- business: '',
- estimateType: '',
- phase: '',
- params: {
- lostMaterial: null
- }
+ projectName: '',
+ projectDateStart: '',
+ projectDateEnd: '',
+ step: null,
+ deptId: null,
+ projectCode: ''
}
chooseType.value = '';
getList();
getStatistics();
- showDrawer.value = false;
-}
-const conversionDays = (time,createTime) => {
- let day = "";
- if(time) {
- day = new Date(time).getTime() - new Date(createTime).getTime();//日期转时间戳
- }else {
- day = Date.now() - new Date(createTime).getTime();//日期转时间戳
- }
- return Math.floor(day / 86400000) ;//时间戳获取天数
-}
-const handleChange = (value) => {
- // if(state.registerForm.agency.attribute == 0){
- // state.registerForm.agency.province = '新疆维吾尔自治区'
- // state.registerForm.agency.city = value[0]?value[0]:''
- // state.registerForm.agency.district = value[1]?value[1]:''
- // }else{
- search.queryParams.province = value[0]?value[0]:''
- search.queryParams.city = value[1]?value[1]:''
- 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 '项目归档'
- }
- }
- },
- '项目实施天数': 'filingDate',
- '预估金额（万元）': 'contractMoney',
- '归档金额（万元）': 'actualContractMoney',
- '缺失要件': 'materialCnt',
- '归档确认': 'activeConfirm'
-});
-const goMenu = (toPath,val) => {
- console.log("val",val)
- if(toPath ==='toThirteen' && val.personRecognition && val.personRecognition. recognitionCnt === 0){
- ElMessage.warning('未进行签字确认，无法查看！')
- return;
- }
- toProcess('edit',val,toPath);
-}
+}
</script>
<style scoped lang="scss">
-.project-container{
- .header{
+.project-container {
+ .header {
margin: 15px 10px;
display: flex;
align-items: center;
justify-content: flex-end;
}
- .middle{
+
+ .middle {
height: 99px;
margin-bottom: 20px;
}
- .card-box{
+
+ .card-box {
margin: 20px;
height: 99px;
background: #fff;
- box-shadow: 0 3px 10px 0 rgba(62,62,62,.25);
+ box-shadow: 0 3px 10px 0 rgba(62, 62, 62, .25);
border-radius: 10px;
display: flex;
- .box-left{
+
+ .box-left {
width: 20%;
min-width: 200px;
height: 99px;
background: #fff;
- box-shadow: 0 0 5px 0 rgba(62,62,62,.2);
+ box-shadow: 0 0 5px 0 rgba(62, 62, 62, .2);
border-radius: 10px;
display: flex;
margin-left: -15px;
align-items: center;
cursor: pointer;
padding-left: 2%;
- .font-left{
+
+ .font-left {
width: 40px;
height: 40px;
font-size: 20px;
@@ -543,7 +589,8 @@
line-height: 18px;
font-family: fantasy;
}
- .font-right{
+
+ .font-right {
position: relative;
left: 7%;
top: -3px;
@@ -554,10 +601,12 @@
color: #222733;
}
}
- .box-left:hover{
+
+ .box-left:hover {
border: 1px solid #4378f1
}
- .box-right{
+
+ .box-right {
width: 80%;
height: 99px;
border-radius: 10px;
@@ -565,27 +614,32 @@
display: flex;
align-items: center;
justify-content: space-between;
- .inbox{
- width: 19%;
+
+ .inbox {
+ width: 23%;
height: 76px;
background: #fff;
border-radius: 5px;
cursor: pointer;
- .top{
+
+ .top {
width: 100%;
height: 39px;
border-top-left-radius: 5px;
border-top-right-radius: 5px;
- .top-right-font{
+
+ .top-right-font {
font-size: 16px;
color: #fff;
line-height: 39px;
margin-left: 10px;
}
}
- .bottom{
+
+ .bottom {
height: 37px;
- .top-right-font-bottom{
+
+ .top-right-font-bottom {
font-size: 20px;
color: #333;
line-height: 37px;
@@ -594,61 +648,78 @@
}
}
}
- .inbox:nth-child(1):hover{
+
+ .inbox:nth-child(1):hover {
border: 1px solid #dab4f6;
}
- .inbox:nth-child(2):hover{
+
+ .inbox:nth-child(2):hover {
border: 1px solid #efba8d;
}
- .inbox:nth-child(3):hover{
+
+ .inbox:nth-child(3):hover {
border: 1px solid #f99fc0;
}
- .inbox:nth-child(4):hover{
+
+ .inbox:nth-child(4):hover {
border: 1px solid #7cc4f2;
}
- .inbox:nth-child(5):hover{
+
+ .inbox:nth-child(5):hover {
border: 1px solid #72e8c8;
}
}
}
- .btn1{
+
+ .btn1 {
border: 1px solid #dab4f6;
}
- .btn2{
+
+ .btn2 {
border: 1px solid #efba8d;
}
- .btn3{
+
+ .btn3 {
border: 1px solid #f99fc0;
}
- .btn4{
+
+ .btn4 {
border: 1px solid #7cc4f2;
}
- .btn5{
+
+ .btn5 {
border: 1px solid #72e8c8;
}
- .pag-container{
+
+ .pag-container {
float: right;
margin-top: 20px;
}
- .process1{
+
+ .process1 {
border-radius: 5px;
color: rgb(255, 255, 255);
padding: 5px 10px;
background: linear-gradient(90deg, rgb(127, 118, 253), rgb(218, 180, 246));
}
- .process2{
+
+ .process2 {
background: linear-gradient(90deg, rgb(255, 140, 138), rgb(239, 186, 141));
}
+
.process3 {
background: linear-gradient(90deg, rgb(229, 119, 180), rgb(249, 159, 192));;
}
+
.process4 {
background: linear-gradient(90deg, rgb(54, 115, 255), rgb(124, 196, 242));;
}
+
.process5 {
background: linear-gradient(90deg, rgb(0, 195, 151), rgb(114, 232, 200));;
}
- .drawer{
+
+ .drawer {
:deep(.el-form .el-form-item__label) {
font-size: 15px;
}
--
Gitblit v1.9.2