X-Git-Url: https://git.sesse.net/?a=blobdiff_plain;f=update_sheets.js;h=7867141460371be0a862db61f4b9f5061206a5cc;hb=eb8362399621b3c50e380f941c71b3a5bc108db9;hp=7cfe0fda6cc320bfdc2532e58a1d7d766aa5ccec;hpb=74ac454c782401f07e3c26353073a4645c8b825a;p=ultimatescore

diff --git a/update_sheets.js b/update_sheets.js
index 7cfe0fd..7867141 100644
--- a/update_sheets.js
+++ b/update_sheets.js
@@ -69,10 +69,7 @@ function publish_group_rank(group_name)
 {
 	get_group(group_name, function(response, group_name) {
 		let updates = [];
-		let cols = ["Results!M", "Results!N", "Results!O"];
-		if (group_name === 'Group B') {
-			cols = ["Results!Q", "Results!R", "Results!S"];
-		}
+		let cols = ultimateconfig['score_sheet_cols'][group_name];
 
 		let teams = parse_teams_from_spreadsheet(response);
 		let games = parse_games_from_spreadsheet(response, group_name, false);
@@ -80,7 +77,8 @@ function publish_group_rank(group_name)
 
 		// Write the points total to the unsorted columns.
 		for (let i = 0; i < teams.length; ++i) {
-			updates.push({ "range": cols[2] + (10 + i), "values": [ [ teams[i].pts ] ] });
+			let row = ultimateconfig['point_total_start_row'] + i;
+			updates.push({ "range": cols[2] + row, "values": [ [ teams[i].pts ] ] });
 		}
 
 		let tiebreakers = [];
@@ -88,23 +86,24 @@ function publish_group_rank(group_name)
 
 		// Write the ranking table, from scratch.
 		for (let i = 0; i < teams.length; ++i) {
-			updates.push({ "range": cols[0] + (19 + i), "values": [ [ teams[i].rank ] ] });
-			updates.push({ "range": cols[1] + (19 + i), "values": [ [ teams[i].shortname ] ] });
-			updates.push({ "range": cols[2] + (19 + i), "values": [ [ teams[i].pts ] ] });
+			let row = ultimateconfig['ranking_list_start_row'] + i;
+			updates.push({ "range": cols[0] + row, "values": [ [ teams[i].rank ] ] });
+			updates.push({ "range": cols[1] + row, "values": [ [ teams[i].mediumname ] ] });
+			updates.push({ "range": cols[2] + row, "values": [ [ teams[i].pts ] ] });
 		}
 
 		let tb_str = "";
 		if (tiebreakers.length != 0) {
 			tb_str = tiebreakers.join("\n");
 		}
-		updates.push({ "range": cols[0] + "25", "values": [ [ tb_str ] ]});
+		updates.push({ "range": cols[0] + ultimateconfig['ranking_list_explain_row'], "values": [ [ tb_str ] ]});
 
 		let json = {
 			"valueInputOption": "USER_ENTERED",
 			"data": updates 
 		};
 		possibly_update_oauth_key(function() {
-			post_json('https://sheets.googleapis.com/v4/spreadsheets/1ygfeR6njBUmLyuLRq7zfYW5slMWBGnj4XxzQQ4WJklU/values:batchUpdate?key=AIzaSyAuP9yQn8g0bSay6r_RpGtpFeIbwprH1TU', 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) {}, current_oauth_access_token);
 		});
 
 	});