fix: 生产订单-导出接口重新对接

spring

18 小时以前 46ec48beb42de969c2e83968ee1696a709b99f33

 src/views/procurementManagement/invoiceEntry/index.vue

@@ -1,413 +1,301 @@
<template>
  <div class="app-container">
    <div class="search_form">
      <div>
        <span class="search_title">采购合同号：</span>
        <el-input
            v-model="searchForm.purchaseContractNumber"
            style="width: 240px"
            placeholder="请输入"
            @change="handleQuery"
            clearable
            prefix-icon="Search"
        />
        <el-button type="primary" @click="handleQuery" style="margin-left: 10px">搜索</el-button>
      </div>
      <div>
        <el-button type="primary" @click="openForm('add')">新增登记</el-button>
        <el-button @click="handleOut">导出</el-button>
        <el-button type="danger" plain @click="handleDelete">删除</el-button>
      </div>
      <el-form :model="filters"
               :inline="true">
        <el-form-item label="供应商名称">
          <el-input v-model="filters.supplierName"
                    placeholder="请输入名称搜索"
                    clearable
                    prefix-icon="Search"
                    @change="getTableData" />
        </el-form-item>
        <el-form-item label="采购订单号：">
          <el-input v-model="filters.purchaseContractNumber"
                    placeholder="请输入"
                    clearable
                    prefix-icon="Search"
                    @change="getTableData" />
        </el-form-item>
        <el-form-item label="销售合同号">
          <el-input v-model="filters.salesContractNo"
                    placeholder="请输入销售合同号"
                    clearable />
        </el-form-item>
        <el-form-item>
          <el-button type="primary"
                     @click="getTableData"> 搜索 </el-button>
          <el-button @click="resetFilters"> 重置 </el-button>
        </el-form-item>
      </el-form>
    </div>
    <div class="table_list">
      <el-table :data="tableData" border v-loading="tableLoading"
                @selection-change="handleSelectionChange"
                :expand-row-keys="expandedRowKeys"
                :row-key="row => row.id"
                show-summary
                :summary-method="summarizeMainTable"
                @expand-change="expandChange"
                height="calc(100vh - 18.5em)">
        <el-table-column align="center" type="selection" width="55" />
        <el-table-column type="expand">
          <template #default="props">
            <el-table :data="props.row.children" border
                      show-summary
                      :summary-method="summarizeChildrenTable">
              <el-table-column align="center" label="序号" type="index" width="60" />
              <el-table-column label="产品大类" prop="productCategory" />
              <el-table-column label="规格型号" prop="specificationModel" />
              <el-table-column label="单位" prop="unit" />
              <el-table-column label="数量" prop="quantity" />
              <el-table-column label="税率(%)" prop="taxRate" />
              <el-table-column label="含税单价(元)" prop="taxInclusiveUnitPrice" />
              <el-table-column label="含税总价(元)" prop="taxInclusiveTotalPrice" />
              <el-table-column label="不含税总价(元)" prop="taxExclusiveTotalPrice" />
              <el-table-column label="本次来票数" prop="ticketsNum" />
              <el-table-column label="本次来票金额(元)" prop="ticketsAmount" />
              <el-table-column label="未来票数" prop="futureTickets" />
              <el-table-column label="未来票金额(元)" prop="futureTicketsAmount" />
            </el-table>
          </template>
        </el-table-column>
        <el-table-column align="center" label="序号" type="index" width="60" />
        <el-table-column label="采购合同号" prop="purchaseContractNumber" show-overflow-tooltip/>
        <el-table-column label="销售合同号" prop="salesContractNo" show-overflow-tooltip/>
        <el-table-column label="供应商名称" prop="supplierName" show-overflow-tooltip/>
        <el-table-column label="业务员" prop="businessPerson" show-overflow-tooltip/>
        <el-table-column label="项目名称" prop="projectName" show-overflow-tooltip/>
        <el-table-column label="合同金额(元)" prop="contractAmount" 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>
          </template>
        </el-table-column>
      </el-table>
      <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="80%" @close="closeDia">
      <el-form :model="form" label-width="140px" label-position="top" :rules="rules" ref="formRef">
        <el-row :gutter="30">
          <el-col :span="12">
            <el-form-item label="采购合同号：" prop="purchaseLedgerId">
              <el-select v-model="form.purchaseLedgerId" placeholder="请选择" clearable @change="setInfo">
                <el-option v-for="item in purchaseLedgerList" :key="item.id" :label="item.purchaseContractNumber" :value="item.id"/>
              </el-select>
            </el-form-item>
          </el-col>
          <el-col :span="12">
            <el-form-item label="销售合同号：" prop="salesContractNo">
              <el-input v-model="form.salesContractNo" placeholder="自动填充" clearable disabled/>
            </el-form-item>
          </el-col>
        </el-row>
        <el-row :gutter="30">
          <el-col :span="12">
            <el-form-item label="供应商名称：" prop="supplierName">
              <el-input v-model="form.supplierName" placeholder="自动填充" clearable disabled/>
            </el-form-item>
          </el-col>
          <el-col :span="12">
            <el-form-item label="项目名称：" prop="projectName">
              <el-input v-model="form.projectName" placeholder="自动填充" clearable disabled/>
            </el-form-item>
          </el-col>
        </el-row>
        <el-row :gutter="30">
          <el-col :span="12">
            <el-form-item label="业务员：" prop="businessPersonId">
              <el-select v-model="form.businessPersonId" placeholder="自动填充" clearable disabled>
                <el-option v-for="item in userList" :key="item.userId" :label="item.nickName" :value="item.userId"/>
              </el-select>
            </el-form-item>
          </el-col>
        </el-row>
        <el-row>
          <el-form-item label="产品信息：" prop="entryDate">
          </el-form-item>
        </el-row>
        <el-table :data="productData" border @selection-change="productSelected">
          <el-table-column align="center" label="序号" type="index" width="60" />
          <el-table-column label="产品大类" prop="productCategory" />
          <el-table-column label="规格型号" prop="specificationModel" />
          <el-table-column label="单位" prop="unit" />
          <el-table-column label="数量" prop="quantity" />
          <el-table-column label="税率(%)" prop="taxRate" />
          <el-table-column label="含税单价(元)" prop="taxInclusiveUnitPrice" />
          <el-table-column label="含税总价(元)" prop="taxInclusiveTotalPrice" />
          <el-table-column label="不含税总价(元)" prop="taxExclusiveTotalPrice" />
          <el-table-column label="本次来票数" prop="ticketsNum">
            <template #default="scope">
              <el-input :disabled="!scope.row.editFlag" v-model="scope.row.ticketsNum"></el-input>
            </template>
          </el-table-column>
          <el-table-column label="本次来票金额(元)" prop="ticketsAmount">
            <template #default="scope">
              <el-input :disabled="!scope.row.editFlag" v-model="scope.row.ticketsAmount"></el-input>
            </template>
          </el-table-column>
          <el-table-column label="未来票数" prop="futureTickets">
            <template #default="scope">
              <el-input :disabled="!scope.row.editFlag" v-model="scope.row.futureTickets"></el-input>
            </template>
          </el-table-column>
          <el-table-column label="未来票金额(元)" prop="futureTicketsAmount">
            <template #default="scope">
              <el-input :disabled="!scope.row.editFlag" v-model="scope.row.futureTicketsAmount"></el-input>
            </template>
          </el-table-column>
          <el-table-column fixed="right" label="操作" min-width="60" align="center">
            <template #default="scope">
              <el-button v-if="!scope.row.editFlag" link type="primary" size="small" @click="openProductEdit(scope.row);">编辑</el-button>
              <el-button v-else link type="primary" size="small" @click="openProductEdit(scope.row);">保存</el-button>
            </template>
          </el-table-column>
        </el-table>
      </el-form>
      <template #footer>
        <div class="dialog-footer">
          <el-button type="primary" @click="submitForm">确认</el-button>
          <el-button @click="closeDia">取消</el-button>
      <div class="actions">
        <div></div>
        <div>
          <el-button @click="handleExport"
                     style="margin-right: 10px">导出</el-button>
          <el-button type="primary"
                     @click="handleAdd('add')">
            新增登记
          </el-button>
          <!--          <el-button type="danger" plain @click="handleDelete">删除</el-button>-->
        </div>
      </template>
    </el-dialog>
      </div>
      <PIMTable rowKey="id"
                :column="columns"
                :tableData="dataList"
                :tableLoading="loading"
                :isSelection="true"
                :page="{
          current: pagination.currentPage,
          size: pagination.pageSize,
          total: pagination.total,
        }"
                :expand-row-keys="expandRowKeys"
                :summaryMethod="summarizeMainTable"
                :isShowSummary="true"
                @expand-change="expandChange"
                @selection-change="handleSelectionChange"
                @pagination="changePage">
        <template #expand="{ row }">
          <ExpandTable ref="expandTableRef" />
        </template>
        <template #operation="{ row }">
          <el-button text
                     type="primary"
                     size="small"
                     @click="handleEdit('edit', row.id)">
            编辑
          </el-button>
        </template>
      </PIMTable>
    </div>
    <Modal ref="modalRef"
           @refreshList="getTableData"></Modal>
  </div>
</template>

<script setup>
import pagination from '@/components/PIMTable/Pagination.vue'
import { ref } from 'vue'
import {ElMessageBox } from "element-plus";
import {userListNoPage} from "@/api/system/user.js";
import {productList} from "@/api/procurementManagement/procurementLedger.js";
const { proxy } = getCurrentInstance()
const tableData = ref([])
const productData = ref([])
const selectedRows = ref([])
const productSelectedRows = ref([])
const userList = ref([])
const purchaseLedgerList = ref([])
const tableLoading = ref(false)
const page = reactive({
  current: 1,
  size: 10,
})
const total = ref(0)
const fileList = ref([])
import {
  addOrUpdateRegistration,
  delRegistration,
  gePurchaseList,
  getInfo,
  getProduct,
  getRegistrationById
} from "@/api/procurementManagement/invoiceEntry.js";
  import { usePaginationApi } from "@/hooks/usePaginationApi";
  import {
    delRegistration,
    gePurchaseListPage,
  } from "@/api/procurementManagement/invoiceEntry.js";
  import { nextTick, onMounted, getCurrentInstance, ref } from "vue";
  import ExpandTable from "./components/ExpandTable.vue";
  import Modal from "./components/Modal.vue";
  import { ElMessageBox } from "element-plus";

// 用户信息表单弹框数据
const operationType = ref('')
const dialogFormVisible = ref(false)
const data = reactive({
  searchForm: {
    purchaseContractNumber: '',
  },
  form: {
    purchaseLedgerId: '',
  },
  rules: {
    purchaseLedgerId: [{ required: true, message: "请选择", trigger: "change" }],
  }
})
const { searchForm, form, rules } = toRefs(data)
// 产品表单弹框数据
const productFormVisible = ref(false)
const productOperationType = ref('')
const currentId = ref('')

// 查询列表
/** 搜索按钮操作 */
const handleQuery = () => {
  page.current = 1
  getList()
}
const paginationChange = ({ current, limit }) => {
  page.current = current;
  page.size = limit;
  getList()
}
const getList = () => {
  tableLoading.value = true
  gePurchaseList({...searchForm.value, ...page}).then(res => {
    tableLoading.value = false
    tableData.value = res.rows
    tableData.value.map(item => {
      item.children = []
    })
    total.value = res.total
    expandedRowKeys.value = []
  }).catch(() => {
    tableLoading.value = false
  })
}
// 表格选择数据
const handleSelectionChange = (selection) => {
  selectedRows.value = selection
}
const productSelected = (selectedRows) => {
  productSelectedRows.value = selectedRows
}
const expandedRowKeys = ref([])
// 展开行
const expandChange = (row, expandedRows) => {
  if (expandedRows.length > 0) {
    expandedRowKeys.value = []
    try {
      productList({salesLedgerId: row.purchaseLedgerId, type: 2}).then(res => {
        const index = tableData.value.findIndex(item => item.id === row.id);
        if (index > -1) {
          tableData.value[index].children = res.rows;
        }
        expandedRowKeys.value.push(row.id)
      })
    } catch (error) {
      console.log(error)
    }
  } else {
    expandedRowKeys.value = []
  }
}
// 主表合计方法
const summarizeMainTable = (param) => {
  const { columns, data } = param;
  const sums = [];
  columns.forEach((column, index) => {
    if (index === 0) {
      sums[index] = '合计';
      return;
    }
    const prop = column.property;
    if (['contractAmount'].includes(prop)) {
      const values = data.map(item => Number(item[prop]));
      if (!values.every(value => isNaN(value))) {
        sums[index] = values.reduce((acc, val) => (!isNaN(val) ? acc + val : acc), 0);
      } else {
        sums[index] = '';
      }
    } else {
      sums[index] = '';
    }
  })
  return sums;
};
// 子表合计方法
const summarizeChildrenTable = (param) => {
  const { columns, data } = param;
  const sums = [];
  columns.forEach((column, index) => {
    if (index === 0) {
      sums[index] = '合计';
      return;
    }
    const prop = column.property;
    if (['taxInclusiveUnitPrice', 'taxInclusiveTotalPrice', 'taxExclusiveTotalPrice', 'ticketsNum', 'ticketsAmount', 'futureTickets', 'futureTicketsAmount'].includes(prop)) {
      const values = data.map(item => Number(item[prop]));
      if (!values.every(value => isNaN(value))) {
        sums[index] = values.reduce((acc, val) => (!isNaN(val) ? acc + val : acc), 0);
      } else {
        sums[index] = '';
      }
    } else {
      sums[index] = '';
    }
  defineOptions({
    name: "来票登记",
  });
  return sums;
}
// 打开弹框
const openForm = (type, row) => {
  operationType.value = type
  form.value = {}
  productData.value = []
  fileList.value = []
  // 查询人员列表
  userListNoPage().then(res => {
    userList.value = res.data
  })
  // 查询采购合同号
  getProduct().then(res => {
    purchaseLedgerList.value = res
  })
  if (type === 'edit') {
    currentId.value = row.id;
    getRegistrationById({id: row.id}).then(res => {
      form.value = {...res}
      productData.value = form.value.productData
      if(form.value.salesLedgerFiles) {
        fileList.value = form.value.salesLedgerFiles
      } else {
        fileList.value = []
      }
    })
  }
  dialogFormVisible.value = true
}
// 选择采购合同号赋值
const setInfo = (value) => {
  getInfo({id: value}).then(res => {
    form.value.salesContractNo = res.salesContractNo
    form.value.projectName = res.projectName
    productData.value = res.productData
    form.value.supplierName = res.supplierName
    form.value.businessPersonId = res.businessPersonId
  })
}
// 提交表单
const submitForm = () => {
  proxy.$refs["formRef"].validate(valid => {
    if (valid) {
      form.value.productData = proxy.HaveJson(productData.value)
      addOrUpdateRegistration(form.value).then(res => {
        proxy.$modal.msgSuccess("提交成功")
        closeDia()
        getList()
      })

  const { proxy } = getCurrentInstance();
  const expandRowKeys = ref([]);
  const expandTableRef = ref();
  const modalRef = ref();
  const selectedRows = ref([]);

  const {
    loading,
    filters,
    columns,
    dataList,
    pagination,
    getTableData,
    resetFilters,
    onCurrentChange,
  } = usePaginationApi(
    gePurchaseListPage,
    {
      purchaseContractNumber: undefined,
    },
    [
      {
        type: "expand",
        dataType: "slot",
        slot: "expand",
      },
      {
        label: "采购订单号",
        prop: "purchaseContractNumber",
        width: 150,
      },
      {
        label: "销售合同号",
        prop: "salesContractNo",
        width: 150,
      },
      {
        label: "供应商名称",
        prop: "supplierName",
        width: 300,
      },
      {
        label: "录入人",
        prop: "recorderName",
      },
      {
        label: "录入日期",
        prop: "entryDate",
        width: 110,
      },
      {
        label: "合同金额(元)",
        prop: "contractAmount",
        width: 200,
        formatData: val => {
          return val ? parseFloat(val).toFixed(2) : 0;
        },
      },
      {
        label: "已来票金额(元)",
        prop: "receiptPaymentAmount",
        width: 200,
        formatData: val => {
          return val ? parseFloat(val).toFixed(2) : 0;
        },
      },
      {
        label: "待来票金额(元)",
        prop: "unReceiptPaymentAmount",
        width: 200,
        formatData: val => {
          return val ? parseFloat(val).toFixed(2) : 0;
        },
      },
      // {
      //   fixed: "right",
      //   label: "操作",
      //   dataType: "slot",
      //   slot: "operation",
      //   align: "center",
      //   width: "200px",
      // },
    ]
  );
  // 计算属性过滤 审批通过approvalStatus=1 的数据
  // const filteredDataList = computed(() => {
  //   // return dataList.value.filter(item => item.approvalStatus == 1);
  //   return dataList;
  // });
  const handleSelectionChange = selection => {
    selectedRows.value = selection.filter(
      item => item.purchaseContractNumber !== undefined
    );
  };

  const handleAdd = type => {
    if (selectedRows.value.length < 1) {
      proxy.$modal.msgWarning("请至少选中一条数据");
      return;
    }
  })
}
// 关闭弹框
const closeDia = () => {
  proxy.resetForm("formRef")
  dialogFormVisible.value = false
}
// 填写数据
const openProductEdit = (row) => {
  const index =  productData.value.findIndex(item => item.id === row.id);
  if (index > -1) {
    productData.value[index].editFlag = !productData.value[index].editFlag
  }
}
// 导出
const handleOut = () => {
  ElMessageBox.confirm(
      '选中的内容将被导出，是否确认导出？',
      '导出', {
        confirmButtonText: '确认',
        cancelButtonText: '取消',
        type: 'warning',
      }
  ).then(() => {
    proxy.download("/purchase/registration/export", {}, '来票登记.xlsx')
  }).catch(() => {
    proxy.$modal.msg("已取消")
  })
}
// 删除
const handleDelete = () => {
  let ids = []
  if (selectedRows.value.length > 0) {
    ids = selectedRows.value.map(item => item.id);
  } else {
    proxy.$modal.msgWarning('请选择数据')
    return
  }
  ElMessageBox.confirm(
      '选中的内容将被删除，是否确认删除？',
      '导出', {
        confirmButtonText: '确认',
        cancelButtonText: '取消',
        type: 'warning',
      }
  ).then(() => {
    delRegistration(ids).then(res => {
      proxy.$modal.msgSuccess("删除成功")
      getList()
    modalRef.value.open(type, selectedRows.value);
  };

  const handleEdit = (type, id) => {
    modalRef.value.open(type, id);
  };

  // 导出
  const handleOut = () => {
    ElMessageBox.confirm("选中的内容将被导出，是否确认导出？", "导出", {
      confirmButtonText: "确认",
      cancelButtonText: "取消",
      type: "warning",
    })
  }).catch(() => {
    proxy.$modal.msg("已取消")
  })
}
getList()
      .then(() => {
        proxy.download("/purchase/registration/export", {}, "来票登记.xlsx");
      })
      .catch(() => {
        proxy.$modal.msg("已取消");
      });
  };

  // 导出采购台账
  const handleExport = () => {
    ElMessageBox.confirm("选中的内容将被导出，是否确认导出？", "导出", {
      confirmButtonText: "确认",
      cancelButtonText: "取消",
      type: "warning",
    })
      .then(() => {
        proxy.download("/purchase/ledger/exportOne", {}, "来票登记.xlsx");
      })
      .catch(() => {
        proxy.$modal.msg("已取消");
      });
  };

  // 删除
  const handleDelete = () => {
    let ids = [];
    if (selectedRows.value.length > 0) {
      // 新增判断：如果有选中的数据没有ticketRegistrationId，提示并终止
      const noTicket = selectedRows.value.some(
        item => !item.ticketRegistrationId
      );
      if (noTicket) {
        proxy.$modal.msgWarning("采购台账还未进行来票登记,无法进行删除操作");
        return;
      }
      ids = selectedRows.value.map(item => item.ticketRegistrationId);
    } else {
      proxy.$modal.msgWarning("请选择数据");
      return;
    }
    ElMessageBox.confirm("选中的内容将被删除，是否确认删除？", "导出", {
      confirmButtonText: "确认",
      cancelButtonText: "取消",
      type: "warning",
    })
      .then(() => {
        delRegistration(ids).then(res => {
          proxy.$modal.msgSuccess("删除成功");
          getList();
        });
      })
      .catch(() => {
        proxy.$modal.msg("已取消");
      });
  };

  const expandChange = async (row, expandedRows) => {
    if (expandedRows.length > 0) {
      await nextTick();
      expandTableRef.value.getList(row.id);
    }
  };

  const changePage = ({ page, limit }) => {
    pagination.currentPage = page;
    pagination.pageSize = limit;
    onCurrentChange(page);
  };
  // 主表合计方法
  const summarizeMainTable = param => {
    return proxy.summarizeTable(
      param,
      ["contractAmount", "receiptPaymentAmount", "unReceiptPaymentAmount"],
      {
        ticketsNum: { noDecimal: true }, // 不保留小数
        futureTickets: { noDecimal: true }, // 不保留小数
      }
    );
  };
  onMounted(() => {
    getTableData();
  });
</script>

<style scoped lang="scss">

</style>
<style lang="scss" scoped>
  .table_list {
    margin-top: unset;
  }
  .actions {
    display: flex;
    justify-content: space-between;
    margin-bottom: 10px;
  }
</style>