"use client";

import { useCallback, useEffect, useState } from "react";
import { createClient, getBrowserUserId } from "@/lib/supabase/client";
import { useWorkspaceStore } from "@/stores/workspace-store";
import type { TaskBucket } from "@/types";

const DEFAULT_BUCKET_NAME = "Neues Bucket";

export function useTaskBuckets() {
  const [buckets, setBuckets] = useState<TaskBucket[]>([]);
  const [loading, setLoading] = useState(true);
  const [userId, setUserId] = useState<string | null>(null);
  const supabase = createClient();
  const activeTeamId = useWorkspaceStore((state) => state.activeTeamId);
  const initialized = useWorkspaceStore((state) => state.initialized);

  useEffect(() => {
    void getBrowserUserId().then(setUserId).catch(() => setUserId(null));
  }, []);

  async function requireCurrentUserId() {
    const currentUserId = userId || (await getBrowserUserId());
    if (currentUserId && currentUserId !== userId) setUserId(currentUserId);
    return currentUserId;
  }

  const fetchBuckets = useCallback(async () => {
    if (!initialized) return;
    setLoading(true);

    let query = supabase
      .from("task_buckets")
      .select("*")
      .order("sort_order")
      .order("created_at", { ascending: true });

    query = activeTeamId ? query.eq("team_id", activeTeamId) : query.is("team_id", null);

    const { data, error } = await query;
    if (error) {
      console.error("Failed to load task buckets", error);
      setLoading(false);
      return;
    }

    setBuckets((data || []) as TaskBucket[]);
    setLoading(false);
  }, [activeTeamId, initialized, supabase]);

  useEffect(() => {
    async function loadBuckets() {
      await fetchBuckets();
    }
    void loadBuckets();
  }, [fetchBuckets]);

  async function createBucket(name: string = DEFAULT_BUCKET_NAME) {
    const currentUserId = await requireCurrentUserId();
    if (!currentUserId) throw new Error("Not authenticated");

    const { data, error } = await supabase
      .from("task_buckets")
      .insert({
        user_id: currentUserId,
        team_id: activeTeamId,
        name,
        color: "#71717a",
        sort_order: buckets.length,
      })
      .select()
      .single();

    if (error) throw error;
    await fetchBuckets();
    return data as TaskBucket;
  }

  async function renameBucket(id: string, name: string) {
    const { error } = await supabase.from("task_buckets").update({ name }).eq("id", id);
    if (error) throw error;
    await fetchBuckets();
  }

  async function deleteBucket(id: string) {
    const { error } = await supabase.from("task_buckets").delete().eq("id", id);
    if (error) throw error;
    await fetchBuckets();
  }

  return {
    buckets,
    loading,
    createBucket,
    renameBucket,
    deleteBucket,
    refetch: fetchBuckets,
  };
}