From a68195121e02f4294542a11ac96e48047f0fde24 Mon Sep 17 00:00:00 2001
From: yxh <172933527@qq.com>
Date: 星期三, 28 十月 2026 18:09:09 +0800
Subject: [PATCH] 绩效科室
---
src/views/project/statistics/performanceStaristics/index.vue | 286 ++++++++++++++++++++++++++++++++++-----------------------
1 files changed, 170 insertions(+), 116 deletions(-)
diff --git a/src/views/project/statistics/performanceStaristics/index.vue b/src/views/project/statistics/performanceStaristics/index.vue
index 85267d8..a93897b 100644
--- a/src/views/project/statistics/performanceStaristics/index.vue
+++ b/src/views/project/statistics/performanceStaristics/index.vue
@@ -1,30 +1,13 @@
<!-- -->
<template>
<div class="app-container">
- <el-form
- class="opo-query-form"
- :model="queryParams"
- ref="queryForm"
- :inline="true"
- label-width="70px"
- >
- <el-row :gutter="8">
- <el-col :span="6">
- <el-form-item label="涓氬姟浜哄憳" prop="pauserno">
- <el-input
- v-model="queryParams.pausername"
- placeholder="璇疯緭鍏ュ鍚�"
- clearable
- size="small"
- @keyup.enter.native="handleQuery"
- />
- </el-form-item>
- </el-col>
- <el-col :span="6">
+ <el-form class="opo-query-form" :model="queryParams" ref="queryForm" :inline="true" v-show="showSearch" label-width="70px">
+ <el-row :gutter="4">
+ <!-- <el-col :span="6">
<el-form-item align="left" label="涓氬姟缁�" prop="padeptno">
<el-select
v-model="queryParams.padeptno"
- placeholder="璇烽�夋嫨妗堜緥鐘舵��"
+ placeholder="璇烽�夋嫨閮ㄩ棬銆佷笟鍔＄粍"
>
<el-option
v-for="item in deptList"
@@ -34,97 +17,72 @@
</el-option>
</el-select>
</el-form-item>
- </el-col>
- <el-col :span="6">
- <el-form-item label="缁╂晥绫诲瀷">
- <el-select
- v-model="queryParams.pabonustype"
- placeholder="璇烽�夋嫨妗堜緥鐘舵��"
- >
- <el-option
- v-for="item in reportlist"
- :label="item.label"
- :value="item.value"
- >
- </el-option>
- </el-select>
- </el-form-item>
- </el-col>
- </el-row>
- <el-row :gutter="8">
- <el-col :span="12">
+ </el-col> -->
+ <el-col :span="8">
<el-form-item label="缁熻鏃ユ湡">
- <el-date-picker
- style="width: 100%"
- v-model="selecttime"
- type="monthrange"
- range-separator="鑷�"
- start-placeholder="寮�濮嬫湀浠�"
- end-placeholder="缁撴潫鏈堜唤"
- value-format="yyyy-MM-dd"
- @change="getTimeList"
- >
+ <el-date-picker style="width: 100%" v-model="selecttime" type="monthrange" range-separator="鑷�"
+ start-placeholder="寮�濮嬫湀浠�" end-placeholder="缁撴潫鏈堜唤" value-format="yyyy-MM-dd" @change="getTimeList">
</el-date-picker>
</el-form-item>
</el-col>
-
+ <el-col :span="10">
+ <el-form-item label="缁╂晥浜哄憳" prop="pauserno">
+ <el-input v-model="queryParams.pausername" placeholder="璇疯緭鍏ュ鍚�" clearable size="small"
+ @keyup.enter.native="handleQuery" />
+ </el-form-item>
+ </el-col>
<el-col :span="6">
<el-form-item>
- <el-button
- type="primary"
- icon="el-icon-search"
- size="mini"
- @click="handleQuery"
- >鎼滅储</el-button
- >
- <el-button icon="el-icon-refresh" size="mini" @click="resetQuery"
- >閲嶇疆</el-button
- >
+ <el-button type="primary" icon="el-icon-search" size="mini" @click="handleQuery">鎼滅储</el-button>
+ <el-button icon="el-icon-refresh" size="mini" @click="resetQuery">閲嶇疆</el-button>
</el-form-item>
</el-col>
</el-row>
</el-form>
- <!--<el-table v-loading="loading" border :data="donatebaseinfoList"> -->
- <el-table
- v-loading="loading"
- :data="jxidata"
- ref="table"
- border
- max-height="700"
- highlight-current-row
- :summary-method="getSummaries"
- show-summary
- >
- <el-table-column label="搴忓彿" align="center" prop="id" width="100">
- </el-table-column>
+ <el-row :gutter="10" class="mb8">
+ <el-col :span="1.5">
+ <el-button type="warning" plain icon="el-icon-download" size="mini" :loading="exportLoading"
+ @click="handleExport">瀵煎嚭</el-button>
+ </el-col>
+ <right-toolbar :showSearch.sync="showSearch" @queryTable="getList"></right-toolbar>
+ </el-row>
- <el-table-column label="缁熻鏈堜唤" align="center" prop="bonusmonth" />
+ <el-tabs v-model="activeTab">
+ <el-tab-pane label="鎸変笟鍔＄粍" name="dept">
+ <el-table v-loading="loading" :data="deptData" ref="deptTable" border max-height="700"
+ highlight-current-row :summary-method="getDeptSummaries" show-summary>
+ <el-table-column label="搴忓彿" align="center" prop="id" width="80" />
+ <el-table-column label="涓氬姟缁�" align="center" prop="deptname" />
+ <el-table-column label="缁╂晥閲戦" align="center" prop="amount" :formatter="amountFormatter" />
+ <el-table-column label="鏈堝害缁╂晥" align="center" prop="mamount" :formatter="amountFormatter" />
+ <el-table-column label="瀛ｅ害缁╂晥" align="center" prop="samount" :formatter="amountFormatter" />
+ <el-table-column label="骞村害缁╂晥" align="center" prop="yamount" :formatter="amountFormatter" />
+ </el-table>
+ </el-tab-pane>
- <el-table-column label="涓氬姟缁�" align="center" prop="deptName">
- </el-table-column>
- <el-table-column label="涓撹亴浜哄憳" align="center" prop="beneficiaryname" />
+ <el-tab-pane label="鎸変汉鍛�" name="person">
+ <el-table v-loading="loading" :data="jxidata" ref="personTable" border max-height="700"
+ highlight-current-row :summary-method="getSummaries" show-summary>
+ <el-table-column label="搴忓彿" align="center" prop="id" width="80" />
+ <el-table-column label="涓氬姟缁�" align="center" prop="deptName" />
+ <el-table-column label="缁╂晥浜哄憳/鍖婚櫌" align="center" prop="beneficiaryname" />
+ <el-table-column label="缁╂晥閲戦" align="center" prop="amount" :formatter="amountFormatter" />
+ <el-table-column label="鏈堝害缁╂晥" align="center" prop="mamount" :formatter="amountFormatter" />
+ <el-table-column label="瀛ｅ害缁╂晥" align="center" prop="samount" :formatter="amountFormatter" />
+ <el-table-column label="骞村害缁╂晥" align="center" prop="yamount" :formatter="amountFormatter" />
+ <!-- <el-table-column label="鎿嶄綔" align="center" class-name="small-padding fixed-width" fixed="right">
+ <template slot-scope="scope">
+ <el-button size="mini" type="text" icon="el-icon-edit">鏄庣粏</el-button>
+ </template>
+ </el-table-column> -->
+ </el-table>
+ </el-tab-pane>
+ </el-tabs>
- <el-table-column label="閲戦" align="center" prop="amount" />
-
- <el-table-column
- label="鎿嶄綔"
- align="center"
- class-name="small-padding fixed-width"
- fixed="right"
- >
- <template slot-scope="scope">
- <!-- v-if="scope.row.recordstate==2"
- -->
- <el-button size="mini" type="text" icon="el-icon-edit"
- >鏄庣粏</el-button
- >
- </template>
- </el-table-column>
- </el-table>
<div style="margin: 10px;text-align: right;">
<div>
- 鍏� <span style="color:#1890FF ;">{{ total }}</span> 鏉℃暟鎹�
+ 鍏� <span style="color:#1890FF ;">{{ tableTotal }}</span> 鏉℃暟鎹�
</div>
</div>
@@ -141,7 +99,9 @@
listsfeistatistics,
listbxiaostatistics,
listjixstatistics,
- listanlstatistics
+ listanlstatistics,
+ exportPerformanceStatistics,
+ exportPerformanceDeptStatistics
} from "@/api/project/statistics";
import { listUser } from "@/api/project/organization";
@@ -171,11 +131,6 @@
selecttime: "",
reportervalue: "",
- reportlist: [
- { label: "鏈堝害", value: 1 },
- { label: "瀛ｅ害", value: 2 },
- { label: "骞村害", value: 3 }
- ],
//鐪佸競鍖�
//榛樿鍊艰缃紝鍙负绌�
searchAddress: {
@@ -213,7 +168,7 @@
shi: "",
qu: ""
},
- deptList:[],
+ deptList: [],
// 閬僵灞�
loading: false,
// 瀵煎嚭閬僵灞�
@@ -232,6 +187,10 @@
donatebaseinfoList: [],
// 鎹愮尞鍩虹琛ㄦ牸鏁版嵁
jxidata: [],
+ // 褰撳墠椤电锛歞ept=鎸変笟鍔＄粍锛宲erson=鎸変汉鍛�
+ activeTab: "dept",
+ // 鎸変笟鍔＄粍鑱氬悎鏁版嵁
+ deptData: [],
// 寮瑰嚭灞傛爣棰�
title: "",
// 鏄惁鏄剧ず寮瑰嚭灞�
@@ -240,10 +199,9 @@
daterangeReporttime: [],
// 鏌ヨ鍙傛暟
queryParams: {
- pabonustype:'',
pabegtime: null,
paendtime: null,
- pauserno: null,
+ pausername: "",
padeptno: null,
},
@@ -265,9 +223,13 @@
};
},
//鐩戝惉灞炴�� 绫讳技浜巇ata姒傚康
- computed: {},
- activated() {},
- mounted() {},
+ computed: {
+ tableTotal() {
+ return this.activeTab === "dept" ? this.deptData.length : this.jxidata.length;
+ }
+ },
+ activated() { },
+ mounted() { },
//鐩戞帶data涓殑鏁版嵁鍙樺寲
watch: {},
@@ -297,7 +259,7 @@
resetArr(Arr) {
var hash = {};
- Arr = Arr.reduce(function(arr, current) {
+ Arr = Arr.reduce(function (arr, current) {
hash[current.reporterno]
? ""
: (hash[current.reporterno] = true && arr.push(current));
@@ -306,15 +268,73 @@
return Arr;
},
+ /** 缁勮鏌ヨ鍙傛暟锛氭湭閫夋嫨缁熻鏃ユ湡鏃舵煡鍏ㄩ儴 */
+ buildQueryParams() {
+ const query = { ...this.queryParams };
+ if (!query.pabegtime || !query.paendtime) {
+ // 鏂� SP 榛樿鍙栬繎 6 涓湀锛岃�岀哗鏁� jxrq 鏁版嵁闆嗕腑鍦� 2023-08~2024-01锛岄粯璁や細鏌ヤ笉鍒�
+ query.pabegtime = "2000-01-01 00:00:00";
+ query.paendtime = "2999-12-31 23:59:59";
+ }
+ return query;
+ },
+
/** 鏌ヨ鎹愮尞鍩虹鍒楄〃 */
getList() {
- listjixstatistics(this.queryParams).then(res => {
+ listjixstatistics(this.buildQueryParams()).then(res => {
this.jxidata = res.rows;
this.jxidata.forEach(($obj, $index) => {
$obj.id = $index + 1;
});
- this.total=res.total;
+ this.total = res.total;
+ this.buildDeptData();
});
+ },
+ /** 鎸変笟鍔＄粍鑱氬悎锛氱哗鏁堥噾棰�/鏈堝害/瀛ｅ害/骞村害鍒嗗埆姹傚拰 */
+ buildDeptData() {
+ const map = new Map();
+ this.jxidata.forEach(row => {
+ const key = row.deptId || row.deptName || "鏈垎缁�";
+ if (!map.has(key)) {
+ map.set(key, {
+ deptname: row.deptName || "鏈垎缁�",
+ amount: 0,
+ mamount: 0,
+ samount: 0,
+ yamount: 0
+ });
+ }
+ const item = map.get(key);
+ item.amount += Number(row.amount) || 0;
+ item.mamount += Number(row.mamount) || 0;
+ item.samount += Number(row.samount) || 0;
+ item.yamount += Number(row.yamount) || 0;
+ });
+ this.deptData = Array.from(map.values()).map((item, index) => {
+ item.id = index + 1;
+ return item;
+ });
+ },
+ /** 瀵煎嚭鎸夐挳鎿嶄綔 */
+ handleExport() {
+ const queryParams = this.buildQueryParams();
+ const exportApi =
+ this.activeTab === "dept"
+ ? exportPerformanceDeptStatistics
+ : exportPerformanceStatistics;
+ this.$modal
+ .confirm("鏄惁纭瀵煎嚭褰撳墠鍒楄〃鐨勭哗鏁堢粺璁℃暟鎹紵")
+ .then(() => {
+ this.exportLoading = true;
+ return exportApi(queryParams);
+ })
+ .then(response => {
+ this.$download.name(response.msg);
+ this.exportLoading = false;
+ })
+ .catch(() => {
+ this.exportLoading = false;
+ });
},
listDept() {
listDept({}).then(response => {
@@ -339,10 +359,9 @@
this.queryParams = {
- pabonustype:'',
pabegtime: null,
paendtime: null,
- pauserno: null,
+ pausername: "",
padeptno: null
};
this.selecttime = [];
@@ -357,10 +376,24 @@
this.resetForm("queryForm");
this.handleQuery();
},
+ /** 閲戦鏄剧ず锛氫繚鐣欎袱浣嶅皬鏁帮紝0.00 涓嶆樉绀� */
+ formatAmount(value) {
+ if (value === null || value === undefined || value === "") {
+ return "";
+ }
+ const num = Number(value);
+ if (!Number.isFinite(num) || num === 0) {
+ return "";
+ }
+ return num.toFixed(2);
+ },
+ amountFormatter(row, column, cellValue) {
+ return this.formatAmount(cellValue);
+ },
getSummaries(param) {
const { columns, data } = param;
const sums = [];
- var columnnames = ["applymonth", "deptmentName", "username",'deptName'];
+ var columnnames = ["deptName", "beneficiaryname"];
columns.forEach((column, index) => {
if (index === 0) {
sums[index] = "鍚堣";
@@ -373,7 +406,7 @@
const values = data.map(item => Number(item[column.property]));
if (!values.every(value => isNaN(value))) {
- sums[index] = values.reduce((prev, curr) => {
+ const total = values.reduce((prev, curr) => {
const value = Number(curr);
if (!isNaN(value)) {
return prev + curr;
@@ -381,12 +414,33 @@
return prev;
}
}, 0);
- sums[index] = sums[index].toFixed(2); // 淇濈暀2浣嶅皬鏁帮紝瑙ｅ喅灏忔暟鍚堣鍒�;
+ // 鍚堣淇濈暀 2 浣嶅皬鏁帮紱0.00 涓嶆樉绀�
+ sums[index] = total === 0 ? "" : Number(total).toFixed(2);
} else {
sums[index] = "";
}
});
return sums;
+ },
+ /** 鎸変笟鍔＄粍琛ㄦ牸鍚堣 */
+ getDeptSummaries(param) {
+ const { columns, data } = param;
+ const sums = [];
+ columns.forEach((column, index) => {
+ if (index === 0) {
+ sums[index] = "鍚堣";
+ return;
+ }
+ if (column.property === "deptname") {
+ return;
+ }
+ const total = data.reduce(
+ (prev, item) => prev + (Number(item[column.property]) || 0),
+ 0
+ );
+ sums[index] = total === 0 ? "" : Number(total).toFixed(2);
+ });
+ return sums;
}
},
--
Gitblit v1.9.3