kj - プログラム倉庫

google.load("visualization", "1", {packages:["table"]});
 
yahoo=new Array();
y=new Array();
m=new Array();
d=new Array();
r=new Array();
a=new Array();
t=new Array();
var number; 
 
var subnumber;
artist=new Array();
title=new Array();
 
function fusion() {
 
 var query = "SELECT * FROM ";   
query=query+"1N7WOBDTXcMXtjnkq6zFk_AieDmHbiV3KW3jjdyo"; 
 
 
 
        var encodedQuery = encodeURIComponent(query);
 
        var url = ['https://www.googleapis.com/fusiontables/v1/query'];
        url.push('?sql=' + encodedQuery);
        url.push('&key=AIzaSyAH0WCAXRIdHdbI-6bnMSN4kVDDZZmGyqY');
        url.push('&callback=?');
 
var sx;
 
sx=0;
 
        $.ajax({
          url: url.join(''),
          dataType: 'jsonp',
          success: function (data) {
 
 var rows = data['rows'];
 
for (var i in rows) {
sx=sx+1;
y[sx]=parseInt(rows[i][0]);
m[sx]=parseInt(rows[i][1]);
d[sx]=parseInt(rows[i][2]);
r[sx]=parseInt(rows[i][3]);
a[sx]=rows[i][4];
t[sx]=rows[i][5];
yahoo[sx]=rows[i][6];        
}
 
number=sx;
 
select();
 
$("#memo").text("準備完了");
 
}
});
 
}
 
function select(){
 
var y1,m1;
var str;
 
for(y1=2010;y1<2014;y1++){
var option = $('<option />');
option.val(y1);
str=""+y1+"年";
option.html(str);
$('#year').append(option);
}
 
 for(m1=1;m1<13;m1++){
var option = $('<option />');
option.val(m1);
str=""+m1+"月";
option.html(str);
$('#month').append(option);
}
 
 
}
 
function table() {
 
var s;
 
sample();
 
var data = new google.visualization.DataTable();
data.addColumn('string', "a");
data.addColumn('string', "t");
data.addColumn('string', "pic");
 
 
data.addRows(subnumber);
 
var pic="<img src=\"http://image.space.rakuten.co.jp/lg01/71/0001143671/88/imgb56990e2zikbzj.jpeg\" width=\100\" height=\"100\">";
 
for(s=1;s<subnumber+1;s++){
data.setCell(s-1, 0, artist[s]);
data.setCell(s-1, 1, title[s]);
data.setCell(s-1, 2, pic);
 
}
 
 
var table = new google.visualization.Table(document.getElementById('memo'));
table.draw(data, {allowHtml: true});
 
}
 
function sample(){
 
var y1,m1; 
var h,s,sx;
 
 
y1=$("#year").val();
m1=$("#month").val();
 
 
sx=0;
for(s=1;s<number+1;s++){
h=0;
if(y[s]==y1)h=h+1;
if(m[s]==m1)h=h+1;
if(h==2)sx=sx+1;
if(h==2)artist[sx]=a[s];
if(h==2)title[sx]=t[s];
}
 
subnumber=sx;
 
}