From 96e50288e30a2e18bf13963100bb4fb0180aaa7b Mon Sep 17 00:00:00 2001
From: CD配唱片 <CD配唱片>
Date: 星期五, 25 四月 2025 20:49:21 +0800
Subject: [PATCH] 提交负载统计查询
---
src/views/mainPlan/gasProduceStatics/index.vue | 75 +++++++++++++++++++++++--------------
1 files changed, 47 insertions(+), 28 deletions(-)
diff --git a/src/views/mainPlan/gasProduceStatics/index.vue b/src/views/mainPlan/gasProduceStatics/index.vue
index ae47d56..2272d3f 100644
--- a/src/views/mainPlan/gasProduceStatics/index.vue
+++ b/src/views/mainPlan/gasProduceStatics/index.vue
@@ -11,7 +11,7 @@
<el-row type="flex" justify="left">
<el-form-item label="缁熻鏂瑰紡">
<el-select
- v-model="queryParams.type"
+ v-model="queryParams.searchType"
style="width: 200px"
placeholder="Select"
@change="handleChangeSelectType"
@@ -104,10 +104,10 @@
} from "@/api/mainPlan/gasProduceStatics.js";
import { ref } from "vue";
import * as XLSX from "xlsx";
-
+import { ElMessage } from "element-plus";
const { proxy } = getCurrentInstance();
-const loading = ref(true);
+const loading = ref(false);
const gridRef = ref();
const gridRef2 = ref();
const height = ref(document.documentElement.clientHeight - 130 + "px;");
@@ -117,7 +117,7 @@
const data = reactive({
queryParams: {
monthRange: "",
- type: "鎸夋湀缁熻",
+ searchType: "鎸夋湀缁熻",
},
});
const options = [
@@ -167,6 +167,25 @@
}
/** 鏌ヨ闆朵欢缁熻琛ㄥ垪琛� */
function getList() {
+ let type = ""
+ options.map(item=>{
+ if(queryParams.value.searchType === item.label){
+ type = item.value
+ }
+ })
+ // 鍒涘缓涓�涓狣ate瀵硅薄
+ let sDate = new Date(queryParams.value.monthRange[0]);
+ let eDate = new Date(queryParams.value.monthRange[1]);
+ // 鑾峰彇骞翠唤鍜屾湀浠�
+ let sYear = sDate.getFullYear();
+ let sMonth = sDate.getMonth() + 1; // 鏈堜唤鏄粠0寮�濮嬬殑锛屾墍浠ヨ鍔�1
+ let eYear = eDate.getFullYear();
+ let eMonth = eDate.getMonth() + 1; // 鏈堜唤鏄粠0寮�濮嬬殑锛屾墍浠ヨ鍔�1
+ // 鏍煎紡鍖栦负"YYYY-MM"鐨勫舰寮�
+ let sYearMonth = `${sYear}-${sMonth.toString().padStart(2, "0")}`;
+ let eYearMonth = `${eYear}-${eMonth.toString().padStart(2, "0")}`;
+ console.log(sYearMonth, eYearMonth, "yearMonth");
+
let rowKey = 0;
let colKey = 0;
headers.value = [];
@@ -174,7 +193,11 @@
tableColumn = [];
tableData = [];
loading.value = true;
- listGasProduceStatics().then((response) => {
+ listGasProduceStatics({
+ searchStartDate: sYearMonth,
+ searchEndDate: eYearMonth,
+ searchType: type,
+ }).then((response) => {
const colList = [];
let headersOne = [];
let headersTwo = [];
@@ -190,7 +213,12 @@
title: "鏃ユ湡",
fixed: "left",
children: [
- { field: `resourceName`, title: "璧勬簮缁�", width: 250, type: "html" },
+ {
+ field: `resourceName`,
+ title: "璧勬簮缁�",
+ width: 250,
+ type: "html",
+ },
],
width: 160,
});
@@ -284,30 +312,21 @@
/** 瀵煎嚭鎸夐挳鎿嶄綔 */
function handleExport() {
- // 鍚堝苟琛ㄥご鍜屾暟鎹�
- const finalData = [...headers.value, ...exportData.value];
-
- // 灏嗘暟鎹浆鎹负 worksheet
- const ws = XLSX.utils.aoa_to_sheet(finalData);
-
- // 鍚堝苟鍗曞厓鏍硷紙濡傛灉闇�瑕侊級
- /* ws['!merges'] = [
- { s: { r: 0, c: 1 }, e: { r: 0, c: 3 } },
- { s: { r: 0, c: 0 }, e: { r: 0, c: 0 } }
- ]; */
-
- ws["!merges"] = merges;
-
- // 鍒涘缓 workbook
- const wb = XLSX.utils.book_new();
- // 灏� worksheet 娣诲姞鍒� workbook 涓�
- XLSX.utils.book_append_sheet(wb, ws, "Sheet1");
- // 瀵煎嚭鏂囦欢
- XLSX.writeFile(wb, `apsPartRouteStat_${new Date().getTime()}.xlsx`);
+ proxy.download(
+ "/aps/apsGasPipingRouteStat/exportExcel", {},
+ `aps_gas_produce_statics_${new Date().getTime()}.xlsx`
+ );
}
/** 鎼滅储鎸夐挳鎿嶄綔 */
function handleQuery() {
- queryParams.value.pageNum = 1;
+ if (!queryParams.value.monthRange) {
+ ElMessage({
+ message: "璇烽�夋嫨骞存湀",
+ type: "error",
+ });
+ return;
+ }
+ // queryParams.value.pageNum = 1;
getList();
}
@@ -325,7 +344,7 @@
});
}
-getList();
+// getList();
</script>
<style lang="scss" scoped>
.box_container {
--
Gitblit v1.9.3