X-Git-Url: https://git.sesse.net/?a=blobdiff_plain;f=update_sheets.js;h=f96b223a83054a4b732369c1cac52ed0f90c07dd;hb=62acd54d7e0d27c056de5e7a106be803c3dc2f4e;hp=aa4daa6a8559dbeeeed674da59352fa3ea910826;hpb=b0d7dd6f2006053313c3ef1f7fee4ccb14b14200;p=ultimatescore

diff --git a/update_sheets.js b/update_sheets.js
index aa4daa6..f96b223 100644
--- a/update_sheets.js
+++ b/update_sheets.js
@@ -74,6 +74,7 @@ function publish_group_rank(response, group_name)
 	let teams = parse_teams_from_spreadsheet(response);
 	let games = parse_games_from_spreadsheet(response, group_name, false);
 	apply_games_to_teams(games, teams);
+	teams = filter_teams(teams, response);
 
 	// Write the points total to the unsorted columns.
 	if (config['point_total_start_row'] !== null) {
@@ -98,7 +99,7 @@ function publish_group_rank(response, group_name)
 	if (tiebreakers.length != 0) {
 		tb_str = tiebreakers.join("\n");
 	}
-	updates.push({ "range": cols[0] + config['ranking_list_explain_row'], "values": [ [ tb_str ] ]});
+	updates.push({ "range": config['ranking_list_explain_cell'], "values": [ [ tb_str ] ]});
 
 	let json = {
 		"valueInputOption": "USER_ENTERED",
@@ -300,6 +301,10 @@ function fill_playoff(replacements, teams) {
 			let score2 = response['values'][row - 1][cols[2]];
 			let game_name = game[4];
 			let game_name2 = game_name.replace("Semi", "semi");
+			let game_day = game[7];
+			if (game_day === undefined) {
+				game_day = 7;  // Sunday.
+			}
 
 			let range = {
 				"sheetId": ultimateconfig['score_sheet_index'],
@@ -335,7 +340,7 @@ function fill_playoff(replacements, teams) {
 				// Game.
 				updates.push({
 					"range": "Playoffs!A" + (game_num + 32) + ":J" + (game_num + 32),
-					"values": [ [ team1, team2, score1, score2, "", "", "", 7, response['values'][row - 1][1].replace(".",":"), game[6] ] ]
+					"values": [ [ team1, team2, score1, score2, "", "", "", game_day, response['values'][row - 1][1].replace(".",":"), game[6] ] ]
 				});
 
 				// Team codes.
@@ -359,7 +364,9 @@ function fill_playoff(replacements, teams) {
 			"requests": meta_updates
 		};
 		possibly_update_oauth_key(function() {
-			post_json('https://sheets.googleapis.com/v4/spreadsheets/' + ultimateconfig['score_sheet_id'] + '/values:batchUpdate?key=' + ultimateconfig['api_key'], json, function(response) {}, current_oauth_access_token);
+			post_json('https://sheets.googleapis.com/v4/spreadsheets/' + ultimateconfig['score_sheet_id'] + '/values:batchUpdate?key=' + ultimateconfig['api_key'], json, function(response) {
+				get_group('Playoffs 9th-13th', function(response_l) { publish_group_rank(response_l, 'Playoffs 9th-13th'); });
+			}, current_oauth_access_token);
 			post_json('https://sheets.googleapis.com/v4/spreadsheets/' + ultimateconfig['score_sheet_id'] + ':batchUpdate?key=' + ultimateconfig['api_key'], meta_json, function(response) {}, current_oauth_access_token);
 		});
 	});
@@ -397,6 +404,7 @@ function get_ranked(response, group_name) {
 	let teams = parse_teams_from_spreadsheet(response);
 	let games = parse_games_from_spreadsheet(response, group_name, false);
 	apply_games_to_teams(games, teams);
+	teams = filter_teams(teams, response);
 	let tiebreakers = [];
 	teams = rank(games, teams, 1, tiebreakers);
 	return teams;