湟水峡-销售台账/采购台账，有可能同一个公司不同单子，但是开票登记的时候会一起，一对多或者多对一

gaoluyang

2025-11-28 60a702a3dbcbe6e16a26faab49e66d710d1f8656

 src/views/salesManagement/invoiceRegistration/index.vue

@@ -2,7 +2,7 @@
  <div class="app-container">
    <div class="search_form">
      <el-form :inline="true" :model="searchForm">
        <el-form-item label="开票登记">
        <el-form-item label="客户名称">
          <el-input
            v-model="searchForm.customerName"
            style="width: 240px"
@@ -26,6 +26,12 @@
            clearable
          />
        </el-form-item>
        <br>
        <el-form-item label="产品大类：">
          <el-input v-model="searchForm.productCategory" placeholder="请输入" clearable prefix-icon="Search"
                    @change="handleQuery" />
        </el-form-item>

        <el-form-item>
          <el-checkbox
            v-model="searchForm.status"
@@ -36,15 +42,18 @@
        <el-form-item>
          <el-button type="primary" @click="handleQuery"> 搜索 </el-button>
          <el-button @click="resetForm"> 重置 </el-button>
          <el-button @click="handleExport" style="margin-right: 10px">导出</el-button>
        </el-form-item>
      </el-form>
    </div>
    <div class="table_list">
      <div class="flex justify-between">
        <div></div>
        <div>
        <el-button type="primary" @click="openForm" style="margin-bottom: 8px">
          新增登记
        </el-button>
        </div>
      </div>
      <el-table
        :data="tableData"
@@ -74,10 +83,14 @@
                width="60"
              />
              <el-table-column label="产品大类" prop="productCategory" />
              <el-table-column label="规格型号" prop="specificationModel" />
              <el-table-column
                label="规格型号"
                prop="specificationModel"
                width="150"
              />
              <el-table-column label="单位" prop="unit" width="70" />
              <el-table-column label="数量" prop="quantity" width="70" />
              <el-table-column label="税率(%)" prop="taxRate" width="70" />
              <el-table-column label="税率(%)" prop="taxRate" width="80" />
              <el-table-column
                label="含税单价(元)"
                prop="taxInclusiveUnitPrice"
@@ -121,36 +134,48 @@
          label="销售合同号"
          prop="salesContractNo"
          show-overflow-tooltip
          width="200"
        />
        <el-table-column
          label="客户合同号"
          prop="customerContractNo"
          width="200"
          show-overflow-tooltip
        />
        <el-table-column
          label="客户名称"
          prop="customerName"
          show-overflow-tooltip
          width="240"
        />
        <el-table-column label="业务员" prop="salesman" show-overflow-tooltip />
        <el-table-column label="业务员" prop="salesman" show-overflow-tooltip width="90"/>
        <el-table-column
          label="项目名称"
          prop="projectName"
          show-overflow-tooltip
          width="200"
        />
        <el-table-column
          label="合同金额(元)"
          prop="contractAmount"
          show-overflow-tooltip
          :formatter="formattedNumber"
               width="220"

        />
        <el-table-column
          label="已开票金额(元)"
          prop="invoiceTotal"
          show-overflow-tooltip
          :formatter="formattedNumber"
          width="120"
        />
        <el-table-column label="未开票金额(元)" show-overflow-tooltip>
        <el-table-column
          label="未开票金额(元)"
          prop="noInvoiceAmountTotal"
          show-overflow-tooltip
          width="120"
        >
          <template #default="{ row, column }">
            <el-text type="danger">
              {{ formattedNumber(row, column, row.noInvoiceAmountTotal) }}
@@ -183,7 +208,7 @@
        <el-row :gutter="30">
          <el-col :span="12">
            <el-form-item label="销售合同号：" prop="salesContractNo">
              <el-input v-model="form.salesContractNo" disabled></el-input>
              <el-input v-model="form.salesContractNo" disabled placeholder="多合同批量处理（具体合同号见产品列表）"></el-input>
            </el-form-item>
          </el-col>
          <el-col :span="12">
@@ -273,20 +298,31 @@
            type="index"
            width="60"
          />
          <el-table-column label="所属合同" prop="salesContractNo" width="200">
            <template #default="{ row }">
              <el-tag type="primary">{{ row.salesContractNo }}</el-tag>
            </template>
          </el-table-column>
          <el-table-column label="产品大类" prop="productCategory" />
          <el-table-column label="规格型号" prop="specificationModel" />
          <el-table-column
            label="规格型号"
            prop="specificationModel"
            width="150"
          />
          <el-table-column label="单位" prop="unit" />
          <el-table-column label="数量" prop="quantity" width="70" />
          <el-table-column label="税率(%)" prop="taxRate" width="70" />
          <el-table-column label="税率(%)" prop="taxRate" width="80" />
          <el-table-column
            label="含税单价(元)"
            prop="taxInclusiveUnitPrice"
            :formatter="formattedNumber"
                  width="200"
          />
          <el-table-column
            label="含税总价(元)"
            prop="taxInclusiveTotalPrice"
            :formatter="formattedNumber"
                  width="200"
          />
          <el-table-column
            label="不含税总价(元)"
@@ -294,33 +330,29 @@
            :formatter="formattedNumber"
            width="150"
          />
          <el-table-column label="本次开票数" prop="currentInvoiceNum">
          <el-table-column label="本次开票数" prop="currentInvoiceNum" width="180">
            <template #default="scope">
              <el-input
                type="number"
                :step="0.1"
                min="0"
              <el-input-number :step="0.1" :min="0" style="width: 100%"
                                              :precision="2"
                v-model="scope.row.currentInvoiceNum"
                @blur="invoiceNumBlur(scope.row)"
              ></el-input>
                @change="invoiceNumBlur(scope.row)"
              ></el-input-number>
            </template>
          </el-table-column>
          <el-table-column
            label="本次开票金额(元)"
            prop="currentInvoiceAmount"
            width="150"
            width="180"
          >
            <template #default="scope">
              <el-input
                type="number"
                :step="0.01"
                min="0"
              <el-input-number :step="0.01" :min="0" style="width: 100%"
                                              :precision="2"
                v-model="scope.row.currentInvoiceAmount"
                @blur="invoiceAmountBlur(scope.row)"
              ></el-input>
                @change="invoiceAmountBlur(scope.row)"
              ></el-input-number>
            </template>
          </el-table-column>
          <el-table-column label="未开票数" prop="noInvoiceNum">
          <el-table-column label="未开票数" prop="noInvoiceNum" width="120">
            <template #default="scope">
              <el-input
                type="number"
@@ -333,7 +365,7 @@
          <el-table-column
            label="未开票金额(元)"
            prop="noInvoiceAmount"
            width="150"
            width="200"
          >
            <template #default="scope">
              <el-input
@@ -347,13 +379,17 @@
              ></el-input>
            </template>
          </el-table-column>
          <el-table-column label="登记人" prop="register">
            <template #default="{ row }">
              <el-input v-model="row.register" placeholder="请输入登记人" />
            </template>
          <el-table-column label="登记人" prop="register" width="100">
            <!-- <template #default="{ row }">
              <el-input
                v-model="row.register"
                placeholder="请输入登记人"
                disabled
              />
            </template> -->
          </el-table-column>
          <el-table-column label="登记日期" prop="registerDate">
            <template #default="{ row }">
          <el-table-column label="登记日期" prop="registerDate" width="150">
            <!-- <template #default="{ row }">
              <el-date-picker
                style="width: 100%"
                v-model="row.registerDate"
@@ -362,8 +398,9 @@
                type="date"
                placeholder="请选择"
                clearable
                disabled
              />
            </template>
            </template> -->
          </el-table-column>
        </el-table>
      </el-form>
@@ -416,6 +453,8 @@
    createUer: undefined, // 登记人
    issueDate: undefined, // 开票日期
    createTime: undefined, // 录入日期：
    productCategory: "",
    isInvoice: 1
  },
  form: {
    salesLedgerId: "",
@@ -426,11 +465,13 @@
    invoiceNo: "",
    createUer: userStore.nickName,
    issueDate: dayjs().format("YYYY-MM-DD"),
    selectedContractIds: [], // 新增：存储所有选中的合同ID
    isBatch: false // 新增：标识是否为批量操作
  },
  rules: {
    salesLedgerId: [{ required: true, message: "请选择", trigger: "change" }],
    createUer: [{ required: true, message: "请选择", trigger: "blur" }],
    issueDate: [{ required: true, message: "请选择", trigger: "change" }],
    invoiceNo: [{ required: true, message: "请输入", trigger: "change" }],
    createTime: [{ required: true, message: "请选择", trigger: "change" }],
  },
});
@@ -449,7 +490,7 @@
};

const formattedInputNumber = (value) => {
  return parseFloat(value).toFixed(2);
  return value ? parseFloat(value).toFixed(2) : 0;
};

// 查询列表
@@ -488,7 +529,7 @@
      productList({ salesLedgerId: row.id, type: 1 }).then((res) => {
        const index = tableData.value.findIndex((item) => item.id === row.id);
        if (index > -1) {
          tableData.value[index].children = res;
          tableData.value[index].children = res.data;
        }
        expandedRowKeys.value.push(row.id);
      });
@@ -503,8 +544,8 @@
const summarizeMainTable = (param) => {
  return proxy.summarizeTable(param, [
    "contractAmount",
    "noInvoiceAmountTotal",
    "invoiceTotal",
    "noInvoiceAmountTotal",
  ]);
};
// 子表合计方法
@@ -518,24 +559,67 @@
    "currentInvoiceAmount",
    "noInvoiceNum",
    "noInvoiceAmount",
    "currentInvoiceNum",
  ]);
};
// 打开弹框
const openForm = () => {
  // 判断是否多选
  if (selectedRows.value.length != 1) {
    proxy.$modal.msgError("请选择一条合同");
  // 判断是否选择了合同
  if (selectedRows.value.length === 0) {
    proxy.$modal.msgError("请至少选择一条合同");
    return;
  }
  
  // 检查所有选择的合同是否具有相同的客户名称
  const firstRow = selectedRows.value[0];
  const isSameCustomer = selectedRows.value.every(row => 
    row.customerName === firstRow.customerName
  );
  
  if (!isSameCustomer) {
    proxy.$modal.msgError("请选择相同客户名称的合同");
    return;
  }
  
  // 允许不同的销售合同号批量处理，无需检查重复
  
  form.value = {};
  productData.value = [];
  getSalesLedgerWithProducts({ id: selectedRows.value[0].id }).then((res) => {
    form.value = { ...res };
    form.value.createTime = dayjs().format("YYYY-MM-DD");
    form.value.createUer = userStore.nickName;
    productData.value = form.value.productData.map((item) => {
      return item;
  
  // 加载所有选中合同的产品数据
  const promises = selectedRows.value.map(row => 
    getSalesLedgerWithProducts({ id: row.id })
  );
  
  Promise.all(promises).then(results => {
    // 合并所有合同的产品数据，并为每个产品添加对应的合同信息
    const allProductData = [];
    results.forEach((result, index) => {
      const contract = selectedRows.value[index];
      const contractId = contract.id;
      if (result.productData) {
        result.productData.forEach(item => {
          allProductData.push({
            ...item,
            id: contractId, // 明确设置合同ID
            salesContractNo: contract.salesContractNo, // 添加销售合同号
            customerName: contract.customerName, // 添加客户名称
            customerContractNo: contract.customerContractNo // 添加客户合同号
          });
        });
      }
    });
    
    // 设置表单数据（使用第一个合同的基本信息，销售合同号留空）
    form.value = { ...results[0] };
    form.value.createTime = dayjs().format("YYYY-MM-DD");
    form.value.issueDate = dayjs().format("YYYY-MM-DD");
    form.value.createUer = userStore.nickName;
    form.value.selectedContractIds = selectedRows.value.map(row => row.id); // 存储所有选中的合同ID
    form.value.salesContractNo = ""; // 销售合同号留空，因为会在产品表格中分别显示
    
    productData.value = allProductData;
    
    dialogFormVisible.value = true;
    console.log("productData.value ", productData.value);
  });
@@ -544,12 +628,77 @@
const submitForm = () => {
  proxy.$refs["formRef"].validate((valid) => {
    if (valid) {
      form.value.productData = proxy.HaveJson(productData.value);
      invoiceRegistrationSave(form.value).then((res) => {
        proxy.$modal.msgSuccess("提交成功");
        closeDia();
        getList();
      });
      // 如果是批量操作，将所有合同的数据放在一个数组里，只调用一次接口
      if (selectedRows.value.length > 1) {
        // 创建包含所有合同数据的数组
        const batchData = selectedRows.value.map(contract => {
          // 筛选出属于当前合同的产品数据
          const contractProductData = productData.value.filter(item => 
            item.salesLedgerId === contract.id
          );
          
          // 为每个销售合同号创建独立的对象
          return {
            // 基础表单数据
            issueDate: form.value.issueDate,
            createTime: form.value.createTime,
            createUer: form.value.createUer,
            invoiceNo: form.value.invoiceNo,
            
            // 合同实际信息
            id: contract.id, // 使用id作为字段名，值为salesLedgerId
            salesContractNo: contract.salesContractNo, // 使用实际的销售合同号
            customerName: contract.customerName, // 使用实际的客户名称
            customerId: contract.customerId, // 添加客户ID
            customerContractNo: contract.customerContractNo, // 使用实际的客户合同号
            projectName: contract.projectName, // 使用实际的项目名称
            salesman: contract.salesman, // 使用实际的业务员
            
            // 产品数据
            productData: proxy.HaveJson(contractProductData),
            
            // 批量标识
            isBatch: true
          };
        });
        
        // 只调用一次接口，传递包含所有合同数据的数组
        invoiceRegistrationSave(batchData).then(() => {
          proxy.$modal.msgSuccess("批量新增成功");
          closeDia();
          getList();
        });
      } else {
        // 单个合同提交逻辑
        const singleContract = selectedRows.value[0];
        const singleForm = {
          // 基础表单数据
          issueDate: form.value.issueDate,
          createTime: form.value.createTime,
          createUer: form.value.createUer,
          invoiceNo: form.value.invoiceNo,
          
          // 合同实际信息
          id: singleContract.id, // 使用id作为字段名，值为salesLedgerId
          salesContractNo: singleContract.salesContractNo, // 使用实际的销售合同号
          customerName: singleContract.customerName, // 使用实际的客户名称
          customerId: singleContract.customerId, // 添加客户ID
          customerContractNo: singleContract.customerContractNo, // 使用实际的客户合同号
          projectName: singleContract.projectName, // 使用实际的项目名称
          salesman: singleContract.salesman, // 使用实际的业务员
          
          // 产品数据
          productData: proxy.HaveJson(productData.value),
          
          // 批量标识
          isBatch: false
        };
        invoiceRegistrationSave(singleForm).then((res) => {
          proxy.$modal.msgSuccess("提交成功");
          closeDia();
          getList();
        });
      }
    }
  });
};
@@ -567,6 +716,21 @@
  })
    .then(() => {
      proxy.download("/invoiceRegistration/export", {}, "开票登记信息.xlsx");
    })
    .catch(() => {
      proxy.$modal.msg("已取消");
    });
};

// 导出销售台账
const handleExport = () => {
  ElMessageBox.confirm("选中的内容将被导出，是否确认导出？", "导出", {
    confirmButtonText: "确认",
    cancelButtonText: "取消",
    type: "warning",
  })
    .then(() => {
      proxy.download("/sales/ledger/exportOne", { ...searchForm, ...page }, "开票登记.xlsx");
    })
    .catch(() => {
      proxy.$modal.msg("已取消");
@@ -640,3 +804,8 @@
  font-weight: bold;
}
</style>