<html>
<head>
<meta charset="utf-8"/>
<title>表 3-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()">
<select id="abc" name="abc">
<input type="button" value="検索" onClick="fusion()" />
<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+"1CwzRsc360nNYcTVC1YHwpjLILwrPSmy6KPCGXw0";
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();
$("#memo").text("準備完了");
}
});
}
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;
}
for(s=1;s<creditnumber[2]+1;s++){
var option = $('<option />');
option.val(index[2][s]);
option.html(credit[2][s]);
$("#abc").append(option);
}
}
var a=new Array();
var b=new Array();
var c=new Array();
var d=new Array();
var v=new Array();
var number,subnumber;
var vs=new Array();
var ax=new Array();
var bx=new Array();
var cx=new Array();
var dx=new Array();
function fusion(){
var query = "SELECT * FROM ";
query=query+"188xJRCLKc8oibNCOP7qagb1QqPCltAdl-hAPJII";
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 abc=$("#abc").val();
var s,sx;
var axs=new Array();
var bxs=new Array();
var cxs=new Array();
var dxs=new Array();
sx=0;
for(s=1;s<number+1;s++){
if(b[s]==abc)sx=sx+1;
if(b[s]==abc)axs[sx]=a[s];
if(b[s]==abc)cxs[sx]=c[s];
if(b[s]==abc)dxs[sx]=d[s];
if(b[s]==abc)vs[sx]=v[s];
}
subnumber=sx;
for(s=1;s<subnumber+1;s++){
ax[s]="noname";
for(sx=1;sx<creditnumber[1]+1;sx++){
if(axs[s]==index[1][sx])ax[s]=credit[1][sx];
}
}
for(s=1;s<subnumber+1;s++){
cx[s]="noname";
for(sx=1;sx<creditnumber[3]+1;sx++){
if(cxs[s]==index[3][sx])cx[s]=credit[3][sx];
}
}
for(s=1;s<subnumber+1;s++){
dx[s]="noname";
for(sx=1;sx<creditnumber[4]+1;sx++){
if(dxs[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', "期間");
data.addColumn('number', "値");
data.addRows(subnumber);
for(s=1;s<subnumber+1;s++){
data.setCell(s-1, 0, dx[s]);
data.setCell(s-1, 1,vs[s]);
}
var table = new google.visualization.Table(document.getElementById('memo'));
table.draw(data, {showRowNumber: true});
}
最終更新：2013年12月31日 22:09
