added fetch map stats (#25)

3 files changed, 110 insertions, 2 deletions

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)
         }
 }