<html>
<head>
<meta charset="utf-8"/>
<title>表 1-0 事業活動の産業別売上高</title>
<script src="https://www.google.com/jsapi"></script>
<script src="jquery.js"></script>
<script src="index.js"></script>
<script src="fusion.js"></script>
<script src="table.js"></script>
</head>
<body onload="sample()">
<div id="memo" style="width: 800px; height: 500px;">準備中</div>
</body>
</html>
var a_index=new Array();
var b_index=new Array();
var c_index=new Array();
var number_index;
var indexnumber;
var creditnumber=new Array();
var credit=new Array();
var index=new Array();
function sample() {
var query = "SELECT * FROM ";
query=query+"17KEpHeTL6HA-Fh68naOCG3rx80wMIBDtfqYU-dY";
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;
a_index[sx]=parseInt(rows[i][0]);
c_index[sx]=rows[i][2];
b_index[sx]=rows[i][1];
}
number_index=sx;
select();
fusion();
}
});
}
function select(){
var s,sx,n1,tx;
n1=0;
for(s=1;s<number_index+1;s++){
if(a_index[s]>n1)n1=a_index[s];
}
indexnumber=n1;
for(s=1;s<indexnumber+1;s++){
credit[s]=new Array();
index[s]=new Array();
}
for(s=1;s<indexnumber+1;s++){
tx=0;
for(sx=1;sx<number_index+1;sx++){
if(a_index[sx]==s)tx=tx+1;
if(a_index[sx]==s)credit[s][tx]=b_index[sx];
if(a_index[sx]==s)index[s][tx]=c_index[sx];
}
creditnumber[s]=tx;
}
}
var a=new Array();
var b=new Array();
var c=new Array();
var d=new Array();
var v=new Array();
var number;
var ax=new Array();
var bx=new Array();
var cx=new Array();
var dx=new Array();
function fusion(){
var query = "SELECT * FROM ";
query=query+"1Ifq6jDezUsGnnB6t2RuzIeWFuxx9xYTTz7f-tsY";
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;
a[sx]=rows[i][0];
b[sx]=rows[i][1];
c[sx]=rows[i][2];
d[sx]=rows[i][3];
v[sx]=parseInt(rows[i][4]);
}
number=sx;
g();
table();
}
});
}
function g(){
var s,sx;
for(s=1;s<number+1;s++){
ax[s]="noname";
for(sx=1;sx<creditnumber[1]+1;sx++){
if(a[s]==index[1][sx])ax[s]=credit[1][sx];
}
}
for(s=1;s<number+1;s++){
bx[s]="noname";
for(sx=1;sx<creditnumber[2]+1;sx++){
if(b[s]==index[2][sx])bx[s]=credit[2][sx];
}
}
for(s=1;s<number+1;s++){
cx[s]="noname";
for(sx=1;sx<creditnumber[3]+1;sx++){
if(c[s]==index[3][sx])cx[s]=credit[3][sx];
}
}
for(s=1;s<number+1;s++){
dx[s]="noname";
for(sx=1;sx<creditnumber[4]+1;sx++){
if(d[s]==index[4][sx])dx[s]=credit[4][sx];
}
}
}
google.load("visualization", "1", {packages:["table"]});
function table() {
var s;
var data = new google.visualization.DataTable();
data.addColumn('string', "a");
data.addColumn('string', "b");
data.addColumn('string', "c");
data.addColumn('string', "d");
data.addColumn('number', "v");
data.addRows(number);
for(s=1;s<number+1;s++){
data.setCell(s-1, 0, ax[s]);
data.setCell(s-1, 1, bx[s]);
data.setCell(s-1, 2, cx[s]);
data.setCell(s-1, 3, dx[s]);
data.setCell(s-1, 4,v[s]);
}
var table = new google.visualization.Table(document.getElementById('memo'));
table.draw(data, {showRowNumber: true});
}
最終更新：2013年12月31日 12:28
