<template>
|
<LoadingLayout :loading="state.loading">
|
<AppContainer>
|
<ProTableQueryFilterBar @on-reset="reset">
|
<template #query>
|
<QueryFilterItem tip-content="操作">
|
<FieldRadio
|
v-model="extraParamState.operate"
|
:value-enum="EnumDbAuditOperateText"
|
buttonStyle
|
showAllBtn
|
:all-btn-value="null"
|
@change="getList()"
|
/>
|
</QueryFilterItem>
|
<QueryFilterItem tip-content="创建时间">
|
<FieldDatePicker
|
v-model="extraParamState.createdTime"
|
type="daterange"
|
range-separator="~"
|
start-placeholder="开始时间"
|
end-placeholder="结束时间"
|
clearable
|
@change="getList()"
|
></FieldDatePicker>
|
</QueryFilterItem>
|
<QueryFilterItem>
|
<SearchInput
|
v-model="extraParamState.createdUser"
|
style="width: 260px"
|
placeholder="操作人createdUser"
|
@on-click-search="getList()"
|
>
|
</SearchInput>
|
</QueryFilterItem>
|
<QueryFilterItem>
|
<SearchInput
|
v-model="extraParamState.traceId"
|
style="width: 260px"
|
placeholder="跟踪Id(traceId)"
|
@on-click-search="getList()"
|
>
|
</SearchInput>
|
</QueryFilterItem>
|
<QueryFilterItem>
|
<SearchInput
|
v-model="extraParamState.tableName"
|
style="width: 260px"
|
placeholder="表名tableName"
|
@on-click-search="getList()"
|
>
|
</SearchInput>
|
</QueryFilterItem>
|
<QueryFilterItem>
|
<SearchInput
|
v-model="extraParamState.primaryKey"
|
style="width: 260px"
|
placeholder="主键primaryKey"
|
@on-click-search="getList()"
|
>
|
</SearchInput>
|
</QueryFilterItem>
|
<QueryFilterItem>
|
<SearchInput
|
v-model="extraParamState.oldValues"
|
style="width: 260px"
|
placeholder="旧值oldValues"
|
@on-click-search="getList()"
|
>
|
</SearchInput>
|
</QueryFilterItem>
|
<QueryFilterItem>
|
<SearchInput
|
v-model="extraParamState.newValues"
|
style="width: 260px"
|
placeholder="新值newValues"
|
@on-click-search="getList()"
|
>
|
</SearchInput>
|
</QueryFilterItem>
|
</template>
|
</ProTableQueryFilterBar>
|
<ProTableV2 v-bind="proTableProps" :columns="column" :operationBtns="operationBtns">
|
<template #oldValues="{ row }">
|
<el-button
|
v-if="row.oldValues"
|
type="primary"
|
link
|
@click="handleAdd({ json: { oldValues: JSON.parse(row.oldValues) } })"
|
>查看</el-button
|
>
|
</template>
|
<template #newValues="{ row }">
|
<el-button
|
v-if="row.newValues"
|
type="primary"
|
link
|
@click="handleAdd({ json: { newValues: JSON.parse(row.newValues) } })"
|
>查看</el-button
|
>
|
</template>
|
<template #createdUser="{ row }">
|
<el-button
|
v-if="row.createdUser"
|
type="primary"
|
link
|
@click="
|
handleAdd({ json: { createdUser: JSON.parse(JSON.stringify(row.createdUser)) } })
|
"
|
>查看</el-button
|
>
|
</template>
|
</ProTableV2>
|
<JsonViewerDialog v-bind="dialogProps" />
|
</AppContainer>
|
</LoadingLayout>
|
</template>
|
|
<script setup lang="ts">
|
import {
|
ProTableQueryFilterBar,
|
SearchInput,
|
LoadingLayout,
|
AppContainer,
|
QueryFilterItem,
|
useTable,
|
ProTableV2,
|
FieldRadio,
|
FieldDatePicker,
|
useFormDialog,
|
} from '@bole-core/components';
|
import { EnumDbAuditOperateText } from '@/constants';
|
import * as logRecordsServices from '@/services/api/logRecords';
|
import { ModelValueType } from 'element-plus';
|
import { format } from '@/utils';
|
import JsonViewerDialog from './components/JsonViewerDialog.vue';
|
|
defineOptions({
|
name: 'DbAuditLogs',
|
});
|
|
const operationBtnMap: Record<string, OperationBtnType> = {
|
detailBtn: { emits: { onClick: (role) => openDialog(role) } },
|
};
|
|
const { column, operationBtns } = useAccess({
|
operationBtnMap,
|
});
|
|
const BaseState = {
|
loading: true,
|
};
|
|
const state = reactive({ ...BaseState });
|
|
onMounted(async () => {
|
await getList();
|
state.loading = false;
|
});
|
|
const {
|
getDataSource: getList,
|
proTableProps,
|
paginationState,
|
extraParamState,
|
reset,
|
} = useTable(
|
async ({ pageIndex, pageSize }, extraParamState) => {
|
try {
|
let params: API.GetDbAuditLogsQuery = {
|
pageModel: {
|
rows: pageSize,
|
page: pageIndex,
|
// orderInput: extraParamState.orderInput,
|
},
|
createdTimeBegin: format(extraParamState.createdTime?.[0] ?? '', 'YYYY-MM-DD 00:00:00'),
|
createdTimeEnd: format(extraParamState.createdTime?.[1] ?? '', 'YYYY-MM-DD 23:59:59'),
|
createdUser: extraParamState.createdUser,
|
traceId: extraParamState.traceId,
|
tableName: extraParamState.tableName,
|
primaryKey: extraParamState.primaryKey,
|
operate: extraParamState.operate,
|
oldValues: extraParamState.oldValues,
|
newValues: extraParamState.newValues,
|
};
|
let res = await logRecordsServices.getDbAuditLogs(params, {
|
showLoading: !state.loading,
|
});
|
return res;
|
} catch (error) {}
|
},
|
{
|
defaultExtraParams: {
|
createdUser: '',
|
traceId: '',
|
operate: '' as any as EnumDbAuditOperate,
|
tableName: '',
|
primaryKey: '',
|
oldValues: '',
|
newValues: '',
|
createdTime: [] as unknown as ModelValueType,
|
orderInput: [{ property: 'createdTime', order: EnumPagedListOrder.Desc }],
|
},
|
columnsRenderProps: {
|
createdTime: { type: 'date', format: 'YYYY-MM-DD HH:mm:ss' },
|
operate: { type: 'enum', valueEnum: EnumDbAuditOperateText },
|
},
|
}
|
);
|
|
const { dialogProps, handleAdd } = useFormDialog({
|
defaultFormParams: {
|
json: null,
|
},
|
});
|
|
function openDialog(row: API.GetDbAuditLogsQueryResultItem) {
|
handleAdd({
|
json: {
|
oldValues: JSON.parse(row.oldValues),
|
newValues: JSON.parse(row.newValues),
|
createdUser: JSON.parse(JSON.stringify(row.createdUser)),
|
},
|
});
|
}
|
</script>
|
|
<style lang="scss" scoped>
|
@use '@/style/common.scss' as *;
|
</style>
|
