webapp / GreenwayWeb

<template>
  <div style="background-color:#f7f7f7;padding:10px 10px;">
    <div class="history">
      <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="toolbar">
          <el-form ref="formParams" :inline="true" :model="pageIndex">
              <el-form-item label="渠道">
              <el-select  placeholder="全部"
                v-model="pageIndex.ticketChannel"
                style="width: 168px;margin-right: 15px">
                <el-option label="大麦" value="大麦" />
                <el-option label="猫眼" value="猫眼" />
                <el-option label="携程" value="携程" />
                <el-option label="美团" value="美团" />
              </el-select>
              </el-form-item>
              <el-form-item label="票种">
              <el-select  placeholder="全部"
                v-model="pageIndex.ticketType"
                style="width: 168px;margin-right: 15px">
                <el-option label="电影票" value="电影票" />
                <el-option label="演唱会票" value="演唱会票" />
              </el-select>
              </el-form-item>
              <el-form-item label="证件">
              <el-select  placeholder="全部"
                v-model="pageIndex.type"
                style="width: 168px;margin-right: 15px">
                <el-option label="正常购票" value="0" />
                <el-option label="学生证" value="1" />
                <el-option label="老年证" value="2" />
                <el-option label="军官证" value="3" />
                <el-option label="警官证" value="4" />
                <el-option label="残疾证" value="5" />
                <el-option label="护照" value="6" />
              </el-select>
              </el-form-item>
            <el-form-item label="日期">
              <el-date-picker
                v-model="pageIndex.list"
                type="daterange"

                range-separator="至"
                start-placeholder="开始时间"
                end-placeholder="结束时间"
                value-format="yyyy-MM-dd"
              />
            </el-form-item>

            <el-form-item label-width="0">
              <el-button   @click="search('formParams')"  style="background-color: #3F9B6A;color: #fff;">查询</el-button>
              <el-button  @click="clear('formParams')"  class="buttonHover"
              style="color: #606266;border: 1px solid #dddfe5;background-color: #fff;">重置</el-button>
            </el-form-item>
          </el-form>
        </div>
         </div>
        <!-- 表格 -->
        <div class="content_table" style="padding: 15px 10px 10px 20px;background-color:#F2F3F5">
          <div style='padding:20px 10px;background-color:#fff;margin-bottom: 10px;'>
            <div style="display:flex;font-size:14px;justify-content: space-around">
              <div style="width:12%;border-right:1px solid #F2F3F5">
                <div style="margin-bottom: 10px;font-weight: 600;">学生证购票数量(张)</div>
                <div style="font-weight: 600;">{{numOne}}</div>
              </div>
              <div style="width:12%;border-right:1px solid #F2F3F5">
                 <div style="margin-bottom: 10px;font-weight: 600;">学生证购票总额(元)</div>
                <div style="font-weight: 600;">{{moyeOne}}</div>
              </div>


              <div style="width:12%;border-right:1px solid #F2F3F5">
                 <div style="margin-bottom: 10px;font-weight: 600;">老年证购票数量(张)</div>
                 <div style="font-weight: 600;">{{numTwo}}</div>
              </div>
              <div style="width:12%;border-right:1px solid #F2F3F5">
                <div style="margin-bottom: 10px;font-weight: 600;">老年证购票总额(元)</div>
                 <div style="font-weight: 600;">{{moyeTwo}}</div>
              </div>
              <div style="width:12%;border-right:1px solid #F2F3F5">
                <div style="margin-bottom: 10px;font-weight: 600;">军官证购票数量(张)</div>
                 <div style="font-weight: 600;">{{numthree}}</div>
              </div>
              <div>
                <div style="margin-bottom: 10px;font-weight: 600;">军官证购票总额(元)</div>
                 <div style="font-weight: 600;">{{moyethree}}</div>
              </div>
            </div>
          </div>
          <div style='padding:20px 10px;background-color:#fff;margin-bottom: 10px;'>
            <div style="display:flex;font-size:14px;justify-content: space-around">
              <div style="width:12%;border-right:1px solid #F2F3F5">
                <div style="margin-bottom: 10px;font-weight: 600;">警官证购票数量(张)</div>
                <div style="font-weight: 600;">{{numfour}}</div>
              </div>
              <div style="width:12%;border-right:1px solid #F2F3F5">
                 <div style="margin-bottom: 10px;font-weight: 600;">警官证购票总额(元)</div>
                <div style="font-weight: 600;">{{moyefour}}</div>
              </div>
              <div style="width:12%;border-right:1px solid #F2F3F5">
                 <div style="margin-bottom: 10px;font-weight: 600;">残疾证购票数量(张)</div>
                 <div style="font-weight: 600;">{{numfive}}</div>
              </div>
              <div style="width:12%;border-right:1px solid #F2F3F5">
                <div style="margin-bottom: 10px;font-weight: 600;">残疾证购票总额(元)</div>
                 <div style="font-weight: 600;">{{moyefive}}</div>
              </div>
              <div style="width:12%;border-right:1px solid #F2F3F5">
                <div style="margin-bottom: 10px;font-weight: 600;">护照购票数量(张)</div>
                 <div style="font-weight: 600;">{{numsix}}</div>
              </div>
              <div>
                <div style="margin-bottom: 10px;font-weight: 600;">护照购票总额(元)</div>
                 <div style="font-weight: 600;">{{moyesix}}</div>
              </div>
            </div>
          </div>
             <div style="background-color: #fff;padding: 10px;margin-bottom: 20px;">
          <div style="display: flex;margin-bottom: 20px;">
            <div style="width: 100%;padding: 10px 0;">特殊证件购票数据</div>
            <!-- <el-select  placeholder="全部证件"
              style="width: 120px;margin-right: 15px">
              <el-option label="1" value="1" />
            </el-select> -->
            <el-button  style="background-color: #3F9B6A;color: #fff;" @click="daochu">导出</el-button>
          </div>
          <div class="table">
            <el-table
            :summary-method="getSummaries"
              :span-method="objectSpanMethod"
               show-summary
              :data="tableData"
             :header-cell-style="{fontSize: '14px',color:'#0009',fontWeight: 'normal',backgroundColor:'#F2F3F5'}"
            >
              <el-table-column label="序号" >
              <template slot-scope="scope">
                  {{scope.$index +1}}
                                  </template>
              </el-table-column>
              <el-table-column label="证件名称" :show-overflow-tooltip="true">
              <template slot-scope="scope">
                  {{scope.row.type == '0'?'正常购票':scope.row.type == '1'?'学生证':scope.row.type == '2'?'老年证':scope.row.type == '3'?'军官证':scope.row.type == '4'?'警官证':scope.row.type == '5'?'残疾证':'护照'}}


                                  </template>
              </el-table-column>
              <el-table-column prop="ticketChannel" label="渠道">

              </el-table-column>
              <el-table-column prop="ticketType" label="票种" />
     <el-table-column prop="ticketName" label="票名" />
     <el-table-column prop="num" label="销售数量(张)" />
     <el-table-column prop="ticketPrice" label="客单价(元)" />
     <el-table-column prop="price" label="销售金额(元)" />
              <!-- <el-table-column label="操作">
                <template slot-scope="scope">
                  <el-button type="text"   style="background-color: transparent;color: #3F9B6A;;border: none;">详情</el-button>
                  <el-button type="text"   style="background-color: transparent;color: #3F9B6A;;border: none;">删除</el-button>
                </template>
              </el-table-column> -->
            </el-table>
          </div>
          <!-- 分页 -->
          <div class="fenye">

            <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,prev, pager,next" :total="total"
              @size-change="handleSizeChange" @current-change="handleCurrentChange" />
          </div>
       </div>
        </div>
      </div>
  </div>
</template>

<script>
import {getCertificatePurchase,excelToGetCertificatePurchase} from '@/api/piaowu'
export default {
  data() {
    return {
    flag:false,
      total: 1,
      pageSize: 10,
      currentPage: 1,
      tipsList: [],
       tableData: [],
      pageIndex:{
        list: [],
            page: 1,
            pageSize: 10,
           startTime: "",
    endTime: "",
    ticketChannel: "",
    ticketType: "",
    type:""
        },
        numOne:0,
        moyeOne:0,
        numTwo:0,
        moyeTwo:0,
        numthree:0,
        moyethree:0,
        numfour:0,
        moyefour:0,
        numfive:0,
        moyefive:0,
        numsix:0,
        moyesix:0

    }
  },
  mounted() {
    this.getAll()
  },
  methods: {
    async getAll(){
    let res =   await getCertificatePurchase(this.pageIndex)
    this.tableData = res.data.list
    this.total = res.data.total

   let numOne= 0
   let moyeOne =0
   let numTwo = 0
   let moyeTwo = 0
   let numthree = 0
   let moyethree = 0
   let numfour = 0
   let moyefour =0
   let numfive = 0
   let moyefive =0
    let numsix = 0
   let moyesix=0
   this.tableData.map(item=>{
     if(item.type == '1'){
        numOne += item.num
       moyeOne += Number(item.price)
     }
    if(item.type == '2'){
       numTwo += item.num
      moyeTwo += Number(item.price)
    }
    if(item.type == '3'){
       numthree += item.num
      moyethree += Number(item.price)
    }
    if(item.type == '4'){
       numfour += item.num
      moyefour += Number(item.price)
    }
    if(item.type == '5'){
       numfive += item.num
      moyefive += Number(item.price)
    }
    if(item.type == '6'){
       numsix += item.num
      moyesix += Number(item.price)
    }
   })
   this.numOne = numOne
   this.moyeOne = moyeOne
   this.numTwo = numTwo
   this.moyeTwo = moyeTwo
   this.numthree = numthree
   this.moyethree = moyethree
   this.numfour = numfour
   this.moyefour = moyefour
   this.numfive = numfive
   this.moyefive = moyefive
   this.numsix = numsix
   this.moyesix = moyesix
    },
    search(){
      if(this.pageIndex.list.length !=0){
        this.pageIndex.startTime = this.pageIndex.list[0]
        this.pageIndex.endTime = this.pageIndex.list[1]
      }
      this.getAll()
    },
    clear(){
      this.pageIndex = {
        list: [],
            page: 1,
            pageSize: 10,
           startTime: "",
    endTime: "",
    ticketChannel: "",
    ticketType: "",
    type:""
        }

        this.getAll()
    },
    changepiao(){
      this.getAll()
    },
    getSummaries(param) {
          const { columns, data } = param;
          const sums = [];
          columns.forEach((column, index) => {
            if (index === 0) {
              sums[index] = '总计';
              return;
            }
            if (['销售数量(张)', '客单价(元)', '销售金额(元)'].includes(column.label)) {
              const values = data.map(item => Number(item[column.property]));
              if (!values.every(value => isNaN(value))) {
                sums[index] = values.reduce((prev, curr) => {
                  const value = Number(curr);
                  if (!isNaN(value)) {
                    return prev + curr;
                  } else {
                    return prev;
                  }
                }, 0);
              } else {
                sums[index] = '';
              }
            } else {
              sums[index] = '';
            }
          });

          return sums;
        },
 async daochu(){
  let res = await excelToGetCertificatePurchase(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'
  })
},

       async handleCurrentChange(val) {
          this.currentPage = val
           this.pageIndex.page = val
          try {
             const res = await getCertificatePurchase(this.pageIndex);
             this.tableData = res.data.list;
             this.total = res.data.total;

           } catch (error) {
             console.error('Error fetching data:', error);
           }
        },
        handleSizeChange(val) {
          this.pageSize = val
        },
         objectSpanMethod({ row, column, rowIndex, columnIndex }) {
                if (columnIndex === 0) {
                  if (rowIndex % 2 === 0) {
                    return {
                      rowspan: 2,
                      colspan: 1
                    };
                  } else {
                    return {
                      rowspan: 0,
                      colspan: 0
                    };
                  }
                }
              }
                   },
 }
</script>

<style lang='scss' scoped>
.history{
 padding: 0 20px 20px 20px;
    min-height: calc(100vh - 50px - 20px);
    background-color: #Fff;
}
 ::v-deep .el-form-item__label{
        font-weight: normal;
         font-size: 14px;

       }

          ::v-deep .el-pagination.is-background .el-pager li:not(.disabled).active {
           background-color: #3F9B6A;
         }
</style>
<style scoped>
.history /deep/ .el-table .cell.el-tooltip img {
  max-height: 100px;
}
 .pagination {
    text-align: right;
    line-height: 20px;
  }
.greens {
    color: #3F9B6A;
  }

  /deep/ .el-table__row {
    font-size: 14px;
    color:#000000e6;
    height:42px;
  }

  .fenye {
    margin-top: 20px;
    display: flex;
    justify-content: flex-end;
  }
  ::v-deep .el-pagination__total{
        position: absolute;
        left: 60px;
  }
  ::v-deep .buttonHover:hover{
    color:#3f9b6a !important;
    border-color: #c5e1d2 !important;
    background-color: #ecf5f0 !important;
    outline: none;
  }
</style>
<style>
.el-tooltip__popper {
  max-width: 50%;
}
</style>