<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 label="未开票金额(元)" prop="noInvoiceAmountTotal" show-overflow-tooltip/>
|
</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 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">
|
<template #default="scope">
|
<el-input type="number" :step="1" min="0" v-model="scope.row.invoiceNum" @blur="invoiceNumBlur(scope.row)"></el-input>
|
</template>
|
</el-table-column>
|
<el-table-column label="本次开票金额(元)" prop="invoiceAmount" >
|
<template #default="scope">
|
<el-input type="number" :step="0.01" min="0" v-model="scope.row.invoiceAmount" @blur="invoiceAmountBlur(scope.row)"></el-input>
|
</template>
|
</el-table-column>
|
<el-table-column label="未开票数" prop="noInvoiceNum" >
|
<template #default="scope">
|
<el-input type="number" min="0" disabled v-model="scope.row.noInvoiceNum"></el-input>
|
</template>
|
</el-table-column>
|
<el-table-column label="未开票金额(元)" prop="noInvoiceAmount" >
|
<template #default="scope">
|
<el-input type="number" min="0" disabled v-model="scope.row.noInvoiceAmount"></el-input>
|
</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,
|
} 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 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
|
expandedRowKeys.value = []
|
})
|
}
|
// 表格选择数据
|
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
|
})
|
}
|
dialogFormVisible.value = true
|
}
|
// 提交表单
|
const submitForm = () => {
|
proxy.$refs["formRef"].validate(valid => {
|
if (valid) {
|
form.value.productDtoList = proxy.HaveJson(productData.value)
|
delete form.value.productData
|
invoiceRegistrationSaveOrUpdate(form.value).then(res => {
|
proxy.$modal.msgSuccess("提交成功")
|
closeDia()
|
getList()
|
})
|
}
|
})
|
}
|
// 关闭弹框
|
const closeDia = () => {
|
proxy.resetForm("formRef")
|
dialogFormVisible.value = false
|
}
|
// 导出
|
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.noInvoiceNum = item.futureTickets
|
item.noInvoiceAmount = item.futureTicketsAmount
|
return item
|
})
|
console.log('productData.value ',productData.value )
|
})
|
}else {
|
proxy.resetForm("formRef")
|
productData.value = []
|
}
|
}
|
|
//本次开票失焦操作
|
const invoiceNumBlur = (row) => {
|
if(!row.invoiceNum){
|
row.invoiceNum = 0
|
}
|
if(row.invoiceNum > row.noInvoiceNum){
|
proxy.$modal.msgWarning('本次开票数不得大于未开票数')
|
row.invoiceNum = 0
|
}
|
row.noInvoiceNum = row.futureTickets - row.invoiceNum
|
}
|
// 本次开票金额失焦操作
|
const invoiceAmountBlur = (row) => {
|
if(!row.invoiceAmount){
|
row.invoiceAmount = 0
|
}
|
if(row.invoiceAmount > row.noInvoiceAmount){
|
proxy.$modal.msgWarning('本次开票金额不得大于未开票金额')
|
row.invoiceAmount = 0
|
}
|
row.noInvoiceAmount = row.futureTicketsAmount - row.invoiceAmount
|
}
|
getList()
|
</script>
|
|
<style scoped lang="scss">
|
|
</style>
|
