アットウィキロゴ
プログラム倉庫
アットウィキロゴ
プログラム倉庫
ページ一覧

ｓ他愛

<html>
<head>
<meta charset="utf-8"/>
<title>次世代</title>
<script src="https://www.google.com/jsapi"></script>
<script src="jquery.js"></script>
<script src="citycode.js"></script>
<script src="social.js"></script>
<script src="sample.js"></script>
<script src="jsonp.js"></script> 
<script src="table.js"></script> 
</head>
<body onload="sample()">
<select id="topic" name="topic">
</select>
<input type="button" value="ダウンロード" onClick="jsonp()" />
<br>
<select id="year" name="year">年
<input type="button" value="グラフ" onClick="table()" />
</select>
<div id="chart" style="width: 800px; height: 500px;"></div>
</body>
</html>
 
 
c=new Array();
y=new Array();
v=new Array();
var number;
 
function jsonp() {
 
var page=$("#topic").val();
 
var urlx;
 
urlx="http://atsites.jp/skebank/soc/gdata/"+page+".jsonp";
 
$.ajax({
  type: 'GET',
  url: urlx,
  dataType: 'jsonp',
  jsonpCallback: 'callback',
  success: function(json){
 
number = json.length;
var s;
var x1;
for(s=0; s<number; s++){
c[s+1]=json[s].city;
x1=json[s].year;
y[s+1]=parseInt(x1);
x1=json[s].v;
v[s+1]=parseInt(x1);
}
 
 
f();
 
$("#chart").html("ダウンロード完了");
 
}
});
}
 
 
function f(){
 
var s,sx,h;
var ynumber;
year=new Array();
 
ynumber=0;
for(s=1;s<number+1;s++){
h=0;
for(sx=1;sx<ynumber+1;sx++){
if(y[s]==year[sx])h=100;
}
if(h<50)ynumber=ynumber+1;
if(h<50)year[ynumber]=y[s];
}
 
for(s=1;s<ynumber+1;s++){
var option = $('<option />');
option.val(year[s]);
option.html(year[s]);
$("#year").append(option);
}
 
 
 
}
 
 
 
google.load("visualization", "1", {packages:["table"]});
 
function table() {
 
var s,sx,subnumber;
 
var y1=$("#year").val();
 
v1=new Array();
c1=new Array();
c2=new Array();
n1=new Array();
 
sx=0;
for(s=1;s<number+1;s++){
if(y[s]==y1)sx=sx+1;
if(y[s]==y1)v1[sx]=v[s];
if(y[s]==y1)c1[sx]=c[s];
}
 
subnumber=sx;
 
for(s=1;s<subnumber+1;s++){
str="7"+c1[s];
c2[s]=parseInt(str)-700000;
}
 
for(s=1;s<subnumber+1;s++){
n1[s]="abc";
for(sx=1;sx<citynumber+1;sx++){
if(c2[s]==city[sx])n1[s]=n[sx]
}
}
 
 
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, n1[s]);
data.setCell(s-1, 1, v1[s]);
}
 
var table = new google.visualization.Table(document.getElementById('chart'));
table.draw(data, {showRowNumber: true});
 
}
 
 
 
soc=new Array();                                        
var socnumber; 
 
function social() {
 
       var query = "SELECT * FROM " +
            '1paGzEyuBKmAvFMrYGr5kOrP8bCDH914Vqure00A';
 
        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'];
 
var tx;
 
for (var i in rows) {
sx=sx+1;
soc[sx]= rows[i][0];
}
 
socnumber=sx;
 
select();
 
$("#chart").text("準備完了");
 
}
});
 
}
 
function select(){
 
var s;
 
for(s=1;s<socnumber+1;s++){
var option = $('<option />');
option.val(s);
option.html(soc[s]);
$("#topic").append(option);
}
 
}
 
 
city=new Array();              
n=new Array();                          
var citynumber; 
 
function citycode() {
 
       var query = "SELECT * FROM " +
            '1U7Qkyyazuj4UCoekdBnSbBukQylVtsdp4KjZTkY';
 
        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'];
 
var tx;
 
for (var i in rows) {
sx=sx+1;
n[sx]=rows[i][0];
city[sx]= rows[i][1];
}
 
citynumber=sx;
 
$("#chart").text("準備完了");
 
}
});
 
}
 
 
 
 
function sample(){
 
citycode();
 
social();
 
}
 
「ｓ他愛」をウィキ内検索
最終更新：2013年12月22日 09:44