82zeVS7u

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
15 
16var app = new Framework7({
17  root: '#app', // App root element
18  id: 'io.framework7.myapp', // App bundle ID
19  name: 'test', // App name
20  theme: 'auto', // Automatic theme detection
21  // App root data
22  data: function () {
23    return {
24      user: {
25        firstName: 'John',
26        lastName: 'Doe',
27      },
28 
29    };
30  },
31  // App root methods
32  methods: {
33    helloWorld: function () {
34      app.dialog.alert('Hello World!');
35    },
36  },
37  // App routes
38  routes: routes,
39  // Enable panel left visibility breakpoint
40  panel: {
41    leftBreakpoint: 960,
42  },
43 
44 
45  // Input settings
46  input: {
47    scrollIntoViewOnFocus: Framework7.device.cordova && !Framework7.device.electron,
48    scrollIntoViewCentered: Framework7.device.cordova && !Framework7.device.electron,
49  },
50  // Cordova Statusbar settings
51  statusbar: {
52    overlay: Framework7.device.cordova && Framework7.device.ios || 'auto',
53    iosOverlaysWebView: true,
54    androidOverlaysWebView: false,
55  },
56  on: {
57    init: function () {
58      var f7 = this;
59        
60      if (f7.device.cordova) {
61        // Init cordova APIs (see cordova-app.js)
62        cordovaApp.init(f7);
63      }
64        init();
65
66    },
67  },
68});
69 
70// Login Screen Demo
71$$('#my-login-screen .login-button').on('click', function () {
72    console.log("LOGOWANIE!")
73    
74  var Login = $$('#my-login-screen [name="Login"]').val();
75  var Password = $$('#my-login-screen [name="Password"]').val();
76  var ID = $$('#my-login-screen [name="ID"]').val();
77 
78  // Close login screen
79  app.loginScreen.close('#my-login-screen');
80 
81  // Alert username and password
82  app.dialog.alert('Login: ' + Login + '<br>Password: ' + Password+'<br>Twoje ID: ');   
83});
84 
85
86
87
88
89
90//sss
91var db2;
92var shortName = 'Bazaa';
93var version = '2.0';
94var displayName = 'Bazaa';
95var maxSize = 65535;
96    
97    
98    
99    
100    function errorHandler(transaction, error) {
101   alert('Błąd: ' + error.message + ' kod błędu: ' + error.code);
102}
103 
104// Funkcja wywoływana po udanej transakcji z bazą
105function successCallBack() {
106   alert("Debuger: sukces!");
107}
108 
109function nullHandler(){};
110 
111//Funkcja wywoływana po starcie apki
112function init(){
113    if (!window.openDatabase) {
114       alert('Twoje urządzenie nie obsługuje SQLite!');
115       return;
116    }
117    db2 = openDatabase(shortName, version, displayName,maxSize); //tworzy połączenie z bazą
118    db2.transaction(function(tx){ //wykonuje SQL
119    //tx.executeSql( 'DROP TABLE Konta',nullHandler,nullHandler);
120    tx.executeSql( 'CREATE TABLE IF NOT EXISTS Konta1(ID TEXT NOT NULL, Login TEXT NOT NULL,Password TEXT NOT NULL)',[],
121          db2.nullHandler,
122          db2.errorHandler
123        );
124      }.bind(db2),
125      db2.errorHandler,
126      db2.successCallBack
127    );
128    
129}
130   
131function ListDBValues() {
132 if (!window.openDatabase) {
133  alert('To urządzenie nie obsługuje SQLite!');
134  return;
135 }
136 $$('#Konta1').html(''); //wyczyszczenie wcześniejszej zawartości
137 db2.transaction(function(transaction) {
138   transaction.executeSql('SELECT * FROM Konta1 where ID=1;', [],
139     function(transaction, result) {
140      if (result != null && result.rows != null) {
141        for (var i = 0; i < result.rows.length; i++) {
142          var row = result.rows.item(i);
143          $$('#Konta').append('<br>' + row.ID + ' ' +row.Login + ' ' + row.Password+ ' ');
144                             
145        }
146       }
147     },errorHandler);
148 },errorHandler,nullHandler);
149    
150 return
151}
152 
153    
154    
155    
156$$(document).on("page:init",'.page[data-name="Konta"]',function(e){
157    console.log("LOGIN");
158    $$('#pokaz').on('click', () => {      
159        console.log("pokazane")
160      ListDBValues();                    
161 
162 
163 
164    });
165   
166    $$('#zapisz').on('click', () => {   
167        DeleteFromDB();
168        console.log("zapisane")
169        DeleteFromDB();
170        AddValueToDB();
171        
172 
173 
174    });
175});
176   
177
178
179function DeleteFromDB(IDID,Login,Password){
180 if (!window.openDatabase) {
181  alert('To urządzenie nie obsługuje SQLite!');
182  return;
183 }
184 db2.transaction(function(transaction) {
185   transaction.executeSql('DELETE FROM Konta1;', [],
186    function(transaction, result) {
187       console.log("deleted");
188    },errorHandler);
189 },errorHandler,nullHandler);
190 return
191}
192 
193 
194 
195function AddValueToDB(ID,Login,Password) {
196 if (!window.openDatabase) {
197   alert('To urządzenie nie obsługuje SQLite!');
198   return;
199 }
200 
201 db2.transaction(function(transaction) {
202   transaction.executeSql('INSERT INTO Konta1(ID, Login, Password) VALUES (?,?,?)',[$$('#ID').val(),$$('#Login').val(),$$('#Password').val(),],
203     nullHandler,errorHandler);
204   });
205    
206    
207    
208
209
210 
211 return false;
212}
213    
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276//cars
277/*var db;
278var shortName = 'Baza';
279var version = '1.0';
280var displayName = 'Baza';
281var maxSize = 65535;
282var db1;
283var shortName1 = 'Baza1';
284var version1 = '1.1';
285var displayName1 = 'Baza1';
286var maxSize1 = 65535;
287 
288// wywoływana kiedy pojawi się błąd w połączeniu do bazy:
289function errorHandler(transaction, error) {
290   //alert('Błąd: ' + error.message + ' kod błędu: ' + error.code);
291}
292 
293// Funkcja wywoływana po udanej transakcji z bazą
294function successCallBack() {
295   alert("Debuger: sukces!");
296}
297 
298function nullHandler(){};
299 
300//Funkcja wywoływana po starcie apki
301function init(){
302    if (!window.openDatabase) {
303       alert('Twoje urządzenie nie obsługuje SQLite!');
304       return;
305    }
306    db = openDatabase(shortName, version, displayName,maxSize); //tworzy połączenie z bazą
307    db.transaction(function(tx){ //wykonuje SQL
308     //tx.executeSql( 'DROP TABLE User11',nullHandler,nullHandler);
309    tx.executeSql( 'CREATE TABLE IF NOT EXISTS User10(ID INTEGER PRIMARY KEY, Marka TEXT NOT NULL,Rok TEXT NOT NULL,Silnik TEXT NOT NULL,Pojemnosc TEXT NOT NULL)',[],
310          db.nullHandler,
311          db.errorHandler
312        );
313      }.bind(db),
314      db.errorHandler,
315      db.successCallBack
316    );
317    
318    db1 = openDatabase(shortName1, version1, displayName1,maxSize1);
319    console.log("utworzono"); 
320    db.transaction(function(tx){ //wykonuje SQL
321    // tx.executeSql( 'DROP TABLE User',nullHandler,nullHandler);
322    tx.executeSql( 'CREATE TABLE IF NOT EXISTS User11(UserId INTEGER PRIMARY KEY,Adres TEXT NOT NULL,Pesel TEXT NOT NULL,Imie TEXT NOT NULL,Nazwisko TEXT NOT NULL )',[],
323          db.nullHandler,
324          db.errorHandler
325        );
326      }.bind(db),
327      db.errorHandler,
328      db.successCallBack
329    );
330}
331   
332function ListDBValues() {
333 if (!window.openDatabase) {
334  alert('To urządzenie nie obsługuje SQLite!');
335  return;
336 }
337 $$('#lbUsers').html(''); //wyczyszczenie wcześniejszej zawartości
338 db.transaction(function(transaction) {
339   transaction.executeSql('SELECT * FROM User10;', [],
340     function(transaction, result) {
341      if (result != null && result.rows != null) {
342        for (var i = 0; i < result.rows.length; i++) {
343          var row = result.rows.item(i);
344          $$('#lbUsers').append('<br>' + row.ID + ' ' + row.Marka+ ' ' + row.Rok+ ' ' + row.Silnik+ ' ' + row.Pojemnosc+ ' ');
345                             
346        }
347       }
348     },errorHandler);
349 },errorHandler,nullHandler);
350    
351    $$('#lbUsers1').html('');
352    db.transaction(function(transaction) {
353   transaction.executeSql('SELECT * FROM User11;', [],
354     function(transaction, result) {
355      if (result != null && result.rows != null) {
356        for (var i = 0; i < result.rows.length; i++) {
357          var row = result.rows.item(i);
358          $$('#lbUsers1').append('<br>' + row.UserId + ' '  + row.Pesel+ ' '+ row.Adres+ ' ' + row.Imie+ ' ' + row.Nazwisko+ ' ');
359                             
360        }
361       }
362     },errorHandler);
363 },errorHandler,nullHandler);
364 return
365}
366 
367$$(document).on("page:init",'.page[data-name="index"]',function(e){
368    $$('#odswiezanie').on('click', () => {      
369        console.log("click")
370      ListDBValues();                    
371 
372 
373 
374    });
375   
376$$('#dodawanie').on('click', () => {      
377        console.log("click")
378      AddValueToDB();                    
379 
380 
381 
382    });
383});
384 
385 
386 
387function AddValueToDB() {
388 if (!window.openDatabase) {
389   alert('To urządzenie nie obsługuje SQLite!');
390   return;
391 }
392 
393 db.transaction(function(transaction) {
394   transaction.executeSql('INSERT INTO User10(ID,Marka, Rok, Silnik, Pojemnosc) VALUES (?,?,?,?,?)',[$$('#ID').val(),$$('#Marka').val(),$$('#Rok').val(),$$('#Silnik').val(),$$('#Pojemnosc').val()],
395     nullHandler,errorHandler);
396   });
397 db.transaction(function(transaction) {
398   transaction.executeSql('INSERT INTO User11(UserId,Pesel, Adres, Imie, Nazwisko) VALUES (?,?,?,?,?)',[$$('#UserId').val(),$$('#Pesel').val(),$$('#Adres').val(),$$('#Imie').val(),$$('#Nazwisko').val()],
399     nullHandler,errorHandler);
400   });
401 
402 return false;
403}*/
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446<template>
447        <div class="page" data-name="Konta">
448          <div class="page-content login-screen-content">
449            <div class="login-screen-title">Login</div>
450            <div class="list">
451              <ul>
452                <li class="item-content item-input">
453                  <div class="item-inner">
454                    <div class="item-title item-label">Username</div>
455                    <div class="item-input-wrap">
456                      <input type="text" name="Login" placeholder="Login" id="Login">
457                    </div>
458                  </div>
459                </li>
460                <li class="item-content item-input">
461                  <div class="item-inner">
462                    <div class="item-title item-label">Password</div>
463                    <div class="item-input-wrap">
464                      <input type="password" name="Password" placeholder="Password" id="Password">
465                        <div class="item-title item-label">ID</div>
466                          <div class="item-input-wrap">
467                      <input type="text" name="ID" placeholder="ID" id="ID">
468                    </div>
469                  </div>
470                </li>
471              </ul>
472            </div>
473            <div class="list">
474              <ul>
475                <li>
476                   <p align="center"><input class="item-link list-button login-button"  id="zapisz" value="Dodaj do bazy" ><BR>
477                   <input class="col button button-big button-fill button-raised color-blue" id="pokaz" value="Pokaż zapisane" >
478                   </p>
479
480                </li>
481              </ul>
482                <div id="Konta"></div>
483              <div class="block-footer">Some text about login information.<br>Click "Dodaj do bazy" to close Login Screen</div>
484            </div>
485          </div>
486        </div>
487</template>
488<script>
489export default {};
490</script>