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 ++++++++++++++++++++++++++++++++++++
 1 file changed, 79 insertions(+)
 create mode 100644 backend/controllers/mapController.go

(limited to '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,
+	})
+}
-- 
cgit v1.2.3