<!-- from 7 5 2 7 1 8 9 2 0 -->
|
<template>
|
<a-row :gutter="24">
|
<a-col :md="24">
|
<a-card :style="cardStyle" :bordered="false">
|
<!-- 查询区域 -->
|
<div class="table-page-search-wrapper">
|
<a-form layout="inline" @keyup.enter.native="searchQuery">
|
<a-row :gutter="24">
|
<a-col :md="6" :sm="24">
|
<a-form-item label="名称" :labelCol="labelCol" :wrapperCol="wrapperCol">
|
<a-input placeholder="请输入名称" v-model="queryParam.name"></a-input>
|
</a-form-item>
|
</a-col>
|
<a-col :md="6" :sm="24">
|
<a-form-item label="编号" :labelCol="labelCol" :wrapperCol="wrapperCol">
|
<a-input placeholder="请输入编号" v-model="queryParam.serialNo"></a-input>
|
</a-form-item>
|
</a-col>
|
<a-col :md="5" :sm="24">
|
<span class="table-page-search-submitButtons">
|
<a-button type="primary" @click="searchQuery">查询</a-button>
|
<a-button style="margin-left: 8px" v-print="'#reportPrint'" icon="printer">打印</a-button>
|
<a-button style="margin-left: 8px" @click="exportExcel" icon="download">导出</a-button>
|
</span>
|
</a-col>
|
<a-col :md="6" :sm="24">
|
<a-form-item>
|
<span>本月发生总额：{{allMonthAmount}}，当前总余额：{{allCurrentAmount}}</span>
|
</a-form-item>
|
</a-col>
|
</a-row>
|
</a-form>
|
</div>
|
<!-- table区域-begin -->
|
<section ref="print" id="reportPrint">
|
<a-table
|
bordered
|
ref="table"
|
size="middle"
|
rowKey="id"
|
:columns="columns"
|
:dataSource="dataSource"
|
:components="handleDrag(columns)"
|
:pagination="false"
|
:scroll="scroll"
|
:loading="loading"
|
@change="handleTableChange">
|
<span slot="customTitle">
|
<a-popover trigger="click" placement="right">
|
<template slot="content">
|
<a-checkbox-group @change="onColChange" v-model="settingDataIndex" :defaultValue="settingDataIndex">
|
<a-row style="width: 600px">
|
<template v-for="(item,index) in defColumns">
|
<template>
|
<a-col :span="6">
|
<a-checkbox :value="item.dataIndex" v-if="item.dataIndex==='rowIndex'" disabled></a-checkbox>
|
<a-checkbox :value="item.dataIndex" v-if="item.dataIndex!=='rowIndex'">
|
<j-ellipsis :value="item.title" :length="10"></j-ellipsis>
|
</a-checkbox>
|
</a-col>
|
</template>
|
</template>
|
</a-row>
|
<a-row style="padding-top: 10px;">
|
<a-col>
|
恢复默认列配置：<a-button @click="handleRestDefault" type="link" size="small">恢复默认</a-button>
|
</a-col>
|
</a-row>
|
</a-checkbox-group>
|
</template>
|
<a-icon type="setting" />
|
</a-popover>
|
</span>
|
<span slot="action" slot-scope="text, record">
|
<a @click="showAccountInOutList(record)">{{record.id?'流水':''}}</a>
|
</span>
|
</a-table>
|
<a-row :gutter="24" style="margin-top: 8px;text-align:right;">
|
<a-col :md="24" :sm="24">
|
<a-pagination @change="paginationChange" @showSizeChange="paginationShowSizeChange"
|
size="small"
|
show-size-changer
|
:showQuickJumper="true"
|
:current="ipagination.current"
|
:page-size="ipagination.pageSize"
|
:page-size-options="ipagination.pageSizeOptions"
|
:total="ipagination.total"
|
:show-total="(total, range) => `共 ${total-Math.ceil(total/ipagination.pageSize)} 条`">
|
<template slot="buildOptionText" slot-scope="props">
|
<span>{{ props.value-1 }}条/页</span>
|
</template>
|
</a-pagination>
|
</a-col>
|
</a-row>
|
</section>
|
<!-- table区域-end -->
|
<account-in-out-list ref="accountInOutList" @ok="modalFormOk"></account-in-out-list>
|
</a-card>
|
</a-col>
|
</a-row>
|
</template>
|
<script>
|
import AccountInOutList from './modules/AccountInOutList'
|
import { JeecgListMixin } from '@/mixins/JeecgListMixin'
|
import JEllipsis from '@/components/jeecg/JEllipsis'
|
import {getAction} from '@/api/manage'
|
export default {
|
name: "AccountReport",
|
mixins:[JeecgListMixin],
|
components: {
|
AccountInOutList,
|
JEllipsis
|
},
|
data () {
|
return {
|
labelCol: {
|
span: 5
|
},
|
wrapperCol: {
|
span: 18,
|
offset: 1
|
},
|
// 查询条件
|
queryParam: {
|
name:'',
|
serialNo:''
|
},
|
ipagination:{
|
pageSize: 11,
|
pageSizeOptions: ['11', '21', '31', '101', '201']
|
},
|
allMonthAmount: '',
|
allCurrentAmount: '',
|
tabKey: "1",
|
pageName: 'accountReport',
|
// 默认索引
|
defDataIndex:['rowIndex','action','name','serialNo','initialAmount','thisMonthAmount','currentAmount'],
|
// 默认列
|
defColumns: [
|
{
|
dataIndex: 'rowIndex', width:60, align:"center", slots: { title: 'customTitle' },
|
customRender:function (t,r,index) {
|
return (t !== '合计') ? (parseInt(index) + 1) : t
|
}
|
},
|
{ title: '账户流水', dataIndex: 'action', align:"center", width: 120,
|
scopedSlots: { customRender: 'action' }
|
},
|
{ title: '名称', dataIndex: 'name', width: 150},
|
{ title: '编号', dataIndex: 'serialNo', width: 150},
|
{ title: '期初金额', dataIndex: 'initialAmount', sorter: (a, b) => a.initialAmount - b.initialAmount, width: 100},
|
{ title: '本月发生额', dataIndex: 'thisMonthAmount', sorter: (a, b) => a.thisMonthAmount - b.thisMonthAmount, width: 100},
|
{ title: '当前余额', dataIndex: 'currentAmount', sorter: (a, b) => a.currentAmount - b.currentAmount, width: 100}
|
],
|
url: {
|
list: "/account/listWithBalance",
|
getStatistics: "/account/getStatistics"
|
}
|
}
|
},
|
created () {
|
this.getAccountStatistics()
|
this.initColumnsSetting()
|
},
|
methods: {
|
getQueryParams() {
|
let param = Object.assign({}, this.queryParam, this.isorter);
|
param.field = this.getQueryField();
|
param.currentPage = this.ipagination.current;
|
param.pageSize = this.ipagination.pageSize-1;
|
return param;
|
},
|
getAccountStatistics() {
|
getAction(this.url.getStatistics, this.queryParam).then((res)=>{
|
if(res && res.code === 200) {
|
if(res.data){
|
this.allMonthAmount = res.data.allMonthAmount
|
this.allCurrentAmount = res.data.allCurrentAmount
|
}
|
}
|
})
|
},
|
searchQuery() {
|
this.loadData(1);
|
this.getAccountStatistics();
|
},
|
showAccountInOutList(record) {
|
this.$refs.accountInOutList.show(record);
|
this.$refs.accountInOutList.title = "查看账户流水-" + record.name;
|
this.$refs.accountInOutList.disableSubmit = false;
|
},
|
exportExcel() {
|
let list = []
|
let head = '名称,编号,期初金额,本月发生额,当前余额'
|
for (let i = 0; i < this.dataSource.length; i++) {
|
let item = []
|
let ds = this.dataSource[i]
|
item.push(ds.name, ds.serialNo, ds.initialAmount, ds.thisMonthAmount, ds.currentAmount)
|
list.push(item)
|
}
|
let tip = '账户统计查询'
|
this.handleExportXlsPost('账户统计', '账户统计', head, tip, list)
|
}
|
}
|
}
|
</script>
|
<style scoped>
|
@import '~@assets/less/common.less'
|
</style>
|
