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)';

var visited_html = '<span style="color:blue;">⊿</span>';

function addEntry( inm , uid , entry_url ,entry_name , blog_name ){
	db.transaction(function(tx){
		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' )
					var dd = new Date();
//dd.getYear().toString() + dd.getMonth().toString() + dd.getDate().toString() + dd.getHours().toString() + dd.getMinutes().toString() + dd.getSeconds().toString() + dd.getMilliseconds().toString() 
					tx.executeSql('INSERT INTO bookmarks(id , entry_name , url , blog_name ,read_chk , created  )  VALUES( ? , ? , ? , ? , ? , ? )' , [uid,entry_name,entry_url,blog_name,'false', dd.getTime()  ]);
					document.getElementById("itmatd" + inm).innerHTML = visited_html;
			}
		);
	});
}
function checkEntry(inm , entry_url ,entry_name , blog_name){
	db.transaction(function(tx){
		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("itmatd" + inm).innerText = '⊿';
				}
			}
		);
	});
}
function checkEntryByUID(inm,uid){
	db.transaction(function(tx){
		tx.executeSql( table_init_sql, []);
		tx.executeSql('SELECT count(*) as cnt FROM bookmarks WHERE id = ? ',[uid],
			function(tx, res){
				if ( res.rows.item(0).cnt != '0' ){
					document.getElementById("itmatd" + inm).innerHTML = visited_html;
				}
			}
		);
	});
}

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 += '<div id="itm' + robj.id + '" style="margin-bottom:3px;height:22px; clear:left'+sty+'" onmouseover="bbc(\'itm'+ robj.id +'\',\'0\');" onmouseout="bbc(\'itm' + robj.id + '\',\'1\');" >';
					str += '<div style="text-align: left; float: left; max-width: 85%">';
					str += '<font style="font-size:12px;color:#AAAAAA">　</font>';
					str += '<a id="itmlnk'+robj.id+'" onclick="readEntry(\'' + robj.id  +'\');" target="_blank" href="'+robj.url+'">'+robj.entry_name+'</a>';
					str += '<span name="ikjh'+robj.id+'" suid="'+robj.id+'"  id="sitename">&nbsp;('+robj.blog_name+')</span>';
					str += '</div>';
					str += '<div id="atcle_menu">';
					str += '<span><a id="itmlnk'+robj.id+'" onclick="cclp(\'itm'+robj.id+'\', \''+robj.id+'\');" target="_blank" href="'+robj.url+'">[読む] </a></span>';
					str += '<span onclick="deleteEntry(\''+robj.id+'\')" >[⊿削除]</span>';
					str += '</div>';
					str += '</div>';
					str+='\n';
					document.getElementById('atodelist').innerHTML=str;
				}
			});
	});
}