付延余
2022-12-16 f0f8ee8c4a945adbc742d9bab69382b28ad311fb
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
<!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">
      <div class="container-fluid">
        <div class="row mb-2">
          <div class="col-sm-6">
            <h1></h1>
          </div>
          <div class="col-sm-6">
            <ol class="breadcrumb float-sm-right">
              <li class="breadcrumb-item active"></li>
            </ol>
          </div>
        </div>
      </div><!-- /.container-fluid -->
    </section>
 
    <!-- Main content -->
    <section class="content">
      <div class="container-fluid">
        <div class="row">
 
  <div class="col-md-10">
    <div class="card card-primary">
      <div class="card-header">
        <h3 class="card-title">添加数据表,监控数据量变化</h3>
          <div class=" float-sm-right">
              <a href="javascript:history.back()">返回</a>
          </div>
      </div>
      <!-- /.card-header -->
      <!-- form start -->
        <form role="form" id="form1" method="post" th:action="@{'/dbTable/save'}">
            <input type="hidden" name="id" th:value="${dbTable.id}"/>
            <div class="card-body">
                <div class="form-group">
                    <label><font color="red">*</font>数据源</label>
                    <select class="validate[required] form-control"  name="dbInfoId" id="dbInfoId">
                        <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 class="form-group">
                    <label for="fromPwd"><font color="red">*</font>表别名</label>
                    <input type="text" autocomplete="off" th:value="${dbTable.remark}" class="validate[required,maxSize[40]] form-control" name="remark" id="remark" placeholder="给表定义一个别名,如:订单表">
                </div>
                <div class="form-group">
                    <label><font color="red">*</font>统计SQL语句<span class="text-muted">(不能输入sql敏感字符:<span th:text="${sqlInKeys}"></span>)</span></label>
                    <textarea class="validate[required,maxSize[2000]] form-control"   name="whereVal" id="whereVal"
                              th:text="${dbTable.whereVal}"  rows="3" placeholder="如:SELECT COUNT(*) FROM CPU_STATE WHERE status='1' OR status='2'"></textarea>
                </div>
                <div class="form-group">
                    <label >SQL执行结果的取值列名<span class="text-muted">(系统默认取SQL查询结果的第一行的某一列,列值需是整型数字,若列值是浮点型系统会自动转为整型。若返回结果只有一列,此处可为空)</span></label>
                    <input type="text" autocomplete="off" th:value="${dbTable.tableName}" class="validate[maxSize[40]] form-control" name="tableName" id="tableName" placeholder="如:COUNT(*)">
                </div>
                <div class="form-group">
                    <label >告警表达式<span class="text-muted">(表达式成立时即告警,不成立不告警,如:<code class="highlighter-rouge" style="font-size:100%">(result + 10)>=100</code>,其中<code class="highlighter-rouge" style="font-size:100%">result</code>为固定写法,标识为上面的SQL执行结果值(系统会自动替换为数值),注意表达式需为英文输入法拼写)</span></label>
                    <input type="text" autocomplete="off" th:value="${dbTable.resultExp}" class="validate[maxSize[100]] form-control" name="resultExp" id="resultExp" placeholder="如:(result + 10)>=100">
                </div>
                <div class="form-group clearfix">
                    <label><font color="red">*</font>监控状态</label></br>
                    <th:block th:if="${#strings.isEmpty(dbTable.active)}" >
                        <div class="icheck-primary d-inline">
                            <input type="radio" id="radioPrimary1" name="active" value="1" checked>
                            <label for="radioPrimary1"> 启用监控 </label>
                        </div>
                        <div class="icheck-danger d-inline">
                            <input type="radio" id="radioPrimary3" value="2" name="active" >
                            <label for="radioPrimary3">停止监控</label>
                        </div>
                    </th:block>
                    <th:block th:if="${dbTable.active  == '1'}">
                        <div class="icheck-primary d-inline">
                            <input type="radio" id="radioPrimary1" name="active" value="1" checked>
                            <label for="radioPrimary1"> 启用监控 </label>
                        </div>
                        <div class="icheck-danger d-inline">
                            <input type="radio" id="radioPrimary3" value="2" name="active" >
                            <label for="radioPrimary3">停止监控</label>
                        </div>
                    </th:block>
                    <th:block th:if="${dbTable.active  == '2'}">
                        <div class="icheck-primary d-inline">
                            <input type="radio" id="radioPrimary1" value="1"  name="active" >
                            <label for="radioPrimary1"> 启用监控 </label>
                        </div>
                        <div class="icheck-danger d-inline">
                            <input type="radio" id="radioPrimary3" value="2"  name="active" checked>
                            <label for="radioPrimary3">停止监控</label>
                        </div>
                    </th:block>
                </div>
 
 
            </div>
            <!-- /.card-body -->
 
            <div class="card-footer">
                <button type="submit" class="btn btn-primary btn-sm" style="margin-right:10px;">保 存</button>
                <button type="button"  th:onclick="goback()"  class="btn bg-gradient-danger btn-sm">返 回</button>
            </div>
 
        </form>
      <!-- /.card-body -->
    </div>
    <!-- /.card -->
 
 
  </div>
 
        </div>
      </div>
    </section>
  </div>
 
 
  <div th:replace="common/footer.html"></div>
 
</div>
<!-- ./wrapper -->
<link rel="stylesheet" th:href="@{'/static/js/jQuery/validationEngine.jquery.css'}" type="text/css"/>
<script th:src="@{'/static/js/jQuery/jquery.validationEngine-zh_CN.js'}" type="text/javascript" charset="utf-8"></script>
<script th:src="@{'/static/js/jQuery/jquery.validationEngine.js'}" type="text/javascript" charset="utf-8"></script>
<script th:inline="javascript">
    $(document).ready(function(){
        $("#form1").validationEngine();
        $("#dbInfoId").val([[${dbTable.dbInfoId}]]);
    });
 
    function goback() {
            window.location.href = "/wgcloud/dbTable/list";
    }
    var msg = [[${msg}]];
    if(msg!='' && msg!=null){
        toastr.error(msg);
    }
 
</script>
</body>
</html>