ähnliche grils anzeigen, wenn verfügbar (gril view)

1 files changed, 30 insertions, 0 deletions

diff --git a/modules/grils/grils.go b/modules/grils/grils.go
index 5d548e6..e6aaa11 100644
--- a/modules/grils/grils.go
+++ b/modules/grils/grils.go
@@ -195,6 +195,36 @@ func (m *GrilsModule) viewGril(w http.ResponseWriter, r *http.Request, p httprou
         data := m.g.Renderer.DefaultData()
         data["user"] = user
         data["gril"] = gril
+    
+    // ähnliche grils holen
+    rows, err := m.g.DB.Query(`SELECT gril_id FROM (
+        SELECT DISTINCT gril_id FROM gril_appearance WHERE appearance_id IN (SELECT appearance_id FROM gril_appearance WHERE gril_id = $1)
+        ) as t
+    ORDER BY RANDOM()
+    LIMIT 4;`, id)
+    if err != nil {
+        log.Println("could not get similar grils:", err)
+        http.Error(w, "500", http.StatusInternalServerError)
+        return
+    }
+    
+    defer rows.Close()
+    var similar []*Gril
+    for rows.Next() {
+        var id int
+        if err := rows.Scan(&id); err != nil {
+            log.Println("error scanning for similar gril:", err)
+            continue
+        }
+        
+        g, err := m.FromID(id)
+        if err != nil {
+            log.Println("invalid similar gril:", err)
+            continue
+        }
+        similar = append(similar, g)
+    }
+    data["SimilarGrils"] = similar
 
         m.g.Renderer.RenderPage("gril", w, data)
 }