-
Notifications
You must be signed in to change notification settings - Fork 0
/
index.html
142 lines (110 loc) · 5.05 KB
/
index.html
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
<!--
@author [Anjana Gihan Wijesooriya]
@email [ajgihan@gmail.com]
@create date 2018-01-30 11:11:30
@modify date 2018-01-30 11:11:30
@desc [description]
-->
<!DOCTYPE html>
<html lang="en" >
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<meta name="author" content="Anjana Gihan Wijesooriya">
<link rel="shortcut icon" href="img/logo.jpg">
<title>AngularJS Bootstrap Dashboard </title>
<!-- Main styles for this application -->
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-datepicker/1.7.1/css/bootstrap-datepicker3.min.css" />
<link href="css/style.css" rel="stylesheet">
<!-- <link href="https://account.gametester.co/app/css/app.css" rel="stylesheet"> -->
</head>
<!-- BODY options, add following classes to body to change options
// Header options
1. '.header-fixed' - Fixed Header
// Sidebar options
1. '.sidebar-fixed' - Fixed Sidebar
2. '.sidebar-hidden' - Hidden Sidebar
3. '.sidebar-off-canvas' - Off Canvas Sidebar
4. '.sidebar-minimized' - Minimized Sidebar (Only icons)
5. '.sidebar-compact' - Compact Sidebar
// Aside options
1. '.aside-menu-fixed' - Fixed Aside Menu
2. '.aside-menu-hidden' - Hidden Aside Menu
3. '.aside-menu-off-canvas' - Off Canvas Aside Menu
// Footer options
1. 'footer-fixed' - Fixed footer
-->
<body class="app header-fixed sidebar-fixed aside-menu-fixed aside-menu-hidden" ng-app="app">
<!-- User Interface -->
<ui-view></ui-view>
<!-- Bootstrap and necessary plugins -->
<script src="bower_components/jquery/dist/jquery.min.js"></script>
<script src="bower_components/tether/dist/js/tether.min.js"></script>
<script src="bower_components/bootstrap/dist/js/bootstrap.min.js"></script>
<!-- AngularJS -->
<script src="bower_components/angular/angular.min.js"></script>
<!-- AngularJS plugins -->
<script src="bower_components/angular-ui-router/release/angular-ui-router.min.js"></script>
<script src="bower_components/oclazyload/dist/ocLazyLoad.min.js"></script>
<script src="bower_components/angular-breadcrumb/dist/angular-breadcrumb.min.js"></script>
<script src="bower_components/angular-loading-bar/build/loading-bar.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-datepicker/1.7.1/js/bootstrap-datepicker.min.js"></script>
<!-- AngularJS App scripts -->
<script src="js/app.js"></script>
<script src="js/core.js"></script>
<script src="js/routes.js"></script>
<script src="js/controllers/MainController.js"></script>
<script>
var createStatement = "CREATE TABLE IF NOT EXISTS Contacts (id INTEGER PRIMARY KEY AUTOINCREMENT, username TEXT, useremail TEXT)";
var selectAllStatement = "SELECT * FROM Contacts";
var insertStatement = "INSERT INTO Contacts (username, useremail) VALUES (?, ?)";
var updateStatement = "UPDATE Contacts SET username = ?, useremail = ? WHERE id=?";
var deleteStatement = "DELETE FROM Contacts WHERE id=?";
var dropStatement = "DROP TABLE Contacts";
var db = openDatabase("AddressBook", "1.0", "Address Book", 200000); // Open SQLite Database
var dataset;
var DataType;
function initDatabase() {
try {
if (!window.openDatabase) {
console.log("Databases are not supported in this browser.");
} else {
console.log("Databases are supported in this browser.");
db.transaction(function (tx) {
tx.executeSql(createStatement, [],showRecords, onError)
});
}
} catch (exeption) {
if (exeption == 2) {
console.log("Invalid database version.");
} else {
console.log("Unknown error " + exeption + ".");
}
}
}
function showRecords(){
$("#results").html("");
db.transaction(function (tx) {
tx.executeSql(selectAllStatement, [], function (tx, result) {
dataset = result.rows;
for (var i = 0, item = null; i < dataset.length; i++) {
item = dataset.item(i);
console.log(i)
$("#results").append('<li>' + item['username'] + ' , ' + item['useremail'] + ' <a href="#" onclick="loadRecord(' + i + ')">edit</a> ' + '<a href="#" onclick="deleteRecord(' + item['id'] + ')">delete</a></li>');
}
});
});
}
function onError(tx, error){
console.log(error.message);
}
function insertRecord() {
db.transaction(function (tx) {
tx.executeSql(insertStatement, ["Anjana", "Gihan"], showRecords, onError);
});
}
initDatabase();
</script>
</body>
</html>