1 files changed, 79 insertions, 0 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,
+        })
+}