X-Git-Url: https://git.sesse.net/?a=blobdiff_plain;f=update_sheets.js;h=7776425146c700e58de0e2d61a32c977a2ebdddd;hb=0830813a9a0a59443b1a068e217bf9524f82052e;hp=aa4daa6a8559dbeeeed674da59352fa3ea910826;hpb=b0d7dd6f2006053313c3ef1f7fee4ccb14b14200;p=ultimatescore diff --git a/update_sheets.js b/update_sheets.js index aa4daa6..7776425 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) { @@ -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;