<template>
|
<div class="sys-difflog-container">
|
<el-card shadow="hover" :body-style="{ paddingBottom: '0' }">
|
<el-form :model="state.queryParams" ref="queryForm" :inline="true">
|
<el-form-item label="开始时间">
|
<el-date-picker v-model="state.queryParams.startTime" type="datetime" placeholder="开始时间" value-format="YYYY-MM-DD HH:mm:ss" :shortcuts="shortcuts" />
|
</el-form-item>
|
<el-form-item label="结束时间">
|
<el-date-picker v-model="state.queryParams.endTime" type="datetime" placeholder="结束时间" value-format="YYYY-MM-DD HH:mm:ss" :shortcuts="shortcuts" />
|
</el-form-item>
|
<el-form-item>
|
<el-button-group>
|
<el-button type="primary" icon="ele-Search" @click="handleQuery" v-auth="'sysDifflog:page'"> 查询 </el-button>
|
<el-button icon="ele-Refresh" @click="resetQuery"> 重置 </el-button>
|
</el-button-group>
|
</el-form-item>
|
<el-form-item>
|
<el-button icon="ele-DeleteFilled" type="danger" @click="clearLog" v-auth="'sysDifflog:clear'"> 清空 </el-button>
|
</el-form-item>
|
</el-form>
|
</el-card>
|
|
<el-card class="full-table" shadow="hover" style="margin-top: 5px">
|
<el-table :data="state.logData" style="width: 100%" v-loading="state.loading" border>
|
<el-table-column type="index" label="序号" width="55" align="center" />
|
<el-table-column prop="diffType" label="差异操作" header-align="center" show-overflow-tooltip />
|
<el-table-column prop="sql" label="Sql语句" header-align="center" show-overflow-tooltip />
|
<el-table-column prop="parameters" label="参数" header-align="center" show-overflow-tooltip />
|
<el-table-column prop="elapsed" label="耗时(ms)" header-align="center" show-overflow-tooltip />
|
<el-table-column prop="message" label="日志消息" header-align="center" show-overflow-tooltip />
|
<el-table-column prop="beforeData" label="操作前记录" header-align="center" show-overflow-tooltip />
|
<el-table-column prop="afterData" label="操作后记录" header-align="center" show-overflow-tooltip />
|
<el-table-column prop="businessData" label="业务对象" header-align="center" show-overflow-tooltip />
|
<el-table-column prop="createTime" label="操作时间" align="center" show-overflow-tooltip />
|
</el-table>
|
<el-pagination
|
v-model:currentPage="state.tableParams.page"
|
v-model:page-size="state.tableParams.pageSize"
|
:total="state.tableParams.total"
|
:page-sizes="[10, 20, 50, 100]"
|
size="small"
|
background
|
@size-change="handleSizeChange"
|
@current-change="handleCurrentChange"
|
layout="total, sizes, prev, pager, next, jumper"
|
/>
|
</el-card>
|
</div>
|
</template>
|
|
<script lang="ts" setup name="sysDiffLog">
|
import { onMounted, reactive } from 'vue';
|
import { ElMessage } from 'element-plus';
|
|
import { getAPI } from '/@/utils/axios-utils';
|
import { SysLogDiffApi } from '/@/api-services/api';
|
import { SysLogDiff } from '/@/api-services/models';
|
|
const state = reactive({
|
loading: false,
|
queryParams: {
|
startTime: undefined,
|
endTime: undefined,
|
},
|
tableParams: {
|
page: 1,
|
pageSize: 20,
|
total: 0 as any,
|
},
|
logData: [] as Array<SysLogDiff>,
|
});
|
|
onMounted(async () => {
|
handleQuery();
|
});
|
|
// 查询操作
|
const handleQuery = async () => {
|
if (state.queryParams.startTime == null) state.queryParams.startTime = undefined;
|
if (state.queryParams.endTime == null) state.queryParams.endTime = undefined;
|
|
state.loading = true;
|
let params = Object.assign(state.queryParams, state.tableParams);
|
var res = await getAPI(SysLogDiffApi).apiSysLogDiffPagePost(params);
|
state.logData = res.data.result?.items ?? [];
|
state.tableParams.total = res.data.result?.total;
|
state.loading = false;
|
};
|
|
// 重置操作
|
const resetQuery = () => {
|
state.queryParams.startTime = undefined;
|
state.queryParams.endTime = undefined;
|
handleQuery();
|
};
|
|
// 清空日志
|
const clearLog = async () => {
|
state.loading = true;
|
await getAPI(SysLogDiffApi).apiSysLogDiffClearPost();
|
state.loading = false;
|
|
ElMessage.success('清空成功');
|
handleQuery();
|
};
|
|
// 改变页面容量
|
const handleSizeChange = (val: number) => {
|
state.tableParams.pageSize = val;
|
handleQuery();
|
};
|
|
// 改变页码序号
|
const handleCurrentChange = (val: number) => {
|
state.tableParams.page = val;
|
handleQuery();
|
};
|
|
const shortcuts = [
|
{
|
text: '今天',
|
value: new Date(),
|
},
|
{
|
text: '昨天',
|
value: () => {
|
const date = new Date();
|
date.setTime(date.getTime() - 3600 * 1000 * 24);
|
return date;
|
},
|
},
|
{
|
text: '上周',
|
value: () => {
|
const date = new Date();
|
date.setTime(date.getTime() - 3600 * 1000 * 24 * 7);
|
return date;
|
},
|
},
|
];
|
</script>
|
|
<style lang="scss" scoped>
|
.el-popper {
|
max-width: 60%;
|
}
|
</style>
|
