File size: 2,049 Bytes
1a45d5d |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 |
import { Dialog, DialogContent } from "@/components/ui/dialog";
import { useTranslation } from "@/hooks/useTranslation";
import { ExternalLink } from "lucide-react";
import { useQuery } from "@tanstack/react-query";
import { supabase } from "@/integrations/supabase/client";
export const StatsDialog = ({
open,
onOpenChange,
}: {
open: boolean;
onOpenChange: (open: boolean) => void;
}) => {
const t = useTranslation();
const { data: todayResults } = useQuery({
queryKey: ["game-results-today"],
queryFn: async () => {
const today = new Date();
today.setHours(0, 0, 0, 0);
const { count } = await supabase
.from("game_results")
.select("*", { count: "exact" })
.gte("created_at", today.toISOString());
return count || 0;
},
});
const { data: totalResults } = useQuery({
queryKey: ["game-results-total"],
queryFn: async () => {
const { count } = await supabase
.from("game_results")
.select("*", { count: "exact" });
return count || 0;
},
});
return (
<Dialog open={open} onOpenChange={onOpenChange}>
<DialogContent>
<div className="space-y-4">
<div>
<h3 className="font-semibold text-lg">{t.welcome.stats.title}</h3>
</div>
<div className="space-y-2">
<p>
{t.welcome.stats.dailyGuesses}: {todayResults || 0}
</p>
<p>
{t.welcome.stats.totalGuesses}: {totalResults || 0}
</p>
</div>
<div>
<a
href="https://plausible.sonnenhof-zieger.de/think-in-sync.com"
target="_blank"
rel="noopener noreferrer"
className="inline-flex items-center gap-2 text-primary hover:text-primary/80 transition-colors"
>
{t.welcome.stats.visitDashboard}
<ExternalLink className="w-4 h-4" />
</a>
</div>
</div>
</DialogContent>
</Dialog>
);
};
|