· 6 years ago · Dec 02, 2019, 08:52 AM
1import $$ from 'dom7';
2import Framework7 from 'framework7/framework7.esm.bundle.js';
3
4// Import F7 Styles
5import 'framework7/css/framework7.bundle.css';
6
7// Import Icons and App Custom Styles
8import '../css/icons.css';
9import '../css/app.css';
10// Import Cordova APIs
11import cordovaApp from './cordova-app.js';
12// Import Routes
13import routes from './routes.js';
14
15var app = new Framework7({
16 root: '#app', // App root element
17 id: 'io.framework7.myapp', // App bundle ID
18 name: 'test', // App name
19 theme: 'auto', // Automatic theme detection
20 // App root data
21 data: function () {
22 return {
23 user: {
24 firstName: 'John',
25 lastName: 'Doe',
26 },
27
28 };
29 },
30 // App root methods
31 methods: {
32 helloWorld: function () {
33 app.dialog.alert('Hello World!');
34 },
35 },
36 // App routes
37 routes: routes,
38 // Enable panel left visibility breakpoint
39 panel: {
40 leftBreakpoint: 960,
41 },
42
43
44 // Input settings
45 input: {
46 scrollIntoViewOnFocus: Framework7.device.cordova && !Framework7.device.electron,
47 scrollIntoViewCentered: Framework7.device.cordova && !Framework7.device.electron,
48 },
49 // Cordova Statusbar settings
50 statusbar: {
51 overlay: Framework7.device.cordova && Framework7.device.ios || 'auto',
52 iosOverlaysWebView: true,
53 androidOverlaysWebView: false,
54 },
55 on: {
56 init: function () {
57 var f7 = this;
58 if (f7.device.cordova) {
59 // Init cordova APIs (see cordova-app.js)
60 cordovaApp.init(f7);
61 }
62 init();
63 },
64 },
65});
66
67// Login Screen Demo
68$$('#my-login-screen .login-button').on('click', function () {
69 var username = $$('#my-login-screen [name="username"]').val();
70 var password = $$('#my-login-screen [name="password"]').val();
71
72 // Close login screen
73 app.loginScreen.close('#my-login-screen');
74
75 // Alert username and password
76 app.dialog.alert('Username: ' + username + '<br>Password: ' + password);
77});
78
79var db;
80var shortName = 'sadf3';
81var version = '1.0';
82var displayName = 'sadf3';
83var maxSize = 65535;
84
85// wywoływana kiedy pojawi się błąd w połączeniu do bazy:
86function errorHandler(transaction, error) {
87 alert('Błąd: ' + error.message + ' kod błędu: ' + error.code);
88}
89
90// Funkcja wywoływana po udanej transakcji z bazą
91function successCallBack() {
92 alert("Debuger: sukces!");
93}
94
95function nullHandler(){};
96
97//Funkcja wywoływana po starcie apki
98function init(){
99 if (!window.openDatabase) {
100 alert('Twoje urządzenie nie obsługuje SQLite!');
101 return;
102 }
103 db = openDatabase(shortName, version, displayName,maxSize); //tworzy połączenie z bazą
104 db.transaction(function(tx){ //wykonuje SQL
105 // tx.executeSql( 'DROP TABLE User',nullHandler,nullHandler);
106 tx.executeSql( 'CREATE TABLE IF NOT EXISTS User(UserId INTEGER NOT NULL PRIMARY KEY, Marka TEXT NOT NULL, Rok TEXT NOT NULL, Silnik TEXT NOT NULL, Pojemnosc TEXT NOT NULL,Adres TEXT NOT NULL,Pesel TEXT NOT NULL,Imie TEXT NOT NULL,Nazwisko TEXT NOT NULL )',[],nullHandler,errorHandler);},errorHandler,successCallBack);
107};
108
109function ListDBValues() {
110 if (!window.openDatabase) {
111 alert('To urządzenie nie obsługuje SQLite!');
112 return;
113 }
114 $$('#lbUsers').html(''); //wyczyszczenie wcześniejszej zawartości
115 db.transaction(function(transaction) {
116 transaction.executeSql('SELECT * FROM User;', [],
117 function(transaction, result) {
118 if (result != null && result.rows != null) {
119 for (var i = 0; i < result.rows.length; i++) {
120 var row = result.rows.item(i);
121 $$('#lbUsers').append('<br>' + row.UserId + '. ' + row.Marka+ ' ' + row.Rok+ ' ' + row.Silnik+ ' ' + row.Pojemnosc+ ' ' + row.Pesel+ ' '+ row.Adres+ ' ' + row.Imie+ ' ' + row.Nazwisko+ ' ');
122
123 }
124 }
125 },errorHandler);
126 },errorHandler,nullHandler);
127 return
128}
129
130$$(document).on("page:init",'.page[data-name="about"]',function(e){
131 $$('#odswiezanie').on('click', () => {
132 console.log("click")
133 ListDBValues();
134
135
136
137 });
138
139$$('#dodawanie').on('click', () => {
140 console.log("click")
141 AddValueToDB();
142
143
144
145 });
146
147
148$$('#usun').on('click', () => {
149 console.log("click")
150 DeleteFromDB($$("#Id").val());
151
152});
153 });
154
155function AddValueToDB() {
156
157
158
159
160
161 db.transaction(function(transaction) {
162 transaction.executeSql('INSERT INTO User(Marka, Rok, Silnik, Pojemnosc, Adres, Pesel, Imie, Nazwisko) VALUES (?,?,?,?,?,?,?,?)',[$$('#Marka').val(), $$('#Rok').val(),$$('#Silnik').val(),$$('#Pojemnosc').val(),$$('#Adres').val() ,$$('#Pesel').val() ,$$('#Imie').val(),$$('#Nazwisko').val()],
163 nullHandler,errorHandler);
164 });
165
166 return false;
167}
168 function DeleteFromDB(Id){
169
170 if (!window.openDatabase) {
171 alert('To urządzenie nie obsługuje SQLite!');
172 return;
173 }
174 db.transaction(function(transaction) {
175 transaction.executeSql('DELETE FROM User where UserId=?;', [Id],
176 function(transaction, result) {
177 ListDBValues();
178 },errorHandler);
179 },errorHandler,nullHandler);
180 return
181}