From f9ebd85d20cfa794468f9b07b4b781bcd6b686ab Mon Sep 17 00:00:00 2001
From: Arda Serdar Pektezol <1669855+pektezol@users.noreply.github.com>
Date: Thu, 29 Jun 2023 19:34:25 +0300
Subject: feat: delete map summary

Former-commit-id: bd5bc84fc142f44bfa3c1c1ddc35e435a3f816bf
---
 backend/controllers/modController.go | 91 +++++++++++++++++++++++++++++++++++-
 backend/models/requests.go           |  4 ++
 2 files changed, 94 insertions(+), 1 deletion(-)

(limited to 'backend')

diff --git a/backend/controllers/modController.go b/backend/controllers/modController.go
index 75be112..9398b2c 100644
--- a/backend/controllers/modController.go
+++ b/backend/controllers/modController.go
@@ -89,7 +89,7 @@ func CreateMapSummary(c *gin.Context) {
 	// Return response
 	c.JSON(http.StatusOK, models.Response{
 		Success: true,
-		Message: "Successfully updated map summary.",
+		Message: "Successfully created map summary.",
 		Data:    request,
 	})
 }
@@ -175,3 +175,92 @@ func EditMapSummary(c *gin.Context) {
 		Data:    request,
 	})
 }
+
+// DELETE Map Summary
+//
+//	@Summary	Delete map summary with specified map id.
+//	@Tags		maps
+//	@Produce	json
+//	@Param		id		path		int								true	"Map ID"
+//	@Param		request	body		models.DeleteMapSummaryRequest	true	"Body"
+//	@Success	200		{object}	models.Response{data=models.DeleteMapSummaryRequest}
+//	@Failure	400		{object}	models.Response
+//	@Router		/maps/{id}/summary [post]
+func DeleteMapSummary(c *gin.Context) {
+	// Check if user exists
+	user, exists := c.Get("user")
+	if !exists {
+		c.JSON(http.StatusUnauthorized, models.ErrorResponse("User not logged in."))
+		return
+	}
+	var moderator bool
+	for _, title := range user.(models.User).Titles {
+		if title == "Moderator" {
+			moderator = true
+		}
+	}
+	if !moderator {
+		c.JSON(http.StatusUnauthorized, models.ErrorResponse("Insufficient permissions."))
+		return
+	}
+	// Bind parameter and body
+	id := c.Param("id")
+	mapID, err := strconv.Atoi(id)
+	if err != nil {
+		c.JSON(http.StatusBadRequest, models.ErrorResponse(err.Error()))
+		return
+	}
+	var request models.DeleteMapSummaryRequest
+	if err := c.BindJSON(&request); err != nil {
+		c.JSON(http.StatusBadRequest, models.ErrorResponse(err.Error()))
+		return
+	}
+	// Start database transaction
+	tx, err := database.DB.Begin()
+	if err != nil {
+		c.JSON(http.StatusInternalServerError, models.ErrorResponse(err.Error()))
+		return
+	}
+	defer tx.Rollback()
+	// Fetch route category and score count
+	var checkMapID, scoreCount, mapHistoryID int
+	sql := `SELECT m.id, mr.score_count FROM maps m INNER JOIN map_routes mr ON m.id=mr.map_id WHERE m.id = $1 AND mr.id = $2`
+	err = database.DB.QueryRow(sql, mapID, request.RouteID).Scan(&checkMapID, &scoreCount)
+	if err != nil {
+		c.JSON(http.StatusBadRequest, models.ErrorResponse(err.Error()))
+		return
+	}
+	if mapID != checkMapID {
+		c.JSON(http.StatusBadRequest, models.ErrorResponse("Map ID does not exist."))
+		return
+	}
+	sql = `SELECT mh.id FROM maps m INNER JOIN map_routes mr ON m.id=mr.map_id INNER JOIN map_history mh ON m.id=mh.map_id WHERE m.id = $1 AND mr.id = $2 AND mh.score_count = $3`
+	err = database.DB.QueryRow(sql, mapID, request.RouteID, scoreCount).Scan(&mapHistoryID)
+	if err != nil {
+		c.JSON(http.StatusBadRequest, models.ErrorResponse(err.Error()))
+		return
+	}
+	// Update database with new data
+	sql = `DELETE FROM map_routes mr WHERE mr.id = $1 `
+	_, err = tx.Exec(sql, request.RouteID)
+	if err != nil {
+		c.JSON(http.StatusBadRequest, models.ErrorResponse(err.Error()))
+		return
+	}
+	sql = `DELETE FROM map_history mh WHERE mh.id = $1`
+	_, err = tx.Exec(sql, mapHistoryID)
+	if err != nil {
+		c.JSON(http.StatusBadRequest, models.ErrorResponse(err.Error()))
+		return
+	}
+	if err = tx.Commit(); err != nil {
+		c.JSON(http.StatusInternalServerError, models.ErrorResponse(err.Error()))
+		return
+	}
+	// Return response
+	c.JSON(http.StatusOK, models.Response{
+		Success: true,
+		Message: "Successfully delete map summary.",
+		Data:    request,
+	})
+}
diff --git a/backend/models/requests.go b/backend/models/requests.go
index 767b4d8..f275203 100644
--- a/backend/models/requests.go
+++ b/backend/models/requests.go
@@ -23,6 +23,10 @@ type EditMapSummaryRequest struct {
 	RecordDate  time.Time `json:"record_date" binding:"required"`
 }
 
+type DeleteMapSummaryRequest struct {
+	RouteID int `json:"route_id" binding:"required"`
+}
+
 type RecordRequest struct {
 	HostDemo        *multipart.FileHeader `json:"host_demo" form:"host_demo" binding:"required" swaggerignore:"true"`
 	PartnerDemo     *multipart.FileHeader `json:"partner_demo" form:"partner_demo" swaggerignore:"true"`
-- 
cgit v1.2.3