import type { Actions, PageServerLoad } from "./$types";

import { fail, redirect, isRedirect } from "@sveltejs/kit";

const R2_BASE_URL = "https://r2.steve.photo";

type PhotoRow = {

	id: number;

	slug: string;

	title: string;

	date: string;

	image_key: string;

	thumb_key: string;

};

export const load: PageServerLoad = async ({ platform }) => {

	const db = platform?.env?.DB;

	if (!db) {

		return { photos: [] };

	}

	const result = await db

		.prepare(

			"SELECT id, slug, title, date, image_key, thumb_key FROM photos ORDER BY date DESC",

		)

		.all<PhotoRow>();

	const photos = result.results.map((row: PhotoRow) => ({

		id: row.id,

		slug: row.slug,

		title: row.title,

		date: row.date,

		thumb: `${R2_BASE_URL}/${row.thumb_key}`,

	}));

	return { photos };

};

export const actions: Actions = {

	upload: async ({ request, platform, locals }) => {

		if (!locals.user?.authenticated) {

			return fail(401, { error: "Unauthorized" });

		}

		const db = platform?.env?.DB;

		const bucket = platform?.env?.PHOTOS;

		if (!db || !bucket) {

			return fail(500, { error: "Server configuration error" });

		}

		const formData = await request.formData();

		const file = formData.get("file") as File | null;

		const thumbnail = formData.get("thumbnail") as File | null;

		const title = formData.get("title") as string;

		const date = formData.get("date") as string;

		const camera = formData.get("camera") as string;

		const lens = formData.get("lens") as string;

		const aperture = formData.get("aperture") as string;

		const exposure = formData.get("exposure") as string;

		const focalLength = formData.get("focalLength") as string;

		const iso = formData.get("iso") as string;

		const make = formData.get("make") as string;

		const blurData = formData.get("blur_data") as string;

		if (!file || !title || !date) {

			return fail(400, { error: "File, title, and date are required" });

		}

		// Generate slug from title

		const slug = title

			.toLowerCase()

			.replace(/[^a-z0-9]+/g, "-")

			.replace(/(^-|-$)/g, "");

		// Check if slug already exists

		const existing = await db

			.prepare("SELECT id FROM photos WHERE slug = ?")

			.bind(slug)

			.first();

		if (existing) {

			return fail(400, { error: "A photo with this title already exists" });

		}

		// Get file extension

		const ext = file.name.split(".").pop()?.toLowerCase() || "jpg";

		const imageKey = `${slug}.${ext}`;

		const thumbKey = `${slug}-thumb.jpg`;

		try {

			// Upload original image to R2

			const fileBuffer = await file.arrayBuffer();

			await bucket.put(imageKey, fileBuffer, {

				httpMetadata: {

					contentType: file.type,

				},

			});

			// Upload thumbnail to R2

			if (thumbnail) {

				const thumbBuffer = await thumbnail.arrayBuffer();

				await bucket.put(thumbKey, thumbBuffer, {

					httpMetadata: {

						contentType: "image/jpeg",

					},

				});

			} else {

				// If no thumbnail provided, use original as thumbnail

				await bucket.put(thumbKey, fileBuffer, {

					httpMetadata: {

						contentType: file.type,

					},

				});

			}

			// Insert into database

			await db

				.prepare(

					`INSERT INTO photos (slug, title, date, image_key, thumb_key, camera, lens, aperture, exposure, focal_length, iso, make, blur_data)

					 VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,

				)

				.bind(

					slug,

					title,

					date,

					imageKey,

					thumbKey,

					camera || null,

					lens || null,

					aperture || null,

					exposure || null,

					focalLength || null,

					iso || null,

					make || null,

					blurData || null,

				)

				.run();

			return { success: true };

		} catch (err) {

			if (isRedirect(err)) {

				throw err; // Re-throw redirects

			}

			const errorMessage = err instanceof Error ? err.message : String(err);

			console.error("Upload error:", errorMessage, err);

			return fail(500, { error: `Failed to upload photo: ${errorMessage}` });

		}

	},

	edit: async ({ request, platform, locals }) => {

		if (!locals.user?.authenticated) {

			return fail(401, { error: "Unauthorized" });

		}

		const db = platform?.env?.DB;

		if (!db) {

			return fail(500, { error: "Server configuration error" });

		}

		const formData = await request.formData();

		const id = formData.get("id") as string;

		const title = formData.get("title") as string;

		if (!id || !title) {

			return fail(400, { error: "ID and title are required" });

		}

		try {

			await db

				.prepare("UPDATE photos SET title = ? WHERE id = ?")

				.bind(title, parseInt(id, 10))

				.run();

			return { success: true };

		} catch (err) {

			const errorMessage = err instanceof Error ? err.message : String(err);

			console.error("Edit error:", errorMessage);

			return fail(500, { error: `Failed to update photo: ${errorMessage}` });

		}

	},

	delete: async ({ request, platform, locals }) => {

		if (!locals.user?.authenticated) {

			return fail(401, { error: "Unauthorized" });

		}

		const db = platform?.env?.DB;

		const bucket = platform?.env?.PHOTOS;

		if (!db || !bucket) {

			return fail(500, { error: "Server configuration error" });

		}

		const formData = await request.formData();

		const id = formData.get("id") as string;

		if (!id) {

			return fail(400, { error: "ID is required" });

		}

		try {

			// Get photo details first to delete from R2

			const photo = await db

				.prepare("SELECT image_key, thumb_key FROM photos WHERE id = ?")

				.bind(parseInt(id, 10))

				.first<{ image_key: string; thumb_key: string }>();

			if (!photo) {

				return fail(404, { error: "Photo not found" });

			}

			// Delete from R2

			await bucket.delete(photo.image_key);

			await bucket.delete(photo.thumb_key);

			// Delete from database

			await db

				.prepare("DELETE FROM photos WHERE id = ?")

				.bind(parseInt(id, 10))

				.run();

			return { success: true };

		} catch (err) {

			const errorMessage = err instanceof Error ? err.message : String(err);

			console.error("Delete error:", errorMessage);

			return fail(500, { error: `Failed to delete photo: ${errorMessage}` });

		}

	},

};