Newer
Older
xc-business-system / src / views / resource / person / cert / list.vue
<!-- 证书列表 -->
<script name="CertList" lang="ts" setup>
import { dayjs } from 'element-plus'
import type { DateModelType } from 'element-plus'
import type { ICertInfo, IListQuery } from './cert-interface'
import { exportCertList, getCertList } from '@/api/resource/certRemind'
import type { TableColumn } from '@/components/NormalTable/table_interface'
import { getDictByCode } from '@/api/system/dict'
import type { IDictType } from '@/commonInterface/resource-interface'
import { exportFile } from '@/utils/exportUtils'

// 定义变量
const $router = useRouter()
const searchQuery = ref<IListQuery>({
  name: '',
  deptName: '',
  station: '',
  certType: '',
  certNo: '',
  certName: '',
  beginTime: '',
  endTime: '',
  offset: 1,
  limit: 20,
})
const dateRange = ref<[DateModelType, DateModelType]>(['', ''])// 筛选时间段数据

const loadingTable = ref<boolean>(false) // 表格loading
const total = ref<number>(0) // 数据总条数
const columns = ref<Array<TableColumn>>([
  { text: '姓名', value: 'staffName', align: 'center', width: '160' },
  { text: '工作部门', value: 'deptName', align: 'center' },
  { text: '岗位', value: 'station', align: 'center' },
  { text: '证书类型', value: 'certTypeName', align: 'center' },
  { text: '证书号', value: 'certNo', align: 'center' },
  { text: '证书名称', value: 'certName', align: 'center' },
  { text: '发证日期', value: 'grantDate', align: 'center', width: '160' },
  { text: '证书有效日期', value: 'effectiveDate', align: 'center' },
]) // 表头
const list = ref([]) // 表格数据
const listSelected = ref<Array<ICertInfo>>([])

const certTypeDict = ref<Array<IDictType>>([])

// 逻辑

// 获取数据列表
const fetchData = (isNowPage = false) => {
  loadingTable.value = true
  if (!isNowPage) {
    // 是否显示当前页,否则跳转第一页
    searchQuery.value.offset = 1
  }
  getCertList(searchQuery.value).then((res) => {
    if (res.code === 200) {
      list.value = res.data.rows
      total.value = Number(res.data.total)
    }
    loadingTable.value = false
  }).catch(() => {
    loadingTable.value = false
  })
}

const search = () => {
  fetchData()
}

const clearList = () => {
  searchQuery.value = {
    name: '',
    deptName: '',
    station: '',
    certType: '',
    certNo: '',
    certName: '',
    beginTime: '',
    endTime: '',
    offset: 1,
    limit: 20,
  }
  dateRange.value = ['', '']
  fetchData()
}

// 页数发生变化后的操作,可能是页码变化,可能是每页容量变化,此函数必写
const changePage = (val: { size?: number; page?: number }) => {
  if (val && val.size) {
    searchQuery.value.limit = val.size
  }
  if (val && val.page) {
    searchQuery.value.offset = val.page
  }
  fetchData(true)
}

const rowsSelected = (e: any) => {
  listSelected.value = e
}

// 查看详情信息
const detail = (row: ICertInfo) => {
  sessionStorage.setItem('certInfo', JSON.stringify(row))
  $router.push({
    query: {
      type: 'detail',
      id: row.id,
    },
    path: 'cert/detail',
  })
}

const exportToExcel = () => {
  const ids: string[] = []
  listSelected.value.forEach((item: ICertInfo) => {
    ids.push(item.id!)
  })

  loadingTable.value = true

  if (ids.length === 0) {
    // 没有选择导出所有
    exportCertList(searchQuery.value).then((res) => {
      exportFile(res.data, `证书列表-${dayjs(new Date()).format('YYYYMMDDHHmmss')}.xlsx`)
    })
  }
  else {
    exportCertList({ ids }).then((res) => {
      exportFile(res.data, `证书列表-${dayjs(new Date()).format('YYYYMMDDHHmmss')}.xlsx`)
    })
  }

  loadingTable.value = false
}

const getCertTypeDict = async () => {
  await getDictByCode('bizCertType').then((res) => {
    if (res.code === 200) {
      certTypeDict.value = res.data
    }
  })
}

const getDict = () => {
  getCertTypeDict()
}

watch(dateRange, (val) => {
  if (val) {
    searchQuery.value.beginTime = dayjs(val[0]).format('YYYY-MM-DD HH:mm:ss') === 'Invalid Date' ? '' : dayjs(val[0]).format('YYYY-MM-DD HH:mm:ss')
    searchQuery.value.endTime = dayjs(val[1]).format('YYYY-MM-DD HH:mm:ss') === 'Invalid Date' ? '' : dayjs(val[1]).format('YYYY-MM-DD HH:mm:ss')
  }
  else {
    searchQuery.value.beginTime = ''
    searchQuery.value.endTime = ''
  }
})

onMounted(() => {
  getDict()
  fetchData()
})
</script>

<template>
  <app-container>
    <!-- 筛选条件 -->
    <search-area :need-clear="true" @search="search" @clear="clearList">
      <search-item width="162px">
        <el-input v-model="searchQuery.name" placeholder="姓名" clearable />
      </search-item>
      <search-item width="162px">
        <el-input v-model="searchQuery.deptName" placeholder="工作部门" clearable />
      </search-item>
      <search-item width="162px">
        <el-input v-model="searchQuery.station" placeholder="岗位" clearable />
      </search-item>
      <search-item width="162px">
        <el-select v-model="searchQuery.certType" placeholder="证书类型" clearable>
          <el-option v-for="dict in certTypeDict" :key="dict.id" :value="dict.value" :label="dict.name" />
        </el-select>
      </search-item>
      <search-item width="162px">
        <el-input v-model="searchQuery.certNo" placeholder="证书号" clearable />
      </search-item>
      <search-item width="162px">
        <el-input v-model="searchQuery.certName" placeholder="证书名称" clearable />
      </search-item>
      <search-item>
        <el-date-picker v-model="dateRange" type="daterange" start-placeholder="证书有效期(开始)" end-placeholder="证书有效期(结束)" />
      </search-item>
    </search-area>

    <!-- 表格数据展示 -->
    <table-container>
      <!-- 表头区域 -->
      <template #btns-right>
        <icon-button icon="icon-export" title="导出" @click="exportToExcel" />
      </template>

      <!-- 表格区域 -->
      <normal-table
        :data="list" :total="total" :columns="columns"
        :query="{ limit: searchQuery.limit, offset: searchQuery.offset }"
        :list-loading="loadingTable"
        :is-showmulti-select="true"
        @change="changePage" @multi-select="rowsSelected"
      >
        <template #preColumns>
          <el-table-column label="序号" width="55" align="center">
            <template #default="scope">
              {{ (searchQuery.offset - 1) * searchQuery.limit + scope.$index + 1 }}
            </template>
          </el-table-column>
        </template>
        <template #columns>
          <el-table-column fixed="right" label="操作" align="center" width="130">
            <template #default="{ row }">
              <el-button size="small" type="primary" link @click="detail(row)">
                详情
              </el-button>
            </template>
          </el-table-column>
        </template>
      </normal-table>
    </table-container>
  </app-container>
</template>