google.load("visualization", "1");
google.load("feeds", "1");

function init() {
	var query = new google.visualization.Query("http://spreadsheets.google.com/tq?key=tNcOfLvh-WzdaPtGN9DIcIg&gid=0&pub=1");
	query.setQuery("select A,B,C,D,E,F");
	query.send(function(response) {
		handleQueryResponse("jica", response);
	});

	query = new google.visualization.Query("http://spreadsheets.google.com/tq?key=tkALIdqeu0SopmM0Vpw_QHg&gid=0&pub=1");
	query.setQuery("select A,B,C,D,E,F");
	query.send(function(response) {
		handleQueryResponse("ngo", response);
	});
}

google.setOnLoadCallback(init);

function handleQueryResponse(category, response) {
	var dataTable = eval("(" + response.getDataTable().toJSON() + ")");
	var count = dataTable.rows.length;
	var feedElem = document.getElementById("feed_" + category);

	for (i = 1; i < count; i++) {
		var row = dataTable.rows[i];
		var url = row.c[0].v;
		var rss = row.c[1].v;
		var name = unescape(row.c[2].v);
		var description = unescape(row.c[3].v);
		var country = unescape(row.c[4].v);
		var org = unescape(row.c[5].v);
		
		var ele = document.createElement("div");
		ele.innerHTML = "<div class='blog'>" +
						"<h4><a href='" + url + "'>" + name + "</a></h4>" +
						"<p>" + description + "</p>" +
						"<div id='" + category + i + "' class='article'></div>" +
						"</div>" +
						"<script type='text/javascript' defer='defer'>loadRss('" + rss + "', '" + category + i + "');</script>";
		feedElem.appendChild(ele);
	}
}

function loadRss(rss, id) {
	var feed = new google.feeds.Feed(rss);
	feed.setNumEntries(1);
	if (rss == null || rss == "") return;
	feed.load(function(data) {
		var entry = data.feed.entries[0];
		var ele = document.createElement("div");
		var date = new Date(entry.publishedDate);
		var dateString = date.getFullYear() + "年" + (date.getMonth() + 1) + "月" + date.getDate() + "日";
		ele.innerHTML =  "<div><span>最新記事：" + dateString + "</span>[<a href='" + entry.link + "'>" + entry.title + "</a>]</div>";
		document.getElementById(id).appendChild(ele);
	});
}