<template>
|
<div class="wareAgeWarm-container">
|
<el-tabs v-model="activeName" class="demo-tabs" @tab-click="handleClick">
|
<el-tab-pane label="仓库汇总" name="first">
|
<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="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="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('first')" 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-Download" @click="handleExportExcelWareAgeWarm" > 导出 </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" row-key="id" @sort-change="sortChangeWareAgeWarm" border="">
|
<el-table-column type="index" label="序号" width="55" align="center" />
|
|
<el-table-column label="物料编号" prop="materialCode" width="150" show-overflow-tooltip>
|
<template #default="scope">
|
<span class="under_line" @click="openDrawertwo(1, scope.row)">
|
{{ scope.row.materialCode }}
|
</span>
|
</template>
|
</el-table-column>
|
|
<el-table-column prop="materialName" label="物料名称" show-overflow-tooltip="" />
|
<el-table-column prop="materialUnit" label="库存单位" show-overflow-tooltip="" />
|
<el-table-column prop="quantity" label="总库存" show-overflow-tooltip="" />
|
<el-table-column prop="useQty" label="可用库存" show-overflow-tooltip="" />
|
<el-table-column prop="predetermineLockedQty" label="预配数" show-overflow-tooltip="" />
|
<el-table-column prop="otherLockQty" label="其他不可用库存" 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('first')" />
|
<editDialogWareAgeWarm ref="editDialogRefWareAgeWarm" :title="editWareAgeWarmTitle"
|
@reloadTable="handleQueryWareAgeWarm('first')" />
|
</el-card>
|
|
</el-tab-pane>
|
<el-tab-pane label="库区汇总" name="second">
|
<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="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="所在库区" prop="areaName">
|
<el-select v-model="queryParamsWareAgeWarm.areaName" placeholder="请选择所在库区">
|
<el-option v-for="(item,index) in arr1" :key="index" :value="item.value" :label="`[${item.code}] ${item.value}`"></el-option>
|
</el-select>
|
</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('second')" 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-Download" @click="handleExportExcelWareAgeWarm" > 导出 </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" row-key="id" @sort-change="sortChangeWareAgeWarm" border="">
|
<el-table-column type="index" label="序号" width="55" align="center" />
|
<el-table-column label="物料编号" prop="materialCode" width="150" show-overflow-tooltip>
|
<template #default="scope">
|
<span class="under_line" @click="openDrawer(1, scope.row)">
|
{{ scope.row.materialCode }}
|
</span>
|
</template>
|
</el-table-column>
|
<el-table-column prop="materialName" 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="useQty" label="可用库存" show-overflow-tooltip="" />
|
<el-table-column prop="lockQty" 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" />
|
<printDialogWareAgeWarm ref="printDialogRefWareAgeWarm" :title="printWareAgeWarmTitle"
|
@reloadTable="handleQueryWareAgeWarm('second')" />
|
<editDialogWareAgeWarm ref="editDialogRefWareAgeWarm" :title="editWareAgeWarmTitle"
|
@reloadTable="handleQueryWareAgeWarm('second')" />
|
</el-card>
|
|
</el-tab-pane>
|
</el-tabs>
|
<!-- 所有弹框 ：新增 编辑 详情 -->
|
<open-allprop titleAuthor="1" hexiao="0" ref="propALlProp" @getTabelData="handleQueryWareAgeWarm('first')"></open-allprop>
|
<open-allproptwo ref="propALlProptwo" @getTabelData="handleQueryWareAgeWarm('second')"></open-allproptwo>
|
</div>
|
</template>
|
|
<script lang="ts" setup="" name="wareAgeWarm">
|
import { ref, onMounted, getCurrentInstance,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 type { TabsPaneContext } from 'element-plus'
|
|
const activeName = ref('first')
|
|
const handleClick = (tab: TabsPaneContext, event: Event) => {
|
// console.log(tab, event)
|
tableDataWareAgeWarm.value = []
|
handleQueryWareAgeWarm(tab.props.name);
|
}
|
|
import printDialogWareAgeWarm from '/@/views/system/print/component/hiprint/preview.vue'
|
import { pageStockGroup , v_WmsStockQuanAreaGroup} from '/@/api/main/WareAgeWarm/wareAgeWarm';
|
import { handleSlectDataWmsArea } from '/@/utils/selectData';
|
|
import OpenAllprop from "./component/openAllprop.vue";
|
import openAllproptwo from "./component/openAllproptwo.vue";
|
import { ExcellTableDataExport } from "/@/hooks/exportTableDataExcell";
|
const { proxy }: any = getCurrentInstance(); // 访问实例上下文 proxy同时支持开发 线上环境
|
|
// ---------------详情-----------------------
|
const openDrawer = (type: number, item?: any) => {
|
proxy.$refs['propALlProp'].openDrawer(type, item, {});
|
}
|
const openDrawertwo = (type: number, item?: any) => {
|
console.log('type2',type)
|
console.log('item2',item)
|
proxy.$refs['propALlProptwo'].openDrawer(type, item, {});
|
}
|
// ---------------end详情-----------------------
|
|
/***************************************************[库龄报表操作]开始***************************************************/
|
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 (val:any) => {
|
loadingWareAgeWarm.value = true;
|
disabled_btnWareAgeWarm.value = true;
|
if(val=='first'){
|
var res = await pageStockGroup(Object.assign(queryParamsWareAgeWarm.value, tableParamsWareAgeWarm.value));
|
if (res.data.type == "success") {
|
tableDataWareAgeWarm.value = res.data.result?.items ?? [];
|
tableParamsWareAgeWarm.value.total = res.data.result?.total;
|
}
|
}else{
|
var res = await v_WmsStockQuanAreaGroup(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('first');
|
};
|
|
// 打开新增库龄报表页面
|
const openAddWareAgeWarm = () => {
|
editWareAgeWarmTitle.value = '添加库龄报表';
|
editDialogRefWareAgeWarm.value.openDialog(1, {});
|
};
|
|
// 打开打印库龄报表页面
|
const openPrintWareAgeWarm = async (row: any) => {
|
printWareAgeWarmTitle.value = '打印库龄报表';
|
}
|
|
|
// 改变库龄报表页面容量
|
const handleSizeChangeWareAgeWarm = (val: number) => {
|
tableParamsWareAgeWarm.value.pageSize = val;
|
handleQueryWareAgeWarm('first');
|
};
|
|
// 改变库龄报表页码序号
|
const handleCurrentChangeWareAgeWarm = (val: number) => {
|
tableParamsWareAgeWarm.value.page = val;
|
handleQueryWareAgeWarm('first');
|
};
|
|
/***************************************************[库龄报表操作]结束***************************************************/
|
/***************************************************[库存汇总导出]开始***************************************************/
|
//定义当前页面的方法组
|
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;
|
if(activeName.value=='first'){
|
var res = await pageStockGroup(Object.assign(queryParamsWareAgeWarm.value, new_tableParamsWareAgeWarm));
|
if(res.data.type=="success"){
|
let array = res.data.result?.items ?? []
|
exportExcelWareAgeWarm(array);
|
}
|
}else{
|
var res = await v_WmsStockQuanAreaGroup(Object.assign(queryParamsWareAgeWarm.value, new_tableParamsWareAgeWarm));
|
if(res.data.type=="success"){
|
let array = res.data.result?.items ?? []
|
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('first');
|
</script>
|
<style scoped>
|
:deep(.el-input),
|
:deep(.el-select),
|
:deep(.el-input-number) {
|
width: 100%;
|
}
|
|
.under_line {
|
color: #F18201;
|
text-decoration: underline;
|
cursor: pointer;
|
}
|
.demo-tabs{
|
background-color: #fff;
|
padding-left: 10px;
|
}
|
/* :deep(.demo-tabs > .el-tabs__content) {
|
padding: 32px;
|
color: #6b778c;
|
font-size: 32px;
|
font-weight: 600;
|
} */
|
</style>
|
