375 lines
12 KiB
Cheetah
375 lines
12 KiB
Cheetah
<!doctype html>
|
||
<html lang="zh-CN">
|
||
<head>
|
||
<meta charset="UTF-8">
|
||
<meta name="viewport"
|
||
content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0">
|
||
<meta http-equiv="X-UA-Compatible" content="ie=edge">
|
||
<title>Title</title>
|
||
|
||
{{/* <script src="/resource/js/default-passive-events-index.umd.js"></script>*/}}
|
||
|
||
<link rel="stylesheet" href="/resource/css/element-index.css"/>
|
||
|
||
|
||
<!-- Import component library -->
|
||
<script src="/resource/js/vue.global.js"></script>
|
||
|
||
<script src="/resource/js/element-index.full.js"></script>
|
||
<script src="/resource/js/element-zh-cn.js"></script>
|
||
|
||
<link rel="stylesheet" href="/resource/css/vxe-style.css">
|
||
<script src="/resource/js/xe-utils.js"></script>
|
||
<script src="/resource/js/vxe-table.js"></script>
|
||
|
||
|
||
<style>
|
||
#app {
|
||
width: 90%;
|
||
margin: 0 auto;
|
||
}
|
||
|
||
|
||
</style>
|
||
</head>
|
||
<body>
|
||
|
||
<div id="app">
|
||
<div class="header">
|
||
<el-form :inline="true" :model="form" class="demo-form-inline">
|
||
<el-form-item label="时间范围" style="width: 350px">
|
||
<el-date-picker
|
||
v-model="form.date"
|
||
type="daterange"
|
||
start-placeholder="Start date"
|
||
end-placeholder="End date"
|
||
format="YYYY-MM-DD"
|
||
date-format="YYYY-MM-DD"
|
||
value-format="YYYY-MM-DD"
|
||
:clearable="false"
|
||
/>
|
||
</el-form-item>
|
||
|
||
<el-form-item label="管理员">
|
||
<el-select v-model="form.admin_name" placeholder="选择" clearable>
|
||
<el-option v-for="item in selectInfo.adminNameList" :label="item.AdminName"
|
||
:value="item.AdminName"/>
|
||
</el-select>
|
||
</el-form-item>
|
||
|
||
|
||
<el-form-item label="sql信息" style="width: 500px">
|
||
<el-input v-model="form.query_info" placeholder="sql信息" clearable/>
|
||
</el-form-item>
|
||
|
||
|
||
</el-form>
|
||
|
||
<div>
|
||
<el-button type="primary" @click="listSqlQueryLog">查询</el-button>
|
||
</div>
|
||
</div>
|
||
|
||
|
||
<div>
|
||
|
||
<div style="margin-top: 15px; height: 750px">
|
||
<vxe-table
|
||
height="100%"
|
||
stripe
|
||
:data="tableData"
|
||
:column-config="{resizable: true}"
|
||
>
|
||
<vxe-column width="80" field="Id" title="ID" show-overflow></vxe-column>
|
||
<vxe-column width="200" field="QueryTime" title="调用时间" show-overflow></vxe-column>
|
||
<vxe-column width="130" field="Ip" title="IP" show-overflow></vxe-column>
|
||
<vxe-column width="100" field="AdminName" title="账号" show-overflow></vxe-column>
|
||
<vxe-column width="100" field="AdminRealName" title="姓名" show-overflow></vxe-column>
|
||
<vxe-column width="100" field="Project" title="项目" show-overflow></vxe-column>
|
||
<vxe-column width="200" field="RequestPath" title="接口地址" show-overflow></vxe-column>
|
||
<vxe-column width="200" field="MenuName" title="接口名称" show-overflow></vxe-column>
|
||
<vxe-column field="CallInfo" title="调用路径" show-overflow></vxe-column>
|
||
|
||
<vxe-column width="200" field="Query" title="SQL" show-overflow>
|
||
<template #default="{ row }">
|
||
<span style="cursor: pointer" @click="copText(row.Query)">${ row.Query }$</span>
|
||
</template>
|
||
</vxe-column>
|
||
|
||
<vxe-column width="100" field="" title="操作">
|
||
<template #default="{ row }">
|
||
<el-button size="small" type="success" @click="showQuerySql(row)">查看</el-button>
|
||
</template>
|
||
</vxe-column>
|
||
|
||
|
||
</vxe-table>
|
||
</div>
|
||
|
||
|
||
<div style="margin-top: 15px; width: 100%; display: flex; justify-content: center">
|
||
<el-pagination
|
||
background
|
||
:total="pageInfo.totalCount"
|
||
v-model:current-page="pageInfo.currentPage"
|
||
v-model:page-size="pageInfo.pageSize"
|
||
layout="prev, slot, next, sizes"
|
||
@size-change="listSqlQueryLog(true)"
|
||
@current-change="listSqlQueryLog(false)"
|
||
:page-sizes="[200, 600, 1000]"
|
||
>
|
||
<template #default>
|
||
<ul class="el-pager">
|
||
<li class="is-active number">${ pageInfo.currentPage }$</li>
|
||
</ul>
|
||
</template>
|
||
|
||
</el-pagination>
|
||
</div>
|
||
</div>
|
||
|
||
|
||
<el-dialog
|
||
v-model="dialogVisible"
|
||
title="Title"
|
||
width="30%"
|
||
>
|
||
<div>
|
||
<el-input
|
||
v-model="dialogRow.Query"
|
||
rows="20"
|
||
type="textarea"
|
||
placeholder="Please input"
|
||
/>
|
||
</div>
|
||
<template #footer>
|
||
<el-button type="primary" @click="dialogRow = {}; dialogVisible = false">确定</el-button>
|
||
</template>
|
||
|
||
</el-dialog>
|
||
|
||
</div>
|
||
|
||
<script>
|
||
|
||
function getDate(diff) {
|
||
let date = new Date(); // 当前日期和时间
|
||
|
||
date.setDate(date.getDate() + diff)
|
||
|
||
const year = date.getFullYear();
|
||
const month = (date.getMonth() + 1).toString().padStart(2, '0'); // 月份从0开始，需要加1，并确保是两位数
|
||
const day = date.getDate().toString().padStart(2, '0'); // 确保是两位数的日期
|
||
|
||
return `${year}-${month}-${day}`;
|
||
}
|
||
|
||
|
||
const {createApp, ref, reactive, toRefs, toRef} = Vue
|
||
|
||
|
||
console.log(getDate(5))
|
||
|
||
|
||
const vm = createApp({
|
||
delimiters: ['${', '}$'],
|
||
setup() {
|
||
const data = reactive({
|
||
mailMessage: "",
|
||
form: {
|
||
game_id: "",
|
||
query_info: "",
|
||
date: [getDate(-15), getDate(0)],
|
||
admin_name: "",
|
||
},
|
||
tableData: [],
|
||
pageInfo: {
|
||
currentPage: 1,
|
||
pageSize: 200,
|
||
},
|
||
dialogVisible: false,
|
||
dialogRow: {},
|
||
selectInfo: {
|
||
adminNameList: []
|
||
}
|
||
|
||
})
|
||
|
||
|
||
setTimeout(() => {
|
||
listSqlQueryLog()
|
||
selectInfo()
|
||
})
|
||
|
||
const resetPageInfo = () => {
|
||
data.pageInfo.currentPage = 1
|
||
}
|
||
|
||
|
||
const selectInfo = () => {
|
||
let loading = ElementPlus.ElLoading.service({
|
||
fullscreen: true,
|
||
lock: true
|
||
})
|
||
|
||
fetch("/SelectInfo", {
|
||
method: 'POST', // 或 'POST'、'PUT' 等
|
||
})
|
||
.then(response => {
|
||
// 检查请求是否成功（状态码为 200 到 299）
|
||
if (!response.ok) {
|
||
throw new Error(`HTTP error! Status: ${response.status}`);
|
||
}
|
||
// 将响应解析为 JSON
|
||
return response.json();
|
||
})
|
||
.then(res => {
|
||
// 处理返回的 JSON 数据
|
||
if (res.Code != 0) {
|
||
console.log(res);
|
||
ElementPlus.ElMessage.error(res.Message)
|
||
return
|
||
}
|
||
|
||
data.selectInfo.adminNameList = res.Data.AdminNameList
|
||
|
||
|
||
})
|
||
.catch(error => {
|
||
// 处理错误
|
||
console.error('Fetch error:', error);
|
||
alert(error)
|
||
}).finally(
|
||
() => {
|
||
loading.close()
|
||
})
|
||
|
||
|
||
}
|
||
|
||
const copText = (text) => {
|
||
var textToCopy = text;
|
||
var textArea = document.createElement("textarea");
|
||
textArea.value = textToCopy;
|
||
document.body.appendChild(textArea);
|
||
textArea.select();
|
||
|
||
try {
|
||
document.execCommand('copy');
|
||
console.log('Text copied to clipboard');
|
||
ElementPlus.ElMessage.success("复制成功")
|
||
} catch (err) {
|
||
console.error('Unable to copy text', err);
|
||
}
|
||
|
||
document.body.removeChild(textArea);
|
||
|
||
// navigator.clipboard.writeText(text)
|
||
// .then(function () {
|
||
// ElementPlus.ElMessage.success("复制成功")
|
||
// })
|
||
// .catch(function (err) {
|
||
// console.error('复制失败', err);
|
||
// ElementPlus.ElMessage.error("复制失败")
|
||
// });
|
||
}
|
||
|
||
|
||
const showQuerySql = (row) => {
|
||
console.log(row)
|
||
data.dialogRow = JSON.parse(JSON.stringify(row))
|
||
data.dialogVisible = true
|
||
}
|
||
|
||
const listSqlQueryLog = (reset) => {
|
||
if (reset === true) {
|
||
resetPageInfo()
|
||
}
|
||
|
||
let loading = ElementPlus.ElLoading.service({
|
||
fullscreen: true,
|
||
lock: true
|
||
})
|
||
|
||
// console.log(data.form)
|
||
// return
|
||
let req = {
|
||
start_date: "",
|
||
end_date: "",
|
||
// game_id: (/^\d+$/).test(data.form.game_id) ? Number(data.form.game_id) : -1,
|
||
query_info: data.form.query_info,
|
||
page: data.pageInfo.currentPage,
|
||
limit: data.pageInfo.pageSize,
|
||
admin_name: data.form.admin_name,
|
||
}
|
||
|
||
if (data.form.date) {
|
||
req.start_date = data.form.date[0]
|
||
req.end_date = data.form.date[1]
|
||
}
|
||
|
||
|
||
const requestOptions = {
|
||
method: 'POST', // 或 'POST'、'PUT' 等
|
||
headers: {
|
||
'Content-Type': 'application/json', // 指定请求类型为 JSON
|
||
// 可以添加其他请求头，比如认证信息等
|
||
},
|
||
// 如果是 POST 或 PUT 请求，可以在 body 中添加请求数据
|
||
|
||
|
||
body: JSON.stringify(req)
|
||
};
|
||
|
||
// 使用 fetch 发起请求
|
||
fetch("/ListSqlQueryLog", requestOptions)
|
||
.then(response => {
|
||
// 检查请求是否成功（状态码为 200 到 299）
|
||
if (!response.ok) {
|
||
throw new Error(`HTTP error! Status: ${response.status}`);
|
||
}
|
||
// 将响应解析为 JSON
|
||
return response.json();
|
||
})
|
||
.then(res => {
|
||
// 处理返回的 JSON 数据
|
||
if (res.Code != 0) {
|
||
console.log(res);
|
||
alert(res.Message)
|
||
return
|
||
}
|
||
|
||
|
||
data.tableData = res.Data.List
|
||
data.pageInfo.totalCount = res.Data.TotalCount
|
||
|
||
|
||
})
|
||
.catch(error => {
|
||
// 处理错误
|
||
console.error('Fetch error:', error);
|
||
alert(error)
|
||
}).finally(
|
||
() => {
|
||
loading.close()
|
||
}
|
||
);
|
||
}
|
||
|
||
return {
|
||
...toRefs(data),
|
||
listSqlQueryLog, showQuerySql, copText
|
||
}
|
||
|
||
|
||
}
|
||
})
|
||
|
||
|
||
vm.use(ElementPlus, {locale: ElementPlusLocaleZhCn})
|
||
vm.use(VXETable)
|
||
vm.mount("#app")
|
||
</script>
|
||
|
||
</body>
|
||
</html> |