oops! Sorry, I forgot to add in my code! I apologize for the inconvenience.
app.moodule.ts
import { BrowserModule } from ‘@angular/platform-browser’;
import { ErrorHandler, NgModule } from ‘@angular/core’;
import { IonicApp, IonicErrorHandler, IonicModule } from ‘ionic-angular’;
import { SplashScreen } from ‘@ionic-native/splash-screen’;
import { StatusBar } from ‘@ionic-native/status-bar’;
import { BarcodeScanner } from ‘@ionic-native/barcode-scanner’;
import { SQLite, SQLiteObject } from ‘@ionic-native/sqlite’;
import { SQLitePorter } from ‘@ionic-native/sqlite-porter’;
import { IonicStorageModule } from ‘@ionic/storage’;
import { MyApp } from ‘./app.component’;
import { HomePage } from ‘…/pages/home/home’;
@NgModule({
declarations: [
MyApp,
HomePage
],
imports: [
BrowserModule,
IonicModule.forRoot(MyApp),
IonicStorageModule.forRoot()
],
bootstrap: [IonicApp],
entryComponents: [
MyApp,
HomePage
],
providers: [
StatusBar,
SplashScreen,
BarcodeScanner,
SQLite,
SQLiteObject,
SQLitePorter,
{provide: ErrorHandler, useClass: IonicErrorHandler}
]
})
export class AppModule {}
home.ts
import { Component } from '@angular/core';
import { NavController } from 'ionic-angular';
import { BarcodeScanner } from '@ionic-native/barcode-scanner';
import { SQLite, SQLiteObject } from "@ionic-native/sqlite";
@Component({
selector: 'page-home',
templateUrl: 'home.html'
})
export class HomePage {
constructor(public navCtrl: NavController,
private barcodeScanner: BarcodeScanner,
private sqlite: SQLite,
private sqliteObject: SQLiteObject) {
}
createDB(){
this.sqlite.create({
name: 'Assets.db',
location: 'default'
})
.then((db: SQLiteObject) => {
db.executeSql('create table Assets(ASSET_TAG VARCHAR(50), ASSET_TYPE VARCHAR(50), DEPLOYMENT_CYCLE VARCHAR(50), YEAR_ISSUED YEAR, WARRANTY_EXPIRES DATE, SERVICE_TAG VARCHAR(50), EXPRESS_SERVICE_CODE NUMERIC(25,0), MAC_ADDRESS VARCHAR(50), MANUFACTURER VARCHAR(50), DEVICE_MODEL VARCHAR(50), OPERATING_SYSTEM VARCHAR(50), PROCESSOR VARCHAR(50), RAM VARCHAR(50), STORAGE VARCHAR(50), ASSET_LOCATION VARCHAR(50), ASSET_DEPARTMENT VARCHAR(50)', {})
.then(() => console.log('Executed SQL'))
.catch(e => console.log(e));
})
.catch(e => console.log(e));}
barcodeData: any;
result: any;
Fetch(tag) {
}
ScanBarcode() {
this.barcodeScanner.scan().then((barcodeData) => {
console.log("Scan Successful: " + barcodeData.text);
this.result = barcodeData.text;
}, (err) => {
console.error("Scan Failure: " + err);
});
}
}
home.html
<ion-header>
<ion-navbar color="dark">
<ion-title text-center>
SVUIT Asset Tracker
</ion-title>
</ion-navbar>
</ion-header>
<ion-content padding>
Scan an Asset Tag
<!-- Item with a label and content -->
<ion-item padding>
<ion-label>Last Scan:</ion-label>
<div item-content>{{ result }}</div>
</ion-item>
<button ion-button block color="dark" (click)="ScanBarcode()">Scan</button>
<ion-card>
<ion-item padding>
<ion-label>Fetch Asset Data</ion-label>
<div item-content>
{{ result }}
</div>
</ion-item>
<button ion-button block color="dark" (click)="Fetch(tag)">Fetch Data</button>
</ion-card>
</ion-content>
Hope that thorough list of my files makes up for my foolish mistake. I can supply the theme file if needed!
In any case, thank you for the rapid reply. I am very new to mobile development, and I need to have this done by Friday, so I am grateful for any and all help and friendly advice!
PS- yes, I am in fact trying to implement the ionic native plugin for SQLite.
