Function DashboardNumMessages

pages/usage.tsx:132–213

()

}

function DashboardNumMessages() {
  const supabase = useSupabaseClient<Database>();
  const { profile, refreshProfile } = useProfile();
  const [queriesTimeseries, setQueriesTimeseries] = useState([{}] as {
    date: string;
    value: number;
  }[]);
  const [totalThisMonth, setTotalThisMonth] = useState(0);
  const [totalLastMonth, setTotalLastMonth] = useState(0);
  const [loading, setLoading] = useState(true);

  const today = new Date();
  const firstOfThisMonth = new Date(today.getFullYear(), today.getMonth(), 1);
  const startOfPreviousMonth = new Date(
    today.getFullYear(),
    today.getMonth() - 1,
    1,
  );
  const endOfPreviousMonth = new Date(today.getFullYear(), today.getMonth(), 0);

  useEffect(() => {
    if (!profile) return;
    (async () => {
      const thisMonthRes = await supabase
        .from("usage")
        .select("*")
        .eq("org_id", profile?.org_id!)
        .gte("date", firstOfThisMonth.toISOString());
      if (thisMonthRes.error) throw thisMonthRes.error;

      setQueriesTimeseries(
        thisMonthRes.data.map((d) => ({
          date: d.date,
          value: d.num_user_queries,
        })),
      );
      setTotalThisMonth(
        thisMonthRes.data.reduce((acc, curr) => acc + curr.num_user_queries, 0),
      );

      const lastMonthRes = await supabase
        .from("usage")
        .select("*")
        .eq("org_id", profile?.org_id!)
        .gte("date", startOfPreviousMonth.toISOString())
        .lte("date", endOfPreviousMonth.toISOString());

      if (lastMonthRes.error) throw thisMonthRes.error;
      setTotalLastMonth(
        lastMonthRes.data.reduce((acc, curr) => acc + curr.num_user_queries, 0),
      );

      setLoading(false);
    })();
  }, [profile, refreshProfile, supabase]);
  return (
    <div className="bg-gray-800 min-h-screen">
      <Navbar current={"Usage"} />