<template>
|
<div class="wareAgeWarm-container">
|
<el-card shadow="hover" :body-style="{ paddingBottom: '0' }">
|
<el-form :model="queryParamsWareAgeWarm" 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="queryParamsWareAgeWarm.searchKey" clearable="" placeholder="物料名称,物料编号,库位编号"/>
|
</el-form-item>
|
</el-col>
|
<el-col :xs="24" :sm="12" :md="12" :lg="8" :xl="6" class="mb10" v-if="showAdvanceQueryUIWareAgeWarm">
|
<el-form-item label="入库时间">
|
<el-date-picker placeholder="请选择入库时间" value-format="YYYY/MM/DD" type="daterange" v-model="queryParamsWareAgeWarm.recordInsertTimeRange" />
|
</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="queryParamsWareAgeWarm.materialName" 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="queryParamsWareAgeWarm.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="queryParamsWareAgeWarm.placeCode" 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="areaName">
|
<el-select v-model="queryParamsWareAgeWarm.areaName" placeholder="请选择所在库区">
|
<el-option v-for="(item,index) in arr1" :key="index" :value="item.value" :label="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" v-if="showAdvanceQueryUIWareAgeWarm">
|
<el-form-item label="容器编号">
|
<el-input v-model.trim="queryParamsWareAgeWarm.containerCode" placeholder="请输入容器编号" clearable></el-input>
|
</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="queryParamsWareAgeWarm.qualityAssurance" 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-number v-model="queryParamsWareAgeWarm.wareAge" 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="queryParamsWareAgeWarm.overDueDays" clearable="" placeholder="请输入超期天数"/>
|
|
</el-form-item>
|
</el-col> -->
|
<!-- <el-col :xs="24" :sm="12" :md="12" :lg="8" :xl="6" class="mb10" v-if="showAdvanceQueryUIWareAgeWarm">
|
|
<el-form-item label="超期范围">
|
<div style="display:flex">
|
<el-input v-model="queryParamsWareAgeWarm.overDueDaysStart" clearable="" placeholder="期天开始天数"/>
|
<div style="margin: 0 10px 0 10px;"> ~ </div>
|
<el-input v-model="queryParamsWareAgeWarm.overDueDaysEnd" clearable="" placeholder="超期结束天数"/>
|
</div>
|
|
</el-form-item>
|
</el-col> -->
|
<!-- <el-col :xs="24" :sm="12" :md="12" :lg="8" :xl="6" class="mb20"v-if="showAdvanceQueryUIWareAgeWarm">
|
<el-form-item label="期天开始天数" prop="startTime">
|
<el-date-picker :disabled="dialogType == 'detail'" v-model="queryParamsWareAgeWarm.overDueDaysStart" type="date" placeholder="期天开始天数" />
|
</el-form-item>
|
</el-col>
|
<el-col :xs="24" :sm="12" :md="12" :lg="8" :xl="6" class="mb20"v-if="showAdvanceQueryUIWareAgeWarm">
|
<el-form-item label="超期结束天数" prop="endTime">
|
<el-date-picker :disabled="dialogType == 'detail'" v-model="queryParamsWareAgeWarm.overDueDaysEnd" type="date" placeholder="超期结束天数" />
|
</el-form-item>
|
</el-col> -->
|
<el-col :xs="24" :sm="12" :md="12" :lg="8" :xl="6" class="mb10" v-if="showAdvanceQueryUIWareAgeWarm">
|
|
<el-form-item label="超期范围">
|
<div style="display:flex">
|
<el-input v-model="queryParamsWareAgeWarm.overDueDaysStart" clearable="" placeholder="超期天数"/>
|
<div style="margin: 0 10px 0 10px;"> ~ </div>
|
<el-input v-model="queryParamsWareAgeWarm.overDueDaysEnd" clearable="" placeholder="超期天数"/>
|
</div>
|
|
</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="'wareAgeWarm: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-Plus" @click="openAddWareAgeWarm" v-auth="'wareAgeWarm:add'"> 新增 </el-button>
|
<el-button type="primary" style="margin-left:5px;" icon="ele-Download" @click="handleExportExcelWareAgeWarm" v-auth="'wareAgeWarm: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="light" @sort-change="sortChangeWareAgeWarm"
|
border="">
|
<el-table-column type="index" label="序号" width="55" align="center"/>
|
<el-table-column prop="materialCode" label="物料编号" min-width="110px" show-overflow-tooltip="" />
|
<el-table-column prop="materialName" label="物料名称" min-width="110px" show-overflow-tooltip="" />
|
<el-table-column prop="snCode" label="跟踪码" min-width="260px" show-overflow-tooltip="" />
|
<el-table-column prop="placeCode" label="库位编号" show-overflow-tooltip="" />
|
<el-table-column prop="containerCode" label="容器编号" show-overflow-tooltip="" />
|
<el-table-column prop="areaName" label="所属库区" show-overflow-tooltip="" />
|
<el-table-column prop="qualityAssurance" label="预警库龄" show-overflow-tooltip="" />
|
<el-table-column prop="wareAge" label="库龄" show-overflow-tooltip="" />
|
<el-table-column prop="overDueDays" label="超期天数" show-overflow-tooltip="" />
|
<el-table-column prop="recordInsertTime" label="入库时间" min-width="130px" show-overflow-tooltip="" />
|
|
|
<!-- <el-table-column prop="createTime" label="创建时间" width="130" show-overflow-tooltip="" /> -->
|
<!-- <el-table-column prop="updateTime" label="修改时间" width="130" :formatter="formatDate_T_Time" show-overflow-tooltip="" />
|
<el-table-column prop="createUserName" label="创建人" show-overflow-tooltip="" />
|
<el-table-column prop="updateUserName" label="修改人" show-overflow-tooltip="" />
|
<el-table-column label="操作" width="140" align="center" fixed="right" show-overflow-tooltip="" v-if="auth('wareAgeWarm:update') || auth('wareAgeWarm:delete')">
|
<template #default="scope">
|
<el-button icon="ele-Edit" size="small" text="" type="primary" @click="openEditWareAgeWarm(scope.row)" v-auth="'wareAgeWarm:update'"> 编辑 </el-button>
|
<el-button icon="ele-Delete" size="small" text="" type="primary" @click="delWareAgeWarm(scope.row)" v-auth="'wareAgeWarm:delete'"> 删除 </el-button>
|
</template>
|
</el-table-column> -->
|
</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"
|
/>
|
<printDialogWareAgeWarm
|
ref="printDialogRefWareAgeWarm"
|
:title="printWareAgeWarmTitle"
|
@reloadTable="handleQueryWareAgeWarm" />
|
<editDialogWareAgeWarm
|
ref="editDialogRefWareAgeWarm"
|
:title="editWareAgeWarmTitle"
|
@reloadTable="handleQueryWareAgeWarm"
|
/>
|
</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 { handleSlectDataWmsArea } from '/@/utils/selectData';
|
|
import printDialogWareAgeWarm from '/@/views/system/print/component/hiprint/preview.vue'
|
import { pageWareAgeWarm, deleteWareAgeWarm,importExcelWareAgeWarm,downloadExcelTemplateWareAgeWarm } from '/@/api/main/WareAgeWarm/wareAgeWarm';
|
|
|
|
/***************************************************[库龄报表操作]开始***************************************************/
|
const showAdvanceQueryUIWareAgeWarm = ref(false);
|
const tableRefWareAgeWarm = ref(null);
|
const printDialogRefWareAgeWarm = ref();
|
const editDialogRefWareAgeWarm = ref();
|
const loadingWareAgeWarm = ref(false);
|
const disabled_btnWareAgeWarm = ref(false);
|
const tableDataWareAgeWarm = ref<any>([]);
|
const queryParamsWareAgeWarm = ref<any>({});
|
const tableParamsWareAgeWarm = ref({
|
page: 1,
|
pageSize: 10,
|
total: 0,
|
});
|
|
const printWareAgeWarmTitle = ref("");
|
const editWareAgeWarmTitle = ref("");
|
|
// 改变高级查询的控件显示状态
|
const changeAdvanceQueryUIWareAgeWarm = () => {
|
showAdvanceQueryUIWareAgeWarm.value = !showAdvanceQueryUIWareAgeWarm.value;
|
}
|
|
// 查询库龄报表
|
const handleQueryWareAgeWarm = async () => {
|
loadingWareAgeWarm.value = true;
|
disabled_btnWareAgeWarm.value = true;
|
var res = await pageWareAgeWarm(Object.assign(queryParamsWareAgeWarm.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 () => {
|
queryParamsWareAgeWarm.value = {}
|
};
|
|
// 库龄报表列排序
|
const sortChangeWareAgeWarm = async (column: any) => {
|
queryParamsWareAgeWarm.value.field = column.prop;
|
queryParamsWareAgeWarm.value.order = column.order;
|
await handleQueryWareAgeWarm();
|
};
|
|
// 打开新增库龄报表页面
|
const openAddWareAgeWarm = () => {
|
editWareAgeWarmTitle.value = '添加库龄报表';
|
editDialogRefWareAgeWarm.value.openDialog(1,{});
|
};
|
|
// 打开打印库龄报表页面
|
const openPrintWareAgeWarm = async (row: any) => {
|
printWareAgeWarmTitle.value = '打印库龄报表';
|
}
|
|
// 打开编辑库龄报表页面
|
const openEditWareAgeWarm = (row: any) => {
|
editWareAgeWarmTitle.value = '编辑库龄报表';
|
editDialogRefWareAgeWarm.value.openDialog(2,row);
|
};
|
|
// 删除库龄报表
|
const delWareAgeWarm = (row: any) => {
|
ElMessageBox.confirm(`确定要删除吗?`, "提示", {
|
confirmButtonText: "确定",
|
cancelButtonText: "取消",
|
type: "warning",
|
})
|
.then(async () => {
|
loadingWareAgeWarm.value = true;
|
var ret = await deleteWareAgeWarm(row);
|
if(ret.data.type=="success"){
|
ElMessage.success("删除成功");
|
}
|
loadingWareAgeWarm.value = false;
|
handleQueryWareAgeWarm();
|
})
|
.catch(() => {});
|
};
|
|
// 改变库龄报表页面容量
|
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 pageWareAgeWarm(Object.assign(queryParamsWareAgeWarm.value, new_tableParamsWareAgeWarm));
|
if(res.data.type=="success"){
|
exportExcelWareAgeWarm(res.data.result?.items ?? []);
|
}
|
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%;
|
}
|
</style>
|