var point = new Array();
var x = new Array();
var y1 = new Array();
var m1 = new Array();
var y2 = new Array();
var m2 = new Array();
var sta = new Array();
var t = new Array();
var week = new Array();
var time = new Array();
function sample() {
var query = "SELECT * FROM " +
'1l0FJwM4YDJtJUTqF1tx_RmE7XaeeqD4990E0W9Pz';
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=?');
$.ajax({
url: url.join(''),
dataType: 'jsonp',
success: function (data) {
var rows = data['rows'];
sx = 0;
for (var i in rows) {
sx = sx + 1;
y1[sx]=rows[i][1]/1;
m1[sx]=rows[i][2]/1;
y2[sx]=rows[i][3]/1;
m2[sx]=rows[i][4]/1;
sta[sx]=rows[i][0];
week[sx]=rows[i][5];
time[sx]=rows[i][6]/1;
t[sx]=rows[i][7];
}
number = sx;
$("select").change(function () {
var v1 = $("#sel4").val();
y=v1/1;
var v2 = $("#sel5").val();
m=v2/1;
var v5 = $("#sel").val();
var v3 = $("#sel2").val();
var v4 = $("#sel3").val();
play(1987,m,v3,v4,v5);
});
}
});
}
function play(c1,c2,c3,c4,c5){
str="no";
for(s=1;s<number+1;s++){
h=0;
if(sta[s]==c5)h=h+1;
if(week[s]==c3)h=h+1;
if(time[s]==c4)h=h+1;
z=(c1-1980)*12+c2;
z1=12*(y1[s]-1980)+m1[s];
z2=12*(y2[s]-1980)+m2[s];
if(z>z1)h=h+1;
if(z<z2)h=h+1;
if(h==5)str=t[s];
}
$("#memo").html(str);
}
<html>
<head>
<title>統計体系</title>
<meta charset="utf-8" />
<script type='text/javascript' src='https://www.gstatic.com/charts/loader.js'></script>
<script type='text/javascript' src='sample.js'></script>
<script type='text/javascript' src='jquery.js'></script>
</head>
<body onload="sample()">
<select id="sel" name="x">
<option value="tbs">TBS</option>
<option value="日本">日本</option>
<option value="フジ">フジ</option>
<option value="東京" selected>東京</option>
<option value="朝日">朝日</option>
</select>
<select id="sel2" name="x">
<option value="月">月</option>
<option value="火">火</option>
<option value="水">水</option>
<option value="木" selected>木</option>
<option value="金">金</option>
<option value="土">土</option>
<option value="日">日</option>
</select>
<select id="sel3" name="x">
<option value="71">7</option>
<option value="72">7</option>
<option value="8">8</option>
<option value="9" selected>9</option>
<option value="101">10</option>
<option value="102">10</option>
</select>
<select id="sel4" name="x">
<option value="1981">1</option>
<option value="1982">2</option>
<option value="1983">3</option>
<option value="1984" selected>1984</option>
<option value="1985">5</option>
<option value="1986">6</option>
<option value="1987">7</option>
<option value="1988">8</option>
<option value="1989">9</option>
</select>
<select id="sel5" name="x">
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4" selected>4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10" selected>10</option>
<option value="11">11</option>
<option value="12">12</option>
</select>
<div id="memo" style="width: 900px; height: 500px;"></div>
</body>
</html>
最終更新:2017年06月12日 00:43