开票登记前后端联调

chenrui

2025-05-12 07248d50234b812002f9a16ae5a9f45190baa675

开票登记前后端联调

 src/api/salesManagement/invoiceRegistration.js

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,54 @@
// é”€å”®å°è´¦é¡µé¢æŽ¥å£
import request from '@/utils/request'

// åˆ†é¡µæŸ¥è¯¢
export function invoiceRegistrationList(query) {
    return request({
        url: '/invoiceRegistration/listPage',
        method: 'get',
        params: query
    })
}
// å¼€ç¥¨ç™»è®°æ–°å¢ž
export function invoiceRegistrationSaveOrUpdate(query) {
    return request({
        url: '/invoiceRegistration/saveOrUpdate',
        method: 'post',
        data: query
    })
}
// å¼€ç¥¨ç™»è®°åˆ é™¤
export function invoiceRegistrationDel(query) {
    return request({
        url: '/invoiceRegistration/del',
        method: 'delete',
        data: query
    })
}
// å­è¡¨æ ¼æŸ¥è¯¢
export function productList(query) {
    return request({
        url: '/invoiceRegistration/productList',
        method: 'get',
        params: query
    })
}

// å¼€ç¥¨ç™»è®°è¯¦æƒ…
export function invoiceRegistrationDetail(query) {
    return request({
        url: '/invoiceRegistration/detail',
        method: 'get',
        params: query
    })
}

// å¯¼å‡ºå¼€ç¥¨ç™»è®°
export function invoiceRegistrationExport(query) {
    return request({
        url: '/invoiceRegistration/export',
        method: 'get',
        params: query,
        responseType: 'blob'
    })
}

 src/api/salesManagement/salesLedger.js

@@ -65,3 +65,12 @@
        data: query
    })
}

// é”€å”®ä¸åˆ†é¡µæŸ¥è¯¢
export function ledgerListNoPage(query) {
    return request({
        url: '/sales/ledger/listNoPage',
        method: 'get',
        params: query
    })
}

 src/views/salesManagement/invoiceRegistration/index.vue

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,422 @@
<template>
  <div class="app-container">
    <div class="search_form">
      <div>
        <span class="search_title">开票登记：</span>
        <el-input
            v-model="searchForm.customerName"
            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>
    </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="invoiceNum" />
              <el-table-column label="本次开票金额(元)" prop="invoiceAmount" />
              <el-table-column label="未开票数(元)" prop="noInvoiceNum" />
              <el-table-column label="未开票金额(元)" prop="noInvoiceAmount" />
            </el-table>
          </template>
        </el-table-column>
        <el-table-column align="center" label="序号" type="index" width="60" />
        <el-table-column label="销售合同号" prop="salesContractNo" show-overflow-tooltip/>
        <el-table-column label="客户合同号" prop="customerContractNo" show-overflow-tooltip/>
        <el-table-column label="客户名称" prop="customerName" show-overflow-tooltip/>
        <el-table-column label="业务员" prop="salesman" 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="70%" @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="salesLedgerId">
              <el-select v-model="form.salesLedgerId" placeholder="请选择" clearable @change="ledgerChange" :disabled="operationType === 'edit'">
                <el-option v-for="item in ledgerList" :key="item.id" :label="item.salesContractNo" :value="item.id"/>
              </el-select>
            </el-form-item>
          </el-col>
          <el-col :span="12">
            <el-form-item label="客户名称：" prop="customerName">
                <el-input v-model="form.customerName" placeholder="自动填充" disabled></el-input>
            </el-form-item>
          </el-col>
        </el-row>
        <el-row :gutter="30">
          <el-col :span="12">
            <el-form-item label="业务员：" prop="salesman">
              <el-input v-model="form.salesman" placeholder="自动填充" disabled/>
            </el-form-item>
          </el-col>
          <el-col :span="12">
            <el-form-item label="项目名称：" prop="projectName">
              <el-input v-model="form.projectName" placeholder="自动填充" disabled/>
            </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>
          <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="invoiceNum">
            <template #default="scope">
              <el-input :disabled="!scope.row.editFlag" v-model="scope.row.invoiceNum"></el-input>
            </template>
          </el-table-column>
          <el-table-column label="本次开票金额(元)" prop="invoiceAmount" >
            <template #default="scope">
              <el-input :disabled="!scope.row.editFlag" v-model="scope.row.invoiceAmount"></el-input>
            </template>
          </el-table-column>
          <el-table-column label="未开票数(元)" prop="noInvoiceNum" >
            <template #default="scope">
              <el-input :disabled="!scope.row.editFlag" v-model="scope.row.noInvoiceNum"></el-input>
            </template>
          </el-table-column>
          <el-table-column label="未开票金额(元)" prop="noInvoiceAmount" >
            <template #default="scope">
              <el-input :disabled="!scope.row.editFlag" v-model="scope.row.noInvoiceAmount"></el-input>
            </template>
          </el-table-column>
          <el-table-column fixed="right" label="操作" min-width="60" align="center">
            <template #default="scope">
              <el-button link type="primary" size="small" @click="openProductEdit('edit', 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>
      </template>
    </el-dialog>
  </div>
</template>

<script setup>
import pagination from '@/components/PIMTable/Pagination.vue'
import { ref } from 'vue'
import {Search} from "@element-plus/icons-vue";
import {ElMessageBox } from "element-plus";
// import {userListNoPage} from "@/api/system/user.js";
import {
  ledgerListNoPage,
  getSalesLedgerWithProducts,
} from "@/api/salesManagement/salesLedger.js";
import {
  invoiceRegistrationList,
  invoiceRegistrationSaveOrUpdate,
  invoiceRegistrationDel,
  productList,
  invoiceRegistrationDetail,
  invoiceRegistrationExport
} from "@/api/salesManagement/invoiceRegistration.js";
const { proxy } = getCurrentInstance()
const tableData = ref([])
const productData = ref([])
const selectedRows = ref([])
const tableLoading = ref(false)
const page = reactive({
  current: 1,
  size: 10,
})
const total = ref(0)
const ledgerList = ref([])
// ç”¨æˆ·ä¿¡æ¯è¡¨å•å¼¹æ¡†æ•°æ®
const operationType = ref('')
const dialogFormVisible = ref(false)
const data = reactive({
  searchForm: {
    customerName: '',
  },
  form: {
    salesLedgerId: '',
    customerName: '',
    salesman: '',
    projectName: '',
    productData: []
  },
  rules: {
    salesLedgerId: [{ required: true, message: "请选择", trigger: "change" }]
  }
})
const { searchForm, form, rules } = toRefs(data)
// äº§å“è¡¨å•å¼¹æ¡†æ•°æ®
const productFormData = reactive({
  productForm: {
    productCategory: '',
    specificationModel: '',
    unit: '',
    quantity: '',
    taxInclusiveUnitPrice: '',
    taxRate: '',
    taxInclusiveTotalPrice: '',
    taxExclusiveTotalPrice: '',
    invoiceType: '',
  },
})
const { productForm } = toRefs(productFormData)

// æŸ¥è¯¢åˆ—表
/** æœç´¢æŒ‰é’®æ“ä½œ */
const handleQuery = () => {
  page.current = 1
  getList()
}
const paginationChange = ({ current, limit }) => {
  page.current = current;
  page.size = limit;
  getList()
}
const getList = () => {
  tableLoading.value = true
  invoiceRegistrationList({...searchForm.value, ...page}).then(res => {
    tableLoading.value = false
    tableData.value = res.data.records;
    tableData.value.map(item => {
      item.children = []
    })
    total.value = res.data.total
  })
}
// è¡¨æ ¼é€‰æ‹©æ•°æ®
const handleSelectionChange = (selection) => {
  selectedRows.value = selection
}
const expandedRowKeys = ref([])
// å±•å¼€è¡Œ
const expandChange = (row, expandedRows) => {
  if (expandedRows.length > 0) {
    expandedRowKeys.value = []
    try {
      productList({invoiceRegistrationId: row.id}).then(res => {
        const index = tableData.value.findIndex(item => item.id === row.id);
        if (index > -1) {
          tableData.value[index].children = res.data;
        }
        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','invoiceNum','invoiceAmount','noInvoiceNum','noInvoiceAmount'].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 openForm = (type, row) => {
  operationType.value = type
  form.value = {}
  productData.value = []
  // æŸ¥è¯¢é”€å”®åˆåŒ
  ledgerListNoPage({}).then(res => {
    ledgerList.value = res.data;
  })
  if (type === 'edit') {
    invoiceRegistrationDetail({id: row.id}).then(res => {
      form.value = {...res.data}
      form.value.productDtoList = res.data.productDtoList
      productData.value = form.value.productDtoList
    })
  }
  //   currentId.value = row.id;
  //   getSalesLedgerWithProducts({id: row.id}).then(res => {
  //     form.value = {...res}
  //     productData.value = form.value.productData
  //   })
  // }
  dialogFormVisible.value = true
}
// æäº¤è¡¨å•
const submitForm = () => {
  proxy.$refs["formRef"].validate(valid => {
    if (valid) {
      form.value.productDtoList = productData;
      invoiceRegistrationSaveOrUpdate(form.value).then(res => {
        proxy.$modal.msgSuccess("提交成功")
        closeDia()
        getList()
      })
    }
  })
}
// å…³é—­å¼¹æ¡†
const closeDia = () => {
  proxy.resetForm("formRef")
  dialogFormVisible.value = false
}
// æ‰“开产品弹框
const openProductEdit = (type, 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("/invoiceRegistration/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(() => {
    invoiceRegistrationDel(ids).then(res => {
      proxy.$modal.msgSuccess("删除成功")
      getList()
    })
  }).catch(() => {
    proxy.$modal.msg("已取消")
  })
}
// é”€å”®å°è´¦ç­›é€‰
const ledgerChange = (val) => {
  if(val){
    getSalesLedgerWithProducts({id: val}).then(res => {
      form.value = {
        salesLedgerId: res.id,
        customerName: res.customerName,
        salesman: res.salesman,
        projectName: res.projectName,
        productData: res.productData,
        salesContractNo: res.salesContractNo,
        customerId: res.customerId,
      }
      productData.value = form.value.productData.map(item => {
        item.id = ""
        item.editFlag = false
        return item
      })
    })
  }else {
    proxy.resetForm("formRef")
    productData.value = []
  }
}
getList()
</script>

<style scoped lang="scss">

</style>