summaryrefslogtreecommitdiffstats
path: root/admportal/views/sdnfc/viewTables.ejs
diff options
context:
space:
mode:
Diffstat (limited to 'admportal/views/sdnfc/viewTables.ejs')
-rw-r--r--admportal/views/sdnfc/viewTables.ejs102
1 files changed, 102 insertions, 0 deletions
diff --git a/admportal/views/sdnfc/viewTables.ejs b/admportal/views/sdnfc/viewTables.ejs
new file mode 100644
index 00000000..b950d8f9
--- /dev/null
+++ b/admportal/views/sdnfc/viewTables.ejs
@@ -0,0 +1,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>
+