ALfaEWkz

1<ion-content>
2    <div class="divCommonBg">
3        <div class="row">
4            <div class="col">
5                <h4>Total KiloMeters</h4>
6            </div>
7            <div class="col">
8                <input type="number" ng-model="data.totalkm" style="height:30px;width:100%" required>
9            </div>
10        </div>
11        <div class="row">
12            <div class="col">
13                <h4>Date of Service</h4>
14            </div>
15            <div class="col">
16                <input type="date" ng-model="data.servicedate" style="height:30px;width:100%" required>
17            </div>
18        </div>
19        <div class="row">
20            <div class="col">
21                <h4>Amount Paid</h4>
22            </div>
23            <div class="col">
24                <input type="number" ng-model="data.amount" style="height:30px;width:100%" required>
25            </div>
26        </div>
27        <div class="row">
28            <div class="col">
29                <h4>Next Service Date</h4>
30            </div>
31            <div class="col">
32
33                <input type="date" ng-model="data.nextservicedate" style="height:30px;width:100%" required>
34            </div>
35        </div>
36
37        <div style="margin-left:30%">        
38              <button class="button button-calm" ng-click="doSavetoDb()" style="height:25px;width:60%">save </button>    
39        </div>
40	
41try {
42        dbApp = $cordovaSQLite.openDB({
43            name: "AAICMOBAPP.db",
44            location: 'default'
45        });
46        $cordovaSQLite.execute(dbApp, "CREATE TABLE IF NOT EXISTS OIL_TRACKER (TOTAL_KM TEXT, SERVICE_DATE TEXT, AMOUNT_PAID TEXT, NEXT_SERVICE_DATE TEXT)");
47        $cordovaSQLite.execute(dbApp, "SELECT TOTAL_KM, SERVICE_DATE, AMOUNT_PAID, NEXT_SERVICE_DATE FROM OIL_TRACKER")
48            .then(
49                function(res) {
50                    $ionicLoading.hide();
51                    if (res.rows.length > 0) {                          
52                        for (var i = 0; i < res.rows.length; i++) {
53
54                            var varTrackerData = new TrackerData(res.rows.item(i).TOTAL_KM, res.rows.item(i).SERVICE_DATE, res.rows.item(i).AMOUNT_PAID, res.rows.item(i).NEXT_SERVICE_DATE);
55                            SelectedTracker.push(varTrackerData);   
56                        }
57                        var d = JSON.stringify(SelectedTracker);
58                        $scope.pTrackerData = JSON.parse(d);
59
60                    } else {
61                        alert('No data found!');
62                    }
63                },
64                function(error) {
65                    alert("Error on loading: " + error.message);
66                }
67            );
68    } catch (err) {
69        alert(err.message);
70    }
71
72});