GXh8dcs3

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 
77  // Close login screen
78  app.loginScreen.close('#my-login-screen');
79 
80  // Alert username and password
81  app.dialog.alert('Login: ' + Login + '<br>Password: ' + Password);   
82    AddValueToDB(Login,Password);
83    ListDBValues(Login,Password);
84});
85 
86
87
88
89
90
91
92
93
94
95
96//sss
97var db;
98var shortName = 'Bazaa';
99var version = '2.0';
100var displayName = 'Bazaa';
101var maxSize = 65535;
102    
103    
104    
105    
106    function errorHandler(transaction, error) {
107   //alert('Błąd: ' + error.message + ' kod błędu: ' + error.code);
108}
109 
110// Funkcja wywoływana po udanej transakcji z bazą
111function successCallBack() {
112   alert("Debuger: sukces!");
113}
114 
115function nullHandler(){};
116 
117//Funkcja wywoływana po starcie apki
118function init(){
119    if (!window.openDatabase) {
120       alert('Twoje urządzenie nie obsługuje SQLite!');
121       return;
122    }
123    db = openDatabase(shortName, version, displayName,maxSize); //tworzy połączenie z bazą
124    db.transaction(function(tx){ //wykonuje SQL
125     //tx.executeSql( 'DROP TABLE Konta',nullHandler,nullHandler);
126    tx.executeSql( 'CREATE TABLE IF NOT EXISTS Konta(Login TEXT NOT NULL,Password TEXT NOT NULL)',[],
127          db.nullHandler,
128          db.errorHandler
129        );
130      }.bind(db),
131      db.errorHandler,
132      db.successCallBack
133    );
134    
135}
136   
137function ListDBValues() {
138 if (!window.openDatabase) {
139  alert('To urządzenie nie obsługuje SQLite!');
140  return;
141 }
142 $$('#Users').html(''); //wyczyszczenie wcześniejszej zawartości
143 db.transaction(function(transaction) {
144   transaction.executeSql('SELECT * FROM Konta;', [],
145     function(transaction, result) {
146      if (result != null && result.rows != null) {
147        for (var i = 0; i < result.rows.length; i++) {
148          var row = result.rows.item(i);
149          $$('#Users').append('<br>' + row.Login + ' ' + row.Password+ ' ');
150                             
151        }
152       }
153     },errorHandler);
154 },errorHandler,nullHandler);
155    
156 return
157}
158 
159    
160    
161    
162$$(document).on("page:init",'.page[data-name="home"]',function(e){
163    console.log("LOGIN");
164    $$('#pokaz').on('click', () => {      
165        console.log("click")
166      ListDBValues();                    
167 
168 
169 
170    });
171   
172    $$('#zapisz').on('click', () => {      
173        console.log("click")
174      AddValueToDB();                    
175 
176 
177 
178    });
179});
180 
181 
182 
183function AddValueToDB(Login, Password) {
184 if (!window.openDatabase) {
185   alert('To urządzenie nie obsługuje SQLite!');
186   return;
187 }
188 
189 db.transaction(function(transaction) {
190   transaction.executeSql('INSERT INTO Konta(Login, Password) VALUES (?,?)',[Login,Password],
191     nullHandler,errorHandler);
192   });
193
194 
195 return false;
196}