<template>
<div class="eibs-tab">
<el-form class="m-table-search-form" :rules="rules" ref="BcrincForm" label-position="right" label-width="110px" size="small" :model="model">
<!-- ==================左边================ -->
<c-col :span="12" style="padding-right: 20px;">
<c-col :span="24" >
<el-form-item label="国际/国内报表" prop="bcrinc.dlselect">
<c-select v-model="model.bcrinc.dlselect" style="width:100%" dbCode="DFLG" placeholder="">
</c-select>
</el-form-item>
</c-col>
<c-col :span="24">
<el-form-item label="统计分类" prop="bcrinc.statisticsort" >
<c-select @change="statisticsort" v-model="model.bcrinc.statisticsort" :code="StatisticSortList" :filterKey="filterSort" style="width:100%" placeholder="">
</c-select>
</el-form-item>
</c-col>
<c-col :span="24">
<el-form-item label="选择交易类型" prop="bcrinc.sector">
<c-select @change="Onsector" :disabled="isSector" v-model="model.bcrinc.sector" dbCode="bustxt" :filterKey="filterSector" style="width:100%" placeholder="" >
</c-select>
</el-form-item>
</c-col>
<c-col :span="24">
<el-form-item label="Reference No." prop="bcrinc.selref" >
<c-input
@keyup.enter.native="Onselref"
@blur="Onselref"
@change="clearRef"
:disabled="!model.bcrinc.sector || model.bcrinc.sector=='GE'" v-model="model.bcrinc.selref" maxlength="40" placeholder="">
</c-input>
</el-form-item>
</c-col>
<c-col :span="24">
<el-form-item label="Name" prop="bcrinc.selnam" >
<c-input disabled v-model="model.bcrinc.selnam" maxlength="40" placeholder="">
</c-input>
</el-form-item>
</c-col>
</c-col>
<!-- ============右边================= -->
<c-col :span="12" style="padding-left: 20px;">
<c-col :span="24">
<el-form-item label="日期" style="width: 100%">
<c-col :span="11">
<c-date-picker type="date" v-model="model.bcrinc.begdat" style="width: 100%" placeholder="请选择起始日期" value-format="yyyy-MM-dd"></c-date-picker>
</c-col>
<c-col :span="2" style="text-align: center">
<label style="display: inline-block; width: 100%">-</label>
</c-col>
<c-col :span="11">
<c-date-picker type="date" v-model="model.bcrinc.enddat" style="width: 100%" placeholder="请选择截止日期" value-format="yyyy-MM-dd"></c-date-picker>
</c-col>
</el-form-item>
</c-col>
<c-col :span="24">
<el-form-item label="业务所属机构" prop="bcrinc.branch" >
<c-select v-model="model.bcrinc.branch" style="width:100%" placeholder="请选择业务所属机构" :clearable="true">
<el-option v-for="item in bchlst" :key="item.inr" :value ="item.branch" :label="item.branch + '-' + item.bchname">
</el-option>
</c-select>
</el-form-item>
</c-col>
<c-col :span="24">
<el-form-item label="收费状态" prop="bcrinc.feestatus"
:rules="[
{required: 'f|c|b|d'.indexOf(model.bcrinc.statisticsort) >= 0, message: '必输项', trigger:['blur','change'] },
]"
>
<c-select :disabled="'f|c|b|d'.indexOf(model.bcrinc.statisticsort) < 0 " v-model="model.bcrinc.feestatus" style="width:100%" dbCode="FEESTA" placeholder="" >
</c-select>
</el-form-item>
</c-col>
<c-col :span="24" v-if="model.bcrinc.statisticsort=='f'">
<el-form-item label="费用类型" prop="bcrinc.cod" >
<c-select v-model="model.bcrinc.cod" style="width:100%" placeholder="" :isShowKeyAndLabel="true" dbCode="FEETXT">
</c-select>
</el-form-item>
</c-col>
<c-col :span="24" v-if="model.bcrinc.statisticsort=='d'">
<el-form-item label="客户经理" prop="bcrinc.usr" >
<c-input disabled v-model="model.bcrinc.usr" maxlength="40" placeholder="">
</c-input>
</el-form-item>
</c-col>
<c-col :span="24" v-if="'c|l|g|o'.indexOf(model.bcrinc.statisticsort) >= 0">
<el-form-item label="选择客户" prop="bcrinc.extkey" >
<c-input @keyup.enter.native="Onextkey"
@blur="Onextkey"
@change="clearExtkey"
v-model="model.bcrinc.extkey" maxlength="40" placeholder="">
</c-input>
</el-form-item>
</c-col>
<c-col :span="24" v-if="'c|l|g|o'.indexOf(model.bcrinc.statisticsort) >= 0">
<el-form-item label="Name of Party" prop="bcrinc.nam1" >
<c-input disabled v-model="model.bcrinc.nam1" maxlength="40" placeholder="">
</c-input>
</el-form-item>
</c-col>
<c-col :span="24" v-if="(model.bcrinc.sector=='GI')||(model.bcrinc.sector=='GC')">
<el-form-item label="保函类型" prop="bcrinc.gartyp">
<c-select v-model="model.bcrinc.gartyp" style="width:100%" placeholder="" dbCode='GARTYP'>
</c-select>
</el-form-item>
</c-col>
<c-col :span="24">
<c-col :span="12" style="text-align: right">
<el-button size="small" @click="handleReset">重置</el-button>
<el-button type="primary" icon="el-icon-export" size="small" @click="BcrexportExcel()">导出报表
</el-button>
</c-col>
</c-col>
</c-col>
</el-form>
<el-dialog
v-if="initdialog"
:visible.sync="initdialog"
title="客户信息"
append-to-body
width="70%"
>
<div style="height: 90%">
<c-col :span="24">
<el-table
:data="stmData.data"
size="small"
height="calc(100vh - 390px)"
:border="true"
:highlight-current-row="true"
@row-dblclick="TableDblRow"
>
<el-table-column
v-for="(item, key) in stmData.columns"
:key="key"
:label="item.label"
:prop="item.prop"
:min-width="item.width"
>
</el-table-column>
</el-table>
<div class="pagination-box">
<el-pagination
style="margin-right: 30px;"
@size-change="handleSizeChange"
@current-change="handleCurrentChange"
:current-page.sync="pagination.pageIndex"
:page-sizes="[10, 20, 50, 100, 500]"
:page-size="pagination.pageSize"
layout="total, sizes, prev, pager, next, jumper"
:total="pagination.total">
</el-pagination>
</div>
</c-col>
</div>
</el-dialog>
<el-dialog
v-if="trninitdialog"
:visible.sync="trninitdialog"
title="业务信息"
append-to-body
width="70%"
>
<div style="height: 90%">
<c-col :span="24">
<el-table
:data="stmDatatrn.data"
size="small"
height="calc(100vh - 390px)"
:border="true"
:highlight-current-row="true"
@row-dblclick="TableDblRowtrn"
>
<el-table-column
v-for="(item, key) in stmDatatrn.columns"
:key="key"
:label="item.label"
:prop="item.prop"
:min-width="item.width"
>
</el-table-column>
</el-table>
<div class="pagination-box">
<el-pagination
style="margin-right: 30px;"
@size-change="handleSizeChange"
@current-change="handleCurrentChange"
:current-page.sync="pagination.pageIndex"
:page-sizes="[10, 20, 50, 100, 500]"
:page-size="pagination.pageSize"
layout="total, sizes, prev, pager, next, jumper"
:total="pagination.total">
</el-pagination>
</div>
</c-col>
</div>
</el-dialog>
</div>
</template>
<script>
import Api from "~/service/Api";
import CodeTable from "~/config/CodeTable";
import event from "../event";
import Check from "../model/check";
export default {
inject: ["root"],
props: ["model", "codes"],
mixins: [event,Check],
data() {
return {
// 客户信息表格相关
stmData: {
columns: [
{
label: '客户号',
prop: 'extkey',
width:'180px',
isShow: true
},
{
label: '客户名称',
prop: 'nam',
width:'250px',
isShow: true
},
{
label: '客户中文名称',
prop: 'nam1',
width:'150px',
isShow: true
},
{
label: '类型',
prop: 'ptytyp',
width:'150px',
isShow: true
},
],
data: [],
},
// 业务信息表格相关
stmDatatrn: {
columns: [
{
label: '业务编号',
prop: 'ownref',
width:'180px',
isShow: true
},
{
label: '日期',
prop: 'inidattim',
width:'150px',
isShow: true
},
{
label: 'Name',
prop: 'objnam',
width:'150px',
isShow: true
},
{
label: '经办柜员',
prop: 'usr',
width:'150px',
isShow: true
},
],
data: [],
},
pagination: {
pageIndex: 1,
pageSize: 10,
total: 0
},
// 处理
initdialog: false,
trninitdialog: false,
bchlst:[],
//临时码表
StatisticSortList:[
{ label: "按收益汇总", value: "f" },
{ label: "按客户汇总", value: "c" },
{ label: "按分支机构汇总", value: "b" },
{ label: "按客户经理汇总", value: "d" },
{ label: "进口信用证保证金及额度", value: "l" },
{ label: "进口保函保证金及额度", value: "g" },
{ label: "进口信用证承兑余额", value: "o" },
{ label: "国内信用证保证金和额度", value: "m" },
{ label: "国内信用证余额报表", value: "n" },
{ label: "国内信用证承兑余额", value: "p" },
],
sectorList:[
{ label: "Guarantee", value: "GI" },
{ label: "Guarantee Claim", value: "GC" },
{ label: "出口保函", value: "GE" },
],
isSector:false,
//进口保函保证金及额度
limitColumns:[
{
prop: "extkey",
label: "客户号",
},
{
prop: "nam1",
label: "客户名称",
},
{
prop: "ownref",
label: "交易编号",
},
{
prop: "inifrm",
label: "交易代码",
},
{
prop: "cbecur",
label: "交易币别",
},
{
prop: "cbeamt",
label: "交易金额",
},
{
prop: "xrfamt",
label: "保函金额折美元",
},
{
prop: "opndat",
label: "开立日期",
},
{
prop: "expdat",
label: "到期日",
},
{
prop: "cshpct",
label: "应收保证金比例(%)",
},
{
prop: "limcur",
label: "额度币别",
},
{
prop: "limamt",
label: "额度余额",
},
{
prop: "gartyp",
label: "保函类型",
},
{
prop: "ptsnam",
label: "受益人",
},
{
prop: "cbeacc",
label: "保证金账号",
},
{
prop: "cbbamt",
label: "保证金余额",
},
{
prop: "clsdat",
label: "保函注销日",
},
{
prop: "fingua",
label: "是否对外担保",
},
{
prop: "cfaguatyp",
label: "担保类型",
},
],
//信用证保证金及额度
lidlimitColumns:[
{
prop: "extkey",
label: "客户号",
},
{
prop: "nam1",
label: "客户名称",
},
{
prop: "ownref",
label: "交易编号",
},
{
prop: "inifrm",
label: "交易代码",
},
{
prop: "cbecur",
label: "交易币别",
},
{
prop: "cbeamt",
label: "交易金额",
},
{
prop: "opndat",
label: "开立日期",
},
{
prop: "expdat",
label: "到期日",
},
{
prop: "cshpct",
label: "应收保证金比例(%)",
},
{
prop: "limcur",
label: "额度币别",
},
{
prop: "limamt",
label: "额度余额",
},
],
//按收益汇总
incomeColumns:[
{
prop: "fepnam",
label: "费用类型",
type:"all"
},
{
prop: "ownref",
label: "业务编号",
type:"all"
},
{
prop: "gartyp",
label: "保函类型",
type:"GI"
},
{
prop: "gartyp",
label: "保函类型",
type:"GE"
},
{
prop: "gartyp",
label: "保函类型",
type:"GC"
},
{
prop: "gartyp",
label: "保函类型",
type:"NI"
},
{
prop: "gartyp",
label: "保函类型",
type:"NE"
},
{
prop: "gartyp",
label: "保函类型",
type:"NC"
},
{
prop: "srcdat",
label: "费用产生日期",
type:"all"
},
{
prop: "cpldattim",
label: "收费日期",
type:"Y"
},
{
prop: "dat1",
label: "计费开始日期",
type:"all"
},
{
prop: "dat2",
label: "计费结束日期",
type:"all"
},
{
prop: "untamt",
label: "费用",
type:"all"
},
{
prop: "ratcal",
label: "费率",
type:"all"
},
{
prop: "fepcur",
label: "费用币种",
type:"all"
},
{
prop: "ogiamt",
label: "应收金额",
type:"Y"
},
{
prop: "dctamt",
label: "优惠金额",
type:"Y"
},
{
prop: "fepamt",
label: "实收金额",
type:"Y"
},
{
prop: "fepamt",
label: "应收金额",
type:"N"
},
{
prop: "xrfcur",
label: "折算币种",
type:"all"
},
{
prop: "xrfamt",
label: "折算金额",
type:"all"
},
{
prop: "extkey",
label: "客户号",
type:"all"
},
{
prop: "nam1",
label: "客户名称",
type:"all"
},
{
prop: "branch",
label: "机构号",
type:"all"
},
{
prop: "bchname",
label: "机构名称",
type:"all"
},
{
prop: "fingua",
label: "是否融资",
type:"all"
},
{
prop: "fenlishi",
label: "是否分离式",
type:"all"
},
],
//按客户汇总
ptyincomeColumns:[
{
prop: "extkey",
label: "客户号",
type:"all"
},
{
prop: "nam1",
label: "客户名称",
type:"all"
},
{
prop: "branch",
label: "机构号",
type:"all"
},
{
prop: "bchname",
label: "机构名称",
type:"all"
},
{
prop: "ownref",
label: "业务编号",
type:"all"
},
{
prop: "tenmaxday",
label: "信用证期限",
type:"LI"
},
{
prop: "tenmaxday",
label: "信用证期限",
type:"LE"
},
{
prop: "srcdat",
label: "费用产生日期",
type:"all"
},
{
prop: "cpldattim",
label: "收费日期",
type:"Y"
},
{
prop: "dat1",
label: "计费开始日期",
type:"all"
},
{
prop: "dat2",
label: "计费结束日期",
type:"all"
},
{
prop: "fepnam",
label: "费用类型",
type:"all"
},
{
prop: "untamt",
label: "费用",
type:"all"
},
{
prop: "ratcal",
label: "费率",
type:"all"
},
{
prop: "fepcur",
label: "费用币种",
type:"all"
},
{
prop: "ogiamt",
label: "应收金额",
type:"Y"
},
{
prop: "dctamt",
label: "优惠金额",
type:"Y"
},
{
prop: "fepamt",
label: "实收金额",
type:"Y"
},
{
prop: "fepamt",
label: "应收金额",
type:"N"
},
{
prop: "xrfcur",
label: "折算币种",
type:"all"
},
{
prop: "xrfamt",
label: "折算金额",
type:"all"
},
],
//按分支机构汇总
bchincomeColumns:[
{
prop: "branch",
label: "机构号",
type:"all"
},
{
prop: "bchname",
label: "机构名称",
type:"all"
},
{
prop: "extkey",
label: "客户号",
type:"all"
},
{
prop: "nam1",
label: "客户名称",
type:"all"
},
{
prop: "ownref",
label: "业务编号",
type:"all"
},
{
prop: "tenmaxday",
label: "信用证期限",
type:"LI"
},
{
prop: "tenmaxday",
label: "信用证期限",
type:"LE"
},
{
prop: "usr",
label: "客户经理",
type:"all"
},
{
prop: "srcdat",
label: "费用产生日期",
type:"all"
},
{
prop: "cpldattim",
label: "收费日期",
type:"Y"
},
{
prop: "dat1",
label: "计费开始日期",
type:"all"
},
{
prop: "dat2",
label: "计费结束日期",
type:"all"
},
{
prop: "fepnam",
label: "费用类型",
type:"all"
},
{
prop: "untamt",
label: "费用",
type:"all"
},
{
prop: "ratcal",
label: "费率",
type:"all"
},
{
prop: "fepcur",
label: "费用币种",
type:"all"
},
{
prop: "ogiamt",
label: "应收金额",
type:"Y"
},
{
prop: "dctamt",
label: "优惠金额",
type:"Y"
},
{
prop: "fepamt",
label: "实收金额",
type:"Y"
},
{
prop: "fepamt",
label: "应收金额",
type:"N"
},
{
prop: "xrfcur",
label: "折算币种",
type:"all"
},
{
prop: "xrfamt",
label: "折算金额",
type:"all"
},
],
//按客户经理汇总
usrincomeColumns:[
{
prop: "usr",
label: "客户经理",
type:"all"
},
{
prop: "extkey",
label: "客户号",
type:"all"
},
{
prop: "nam1",
label: "客户名称",
type:"all"
},
{
prop: "ownref",
label: "业务编号",
type:"all"
},
{
prop: "tenmaxday",
label: "信用证期限",
type:"LI"
},
{
prop: "tenmaxday",
label: "信用证期限",
type:"LE"
},
{
prop: "srcdat",
label: "费用产生日期",
type:"all"
},
{
prop: "cpldattim",
label: "收费日期",
type:"Y"
},
{
prop: "dat1",
label: "计费开始日期",
type:"all"
},
{
prop: "dat2",
label: "计费结束日期",
type:"all"
},
{
prop: "fepnam",
label: "费用类型",
type:"all"
},
{
prop: "untamt",
label: "费用",
type:"all"
},
{
prop: "ratcal",
label: "费率",
type:"all"
},
{
prop: "fepcur",
label: "费用币种",
type:"all"
},
{
prop: "ogiamt",
label: "应收金额",
type:"Y"
},
{
prop: "dctamt",
label: "优惠金额",
type:"Y"
},
{
prop: "fepamt",
label: "实收金额",
type:"Y"
},
{
prop: "fepamt",
label: "应收金额",
type:"N"
},
{
prop: "xrfcur",
label: "折算币种",
type:"all"
},
{
prop: "xrfamt",
label: "折算金额",
type:"all"
},
{
prop: "branch",
label: "机构号",
type:"all"
},
{
prop: "bchname",
label: "机构名称",
type:"all"
},
],
//进口信用证承兑余额报表
lidudpopnColumns:[
{
prop: "opndat",
label: "开证日期",
},
{
prop: "ownref",
label: "信用证编号",
},
{
prop: "aplnam",
label: "开证申请人",
},
{
prop: "bennam",
label: "开证受益人",
},
{
prop: "cur",
label: "币种",
},
{
prop: "amt",
label: "信用证金额",
},
{
prop: "lb1xrfamt",
label: "信用证金额折美元",
},
{
prop: "allnom",
label: "溢短装",
},
{
prop: "expdat",
label: "效期",
},
{
prop: "expplc",
label: "效地",
},
{
prop: "rptref",
label: "合同号",
},
{
prop: "tenmaxday",
label: "付款期限",
},
{
prop: "tenmaxday",
label: "保证金当前余额",
},
{
prop: "sumxrfamt",
label: "保证金当前余额",
},
{
prop: "nompct",
label: "保证金实收比例",
},
{
prop: "cpldattim",
label: "承兑日期",
},
{
prop: "bbamt",
label: "承兑金额",
},
{
prop: "matdat",
label: "承兑到期日",
},
{
prop: "bbopnamt",
label: "承兑余额",
},
{
prop: "payamt",
label: "付款金额",
},
{
prop: "paydat",
label: "付款日期",
},
{
prop: "avbby",
label: "付款方式",
},
{
prop: "remark",
label: "备注",
},
],
//国内信用证承兑余额报表
didudpopnColumns:[
{
prop: "opndat",
label: "开证日期",
},
{
prop: "ownref",
label: "信用证编号",
},
{
prop: "aplnam",
label: "开证申请人",
},
{
prop: "bennam",
label: "开证受益人",
},
{
prop: "cur",
label: "币种",
},
{
prop: "amt",
label: "信用证金额",
},
{
prop: "lb1xrfamt",
label: "信用证金额折美元",
},
{
prop: "allnom",
label: "溢短装",
},
{
prop: "expdat",
label: "效期",
},
{
prop: "rptref",
label: "合同号",
},
{
prop: "tenmaxday",
label: "付款期限",
},
{
prop: "sumxrfamt",
label: "保证金当前余额",
},
{
prop: "nompct",
label: "保证金实收比例",
},
{
prop: "cpldattim",
label: "承兑日期",
},
{
prop: "bbamt",
label: "承兑金额",
},
{
prop: "matdat",
label: "承兑到期日",
},
{
prop: "bbopnamt",
label: "承兑余额",
},
{
prop: "payamt",
label: "付款金额",
},
{
prop: "paydat",
label: "付款日期",
},
{
prop: "avbby",
label: "付款方式",
},
{
prop: "remark",
label: "备注",
},
],
//国内信用证余额报表导出列
didopnamtColumns: [
{
prop: "ownref",
label: "交易编号",
width: 170,
isShow: true
},
{
prop: "cur",
label: "币种",
width: 70,
isShow: true
},
{
prop: "maxamt",
label: "开立金额",
width: 150,
isShow: true
},
{
prop: "opnamt",
label: "余额",
isShow: true,
width: 150
},
{
prop: "expdat",
label: "到期日",
isShow: true,
width: 100
},
{
prop: "ptyextkey",
label: "客户号",
isShow: true,
width: 150
},
{
prop: "ptynam",
label: "客户名称",
isShow: true,
width: 200
}
],
};
},
computed: {
filterSort(){
let filter = []
if(this.model.bcrinc.dlselect == '2'){
filter = ['f','c','b','d','m','n','p']
}else{
filter = ['f','c','b','d','l','g','o']
}
if('l|g|m|n|o|p'.indexOf(this.model.bcrinc.statisticsort) >= 0){
this.model.bcrinc.sector = ''
this.isSector = true;
}else{
this.isSector = false;
}
return filter;
},
filterSector(){
let filter =[]
if(this.model.bcrinc.dlselect == '2'){
filter = ['BP','CL','FC','CC','CP','BO','LT','GI','GC','BC','TR','MC','RM','RC','BT','DF','GE','JS','DI','BD','DE','BF','WI']
}else{
filter = ['BP','CL','FC','CC','CP','BO','LE','BE','LT','GI','GC','BC','LI','BR','TR','MC','RM','RC','BT','DF','GE','YS','JS','DI','BD','DE','BF','WI']
}
}
},
methods: {
},
mounted() {
this.getBranchList();
},
created: function() {}
};
</script>
<style scoped>
</style>