From b609f77709c4646daf155341475ae14fc0c7943d Mon Sep 17 00:00:00 2001
From: 祖安之光 <11848914+light-of-zuan@user.noreply.gitee.com>
Date: 星期五, 27 六月 2025 13:25:30 +0800
Subject: [PATCH] 修改
---
src/views/safetyReview/projectManage/index.vue | 136 +++++++++++++++++++++++++++++++++++++--------
1 files changed, 111 insertions(+), 25 deletions(-)
diff --git a/src/views/safetyReview/projectManage/index.vue b/src/views/safetyReview/projectManage/index.vue
index 01926ff..a0e6af0 100644
--- a/src/views/safetyReview/projectManage/index.vue
+++ b/src/views/safetyReview/projectManage/index.vue
@@ -65,11 +65,12 @@
<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" width="180"/>
- <el-table-column label="部门" prop="deptName" align="center"/>
- <el-table-column label="专家组组长" prop="expertName" align="center" width="150"/>
- <el-table-column label="专家组人数" prop="expertNum" align="center" width="150"/>
+ <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">
<span>{{
@@ -119,17 +120,37 @@
<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-input v-model.trim="search.queryParams.deptName" placeholder="请输入部门名称"></el-input>-->
+ <el-cascader
+ style="width: 100%"
+ clearable
+ v-model.trim="search.queryParams.deptId"
+ :show-all-levels="false"
+ placeholder="请选择部门"
+ :options="deptList"
+ :props="{ value: 'deptId',label: 'deptName',emitPath: false,checkStrictly: 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>
@@ -142,9 +163,11 @@
// import {delProject, getProjectList, getProjectStatistics} from "@/api/projectManage/project";
import {ElMessage, ElMessageBox} from "element-plus";
import Cookies from "js-cookie"
-import {delProject, exportData, getProjectList, getProjectNum} from "@/api/projectManage";
+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();
@@ -164,8 +187,9 @@
projectName: '',
projectDateStart: '',
projectDateEnd: '',
- step: null
-
+ step: null,
+ deptId: null,
+ projectCode: ''
},
num: {
approval: 0,
@@ -174,6 +198,21 @@
staging: 0,
total: 0
}
+});
+
+const expertList = ref([])
+// 导出表格
+const fields = ref({
+ '姓名':'expertName',
+ '处室':'deptName',
+ '专家费': 'expertFee',
+ '交通费': 'travelExpenses',
+ '住宿费':'accommodationFee',
+ '申请时间': 'createTime',
+ '事由': 'projectName',
+ '发现重大隐患':'majorDangers',
+ '发现一般隐患': 'generalHazards'
+
});
const searchTime = ref([]);
@@ -199,14 +238,17 @@
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')
Cookies.remove('end')
Cookies.remove('btn')
- getList();
- getStatistics();
+ getList()
+ getDeptList()
+ getStatistics()
+ exportEData()
// getArea();
// getBusinessList();
// getRiskList();
@@ -236,6 +278,36 @@
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 res = await getProjectNum();
if (res.code == 200) {
@@ -294,24 +366,28 @@
const res = await exportData({projectId: row.id})
if (res.code == 200) {
// 定义标题
- const title = [["自治区应急管理厅外聘专家劳务费发放表"]]
+ const title = [[`自治区应急管理厅外聘专家劳务费发放表（项目编码${row.projectCode}）`]]
// 固定一行：填报处室和单位
const fixedHeader = [
- ["填报处室：" + row.deptName, "", "", "", "", "单位：元", "", "", "", "","","",""]
+ ["填报处室：" + row.deptName, "", "", "", "", "单位：元", "", "", "", "","", "",""]
]
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.afterTaxAmount,item.openBank,item.bankCard,item.taxExpertFee,item.taxableIncome,item.incomeTaxPayable]
+ return [index+1,item.name,item.companyName,item.title,item.idCard,item.freightBasis,item.billingDuration,item.taxExpertFee,item.incomeTaxPayable,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)}`,"",""]
]
// 创建工作表
const ws = XLSX.utils.aoa_to_sheet([
@@ -329,7 +405,7 @@
{ s: { r: 1, c: 0 }, e: { r: 1, c: 4 } }, // 合并填报处室：第2行 第0列到4列
{ s: { r: 1, c: 5 }, e: { r: 1, c: 12 } }, // 合并单位：第2行 第5列到12列
{ 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: 12 } }, // 合并负责人：最后一行的第5列到12列
+ { s: { r: 3 + dataRowCount, c: 5 }, e: { r: 3 + dataRowCount, c: 6} }, // 合并负责人：最后一行的第5列到+6列
]
// 设置标题
if (!ws['A1']) ws['A1'] = {}; // 确保 A1 单元格存在
@@ -368,10 +444,17 @@
const lastRowStart = 3 + dataRowCount;
for (let c = 0; c < 13; c++) {
const cellRef = `${String.fromCharCode(65 + c)}${lastRowStart + 1}`;
+ console.log(cellRef,'ref')
if (!ws[cellRef]) ws[cellRef] = {}; // 确保单元格存在
- ws[cellRef].s = {
- alignment: { horizontal: 'left', vertical: 'center' } // 设置为左对齐
- };
+ if(cellRef == 'H'+ (4 + dataRowCount) || cellRef == 'I'+ (4 + dataRowCount)){
+ ws[cellRef].s = {
+ alignment: { horizontal: 'center', vertical: 'center' } // 设置居中对齐
+ }
+ }else{
+ ws[cellRef].s = {
+ alignment: { horizontal: 'left', vertical: 'center' } // 设置为左对齐
+ }
+ }
}
// 设置列宽，计算每列的最大宽度
const MIN_COL_WIDTH = 60;
@@ -433,6 +516,7 @@
}
getList();
getStatistics();
+ exportEData()
showDrawer.value = false;
}
const reset = () => {
@@ -443,7 +527,9 @@
projectName: '',
projectDateStart: '',
projectDateEnd: '',
- step: null
+ step: null,
+ deptId: null,
+ projectCode: ''
}
chooseType.value = '';
getList();
--
Gitblit v1.9.2