feat: completion count on summary for each cm entry (#63)

Former-commit-id: 38779e7cbddb7e850a5f4a56565938b3dcb14857

2 files changed, 29 insertions, 6 deletions

diff --git a/backend/handlers/map.go b/backend/handlers/map.go
index 2a060e6..e55dab4 100644
--- a/backend/handlers/map.go
+++ b/backend/handlers/map.go
@@ -101,6 +101,28 @@ func FetchMapSummary(c *gin.Context) {
                         c.JSON(http.StatusBadRequest, models.ErrorResponse(err.Error()))
                         return
                 }
+                // Get completion count
+                if response.Map.IsCoop {
+                        sql = `SELECT count(*) FROM ( SELECT host_id, partner_id, score_count, score_time,
+                                ROW_NUMBER() OVER (PARTITION BY host_id, partner_id ORDER BY score_count, score_time) AS rn
+                                FROM records_mp WHERE map_id = $1
+                                ) sub WHERE sub.rn = 1 AND score_count = $2`
+                        err = database.DB.QueryRow(sql, response.Map.ID, route.History.ScoreCount).Scan(&route.CompletionCount)
+                        if err != nil {
+                                c.JSON(http.StatusBadRequest, models.ErrorResponse(err.Error()))
+                                return
+                        }
+                } else {
+                        sql = `SELECT count(*) FROM ( SELECT user_id, score_count, score_time, 
+                                ROW_NUMBER() OVER (PARTITION BY user_id ORDER BY score_count, score_time) AS rn
+                                FROM records_sp WHERE map_id = $1
+                                ) sub WHERE rn = 1 AND score_count = $2`
+                        err = database.DB.QueryRow(sql, response.Map.ID, route.History.ScoreCount).Scan(&route.CompletionCount)
+                        if err != nil {
+                                c.JSON(http.StatusBadRequest, models.ErrorResponse(err.Error()))
+                                return
+                        }
+                }
                 response.Summary.Routes = append(response.Summary.Routes, route)
         }
         // Return response
diff --git a/backend/models/models.go b/backend/models/models.go
index 35929c1..e5d92fb 100644
--- a/backend/models/models.go
+++ b/backend/models/models.go
@@ -64,12 +64,13 @@ type MapHistory struct {
 }
 
 type MapRoute struct {
-        RouteID     int        `json:"route_id"`
-        Category    Category   `json:"category"`
-        History     MapHistory `json:"history"`
-        Rating      float32    `json:"rating"`
-        Description string     `json:"description"`
-        Showcase    string     `json:"showcase"`
+        RouteID         int        `json:"route_id"`
+        Category        Category   `json:"category"`
+        History         MapHistory `json:"history"`
+        Rating          float32    `json:"rating"`
+        CompletionCount int        `json:"completion_count"`
+        Description     string     `json:"description"`
+        Showcase        string     `json:"showcase"`
 }
 
 type MapRecords struct {