meet-hub/supabase/functions/cancel-expired-consulting-orders/index.ts

import { serve } from "https://deno.land/std@0.190.0/http/server.ts";
import { createClient } from "https://esm.sh/@supabase/supabase-js@2";

const corsHeaders = {
  "Access-Control-Allow-Origin": "*",
  "Access-Control-Allow-Headers": "authorization, x-client-info, apikey, content-type",
};

serve(async (req: Request): Promise<Response> => {
  if (req.method === "OPTIONS") {
    return new Response(null, { headers: corsHeaders });
  }

  try {
    const supabaseUrl = Deno.env.get("SUPABASE_URL")!;
    const supabaseServiceKey = Deno.env.get("SUPABASE_SERVICE_ROLE_KEY")!;
    const supabase = createClient(supabaseUrl, supabaseServiceKey);

    console.log("[CLEANUP-CALENDAR] Starting calendar cleanup for cancelled sessions");

    // Find cancelled consulting sessions with calendar events that haven't been cleaned up
    const { data: cancelledSessions, error: queryError } = await supabase
      .from("consulting_sessions")
      .select("id, calendar_event_id")
      .eq("status", "cancelled")
      .not("calendar_event_id", "is", null);

    if (queryError) {
      console.error("[CLEANUP-CALENDAR] Query error:", queryError);
      throw queryError;
    }

    if (!cancelledSessions || cancelledSessions.length === 0) {
      console.log("[CLEANUP-CALENDAR] No cancelled sessions with calendar events found");
      return new Response(
        JSON.stringify({
          success: true,
          message: "No calendar events to clean up",
          processed: 0
        }),
        { headers: { ...corsHeaders, "Content-Type": "application/json" } }
      );
    }

    console.log(`[CLEANUP-CALENDAR] Found ${cancelledSessions.length} cancelled sessions with calendar events`);

    let processedCount = 0;

    // Delete calendar events for cancelled sessions
    for (const session of cancelledSessions) {
      if (session.calendar_event_id) {
        try {
          await supabase.functions.invoke('delete-calendar-event', {
            body: { session_id: session.id }
          });
          console.log(`[CLEANUP-CALENDAR] Deleted calendar event for session: ${session.id}`);
          processedCount++;
        } catch (err) {
          console.log(`[CLEANUP-CALENDAR] Failed to delete calendar event: ${err}`);
          // Continue with other events even if one fails
        }
      }
    }

    console.log(`[CLEANUP-CALENDAR] Successfully cleaned up ${processedCount} calendar events`);

    return new Response(
      JSON.stringify({
        success: true,
        message: `Successfully cleaned up ${processedCount} calendar events`,
        processed: processedCount
      }),
      { headers: { ...corsHeaders, "Content-Type": "application/json" } }
    );

  } catch (error: any) {
    console.error("[CLEANUP-CALENDAR] Error:", error);
    return new Response(
      JSON.stringify({
        success: false,
        error: error.message || "Internal server error"
      }),
      { status: 500, headers: { ...corsHeaders, "Content-Type": "application/json" } }
    );
  }
});