Newer
Older
securityFront / src / views / statistics / personDuration.vue
wangxitong on 30 Jan 2021 7 KB 总览,样式,1.29bug修改
<!--人员所处时长统计-->
<template>
  <div class="app-container">
    <!--筛选条件-->
    <div class="search-div">
      <div class="search-left">
        <el-form ref="selectForm" :inline="true" :model="listQuery" class="form-container">
          <el-row>
            <el-col :span="4">
              <el-form-item class="selectForm-container-item">
                <el-input v-model.trim="listQuery.keywords" placeholder="姓名/身份证号" clearable />
              </el-form-item>
            </el-col>
            <el-col :span="3">
              <el-form-item class="selectForm-container-item">
                <el-select v-model="listQuery.personType" placeholder="类别" clearable>
                  <el-option v-for="item in personTypes" :key="item.value" :label="item.name" :value="item.value"/>
                </el-select>
              </el-form-item>
            </el-col>
            <el-col :span="8">
              <el-form-item class="selectForm-container-item">
                <el-date-picker
                  v-model="timeRange"
                  type="daterange"
                  range-separator="至"
                  start-placeholder="开始日期"
                  end-placeholder="结束日期" />
              </el-form-item>
            </el-col>

            <el-col :span="4" class="search-right">
              <el-button class="filter-item" type="primary" icon="el-icon-search" @click="search">搜索</el-button>
            </el-col>
          </el-row>
        </el-form>
      </div>
    </div>
    <!--查询结果Table显示-->
    <div>
      <el-row class="table-title">
        <el-col :span="6"><div class="title-header" style="color: white"><i class="el-icon-menu"/>数据列表</div></el-col>
        <el-col :span="12" :offset="6" class="edit_btns">
          <el-button class="edit_btn" size="small" @click="batchExport" :disabled="list.length===0">导出</el-button>
        </el-col>
      </el-row>
      <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border>
        <!--序号列-->
        <el-table-column :index="indexMethod" align="center" type="index" label="#" width="55"/>
        <!--内容列-->
        <el-table-column v-for="column in columns" :key="column.value" :label="column.text" :width="column.width" :align="column.align" show-overflow-tooltip>
          <template slot-scope="scope">
            <span v-if="column.value === 'idCard'">{{ encrypIdCardNo(scope.row[column.value]) }}</span>
            <span v-else :class="column.class">{{ scope.row[column.value] }}</span>
          </template>
        </el-table-column>
      </el-table>
    </div>
    <!--分页-->
    <div class="pagination-container">
      <el-pagination
        v-show="total>listQuery.limit"
        :current-page="listQuery.offset"
        :page-sizes="[20,30,50]"
        :page-size="listQuery.limit"
        :total="total"
        align="center"
        layout="total, sizes, prev, pager, next"
        @size-change="handleSizeChange"
        @current-change="handleCurrentChange"/>
    </div>
  </div>
</template>

<script>
import { formatToString } from '@/utils/calendarUtil'
import { personDurationStatistics } from '@/api/statistics'
import { getPersonType } from '@/api/allDict'
import { personDurationListExport } from '@/api/batch'

export default {
  name: 'PersonDuration',
  data() {
    return {
      listQuery: {
        keywords: '',
        personType: '',
        beginTime: '',
        endTime: '',
        offset: 1,
        limit: 20
      }, // 筛选条件
      columns: [
        {
          text: '姓名',
          value: 'name',
          align: 'center'
        },
        {
          text: '身份证号',
          value: 'idCard',
          align: 'center'
        },
        {
          text: '类别',
          value: 'personTypeName',
          align: 'center'
        },
        {
          text: '所处时长',
          value: 'duration',
          align: 'center'
        },
        {
          text: '进营时间',
          value: 'inTime',
          align: 'center'
        },
        {
          text: '出营时间',
          value: 'outTime',
          align: 'center'
        }
      ], // 显示列
      list: [], // 列表数据
      total: 0, // 数据总数
      personTypes: [],
      timeRange: [],
      listLoading: false, // 加载动画
      fullscreenLoading: false, // 全屏加载动画
      dialogFormVisible: false
    }
  },
  watch: {
    timeRange: function(newV) {
      if (newV) {
        this.listQuery.beginTime = formatToString(newV[0], 'DATE')
        this.listQuery.endTime = formatToString(newV[1], 'DATE')
      } else {
        this.listQuery.beginTime = ''
        this.listQuery.endTime = ''
      }
      this.fetchData()
    }
  },
  created() {
    this.fetchPersonType()
  },
  activated() {
    this.fetchData()// 获取数据
  },
  methods: {
    batchExport() {
      // 全屏加载动画
      const loading = this.$loading({
        lock: true,
        text: '下载中,请稍后...',
        spinner: 'el-icon-loading',
        background: 'rgba(0, 0, 0, 0.7)'
      })
      personDurationListExport(this.listQuery).then(res => {
        loading.close() // 关闭加载动画
        console.log('download===', res)
        const blob = new Blob([res.data])
        const downloadElement = document.createElement('a')
        const href = window.URL.createObjectURL(blob) // 创建下载的链接
        downloadElement.href = href
        downloadElement.download = `人员所处时长统计列表.xlsx` // 下载后文件名
        document.body.appendChild(downloadElement)
        downloadElement.click() // 点击下载
        document.body.removeChild(downloadElement) // 下载完成移除元素
        window.URL.revokeObjectURL(href) // 释放blob对象
      }).catch((res) => {
        loading.close()
        this.$message.error(res.message)
      })
    },
    // 身份证号加密显示
    encrypIdCardNo(idCard) {
      return idCard
      // if (idCard.length > 6) {
      //   return idCard.substr(0, 6) + '********' + idCard.substr(14)
      // } else if (idCard) {
      //   return idCard
      // } else {
      //   return ''
      // }
    },
    // 查询数据
    search() {
      this.fetchData(false)
    },
    fetchPersonType() {
      getPersonType().then(response => {
        this.personTypes = response.data
      })
    },
    // 获取列表
    fetchData(isNowPage = true) {
      this.listLoading = true
      if (!isNowPage) { // 是否显示当前页,否则跳转第一页
        this.listQuery.offset = 1
      }
      personDurationStatistics(this.listQuery).then(response => {
        if (response.code === 200) {
          this.list = response.data.rows
          this.total = parseInt(response.data.total)
        } else {
          this.$message.error(response.message)
        }
        this.listLoading = false
      })
    },
    indexMethod(index) {
      return this.listQuery.limit * (this.listQuery.offset - 1) + index + 1
    },
    // 改变页容量
    handleSizeChange(val) {
      this.listQuery.limit = val
      this.fetchData()
    },
    // 改变当前页
    handleCurrentChange(val) {
      this.listQuery.offset = val
      this.fetchData()
    }
  }
}
</script>

<style rel="stylesheet/scss" lang="scss" scoped>
  $tableTitleHeight:46px;
  .app-container{
    margin-bottom:20px
  }
  .table{
    margin-bottom: 20px;
  }
  .pagination-container{
    margin-bottom: 50px;
  }
  .table-title{
    background-color:rgba(76, 142, 226, 1);
    height: $tableTitleHeight;
    .title-header{
      line-height:$tableTitleHeight;
      color: white;
      font-size: 15px;
      i{
        margin-left: 5px;
        margin-right: 5px;
      }
    }
  }
  .edit_btns{
    .edit_btn{
      float:right;
      margin:7px 3px;//为了需要居中显示margin-top和bottom要用$tableTitleHeight减去按钮原高度除以2
    }
  }
</style>