minmoll - 経済統計練習帳

var namex = new Array();
 var alpha = new Array();
  var credit = new Array();
 
function sample() {
 
        var query = "SELECT * FROM 14MPwXgD2khm2QsqR4Quhd4Y8IK5DAZrW1F_B9-0F";
        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=?');
 
 credit[1]="農林水産業";
credit[2]="鉱業";
credit[3]="食料品";
credit[4]="繊維";
credit[5]="パルプ・紙";
credit[6]="化学";
credit[7]="石油・石炭製品";
credit[8]="窯業・土石製品";
credit[9]="一次金属";
credit[10]="金属製品";
credit[11]="一般機械";
credit[12]="電気機械";
credit[13]="輸送用機械";
credit[14]="精密機械";
credit[15]="その他の製造工業製品";
credit[16]="建設";
credit[17]="電気・ガス・水道";
credit[18]="卸売・小売";
credit[19]="金融・保険";
credit[20]="不動産";
credit[21]="運輸";
credit[22]="情報通信";
credit[23]="サ－ビス";
credit[24]="政府サ－ビス";
credit[25]="対家計民間非営利サ－ビス";
credit[26]="内生部門計";
credit[27]="政府集合消費支出";
credit[28]="家計最終消費支出";
credit[29]="対家計民間非営利団体最終消費支出";
credit[30]="政府個別消費支出";
credit[31]="在庫品増加";
credit[32]="総固定資本形成・公的";
credit[33]="総固定資本形成・民間";
credit[34]="輸出";
credit[35]="輸入（控除）";
credit[36]="国内総生産（支出）";
credit[37]="産出額";
 
 
 
 
 for(s=1;s<50;s++){
 alpha[s]=new Array();    
 }
 
 
 
        $.ajax({
            url: url.join(''),
            dataType: 'jsonp',
            success: function (data) {
                var rows = data['rows'];
 
 
 
 for(s=1;s<51;s++){
 alpha[s]=new Array();    
 }
 
 
                sx = 0;
 
            for (var i in rows) {
             sx=sx+1;
             namex[sx]=rows[i][0];
            for(s=1;s<38;s++){
            alpha[sx][s]=rows[i][s];
            }
            }
 
 number=sx;
 
paint();
 
cal();
 
 
 
 
            }
        });
 
}
 
 
function paint(){
 
  str1="<table class=\"mdl-data-table mdl-js-data-table mdl-data-table--selectable mdl-shadow--2dp\">";
  str2="<th class=\"mdl-data-table__cell--non-numeric\">";
  str3="<td class=\"mdl-data-table__cell--non-numeric\">";
 
    str=str1;
    str=str+"<thead>";
    str=str+"<tr>";
 
    str=str+"<th>産業</th>";
for(sx=1;sx<38;sx++){
str=str+"<th>("+sx+")"+credit[sx]+"</th>";
}
str=str+"</tr>"
str=str+"</thead>";
 
  str=str+"<tbody>";
for(s=1;s<number+1;s++){
str=str+"<tr>";
 
str=str+"<td>("+s+")"+namex[s]+"</td>";
for(sx=1;sx<38;sx++){
str=str+"<td>"+alpha[s][sx]+"</td>";
 
}
        str=str+"</tr>";
    } 
str=str+"</table>";
 
 
 
 $("#memo").html(str);
 
}
 
function cal(){
 
var y=new Array();
var im=new Array();
var ex=new Array();
var inv=new Array();
var c=new Array();
 
for(s=1;s<26;s++){
im[s]=alpha[s][35];
ex[s]=alpha[s][34];
inv[s]=alpha[s][33];
c[s]=alpha[s][28];
}
 
 
 
str=str1;
str=str+"<thead>";
str=str+"<tr>";
str=str+"<th>産業</th>";
str=str+"<th>消費</th>";
str=str+"<th>投資</th>";
str=str+"<th>輸出</th>";
str=str+"<th>輸入</th>";
str=str+"</tr>"
str=str+"</thead>";
str=str+"<tbody>";
for(s=1;s<26;s++){
str=str+"<tr>";
str=str+"<td>("+s+")"+namex[s]+"</td>";
str=str+"<td>"+c[s]+"</td>";
str=str+"<td>"+inv[s]+"</td>";
str=str+"<td>"+ex[s]+"</td>";
str=str+"<td>"+im[s]+"</td>";
str=str+"</tr>";
} 
str=str+"</table>";
 
$("#point").html(str);
 
 
}