index.js

import Api from "~/service/Api";
import Smtsel from "../model";
import Utils from "~/utils";
import exportExcel from '~/page/Frontend/Rcvsel/event/exportExcel.js';
export default {
  mixins: [exportExcel],
  methods: {
    async handleSearch() {
      this.load = true;
      let rtnmsg = await Api.post("/frontend/smtsel/query", {
        ...this.model.smtp,
        pageNum: this.pagenation.pageNum,
        pageSize: this.pagenation.pageSize,
      });
      if (rtnmsg.respCode == SUCCESS) {
        this.load = false;
        this.tableData = [];
        this.tableData = rtnmsg.data.list;
        this.pagenation.pageNum = rtnmsg.data.pageNum || 1
        this.pagenation.pageSize = rtnmsg.data.pageSize || 10
        this.pagenation.total = parseInt(rtnmsg.data.total)
      } else {
        this.$notify.error({
          title: this.$t("financing.错误"),
          message: this.$t("financing.服务请求失败！"),
        });
      }
      this.load = false;
    },
    async handleReset() {
      let resetModel = new Smtsel().data
      Utils.copyValueFromVoData(this.model, resetModel);
      this.handleSearch();
    },
    // pageSize改变
    handleSizeChange(val) {
      this.pagenation.pageNum = 1;
      this.pagenation.pageSize = val;
      this.handleSearch();
    },
    // 页码改变
    handleCurrentChange(val) {
      this.pagenation.pageNum = val;
      this.handleSearch();
    },
    exportToExcel() {
      let codeKeysMap = {
        typ: 'kpatyp'
      };
      let params = {
        ...this.model.smtp,
      }
      let columns = [
        {
          label: "收报日期",
          prop: "recdat",
        },
        {
          label: "起息日期",
          prop: "valdat",
        },
        {
          label: "账户行名称",
          prop: "chnnam",
        },
        {
          label: "BIC",
          prop: "bic",
        },
        {
          label: "帐号",
          prop: "acc",
        },
        {
          label: "币种",
          prop: "cur",
        },
        {
          label: "对账单参考号",
          prop: "ref",
        },
        {
          label: "单编号",
          prop: "smtno",
        },
        {
          label: "期初金额",
          prop: "begamt",
        },
        {
          label: "期末金额",
          prop: "endamt",
        },
        {
          label: "期末可用金额",
          prop: "endvalamt",
        },
        {
          label: "对账单类型",
          prop: "typ",
        },
        {
          label: "页数",
          prop: "pag",
        },
        {
          label: "明细条数",
          prop: "dtl",
        },
      ]
      this.exportExcel(columns, '/frontend/smtsel/exportExcel', params, codeKeysMap, '对账单查询');
    }
  }
}