From 5f423e365ada8aae63ad07099031a23252f47514 Mon Sep 17 00:00:00 2001 From: Martin Kagamino Lehoux Date: Mon, 27 Jul 2026 20:44:10 +0200 Subject: feat: navbar + split list/catalog into separate pages - Navbar component with List, Catalog, Categories tabs - / = shopping list (unchecked items with add form) - /catalog = full catalog with toggle - /categories = category management - Removed page titles (navbar indicates context) --- src/routes/catalog/+page.server.ts | 52 ++++++++++++++ src/routes/catalog/+page.svelte | 136 +++++++++++++++++++++++++++++++++++++ 2 files changed, 188 insertions(+) create mode 100644 src/routes/catalog/+page.server.ts create mode 100644 src/routes/catalog/+page.svelte (limited to 'src/routes/catalog') diff --git a/src/routes/catalog/+page.server.ts b/src/routes/catalog/+page.server.ts new file mode 100644 index 0000000..34d0a06 --- /dev/null +++ b/src/routes/catalog/+page.server.ts @@ -0,0 +1,52 @@ +import { fail } from '@sveltejs/kit'; +import { db } from '$lib/server/db'; +import { groceries, categories, references } from '$lib/server/db/schema'; +import { eq, desc } from 'drizzle-orm'; +import type { Actions, PageServerLoad } from './$types'; + +export const load: PageServerLoad = async () => { + 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(); + 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, + }; +}; + +export const actions: Actions = { + toggle: async ({ request }) => { + const data = await request.formData(); + const id = Number(data.get('id')); + + const [item] = await db + .select() + .from(groceries) + .where(eq(groceries.id, id)); + if (!item) { + return fail(404, { error: 'Item not found' }); + } + + await db + .update(groceries) + .set({ checked: !item.checked }) + .where(eq(groceries.id, id)); + + return { success: true }; + }, +}; diff --git a/src/routes/catalog/+page.svelte b/src/routes/catalog/+page.svelte new file mode 100644 index 0000000..0e1106c --- /dev/null +++ b/src/routes/catalog/+page.svelte @@ -0,0 +1,136 @@ + + +{#if catalogItems.length === 0} +

No items yet

+{:else} +
+ {#each groupByCategory(catalogItems) as [cat, items] (cat)} +

{cat}

+
    + {#each items as item (item.id)} +
  • + + → +
  • + {/each} +
+ {/each} +
+{/if} + + -- cgit v1.3