kf8w9L43

1function Authorize() {
2    var result = null;
3    result = $(".loginform").dxForm("instance");
4
5    var json = result.option("formData");
6
7    var localDB = getDatabase();
8    localDB.transaction(
9        function(tx) {
10            databaseQuery(tx, 'DROP TABLE IF EXISTS user_settings', [], null);
11            databaseQuery(tx, 'CREATE TABLE IF NOT EXISTS user_settings ' +
12                '(login text unique,apartmentNumber text,bankAccountNumber text, bankName text, cardNumber text, city text, contractorName text, dateofBirth datetime, email text, fax text, firstName text, houseNumber text, idNumber text, isWorker bool, joinDate datetime,mobileNumber text, notes text, pesel text, phoneNumber text, placeOfBirth text, postalCode text, referLogin text, sex int, skype text, street text, surname text,expire_login_time int)', [], null);
13
14            databaseQuery(tx, 'DROP TABLE IF EXISTS user_permission', [], null);
15            databaseQuery(tx, 'CREATE TABLE IF NOT EXISTS user_permission(permName text unique, categoryId int, description text, id int, isChecked boolean, isGroup boolean)', [], null);
16        });
17
18    var d = $.Deferred();
19    window.db.post('account', 'login', json,
20        (function(data) {
21            localDB.transaction(
22                function(tx) {
23
24                    var now = new Date();
25                    var time = now.getTime();
26                    var expireTime = time + 1000 * 36000;
27
28                    // Login data + expire login token time
29                    databaseQuery(tx, "INSERT INTO user_settings (login,apartmentNumber,bankAccountNumber, bankName, cardNumber, city, contractorName, dateofBirth, email, fax, firstName, houseNumber, idNumber, isWorker, joinDate, mobileNumber, notes, pesel, phoneNumber, placeOfBirth, postalCode, referLogin, sex, skype, street, surname,expire_login_time) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)",
30                    [data.userData.login, data.userData.apartmentNumber, data.userData.bankAccountNumber, data.userData.bankName, data.userData.cardNumber, data.userData.city, data.userData.contractorName, data.userData.dateofBirth, data.userData.email, data.userData.fax, data.userData.firstName, data.userData.houseNumber, data.userData.idNumber, data.userData.isWorker, data.userData.joinDate, data.userData.mobileNumber, data.userData.notes, data.userData.pesel, data.userData.phoneNumber, data.userData.placeOfBirth, data.userData.postalCode, data.userData.referLogin, data.userData.sex, data.userData.skype, data.userData.street, data.userData.surname, expireTime], null);
31
32                    // Permition data to SQLite
33                    for (var i = 0; i < data.userPermission.length; i++) {
34                        databaseQuery(tx,
35                            'INSERT INTO user_permission' +
36                            '(permName, categoryId, description, id, isChecked, isGroup)' +
37                            'values(?,?,?,?,?,?)',
38                            [data.userPermission[i].name, data.userPermission[i].categoryId, data.userPermission[i].description, data.userPermission[i].id, data.userPermission[i].isChecked, data.userPermission[i].isGroup], null);
39                    }
40
41
42                    databaseQuery(tx, 'SELECT * FROM user_settings', [], function (tx, results) {
43                        console.log(results.rows.length);
44                        console.log(results.rows);
45                    });
46                    databaseQuery(tx, 'SELECT * FROM user_permission', [], function (tx, results) {
47                        console.log(results.rows.length);
48                        console.log(results);
49                    });
50                }
51
52
53                );
54            DevExpress.ui.notify("Login success!", 'success', 2000);
55            Rakieta.app.navigate("Mainboard", { root: true });
56        }),
57        function(err) {
58            DevExpress.ui.notify("Wrong login or password", 'error', 2000);
59            d.reject(err);
60        });
61
62};