angular.module('app.controllers', ['ionic','ngCordova'])

.controller('loginCtrl', ['$scope', 'LoginService', '$ionicPopup', '$state','$cordovaSQLite',
function ($scope,LoginService,$ionicPopup, $state,$cordovaSQLite) {

$scope.data = {};

$scope.login = function() {
    var db = null;
    console.log("LOGIN user: " + $scope.data.username + " - PW: " + $scope.data.password);
    LoginService.loginUser($scope.data.username, $scope.data.password).success(function(data) {
        db = $cordovaSQLite.openDB("guards.db");

                       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)";
                        runQuery(query,[],function(res) {
                          console.log("table created done");
                        }, function (err) {
                            console.log("table created done");
                          console.log(err);
                        });
        $state.go('guardTrack.home');
    }).error(function(data) {
        var alertPopup = $ionicPopup.alert({
            title: 'Login failed!',
            template: 'Please check your credentials!'
        });
    });
}}])