feat: show best reference (by quality score) on each item in list view

1 files changed, 11 insertions, 3 deletions

diff --git a/src/routes/+page.server.ts b/src/routes/+page.server.ts
index 6d547e6..27ecbe1 100644
--- a/src/routes/+page.server.ts
+++ b/src/routes/+page.server.ts
@@ -1,21 +1,29 @@
 import { fail } from '@sveltejs/kit';
 import { db } from '$lib/server/db';
-import { groceries, categories } from '$lib/server/db/schema';
-import { eq, desc } from 'drizzle-orm';
+import { groceries, categories, references } from '$lib/server/db/schema';
+import { eq, desc, asc } from 'drizzle-orm';
 import type { Actions, PageServerLoad } from './$types';
 
 export const load: PageServerLoad = async () => {
-	const [items, cats] = await Promise.all([
+	const [items, cats, refs] = await Promise.all([
 		db.select().from(groceries).orderBy(desc(groceries.createdAt)),
 		db.select().from(categories).orderBy(desc(categories.name)),
+		db.select().from(references).orderBy(desc(references.qualityScore)),
 	]);
 
 	const catMap = new Map(cats.map((c) => [c.id, c.name]));
+	const bestRef = new Map<number, (typeof refs)[number]>();
+	for (const ref of refs) {
+		if (!bestRef.has(ref.groceryId)) {
+			bestRef.set(ref.groceryId, ref);
+		}
+	}
 
 	return {
 		items: items.map((i) => ({
 			...i,
 			categoryName: i.categoryId ? (catMap.get(i.categoryId) ?? null) : null,
+			bestRef: bestRef.get(i.id) ?? null,
 		})),
 		categories: cats,
 	};