| | |
| | | <div class="search_form"> |
| | | <div> |
| | | <span class="search_title">供应商名称:</span> |
| | | <el-input v-model="searchForm.customerName" style="width: 240px" placeholder="请输入" @change="handleQuery" |
| | | <el-input v-model="searchForm.supplierName" style="width: 240px" placeholder="请输入" @change="handleQuery" |
| | | clearable prefix-icon="Search" /> |
| | | <el-button type="primary" @click="handleQuery" style="margin-left: 10px">搜索</el-button> |
| | | </div> |
| | |
| | | :summary-method="summarizeMainTable" height="calc(100vh - 18.5em)"> |
| | | <el-table-column align="center" type="selection" width="55" /> |
| | | <el-table-column align="center" label="序号" type="index" width="60" /> |
| | | <el-table-column label="入库时间" prop="salesContractNo" width="100" show-overflow-tooltip /> |
| | | <el-table-column label="入库批次" prop="customerContractNo" width="160" show-overflow-tooltip /> |
| | | <el-table-column label="供应商名称" prop="customerName" width="160" show-overflow-tooltip /> |
| | | <el-table-column label="产品大类" prop="salesman" width="100" show-overflow-tooltip /> |
| | | <el-table-column label="规格型号" prop="projectName" width="160" show-overflow-tooltip /> |
| | | <el-table-column label="单位" prop="contractAmount" width="70" show-overflow-tooltip /> |
| | | <el-table-column label="入库数量" prop="entryPersonName" width="90" show-overflow-tooltip /> |
| | | <el-table-column label="含税单价(元)" prop="entryDate" width="100" show-overflow-tooltip /> |
| | | <el-table-column label="含税总价(元)" prop="executionDate" width="100" show-overflow-tooltip /> |
| | | <el-table-column label="税率(%)" prop="executionDate" width="80" show-overflow-tooltip /> |
| | | <el-table-column label="不含税总价(元)" prop="executionDate" width="180" show-overflow-tooltip /> |
| | | <el-table-column label="入库人" prop="executionDate" width="80" show-overflow-tooltip /> |
| | | <el-table-column label="入库时间" prop="inboundTime" width="100" show-overflow-tooltip /> |
| | | <el-table-column label="入库批次" prop="inboundBatch" width="160" show-overflow-tooltip /> |
| | | <el-table-column label="供应商名称" prop="supplierName" width="160" show-overflow-tooltip /> |
| | | <el-table-column label="产品大类" prop="productName" width="100" show-overflow-tooltip /> |
| | | <el-table-column label="规格型号" prop="model" width="160" show-overflow-tooltip /> |
| | | <el-table-column label="单位" prop="unit" width="70" show-overflow-tooltip /> |
| | | <el-table-column label="入库数量" prop="inboundQuantity" width="90" show-overflow-tooltip /> |
| | | <el-table-column label="含税单价" prop="taxInclusiveUnitPrice" width="100" show-overflow-tooltip /> |
| | | <el-table-column label="含税总价" prop="taxInclusiveTotalPrice" width="100" show-overflow-tooltip /> |
| | | <el-table-column label="税率(%)" prop="taxRate" width="80" show-overflow-tooltip /> |
| | | <el-table-column label="不含税总价" prop="taxExclusiveTotalPrice" width="100" show-overflow-tooltip /> |
| | | <el-table-column label="入库人" prop="nickName" width="80" show-overflow-tooltip /> |
| | | <el-table-column fixed="right" label="操作" min-width="60" align="center"> |
| | | <template #default="scope"> |
| | | <el-button link type="primary" size="small" @click="openForm('edit', scope.row);">编辑</el-button> |
| | |
| | | <el-table-column label="规格型号" prop="specificationModel" /> |
| | | <el-table-column label="单位" prop="unit" width="70" /> |
| | | <el-table-column label="采购数量" prop="quantity" width="100" /> |
| | | <el-table-column label="待入库数量" prop="quantity0" width="100" /> |
| | | <el-table-column label="本次入库数量" prop="quantityStock" width="120"> |
| | | <template #default="scope"> |
| | | <el-input v-model="scope.row.quantityStock" type="number" /> |
| | | <el-input v-model="scope.row.quantityStock" type="number" :min="0" :max="scope.row.quantity0" /> |
| | | </template> |
| | | </el-table-column> |
| | | <el-table-column label="税率(%)" prop="taxRate" width="120" /> |
| | |
| | | import useUserStore from '@/store/modules/user' |
| | | import { userListNoPage } from "@/api/system/user.js"; |
| | | import { |
| | | ledgerListPage, |
| | | customerList, |
| | | addOrUpdateSalesLedger, |
| | | getSalesLedgerWithProducts, delLedger |
| | | } from "@/api/salesManagement/salesLedger.js"; |
| | | getStockInPage, |
| | | updateStockIn, |
| | | addSutockIn, |
| | | delStockIn, |
| | | exportStockIn |
| | | } 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 productData = ref([]) |
| | | const selectedRows = ref([]) |
| | | const userList = ref([]) |
| | | const customerOption = 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, |
| | |
| | | const dialogFormVisible = ref(false) |
| | | const data = reactive({ |
| | | searchForm: { |
| | | customerName: '', |
| | | supplierName: '', |
| | | }, |
| | | form: { |
| | | salesContractNo: '', |
| | | salesman: '', |
| | | customerContractNo: '', |
| | | customerId: '', |
| | | projectName: '', |
| | | entryPerson: '', |
| | | entryDate: '', |
| | | maintenanceTime: '', |
| | | productData: [], |
| | | executionDate: '' |
| | | supplierId: null, |
| | | supplierName: '', |
| | | productId: null, |
| | | productName: '', |
| | | userId: userStore.userId, |
| | | nickName: '', |
| | | model: '', |
| | | productModelId: null, |
| | | unit: '', |
| | | productrecordId: null, |
| | | taxInclusiveUnitPrice: '', |
| | | taxInclusiveTotalPrice: '', |
| | | taxRate: '', |
| | | taxExclusiveTotalPrice: '', |
| | | inboundTime: '', |
| | | inboundBatch: '', |
| | | inboundQuantity: '' |
| | | }, |
| | | rules: { |
| | | salesman: [{ required: true, message: "请选择", trigger: "change" }], |
| | | customerContractNo: [{ required: true, message: "请输入", trigger: "blur" }], |
| | | customerId: [{ required: true, message: "请选择", trigger: "change" }], |
| | | projectName: [{ required: true, message: "请输入", trigger: "blur" }], |
| | | entryPerson: [{ required: true, message: "请选择", trigger: "change" }], |
| | | entryDate: [{ required: true, message: "请选择", trigger: "change" }], |
| | | executionDate: [{ required: true, message: "请选择", trigger: "change" }], |
| | | 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" }], |
| | | } |
| | | }) |
| | | const { searchForm, form, rules } = toRefs(data) |
| | |
| | | } |
| | | const getList = () => { |
| | | tableLoading.value = true |
| | | ledgerListPage({ ...searchForm.value, ...page }).then(res => { |
| | | getStockInPage({ ...searchForm.value, ...page }).then(res => { |
| | | tableLoading.value = false |
| | | tableData.value = res.records |
| | | tableData.value.map(item => { |
| | | item.children = [] |
| | | }) |
| | | total.value = res.total |
| | | tableData.value = res.data.records |
| | | ttotal.value = res.data.total |
| | | }).catch(() => { |
| | | tableLoading.value = false |
| | | }) |
| | | } |
| | | const findNodeById = (nodes, productId) => { |
| | | for (let i = 0; i < nodes.length; i++) { |
| | | if (nodes[i].value === productId) { |
| | | return nodes[i].label; // 找到节点,返回该节点 |
| | | } |
| | | if (nodes[i].children && nodes[i].children.length > 0) { |
| | | const foundNode = findNodeById(nodes[i].children, productId); |
| | | if (foundNode) { |
| | | return foundNode.label; // 在子节点中找到,返回该节点 |
| | | } |
| | | } |
| | | |
| | | // 正确的产品列表加载方法 |
| | | const loadProductList = async () => { |
| | | loadingProducts.value = true; |
| | | 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); |
| | | } catch (error) { |
| | | console.error('加载产品列表失败:', error); |
| | | proxy.$modal.msgError('加载产品列表失败'); |
| | | } finally { |
| | | 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 // 设置默认入库人为当前用户 |
| | | } |
| | | } else { |
| | | // 编辑时填充表单数据 |
| | | form.value = { ...row , |
| | | supplierId: row.supplierId, |
| | | productId: row.productId, |
| | | productModelId: row.productModelId, |
| | | userId: row.userId |
| | | } |
| | | if (row.productId) { |
| | | await loadProductModels(row.productId) |
| | | } |
| | | } |
| | | } |
| | | |
| | | // 提交表单 |
| | | const submitForm = async () => { |
| | | try { |
| | | await proxy.$refs.formRef.validate() |
| | | |
| | | if (!form.value.productrecordId) { |
| | | proxy.$modal.msgError('请选择产品大类和规格型号以获取采购记录') |
| | | return |
| | | } |
| | | |
| | | const submitData = { |
| | | productrecordId: form.value.productrecordId, |
| | | supplierId: form.value.supplierId, |
| | | inboundQuantity: form.value.inboundQuantity, |
| | | userId: form.value.userId, |
| | | } |
| | | |
| | | const apiMethod = operationType.value === 'add' ? addSutockIn : updateStockIn |
| | | await apiMethod(submitData) |
| | | |
| | | proxy.$modal.msgSuccess(operationType.value === 'add' ? '新增成功' : '修改成功') |
| | | closeDia() |
| | | getList() |
| | | } catch (error) { |
| | | console.error('提交失败:', error) |
| | | if (!error.errors) { |
| | | proxy.$modal.msgError('操作失败,请重试') |
| | | } |
| | | } |
| | | } |
| | | // 关闭弹框 |
| | | const closeDia = () => { |
| | | proxy.$refs.formRef.resetFields() |
| | | dialogFormVisible.value = false |
| | | } |
| | | // 表格选择数据 |
| | | const handleSelectionChange = (selection) => { |
| | | // 过滤掉子数据 |
| | | selectedRows.value = selection.filter(item => item.children !== undefined); |
| | | selectedRows.value = selection.filter(item => item.id); |
| | | console.log('selection', selectedRows.value) |
| | | } |
| | | const expandedRowKeys = ref([]) |
| | |
| | | const summarizeMainTable = (param) => { |
| | | return proxy.summarizeTable(param, ['contractAmount', 'taxInclusiveTotalPrice', 'taxExclusiveTotalPrice']); |
| | | }; |
| | | |
| | | // 打开弹框 |
| | | const openForm = async (type, row) => { |
| | | operationType.value = type |
| | | form.value = {} |
| | | productData.value = [] |
| | | let userLists = await userListNoPage() |
| | | userList.value = userLists.data |
| | | customerList().then(res => { |
| | | customerOption.value = res |
| | | }) |
| | | console.log('userStore.id', userStore.id) |
| | | form.value.entryPerson = userStore.id |
| | | if (type === 'edit') { |
| | | currentId.value = row.id; |
| | | getSalesLedgerWithProducts({ id: row.id, type: 1 }).then(res => { |
| | | form.value = { ...res } |
| | | form.value.entryPerson = Number(res.entryPerson) |
| | | productData.value = form.value.productData |
| | | }) |
| | | } |
| | | // let userAll = await userStore.getInfo() |
| | | // userList.value.forEach(element => { |
| | | // if(userAll.user.nickName === element.nickName && userAll.user.userName === element.userName) { |
| | | // form.value.entryPerson = userAll.user.userId // 设置默认业务员为当前用户 |
| | | // } |
| | | // }); |
| | | form.value.entryDate = getCurrentDate() // 设置默认录入日期为当前日期 |
| | | dialogFormVisible.value = true |
| | | } |
| | | |
| | | // 提交表单 |
| | | const submitForm = () => { |
| | | proxy.$refs["formRef"].validate(valid => { |
| | | if (valid) { |
| | | if (productData.value.length > 0) { |
| | | form.value.productData = proxy.HaveJson(productData.value) |
| | | } else { |
| | | proxy.$modal.msgWarning('请添加产品信息') |
| | | return |
| | | } |
| | | let tempFileIds = [] |
| | | form.value.tempFileIds = tempFileIds |
| | | form.value.type = 1 |
| | | addOrUpdateSalesLedger(form.value).then(res => { |
| | | proxy.$modal.msgSuccess("提交成功") |
| | | closeDia() |
| | | getList() |
| | | }) |
| | | } |
| | | }) |
| | | } |
| | | // 关闭弹框 |
| | | const closeDia = () => { |
| | | proxy.resetForm("formRef") |
| | | dialogFormVisible.value = false |
| | | } |
| | | |
| | | // 导出 |
| | | const handleOut = () => { |
| | |
| | | type: 'warning', |
| | | } |
| | | ).then(() => { |
| | | proxy.download("/sales/ledger/export", {}, '入库台账.xlsx') |
| | | proxy.download("/stockin/export", {}, '入库台账.xlsx') |
| | | }).catch(() => { |
| | | proxy.$modal.msg("已取消") |
| | | }) |
| | |
| | | type: 'warning', |
| | | } |
| | | ).then(() => { |
| | | delLedger(ids).then(res => { |
| | | delStockIn(ids).then(res => { |
| | | proxy.$modal.msgSuccess("删除成功") |
| | | getList() |
| | | }) |