vue?vxe-table?實(shí)現(xiàn)財(cái)務(wù)記賬憑證的方案
更新時(shí)間：2024年12月09日 08:54:44 作者：可不簡(jiǎn)單
使用?vxe-table?實(shí)現(xiàn)財(cái)務(wù)記賬憑證非常簡(jiǎn)單,實(shí)現(xiàn)在線(xiàn)實(shí)時(shí)編輯的記賬憑證、自動(dòng)合計(jì)金額等,這篇文章主要介紹了vue?vxe-table?實(shí)現(xiàn)財(cái)務(wù)記賬憑證的方案,需要的朋友可以參考下
使用 vxe-table 實(shí)現(xiàn)財(cái)務(wù)記賬憑證非常簡(jiǎn)單，實(shí)現(xiàn)在線(xiàn)實(shí)時(shí)編輯的記賬憑證、自動(dòng)合計(jì)金額等
官網(wǎng)：https://vxetable.cn/
<template>
<div>
<vxe-grid ref="gridRef" v-bind="gridOptions" @edit-closed="editClosedEvent">
<template #toolbarButtons>
<vxe-button status="primary" @click="addEvent">新增</vxe-button>
<vxe-button status="success" @click="saveEvent">保存</vxe-button>
</template>
</vxe-grid>
<div ref="bottomElemRef" style="display: flex;padding: 8px;">
<div style="width: 25%;">財(cái)務(wù)主管：小徐</div>
<div style="width: 25%;">記賬：張三</div>
<div style="width: 25%;">出納：李四</div>
<div style="width: 25%;">審核：老六</div>
</div>
</div>
</template>
<script>
import { VxeUI } from 'vxe-table'
import XEUtils from 'xe-utils'
export default {
data () {
const footerRow = {
seq: '合計(jì)',
debtorObj: {},
creditObj: {}
}
const gridOptions = {
border: true,
showOverflow: true,
showFooter: true,
keepSource: true,
height: 600,
printConfig: {
beforePrintMethod: ({ html }) => {
const topEl = this.$refs.topElemRef
const topHtml = topEl ? topEl.outerHTML : ''
const bottomEl = this.$refs.bottomElemRef
const bottomHtml = bottomEl ? bottomEl.outerHTML : ''
return `${topHtml}${html}${bottomHtml}`
}
},
exportConfig: {},
columnConfig: {
resizable: true
},
toolbarConfig: {
export: true,
print: true,
slots: {
buttons: 'toolbarButtons'
}
},
mouseConfig: {
area: true,
extension: false
},
editConfig: {
mode: 'cell',
trigger: 'dblclick',
showStatus: true
},
keyboardConfig: {
isClip: true,
arrowCursorLock: true,
isArrow: true,
isShift: true,
isTab: true,
isEnter: true,
isEdit: true,
isBack: true,
isDel: true,
isEsc: true,
isFNR: true // 是否開(kāi)啟查找與替換
},
data: [],
footerData: [
footerRow
],
columns: [
{ field: 'seq', type: 'seq', width: 60 },
{ field: 'summary', title: '摘要', minWidth: 120, editRender: { name: 'VxeInput' } },
{ field: 'subject', title: '會(huì)計(jì)科目', minWidth: 180, editRender: { name: 'VxeInput' } },
{
field: 'debtorAmount',
title: '借方金額',
children: [
{ field: 'debtorObj.p9', title: '億', width: 60, align: 'center', editRender: { name: 'VxeNumberInput', props: { type: 'integer', max: 9, controls: false, maxLength: 1, align: 'center' } } },
{ field: 'debtorObj.p8', title: '千', width: 60, align: 'center', editRender: { name: 'VxeNumberInput', props: { type: 'integer', max: 9, controls: false, maxLength: 1, align: 'center' } } },
{ field: 'debtorObj.p7', title: '百', width: 60, align: 'center', editRender: { name: 'VxeNumberInput', props: { type: 'integer', max: 9, controls: false, maxLength: 1, align: 'center' } } },
{ field: 'debtorObj.p6', title: '十', width: 60, align: 'center', editRender: { name: 'VxeNumberInput', props: { type: 'integer', max: 9, controls: false, maxLength: 1, align: 'center' } } },
{ field: 'debtorObj.p5', title: '萬(wàn)', width: 60, align: 'center', editRender: { name: 'VxeNumberInput', props: { type: 'integer', max: 9, controls: false, maxLength: 1, align: 'center' } } },
{ field: 'debtorObj.p4', title: '千', width: 60, align: 'center', editRender: { name: 'VxeNumberInput', props: { type: 'integer', max: 9, controls: false, maxLength: 1, align: 'center' } } },
{ field: 'debtorObj.p3', title: '百', width: 60, align: 'center', editRender: { name: 'VxeNumberInput', props: { type: 'integer', max: 9, controls: false, maxLength: 1, align: 'center' } } },
{ field: 'debtorObj.p2', title: '十', width: 60, align: 'center', editRender: { name: 'VxeNumberInput', props: { type: 'integer', max: 9, controls: false, maxLength: 1, align: 'center' } } },
{ field: 'debtorObj.p1', title: '元', width: 60, align: 'center', editRender: { name: 'VxeNumberInput', props: { type: 'integer', max: 9, controls: false, maxLength: 1, align: 'center' } } },
{ field: 'debtorObj.m1', title: '角', width: 60, align: 'center', editRender: { name: 'VxeNumberInput', props: { type: 'integer', max: 9, controls: false, maxLength: 1, align: 'center' } } },
{ field: 'debtorObj.m2', title: '分', width: 60, align: 'center', editRender: { name: 'VxeNumberInput', props: { type: 'integer', max: 9, controls: false, maxLength: 1, align: 'center' } } }
]
},
{ field: 'x1', title: '√', width: 40 },
{
field: 'creditAmount',
title: '貸方金額',
children: [
{ field: 'creditObj.p9', title: '億', width: 60, align: 'center', editRender: { name: 'VxeNumberInput', props: { type: 'integer', max: 9, controls: false, maxLength: 1, align: 'center' } } },
{ field: 'creditObj.p8', title: '千', width: 60, align: 'center', editRender: { name: 'VxeNumberInput', props: { type: 'integer', max: 9, controls: false, maxLength: 1, align: 'center' } } },
{ field: 'creditObj.p7', title: '百', width: 60, align: 'center', editRender: { name: 'VxeNumberInput', props: { type: 'integer', max: 9, controls: false, maxLength: 1, align: 'center' } } },
{ field: 'creditObj.p6', title: '十', width: 60, align: 'center', editRender: { name: 'VxeNumberInput', props: { type: 'integer', max: 9, controls: false, maxLength: 1, align: 'center' } } },
{ field: 'creditObj.p5', title: '萬(wàn)', width: 60, align: 'center', editRender: { name: 'VxeNumberInput', props: { type: 'integer', max: 9, controls: false, maxLength: 1, align: 'center' } } },
{ field: 'creditObj.p4', title: '千', width: 60, align: 'center', editRender: { name: 'VxeNumberInput', props: { type: 'integer', max: 9, controls: false, maxLength: 1, align: 'center' } } },
{ field: 'creditObj.p3', title: '百', width: 60, align: 'center', editRender: { name: 'VxeNumberInput', props: { type: 'integer', max: 9, controls: false, maxLength: 1, align: 'center' } } },
{ field: 'creditObj.p2', title: '十', width: 60, align: 'center', editRender: { name: 'VxeNumberInput', props: { type: 'integer', max: 9, controls: false, maxLength: 1, align: 'center' } } },
{ field: 'creditObj.p1', title: '元', width: 60, align: 'center', editRender: { name: 'VxeNumberInput', props: { type: 'integer', max: 9, controls: false, maxLength: 1, align: 'center' } } },
{ field: 'creditObj.m1', title: '角', width: 60, align: 'center', editRender: { name: 'VxeNumberInput', props: { type: 'integer', max: 9, controls: false, maxLength: 1, align: 'center' } } },
{ field: 'creditObj.m2', title: '分', width: 60, align: 'center', editRender: { name: 'VxeNumberInput', props: { type: 'integer', max: 9, controls: false, maxLength: 1, align: 'center' } } }
]
},
{ field: 'x2', title: '√', width: 40 }
]
}
return {
gridOptions,
footerRow
}
},
methods: {
handleSpitAmount (amount, isUnit) {
const str = XEUtils.toValueString(XEUtils.toNumber(amount) || '')
const [pStr, mStr] = `${isUnit ? '￥' : ''}${str}`.split('.')
const restObj = {
p9: '',
p8: '',
p7: '',
p6: '',
p5: '',
p4: '',
p3: '',
p2: '',
p1: '',
m1: '',
m2: ''
}
if (pStr) {
pStr.split('').reverse().forEach((val, i) => {
restObj[`p${i + 1}`] = `${val || 0}`
})
}
if (mStr) {
mStr.split('').forEach((val, i) => {
restObj[`m${i + 1}`] = `${val || 0}`
})
}
return restObj
},
handleJoinAmount (obj) {
const strArr = [obj.p9 || 0, obj.p8 || 0, obj.p7 || 0, obj.p6 || 0, obj.p5 || 0, obj.p4 || 0, obj.p3 || 0, obj.p2 || 0, obj.p1 || 0, '.', obj.m2 || 0, obj.m1 || 0]
return XEUtils.toNumber(strArr.join(''))
},
handleData (list) {
return list.map(item => {
return {
...item,
debtorObj: this.handleSpitAmount(item.debtorAmount, false),
creditObj: this.handleSpitAmount(item.creditAmount, false)
}
})
},
loadList (list) {
this.gridOptions.data = this.handleData(list)
this.$nextTick(() => {
this.updateFooter()
})
},
updateFooter () {
this.$nextTick(() => {
const $grid = this.$refs.gridRef
if ($grid) {
const { visibleData } = $grid.getTableData()
let countDebtorAmount = 0
let countCreditAmount = 0
visibleData.forEach(row => {
row.debtorAmount = this.handleJoinAmount(row.debtorObj)
row.creditAmount = this.handleJoinAmount(row.creditObj)
countDebtorAmount += row.debtorAmount
countCreditAmount += row.creditAmount
})
this.footerRow.debtorObj = this.handleSpitAmount(countDebtorAmount, true)
this.footerRow.creditObj = this.handleSpitAmount(countCreditAmount, true)
}
})
},
async addEvent () {
const $grid = this.$refs.gridRef
if ($grid) {
const record = {}
await $grid.insertAt(record, -1)
this.updateFooter()
}
},
saveEvent () {
const $grid = this.$refs.gridRef
if ($grid) {
const { visibleData } = $grid.getTableData()
const rest = visibleData.map(item => {
return {
id: item.id,
summary: item.summary,
subject: item.subject,
debtorAmount: this.handleJoinAmount(item.debtorObj),
creditAmount: this.handleJoinAmount(item.creditObj)
}
})
VxeUI.modal.message({
content: '保存成功',
status: 'success'
})
this.loadList(rest)
console.log(rest)
}
},
editClosedEvent () {
this.updateFooter()
}
},
created () {
const list = [
{ id: 10001, summary: '購(gòu)買(mǎi)辦公用品', subject: '辦公費(fèi)', debtorAmount: 120000, creditAmount: 0 },
{ id: 10002, summary: '購(gòu)買(mǎi)辦公用品', subject: '庫(kù)存現(xiàn)金', debtorAmount: 0, creditAmount: 120000 }
]
this.loadList(list)
}
}
</script>https://gitee.com/x-extends/vxe-table
到此這篇關(guān)于vue vxe-table 實(shí)現(xiàn)財(cái)務(wù)記賬憑證的方案的文章就介紹到這了,更多相關(guān)vue vxe-table 記賬憑證內(nèi)容請(qǐng)搜索腳本之家以前的文章或繼續(xù)瀏覽下面的相關(guān)文章希望大家以后多多支持腳本之家！
相關(guān)文章
這篇文章主要介紹了在springboot中使用p6spy方式,具有很好的參考價(jià)值,希望對(duì)大家有所幫助,如有錯(cuò)誤或未考慮完全的地方,望不吝賜教2024-01-01
Spring零基礎(chǔ)入門(mén)WebFlux響應(yīng)式編程
Spring 提供了兩個(gè)并行堆棧，一種是基于帶有 Spring MVC 和 Spring Data 結(jié)構(gòu)的 Servlet API，另一個(gè)是完全反應(yīng)式堆棧，它利用了 Spring WebFlux 和 Spring Data 的反應(yīng)式存儲(chǔ)庫(kù)，這篇文章主要介紹了Spring-webflux 響應(yīng)式編程,需要的朋友可以參考下2022-10-10
Java Swing最詳細(xì)基礎(chǔ)知識(shí)總結(jié)
這篇文章主要介紹了Java Swing最詳細(xì)基礎(chǔ)知識(shí)總結(jié),文中有非常詳細(xì)的代碼示例,對(duì)正在學(xué)習(xí)Java Swing的小伙伴們有很好的幫助,需要的朋友可以參考下2021-05-05
Java實(shí)現(xiàn)基于NIO的多線(xiàn)程Web服務(wù)器實(shí)例
在本篇文章里小編給大家整理的是關(guān)于Java實(shí)現(xiàn)基于NIO的多線(xiàn)程Web服務(wù)器實(shí)例內(nèi)容，需要的朋友們可以學(xué)習(xí)下。2020-03-03
Java對(duì)文本文件MD5加密并ftp傳送到遠(yuǎn)程主機(jī)目錄的實(shí)現(xiàn)方法
這篇文章主要給大家介紹了關(guān)于Java對(duì)文本文件MD5加密并ftp傳送到遠(yuǎn)程主機(jī)目錄的實(shí)現(xiàn)方法，文中通過(guò)示例代碼介紹的非常詳細(xì)，對(duì)大家的學(xué)習(xí)或者工作具有一定的參考學(xué)習(xí)價(jià)值，需要的朋友們下面隨著小編來(lái)一起學(xué)習(xí)學(xué)習(xí)吧2018-08-08
Springboot居然可以設(shè)置動(dòng)態(tài)的Banner(推薦)
這篇文章主要介紹了Springboot居然可以設(shè)置動(dòng)態(tài)的Banner,本文給大家介紹的非常詳細(xì)，對(duì)大家的學(xué)習(xí)或工作具有一定的參考借鑒價(jià)值，需要的朋友可以參考下2021-03-03
Java UrlRewriter偽靜態(tài)技術(shù)運(yùn)用深入分析
通常我們?yōu)榱烁玫木徑夥?wù)器壓力,和增強(qiáng)搜索引擎的友好面，都將文章內(nèi)容生成靜態(tài)頁(yè)面,這就產(chǎn)生了偽靜態(tài)技術(shù)，也就是我們常說(shuō)的Url Rewriter重寫(xiě)技術(shù)2012-12-12
Java7之forkjoin簡(jiǎn)介_(kāi)動(dòng)力節(jié)點(diǎn)Java學(xué)院整理
Java7引入了Fork Join的概念，來(lái)更好的支持并行運(yùn)算。接下來(lái)通過(guò)本文給大家分享Java7之forkjoin簡(jiǎn)介，感興趣的朋友一起看看吧2017-06-06
java8新特性 stream流的方式遍歷集合和數(shù)組操作
這篇文章主要介紹了java8新特性 stream流的方式遍歷集合和數(shù)組操作，具有很好的參考價(jià)值，希望對(duì)大家有所幫助。一起跟隨小編過(guò)來(lái)看看吧2020-08-08
Java動(dòng)態(tài)追蹤技術(shù)探究之從JSP到Arthas
這篇文章主要介紹了Java動(dòng)態(tài)追蹤技術(shù)探究之從JSP到Arthas,文中通過(guò)示例代碼介紹的非常詳細(xì)，對(duì)大家的學(xué)習(xí)或者工作具有一定的參考學(xué)習(xí)價(jià)值，,需要的朋友可以參考下2019-06-06