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 type { Actions, PageServerLoad } from './$types';

export const load: PageServerLoad = async () => {
	const [items, cats] = await Promise.all([
		db.select().from(groceries).orderBy(desc(groceries.createdAt)),
		db.select().from(categories).orderBy(desc(categories.name)),
	]);

	const catMap = new Map(cats.map((c) => [c.id, c.name]));

	return {
		items: items.map((i) => ({
			...i,
			categoryName: i.categoryId ? (catMap.get(i.categoryId) ?? null) : null,
		})),
		categories: cats,
	};
};

export const actions: Actions = {
	add: async ({ request }) => {
		const data = await request.formData();
		const name = data.get('name')?.toString().trim();
		const categoryId = data.get('category_id')?.toString() || null;

		if (!name) {
			return fail(400, { error: 'Name is required' });
		}

		const [existing] = await db
			.select()
			.from(groceries)
			.where(eq(groceries.name, name))
			.limit(1);

		if (existing) {
			await db
				.update(groceries)
				.set({
					checked: false,
					categoryId: categoryId ? Number(categoryId) : existing.categoryId,
				})
				.where(eq(groceries.id, existing.id));
		} else {
			await db.insert(groceries).values({
				name,
				categoryId: categoryId ? Number(categoryId) : null,
				createdAt: new Date().toISOString(),
			});
		}

		return { success: true };
	},

	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 };
	},

	delete: async ({ request }) => {
		const data = await request.formData();
		const id = Number(data.get('id'));

		await db.delete(groceries).where(eq(groceries.id, id));

		return { success: true };
	},
};