style>
/* Table */
table {
  background-color: white;
  border-collapse:collapse;
  font-family: sans-serif;
  text-align: center;
  margin-bottom: 2000px;
}

/* all table data styling */
tr.data td { padding: 10px 20px 10px 20px; text-align: center; }

/* color for every odd and even row */
tr.data:nth-child(odd)  { background-color:#E6E7E8; }
tr.data:nth-child(even) { background-color:white;   }

/* left spacer for table */
tr.data td.spacer { padding-left: 32px; background-color: white}

/* heading 0 */
tr.heading_0 td {
  color: #2B353E;
  font-size: 32pt;
  padding: 0px 0px 4px 0px;  
}

/* all heading 0 except first one should have this padding */
tr.heading_0  ~ tr.heading_0 td { padding-top: 40px;}

/* heading 1 */
tr.heading_1 td {
  color: #2B353E; 
  font-size: 20pt;
  padding: 20px 0px 4px 32px;  
}

/* first heading 1 under a heading 0 needs less top padding */
tr.heading_0 + tr.heading_1 td {
  padding-top: 4px;
}

/* Column Headers */
th.column_header {
  background-color: #2B353E;
  color: white;
  font-size: 20px;
  font-weight:normal;
  padding: 10px 20px 10px 20px;
  border-top: solid #00A69C 6px;
  text-align: center;
}

.filter {
  font-size: 20pt;
  font-family: sans-serif;
  text-align: left;
  margin-left: 55px;
  margin-bottom: 20px;
}

select {
  font-size: 20pt;
  font-family: sans-serif;
  text-align: center;    
}

/* Special Rules for Portrait Mode */
@media only screen and (max-width: 650px) {
  .filter { margin-left: 0px; font-size: 14pt;}
  select { font-size: 14pt; }
  tr.data td { padding-left: 0px; padding-right: 0px; }
  tr.data td.spacer { padding-left: 0px; padding-right: 0px; }
  tr.heading_0 td { font-size: 24pt; }
  tr.heading_1 td { padding-left: 0px; padding-right: 0px; font-size: 16pt; }
  th.column_header { padding-left: 0px; padding-right: 0px; font-size: 16px; }
}

</style>

<div class=filter>
  <label for="division">Select Date:</label>
  <select id="select_filter" onchange="generate_table('Schedule', $('#mytable > tbody:last-child'));">
  </select>
  <hr>
</div>

<table id=mytable>
  <tr></tr>
</table>

<script src='https://ajax.googleapis.com/ajax/libs/jquery/2.1.0/jquery.min.js'></script>
<script src='https://unpkg.com/papaparse@latest/papaparse.min.js'></script>

<script>
// Constants
const SHEET_URL = "https://spreadsheets.google.com/spreadsheets/d/1_F14SWAqo46aA76H2mrrbiUxM3a_2lVP2SMIvX9bl6k/gviz/tq?tqx=out:csv";
const COL_SEASON = 0;

function generate_table(table_type, tbody) {
	// select the filter and clear the table
  filter = $('#select_filter option:selected').text();
  tbody.empty();

	// fetch the data from the spreadsheet in CSV format
  url = SHEET_URL + "&sheet=" + table_type; 

  Papa.parse(url, {download: true, header: false, complete: function(results) {
  	// get the columns
    columns = results.data[0];
    
    // loop through all the rows of data
    needs_th = false;
		for (let i = 1 ; i < results.data.length; i++) {

			// filter
      if (!results.data[i][0].endsWith(filter)) {
      	continue;
      }

    	// loop through each column in this row to add common headers
    	for (let j  = 0; j < columns.length; j++) {
      	// check if we need to add a new section header
      	if ((columns[j].startsWith('*')) && (needs_th || (results.data[i - 1][j] != results.data[i][j]))) {
          	tbody.append($(`<tr class='heading_${j} heading_${columns[j].replace('*', '')}'><td colspan=${columns.length+1}>${results.data[i][j]}</td></tr>`));
    				needs_th = true;
        }
      }

      // loop through and add the column headers
      if (needs_th) {
        tbody.append($('<tr><th class="spacer"></th></tr>'));
        for (let j  = 0; j < columns.length; j++)
          if (!columns[j].startsWith('*')) $('tbody tr:last-child').append($(`<th class=column_header>${columns[j]}</th>`));
        needs_th = false;
      }

    	// loop through each column in this row to add data
      tbody.append($('<tr class=data><td class="data spacer"></td></tr>'));
    	for (let j  = 0; j < columns.length; j++)
      	if (!columns[j].startsWith('*')) $('tbody tr:last-child').append($(`<td>${results.data[i][j]}</td>`));
    }
    
   }});
}

function generate_filter(table_type, select_filter) {
  // fetch the data from the spreadsheet in CSV format
  url = SHEET_URL + "&sheet=" + table_type; 
  Papa.parse(url, {download: true, header: false, complete: function(results) {
    var filters = new Set();
    for (let i = 1 ; i < results.data.length; i++) {
    	filters.add(results.data[i][0]);
    }  

    // clear the select filter
    select_filter.find('option').remove()    

    // add new filters
    filters = Array.from(filters);
    for (let i = 0 ; i < filters.length; i++) {
      select_filter.append('<option value="' + i + '">' + filters[i] + '</option>');
    }

    setTimeout(function(){
      $('#select_filter option[value="0"]').attr('selected','selected');
      generate_table('Schedule', $('#mytable > tbody:last-child'));
    },500);


  }});

}

generate_filter('Schedule', $('#select_filter'));
//generate_table('Schedule', $('#mytable > tbody:last-child'));

</script>