<template>
|
<div class="wmsStockQuan-container">
|
<el-card shadow="hover" :body-style="{ paddingBottom: '0' }">
|
<el-form :model="queryParamsWmsStockQuan" 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="queryParamsWmsStockQuan.searchKey" clearable="" placeholder="容器编号,跟踪码,物料编号,物料名称,供应商批次,批次,供应商编号,ERP单号,ERP库存地,ERP凭证"/>
|
|
</el-form-item>
|
</el-col>
|
<el-col :xs="24" :sm="12" :md="12" :lg="8" :xl="4" class="mb10" v-if="showAdvanceQueryUIWmsStockQuan">
|
<el-form-item label="容器编号">
|
<el-input v-model="queryParamsWmsStockQuan.containerCode" clearable="" placeholder="请输入容器编号"/>
|
|
</el-form-item>
|
</el-col>
|
|
<el-col :xs="24" :sm="12" :md="12" :lg="8" :xl="4" class="mb10" v-if="showAdvanceQueryUIWmsStockQuan">
|
<el-form-item label="跟踪码">
|
<el-input v-model="queryParamsWmsStockQuan.snCode" clearable="" placeholder="请输入跟踪码"/>
|
|
</el-form-item>
|
</el-col>
|
<el-col :xs="24" :sm="12" :md="12" :lg="8" :xl="4" class="mb10" v-if="showAdvanceQueryUIWmsStockQuan">
|
<el-form-item label="物料编号">
|
<el-input v-model="queryParamsWmsStockQuan.materialCode" clearable="" placeholder="请输入物料编号"/>
|
|
</el-form-item>
|
</el-col>
|
<el-col :xs="24" :sm="12" :md="12" :lg="8" :xl="4" class="mb10" v-if="showAdvanceQueryUIWmsStockQuan">
|
<el-form-item label="物料名称">
|
<el-input v-model="queryParamsWmsStockQuan.materialName" clearable="" placeholder="请输入物料名称"/>
|
|
</el-form-item>
|
</el-col>
|
<el-col :xs="24" :sm="12" :md="12" :lg="8" :xl="4" class="mb10" v-if="showAdvanceQueryUIWmsStockQuan">
|
<el-form-item label="库存状态">
|
<el-select clearable="" v-model="queryParamsWmsStockQuan.stockStatus" placeholder="请选择库存状态">
|
<el-option v-for="(item,index) in getEnumStockStatusData_Index" :key="index" :value="item.value" :label="`${item.describe}`" />
|
|
</el-select>
|
|
</el-form-item>
|
</el-col>
|
<el-col :xs="24" :sm="12" :md="12" :lg="8" :xl="4" class="mb10" v-if="showAdvanceQueryUIWmsStockQuan">
|
<el-form-item label="供应商批次">
|
<el-input v-model="queryParamsWmsStockQuan.supplierBatch" clearable="" placeholder="请输入供应商批次"/>
|
|
</el-form-item>
|
</el-col>
|
<el-col :xs="24" :sm="12" :md="12" :lg="8" :xl="4" class="mb10" v-if="showAdvanceQueryUIWmsStockQuan">
|
<el-form-item label="批次">
|
<el-input v-model="queryParamsWmsStockQuan.batch" clearable="" placeholder="请输入批次"/>
|
|
</el-form-item>
|
</el-col>
|
<el-col :xs="24" :sm="12" :md="12" :lg="8" :xl="4" class="mb10" v-if="showAdvanceQueryUIWmsStockQuan">
|
<el-form-item label="收货时间">
|
<el-date-picker placeholder="请选择收货时间" value-format="YYYY/MM/DD" type="daterange" v-model="queryParamsWmsStockQuan.recordInsertTimeRange" />
|
|
</el-form-item>
|
</el-col>
|
<el-col :xs="24" :sm="12" :md="12" :lg="8" :xl="4" class="mb10" v-if="showAdvanceQueryUIWmsStockQuan">
|
<el-form-item label="供应商编号">
|
<el-input v-model="queryParamsWmsStockQuan.supplierCode" clearable="" placeholder="请输入供应商编号"/>
|
|
</el-form-item>
|
</el-col>
|
|
<el-col :xs="24" :sm="12" :md="12" :lg="8" :xl="4" class="mb10" v-if="showAdvanceQueryUIWmsStockQuan">
|
<el-form-item label="ERP单号">
|
<el-input v-model="queryParamsWmsStockQuan.erpOrderNo" clearable="" placeholder="请输入ERP单号"/>
|
|
</el-form-item>
|
</el-col>
|
<el-col :xs="24" :sm="12" :md="12" :lg="8" :xl="4" class="mb10" v-if="showAdvanceQueryUIWmsStockQuan">
|
<el-form-item label="ERP库存地">
|
<el-input v-model="queryParamsWmsStockQuan.erpCode" clearable="" placeholder="请输入ERP库存地"/>
|
|
</el-form-item>
|
</el-col>
|
<el-col :xs="24" :sm="12" :md="12" :lg="8" :xl="4" class="mb10" v-if="showAdvanceQueryUIWmsStockQuan">
|
<el-form-item label="质检状态">
|
<el-select clearable="" v-model="queryParamsWmsStockQuan.qCStatus" placeholder="请选择质检状态">
|
<el-option v-for="(item,index) in getEnumQCStatusData_Index" :key="index" :value="item.value" :label="`${item.describe}`" />
|
|
</el-select>
|
|
</el-form-item>
|
</el-col>
|
<el-col :xs="24" :sm="12" :md="12" :lg="8" :xl="4" class="mb10" v-if="showAdvanceQueryUIWmsStockQuan">
|
<el-form-item label="ERP凭证">
|
<el-input v-model="queryParamsWmsStockQuan.erpVoucher" clearable="" placeholder="请输入ERP凭证"/>
|
|
</el-form-item>
|
</el-col>
|
<!-- <el-col :xs="24" :sm="12" :md="12" :lg="8" :xl="4" class="mb10" v-if="showAdvanceQueryUIWmsStockQuan">
|
<el-form-item label="操作时间">
|
<el-date-picker placeholder="请选择操作时间" value-format="YYYY/MM/DD" type="daterange" v-model="queryParamsWmsStockQuan.actionTimeRange" />
|
|
</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="handleQueryWmsStockQuan" v-auth="'wmsStockQuan:page'" :disabled="disabled_btnWmsStockQuan"> 查询 </el-button>
|
<el-button icon="ele-Refresh" @click="resetWmsStockQuan"> 重置 </el-button>
|
<el-button icon="ele-ZoomIn" @click="changeAdvanceQueryUIWmsStockQuan" v-if="!showAdvanceQueryUIWmsStockQuan" style="margin-left:5px;"> 高级查询 </el-button>
|
<el-button icon="ele-ZoomOut" @click="changeAdvanceQueryUIWmsStockQuan" v-if="showAdvanceQueryUIWmsStockQuan" style="margin-left:5px;"> 隐藏 </el-button>
|
<el-button type="primary" style="margin-left:5px;" icon="ele-Plus" @click="openAddWmsStockQuan" v-auth="'wmsStockQuan:add'"> 新增 </el-button>
|
<el-button type="primary" style="margin-left:5px;" icon="ele-Download" @click="handleExportExcelWmsStockQuan" v-auth="'wmsStockQuan:exportExcel'" > 导出 </el-button>
|
|
<el-button type="primary" style="margin-left:5px;" icon="ele-Printer" @click="openPrintWmsStockQuan" v-auth="'wmsStockQuan:exportExcel'" :disabled="checkRows.length==0" > 打印 </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">
|
<!-- show-summary :summary-method="getSummaries" -->
|
<el-table
|
ref="tableRefWmsStockQuan"
|
:data="tableDataWmsStockQuan"
|
style="width: 100%"
|
v-loading="loadingWmsStockQuan"
|
tooltip-effect="light"
|
row-key="id"
|
@sort-change="sortChangeWmsStockQuan"
|
@selection-change="handleSelectionChange"
|
border="">
|
<el-table-column align="center" width="60" type="selection" />
|
<el-table-column type="index" fixed="left" label="序号" width="55" align="center"/>
|
|
<el-table-column prop="placeCode" label="库位编码" show-overflow-tooltip="" />
|
<el-table-column prop="inTime" label="进入时间" width="80" :formatter="formatDate_T_Date" show-overflow-tooltip="" />
|
<el-table-column prop="upi" label="部件条码" show-overflow-tooltip="" />
|
<el-table-column prop="detailName" label="部件名称" show-overflow-tooltip="" />
|
<el-table-column prop="planNo" label="批次" show-overflow-tooltip="" />
|
<el-table-column prop="orderId" label="订单号" show-overflow-tooltip="" />
|
<el-table-column prop="packageCode" label="包装号" show-overflow-tooltip="" />
|
<el-table-column prop="length" label="长" show-overflow-tooltip="" />
|
<el-table-column prop="width" label="宽" show-overflow-tooltip="" />
|
<el-table-column prop="thk" label="厚" show-overflow-tooltip="" />
|
<el-table-column prop="stockStatus" label="库存状态" show-overflow-tooltip="" >
|
<template #default="scope">
|
<el-tag>{{ getEnumDesc(scope.row.stockStatus, getEnumStockStatusData_Index)}}</el-tag>
|
</template>
|
</el-table-column>
|
<el-table-column prop="stockStatusName" label="库存状态名称" show-overflow-tooltip="" />
|
<el-table-column prop="operReason" label="操作原因" show-overflow-tooltip="" />
|
<el-table-column prop="operUser" label="操作人" show-overflow-tooltip="" />
|
<el-table-column prop="operTime" label="操作时间" width="80" :formatter="formatDate_T_Date" show-overflow-tooltip="" />
|
<el-table-column prop="lockStatus" label="锁定状态" show-overflow-tooltip="" >
|
<template #default="scope">
|
<el-tag>{{ getEnumDesc(scope.row.lockStatus, getEnumLockStatusData_Index)}}</el-tag>
|
</template>
|
</el-table-column>
|
<el-table-column prop="lockReason" label="锁定原因" show-overflow-tooltip="" />
|
<el-table-column prop="lockUser" label="锁定人" show-overflow-tooltip="" />
|
<el-table-column prop="lockTime" label="锁定时间" width="80" :formatter="formatDate_T_Date" show-overflow-tooltip="" />
|
<el-table-column prop="remarks" label="备注" show-overflow-tooltip="" />
|
<el-table-column prop="createTime" label="创建时间" width="130" :formatter="formatDate_T_Time" 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>
|
<el-pagination
|
v-model:currentPage="tableParamsWmsStockQuan.page"
|
v-model:page-size="tableParamsWmsStockQuan.pageSize"
|
:total="tableParamsWmsStockQuan.total"
|
:page-sizes="[10, 20, 50, 100, 200, 500]"
|
small=""
|
background=""
|
@size-change="handleSizeChangeWmsStockQuan"
|
@current-change="handleCurrentChangeWmsStockQuan"
|
layout="total, sizes, prev, pager, next, jumper"
|
/>
|
<printDialogWmsStockQuan
|
ref="printDialogRefWmsStockQuan"
|
:title="printWmsStockQuanTitle"
|
@reloadTable="handleQueryWmsStockQuan" />
|
<editDialogWmsStockQuan
|
ref="editDialogRefWmsStockQuan"
|
:title="editWmsStockQuanTitle"
|
@reloadTable="handleQueryWmsStockQuan"
|
/>
|
</el-card>
|
</div>
|
</template>
|
|
<script lang="ts" setup="" name="wmsStockQuan">
|
import { ref,onMounted } 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 printDialogWmsStockQuan from '/@/views/system/print/component/hiprint/preview.vue'
|
import { pageWmsStockQuan, deleteWmsStockQuan,importExcelWmsStockQuan,downloadExcelTemplateWmsStockQuan } from '/@/api/main/ReportCenter/wmsStockQuan';
|
import { getAPI } from '/@/utils/axios-utils';
|
import { SysEnumApi } from '/@/api-services/api';
|
import commonFunction from '/@/utils/commonFunction';
|
import { addWmsRecordSncodePrint } from "/@/api/main/PrintCenter/wmsRecordSncodePrint";
|
|
const getEnumQCStatusData_Index = ref<any>([]);
|
const getEnumStockStatusData_Index = ref<any>([]);
|
|
const { getEnumDesc } = commonFunction();
|
|
/***************************************************[实时库存操作]开始***************************************************/
|
const showAdvanceQueryUIWmsStockQuan = ref(false);
|
const tableRefWmsStockQuan = ref(null);
|
const printDialogRefWmsStockQuan = ref();
|
const editDialogRefWmsStockQuan = ref();
|
const loadingWmsStockQuan = ref(false);
|
const disabled_btnWmsStockQuan = ref(false);
|
const tableDataWmsStockQuan = ref<any>([]);
|
const queryParamsWmsStockQuan = ref<any>({});
|
const tableParamsWmsStockQuan = ref({
|
page: 1,
|
pageSize: 10,
|
total: 0,
|
});
|
|
const printWmsStockQuanTitle = ref("");
|
const editWmsStockQuanTitle = ref("");
|
|
// 改变高级查询的控件显示状态
|
const changeAdvanceQueryUIWmsStockQuan = () => {
|
showAdvanceQueryUIWmsStockQuan.value = !showAdvanceQueryUIWmsStockQuan.value;
|
}
|
|
// 查询实时库存
|
const handleQueryWmsStockQuan = async () => {
|
loadingWmsStockQuan.value = true;
|
disabled_btnWmsStockQuan.value = true;
|
var res = await pageWmsStockQuan(Object.assign(queryParamsWmsStockQuan.value, tableParamsWmsStockQuan.value));
|
if(res.data.type=="success"){
|
tableDataWmsStockQuan.value = res.data.result?.items ?? [];
|
tableParamsWmsStockQuan.value.total = res.data.result?.total;
|
}
|
loadingWmsStockQuan.value = false;
|
disabled_btnWmsStockQuan.value = false;
|
};
|
|
// 重置实时库存查询
|
const resetWmsStockQuan = async () => {
|
queryParamsWmsStockQuan.value = {}
|
};
|
|
// 实时库存列排序
|
const sortChangeWmsStockQuan = async (column: any) => {
|
queryParamsWmsStockQuan.value.field = column.prop;
|
queryParamsWmsStockQuan.value.order = column.order;
|
await handleQueryWmsStockQuan();
|
};
|
|
// 打开新增实时库存页面
|
const openAddWmsStockQuan = () => {
|
editWmsStockQuanTitle.value = '添加实时库存';
|
editDialogRefWmsStockQuan.value.openDialog(1,{});
|
};
|
|
|
|
//选中的行
|
const checkRows = ref<{ id: number }[]>([]);
|
// 选择
|
const handleSelectionChange = (val: any) => {
|
checkRows.value = val;
|
};
|
// 打开打印实时库存页面
|
const openPrintWmsStockQuan = async (row: any) => {
|
|
// printWmsStockQuanTitle.value = '打印实时库存';
|
|
|
ElMessageBox.confirm('是否确认打印？', '提示', {
|
confirmButtonText: '确认',
|
cancelButtonText: '取消',
|
type: 'warning',
|
})
|
.then(async () => {
|
|
const handleArr: number[] = [];
|
checkRows.value.forEach((item) => {
|
// handleArr.push(item.id);
|
item.PrintSource = 1 //库存跟踪码打印
|
item.PrintType = 1
|
item.PrintSheetNum = 1
|
item.PrintNum = 1
|
item.PrintStatu = 1
|
item.IsAllowPrint = 1
|
|
});
|
|
|
const obj = { id: handleArr };
|
|
var res = await addWmsRecordSncodePrint(checkRows.value);
|
if (res.data && res.data.code == 200) {
|
ElMessage.success("添加成功");
|
}
|
|
})
|
.catch(() => {
|
ElMessage.info('已取消删除');
|
});
|
|
}
|
|
// 打开编辑实时库存页面
|
const openEditWmsStockQuan = (row: any) => {
|
editWmsStockQuanTitle.value = '编辑实时库存';
|
editDialogRefWmsStockQuan.value.openDialog(2,row);
|
};
|
|
// 删除实时库存
|
const delWmsStockQuan = (row: any) => {
|
ElMessageBox.confirm(`确定要删除吗?`, "提示", {
|
confirmButtonText: "确定",
|
cancelButtonText: "取消",
|
type: "warning",
|
})
|
.then(async () => {
|
loadingWmsStockQuan.value = true;
|
var ret = await deleteWmsStockQuan(row);
|
if(ret.data.type=="success"){
|
ElMessage.success("删除成功");
|
}
|
loadingWmsStockQuan.value = false;
|
handleQueryWmsStockQuan();
|
})
|
.catch(() => {});
|
};
|
|
// 改变实时库存页面容量
|
const handleSizeChangeWmsStockQuan = (val: number) => {
|
tableParamsWmsStockQuan.value.pageSize = val;
|
handleQueryWmsStockQuan();
|
};
|
|
// 改变实时库存页码序号
|
const handleCurrentChangeWmsStockQuan = (val: number) => {
|
tableParamsWmsStockQuan.value.page = val;
|
handleQueryWmsStockQuan();
|
};
|
|
/***************************************************[实时库存操作]结束***************************************************/
|
/***************************************************[实时库存导出]开始***************************************************/
|
//定义当前页面的方法组
|
const functionMapWmsStockQuan = {
|
getEnumStockStatusData_Index,
|
getEnumQCStatusData_Index,
|
formatDate_T_Date,
|
formatDate_T_Time
|
};
|
//点击导出按钮
|
const handleExportExcelWmsStockQuan = async (formData:Blob) => {
|
loadingWmsStockQuan.value = true;
|
disabled_btnWmsStockQuan.value = true;
|
var new_tableParamsWmsStockQuan=JSON.parse(JSON.stringify(tableParamsWmsStockQuan.value));
|
new_tableParamsWmsStockQuan.page = 1;
|
new_tableParamsWmsStockQuan.pageSize = 100000;
|
var res = await pageWmsStockQuan(Object.assign(queryParamsWmsStockQuan.value, new_tableParamsWmsStockQuan));
|
if(res.data.type=="success"){
|
exportExcelWmsStockQuan(res.data.result?.items ?? []);
|
}
|
loadingWmsStockQuan.value = false;
|
disabled_btnWmsStockQuan.value = false;
|
};
|
//导出
|
const exportExcelWmsStockQuan = async (exportDataList:Array) => {
|
exportPageExcel(exportDataList, tableRefWmsStockQuan,"实时库存",functionMapWmsStockQuan);
|
};
|
/***************************************************[实时库存导出]结束***************************************************/
|
// 实时库存页面加载时
|
|
const getEnumLockStatusData_Index = ref<any>([]);
|
onMounted(async () => {
|
getEnumStockStatusData_Index.value = (await getAPI(SysEnumApi).apiSysEnumEnumDataListGet('StockStatusEnum')).data.result ?? [];
|
getEnumLockStatusData_Index.value = (await getAPI(SysEnumApi).apiSysEnumEnumDataListGet('LockStatusEnum')).data.result ?? [];
|
});
|
|
handleQueryWmsStockQuan();
|
|
|
|
|
|
//表格汇总
|
const getSummaries = (param: any) => {
|
const { columns, data } = param;
|
const sums:any = [];
|
columns.forEach((column, index) => {
|
if (index === 0) {
|
sums[index] = '合计';
|
return;
|
}
|
//debugger
|
if (column.property != 'quantity' && column.property != 'scrapQuantity'
|
&& column.property != 'useNumber'
|
&& column.property != 'gridNumber'
|
) {
|
sums[index] = '';
|
return "";
|
}
|
const values = data.map(item => Number(item[column.property]));
|
if (!values.every(value => isNaN(value))) {
|
sums[index] = Number(values.reduce((prev, curr) => {
|
const value = Number(curr);
|
if (!isNaN(value)) {
|
return prev + curr;
|
} else {
|
return prev;
|
}
|
}, 0)).toFixed(3);
|
sums[index] += '';
|
} else {
|
sums[index] = '';//N/A
|
}
|
});
|
|
return sums;
|
}
|
|
|
|
</script>
|
<style scoped>
|
:deep(.el-input),
|
:deep(.el-select),
|
:deep(.el-input-number) {
|
width: 100%;
|
}
|
</style>
|
