diff options
Diffstat (limited to 'backend/controllers/mapController.go')
| -rw-r--r-- | backend/controllers/mapController.go | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/backend/controllers/mapController.go b/backend/controllers/mapController.go index 77f8e10..7dfd2be 100644 --- a/backend/controllers/mapController.go +++ b/backend/controllers/mapController.go | |||
| @@ -39,7 +39,7 @@ func FetchMapSummary(c *gin.Context) { | |||
| 39 | return | 39 | return |
| 40 | } | 40 | } |
| 41 | // Get map routes and histories | 41 | // Get map routes and histories |
| 42 | sql = `SELECT c.id, c.name, h.user_name, h.score_count, h.record_date, r.description, r.showcase, COALESCE(avg(rating), 0.0) FROM map_routes r | 42 | sql = `SELECT r.id, c.id, c.name, h.user_name, h.score_count, h.record_date, r.description, r.showcase, COALESCE(avg(rating), 0.0) FROM map_routes r |
| 43 | INNER JOIN categories c ON r.category_id = c.id | 43 | INNER JOIN categories c ON r.category_id = c.id |
| 44 | INNER JOIN map_history h ON r.map_id = h.map_id AND r.category_id = h.category_id | 44 | INNER JOIN map_history h ON r.map_id = h.map_id AND r.category_id = h.category_id |
| 45 | LEFT JOIN map_ratings rt ON r.map_id = rt.map_id AND r.category_id = rt.category_id | 45 | LEFT JOIN map_ratings rt ON r.map_id = rt.map_id AND r.category_id = rt.category_id |
| @@ -52,7 +52,7 @@ func FetchMapSummary(c *gin.Context) { | |||
| 52 | } | 52 | } |
| 53 | for rows.Next() { | 53 | for rows.Next() { |
| 54 | route := models.MapRoute{Category: models.Category{}, History: models.MapHistory{}} | 54 | route := models.MapRoute{Category: models.Category{}, History: models.MapHistory{}} |
| 55 | err = rows.Scan(&route.Category.ID, &route.Category.Name, &route.History.RunnerName, &route.History.ScoreCount, &route.History.Date, &route.Description, &route.Showcase, &route.Rating) | 55 | err = rows.Scan(&route.RouteID, &route.Category.ID, &route.Category.Name, &route.History.RunnerName, &route.History.ScoreCount, &route.History.Date, &route.Description, &route.Showcase, &route.Rating) |
| 56 | if err != nil { | 56 | if err != nil { |
| 57 | c.JSON(http.StatusBadRequest, models.ErrorResponse(err.Error())) | 57 | c.JSON(http.StatusBadRequest, models.ErrorResponse(err.Error())) |
| 58 | return | 58 | return |