From 32191222ba22409773b2e86abf8b7113203103ca Mon Sep 17 00:00:00 2001
From: Jake Mannens <jake@asger.xyz>
Date: Fri, 11 Aug 2023 02:57:35 +1000
Subject: Added basis for a search box

---
 Pages/Index.cshtml.cs | 32 ++++++++++++++++++++++++++++++--
 1 file changed, 30 insertions(+), 2 deletions(-)

(limited to 'Pages/Index.cshtml.cs')

diff --git a/Pages/Index.cshtml.cs b/Pages/Index.cshtml.cs
index e03a330..07d24f0 100644
--- a/Pages/Index.cshtml.cs
+++ b/Pages/Index.cshtml.cs
@@ -4,12 +4,40 @@ using Microsoft.AspNetCore.Mvc.RazorPages;
 namespace HyperBooru.Pages;
 
 public class IndexModel : PageModel {
-    public IEnumerable<DbMedia> Media => db.Media;
+    public IEnumerable<DbMedia> Media { get; private set; }
 
     private HyperBooruDbContext db;
 
     public IndexModel(HyperBooruDbContext db) =>
         this.db = db;
 
-    public void OnGet() {}
+    public void OnGet([FromQuery(Name = "q")] string? query) {
+        IEnumerable<DbMedia> media;
+
+        if(query is null) {
+            media = db.UploadedFiles
+                .OrderByDescending(uf => uf.UploadTime)
+                .Select(uf => uf.Media)
+                .Distinct();
+        } else {
+            query = query.ToLower();
+
+            var matchingTags = db.TagDefinitions
+            .Where(td => td.Name.ToLower().Contains(query))
+            .Select(td => td.Guid);
+
+            media = db.Media
+                .Where(m =>
+                    m.Tags
+                        .Select(t => t.TagDefinition.Guid)
+                        .Intersect(matchingTags)
+                        .Any());
+        }
+
+        Media = media.OrderByDescending(m =>
+            m.UploadedFiles
+                .Select(uf => uf.UploadTime)
+                .Order()
+                .Last());
+    }
 }
\ No newline at end of file
-- 
cgit v1.3