From a6c8e710af51be01bc8e40fd9a0a294678837a8e Mon Sep 17 00:00:00 2001
From: Tor Andersson <tor@ccxvii.net>
Date: Sat, 1 Oct 2022 17:52:47 +0200
Subject: Add menu to jump to the next active game.

---
 public/common/play.js |  7 ++++++-
 server.js             | 28 ++++++++++++++++++++++++++--
 2 files changed, 32 insertions(+), 3 deletions(-)

diff --git a/public/common/play.js b/public/common/play.js
index ba59d6f..2fe3e2e 100644
--- a/public/common/play.js
+++ b/public/common/play.js
@@ -1011,4 +1011,9 @@ function add_main_menu_item(text, onclick) {
 }
 
 init_main_menu()
-add_main_menu_item("Go Home", () => window.open("/games/active", "_self"))
+if (params.role !== "Observer") {
+	add_main_menu_item("Go home", () => window.open("/games/active", "_self"))
+	add_main_menu_item("Go to next game", () => window.open("/games/next", "_self"))
+} else {
+	add_main_menu_item("Go home", () => window.open("/", "_self"))
+}
diff --git a/server.js b/server.js
index f99dd43..e0d1b13 100644
--- a/server.js
+++ b/server.js
@@ -1052,17 +1052,30 @@ const QUERY_LIST_PUBLIC_GAMES = SQL(`
 	SELECT * FROM game_view
 	WHERE is_private=0 AND status < 2
 	AND EXISTS ( SELECT 1 FROM players WHERE players.game_id = game_view.game_id )
-	ORDER BY mtime DESC
+	ORDER BY mtime DESC, ctime DESC
 	`)
 
 const QUERY_LIST_GAMES_OF_TITLE = SQL(`
 	SELECT * FROM game_view
 	WHERE is_private=0 AND title_id=? AND status>=? AND status<=?
 	AND EXISTS ( SELECT 1 FROM players WHERE players.game_id = game_view.game_id )
-	ORDER BY mtime DESC
+	ORDER BY mtime DESC, ctime DESC
 	LIMIT ?
 	`)
 
+const QUERY_NEXT_GAME_OF_USER = SQL(`
+	select title_id, game_id, role
+	from games
+	join game_state using(game_id)
+	join players using(game_id)
+	where
+		status = 1
+		and active in ('All', 'Both', role)
+		and user_id = ?
+	order by mtime
+	limit 1
+	`)
+
 const QUERY_LIST_ACTIVE_GAMES_OF_USER = SQL(`
 	select * from game_view
 	where
@@ -1189,6 +1202,15 @@ function sort_your_turn(a, b) {
 	return 0
 }
 
+app.get('/games/next', must_be_logged_in, function (req, res) {
+	let next = QUERY_NEXT_GAME_OF_USER.get(req.user.user_id)
+	console.log("NEXT", next)
+	if (next !== undefined)
+		res.redirect(`/${next.title_id}/play:${next.game_id}:${next.role}`)
+	else
+		res.redirect(`/games/active`)
+})
+
 app.get('/games/active', must_be_logged_in, function (req, res) {
 	let games = QUERY_LIST_ACTIVE_GAMES_OF_USER.all({ user_id: req.user.user_id })
 	annotate_games(games, req.user.user_id)
@@ -1617,6 +1639,7 @@ const MAIL_FOOTER = "\n--\nYou can unsubscribe from notifications on your profil
 const SQL_SELECT_NOTIFIED = SQL("SELECT datetime('now') < datetime(time,?) FROM last_notified WHERE game_id=? AND user_id=?").pluck()
 const SQL_INSERT_NOTIFIED = SQL("INSERT OR REPLACE INTO last_notified (game_id,user_id,time) VALUES (?,?,datetime('now'))")
 const SQL_DELETE_NOTIFIED = SQL("DELETE FROM last_notified WHERE game_id=? AND user_id=?")
+const SQL_DELETE_NOTIFIED_ALL = SQL("DELETE FROM last_notified WHERE game_id=?")
 
 const QUERY_LIST_YOUR_TURN = SQL("SELECT * FROM your_turn_reminder")
 
@@ -1846,6 +1869,7 @@ function get_game_state(game_id) {
 function put_game_state(game_id, state, old_active) {
 	if (state.state === 'game_over') {
 		SQL_UPDATE_GAME_RESULT.run(2, state.result, game_id)
+		SQL_DELETE_NOTIFIED_ALL.run(game_id)
 		mail_game_over_notification_to_offline_users(game_id, state.result, state.victory)
 	}
 	SQL_UPDATE_GAME_STATE.run(game_id, JSON.stringify(state), state.active)
-- 
cgit v1.2.3