manage_invoice_ui/src/views/selfCar/selfCarApply.vue

<template>
    <div class="invoice_container">
      <div class="title">
        <el-row>
          <el-col :span="24">
            <div class="top">
               <el-input  placeholder="企业编号" class="input-demo" v-model="formCondition.companyNum"></el-input>
               <el-input  placeholder="申请Id" class="input-demo" v-model="formCondition.applId"></el-input>
               <el-input  placeholder="etc卡号" class="input-demo" v-model="formCondition.etcNum"></el-input>
               <el-button type="success" style="margin-left: 1%;" @click="loadData">查询</el-button>
               <el-button type="primary" style="margin-left: 1%;" @click="exportExcel">导出报表</el-button>
            </div>
          </el-col>
        </el-row>
      </div>
      <!-- 表格部分 -->
        <template>
        <el-table
          class="table"
          v-loading="loading"
          ref="multipleTable"
          :data="invoiceTable"
          :height="heightt"
          border
          tooltip-effect="dark">
          <el-table-column
            prop="plateNum"
            label="车牌号"
            show-overflow-tooltip>
          </el-table-column>
           <el-table-column
            prop="cardId"
            label="ETC卡号"
            show-overflow-tooltip>
          </el-table-column>
          <el-table-column
            prop="tradeId"
            label="交易Id"
            show-overflow-tooltip>
          </el-table-column>
          <el-table-column
            prop="sellerTaxpayerCode"
            label="销方税号"
            show-overflow-tooltip>
          </el-table-column>
          <el-table-column
            prop="sellerName"
            label="销方名称"
            show-overflow-tooltip>
          </el-table-column>
          <el-table-column
            prop="enStation"
            label="入口收费站"
            width="100"
            show-overflow-tooltip>
          </el-table-column>
          <el-table-column
            prop="exStation"
            label="出口收费站"
            width="100"
            show-overflow-tooltip>
          </el-table-column>
          <el-table-column
            prop="invoiceCode"
            label="发票代码"
            show-overflow-tooltip>
          </el-table-column>
          <el-table-column
            prop="invoiceNum"
            label="发票号码"
            show-overflow-tooltip>
          </el-table-column>
          <el-table-column
            prop="invoiceMakeTime"
            label="开票时间"
            show-overflow-tooltip>
          </el-table-column>
          <el-table-column
            prop="exTime"
            label="交易时间"
            show-overflow-tooltip>
          </el-table-column>
          <!-- <el-table-column
            prop="enStation"
            label="入口收费站"
            width="100"
            show-overflow-tooltip>
          </el-table-column>
          <el-table-column
            prop="exStation"
            label="出口收费站"
            width="100"
            show-overflow-tooltip>
          </el-table-column>
          <el-table-column
            prop="sellerName"
            label="销方名称"
            show-overflow-tooltip>
          </el-table-column>
          <el-table-column
            prop="sellerTaxpayerCode"
            label="销方税号"
            show-overflow-tooltip>
          </el-table-column> -->
           <el-table-column
            prop="fee"
            label="交易金额"
            show-overflow-tooltip>
             <template slot-scope="scope">
               <span>{{scope.row.fee/100| rounding}}</span>
            </template>
          </el-table-column>
          <el-table-column
            prop="totalAmount"
            label="价税合计"
            show-overflow-tooltip>
             <template slot-scope="scope">
               <span>{{scope.row.totalAmount/100| rounding}}</span>
            </template>
          </el-table-column>
           <el-table-column
            prop="totalTaxAmount"
            label="税额"
            show-overflow-tooltip>
             <template slot-scope="scope">
               <span>{{scope.row.totalTaxAmount/100| rounding}}</span>
            </template>
          </el-table-column>
          <el-table-column
            prop="amount"
            label="金额"
            show-overflow-tooltip>
            <template slot-scope="scope">
               <span>{{scope.row.fee/100| rounding}}</span>
            </template>
          </el-table-column>
           <el-table-column
            prop="taxRate"
            label="税率"
            show-overflow-tooltip>
            <template slot-scope="scope">
               <span>{{scope.row.taxRate| rounding}}</span>
            </template>
          </el-table-column>
          <el-table-column
            prop="invoiceHtmlUrl"
            label="预览地址"
            show-overflow-tooltip>
            <template slot-scope="scope">
               <a :href="scope.row.invoiceHtmlUrl" target="_blank">{{scope.row.invoiceHtmlUrl}}</a>
            </template>
          </el-table-column>
          <el-table-column
            prop="invoiceUrl"
            label="下载地址"
            show-overflow-tooltip>
            <template slot-scope="scope">
               <a :href="scope.row.invoiceUrl" target="_blank">{{scope.row.invoiceUrl}}</a>
            </template>
          </el-table-column>
           <el-table-column
            prop="invoiceStatus"
            label="状态"
            show-overflow-tooltip>
             <template slot-scope="scope">
              <span v-if="scope.row.tradeStatus == 1" style="color: green">待开票</span>
              <span v-else-if="scope.row.tradeStatus == 2" style="color: red">开票中</span>
              <span v-else-if="scope.row.tradeStatus == 3" style="color: red">已开票</span>
            </template>
          </el-table-column>
          <el-table-column
            prop="msg"
            label="发票状态信息"
            width="100"
            show-overflow-tooltip>
          </el-table-column>
        </el-table>
      </template>
    </div>
</template>
<script type="text/javascript">
import FileSaver from "file-saver";
import XLSX from "xlsx";
      export default {
        data(){
          return{
            formCondition:{
              etcNum:'',
              applId:'',
              companyNum:''
            },
        
           invoiceTable:[],
            hightt:'0px',
          }
        },
        created() {
          this.heightt = tableHeight-50;
        },
        filters: {
            rounding (value) {
              return value.toFixed(2)
            }
        },
        methods:{
           firstLoadData(){
           
          },
          // 列表展示
          async loadData() {
            const formData = new FormData();
            for(var i in this.formCondition){
                formData.append(i,this.formCondition[i]);
            }
            const response = await this.$http.post('selfCarService/getSelfCarInvoicesByAppl', formData);
            if (response.data.code === 0) {
              this.invoiceTable = response.data.data;
            }
          },

         exportExcel() {
          const loading = this.$loading({
                                lock: true,
                                text: '系统正在努力接收中，过程大概需要几分钟的时间，请您耐心等待...',
                                spinner: 'el-icon-loading',
                                background: 'rgba(0, 0, 0, 0.7)'
                              });
          // 设置当前日期
          let time = new Date();
          let year = time.getFullYear();
          let month = time.getMonth() + 1;
          let day = time.getDate();
          let name = "自有车发票查询列表_"+year + "" + month + "" + day;
          /* generate workbook object from table */
          //  .table要导出的是哪一个表格
          var wb = XLSX.utils.table_to_book(document.querySelector(".table"),{ raw: true });
          this.formartNum(wb);
          /* get binary string as output */
          var wbout = XLSX.write(wb, {
            bookType: "xlsx",
            bookSST: true,
            type: "array"
          });
          try {
            //  name+'.xlsx'表示导出的excel表格名字
            FileSaver.saveAs(
              new Blob([wbout], { type: "application/octet-stream" }),
              name + ".xlsx"
            );
          } catch (e) {
            if (typeof console !== "undefined") console.log(e, wbout);
          }
          loading.close();
          return wbout;
      },
         
        }
      };
</script>
<style>
.invoice_container {
  border: 1px solid #d9d9d9;
  border-radius: 10px;
}
.invoice_container .title {
  font-size: 5px;
  margin-bottom: 20px;
}
.invoice_container .top {
  padding-top: 20px;
  padding-left: 20px;
}
.invoice_container .text {
  display: inline-block;
  color: #000;
  font-size: 16px ;
  margin-left: 1%;
}
.invoice_container .input-demo {
  display: inline-block;
  width: 15%;
  margin-left: 1%;
}
.invoice_container .block {
  font-size: 5px;
  text-align: center;
  margin-top: 25px;
  margin-bottom: 25px;
}
.invoice_container .el-dialog {
  width: 60%;
}
.invoice_container .el-dialog__header, .el-dialog__body {
  padding: 0 20px;
}
.invoice_container .tou {
  font-size: 20px;
  height: 30px;
  line-height: 30px;
  padding-top: 15px;
}
.invoice_container .line {
  margin-top: 15px;
  margin-bottom: 15px;
  width: 100%;
  height: 2px;
  background-color: #d9d9d9;
}
.invoice_container .xinxi {
  text-align: center;
  margin: 15px auto;
  font-size: 18px;
}
</style>