var db = window.openDatabase("matomenomoridb", "1.0", "まとめの杜", "1048576");
var table_init_sql = 'CREATE TABLE IF NOT EXISTS bookmarks(id TEXT, entry_name TEXT, url TEXT , blog_name TEXT , read_chk TEXT , created TEXT)';
function addEntry(inm){
	db.transaction(function(tx){
		var blog_name = document.getElementById("itm_blt" + inm).innerText;
		var entry_name = document.getElementById("itm_tle" + inm).innerText;
		var entry_url = document.getElementById("itmlnk" + inm).href;
		tx.executeSql( table_init_sql, []);
		var uid = window.UUID.generate();
		tx.executeSql('SELECT count(*) as cnt FROM bookmarks WHERE entry_name = ? AND blog_name = ?',[entry_name , blog_name],
			function(tx, res){
				if ( res.rows.item(0).cnt == '0' )
					tx.executeSql('INSERT INTO bookmarks(id , entry_name , url , blog_name ,read_chk , created  )  VALUES( ? , ? , ? , ? , ? , ? )' , [uid,entry_name,entry_url,blog_name,'false',new Date() ]);
					document.getElementById("atd" + inm).innerText = '⊿';
			}
		);
	});
}
function checkEntry(inm){
	db.transaction(function(tx){
		var blog_name = document.getElementById("itm_blt" + inm).innerText;
		var entry_name = document.getElementById("itm_tle" + inm).innerText;
		var entry_url = document.getElementById("itmlnk" + inm).href;
		tx.executeSql( table_init_sql, []);
		tx.executeSql('SELECT count(*) as cnt FROM bookmarks WHERE entry_name = ? AND blog_name = ?',[entry_name , blog_name],
			function(tx, res){
				if ( res.rows.item(0).cnt != '0' ){
					document.getElementById("atd" + inm).innerText = '⊿';
				}
			}
		);
	});
}

function deleteEntry(inm){
	db.transaction(function(tx){
		tx.executeSql('DELETE FROM bookmarks WHERE id = ?' , [inm]);
		loadEntries();
    });
}

function deleteAllEntry(){
	if (confirm("全て削除します。本当にいいですか？")) { 
		db.transaction(function(tx){
			tx.executeSql('DELETE FROM bookmarks' , []);
			window.location.reload();
     	});
	}
}
function readEntry(id){
	db.transaction(function(tx){
		tx.executeSql("update bookmarks set read_chk = 'true' where id = ?" , [id]);
		ccv('itm' + id);
   	});
}

function loadEntries(){
	db.transaction(function(tx){
		tx.executeSql( table_init_sql, []);
		var lst = tx.executeSql('SELECT * FROM bookmarks ORDER BY created DESC',[],
			function(tx, res){
				var str = "";
				var len = res.rows.length;
				for(var i=0; i<len; i++) {
					var robj = res.rows.item(i);
					var sty = "";
					if (robj.read_chk == 'true'){
						sty = 'background:rgb(255, 255, 204);';
					}
					str += '<li style="'+sty+'padding-top: 10px" id="itm' + robj.id + '">';
					str += '<small style="line-height:15px;padding-top:0px;padding-bottom:0px" ><span id="itm_blt' + robj.id + '">' + robj.blog_name +'</span><br/>   ';
					str += '<span style="color:gray;" onclick="deleteEntry(\''+robj.id+'\')" >⊿削除</span>';
					str += '</small>';
					str += '<span><a style="margin-right: 90px;" id="itmlnk' + robj.id  + '" onclick="readEntry(\'' + robj.id  +'\');" target="_blank" href="' + robj.url + '">';
					str += '<span id="itm_tle' + robj.id + '">' +robj.entry_name + '</span></a></span>';
					str+='</li>\n';
					document.getElementById('atodelist').innerHTML=str;
				}
			});
	});
}