3 files changed, 52 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)
 }
diff --git a/views/includes/card_gril.html b/views/includes/card_gril.html
new file mode 100644
index 0000000..337c9a9
--- /dev/null
+++ b/views/includes/card_gril.html
@@ -0,0 +1,11 @@
+{{ define "card_gril" }}

+<div class="card white">

+    <div class="center-align">

+        <div class="circle gril-img" style="background-image: url(/{{ .ImagePath false }})"> </div>

+    </div>

+    <div class="card-content black-text">

+        <span class="card-title">{{ .RomajiName }} <small>{{ .KanjiName }}</small></span>

+    </div>

+    <div class="card-action"><a href="/gril/{{ .Slug }}">anguckieren</a></div>

+</div>

+{{ end }}
\ No newline at end of file
diff --git a/views/pages/gril.html b/views/pages/gril.html
index cd92208..eb66537 100644
--- a/views/pages/gril.html
+++ b/views/pages/gril.html
@@ -75,6 +75,17 @@
                         </div>
                     </div>
                                 </div>
+                
+                {{ if .SimilarGrils }}
+                <h1>Ähnliche Grils</h1>
+                <div class="row">
+                    {{ range .SimilarGrils }}
+                    <div class="col s3">
+                        {{ template "card_gril" . }}
+                    </div>
+                    {{ end }}
+                </div>
+                {{ end }}
                         </div>