$(document).ready(function(){var online=navigator.onLine;if(window.openDatabase){createTables(db);tryit();}});try{if(!window.openDatabase){alert('Your phone will not remember any changed settings');}else{var shortName='PakkeSporing';var version='1.0';var displayName='pakke.bensmann.no';var maxSize=65536;var db=openDatabase(shortName,version,displayName,maxSize);}}catch(e){if(e==2){alert("Invalid database version.");}else{alert("Unknown error "+e+".");}}
function nullDataHandler(transaction,results){}
function dropTable(){db.transaction(function(transaction){transaction.executeSql('DROP TABLE sporing;',[],nullDataHandler,errorHandler);});}
function createTables(){db.transaction(function(transaction){transaction.executeSql('CREATE TABLE sporing(id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, name TEXT NOT NULL, code TEXT NOT NULL, data TEXT NOT NULL, date TEXT NOT NULL, status TEXT NOT NULL);',[],nullDataHandler,errorHandler);});}
function insertData(id,item_id){db.transaction(function(transaction){});}
function changeSettings(id,value){db.transaction(function(transaction){transaction.executeSql("UPDATE settings SET value='"+value+"' where id="+id+";");});}
function errorHandler(transaction,error){var we_think_this_error_is_fatal=true;if(we_think_this_error_is_fatal)return true;return false;}
function dataHandler(transaction,results){content='';for(var i=0;i<results.rows.length;i++){var row=results.rows.item(i);content+='<li sqlrow="'+row['id']+'" code="'+row['code']+'"><h3>'+row['name']+'</h3><div>'+row['status']+' - '+row['code']+'</div></li>';}
$('.list').html(content);$('.backButton').hide();$('.editButton, .addButton').show();$('.list li').click(function(){$editButton=$('.editButton')
if(!$editButton.hasClass('editingOn')){code=$(this).attr('code');sqlrow=$(this).attr('sqlrow')
fetchJSONData(code,sqlrow)}});}
function tryit(){db.transaction(function(transaction){transaction.executeSql("SELECT * from sporing ORDER BY id DESC;",[],dataHandler,errorHandler);});}