From d69a601251ce3a3e785cf9a32233b7d7dd94fea5 Mon Sep 17 00:00:00 2001
From: Arda Serdar Pektezol <1669855+pektezol@users.noreply.github.com>
Date: Mon, 18 Sep 2023 12:03:30 +0300
Subject: feat: pagination for map leaderboards

Former-commit-id: 0a38362eadcf1c1ecf5ae29d5a58a015abfd54ee
---
 backend/handlers/map.go  | 63 ++++++++++++++++++++++++++++++++++++++----------
 backend/models/models.go |  7 ++++++
 2 files changed, 57 insertions(+), 13 deletions(-)

diff --git a/backend/handlers/map.go b/backend/handlers/map.go
index 1d9cee8..b3de2e8 100644
--- a/backend/handlers/map.go
+++ b/backend/handlers/map.go
@@ -16,8 +16,9 @@ type MapSummaryResponse struct {
 }
 
 type MapLeaderboardsResponse struct {
-	Map     models.Map `json:"map"`
-	Records any        `json:"records"`
+	Map        models.Map        `json:"map"`
+	Records    any               `json:"records"`
+	Pagination models.Pagination `json:"pagination"`
 }
 
 type ChaptersResponse struct {
@@ -115,17 +116,24 @@ func FetchMapSummary(c *gin.Context) {
 //	@Description	Get map leaderboards with specified id.
 //	@Tags			maps
 //	@Produce		json
-//	@Param			id	path		int	true	"Map ID"
-//	@Success		200	{object}	models.Response{data=MapLeaderboardsResponse}
-//	@Failure		400	{object}	models.Response
+//	@Param			id			path		int	true	"Map ID"
+//	@Param			page		query		int	false	"Page Number (default: 1)"
+//	@Param			pageSize	query		int	false	"Number of Records Per Page (default: 10)"
+//	@Success		200			{object}	models.Response{data=MapLeaderboardsResponse}
+//	@Failure		400			{object}	models.Response
 //	@Router			/maps/{id}/leaderboards [get]
 func FetchMapLeaderboards(c *gin.Context) {
-	// TODO: make new response type
 	id := c.Param("id")
 	// Get map data
-	response := MapLeaderboardsResponse{Map: models.Map{}, Records: nil}
-	// var mapData models.Map
-	// var mapRecordsData models.MapRecords
+	response := MapLeaderboardsResponse{Map: models.Map{}, Records: nil, Pagination: models.Pagination{}}
+	page, err := strconv.Atoi(c.DefaultQuery("page", "1"))
+	if err != nil || page < 1 {
+		page = 1
+	}
+	pageSize, err := strconv.Atoi(c.DefaultQuery("pageSize", "10"))
+	if err != nil || pageSize < 1 {
+		pageSize = 10
+	}
 	var isDisabled bool
 	intID, err := strconv.Atoi(id)
 	if err != nil {
@@ -147,7 +155,8 @@ func FetchMapLeaderboards(c *gin.Context) {
 		c.JSON(http.StatusBadRequest, models.ErrorResponse("Map is not available for competitive boards."))
 		return
 	}
-	// TODO: avatar and names for host & partner
+	totalRecords := 0
+	totalPages := 0
 	if response.Map.GameName == "Portal 2 - Cooperative" {
 		records := []RecordMultiplayer{}
 		sql = `SELECT
@@ -179,7 +188,7 @@ func FetchMapLeaderboards(c *gin.Context) {
 	) sub
 	JOIN users AS host ON sub.host_id = host.steam_id 
 	JOIN users AS partner ON sub.partner_id = partner.steam_id 
-	WHERE sub.rn = 1;`
+	WHERE sub.rn = 1`
 		rows, err := database.DB.Query(sql, id)
 		if err != nil {
 			c.JSON(http.StatusBadRequest, models.ErrorResponse(err.Error()))
@@ -203,7 +212,18 @@ func FetchMapLeaderboards(c *gin.Context) {
 			records = append(records, record)
 			placement++
 		}
-		response.Records = records
+		totalRecords = len(records)
+		totalPages = (totalRecords + pageSize - 1) / pageSize
+		if page > totalPages {
+			c.JSON(http.StatusBadRequest, models.ErrorResponse("Invalid page number."))
+			return
+		}
+		startIndex := (page - 1) * pageSize
+		endIndex := startIndex + pageSize
+		if endIndex > totalRecords {
+			endIndex = totalRecords
+		}
+		response.Records = records[startIndex:endIndex]
 	} else {
 		records := []RecordSingleplayer{}
 		sql = `SELECT id, user_id, users.user_name, users.avatar_link, score_count, score_time, demo_id, record_date
@@ -238,7 +258,24 @@ func FetchMapLeaderboards(c *gin.Context) {
 			records = append(records, record)
 			placement++
 		}
-		response.Records = records
+		totalRecords = len(records)
+		totalPages = (totalRecords + pageSize - 1) / pageSize
+		if page > totalPages {
+			c.JSON(http.StatusBadRequest, models.ErrorResponse("Invalid page number."))
+			return
+		}
+		startIndex := (page - 1) * pageSize
+		endIndex := startIndex + pageSize
+		if endIndex > totalRecords {
+			endIndex = totalRecords
+		}
+		response.Records = records[startIndex:endIndex]
+	}
+	response.Pagination = models.Pagination{
+		TotalRecords: totalRecords,
+		TotalPages:   totalPages,
+		CurrentPage:  page,
+		PageSize:     pageSize,
 	}
 	c.JSON(http.StatusOK, models.Response{
 		Success: true,
diff --git a/backend/models/models.go b/backend/models/models.go
index 2d54295..35929c1 100644
--- a/backend/models/models.go
+++ b/backend/models/models.go
@@ -109,6 +109,13 @@ type Links struct {
 	Twitch  string `json:"twitch"`
 }
 
+type Pagination struct {
+	TotalRecords int `json:"total_records"`
+	TotalPages   int `json:"total_pages"`
+	CurrentPage  int `json:"current_page"`
+	PageSize     int `json:"page_size"`
+}
+
 type PlayerSummaries struct {
 	SteamId                  string `json:"steamid"`
 	CommunityVisibilityState int    `json:"communityvisibilitystate"`
-- 
cgit v1.2.3