FV4m9DbY

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 = 'BazaFX';
81var version = '1.0';
82var displayName = 'BazaFX';
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 Userr',nullHandler,nullHandler);
106    tx.executeSql( 'CREATE TABLE IF NOT EXISTS Userr(UserId INTEGER NOT NULL PRIMARY KEY, Marka TEXT NOT NULL, Rok TEXT NOT NULL, Silnik TEXT NOT NULL, Pojemnosc TEXT NOT NULL, Imie TEXT NOT NULL,Nazwisko TEXT NOT NULL,Adres TEXT NOT NULL,Pesel TEXT NOT NULL )',[],nullHandler,errorHandler);},errorHandler,successCallBack);
107
108};
109   
110function ListDBValues() {
111 if (!window.openDatabase) {
112  alert('To urządzenie nie obsługuje SQLite!');
113  return;
114 }
115 $$('#lbUsers').html(''); //wyczyszczenie wcześniejszej zawartości
116 db.transaction(function(transaction) {
117   transaction.executeSql('SELECT * FROM Userr;', [],
118    function(transaction, result) {
119    if (result != null && result.rows != null) {
120    for (var i = 0; i < result.rows.length; i++) {
121    var row = result.rows.item(i);
122    $$('#lbUsers').append('<br>' + row.UserId + '. ' + row.Marka+ ', ' + row.Rok+ ', ' + row.Silnik+ ', ' + row.Pojemnosc+ ' | ' + row.Imie+ ', '+ row.Nazwisko+ ', ' + row.Adres+ ', ' + row.Pesel+ ' ');
123                             
124    }
125    }
126    },errorHandler);
127 },errorHandler,nullHandler);
128 return
129}
130 
131$$(document).on("page:init",'.page[data-name="about"]',function(e){
132    $$('#odswiezanie').on('click', () => {      
133        console.log("click")
134      ListDBValues();                    
135
136    });
137   
138$$('#dodawanie').on('click', () => {      
139        console.log("click")
140      AddValueToDB();                    
141
142    });
143});
144 
145 
146 
147function AddValueToDB() {
148 if (!window.openDatabase) {
149   alert('To urządzenie nie obsługuje SQLite!');
150   return;
151 }
152 
153 db.transaction(function(transaction) {
154   transaction.executeSql('INSERT INTO Userr(Marka, Rok, Silnik, Pojemnosc, Imie, Nazwisko, Adres, Pesel) VALUES (?,?,?,?,?,?,?,?)',[$$('#Marka').val(), $$('#Rok').val(),$$('#Silnik').val(),$$('#Pojemnosc').val(),$$('#Imie').val() ,$$('#Nazwisko').val() ,$$('#Adres').val(),$$('#Pesel').val()],
155     nullHandler,errorHandler);
156   });
157 
158 return false;
159}