var localStorageOptions = {
		    key: 'com.jc.mobile.estimates',
		    def: 'nothing saved!',
		    html: true,
		    errorfunc: function(){
		        alert('Not cool. Get a new browser');
		    }
		};

var suit = 'c';
var cardKeys = [ 14 ];
var cardHours = [ 14 ];
var cardDisplayed = [ 14 ];
var hourSelection = 'a';
var hourTimeValue = '1';

cardKeys[0] = 'a';
cardKeys[1] = '2';
cardKeys[2] = '3';
cardKeys[3] = '4';
cardKeys[4] = '5';
cardKeys[5] = '6';
cardKeys[6] = '7';
cardKeys[7] = '8';
cardKeys[8] = '9';
cardKeys[9] = '10';
cardKeys[10] = 'j';
cardKeys[11] = 'q';
cardKeys[12] = 'k';
cardKeys[13] = 'jk';

cardHours[0] = '1';
cardHours[1] = '2';
cardHours[2] = '3';
cardHours[3] = '4';
cardHours[4] = '5';
cardHours[5] = '6';
cardHours[6] = '7';
cardHours[7] = '8';
cardHours[8] = '9';
cardHours[9] = '10';
cardHours[10] = '12';
cardHours[11] = '20';
cardHours[12] = '40';
cardHours[13] = 'A lot';

cardDisplayed[0] = true;
cardDisplayed[1] = true;
cardDisplayed[2] = false;
cardDisplayed[3] = true;
cardDisplayed[4] = false;
cardDisplayed[5] = false;
cardDisplayed[6] = false;
cardDisplayed[7] = true;
cardDisplayed[8] = false;
cardDisplayed[9] = false;
cardDisplayed[10] = true;
cardDisplayed[11] = true;
cardDisplayed[12] = true;
cardDisplayed[13] = false;

function fillHoursSelection()
{
	var selectionsHtml = '<optgroup label="Hours">';
	
	var i=0;
	for (i=0;i<14;i++)
	{
		if(cardDisplayed[i]){
			selectionsHtml = selectionsHtml + '<option value ="' + cardKeys[i] + '">' + cardHours[i] + '</option>';	
		}
	}
	selectionsHtml = selectionsHtml + '</optgroup>';
	
	$('#hourSelection').html(selectionsHtml);
	
}


function fillInSettingsFromVars(){
	var i=0;
	for (i=0;i<14;i++)
	{
		if(cardDisplayed[i]){
			$('#' + cardKeys[i] + 'Toggle').attr('checked', true); //.attr('checked');
			
//			alert('setting to ' + '#' + cardKeys[i] + 'Toggle to checked');
		}
		else{
			$('#' + cardKeys[i] + 'Toggle').removeAttr('checked');
		}
		
		$('#' + cardKeys[i] + 'HourValue').val(cardHours[i]);
		
	}
	fillHoursSelection();
	
}

function loadSystemPropertiesIntoVars(){
	CARDS.transaction(
		    function (transaction) {
		        transaction.executeSql("SELECT * FROM system_settings;", [], systemSettingsSelectHandler, errorHandler);
		        
		    }
		);	

}

function systemSettingsSelectHandler(transaction, results){

	// Handle the results
    for (var i=0; i<results.rows.length; i++) {
        
    	var row = results.rows.item(i);
    	
        var newFeature = new Object();
    	
    	newFeature.property_name   = row['property_name'];
        newFeature.property_value = row['property_value'];
        
     
        if(newFeature.property_name=="suit")
        {
        	suit = newFeature.property_value;
        	
        	$("#selectedCardImage").attr('src', 'images/cards/' + suit + hourSelection + '.png');
        	
        	var optionToSetToSelected = $('#suitSelection').children().removeAttr("selected");
        	
        	var optionToSetToSelected = $('#' + suit + 'SuitSelectionOption');
 //       	alert("setting suit selection for " + suit + " " + optionToSetToSelected.html())
        	optionToSetToSelected.attr("selected", true);
        }
    }
    
    
}





function fillDefaultHoursInSettings()
{
	var i=0;
	for (i=0;i<14;i++)
	{
		$("#"+cardKeys[i] + "HourValue").attr('value', cardHours[i]);
	}	
}


function fillInSettings(){
//	alert('Filling in settings');
	
	selectAll();
	selectApplicationSettings();
	//updateSettingScreenWithDataHandler();
}
	



function selectApplicationSettings(){ 
	CARDS.transaction(
	    function (transaction) {
	        transaction.executeSql("SELECT * FROM application_settings ORDER BY id;", [], applicationSettingsSelectHandler, errorHandler);
	        
	    }
	);	
}

function applicationSettingsSelectHandler(transaction, results){

	// Handle the results
    for (var i=0; i<results.rows.length; i++) {
        
    	var row = results.rows.item(i);
    	
        var newFeature = new Object();
    	

    	newFeature.setting_id   = row['id'];
    	newFeature.property_name   = row['property_name'];
        newFeature.property_value = row['property_value'];
        
   //     alert('property[' + newFeature.setting_id   + ']' + newFeature.property_name + '=' + newFeature.property_value);      
    }
    
}




function selectAll(){ 
	CARDS.transaction(
	    function (transaction) {

	        transaction.executeSql("SELECT * FROM card_settings ORDER BY id;", [], dataSelectHandler, errorHandler);
	        
	    }
	);	
}

function dataSelectHandler(transaction, results){

	// Handle the results
    for (var i=0; i<results.rows.length; i++) {
        
    	var row = results.rows.item(i);
    	
        var newFeature = new Object();
    	

    	newFeature.card_id   = row['id'];
    	newFeature.card_name   = row['card_name'];
        newFeature.card_value = row['card_value'];
        newFeature.is_visibile    = (row['is_visibile'] == 'true');
        
   //     alert('card name=' + newFeature.card_name);
   //     alert('card name[' + newFeature.card_id   + ']' + newFeature.card_name + '=' + newFeature.card_value + ' visible=' + newFeature.is_visibile  + '.');
        
        cardKeys[i] = newFeature.card_name;
        cardHours[i] = newFeature.card_value;
        cardDisplayed[i] = newFeature.is_visibile;

       
    }
    fillInSettingsFromVars();

}

function selectAndUpdateCardSettingsScreen(){ 
//	alert('selectAndUpdateCardSettingsScreen');
	CARDS.transaction(
	    function (transaction) {

	        transaction.executeSql("SELECT * FROM card_settings ORDER BY id;", [], updateSettingScreenWithDataHandler, errorHandler);
	        
	    }
	);	
}
function updateSettingScreenWithDataHandler(transaction, results){

//	alert('updateSettingScreenWithDataHandler');
	// Handle the results
    for (var i=0; i<results.rows.length; i++) {
        
    	var row = results.rows.item(i);
        var newFeature = new Object();

    	newFeature.card_id   = row['id'];
    	newFeature.card_name   = row['card_name'];
        newFeature.card_value = row['card_value'];
        newFeature.is_visibile    = row['is_visibile'];
        
        cardKeys[card_id] = newFeature.card_name;
        cardHours[card_id] = newFeature.card_value;
        cardDisplayed[card_id] = (newFeature.is_visibile == 'true');
  
       
  //      alert('card name[' + newFeature.card_id + ']' + newFeature.card_name + '=' + cardHours);
  
       
    }

}








$(document).ready(function() {

	fillHoursSelection();
	fillDefaultHoursInSettings();

//	fillInSettings();
	
	
	
	
	
	
	$('#hourSelection').change(function(){
		$("#selectedCardImage").attr('src', 'images/cards/' + suit + $(this).val() + '.png');
		hourSelection = $(this).val() ;
		return false;
	});
	

	$('#suitSelection').change(function(){
		suit = $(this).val();
		saveSuitToDb(suit);

    	$("#selectedCardImage").attr('src', 'images/cards/' + suit + hourSelection + '.png');
    	
	});
	
	
	$('#aToggle').click(function() {
        if($(this).is(':checked')) {
            $(this).checked = true;
            cardDisplayed[0]=true;
        } 
        else{
            cardDisplayed[0]=false;
        }
    	fillHoursSelection();
		updateACardSetting(0);
    	
	});
	$('#2Toggle').click(function() {
        if($(this).is(':checked')) {
            $(this).checked = true;
            cardDisplayed[1]=true;
        } 
        else{
            cardDisplayed[1]=false;
        }
    	fillHoursSelection();
		updateACardSetting(1);
	});
	$('#3Toggle').click(function() {
        if($(this).is(':checked')) {
            $(this).checked = true;
            cardDisplayed[2]=true;
        } 
        else{
            cardDisplayed[2]=false;
        }
    	fillHoursSelection();
		updateACardSetting(2);
	});
	$('#4Toggle').click(function() {
        if($(this).is(':checked')) {
            $(this).checked = true;
            cardDisplayed[3]=true;
        } 
        else{
            cardDisplayed[3]=false;
        }
    	fillHoursSelection();
		updateACardSetting(3);
	});
	$('#5Toggle').click(function() {
        if($(this).is(':checked')) {
            $(this).checked = true;
            cardDisplayed[4]=true;
        } 
        else{
            cardDisplayed[4]=false;
        }
    	fillHoursSelection();
		updateACardSetting(4);
	});
	$('#6Toggle').click(function() {
        if($(this).is(':checked')) {
            $(this).checked = true;
            cardDisplayed[5]=true;
        } 
        else{
            cardDisplayed[5]=false;
        }
    	fillHoursSelection();
		updateACardSetting(5);
	});
	$('#7Toggle').click(function() {
        if($(this).is(':checked')) {
            $(this).checked = true;
            cardDisplayed[6]=true;
        } 
        else{
            cardDisplayed[6]=false;
        }
    	fillHoursSelection();
		updateACardSetting(6);
	});
	$('#8Toggle').click(function() {
        if($(this).is(':checked')) {
            $(this).checked = true;
            cardDisplayed[7]=true;
        } 
        else{
            cardDisplayed[7]=false;
        }
    	fillHoursSelection();
		updateACardSetting(7);
	});
	$('#9Toggle').click(function() {
        if($(this).is(':checked')) {
            $(this).checked = true;
            cardDisplayed[8]=true;
        } 
        else{
            cardDisplayed[8]=false;
        }
    	fillHoursSelection();
		updateACardSetting(8);
	});
	$('#10Toggle').click(function() {
        if($(this).is(':checked')) {
            $(this).checked = true;
            cardDisplayed[9]=true;
        } 
        else{
            cardDisplayed[9]=false;
        }
    	fillHoursSelection();
		updateACardSetting(9);
	});
	$('#jToggle').click(function() {
        if($(this).is(':checked')) {
            $(this).checked = true;
            cardDisplayed[10]=true;
        } 
        else{
            cardDisplayed[10]=false;
        }
    	fillHoursSelection();
		updateACardSetting(10);
	});
	$('#qToggle').click(function() {
        if($(this).is(':checked')) {
            $(this).checked = true;
            cardDisplayed[11]=true;
        } 
        else{
            cardDisplayed[11]=false;
        }
    	fillHoursSelection();
		updateACardSetting(11);
	});
	$('#kToggle').click(function() {
        if($(this).is(':checked')) {
            $(this).checked = true;
            cardDisplayed[12]=true;
        } 
        else{
            cardDisplayed[12]=false;
        }
    	fillHoursSelection();
		updateACardSetting(12);
	});
	$('#jkToggle').click(function() {
        if($(this).is(':checked')) {
            $(this).checked = true;
            cardDisplayed[13]=true;
        } 
        else{
            cardDisplayed[13]=false;
        }
    	fillHoursSelection();
		updateACardSetting(13);
	});
	
	
	$('#aHourValue').change(function(){
		cardHours[0] = $(this).val();
		fillHoursSelection();
		updateACardSetting(0);
	});
	$('#2HourValue').change(function(){
		cardHours[1] = $(this).val();
		fillHoursSelection();
		updateACardSetting(1);
	});
	$('#3HourValue').change(function(){
		cardHours[2] = $(this).val();
		fillHoursSelection();
		updateACardSetting(2);
	});
	$('#4HourValue').change(function(){
		cardHours[3] = $(this).val();
		fillHoursSelection();
		updateACardSetting(3);
	});
	$('#5HourValue').change(function(){
		cardHours[4] = $(this).val();
		fillHoursSelection();
		updateACardSetting(4);
	});
	$('#6HourValue').change(function(){
		cardHours[5] = $(this).val();
		fillHoursSelection();
		updateACardSetting(5);
	});
	$('#7HourValue').change(function(){
		cardHours[6] = $(this).val();
		fillHoursSelection();
		updateACardSetting(6);
	});
	$('#8HourValue').change(function(){
		cardHours[7] = $(this).val();
		fillHoursSelection();

		updateACardSetting(7);
	});
	$('#9HourValue').change(function(){
		cardHours[8] = $(this).val();
		fillHoursSelection();
		updateACardSetting(8);
	});
	$('#10HourValue').change(function(){
		cardHours[9] = $(this).val();
		fillHoursSelection();
		updateACardSetting(9);
	});
	$('#jHourValue').change(function(){
		cardHours[10] = $(this).val();
		fillHoursSelection();
		updateACardSetting(10);
	});
	$('#qHourValue').change(function(){
		cardHours[11] = $(this).val();
		fillHoursSelection();
		updateACardSetting(11);
	});
	$('#kHourValue').change(function(){
		cardHours[12] = $(this).val();
		fillHoursSelection();
		updateACardSetting(12);
	});
	$('#jkHourValue').change(function(){
//		changedCardValue('jk', 13);
		cardHours[13] = $(this).val();
		fillHoursSelection();
		updateACardSetting(13);
	});
	
	
	
	
	

});