<!DOCTYPE html>
|
<html>
|
<head>
|
<div th:replace="common/header.html"></div>
|
|
|
</head>
|
<body th:class="${application.sidebarCollapse}">
|
<div th:replace="common/chart.html"></div>
|
|
<div class="wrapper">
|
|
<div th:replace="common/navbar.html"></div>
|
|
<div th:replace="common/aside.html"></div>
|
|
<!-- Content Wrapper. Contains page content -->
|
<div class="content-wrapper" style="font-size:0.90rem">
|
<!-- Content Header (Page header) -->
|
<section class="content-header" style="height:38px">
|
<div class="container-fluid">
|
<div class="row mb-2" style="margin-top: -7px;">
|
<div class="col-sm-6"></div>
|
<div class="col-sm-6">
|
<ol class="breadcrumb float-sm-right">
|
<li class="breadcrumb-item"><a href="javascript:history.back()">返回上级</a></li>
|
</ol>
|
</div>
|
</div>
|
</div><!-- /.container-fluid -->
|
</section>
|
|
<!-- Main content -->
|
<section class="content">
|
<div class="container-fluid">
|
<div class="row">
|
|
<div class="col-md-12">
|
<div class="card">
|
<div class="card-header">
|
<h3 class="card-title"><i class="fas fa-table nav-icon"></i> 数据表信息</h3>
|
<div class=" float-sm-right">
|
<!-- SEARCH FORM -->
|
<form class="form-inline ml-3" th:action="@{'/dbTable/list'}">
|
<th:block th:if="${session.LOGIN_KEY.role != 'guest'}">
|
<button type="button" onclick="delChecks('/dbTable/del')" class="btn bg-danger btn-sm" style="margin-right:5px;">删除</button>
|
<button type="button" onclick="add()" class="btn btn-primary btn-sm" style="margin-right:5px;">添加</button>
|
</th:block>
|
<div class="input-group input-group-sm">
|
<select style="width:150px;margin-right:5px;" class="form-control" name="dbInfoId" id="dbInfoId" onchange="searchByDb()">
|
<option value="">选择数据源</option>
|
<th:block th:each="item,iterStat : ${dbInfoList}">
|
<option th:value="${item.id}" th:text="${item.aliasName}">Alabama</option>
|
</th:block>
|
</select>
|
|
</div>
|
<div th:replace="common/accountSelect.html"></div>
|
<div class="input-group input-group-sm">
|
<input class="form-control" id="remark" name="remark" autocomplete="off" th:value="${dbTable.remark}" type="text" placeholder="表别名">
|
<div class="input-group-append">
|
<button class="btn btn-primary" type="submit">
|
<i class="fas fa-search"></i>
|
</button>
|
</div>
|
|
</div>
|
</form>
|
|
</div>
|
</div>
|
<!-- /.card-header -->
|
<div class="card-body">
|
<table class="table table-bordered table-hover">
|
<thead>
|
<tr>
|
<th style="width: 20px"> <input type="checkbox" value="" name="checkall" id="checkall"></th>
|
<th style="width: 60px">序号</th>
|
<th>数据源</th>
|
<th>表别名</th>
|
<th:block th:if="${dbTable.orderBy == 'TABLE_COUNT'}">
|
<th:block th:if="${dbTable.orderType == 'ASC'}">
|
<th style="cursor:pointer" onclick="searchByOrder('TABLE_COUNT','DESC')">数据量<small class="text-success mr-1 float-right"><i class="fas fa-arrow-up" style="vertical-align:bottom;"></i> </small>
|
</th:block>
|
<th:block th:if="${dbTable.orderType == 'DESC'}">
|
<th style="cursor:pointer" onclick="searchByOrder('TABLE_COUNT','ASC')">数据量<small class="text-success mr-1 float-right"><i class="fas fa-arrow-down" style="color: #dc3545!important;vertical-align:bottom;"></i> </small>
|
</th:block>
|
</th:block>
|
<th:block th:if="${dbTable.orderBy ne 'TABLE_COUNT'}">
|
<th style="cursor:pointer" onclick="searchByOrder('TABLE_COUNT','ASC')">数据量<small class="text-success mr-1 float-right"><i class="fas fa-arrow-up" style="vertical-align:bottom;"></i><i class="fas fa-arrow-down" style="color: #dc3545!important;vertical-align:bottom;"></i></small>
|
</th:block>
|
</th>
|
<th data-trigger="hover" data-container="body" data-toggle="popover" data-placement="top" data-content="表达式成立时候，就会发送告警通知">告警表达式</th>
|
<th>数据状态</th>
|
<th>监控状态</th>
|
<th>更新时间</th>
|
<th th:if="${application.userInfoManage == 'true' && session.LOGIN_KEY.role == 'admin'}">账号</th>
|
<th>操作</th>
|
</tr>
|
</thead>
|
<tbody>
|
<th:block th:each="item,iterStat : ${page.list}">
|
<tr>
|
<td><input type="checkbox" th:value="${item.id}" name="todo2" th:id="${item.id}+'_check'"/></td>
|
<td th:text="${iterStat.index+1}">1</td>
|
<td><image th:src="${item.image}"/> <span th:text="${item.tableName}"></span></td>
|
<td th:text="${item.remark}">Update software</td>
|
<td th:text="${item.tableCount}">Update software</td>
|
<td><code data-trigger="hover" data-container="body" data-toggle="popover" data-placement="top" th:data-content="${item.resultExp}" class="highlighter-rouge" style="font-size:100%" th:text="${#strings.abbreviate(item.resultExp,50)}">result</code></td>
|
<td>
|
<th:block th:if="${item.state == '2'}">
|
<span data-trigger="hover" data-container="body" data-toggle="popover" data-placement="top" data-content="sql执行失败或告警表达式成立" class="badge bg-danger">失败</span>
|
</th:block>
|
<th:block th:if="${item.state == '1'}">
|
<span class="badge bg-primary" >正常</span>
|
</th:block>
|
</td>
|
<td>
|
<th:block th:if="${item.active == '1'}">
|
<span class="badge bg-primary">监控中</span>
|
</th:block>
|
<th:block th:if="${item.active == '2'}">
|
<span class="badge bg-danger">已停止</span>
|
</th:block>
|
</td>
|
<td th:text="${#dates.format(item.createTime,'yyyy-MM-dd HH:mm:ss')}">Update software</td>
|
<th th:text="${item.account}" th:if="${application.userInfoManage == 'true' && session.LOGIN_KEY.role == 'admin'}"></th>
|
<td>
|
<th:block th:if="${session.LOGIN_KEY.role != 'guest'}">
|
<button type="button" th:onclick="view([[${item.id}]])" class="btn bg-gradient-primary btn-sm">编辑</button>
|
<button type="button" th:onclick="del([[${item.id}]])" class="btn bg-gradient-danger btn-sm">删除</button>
|
</th:block>
|
<button type="button" th:onclick="viewChart([[${item.id}]])" class="btn bg-gradient-primary btn-sm">图表</button>
|
</td>
|
</tr>
|
</th:block>
|
|
</tbody>
|
</table>
|
</div>
|
<!-- /.card-body -->
|
<div th:replace="common/page.html"></div>
|
</div>
|
<!-- /.card -->
|
|
|
</div>
|
|
</div>
|
</div>
|
</section>
|
</div>
|
|
|
<div th:replace="common/footer.html"></div>
|
|
</div>
|
<!-- ./wrapper -->
|
|
<script th:src="@{'/static/js/dbtable.js?v=3.4.1'}"></script>
|
|
<script th:inline="javascript">
|
var msg = [[${msg}]];
|
if(msg!='' && msg!=null){
|
toastr.info(msg);
|
}
|
$(document).ready(function(){
|
$("#dbInfoId").val([[${dbTable.dbInfoId}]]);
|
$("#account").val([[${dbTable.account}]]);
|
});
|
</script>
|
|
</body>
|
</html>
|
