<template>
|
<div class="wareAgeWarm-container">
|
<!-- 历史库存 -->
|
<el-card shadow="hover" :body-style="{ paddingBottom: '0' }">
|
<el-form :model="queryParams" ref="queryForm" labelWidth="90">
|
<el-row>
|
<el-col :xs="24" :sm="12" :md="12" :lg="8" :xl="4" class="mb10">
|
<el-form-item label="关键字">
|
<el-input v-model="queryParams.searchKey" clearable="" placeholder="库区编码,物料编号" />
|
</el-form-item>
|
</el-col>
|
<!-- <el-col :xs="24" :sm="12" :md="12" :lg="8" :xl="4" class="mb10" v-if="showAdvanceQueryUIWareAgeWarm">
|
<el-form-item label="存储区编码">
|
<el-input v-model="queryParams.materialCode" clearable="" placeholder="请输入存储区编码"/>
|
</el-form-item>
|
</el-col>
|
<el-col :xs="24" :sm="12" :md="12" :lg="8" :xl="4" class="mb10" v-if="showAdvanceQueryUIWareAgeWarm">
|
<el-form-item label="ERP存储地">
|
<el-input v-model="queryParams.materialCode" clearable="" placeholder="请输入ERP存储地"/>
|
</el-form-item>
|
</el-col> -->
|
<el-col :xs="24" :sm="12" :md="12" :lg="8" :xl="4" class="mb10"
|
v-if="showAdvanceQueryUIWareAgeWarm">
|
<el-form-item label="物料编号">
|
<el-input v-model="queryParams.materialCode" clearable="" placeholder="请输入物料编号" />
|
</el-form-item>
|
</el-col>
|
<!-- <el-col :xs="24" :sm="12" :md="12" :lg="8" :xl="4" class="mb10" v-if="showAdvanceQueryUIWareAgeWarm">
|
<el-form-item label="项目编号">
|
<el-input v-model="queryParams.materialCode" clearable="" placeholder="请输入项目编号"/>
|
</el-form-item>
|
</el-col>
|
-->
|
<el-col :xs="24" :sm="12" :md="12" :lg="8" :xl="4" class="mb10"
|
v-if="showAdvanceQueryUIWareAgeWarm">
|
<el-form-item label="所在库区" prop="areaCode">
|
<el-select v-model="queryParams.areaCode" placeholder="请选择所在库区">
|
<el-option v-for="(item,index) in arr1" :key="index" :value="item.code"
|
:label="`[${item.code}] ${item.value}`"></el-option>
|
</el-select>
|
</el-form-item>
|
</el-col>
|
<el-col :xs="24" :sm="12" :md="12" :lg="8" :xl="4" class="mb10">
|
<el-form-item label="时间" prop="begineTime">
|
<!-- <el-input v-model="queryParams.BegineTime" clearable="" placeholder="请输入时间"/> -->
|
<!-- <el-date-picker v-model="queryParams.begineTime" value-format="YYYY-MM-DD HH:mm:ss"
|
format="YYYY-MM-DD HH:mm:ss" type="datetime" placeholder="选择日期时间">
|
</el-date-picker> -->
|
<el-date-picker v-model="queryParams.begineTime" type="datetime" placeholder="结束时间"
|
style="width: 100%" format="YYYY-MM-DD HH:mm:ss" value-format="YYYY-MM-DD HH:mm:ss" />
|
</el-form-item>
|
</el-col>
|
<el-col :xs="24" :sm="12" :md="12" :lg="6" :xl="6" class="mb10">
|
<el-form-item>
|
<el-button-group style="display: flex; align-items: center;">
|
<el-button type="primary" icon="ele-Search" @click="handleQueryWareAgeWarm"
|
v-auth="'inventoryWarning:page'" :disabled="disabled_btnWareAgeWarm"> 查询
|
</el-button>
|
<el-button icon="ele-Refresh" @click="resetWareAgeWarm"> 重置 </el-button>
|
<el-button icon="ele-ZoomIn" @click="changeAdvanceQueryUIWareAgeWarm"
|
v-if="!showAdvanceQueryUIWareAgeWarm" style="margin-left:5px;"> 高级查询 </el-button>
|
<el-button icon="ele-ZoomOut" @click="changeAdvanceQueryUIWareAgeWarm"
|
v-if="showAdvanceQueryUIWareAgeWarm" style="margin-left:5px;"> 隐藏 </el-button>
|
<el-button type="primary" style="margin-left:5px;" icon="ele-Download"
|
@click="handleExportExcelWareAgeWarm" v-auth="'inventoryWarning:exportExcel'"> 导出
|
</el-button>
|
</el-button-group>
|
</el-form-item>
|
</el-col>
|
</el-row>
|
</el-form>
|
</el-card>
|
<el-card class="full-table" shadow="hover" style="margin-top: 5px">
|
|
<el-table ref="tableRefWareAgeWarm" :data="tableDataWareAgeWarm" style="width: 100%"
|
v-loading="loadingWareAgeWarm" tooltip-effect="dark" row-key="id" @sort-change="sortChangeWareAgeWarm"
|
border="">
|
<el-table-column type="index" label="序号" width="55" align="center" />
|
<!-- <el-table-column prop="materialTypeName" label="工厂代码" show-overflow-tooltip="" /> -->
|
<!-- <el-table-column prop="materialTypeName" label="存储区编码" show-overflow-tooltip="" /> -->
|
<!-- <el-table-column prop="safeImumqty" label="ERP存储地" show-overflow-tooltip="" /> -->
|
<el-table-column prop="materialName" label="物料名称" show-overflow-tooltip="" />
|
<el-table-column prop="materialCode" label="物料编号" show-overflow-tooltip="" />
|
<el-table-column prop="materialUnit" label="单位" show-overflow-tooltip="" />
|
<el-table-column prop="areaCode" label="库区编号" show-overflow-tooltip="" />
|
<el-table-column prop="areaName" label="库区名称" show-overflow-tooltip="" />
|
<el-table-column prop="quantity" label="数量" show-overflow-tooltip="" />
|
<!-- <el-table-column prop="unit" label="快照时间" show-overflow-tooltip="" /> -->
|
|
</el-table>
|
<el-pagination v-model:currentPage="tableParamsWareAgeWarm.page"
|
v-model:page-size="tableParamsWareAgeWarm.pageSize" :total="tableParamsWareAgeWarm.total"
|
:page-sizes="[10, 20, 50, 100, 200, 500]" small="" background=""
|
@size-change="handleSizeChangeWareAgeWarm" @current-change="handleCurrentChangeWareAgeWarm"
|
layout="total, sizes, prev, pager, next, jumper" />
|
</el-card>
|
</div>
|
</template>
|
|
<script lang="ts" setup="" name="wareAgeWarm">
|
import { ref, onMounted, nextTick } from "vue";
|
import { ElMessageBox, ElMessage } from "element-plus";
|
import { auth } from '/@/utils/authFunction';
|
import { getDictDataItem as di, getDictDataList as dl } from '/@/utils/dict-utils';
|
import { formatDate, formatDate_T_Date, formatDate_T_Time, defaultTimeRange } from '/@/utils/formatTime';
|
import { exportPageExcel } from '/@/utils/exportPageExcel' //引入导出方法
|
|
import { wmsStockWarning, historialStockPage } from '/@/api/main/inventoryWarning/inventoryWarning';
|
import { handleSlectDataWmsMaterialType } from "/@/utils/selectData";
|
import { getAPI } from '/@/utils/axios-utils';
|
import { SysEnumApi } from '/@/api-services/api';
|
import commonFunction from '/@/utils/commonFunction';
|
const { getEnumDesc } = commonFunction();
|
import { getStatus } from '/@/utils/switchCase';
|
import { handleSlectDataWmsArea } from '/@/utils/selectData';
|
/***************************************************[库龄报表操作]开始***************************************************/
|
const showAdvanceQueryUIWareAgeWarm = ref(false);
|
const tableRefWareAgeWarm = ref(null);
|
const loadingWareAgeWarm = ref(false);
|
const disabled_btnWareAgeWarm = ref(false);
|
const tableDataWareAgeWarm = ref<any>([]);
|
const warningTypeData = ref<any>([]);
|
const queryParams = ref<any>({});
|
const tableParamsWareAgeWarm = ref({
|
page: 1,
|
pageSize: 10,
|
total: 0,
|
});
|
|
// 改变高级查询的控件显示状态
|
const changeAdvanceQueryUIWareAgeWarm = () => {
|
showAdvanceQueryUIWareAgeWarm.value = !showAdvanceQueryUIWareAgeWarm.value;
|
}
|
|
// 查询库龄报表
|
const handleQueryWareAgeWarm = async () => {
|
if(queryParams.value.begineTime==null){
|
ElMessage.warning("请选择时间");
|
return;
|
}
|
loadingWareAgeWarm.value = true;
|
disabled_btnWareAgeWarm.value = true;
|
var res = await historialStockPage(Object.assign(queryParams.value, tableParamsWareAgeWarm.value));
|
if (res.data.type == "success") {
|
tableDataWareAgeWarm.value = res.data.result.items ?? [];
|
tableParamsWareAgeWarm.value.total = res.data.result?.total;
|
}
|
loadingWareAgeWarm.value = false;
|
disabled_btnWareAgeWarm.value = false;
|
};
|
|
// 重置库龄报表查询
|
const resetWareAgeWarm = async () => {
|
queryParams.value = {}
|
};
|
|
// 库龄报表列排序
|
const sortChangeWareAgeWarm = async (column : any) => {
|
queryParams.value.field = column.prop;
|
queryParams.value.order = column.order;
|
await handleQueryWareAgeWarm();
|
};
|
|
// 改变库龄报表页面容量
|
const handleSizeChangeWareAgeWarm = (val : number) => {
|
tableParamsWareAgeWarm.value.pageSize = val;
|
handleQueryWareAgeWarm();
|
};
|
|
// 改变库龄报表页码序号
|
const handleCurrentChangeWareAgeWarm = (val : number) => {
|
tableParamsWareAgeWarm.value.page = val;
|
handleQueryWareAgeWarm();
|
};
|
|
/***************************************************[库龄报表操作]结束***************************************************/
|
/***************************************************[库龄报表导出]开始***************************************************/
|
//定义当前页面的方法组
|
const functionMapWareAgeWarm = {
|
formatDate_T_Date,
|
formatDate_T_Time
|
};
|
//点击导出按钮
|
const handleExportExcelWareAgeWarm = async (formData : Blob) => {
|
loadingWareAgeWarm.value = true;
|
disabled_btnWareAgeWarm.value = true;
|
var new_tableParamsWareAgeWarm = JSON.parse(JSON.stringify(tableParamsWareAgeWarm.value));
|
new_tableParamsWareAgeWarm.page = 1;
|
new_tableParamsWareAgeWarm.pageSize = 100000;
|
var res = await historialStockPage(Object.assign(queryParams.value, new_tableParamsWareAgeWarm));
|
if (res.data.type == "success") {
|
let array = res.data.result?.items ?? []
|
// array.forEach((item:any)=>{
|
// item.stockAlarm = getEnumDesc(item.stockAlarm, warningTypeData.value)
|
// });
|
exportExcelWareAgeWarm(array);
|
}
|
loadingWareAgeWarm.value = false;
|
disabled_btnWareAgeWarm.value = false;
|
};
|
//导出
|
const exportExcelWareAgeWarm = async (exportDataList : Array) => {
|
exportPageExcel(exportDataList, tableRefWareAgeWarm, "历史库存报表", functionMapWareAgeWarm);
|
};
|
/***************************************************[库龄报表导出]结束***************************************************/
|
let arr1 : any = ref("") //下拉读取接口
|
// 页面加载时
|
onMounted(async () => {
|
nextTick(async () => {
|
arr1.value = await handleSlectDataWmsArea({
|
// page: 1,
|
// pageSize: 1000,
|
// total: 0,
|
// IsDisabled:false,
|
// isVirtually:false,
|
// areaType:1 //立体库
|
}); //下拉读取接口
|
});
|
});
|
|
handleQueryWareAgeWarm();
|
</script>
|
<style scoped>
|
:deep(.el-input),
|
:deep(.el-select),
|
:deep(.el-input-number) {
|
width: 100%;
|
}
|
|
:deep(.el-table .danger-row) {
|
background: #F56C6C !important;
|
}
|
|
:deep(.el-table .success-row) {
|
background: #67C23A !important;
|
}
|
|
:deep(.el-table .warning-row) {
|
background: #E6A23C !important;
|
}
|
</style>
|
