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