| | |
| | | <pagination v-show="total > 0" :total="total" layout="total, sizes, prev, pager, next, jumper" |
| | | :page="page.current" :limit="page.size" @pagination="paginationChange" /> |
| | | </div> |
| | | |
| | | <el-dialog v-model="dialogFormVisible" :title="operationType === 'add' ? '新增入库' : '编辑入库'" width="70%" |
| | | @close="closeDia"> |
| | | <el-form :model="form" label-width="140px" label-position="top" :rules="rules" ref="formRef"> |
| | | <el-form-item label="采购订单号" prop="salesContractNo"> |
| | | <el-input v-model="form.salesContractNo" placeholder="请输入" clearable /> |
| | | <el-input |
| | | v-model="form.purchaseContractNumber" |
| | | placeholder="请输入合同号" |
| | | clearable |
| | | @change="searchByContractNo" |
| | | :disabled="operationType === 'edit'" |
| | | > |
| | | <template #append> |
| | | <el-button |
| | | icon="Search" |
| | | @click="searchByContractNo" |
| | | :loading="loadingProducts" |
| | | /> |
| | | </template> |
| | | </el-input> |
| | | </el-form-item> |
| | | <el-table |
| | | :data="productData" |
| | | :data="productList" |
| | | border |
| | | @selection-change="productSelected" |
| | | v-loading="loadingProducts" |
| | | @selection-change="handleSelectionChange" |
| | | > |
| | | <el-table-column align="center" type="selection" width="55" /> |
| | | <el-table-column |
| | |
| | | <el-table-column label="产品大类" prop="productCategory" /> |
| | | <el-table-column label="规格型号" prop="specificationModel" /> |
| | | <el-table-column label="单位" prop="unit" width="70" /> |
| | | <el-table-column label="供应商" prop="supplierName" width="100" /> |
| | | <el-table-column label="采购数量" prop="quantity" width="100" /> |
| | | <el-table-column label="待入库数量" prop="quantity0" width="100" /> |
| | | <el-table-column label="本次入库数量" prop="quantityStock" width="120"> |
| | |
| | | import { ref } from 'vue' |
| | | import { ElMessageBox } from "element-plus"; |
| | | import useUserStore from '@/store/modules/user' |
| | | import { userListNoPage } from "@/api/system/user.js"; |
| | | import { |
| | | getStockInPage, |
| | | updateStockIn, |
| | | addSutockIn, |
| | | delStockIn, |
| | | exportStockIn |
| | | selectProductRecordListByPuechaserId |
| | | } from "@/api/inventoryManagement/stockIn.js"; |
| | | import {listSupplier} from "@/api/basicData/supplierManageFile.js"; |
| | | import {modelListPage, productTreeList} from "@/api/basicData/product.js"; |
| | | |
| | | const userStore = useUserStore() |
| | | const { proxy } = getCurrentInstance() |
| | | |
| | | const tableData = ref([]) |
| | | const selectedRows = ref([]) |
| | | const userList = ref([]) |
| | | const supplierLists = ref([]) |
| | | const productList = ref([]); |
| | | const productModelList = ref([]); |
| | | const purchaseRecords = ref([]); |
| | | const loadingProducts = ref(false); |
| | | |
| | | |
| | | const loading = ref(false); |
| | | const tableLoading = ref(false) |
| | | |
| | | const page = reactive({ |
| | | current: 1, |
| | | size: 100, |
| | |
| | | const total = ref(0) |
| | | |
| | | // 用户信息表单弹框数据 |
| | | const operationType = ref('') |
| | | const dialogFormVisible = ref(false) |
| | | const operationType = ref('')// 操作类型: 'add' 或 'edit' |
| | | const dialogFormVisible = ref(false)// 弹框显示状态 |
| | | const productList = ref([]);// 产品列表数据 |
| | | const loadingProducts = ref(false);// 产品加载状态 |
| | | const productSelectedRows = ref([]) // 产品表格选中行 |
| | | const data = reactive({ |
| | | searchForm: { |
| | | supplierName: '', |
| | | }, |
| | | form: { |
| | | supplierId: null, |
| | | supplierName: '', |
| | | productId: null, |
| | | productName: '', |
| | | userId: userStore.userId, |
| | | nickName: '', |
| | | model: '', |
| | | productModelId: null, |
| | | unit: '', |
| | | productrecordId: null, |
| | | taxInclusiveUnitPrice: '', |
| | | taxInclusiveTotalPrice: '', |
| | | taxRate: '', |
| | | taxExclusiveTotalPrice: '', |
| | | inboundTime: '', |
| | | inboundBatch: '', |
| | | inboundQuantity: '' |
| | | id: null, |
| | | purchaseContractNumber: '', // 采购订单号 |
| | | supplierId: null, // 供应商ID |
| | | supplierName: '', // 供应商名称 |
| | | inboundTime: '', // 入库时间 |
| | | inboundBatch: '', // 入库批次 |
| | | recorderId: userStore.userId, // 录入人ID |
| | | recorderName: userStore.name, // 录入人姓名 |
| | | entryDate: getCurrentDate(), // 录入日期 |
| | | remark: '', // 备注 |
| | | }, |
| | | rules: { |
| | | productId: [ |
| | | { required: true, message: "请选择产品大类", trigger: "change" } |
| | | ], |
| | | productModelId: [ |
| | | { required: true, message: "请选择规格型号", trigger: "change" } |
| | | ], |
| | | supplierId: [ |
| | | { required: true, message: "请选择供应商", trigger: "change" } |
| | | ], |
| | | inboundQuantity: [ |
| | | { required: true, message: "请输入入库数量", trigger: "blur" } |
| | | ], |
| | | userId: [ |
| | | { required: true, message: "请选择入库人", trigger: "change" } |
| | | ], |
| | | unit: [{ required: true, message: "请输入", trigger: "blur" }], |
| | | inboundTime: [{ required: true, message: "请选择", trigger: "change" }], |
| | | inboundBatch: [{ required: true, message: "请输入", trigger: "blur" }], |
| | | taxInclusiveUnitPrice: [{ required: true, message: "请输入", trigger: "blur" }], |
| | | taxRate: [{ required: true, message: "请输入", trigger: "blur" }], |
| | | purchaseContractNumber: [{ required: true, message: "请输入采购合同号", trigger: "blur" }], |
| | | supplierId: [{ required: true, message: "请选择供应商", trigger: "change" }], |
| | | inboundTime: [{ required: true, message: "请选择入库时间", trigger: "change" }], |
| | | inboundBatch: [{ required: true, message: "请输入入库批次", trigger: "blur" }] |
| | | } |
| | | }) |
| | | const { searchForm, form, rules } = toRefs(data) |
| | |
| | | page.current = 1 |
| | | getList() |
| | | } |
| | | |
| | | const paginationChange = (obj) => { |
| | | page.current = obj.page; |
| | | page.size = obj.limit; |
| | | getList() |
| | | } |
| | | |
| | | const getList = () => { |
| | | tableLoading.value = true |
| | | getStockInPage({ ...searchForm.value, ...page }).then(res => { |
| | |
| | | }) |
| | | } |
| | | |
| | | // 正确的产品列表加载方法 |
| | | const loadProductList = async () => { |
| | | loadingProducts.value = true; |
| | | |
| | | // 调用selectProductRecordListByPuechaserId这个方法根据合同查询到id,再调用getProductRecordByhetong这个方法根据id查询到产品订单记录 |
| | | // 新增根据合同号查询产品记录的方法 |
| | | const searchByContractNo = async () => |
| | | { |
| | | if (!form.value.purchaseContractNumber) { |
| | | proxy.$modal.msgWarning('请输入合同号') |
| | | return |
| | | } |
| | | try { |
| | | const res = await productTreeList(); |
| | | |
| | | // 扁平化处理产品树 |
| | | const flattenProducts = (nodes, parentId = null) => { |
| | | let result = []; |
| | | nodes.forEach(node => { |
| | | // 只添加有id和label的节点 |
| | | if (node.id && node.label) { |
| | | result.push({ |
| | | id: node.id, |
| | | productName: node.label, |
| | | parentId: parentId |
| | | }); |
| | | } |
| | | // 递归处理子节点 |
| | | if (node.children) { |
| | | result = result.concat(flattenProducts(node.children, node.id)); |
| | | } |
| | | }); |
| | | return result; |
| | | }; |
| | | |
| | | productList.value = flattenProducts(res.data); |
| | | console.log('加载的产品列表:', productList.value); |
| | | loadingProducts.value = true |
| | | // 根据合同查询产品记录 |
| | | const productRes = await selectProductRecordListByPuechaserId({ |
| | | purchaseContractNumber: form.value.purchaseContractNumber |
| | | }); |
| | | console.log('productRes:', productRes) |
| | | if (!productRes.data || productRes.data.length === 0) { |
| | | proxy.$modal.msgWarning('该合同下没有产品记录') |
| | | productList.value = []; |
| | | return |
| | | } |
| | | // 处理产品数据,添加本次入库数量字段 |
| | | productList.value = productRes.data.map(item => ({ |
| | | ...item, |
| | | quantityStock: 0 // 初始化本次入库数量为0 |
| | | })) |
| | | } catch (error) { |
| | | console.error('加载产品列表失败:', error); |
| | | proxy.$modal.msgError('加载产品列表失败'); |
| | | console.error('查询产品记录失败:', error) |
| | | proxy.$modal.msgError('查询产品记录失败') |
| | | productList.value = []; |
| | | } finally { |
| | | loadingProducts.value = false; |
| | | loadingProducts.value = false |
| | | } |
| | | return null; // 没有找到节点,返回null |
| | | }; |
| | | } |
| | | |
| | | // 表格选择数据 |
| | | // const handleSelectionChange = (selection) => { |
| | | |
| | | // 加载规格型号列表 |
| | | const loadProductModels = async (productId) => { |
| | | if (!productId) { |
| | | productModelList.value = []; |
| | | return; |
| | | } |
| | | |
| | | try { |
| | | const res = await modelListPage({ |
| | | id: productId, |
| | | current: 1, |
| | | size: 100 |
| | | }); |
| | | |
| | | productModelList.value = res.data.records.map(item => ({ |
| | | id: item.id, |
| | | model: item.model, |
| | | unit: item.unit |
| | | })); |
| | | |
| | | } catch (error) { |
| | | console.error('加载规格型号失败:', error); |
| | | proxy.$modal.msgError('加载规格型号失败'); |
| | | } |
| | | }; |
| | | |
| | | // 产品选择变化 |
| | | const handleProductChange = (productId) => { |
| | | form.value.productModelId = null |
| | | form.value.productrecordId = null |
| | | resetPurchaseFields() |
| | | if (productId) { |
| | | loadProductModels(productId) |
| | | } else { |
| | | productModelList.value = [] |
| | | } |
| | | } |
| | | |
| | | // 规格型号选择变化 |
| | | const handleModelChange = async (modelId) => { |
| | | if (!form.value.productId || !modelId) return |
| | | |
| | | try { |
| | | // 根据产品ID和型号ID查询采购记录 |
| | | const res = await getPurchaseRecords({ |
| | | productId: form.value.productId, |
| | | productModelId: form.value.productModelId, |
| | | type: 2 // 假设2表示已批准的采购记录 |
| | | }) |
| | | |
| | | purchaseRecords.value = res.data.records |
| | | |
| | | if (purchaseRecords.value.length > 0) { |
| | | // 默认取第一条采购记录 |
| | | const record = purchaseRecords.value[0] |
| | | fillFormFromPurchaseRecord(record) |
| | | } |
| | | } catch (error) { |
| | | console.error('查询采购记录失败:', error) |
| | | proxy.$modal.msgError('查询采购记录失败') |
| | | } |
| | | } |
| | | |
| | | // 从采购记录填充表单 |
| | | const fillFormFromPurchaseRecord = (record) => { |
| | | form.value.productrecordId = record.id |
| | | form.value.taxInclusiveUnitPrice = record.taxInclusiveUnitPrice |
| | | form.value.taxRate = record.taxRate |
| | | form.value.taxInclusiveTotalPrice = record.taxInclusiveTotalPrice |
| | | form.value.taxExclusiveTotalPrice = record.taxExclusiveTotalPrice |
| | | } |
| | | |
| | | // 重置采购相关字段 |
| | | const resetPurchaseFields = () => { |
| | | form.value.productrecordId = null |
| | | form.value.unit = '' |
| | | form.value.taxInclusiveUnitPrice = null |
| | | form.value.taxRate = null |
| | | form.value.taxInclusiveTotalPrice = null |
| | | form.value.taxExclusiveTotalPrice = null |
| | | } |
| | | |
| | | const loadUserList = async () => { |
| | | try { |
| | | const res = await userListNoPage() |
| | | userList.value = res.data |
| | | } catch (error) { |
| | | console.error('加载用户列表失败:', error) |
| | | } |
| | | } |
| | | |
| | | const loadSupplierList = async () => { |
| | | try { |
| | | const res = await listSupplier() |
| | | supplierLists.value = res.data.records |
| | | } catch (error) { |
| | | console.error('加载供应商列表失败:', error) |
| | | } |
| | | } |
| | | |
| | | // 打开弹框 |
| | | const openForm = async (type, row) => { |
| | | operationType.value = type |
| | | dialogFormVisible.value = true |
| | | // 加载必要数据 |
| | | await Promise.all([ |
| | | loadUserList(), |
| | | loadSupplierList(), |
| | | loadProductList() |
| | | ]) |
| | | |
| | | if (type === 'add') { |
| | | // 新增时重置表单 |
| | | // 新增时初始化表单 |
| | | form.value = { |
| | | userId: userStore.userId // 设置默认入库人为当前用户 |
| | | id: null, |
| | | purchaseContractNumber: '', |
| | | supplierId: null, |
| | | supplierName: '', |
| | | inboundTime: '', |
| | | inboundBatch: '', |
| | | recorderId: userStore.userId, |
| | | recorderName: userStore.name, |
| | | entryDate: getCurrentDate(), |
| | | remark: '' |
| | | } |
| | | productList.value = [] // 清空产品列表 |
| | | } else { |
| | | // 编辑时填充表单数据 |
| | | form.value = { |
| | | ...row, |
| | | supplierId: row.supplierId, |
| | | productId: row.productId, |
| | | productModelId: row.productModelId, |
| | | userId: row.userId |
| | | } |
| | | if (row.productId) { |
| | | await loadProductModels(row.productId) |
| | | form.value = JSON.parse(JSON.stringify(row)) |
| | | try { |
| | | loadingProducts.value = true |
| | | // 根据合同号加载对应的产品列表(假设 getProductByContract 是可用接口) |
| | | const res = await getProductRecordByhetong(form.value.purchaseContractNumber) |
| | | productList.value = res.data.map(item => ({ |
| | | ...item, |
| | | quantityStock: item.quantityStock || 0 // 如果已有入库数量则保留 |
| | | })) |
| | | } catch (error) { |
| | | proxy.$modal.msgError('加载产品失败') |
| | | productList.value = [] |
| | | } finally { |
| | | loadingProducts.value = false |
| | | } |
| | | } |
| | | } |
| | | |
| | | |
| | | // 提交表单 |
| | | const submitForm = async () => { |
| | | try { |
| | | await proxy.$refs.formRef.validate() |
| | | |
| | | if (!form.value.productrecordId) { |
| | | proxy.$modal.msgError('请选择产品大类和规格型号以获取采购记录') |
| | | // 验证至少选择了一个产品 |
| | | if (selectedRows.value.length === 0) { |
| | | proxy.$modal.msgError('请先查询并选择产品') |
| | | return |
| | | } |
| | | |
| | | const submitData = { |
| | | productrecordId: form.value.productrecordId, |
| | | supplierId: form.value.supplierId, |
| | | inboundQuantity: form.value.inboundQuantity, |
| | | userId: form.value.userId, |
| | | // 验证入库数量 |
| | | const invalidProducts = selectedRows.value.filter( |
| | | product => product.quantityStock <= 0 || product.quantityStock > product.quantity0 |
| | | ) |
| | | |
| | | if (invalidProducts.length > 0) { |
| | | proxy.$modal.msgError('请为所有产品输入有效的入库数量') |
| | | return |
| | | } |
| | | |
| | | const apiMethod = operationType.value === 'add' ? addSutockIn : updateStockIn |
| | | await apiMethod(submitData) |
| | | // 准备提交数据 |
| | | // 准备提交数据 - 修改为后端需要的格式 |
| | | const stockInData = { |
| | | // 入库单基本信息 |
| | | ...form.value, |
| | | inboundTime: formatDateTime(form.value.inboundTime), |
| | | nickName: userStore.nickName,// 使用新格式化函数 |
| | | details: selectedRows.value.map(product => ({ |
| | | id: product.id, |
| | | inboundQuantity: Number(product.quantityStock) |
| | | })), |
| | | }; |
| | | console.log('准备提交的数据:', JSON.parse(JSON.stringify(stockInData))); |
| | | // 调用API |
| | | loading.value = true |
| | | await addSutockIn(stockInData) |
| | | |
| | | proxy.$modal.msgSuccess(operationType.value === 'add' ? '新增成功' : '修改成功') |
| | | proxy.$modal.msgSuccess('新增入库成功') |
| | | closeDia() |
| | | getList() |
| | | getList() // 刷新列表 |
| | | |
| | | } catch (error) { |
| | | console.error('提交失败:', error) |
| | | if (!error.errors) { |
| | | proxy.$modal.msgError('操作失败,请重试') |
| | | } |
| | | } finally { |
| | | loading.value = false |
| | | } |
| | | } |
| | | |
| | | // 关闭弹框 |
| | | const closeDia = () => { |
| | | proxy.$refs.formRef.resetFields() |
| | | dialogFormVisible.value = false |
| | | |
| | | } |
| | | // 表格选择数据 |
| | | const handleSelectionChange = (selection) => { |
| | |
| | | selectedRows.value = selection.filter(item => item.id); |
| | | console.log('selection', selectedRows.value) |
| | | } |
| | | |
| | | const expandedRowKeys = ref([]) |
| | | |
| | | // 主表合计方法 |
| | |
| | | // 导出 |
| | | const handleOut = () => { |
| | | ElMessageBox.confirm( |
| | | '选中的内容将被导出,是否确认导出?', |
| | | '是否确认导出?', |
| | | '导出', { |
| | | confirmButtonText: '确认', |
| | | cancelButtonText: '取消', |
| | |
| | | } |
| | | |
| | | // 获取当前日期并格式化为 YYYY-MM-DD |
| | | function getCurrentDate() { |
| | | const today = new Date(); |
| | | const year = today.getFullYear(); |
| | | const month = String(today.getMonth() + 1).padStart(2, '0'); // 月份从0开始 |
| | | const day = String(today.getDate()).padStart(2, '0'); |
| | | return `${year}-${month}-${day}`; |
| | | // 修改为更通用的日期时间格式化函数 |
| | | function formatDateTime(date = new Date(), includeTime = true) { |
| | | const d = new Date(date); |
| | | const year = d.getFullYear(); |
| | | const month = String(d.getMonth() + 1).padStart(2, '0'); |
| | | const day = String(d.getDate()).padStart(2, '0'); |
| | | |
| | | if (!includeTime) { |
| | | return `${year}-${month}-${day}`; // 保持原有 getCurrentDate 功能 |
| | | } |
| | | |
| | | const productSelectedRows = ref([]) |
| | | const productSelected = (selectedRows) => { |
| | | productSelectedRows.value = selectedRows; |
| | | }; |
| | | // 新增时间部分格式化 |
| | | const hours = String(d.getHours()).padStart(2, '0'); |
| | | const minutes = String(d.getMinutes()).padStart(2, '0'); |
| | | const seconds = String(d.getSeconds()).padStart(2, '0'); |
| | | |
| | | const formattedNumber = (row, column, cellValue) => { |
| | | return parseFloat(cellValue).toFixed(2); |
| | | }; |
| | | return `${year}-${month}-${day} ${hours}:${minutes}:${seconds}`; |
| | | } |
| | | |
| | | // 保持原有 getCurrentDate 的兼容性 |
| | | function getCurrentDate() { |
| | | return formatDateTime(new Date(), false); |
| | | } |
| | | |
| | | |
| | | |
| | | |
| | | onMounted(() => { |
| | | getList() |
| | | }) |
| | | } |
| | | </script> |
| | | |
| | | <style scoped lang="scss"></style> |