Archis Platform Features

-- Uses get_active_firm_id() so expired/suspended
-- firms receive NULL and all queries are denied
CREATE POLICY firm_isolation_policy
  ON public.cases
  FOR ALL
  USING (
    firm_id = get_active_firm_id()
  );

-- Helper returns NULL when firm.status
-- is 'expired' or 'suspended'
CREATE OR REPLACE FUNCTION get_active_firm_id()
RETURNS uuid LANGUAGE sql SECURITY DEFINER AS $$
  SELECT firm_id FROM public.users
  WHERE id = auth.uid()
  AND EXISTS (
    SELECT 1 FROM public.firms
    WHERE firm_id = firms.id
    AND status IN ('trial', 'active')
  );
$$;

// Compare ISO date strings directly (UTC+5:45 safe)
const todayString = new Date()
  .toLocaleDateString("en-CA", {
    timeZone: firmTimeZone // E.g., "America/New_York"
  }); // Output: "YYYY-MM-DD"

// Overdue check avoids datetime offsets
const isOverdue = taskDueDate < todayString;

// Court hearing countdown via local midnight diff
const [y, m, d] = dateStr.split("-").map(Number);
const target = new Date(y, m - 1, d); // local midnight
const today = new Date();
today.setHours(0, 0, 0, 0);
const daysLeft = Math.ceil(
  (target.getTime() - today.getTime()) / 86400000
);