L6v0J9t8

1angular.module('app.controllers', ['ionic','ngCordova'])
2
3.controller('loginCtrl', ['$scope', 'LoginService', '$ionicPopup', '$state','$cordovaSQLite',
4function ($scope,LoginService,$ionicPopup, $state,$cordovaSQLite) {
5
6$scope.data = {};
7
8$scope.login = function() {
9    var db = null;
10    console.log("LOGIN user: " + $scope.data.username + " - PW: " + $scope.data.password);
11    LoginService.loginUser($scope.data.username, $scope.data.password).success(function(data) {
12        db = $cordovaSQLite.openDB("guards.db");
13
14                       var query = "CREATE TABLE IF NOT EXISTS incident_list (id integer autoincrement primary key, complainant string , defendant string, details string, remarks string,incident_date datetime)";
15                        runQuery(query,[],function(res) {
16                          console.log("table created done");
17                        }, function (err) {
18                            console.log("table created done");
19                          console.log(err);
20                        });
21        $state.go('guardTrack.home');
22    }).error(function(data) {
23        var alertPopup = $ionicPopup.alert({
24            title: 'Login failed!',
25            template: 'Please check your credentials!'
26        });
27    });
28}}])