Notes

Ext.define('SmartKidsRewards.utils.DBUtility', {
singleton: true,
config: {
kidsCount: 0,
// apiUrls : {
// login : '/v1/login',
// signup : 'v1/signup'
// }
},

/*
constructor: function (config) {
// Creates the getter/setter wrapper
this.initConfig(config);
this.callParent(arguments);
},*/

getAPI: function (apiName) {
if(!apiName){ return; }

return this.getBaseURL() + this.getApiUrls()[apiName];
},

getAllKids: function(callBack) {
var me = this,
allKIdsArray = [],
kidId,
kidDetails,
kidPhoto,
totalRewards,
balanceRewards;
db.transaction(function (tx) {
tx.executeSql('SELECT * FROM Kids', [], function(tx, results){
me.setKidsCount(results.rows.length);
for(var i=0; i<results.rows.length; i++) {
kidId = results.rows.item(i).KidId;
kidPhoto = results.rows.item(i).KidPhoto;
kidPhoto = '<img src=resources/images/KidsPhotos/' + kidPhoto + ' width=100/>';
totalRewards = results.rows.item(i).TotalRewards;
balanceRewards = results.rows.item(i).BalanceRewards,
kidDetails = results.rows.item(i).KidName + '<br>Total: ' + totalRewards + '<br>Balance: ' + balanceRewards;

allKIdsArray.push({'kidId':kidId, 'kidName':results.rows.item(i).KidName, 'kidDetails':kidDetails, 'kidPhoto':kidPhoto, 'totalRewards':totalRewards, 'balanceRewards':balanceRewards});
}
callBack(allKIdsArray);
}, me.errorHandler);
});
},

getAllTasks: function(kidId, callBack) {
var me = this,
allTasksArray = [],
taskId,
taskTitle,
taskValue,
taskPosValue,
taskNegValue,
selected;
db.transaction(function (tx) {
tx.executeSql('SELECT KidsTasks.KidId, Tasks.TaskId, Tasks.TaskTitle, Tasks.TaskPosValue, Tasks.TaskNegValue FROM Tasks LEFT JOIN KidsTasks ON Tasks.TaskId=KidsTasks.TaskId ORDER BY Tasks.TaskTitle;', [], function(tx, results){
for(var i=0; i<results.rows.length; i++) {

taskId = results.rows.item(i).TaskId;
taskTitle = results.rows.item(i).TaskTitle;
taskValue = '<font color="green">' + results.rows.item(i).TaskPosValue + '</font><img width=20 src=resources/images/coins.png />' +
'<br><font color="red">-' + results.rows.item(i).TaskNegValue + '</font><img width=20 src=resources/images/coins.png />';

if(kidId !== 'ALL' && kidId === results.rows.item(i).KidId) {
selected = 1;
} else {
selected = 0;
}
allTasksArray.push({'taskId':taskId, 'taskTitle':taskTitle, 'taskValue':taskValue, 'selected': selected});
}
callBack(allTasksArray);
}, me.errorHandler);
});
},

getMyTasks: function(kidId, callBack) {
var me = this,
allTasksArray = [],
taskId,
taskTitle,
taskValue,
taskPosValue,
taskNegValue,
selected;
db.transaction(function (tx) {
tx.executeSql('SELECT KidsTasks.KidId, Tasks.TaskId, Tasks.TaskTitle, Tasks.TaskPosValue, Tasks.TaskNegValue FROM Tasks JOIN KidsTasks ON Tasks.TaskId=KidsTasks.TaskId AND KidsTasks.KidId = "' + kidId + '" ORDER BY Tasks.TaskTitle;', [], function(tx, results){
for(var i=0; i<results.rows.length; i++) {

taskId = results.rows.item(i).TaskId;
taskTitle = results.rows.item(i).TaskTitle;
taskValue = '<font color="green">' + results.rows.item(i).TaskPosValue + '</font><img width=20 src=resources/images/coins.png />' +
'<br><font color="red">-' + results.rows.item(i).TaskNegValue + '</font><img width=20 src=resources/images/coins.png />';

allTasksArray.push({'taskId':taskId, 'taskTitle':taskTitle, 'taskValue':taskValue});
}
callBack(allTasksArray);
}, me.errorHandler);
});
},

getAllRewards: function (kidId, callBack) {
console.log("selected Kid id:" + kidId);
var me = this,
allRewardsArray = [],
rewardId,
rewardTitle,
rewardValue,
selected;
db.transaction(function (tx) {
tx.executeSql('SELECT KidsRewards.KidId, Rewards.RewardId, Rewards.RewardTitle, Rewards.RewardValue FROM Rewards LEFT JOIN KidsRewards ON Rewards.RewardId=KidsRewards.RewardId ORDER BY Rewards.RewardTitle;', [], function(tx, results){
for(var i=0; i<results.rows.length; i++) {

rewardId = results.rows.item(i).RewardId;
rewardTitle = results.rows.item(i).RewardTitle;
rewardValue = '<font color="green">' + results.rows.item(i).RewardValue + '</font><img width=20 src=resources/images/coins.png />';

if(kidId !== 'ALL' && kidId === results.rows.item(i).KidId) {
selected = 1;
} else {
selected = 0;
}
console.log("KidId--->" + results.rows.item(i).KidId);
allRewardsArray.push({'rewardId':rewardId, 'rewardTitle':rewardTitle, 'rewardValue':rewardValue, 'selected': selected});
}
callBack(allRewardsArray);
}, me.errorHandler);
});
},

getMyRewards: function (kidId, callBack) {
var me = this,
allRewardsArray = [],
rewardId,
rewardTitle,
rewardValue;
db.transaction(function (tx) {
tx.executeSql('SELECT KidsRewards.KidId, Rewards.RewardId, Rewards.RewardTitle, Rewards.RewardValue FROM Rewards JOIN KidsRewards ON Rewards.RewardId=KidsRewards.RewardId AND KidsRewards.KidId = "' + kidId + '" ORDER BY Rewards.RewardTitle;', [],function(tx, results){
for(var i=0; i<results.rows.length; i++) {

rewardId = results.rows.item(i).RewardId;
rewardTitle = results.rows.item(i).RewardTitle;
rewardValue = '<font color="green">' + results.rows.item(i).RewardValue + '</font><img width=20 src=resources/images/coins.png />';

console.log("KidId--->" + results.rows.item(i).KidId);
allRewardsArray.push({'rewardId':rewardId, 'rewardTitle':rewardTitle, 'rewardValue':rewardValue});
}
callBack(allRewardsArray);
}, me.errorHandler);
});
},

addKid: function(insertDataArray, callBack) {
var me = this,
futureKidsCount = me.getKidsCount() + 1,
kidId = 'K' + futureKidsCount,
kidPhoto = '<img src=resources/images/KidsPhotos/' + insertDataArray[1] + ' width=100>',
totalRewards = insertDataArray[2],
balanceRewards = 0,
kidsDetails = insertDataArray[0] + '<br>Total: ' + totalRewards + '<br>Balance: ' + balanceRewards;

sql='INSERT INTO Kids (KidId, KidName, KidPhoto, TotalRewards, BalanceRewards) VALUES ("' + kidId + '", "' + insertDataArray[0] + '", "' + insertDataArray[1] + '", "' + insertDataArray[2] + '", "0")';

me.setKidsCount(futureKidsCount);
console.log("futureKidsCount Kids Count:" + futureKidsCount);
db.transaction(function (tx) {
tx.executeSql(sql);

kidsStore = Ext.getStore('Kids');
kidsStore.add({'kidId':kidId, 'kidName':insertDataArray[0], 'kidDetails':kidsDetails, 'kidPhoto':kidPhoto, 'totalRewards':totalRewards, 'balanceRewards':balanceRewards});

callBack(true);
}, me.errorHandler);
},

updateKid: function(updateDataArray, callBack) {
var me = this,
kidId = updateDataArray[0],
kidName = updateDataArray[1],
kidPhoto = updateDataArray[2],
totalRewards = updateDataArray[3],
sql='UPDATE Kids SET KidName="' + kidName + '", ' + 'KidPhoto="' + kidPhoto + '", ' + 'TotalRewards="' + totalRewards + '" WHERE KidId = "' + kidId + '"';

db.transaction(function (tx) {
tx.executeSql(sql);

kidsStore = Ext.getStore('Kids');
kidsStore.each(function(record,id){
if(record.data.kidId == kidId) {
console.log("Inside if")
record.data.kidName = kidName;
record.data.kidDetails = updateDataArray[1] + '<br>Total: ' + totalRewards + '<br>Balance: ' + record.data.balanceRewards;
record.data.kidPhoto = kidPhoto;
record.data.totalRewards = totalRewards;
}
console.info(record.data.kidId + "====="+ kidId);
});
//kidsStore.add({'kidId':kidId, 'kidName':updateDataArray[0], 'kidDetails':kidsDetails, 'kidPhoto':kidPhoto, 'totalRewards':totalRewards, 'balanceRewards':balanceRewards});

callBack(true);
}, me.errorHandler);
},

addTask: function(insertDataArray, callBack) {
var me = this,
sql='INSERT INTO Tasks (TaskId, TaskTitle, TaskPosValue, TaskNegValue) VALUES ("' + insertDataArray[0] + '", "' + insertDataArray[1] + '", "' + insertDataArray[2] + '", "' + insertDataArray[3] + '")';
db.transaction(function (tx) {
tx.executeSql(sql);
callBack(true);
}, me.errorHandler);
},

addReward: function(insertDataArray, callBack) {
var me = this,
sql='INSERT INTO Rewards (RewardId, RewardTitle, RewardVaue) VALUES ("' + insertDataArray[0] + '", "' + insertDataArray[1] + '", "' + insertDataArray[2] + '")';
db.transaction(function (tx) {
tx.executeSql(sql);
callBack(true);
}, me.errorHandler);
},

deleteExistingFavoriteSongs: function(songIdToRemove, callBack) {
var me = this;
db.transaction(function (tx) {
tx.executeSql('DELETE FROM FavoriteSongs WHERE id="' + songIdToRemove + '"');
callBack(true);
}, me.errorHandler);
},

errorHandler: function(err) {
console.error("Error processing SQL: " + err.message);
}
});