From 9eae964affb6ca3e3dec8ba80122b90a1c267a2d Mon Sep 17 00:00:00 2001
From: Arda Serdar Pektezol <1669855+pektezol@users.noreply.github.com>
Date: Sun, 15 Jan 2023 03:28:41 +0300
Subject: added fetch map stats (#25)

---
 backend/controllers/mapController.go | 79 ++++++++++++++++++++++++++++++++++++
 backend/models/models.go             | 32 ++++++++++++++-
 backend/routes/routes.go             |  1 +
 3 files changed, 110 insertions(+), 2 deletions(-)
 create mode 100644 backend/controllers/mapController.go

diff --git a/backend/controllers/mapController.go b/backend/controllers/mapController.go
new file mode 100644
index 0000000..c26d1ad
--- /dev/null
+++ b/backend/controllers/mapController.go
@@ -0,0 +1,79 @@
+package controllers
+
+import (
+	"net/http"
+	"strconv"
+
+	"github.com/gin-gonic/gin"
+	"github.com/pektezol/leastportals/backend/database"
+	"github.com/pektezol/leastportals/backend/models"
+)
+
+func FetchMap(c *gin.Context) {
+	id := c.Param("id")
+	// Get map data
+	var mapData models.Map
+	var isDisabled bool
+	intID, err := strconv.Atoi(id)
+	if err != nil {
+		c.JSON(http.StatusBadRequest, models.ErrorResponse(err.Error()))
+		return
+	}
+	mapData.ID = intID
+	sql := `SELECT map_name, wr_score, wr_time, is_coop, is_disabled FROM maps WHERE id = $1;`
+	err = database.DB.QueryRow(sql, id).Scan(&mapData.Name, &mapData.ScoreWR, &mapData.TimeWR, &mapData.IsCoop, &isDisabled)
+	if err != nil {
+		c.JSON(http.StatusBadRequest, models.ErrorResponse(err.Error()))
+		return
+	}
+	if isDisabled {
+		c.JSON(http.StatusBadRequest, models.ErrorResponse("Map is not available for competitive boards."))
+		return
+	}
+	// Get records from the map
+	if mapData.IsCoop {
+		var records []models.RecordMP
+		sql = `SELECT id, host_id, partner_id, score_count, score_time, host_demo_id, partner_demo_id, record_date
+		FROM records_mp WHERE map_id = $1;`
+		rows, err := database.DB.Query(sql, id)
+		if err != nil {
+			c.JSON(http.StatusBadRequest, models.ErrorResponse(err.Error()))
+			return
+		}
+		for rows.Next() {
+			var record models.RecordMP
+			err := rows.Scan(&record.RecordID, &record.HostID, &record.PartnerID, &record.ScoreCount, &record.ScoreTime, &record.HostDemoID, &record.PartnerDemoID, &record.RecordDate)
+			if err != nil {
+				c.JSON(http.StatusBadRequest, models.ErrorResponse(err.Error()))
+				return
+			}
+			records = append(records, record)
+		}
+		mapData.Records = records
+	} else {
+		var records []models.RecordSP
+		sql = `SELECT id, user_id, score_count, score_time, demo_id, record_date
+		FROM records_sp WHERE map_id = $1;`
+		rows, err := database.DB.Query(sql, id)
+		if err != nil {
+			c.JSON(http.StatusBadRequest, models.ErrorResponse(err.Error()))
+			return
+		}
+		for rows.Next() {
+			var record models.RecordSP
+			err := rows.Scan(&record.RecordID, &record.UserID, &record.ScoreCount, &record.ScoreTime, &record.DemoID, &record.RecordDate)
+			if err != nil {
+				c.JSON(http.StatusBadRequest, models.ErrorResponse(err.Error()))
+				return
+			}
+			records = append(records, record)
+		}
+		mapData.Records = records
+	}
+	// Return response
+	c.JSON(http.StatusOK, models.Response{
+		Success: true,
+		Message: "Successfully retrieved map data.",
+		Data:    mapData,
+	})
+}
diff --git a/backend/models/models.go b/backend/models/models.go
index 8f4a5e5..7de5812 100644
--- a/backend/models/models.go
+++ b/backend/models/models.go
@@ -13,10 +13,38 @@ type User struct {
 	UpdatedAt   time.Time `json:"updated_at"`
 }
 
-type Record struct {
+type Map struct {
+	ID      int    `json:"id"`
+	Name    string `json:"name"`
+	ScoreWR int    `json:"wr_score"`
+	TimeWR  int    `json:"wr_time"`
+	IsCoop  bool   `json:"is_coop"`
+	Records any    `json:"records"`
+}
+
+type RecordSP struct {
+	RecordID   int       `json:"record_id"`
+	UserID     string    `json:"user_id"`
+	ScoreCount int       `json:"score_count"`
+	ScoreTime  int       `json:"score_time"`
+	DemoID     string    `json:"demo_id"`
+	RecordDate time.Time `json:"record_date"`
+}
+
+type RecordMP struct {
+	RecordID      int       `json:"record_id"`
+	HostID        string    `json:"host_id"`
+	PartnerID     string    `json:"partner_id"`
+	ScoreCount    int       `json:"score_count"`
+	ScoreTime     int       `json:"score_time"`
+	HostDemoID    string    `json:"host_demo_id"`
+	PartnerDemoID string    `json:"partner_demo_id"`
+	RecordDate    time.Time `json:"record_date"`
+}
+
+type RecordRequest struct {
 	ScoreCount      int    `json:"score_count" form:"score_count" binding:"required"`
 	ScoreTime       int    `json:"score_time" form:"score_time" binding:"required"`
 	PartnerID       string `json:"partner_id" form:"partner_id" binding:"required"`
 	IsPartnerOrange bool   `json:"is_partner_orange" form:"is_partner_orange" binding:"required"`
-	//Demos           []*multipart.FileHeader `form:"demos[]" binding:"required"`
 }
diff --git a/backend/routes/routes.go b/backend/routes/routes.go
index 43dfd65..b872b77 100644
--- a/backend/routes/routes.go
+++ b/backend/routes/routes.go
@@ -19,6 +19,7 @@ func InitRoutes(router *gin.Engine) {
 		v1.PUT("/profile", middleware.CheckAuth, controllers.UpdateCountryCode)
 		v1.GET("/user/:id", middleware.CheckAuth, controllers.FetchUser)
 		v1.GET("/demo", controllers.DownloadDemoWithID)
+		v1.GET("/maps/:id", middleware.CheckAuth, controllers.FetchMap)
 		v1.POST("/maps/:id/record", middleware.CheckAuth, controllers.CreateRecordWithDemo)
 	}
 }
-- 
cgit v1.2.3