yanshouban/src/views/online/reportDownload/index.vue

<template>
  <div style="background-color:#f7f7f7;padding:10px 10px;">
    <div class="zhuti">
      <div style="height:58px;line-height:58px;">
        <div style="color:#0006"> <span>交易联机</span> <span style="padding:0 5px;">></span> <span
            style="color:#000000e6">报表下载</span></div>
      </div>
      <div>
        <div class="formSearch">
          <el-form
            :inline="true"
            :model="pageindex"
            label-position="left"
          >
            <el-form-item label="支付状态">
              <el-select
                v-model="pageindex.payState"
                placeholder="请选择"
                style="width: 168px;"
              >
                <el-option label="PAY_SUCCESS" value="PAY_SUCCESS" />
              </el-select>
            </el-form-item>
            <el-form-item label="选择日期">
              <el-date-picker
                    v-model="createDate"
                    type="datetimerange"
                    value-format="yyyy-MM-dd HH:mm:ss"
                    style="width: 200px;"
                    range-separator="至"
                    start-placeholder="开始日期"
                    end-placeholder="结束日期">
                  </el-date-picker>
            </el-form-item>
            <el-form-item>
              <el-button
                plain
                style="background-color: #3F9B6A;color: #fff;border-color:#3F9B6A;"
                @click="onSubmit"
                >查询
              </el-button>
              <el-button
                plain
                style="color: #000; border-color: #d5d5d5;"
                @click="resetting"
                >重置
              </el-button>
            </el-form-item>
          </el-form>
        </div>
        <div style="margin-bottom:20px;">
          <el-button
            style="background-color: #3F9B6A;color: #fff;"
          @click="downloadImage"
            >下载
          </el-button>
        </div>
        <!-- 表格 -->
        <el-table
          :data="tableData"
           :header-cell-style="{fontSize: '14px',color:'#0009',fontWeight: 'normal',backgroundColor:'#F2F3F5'}"
        >
          <el-table-column
            label="序号"
            min-width="4%"
          >
          <template slot-scope="scope">
            {{scope.$index+1}}
          </template>
          </el-table-column>
          <el-table-column
            label="订单号"
            prop="orderNo"
            width="auto"
            min-width="12%"
          >
          </el-table-column>
          <el-table-column
            label="交易号"
            prop="payId"
            width="auto"
            min-width="12%"
          >
          </el-table-column>
          <el-table-column
            label="账单金额"
            prop="realAmount"
            width="auto"
            min-width="12%"
          >
          </el-table-column>
          <el-table-column
            label="平台流水"
            prop="realAmount"
            width="auto"
            min-width="5%"
          >
          </el-table-column>
          <el-table-column
            label="交易流水"
            prop="realAmount"
            width="auto"
            min-width="10%"
          >
          </el-table-column>
          <el-table-column
            prop="createDate"
            label="支付时间"
            width="auto"
            min-width="10%"
          >
          </el-table-column>
          <el-table-column
            prop="channel"
            label="支付方式"
            width="auto"
            min-width="10%"
          >
          </el-table-column>
<el-table-column
            prop="body"
            label="营业点"
            width="auto"
            min-width="10%"
          >
          </el-table-column>
          <el-table-column
            prop="payState"
            label="交易状态"
            width="auto"
            min-width="10%"
          >
          </el-table-column>
        </el-table>
        <!-- <div class="fenye">
          <div style="line-height: 34px">显示第1到第10条记录</div>
          <el-pagination
            class="pagination"
            :hide-on-single-page="flag"
            background
            small
            :current-page="currentPage"
            :page-sizes="[10, 20, 50, 100]"
            :page-size="pageSize"
            layout="total,sizes,prev, pager,next"
            :total="total "
            @size-change="handleSizeChange"
            @current-change="handleCurrentChange"
          />
        </div> -->
      </div>
    </div>
  </div>
</template>
<script>
import {merchantQueries,excelMerchantQueriesOrderDetails} from '../../../api/online.js'
export default {
  data () {
    return {
      currentPage: 1,
      total: 100,
      flag: false,
      pageSize: 10,
      activeName: 'zfb',
      tabTitle:'',
    tableData: [],
    createDate:[],
    pageindex: {
      payState:'',
      createDate:'',
      merchantId:'9E602E5977EC48DEA06D42C67F4C93F0',
      page: 1,
      limit: 10,
      orderTimeStart:'2024-1-1 :00:00:00',
      orderTimeEnd:'',
    },
    }
  },
  computed: {},
  mounted(){
    this.getOrder()
  },
  methods: {
          async getOrder(){
             // this.getFirstDayOfYear()
            this.getLastDayOfYear()
           const res =   await merchantQueries(this.pageindex)
            this.tableData = res.data
          this.total = res.data.length
            },
            getFirstDayOfYear() {
              const now = new Date();
              const year = now.getFullYear();
              const firstDay = new Date(year, 0, 1, 0, 0, 0, 0);
              this.pageindex.orderTimeStart = this.formatDate(firstDay);
            },
              getLastDayOfYear() {
                const now = new Date()
                const year = now.getFullYear()
                const lastDay = new Date(year, 11, 31, 23, 59, 59, 999)
                this.pageindex.orderTimeEnd = this.formatDate(lastDay)
              },
              formatDate(date) {
                const year = date.getFullYear()
                const month = String(date.getMonth() + 1).padStart(2, '0')
                const day = String(date.getDate()).padStart(2, '0')
                const hours = String(date.getHours()).padStart(2, '0')
                const minutes = String(date.getMinutes()).padStart(2, '0')
                const seconds = String(date.getSeconds()).padStart(2, '0')
                return `${year}-${month}-${day} ${hours}:${minutes}:${seconds}`
              },
   async downloadImage(){
     // this.getFirstDayOfYear()
     this.getLastDayOfYear()
     let res = await excelMerchantQueriesOrderDetails(this.pageindex)
    if(!res){
      return
    }
    const blob = new Blob([res], { type: 'application/vnd.ms-excel' })
    const fileName = '报表.xls'
    if ('download' in document.createElement('a')) {
       // 非IE下载
       const elink = document.createElement('a')
       elink.download = fileName
       elink.style.display = 'none'
       elink.href = URL.createObjectURL(blob)
       document.body.appendChild(elink)
       elink.click()
       URL.revokeObjectURL(elink.href) // 释放URL 对象
       document.body.removeChild(elink)
     } else {
      // IE10+下载
      navigator.msSaveBlob(blob, fileName)
    }
    this.$message({
      message: '下载成功',
      type: 'success'
    })
  // const imageUrl = 'https://jy.scjysm.asia:18086/mefile/file/static/tabbar/export.xlsx';
  //     // 创建一个隐藏的<a>标签
  //     const link = document.createElement('a');
  //     link.href = imageUrl;
  //     link.download = '报表.xlsx'; // 设置下载的文件名
  //     document.body.appendChild(link);
  //     link.click(); // 触发点击事件
  //     document.body.removeChild(link); // 下载完成后移除<a>标签
    },
    handleSizeChange(){
    },
    handleCurrentChange(){
    },
    onSubmit(){
      if(this.createDate.length !=0){
         this.pageindex.createDate = this.createDate.join(',')
      }
        this.getOrder()
    },
    resetting(){
      this.createDate= [],
    this.pageindex = {
      payState:'',
      createDate:'',
      merchantId:'9E602E5977EC48DEA06D42C67F4C93F0',
      page: 1,
      limit: 10,
      orderTimeStart:'',
      orderTimeEnd:'',
    }
        this.getOrder(this.pageindex)
    },
  }
}
</script>
<style scoped >
.zhuti {
    padding: 0 20px 20px 20px;
    min-height: calc(100vh - 50px - 20px);
    background-color: #Fff;
    position: relative;
  }
/deep/ .el-form-item__content {
  line-height: 0;
}
.tableBtn {
  display: inline-block;
  margin-right: 10px;
}
::v-deep .formSearch {
  position: relative;
  margin-bottom: 20px;
  display: flex;
  width: 100%;
  height: 30px;
  font-size: 12px;
  justify-content: space-between;
  .el-form-item__label{
    font-size: 14px;
    color: #000;
    font-weight: 400;
  }
}
.greens {
  color: #3F9B6A;
}
/deep/ .el-table__row {
  font-size: 14px;
}
.fenye {
  margin-top: 20px;
  display: flex;
  justify-content: flex-start;
  position: relative;
}
/deep/ .el-pagination.is-background .el-pager li:not(.disabled).active {
  background-color: #3F9B6A;
}
.el-row {
  margin-bottom: 20px;
}
:last-child {
  margin-bottom: 0;
}
.el-col {
  border-radius: 4px;
}
.bg-purple-dark {
  background: #99a9bf;
}
.bg-purple {
  background: #d3dce6;
}
.bg-purple-light {
  background: #e5e9f2;
}
.grid-content {
  border-radius: 4px;
  min-height: 36px;
}
.row-bg {
  padding: 10px 0;
  background-color: #f9fafc;
}
/deep/ .bg-purple[data-v-0e3fe4ec] {
  background: #fff;
  height: 50px;
}
/deep/ .el-form--label-top .el-form-item__label {
  padding: 0;
}
.demo-input-suffix{
  display: flex;
  margin-right: 20px;
}
.pagination{
  text-align:right;
  line-height: 20px;
}
/deep/ .el-pagination__total{
  margin-top:4px;
}
/deep/ .btn-prev{
  position:absolute ;
  top: 4px;
  right: 266px;
}
/deep/ .el-pager{
  position:absolute ;
  top: 4px;
  right: 40px;
}
/deep/ .btn-next{
  position:absolute;
 top: 4px;
  right: 10px;
}
::v-deep .btn .el-button:focus,
.el-button:hover {
  border: 1px solid #3F9B6A;
}
     ::v-deep .el-select .el-input.is-focus .el-input__inner{
         border-color:#3F9B6A
     }
     ::v-deep .dialog_css_Xq{
       .el-dialog__header{
         background-color:#fafafa;
       }
       .el-dialog__title{
         color:#000
       }
     }
    ::v-deep .el-tabs__item.is-active{
       color:#3F9B6A;
     }
 ::v-deep .el-tabs__active-bar{
  background-color:#3F9B6A;
}
</style>