OTP CSR

Crowd determined value of OTP threads

HTML

<script src="https://www.google.com/jsapi?dummy=.js"></script>
<script src="https://www.google.com/jsapi"></script>
<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>
</select>
<table id="myTable">
</table>
<div id="myDiv2"></div>
<div id="myDiv3"></div>
<div id="myDiv1"></div>

JavaScript

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

function drawSheetName() {
  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;
  }
  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 + "'";
  }
  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/1DZaIQErSqiBup1-33eAtqhr21OZ6iump52Dj5eMHRpY';
  var myFullURL = myURL + magicIncantation + queryString;
  //document.getElementById("myDiv1").innerHTML = myFullURL;
  var query = new google.visualization.Query(myFullURL);
  query.send(handleSampleDataQueryResponse);
}

function handleSampleDataQueryResponse(response) {
  if (response.isError()) {
    alert('Error in query: ' + response.getMessage() + ' ' + response.getDetailedMessage());
    return;
  }

  var data = response.getDataTable();
  var num_rows = data.getNumberOfRows();
  var myTable = document.getElementById("myTable");
  document.getElementById("myDiv2").innerHTML = 'Results:' + num_rows;
  for (var i = 0; i < num_rows; i++) {
  	if(i==0){
    	document.getElementById("myDiv3").innerHTML = "";
    }
    var myValue = data.getValue(i, 0);
    myValue = '$' + myValue.toFixed(2);
    var myTitle = data.getValue(i, 1);
    var myURL = data.getValue(i, 2);
    var myLink = "<a href='" + myURL + "'>" + myTitle + "</a>"
    var myUser =...