Invisible Hand 2

Crowd Sponsored Results (CSR) for liberty literature.

HTML

<script src="https://www.google.com/jsapi?dummy=.js"></script>
<script src="https://www.google.com/jsapi"></script>
<input type="text" id="txtFilter"><button type="button" onclick="drawSheetName();">Filter</button><select id="selectBox" onchange="drawSheetName();">   <option value="All">All Time</option>   <option value="week">Past Week</option>   <option value="month">Past Month</option>   <option value="year">Past Year</option><option value="decade">Past Decade</option><option value="century">Past Century</option></select><span id="myDiv2"></span>
<div id="myDiv3">
</div>
<div id="myDiv1">
</div>

JavaScript

google.load("visualization", "1", {
  packages: ["corechart"]
});
google.setOnLoadCallback(drawSheetName);

function drawSheetName() {
  var myFilter = document.getElementById("txtFilter").value;
  myFilter = myFilter.toUpperCase()
  var selectBox = document.getElementById("selectBox");
  var selectedValue = selectBox.options[selectBox.selectedIndex].value;
  var d = new Date();
  switch (selectedValue) {
    case "week":
      d.setDate(d.getDate() - 7);
      break;
    case "month":
      d.setDate(d.getDate() - 30);
      break;
    case "year":
      d.setDate(d.getDate() - 365);
      break;
    case "decade":
      d.setDate(d.getDate() - 3650);
      break;
    case "century":
      d.setDate(d.getDate() - 36500);
      break;
  }
  myyear = d.getFullYear();
  mymonth = d.getMonth() + 1;
  myday = d.getDate();
  mycowdate = myyear + '-' + mymonth + '-' + myday;
  myQuery = 'SELECT A, B, C, D'
  if (selectedValue != 'All') {
    myQuery = myQuery + " WHERE E > date '" + mycowdate + "'";
  }
  if (myFilter) {
    if (selectedValue == 'All') {
       myQuery = myQuery + " WHERE";
    } else { 
       myQuery = myQuery + " AND";
    }
    var farray = new Array();
    farray = myFilter.split(' ');
    for (j=0;j<farray.length;j++) {  
        
       myQuery = myQuery + " (upper(B) Like '%" + farray[j] + "%'";
       myQuery = myQuery + " OR upper(C) Like '%" + farray[j] + "%'";
       myQuery = myQuery + " OR upper(D) Like '%" + farray[j] + "%')";
        
       if (j != farray.length - 1) {
            myQuery = myQuery + " AND";
       }
    }
  }
  myQuery = myQuery + " Order by A desc";
  var queryString = encodeURIComponent(myQuery);
  var magicIncantation = '/gviz/tq?gid=0&headers=1&tq=';
  var myURL = 'https://docs.google.com/spreadsheets/d/1erZhZkBfrnBFTYEPFacZpaaHsrnDodYj-WPSmQWlSck';
  var myFullURL = myURL + magicIncantation + queryString;
  //document.getElementById("myDiv1").innerHTML = myFullURL;
  var query = new...