<!-- 证书列表 -->
<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>