Hi Sumit,
var db = openDatabase('QA.sqlite', '1.0', 'Test DB', 2 * 1024 * 1024);
var msg;
var results_sql;
var len_sql;
var main_ques = [];
var ans1 = [];
var ans2 = [];
var ans3 = [];
var ans4 = [];
var qImg = [];
var qId = [];
db.transaction(function (tx) {
tx.executeSql('DROP TABLE IF EXISTS Question');
tx.executeSql('CREATE TABLE IF NOT EXISTS Question(qID, qImg, Question, Ans1, Ans2, Ans3, Ans4)');
tx.executeSql('INSERT INTO Question (qID, qImg, Question, Ans1, Ans2, Ans3, Ans4) VALUES (1, "img/ques1.jpg", "What the hell is this language", "Java script", "Java", "Ajax", "Sencha Touch");');
tx.executeSql('INSERT INTO Question (qID, qImg, Question, Ans1, Ans2, Ans3, Ans4) VALUES (2, "img/ques2.jpg", "What is your first company?", "Exilant", "Hcl", "Infosys", "TCS");');
tx.executeSql('INSERT INTO Question (qID, qImg, Question, Ans1, Ans2, Ans3, Ans4) VALUES (3, "img/ques3.jpg", "Which was the 1st non Test playing country to beat India in an international match?", "Canada", "Sri Lanka", "Zimbabwe", "East Africa");');
tx.executeSql('INSERT INTO Question (qID, qImg, Question, Ans1, Ans2, Ans3, Ans4) VALUES (4, "img/ques4.jpg", "Which county did Ravi Shastri play for?", "Glamorgan", "Leicestershire", "Gloucestershire", "Lancashire");');
tx.executeSql('INSERT INTO Question (qID, qImg, Question, Ans1, Ans2, Ans3, Ans4) VALUES (5, "img/ques5.jpg", "Who is the first Indian woman to win an Asian Games gold in 400m run?", "M.L.Valsamma", "P.T.Usha", "Kamaljit Sandhu", "K.Malleshwari");');
tx.executeSql('INSERT INTO Question (qID, qImg, Question, Ans1, Ans2, Ans3, Ans4) VALUES (6, "img/ques6.jpg", "In which year did Milkha Singh win the first National title in the 400 m race?", "1955", "1956", "1957", "1970");');
tx.executeSql('INSERT INTO Question (qID, qImg, Question, Ans1, Ans2, Ans3, Ans4) VALUES (7, "img/ques7.jpg", "The Dronacharya Award is given to...?", "Sportsmen", "Coaches", "Umpires", "Sports Editors");');
});
var select = db.transaction(function (tx) {
tx.executeSql('SELECT * FROM Question', [], function (tx, results) {
len_sql = results.rows.length, i;
for (var i = 0; i < len_sql; i++){
qId[i] = results.rows.item(i).qID;
main_ques[i] = results.rows.item(i).Question;
ans1[i] = results.rows.item(i).Ans1;
ans2[i] = results.rows.item(i).Ans2;
ans3[i] = results.rows.item(i).Ans3;
ans4[i] = results.rows.item(i).Ans4;
qImg[i] = results.rows.item(i).qImg;
}
}, null);
});
Ext.application({
launch: function () {
var logo = Ext.create('Ext.Img', {
src: 'img/qans.jpg',
layout:{
type:'vbox',
align:'middle'
},
id: 'logo',
mode: 'element',
height: 200
}); // create()
var titleb = Ext.create('Ext.TitleBar', {
id: 'titlebar',
docked: 'top',
ui: 'light',
// border: 3,
// style: 'border-color: red; border-style: solid;'
});
var i=0;
var j=0;
var k=0;
var flag=0;
var flag1=0;
var result="";
var checked = "tested";
var resultArray = [];
var setOption;
var without;
var withoutNo = [];
var separate;
var numi = [];
var quesManage = [];
var qnext = [];
var answered = [];
var contactForm = Ext.create('Ext.form.FormPanel', {
extend: 'Ext.Container',
fullscreen: true,
renderTo: document.body,
scrollable: false,
// scrollable : {
// direction : 'horizontal',
// directionLock : true
//},
// layout:'fit',
listeners: {
activate: function(){
Ext.Function.createDelayed( function(){
if(i < len_sql){
document.getElementById('ansl1').innerText = ans1[0];
Ext.getCmp('ans1').setValue(ans1[0]);
document.getElementById('ansl2').innerText = ans2[0];
Ext.getCmp('ans2').setValue(ans2[0]);
document.getElementById('ansl3').innerText = ans3[0];
Ext.getCmp('ans3').setValue(ans3[0]);
document.getElementById('ansl4').innerText = ans4[0];
Ext.getCmp('ans4').setValue(ans4[0]);
document.getElementById('titlebar').innerText = 'Questions:' + len_sql;// + 'Answered:' + (j);
document.getElementById('que').innerText = (i+1) + '.' + main_ques[0];
logo.setSrc(qImg[0]);
}
},1000,this)();
}
},
items: [
titleb,
logo,
{
xtype: 'toolbar',
layout: {
pack: 'center'
}, // layout
ui: 'plain',
items: [{
xtype: 'label',
id: 'que'
},
{
xtype: 'hiddenfield',
id: 'qId'
}
]
}, {
xtype: 'fieldset',
items: [{
xtype: 'radiofield',
id: 'ans1',
name: 'answer',
label: '<label id="ansl1"></label>',
listeners : {
check : function( radioFld, event, obj) {
if(i == len_sql-1){
Ext.getCmp('next').addCls('nextButton');
}else{
Ext.getCmp('next').removeCls('nextButton');
}
if(radioFld.isChecked()) {
alert("Label one:")
}
}
}
}, {
xtype: 'radiofield',
id: 'ans2',
name: 'answer',
label: '<label id="ansl2"></label>',
listeners : {
check : function( radioFld, event, obj) {
if(i == len_sql-1){
Ext.getCmp('next').addCls('nextButton');
}else{
Ext.getCmp('next').removeCls('nextButton');
}
if(radioFld.isChecked()) {
alert("Label two:")
}
}
}
},{
xtype: 'radiofield',
id: 'ans3',
name: 'answer',
label: '<label id="ansl3"></label>',
listeners : {
check : function( radioFld, event, obj) {
if(i == len_sql-1){
Ext.getCmp('next').addCls('nextButton');
}else{
Ext.getCmp('next').removeCls('nextButton');
}
if(radioFld.isChecked()) {
alert("Label three:")
}
}
}
},{
xtype: 'radiofield',
id: 'ans4',
name: 'answer',
label: '<label id="ansl4"></label>',
listeners : {
check : function( radioFld, event, obj) {
if(i == len_sql-1){
Ext.getCmp('next').addCls('nextButton');
}else{
Ext.getCmp('next').removeCls('nextButton');
}
if(radioFld.isChecked()) {
alert("Label four:")
}
}
}
}
] // items
}, {
xtype: 'toolbar',
cls: 'expand-panel',
layout: {
pack: 'center'
}, // layout
ui: 'plain',
items: [{
xtype: 'button',
text: 'Prev',
id: 'prev',
cls: 'prevButton',
ui: 'back',
handler: function (btn, evt) {
Ext.getCmp('next').removeCls('nextButton');
if(i>1){
Ext.getCmp('prev').removeCls('prevButton');
}else{
Ext.getCmp('prev').addCls('prevButton');
}
if(i <= len_sql){
var ans = Ext.ComponentQuery.query('radiofield[name=answer]');
without = ans[0].getGroupValue();
withoutNo[i] = without;
if(withoutNo[i] != null) {
var str = checked+i;
var istr = ""+i+"";
alert("Value of str:" +str);
alert("Value of istr:" +istr);
if((quesManage[i] == checked) || (str.indexOf(istr) >= 0)) {
alert("Tested!!!!!");
} else {
quesManage[j] = checked+i;
alert("Else loop: " +quesManage[j]);
j++;
}
} else {
alert("Value is null:");
}
// document.getElementById('titlebar').innerText = 'Questions:' + len_sql + ' ' + 'Answered:' + quesManage.length;
result = qId[i] +":" + ans[0].getGroupValue();
// result = ans[0].getGroupValue();
resultArray[i] = result;
i = i-1;
document.getElementById('ansl1').innerText = ans1[i];
Ext.getCmp('ans1').setValue(ans1[i]);
document.getElementById('ansl2').innerText = ans2[i];
Ext.getCmp('ans2').setValue(ans2[i]);
document.getElementById('ansl3').innerText = ans3[i];
Ext.getCmp('ans3').setValue(ans3[i]);
document.getElementById('ansl4').innerText = ans4[i];
Ext.getCmp('ans4').setValue(ans4[i]);
document.getElementById('que').innerText = (i+1) + '.' + main_ques[i];
// document.getElementById('titlebar').innerText = 'Questions:' + len_sql + ' ' + 'Answered:' + withoutNo.length;
logo.setSrc(qImg[i]);
}
contactForm.reset();
setOption = resultArray[i].split(':');
ans[0].setGroupValue(setOption[1]);
} // handler
},
{
xtype: 'button',
text: 'Submit',
ui: 'confirm',
handler: function (btn, evt) {
var answers = Ext.ComponentQuery.query('radiofield[name=answer]');
Ext.Msg.alert('Radiofield Vallue: ', answers[0].getGroupValue());
} // handler
},{
xtype: 'button',
text: 'Save',
ui: 'action',
handler: function (btn, evt) {
var ans = Ext.ComponentQuery.query('radiofield[name=answer]');
//result = qId[i] +":"+ ans[0].getGroupValue();
result = ans[0].getGroupValue();
resultArray[i] = result;
for(var r=0; r < resultArray.length; r++){
if(resultArray[r] != null) {
// answered = resultArray[r];
} else {
alert("Null value:")
}
alert(resultArray[r]);
}
// document.getElementById('titlebar').innerText = 'Questions:' + len_sql + ' ' + 'Answered:' + answered.length;
Ext.Msg.alert('Saved');
} // handler
}, {
xtype: 'button',
text: 'Next',
id: 'next',
cls: 'nextButton',
ui: 'forward',
handler: function (btn, evt) {
Ext.getCmp('prev').removeCls('prevButton');
if(i == len_sql-2){
Ext.getCmp('next').addCls('nextButton');
}else{
Ext.getCmp('next').removeCls('nextButton');
}
if(i < len_sql){
var ans = Ext.ComponentQuery.query('radiofield[name=answer]');
without = ans[0].getGroupValue();
withoutNo[i] = without;
result = qId[i] +":"+ ans[0].getGroupValue();
// result = ans[0].getGroupValue();
resultArray[i] = result;
if(withoutNo[i] != null) {
for(var t=0; t<withoutNo.length; t++) {
// quesManage[t] = i;
alert("Inside for loop:" +withoutNo[t]);
alert("value of quesManage:" +quesManage[t]);
}
document.getElementById('titlebar').innerText = 'Questions:' + len_sql + ' ' + 'Answered:' + withoutNo.length;
}
// if(ans[0].getGroupValue() != null){
i = i+1;
document.getElementById('ansl1').innerText = ans1[i];
Ext.getCmp('ans1').setValue(ans1[i]);
document.getElementById('ansl2').innerText = ans2[i];
Ext.getCmp('ans2').setValue(ans2[i]);
document.getElementById('ansl3').innerText = ans3[i];
Ext.getCmp('ans3').setValue(ans3[i]);
document.getElementById('ansl4').innerText = ans4[i];
Ext.getCmp('ans4').setValue(ans4[i]);
document.getElementById('que').innerText = (i+1) + "." + main_ques[i];
// document.getElementById('titlebar').innerText = 'Questions:' + len_sql + ' ' + 'Answered:' + withoutNo.length;
if(qImg[i]==""){
logo.setSrc("");
}else{
logo.setSrc(qImg[i]);
}
// }else{
// Ext.Msg.alert('Select any option.');
// }
}
contactForm.reset();
setOption = resultArray[i].split(':');
ans[0].setGroupValue(setOption[1]);
} // handler
}] // items (toolbar)
}] // items (formpanel)
}); // create()
} // launch
}); // application()
Hi ravindra,
Hi Sumit,
© Copyright © 2010 - 2021 MindStick Software Pvt. Ltd. All Rights Reserved
Sumit Kesarwani
Hi ravindra,