prb_info部分

DreamingJ · Jun 6, 2021 · 0fd982e · 0fd982e
1 parent 46a3064
commit 0fd982e
Showing 10 changed files with 286 additions and 35 deletions.
diff --git a/LTEsystem/urls.py b/LTEsystem/urls.py
@@ -41,6 +41,7 @@
     path('infoquery/enodeb/', views.enodeb_info),
     path('infoquery/kpi/', views.kpi_info),
     path('infoquery/prb/', views.prb_info),
+    path('infoquery/prb_stat/', views.prb_stat),
     path('analyze/', views.analyze2),
     path('load_image/', views.load_image),
     path('load_csv/', views.load_csv),

diff --git a/login/static/login/css/image_kpi.css b/login/static/login/css/image_kpi.css
@@ -0,0 +1,58 @@
+body {
+    height: 100%;
+    background-image: url('../images/bg2.jpg');
+}
+
+#header {
+    font-size: 35px;
+    color: #123844bf;
+    margin: 10px 0 10px 0px;
+    font-weight: bold;
+    align-self: center;
+}
+
+.sub-header {
+    font-size: 30px;
+    color: #0c1a27ed;
+    /*margin: 10px 0 0px 0px;*/
+    font-weight: bold;
+    align-self: center;
+}
+
+.container {
+    display: flex;
+    flex-direction: column;
+    align-items: center;
+}
+
+.img-container{
+    border-style: ridge;
+    border-color:#0daff085;
+    border-width: 6px;
+    margin-top: 30px;
+}
+
+.button-wrapper {
+    display: flex;
+    align-items: center;
+    flex-direction: row;
+    justify-content: space-between;
+    width: 400px;
+    margin-top: 20px;
+    margin-bottom: 20px;
+}
+
+p{
+    font-size: 15px;
+    font-weight: bold;
+}
+
+.title {
+    margin: 10px 10px 10px 0;
+    font-size: 28px;
+    font-weight: 550;
+    color: #212529;
+}
+
+
+
diff --git a/login/static/login/css/kpi_info.css b/login/static/login/css/kpi_info.css
@@ -27,6 +27,7 @@ body {
 
 .wrapper {
     display: flex;
+    align-items: center;
     flex-direction: row;
     justify-content: center;
     margin-top: 20px;
@@ -36,7 +37,35 @@ body {
     display: flex;
     flex-direction: column;
     justify-content: space-between;
-    margin-top: 0;
+    margin-right: 30px;
+}
+
+.name-container{
+    align-items: center;
+    background-color: #88c7dd85;
+    border-radius: 10px;
+    opacity: 0.8;
+    height: 150px;
+    margin-top: 10px;
+}
+
+.date-container{
+    align-items: center;
+    background-color: #88c7dd85;
+    border-radius: 10px;
+    opacity: 0.8;
+    height: 150px;
+    /*width: 300px;*/
+    margin-top: 60px;
+}
+
+p{
+    font-size: 18px;
+    font-weight: bold;
+}
+
+button{
+    margin-left: 20px;
 }
 
 .attr-container{
@@ -46,6 +75,10 @@ body {
     border-radius: 4px;
 }
 
+.index{
+    margin-left: 10px;
+}
+
 .title {
     margin: 10px 10px 10px 0;
     font-size: 28px;
@@ -57,4 +90,12 @@ body {
     margin: 0 20px 20px;
 }
 
+.button-container{
+    display: flex;
+    height: 200px;
+    align-items: flex-start;
+    justify-content: space-between;
+    flex-direction: column;
+}
+
 
diff --git a/login/static/login/images/kpi_info.png b/login/static/login/images/kpi_info.png
diff --git a/login/static/login/images/prb_info.png b/login/static/login/images/prb_info.png
diff --git a/login/templates/login/query/image_kpi.html b/login/templates/login/query/image_kpi.html
@@ -8,7 +8,7 @@
     <!-- 上述meta标签*必须*放在最前面，任何其他内容都*必须*跟随其后！ -->
     <!-- Bootstrap CSS -->
     <link href="https://cdn.bootcdn.net/ajax/libs/twitter-bootstrap/5.0.0-beta3/css/bootstrap.min.css" rel="stylesheet">
-    <link href="{% static 'login/css/kpi_info.css' %}" rel="stylesheet"/>
+    <link href="{% static 'login/css/image_kpi.css' %}" rel="stylesheet"/>
     <title>LTE网络干扰分析系统-业务查询</title>
 
 </head>
@@ -18,18 +18,24 @@
     <div id="header">LTE网络干扰分析系统
     </div>
     <div class="sub-header">查询结果</div>
-    <div class="left-button-container">
-        <a href="/infoquery/kpi/">
-        <button class="btn btn-primary float-right">返回查询</button>
-        </a>
-    </div>
-    <div class="right-button-container">
-        <a href="/load_image/">
-        <button class="btn btn-primary float-right">导出图片</button>
-        </a>
-    </div>
+
     <div class="img-container">
-            <img src="{% static "login/images/kpi_info.png" %}" alt="kpi信息查询折线图" height=400 width=1000/>
+        <img src="{% static img_dir %}" alt="kpi信息查询折线图" height=320 width=800/>
+    </div>
+    <div class="button-wrapper">
+        <div class="left-button-container">
+            <a href="/infoquery/kpi/">
+                <button class="btn btn-primary float-right">返回查询</button>
+            </a>
+        </div>
+        <div class="right-button-container">
+            <form id="kpi_info" action="/load_image/" method="post">
+                {% csrf_token %}
+                {#        <a href="/load_image/">#}
+                <button class="btn btn-primary float-right" name="export" value={{ belong_func }}>导出图片</button>
+                {#        </a>#}
+            </form>
+        </div>
     </div>
 </div>
 

diff --git a/login/templates/login/query/info_query.html b/login/templates/login/query/info_query.html
@@ -47,7 +47,7 @@
             </div>
             <div class="business1">
                 <a href="/infoquery/prb/">
-                    <button type="button" class="btn btn-primary float-right">PRB信息统计与查询
+                    <button type="button" class="btn btn-primary float-right">PRB干扰信息查询与统计
                     </button>
                 </a>
             </div>

diff --git a/login/templates/login/query/kpi_info.html b/login/templates/login/query/kpi_info.html
@@ -29,6 +29,7 @@
         <form class="wrapper" id="kpi_info" action="/infoquery/kpi/" method="post">
             {% csrf_token %}
             <div class="left-wrapper">
+            <p>请选择您要查询的属性:</p>
                 <div class="name-container">
                     <p>小区名称</p>
                     <label>输入</label>
@@ -44,18 +45,15 @@
                     <p>日期</p>
                     起始：
                     <input id="date" type="date" name="date_start" value="2020-07-17" min="2020-07-17"
-                           max="2020-07-19" required>
-                    <p>结束：</p>
+                           max="2020-07-19" required><br><br>
+                    结束：
                     <input id="date" type="date" name="date_end" value="2020-07-19" min="2020-07-17"
                            max="2020-07-19" required>
                 </div>
-                <div class="button-container">
-                    <button type="submit" class="btn btn-primary float-right">确认</button>
-                </div>
+
             </div>
 
-            <div class="right-wrapper">
-                <p>请选择您要查询的属性:</p>
+
                 <div class="attr-container">
                     <br>
                     <input type="radio" name="attr" value="rpc_establish" checked>RRC连接建立完成次数<br>
@@ -97,7 +95,9 @@
                     <input type="radio" name="attr" value="enb_in_succ">eNB内切换出成功次数<br>
                     <input type="radio" name="attr" value="eno_in_request">eNB内切换出请求次数<br>
                 </div>
-            </div>
+        <div class="button-container">
+                    <button type="submit" class="btn btn-primary float-right">确认</button>
+                </div>
         </form>
     </div>
 

diff --git a/login/templates/login/query/prb_info.html b/login/templates/login/query/prb_info.html
@@ -1,10 +1,99 @@
-<!DOCTYPE html>
+<!doctype html>
+{% load static %}
 <html lang="en">
 <head>
-    <meta charset="UTF-8">
-    <title>Title</title>
+    <!-- Required meta tags -->
+    <meta charset="utf-8">
+    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
+    <!-- 上述meta标签*必须*放在最前面，任何其他内容都*必须*跟随其后！ -->
+    <!-- Bootstrap CSS -->
+    <link href="https://cdn.bootcdn.net/ajax/libs/twitter-bootstrap/5.0.0-beta3/css/bootstrap.min.css" rel="stylesheet">
+    <link href="{% static 'login/css/kpi_info.css' %}" rel="stylesheet"/>
+    <title>LTE网络干扰分析系统-业务查询</title>
+
 </head>
 <body>
 
+<div class="container">
+    <div id="header">LTE网络干扰分析系统
+    </div>
+    <div class="sub-header">PRB干扰数据查询</div>
+    {% if message %}
+        <script>
+            alert('{{ message }}');
+        </script>
+    {% endif %}
+    {#    <div class="wrapper">#}
+    {#    </div>#}
+    <div>
+        <form class="wrapper" id="prb_info" action="/infoquery/prb/" method="post">
+            {% csrf_token %}
+            <div class="left-wrapper">
+                <p>请选择您要查询的属性:</p>
+                <div class="name-container">
+                    <p>网元名称</p>
+                    <label>输入</label>
+                    <input type="text" name="cellname" id="cellname" form="prb_info"><br>
+                    <label>or<br>选择</label>
+                    <select name="selected" form="prb_info">
+                        {% for name in name_list %}
+                            <option value={{ name }}>{{ name }}</option>
+                        {% endfor %}
+                    </select>
+                </div>
+                <div class="date-container">
+                    <p>起止时间（小时级）</p>
+                    起始：
+                    <input id="date" type="datetime-local" name="date_start" value="2020-07-17T00:00:00"
+                           min="2020-07-17T00:00:00"
+                           max="2020-07-19T23:00:00" step="3600" required><br><br>
+                    结束：
+                    <input id="date" type="datetime-local" name="date_end" value="2020-07-19T23:00:00"
+                           min="2020-07-17T00:00:00"
+                           max="2020-07-19T23:00:00" step="3600" required>
+                </div>
+
+            </div>
+
+            <div class="right-wrapper">
+                <p>请选择第多少个PRB上检测到的干扰噪声的平均值</p>
+                <div class="attr-container">
+                    {#                <select name="selected-index">#}
+                    {#                    {% for i in range_list %}#}
+                    {#                    <option value={{ i }}>{{ i }}</option>#}
+                    {#                    {% endfor %}#}
+                    {#                </select>#}
+                    <input class="index" type="radio" name="index" value=0 checked>第0个<br>
+                    {% for i in range_list %}
+                        <input class="index" type="radio" name="index" value={{ i }}>第{{ i }}个<br>
+                    {% endfor %}
+                </div>
+            </div>
+            <div class="button-container">
+                <a href="/infoquery/prb_stat/">
+                    <button type="button" class="btn btn-primary float-right">生成新表并导出
+                    </button>
+                </a>
+                <button type="submit" class="btn btn-primary float-right">确认查询</button>
+            </div>
+        </form>
+    </div>
+
+    {#    <div>#}
+    {#        {% for name in attr_list %}#}
+    {#            <p>{{ name }}<p>#}
+    {#        {% endfor %}#}
+    {#    </div>#}
+</div>
+
+
+<div id="footer" style="clear:both;text-align:center;margin-top: 200px;">© BUPT数据库课设小组</div>
+<!-- Optional JavaScript -->
+<!-- jQuery first, then Popper.js, then Bootstrap JS -->
+{#    以下三者的引用顺序是固定的#}
+<script src="https://cdn.bootcss.com/jquery/3.3.1/jquery.js"></script>
+<script src="https://cdn.bootcss.com/popper.js/1.15.0/umd/popper.js"></script>
+<script src="https://cdn.bootcss.com/twitter-bootstrap/4.3.1/js/bootstrap.min.js"></script>
+
 </body>
 </html>