feat: delete map summary

Former-commit-id: bd5bc84fc142f44bfa3c1c1ddc35e435a3f816bf

2 files changed, 94 insertions, 1 deletions

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"`