import { NextRequest, NextResponse } from 'next/server';
import { createClient } from '@/lib/supabase/server';
import { createAdminClient } from '@/lib/supabase/admin';

async function handleDelete(
  request: NextRequest,
  { params }: { params: Promise<{ id: string }> }
) {
  const { id } = await params;
  
  const supabase = await createClient();
  
  const { data: { user }, error: authError } = await supabase.auth.getUser();
  
  if (authError || !user) {
    return NextResponse.json({ error: 'Unauthorized' }, { status: 401 });
  }

  // Check if user is admin
  const adminClient = createAdminClient();
  const { data: userProfile } = await adminClient.from("users").select("role").eq("id", user.id).single();
  const isAdmin = userProfile?.role === "admin";

  // Check for existing orders before deleting
  const { count, error: countError } = await supabase
    .from("orders")
    .select("*", { count: "exact", head: true })
    .eq("event_id", id);

  if (countError) {
    return NextResponse.json({ error: "Failed to check for existing orders" }, { status: 500 });
  }

  if (count && count > 0) {
    return NextResponse.json(
      { error: "Cannot delete an event that has existing orders. Unpublish it instead." },
      { status: 400 }
    );
  }

  // Delete event - admins can delete any event, organizers can only delete their own
  let deleteQuery;
  if (isAdmin) {
    deleteQuery = adminClient.from('events').delete().eq('id', id);
  } else {
    deleteQuery = supabase.from('events').delete().eq('id', id).eq('organizer_id', user.id);
  }

  const { error } = await deleteQuery;

  if (error) {
    return NextResponse.json({ error: error.message }, { status: 500 });
  }

  return NextResponse.json({ success: true });
}

export async function POST(
  request: NextRequest,
  params: { params: Promise<{ id: string }> }
) {
  return handleDelete(request, params);
}

export async function DELETE(
  request: NextRequest,
  params: { params: Promise<{ id: string }> }
) {
  return handleDelete(request, params);
}