<template>
|
<div class="app-container">
|
<el-form
|
class="responsive-form"
|
:model="queryParams"
|
ref="queryRef"
|
:inline="true"
|
v-show="showSearch"
|
label-width="68px"
|
>
|
<el-row type="flex" justify="left">
|
<el-form-item label="统计方式">
|
<el-select
|
v-model="queryParams.searchType"
|
style="width: 200px"
|
placeholder="Select"
|
@change="handleChangeSelectType"
|
>
|
<el-option
|
v-for="item in options"
|
:key="item.value"
|
:label="item.label"
|
:value="item.value"
|
/>
|
</el-select>
|
</el-form-item>
|
<el-form-item label="选择区间">
|
<div v-if="!dayCom">
|
<el-date-picker
|
v-model="queryParams.monthRange"
|
type="monthrange"
|
range-separator="至"
|
start-placeholder="选择开始月份"
|
end-placeholder="选择结束月份"
|
/>
|
</div>
|
<div v-else>
|
<el-date-picker
|
v-model="queryParams.monthDays"
|
type="month"
|
placeholder="选择月份"
|
/>
|
</div>
|
</el-form-item>
|
|
<el-form-item class="column-with-margin">
|
<el-button type="primary" icon="Search" @click="handleQuery"
|
>查询</el-button
|
>
|
<el-button icon="Refresh" @click="resetQuery">重置</el-button>
|
</el-form-item>
|
</el-row>
|
</el-form>
|
<el-row :gutter="10" class="mb8">
|
<el-col :span="1.5">
|
<el-button
|
type="warning"
|
plain
|
icon="Download"
|
@click="handleExport"
|
v-hasPermi="['apsPartRouteStat:export']"
|
>导出</el-button
|
>
|
</el-col>
|
<el-col :span="1.5">
|
<el-button
|
type="info"
|
plain
|
icon="Refresh"
|
@click="handleRefresh"
|
v-hasPermi="['apsPartRouteStat:edit']"
|
>更新</el-button
|
>
|
</el-col>
|
<right-toolbar @queryTable="getList" :search="false"></right-toolbar>
|
</el-row>
|
<div class="box_container">
|
<div class="title_text">管路规划产能负载统计</div>
|
<div class="tabel_container">
|
<vxe-grid
|
ref="gridRef"
|
v-bind="gridOptions"
|
:loading="loading"
|
></vxe-grid>
|
</div>
|
</div>
|
<div class="box_container">
|
<div class="title_text">气柜规划产能负载统计</div>
|
<div class="tabel_container">
|
<vxe-grid
|
ref="gridRef2"
|
v-bind="gridOptions"
|
:loading="loading"
|
></vxe-grid>
|
</div>
|
</div>
|
</div>
|
</template>
|
|
<script setup name="gasProduceStatics">
|
import {
|
listUpdateGasProduceStatics,
|
listGasProduceStatics,
|
} from "@/api/mainPlan/gasProduceStatics.js";
|
import { ref } from "vue";
|
import * as XLSX from "xlsx";
|
const { proxy } = getCurrentInstance();
|
|
const loading = ref(false);
|
const gridRef = ref();
|
const gridRef2 = ref();
|
const height = ref(document.documentElement.clientHeight - 400 + "px;");
|
const headers = ref([]);
|
const exportData = ref([]);
|
const showSearch = ref(true);
|
const data = reactive({
|
queryParams: {
|
monthRange: "",
|
monthDays: "",
|
searchType: "按月统计",
|
},
|
});
|
let searchTypeValue = ref("month");
|
const options = [
|
{
|
value: "month",
|
label: "按月统计",
|
},
|
{
|
value: "day",
|
label: "按日统计",
|
},
|
];
|
const { queryParams } = toRefs(data);
|
const gridOptions = reactive({
|
border: true,
|
stripe: true,
|
loading: false,
|
showOverflow: true,
|
eaderOverflow: true,
|
showFooterOverflow: true,
|
height: height,
|
columnConfig: {
|
resizable: true,
|
},
|
scrollX: {
|
enabled: true,
|
gt: 0,
|
threshold: 50,
|
},
|
scrollY: {
|
enabled: true,
|
gt: 0,
|
threshold: 50,
|
},
|
});
|
const dayCom = ref(false);
|
let tableColumn = [];
|
let tableData = [];
|
let merges = [];
|
function handleChangeSelectType(e) {
|
searchTypeValue.value = e
|
console.log(e,searchTypeValue.value, "sjcsuhcushc");
|
if (e === "day") {
|
dayCom.value = true;
|
} else {
|
dayCom.value = false;
|
}
|
}
|
function dateStr(dateTimeString) {
|
const dateTime = new Date(dateTimeString);
|
// 提取年份和月份
|
const year = dateTime.getFullYear();
|
const month = String(dateTime.getMonth() + 1).padStart(2, "0"); // 月份从0开始，所以需要加1，并用padStart补零
|
// 格式化年份和月份为 "yyyy-mm" 格式的字符串
|
return`${year}-${month}`;
|
}
|
/** 查询零件统计表列表 */
|
function getPipeList() {
|
let sYearMonth = "";
|
let eYearMonth = "";
|
// let type = "";
|
// options.map((item) => {
|
// if (queryParams.value.searchType === item.label) {
|
// type = item.value;
|
// }
|
// });
|
// 创建一个Date对象
|
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"的形式
|
sYearMonth = `${sYear}-${sMonth.toString().padStart(2, "0")}`;
|
eYearMonth = `${eYear}-${eMonth.toString().padStart(2, "0")}`;
|
console.log(sYearMonth, eYearMonth, "yearMonth");
|
|
let rowKey = 0;
|
let colKey = 0;
|
headers.value = [];
|
exportData.value = [];
|
tableColumn = [];
|
tableData = [];
|
loading.value = true;
|
listGasProduceStatics({
|
searchStartDate:
|
queryParams.value.searchType === "按月统计"
|
? sYearMonth
|
: dateStr(queryParams.value.monthDays),
|
searchEndDate:
|
queryParams.value.searchType === "按月统计"
|
? eYearMonth
|
: dateStr(queryParams.value.monthDays),
|
searchType: searchTypeValue.value,
|
major:'piping'
|
}).then((response) => {
|
console.log(response.data.planTable,'responseresponseresponse')
|
const colList = [];
|
let headersOne = [];
|
let headersTwo = [];
|
if(response.code == '200'){
|
if (!response.data.planTitle) {
|
loading.value = false;
|
return;
|
}
|
headersOne.push('日期');
|
headersTwo.push('工序名称');
|
colList.push({
|
field: 'dateCol',
|
title: '日期',
|
fixed: 'left',
|
children: [
|
{ field: `resourceName`, title: '工序名称', width: 250, type: 'html'},
|
],
|
width: 160
|
})
|
response.data.planTitle.forEach(item => {
|
headersOne.push(item);
|
headersOne.push('');
|
headersOne.push('');
|
headersTwo.push('设计产能');
|
headersTwo.push('需求产能');
|
headersTwo.push('产能负载');
|
colKey++
|
colList.push({
|
field: `dateColTime${colKey}`,
|
title: item,
|
children: [
|
{ field: `designTimes${colKey}`, title: '设计产能', width: 80},
|
{ field: `requireTimes${colKey}`, title: '需求产能', width: 80},
|
{ field: `capacityLoad${colKey}`, title: '产能负载', width: 80, type: 'html'},
|
],
|
width: 160
|
})
|
});
|
|
headers.value.push(headersOne);
|
headers.value.push(headersTwo);
|
|
const columnList = [...tableColumn, ...colList]
|
const dataList = []
|
let startCol = 1;
|
|
//获取map
|
response.data.planTable.map(mapItem => {
|
rowKey++
|
let lastCol = startCol + 2;
|
merges.push({ s: { r: 0, c: startCol }, e: { r: 0, c: lastCol} });
|
startCol = lastCol + 1;
|
let data = [];
|
const item = {
|
id: `${rowKey}`
|
}
|
for (const [key, listValue] of Object.entries(mapItem)) {
|
data.push(key);
|
|
let tableKey = 0;
|
let flag = false;
|
listValue.forEach(listItem => {
|
|
tableKey++
|
item[`designTimes${tableKey}`] = listItem.designTimes;
|
item[`requireTimes${tableKey}`] = listItem.requireTimes;
|
item[`capacityLoad${tableKey}`] = listItem.capacityLoad > 100 ? `<font color="red">${listItem.capacityLoad}%</font>` :listItem.capacityLoad+'%';
|
data.push(listItem.designTimes);
|
data.push(listItem.requireTimes);
|
data.push(listItem.capacityLoad+'%');
|
if (listItem.capacityLoad > 100) {
|
flag = true;
|
}
|
});
|
|
item[`resourceName`] = flag ? `<div class='el-badge'><sup class="el-badge__content is-fixed is-dot"></sup>${key}</div>` : key;
|
}
|
exportData.value.push(data);
|
dataList.push(item);
|
});
|
|
const $grid = gridRef.value
|
if ($grid) {
|
tableColumn = columnList
|
tableData = [...tableData, ...dataList]
|
$grid.loadColumn(tableColumn)
|
$grid.loadData(tableData)
|
gridOptions.loading = false
|
}
|
|
loading.value = false;
|
}
|
});
|
}
|
function getGasList() {
|
let sYearMonth = "";
|
let eYearMonth = "";
|
// let type = "";
|
// options.map((item) => {
|
// if (queryParams.value.searchType === item.label) {
|
// type = item.value;
|
// }
|
// });
|
// 创建一个Date对象
|
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"的形式
|
sYearMonth = `${sYear}-${sMonth.toString().padStart(2, "0")}`;
|
eYearMonth = `${eYear}-${eMonth.toString().padStart(2, "0")}`;
|
console.log(sYearMonth, eYearMonth, "yearMonth");
|
|
let rowKey = 0;
|
let colKey = 0;
|
headers.value = [];
|
exportData.value = [];
|
tableColumn = [];
|
tableData = [];
|
loading.value = true;
|
listGasProduceStatics({
|
searchStartDate:
|
queryParams.value.searchType === "按月统计"
|
? sYearMonth
|
: dateStr(queryParams.value.monthDays),
|
searchEndDate:
|
queryParams.value.searchType === "按月统计"
|
? eYearMonth
|
: dateStr(queryParams.value.monthDays),
|
searchType: searchTypeValue.value,
|
major:'gas'
|
}).then((response) => {
|
console.log(response.data.planTable,'responseresponseresponse')
|
const colList = [];
|
let headersOne = [];
|
let headersTwo = [];
|
if(response.code == '200'){
|
if (!response.data.planTitle) {
|
loading.value = false;
|
return;
|
}
|
headersOne.push('日期');
|
headersTwo.push('工序名称');
|
colList.push({
|
field: 'dateCol',
|
title: '日期',
|
fixed: 'left',
|
children: [
|
{ field: `resourceName`, title: '工序名称', width: 250, type: 'html'},
|
],
|
width: 160
|
})
|
response.data.planTitle.forEach(item => {
|
headersOne.push(item);
|
headersOne.push('');
|
headersOne.push('');
|
headersTwo.push('设计产能');
|
headersTwo.push('需求产能');
|
headersTwo.push('产能负载');
|
colKey++
|
colList.push({
|
field: `dateColTime${colKey}`,
|
title: item,
|
children: [
|
{ field: `designTimes${colKey}`, title: '设计产能', width: 80},
|
{ field: `requireTimes${colKey}`, title: '需求产能', width: 80},
|
{ field: `capacityLoad${colKey}`, title: '产能负载', width: 80, type: 'html'},
|
],
|
width: 160
|
})
|
});
|
|
headers.value.push(headersOne);
|
headers.value.push(headersTwo);
|
|
const columnList = [...tableColumn, ...colList]
|
const dataList = []
|
let startCol = 1;
|
|
//获取map
|
response.data.planTable.map(mapItem => {
|
rowKey++
|
let lastCol = startCol + 2;
|
merges.push({ s: { r: 0, c: startCol }, e: { r: 0, c: lastCol} });
|
startCol = lastCol + 1;
|
let data = [];
|
const item = {
|
id: `${rowKey}`
|
}
|
for (const [key, listValue] of Object.entries(mapItem)) {
|
data.push(key);
|
|
let tableKey = 0;
|
let flag = false;
|
listValue.forEach(listItem => {
|
|
tableKey++
|
item[`designTimes${tableKey}`] = listItem.designTimes;
|
item[`requireTimes${tableKey}`] = listItem.requireTimes;
|
item[`capacityLoad${tableKey}`] = listItem.capacityLoad > 100 ? `<font color="red">${listItem.capacityLoad}%</font>` :listItem.capacityLoad+'%';
|
data.push(listItem.designTimes);
|
data.push(listItem.requireTimes);
|
data.push(listItem.capacityLoad+'%');
|
if (listItem.capacityLoad > 100) {
|
flag = true;
|
}
|
});
|
|
item[`resourceName`] = flag ? `<div class='el-badge'><sup class="el-badge__content is-fixed is-dot"></sup>${key}</div>` : key;
|
}
|
exportData.value.push(data);
|
dataList.push(item);
|
});
|
|
const $grid = gridRef2.value
|
if ($grid) {
|
tableColumn = columnList
|
tableData = [...tableData, ...dataList]
|
$grid.loadColumn(tableColumn)
|
$grid.loadData(tableData)
|
gridOptions.loading = false
|
}
|
|
loading.value = false;
|
}
|
});
|
}
|
/** 导出按钮操作 */
|
function handleExport() {
|
proxy.download(
|
"/aps/apsGasPipingRouteStat/exportExcel",
|
{},
|
`aps_gas_produce_statics_${new Date().getTime()}.xlsx`
|
);
|
}
|
/** 搜索按钮操作 */
|
function handleQuery() {
|
if (
|
(!queryParams.value.monthRange && dayCom.value == false) ||
|
(!queryParams.value.monthDays && dayCom.value == true)
|
) {
|
ElMessage({
|
message: "请选择年月",
|
type: "error",
|
});
|
return;
|
}
|
// queryParams.value.pageNum = 1;
|
getPipeList();
|
getGasList();
|
}
|
|
/** 重置按钮操作 */
|
function resetQuery() {
|
proxy.resetForm("queryRef");
|
handleQuery();
|
}
|
/** 刷新按钮操作 */
|
function handleRefresh() {
|
updateStat().then((response) => {
|
if (response.code == "200") {
|
getPipeList();
|
getGasList();
|
}
|
});
|
}
|
|
// getList();
|
</script>
|
<style lang="scss" scoped>
|
.box_container {
|
width: 100%;
|
margin: 20px auto;
|
background: #fff;
|
border-radius: 5px;
|
box-shadow: 1px 1px 1px 4px#f1f1f1;
|
.title_text {
|
padding-top: 20px;
|
margin-left: 20px;
|
}
|
.tabel_container {
|
width: 98%;
|
margin: 20px auto;
|
}
|
}
|
</style>
|
