９７６６６ - 経済統計練習帳

var y1 = new Array();
var m1 = new Array();
var y2 = new Array();
var m2 = new Array();
 
var ys1 = new Array();
var ms1 = new Array();
var ys2 = new Array();
var ms2 = new Array();
var n = new Array();
 
var week = new Array();
var code = new Array();
var namex = new Array();
var number;
 
function play(){
 
 
 var container = document.getElementById('memo');
var chart = new google.visualization.Timeline(container);
var dataTable = new google.visualization.DataTable();
 
var x=new Array();
 
for(s=0;s<number;s++){
x[s]=new Array();    
}
 
 
for(s=1;s<number+1;s++){
x[s-1][0]=n[s];
x[s-1][1]=new Date(ys1[s], ms1[s], 5);
x[s-1][2]=new Date(ys2[s], ms2[s], 25);
}
 
 
 
 
        dataTable.addColumn({ type: 'string', id: '番組' });
        dataTable.addColumn({ type: 'date', id: 'Start' });
        dataTable.addColumn({ type: 'date', id: 'End' });
        dataTable.addRows(x);
 
        chart.draw(dataTable);
 
 
}
 
function sample() {
 
        var query = "SELECT * FROM " +
            '1ZcNyzho5K2N6ke1C6lmxRukX-FhA4REoNHWvk6Rf';
        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];
m1[sx] = rows[i][2];
y2[sx] = rows[i][3];
m2[sx] = rows[i][4];
week[sx] = rows[i][5];
code[sx] = rows[i][6];
namex[sx] = rows[i][7];
}
 
number=sx;
 
sx=0; 
for(s=1;s<number+1;s++){
h=0;
if(week[s]=="木")h=h+1;
if(e8(code[s])>50)h=h+1;
if(h==2)sx=sx+1;
if(h==2)n[sx]=namex[s];
if(h==2)ys1[sx]=y1[s];
if(h==2)ys2[sx]=y2[s];
if(h==2)ms1[sx]=m1[s];
if(h==2)ms2[sx]=m2[s];
}
 
 
number=sx;
 
google.charts.load('current', {'packages':['timeline']});
google.charts.setOnLoadCallback(play);
 
 
            }
 
 
        });
 
}
 
 
 
 
function e8(ee){
  z=0;
   if(ee==728)z=100;
  if(ee==8)z=100;
  if(ee==89)z=100;
 if(ee==78)z=100;
  if(ee==789)z=100;
  return z;
 
}
 
 
 
function e9(ee){
  z=0;
  if(ee==9)z=100;
  if(ee==89)z=100;
 if(ee==910)z=100;
  if(ee==9101)z=100;
   if(ee==789)z=100;
  return z;
 
}
 
function e10(ee){
  z=0;
 
  if(ee==10)z=100;
 if(ee==910)z=100;
  if(ee==103)z=100;
   if(ee==10111)z=100;
  if(ee==1011)z=100;
  return z;
 
}
 
function e101(ee){
  z=0;
   if(ee==101)z=100;
  if(ee==10)z=100;
 if(ee==910)z=100;
   if(ee==9101)z=100; 
  if(ee==1011)z=100;
  return z;
 
}
 
function e102(ee){
  z=0;
  if(ee==10)z=100;
 if(ee==910)z=100;
  if(ee==102)z=100;
  if(ee==10211)z=100;
   if(ee==1011)z=100;
  return z;
 
}
 
 
function e72(ee){
  z=0;
 if(ee==72)z=100;
 if(ee==7)z=100;
  if(ee==627)z=100;
  if(ee==67)z=100;
   if(ee==728)z=100;
   if(ee==78)z=100;
  return z;
 
}
 
 
function e71(ee){
  z=0;
 if(ee==671)z=100;
 if(ee==67)z=100;
 if(ee==627)z=100;
 if(ee==6271)z=100;
 if(ee==71)z=100;
 if(ee==7)z=100;
   if(ee==78)z=100;
 return z;
 
}