summaryrefslogtreecommitdiffstats
path: root/admportal/views/sdnfc/viewTables.ejs
blob: b950d8f9a2983cad519d1db0d0af0fcf3d4d8aff (plain)
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
<!DOCTYPE html>
<html lang="en">
<head>

<meta charset="UTF-8" />
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<% include ../partials/head %>
<% include ../partials/header %>
<script type="text/javascript" src="/javascripts/admportal.js" async></script>
<title>SDN-FC AdminPortal</title>
<script class="init">
    $(document).ready(function() {
    $('#viewTables').DataTable( {
        "order": [[ 0, "asc" ]]
    } );
} );
</script>
</head>

<body>

<div class="well well-sm">
<h3>View Database Tables
</div>

<% if ( typeof result != 'undefined' ) {
		if (result.code.length > 0) {
            if ( result.code == 'success' ) { %>
                <div class='alert alert-success' role='alert'>
                <%
                for ( x in result.msg ){ %>
                    <div><%= result.msg[x] %></div>
                <% } %>
                </div>
            <% } else { %>
                <div class='alert alert-danger' role='danger'>
                <%
                for ( x in result.msg ){ %>
                    <div><%= result.msg[x] %></div>
                <% } %>
                </div>
            <% } %>
        <% } %>
<% } %>

<% if( typeof privilege != 'undefined'){
    var priv = privilege.privilege;
} else {
    var priv = 'A';
} %>

<!-- Single button -->
<nav class="navbar navbar-default">
<div class="container-fluid">
<div class="navbar-header">

<div class="btn-group">
  <button type="button" class="btn btn-primary dropdown-toggle navbar-btn" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">
    Table <span class="caret"></span>
  </button>
    <ul class="dropdown-menu" role="menu">
    <% for ( var i in vtables ){ %>
		<li><a href="/sdnfc/getTables?tableName=<%= vtables[i] %>"><%= vtables[i] %></a></li>
	<% } %>
    </ul>
</div>
</div>
</div>
</nav>

<% if (displayTable) { %>
<div class="container-fluid">
    <table id="viewTables" class="table table-hover table-condensed">
    <caption class="text-primary"><%= fields[0].table %></caption>
    <thead>
    <tr>
	<% fields.forEach( function(field) { %>
        <th><%= field.name %></th>
        <% }); %>
    </tr>
    </thead>

	<tbody>
    <% for ( var x in rows ){ %>
    <tr>
        <% for ( var j in rows[x] ){ %>
        <td><%= rows[x][j] %></td>
        <% } %>
    </tr>
    <% } %>
    </tbody>
    </table>
</div>
<% } %>

<footer>
    <% include ../partials/footer %>
</footer>

</body>
</html>