Download apps/admin/src/pages/AnalyticsPage.tsx from safetrack/edtech: direct link, hf CLI and curl.
- Browser
- Download file 18.4 kB
-
https://huggingface.co/spaces/safetrack/edtech/resolve/main/apps/admin/src/pages/AnalyticsPage.tsx
- Command line
-
hf download hf://spaces/safetrack/edtech/apps/admin/src/pages/AnalyticsPage.tsx
-
curl -L -o AnalyticsPage.tsx https://huggingface.co/spaces/safetrack/edtech/resolve/main/apps/admin/src/pages/AnalyticsPage.tsx
18.4 kB
| import { useEffect, useState, useRef } from 'react'; | |
| import { useTranslation } from 'react-i18next'; | |
| import { | |
| BarChart, Bar, XAxis, YAxis, CartesianGrid, Tooltip, ResponsiveContainer, | |
| PieChart, Pie, Cell | |
| } from 'recharts'; | |
| import { | |
| TrendingUp, Users, MessageSquare, BrainCircuit, | |
| ChevronRight, Award, Clock, Search, Loader2, Terminal | |
| } from 'lucide-react'; | |
| import { useAuth } from '../lib/auth'; | |
| import { useTenant } from '../lib/tenant'; | |
| import { api } from '../lib/api'; | |
| import { logError } from '../lib/logger'; | |
| const COLORS = ['#6366f1', '#10b981', '#f59e0b', '#ef4444']; | |
| export default function AnalyticsPage() { | |
| const { token } = useAuth(); | |
| const { t } = useTranslation(); | |
| const { selectedOrgId } = useTenant(); | |
| const [usage, setUsage] = useState<any>(null); | |
| const [pedagogy, setPedagogy] = useState<any>(null); | |
| const [loading, setLoading] = useState(true); | |
| const [sqlQuestion, setSqlQuestion] = useState(''); | |
| const [sqlLoading, setSqlLoading] = useState(false); | |
| const [sqlResult, setSqlResult] = useState<{ rows: Record<string, unknown>[]; sql: string; count: number } | null>(null); | |
| const [sqlError, setSqlError] = useState<string | null>(null); | |
| const sqlInputRef = useRef<HTMLInputElement>(null); | |
| useEffect(() => { | |
| if (!selectedOrgId || !token) return; | |
| const fetchData = async () => { | |
| setLoading(true); | |
| try { | |
| const [usageData, pedagogyData] = await Promise.all([ | |
| api.get('/v1/analytics/usage', token, selectedOrgId), | |
| api.get('/v1/analytics/pedagogy', token, selectedOrgId) | |
| ]); | |
| setUsage(usageData); | |
| setPedagogy(pedagogyData); | |
| } catch (err) { | |
| logError('Analytics fetch error:', err); | |
| } finally { | |
| setLoading(false); | |
| } | |
| }; | |
| fetchData(); | |
| }, [selectedOrgId, token]); | |
| if (!selectedOrgId) { | |
| return ( | |
| <div className="p-12 text-center text-gray-400"> | |
| <Building2 className="w-12 h-12 mx-auto mb-4 opacity-20" /> | |
| {t('dashboard.select_org_hint')} | |
| </div> | |
| ); | |
| } | |
| if (loading) return <div className="p-12 animate-pulse text-gray-400">{t('common.loading')}</div>; | |
| const handleSqlQuery = async (e: React.FormEvent) => { | |
| e.preventDefault(); | |
| if (!sqlQuestion.trim() || !selectedOrgId || !token) return; | |
| setSqlLoading(true); | |
| setSqlResult(null); | |
| setSqlError(null); | |
| try { | |
| const data = await api.post('/v1/analytics/query', { question: sqlQuestion, language: 'FR' }, token, selectedOrgId); | |
| setSqlResult(data); | |
| } catch (err: any) { | |
| setSqlError(err?.message ?? t('analytics.sql_error')); | |
| } finally { | |
| setSqlLoading(false); | |
| } | |
| }; | |
| const EXAMPLE_QUESTIONS = [ | |
| t('analytics.sql_example_1'), | |
| t('analytics.sql_example_2'), | |
| t('analytics.sql_example_3'), | |
| t('analytics.sql_example_4'), | |
| ]; | |
| const messageData = [ | |
| { name: t('analytics.messages.inbound'), value: usage?.messages?.inbound || 0 }, | |
| { name: t('analytics.messages.outbound'), value: usage?.messages?.outbound || 0 }, | |
| ]; | |
| const completionData = [ | |
| { name: t('analytics.completion.completed'), value: pedagogy?.completion?.completed || 0 }, | |
| { name: t('analytics.completion.in_progress'), value: pedagogy?.completion?.active || 0 }, | |
| ]; | |
| return ( | |
| <div className="p-8 max-w-7xl mx-auto space-y-8"> | |
| <div className="flex items-center justify-between"> | |
| <div> | |
| <h1 className="text-3xl font-bold text-slate-900">{t('dashboard.title')}</h1> | |
| <p className="text-slate-500">{t('dashboard.subtitle')}</p> | |
| </div> | |
| <div className="bg-white px-4 py-2 rounded-2xl border border-slate-100 flex items-center gap-3 shadow-sm"> | |
| <div className="w-2 h-2 bg-green-500 rounded-full animate-pulse" /> | |
| <span className="text-xs font-bold text-slate-600 uppercase tracking-wider">Live System</span> | |
| </div> | |
| </div> | |
| {/* KPI Cards */} | |
| <div className="grid grid-cols-1 md:grid-cols-2 lg:grid-cols-4 gap-6"> | |
| <StatCard | |
| title={t('dashboard.stats.total_messages')} | |
| value={usage?.messages?.total || 0} | |
| icon={<MessageSquare className="w-5 h-5" />} | |
| trend={null} | |
| color="text-indigo-600" | |
| bg="bg-indigo-50" | |
| /> | |
| <StatCard | |
| title={t('dashboard.stats.active_users')} | |
| value={usage?.users?.activeLast24h || 0} | |
| icon={<Users className="w-5 h-5" />} | |
| trend={null} | |
| color="text-emerald-600" | |
| bg="bg-emerald-50" | |
| /> | |
| <StatCard | |
| title={t('dashboard.stats.completion_rate')} | |
| value={`${Math.round(pedagogy?.completion?.rate || 0)}%`} | |
| icon={<TrendingUp className="w-5 h-5" />} | |
| trend={null} | |
| color="text-amber-600" | |
| bg="bg-amber-50" | |
| /> | |
| <StatCard | |
| title={t('dashboard.stats.ai_cost')} | |
| value={`$${(usage?.costs?.totalUsd ?? 0).toFixed(4)}`} | |
| icon={<BrainCircuit className="w-5 h-5" />} | |
| trend={`${((usage?.costs?.totalTokens ?? 0) / 1000).toFixed(1)}k tokens`} | |
| color="text-purple-600" | |
| bg="bg-purple-50" | |
| /> | |
| </div> | |
| <div className="grid grid-cols-1 lg:grid-cols-2 gap-8"> | |
| {/* Messages Chart */} | |
| <div className="bg-white p-8 rounded-3xl border border-slate-100 shadow-sm"> | |
| <h3 className="text-lg font-bold text-slate-800 mb-6 flex items-center gap-2"> | |
| {t('analytics.messages.title')} | |
| </h3> | |
| <div className="h-64 min-h-[256px] w-full"> | |
| <ResponsiveContainer width="100%" height="100%"> | |
| <BarChart data={messageData} margin={{ top: 10, right: 10, left: -20, bottom: 0 }}> | |
| <CartesianGrid strokeDasharray="3 3" vertical={false} stroke="#f1f5f9" /> | |
| <XAxis dataKey="name" axisLine={false} tickLine={false} tick={{fill: '#94a3b8', fontSize: 12}} /> | |
| <YAxis axisLine={false} tickLine={false} tick={{fill: '#94a3b8', fontSize: 12}} /> | |
| <Tooltip | |
| contentStyle={{borderRadius: '16px', border: 'none', boxShadow: '0 10px 15px -3px rgb(0 0 0 / 0.1)'}} | |
| /> | |
| <Bar dataKey="value" fill="#6366f1" radius={[8, 8, 0, 0]} barSize={40} /> | |
| </BarChart> | |
| </ResponsiveContainer> | |
| </div> | |
| </div> | |
| {/* Completion Pie */} | |
| <div className="bg-white p-8 rounded-3xl border border-slate-100 shadow-sm"> | |
| <h3 className="text-lg font-bold text-slate-800 mb-6">{t('analytics.completion.title')}</h3> | |
| <div className="h-64 min-h-[256px] w-full flex items-center"> | |
| <ResponsiveContainer width="100%" height="100%"> | |
| <PieChart> | |
| <Pie | |
| data={completionData} | |
| cx="50%" | |
| cy="50%" | |
| innerRadius={60} | |
| outerRadius={80} | |
| paddingAngle={5} | |
| dataKey="value" | |
| > | |
| {completionData.map((_, index) => ( | |
| <Cell key={`cell-${index}`} fill={COLORS[index % COLORS.length]} /> | |
| ))} | |
| </Pie> | |
| <Tooltip /> | |
| </PieChart> | |
| </ResponsiveContainer> | |
| <div className="space-y-4 pr-8"> | |
| {completionData.map((d, i) => ( | |
| <div key={d.name} className="flex items-center gap-2"> | |
| <div className="w-3 h-3 rounded-full" style={{backgroundColor: COLORS[i]}} /> | |
| <span className="text-xs text-slate-500 font-medium">{d.name}: {d.value}</span> | |
| </div> | |
| ))} | |
| </div> | |
| </div> | |
| </div> | |
| </div> | |
| {/* Detailed Pedagogy */} | |
| <div className="bg-slate-900 text-white rounded-3xl p-10 overflow-hidden relative"> | |
| <div className="absolute top-0 right-0 w-64 h-64 bg-indigo-500/10 blur-3xl rounded-full -mr-20 -mt-20" /> | |
| <div className="relative z-10 grid grid-cols-1 md:grid-cols-3 gap-12"> | |
| <div> | |
| <div className="flex items-center gap-3 text-indigo-300 mb-4 font-bold uppercase tracking-widest text-[10px]"> | |
| <Award className="w-4 h-4" /> {t('analytics.performance.title')} | |
| </div> | |
| <div className="text-4xl font-bold mb-1">{pedagogy?.performance?.averageScore?.toFixed(1) || 0}</div> | |
| <div className="text-sm text-slate-400">{t('analytics.performance.avg_score')}</div> | |
| </div> | |
| <div> | |
| <div className="flex items-center gap-3 text-indigo-300 mb-4 font-bold uppercase tracking-widest text-[10px]"> | |
| <Clock className="w-4 h-4" /> {t('analytics.engagement.title')} | |
| </div> | |
| <div className="text-4xl font-bold mb-1">{pedagogy?.performance?.averageProgressDays?.toFixed(1) || 0}</div> | |
| <div className="text-sm text-slate-400">{t('analytics.engagement.avg_days')}</div> | |
| </div> | |
| <div className="flex items-end justify-end"> | |
| <button className="bg-white/10 hover:bg-white/20 transition px-6 py-3 rounded-xl text-sm font-bold flex items-center gap-2"> | |
| {t('analytics.export')} <ChevronRight className="w-4 h-4" /> | |
| </button> | |
| </div> | |
| </div> | |
| </div> | |
| {/* ββ AI Cost Breakdown βββββββββββββββββββββββββββββββββββββββββββ */} | |
| {usage?.costs?.byFeature?.length > 0 && ( | |
| <div className="bg-white rounded-3xl border border-slate-100 shadow-sm p-8"> | |
| <div className="flex items-center gap-3 mb-6"> | |
| <div className="p-2.5 bg-purple-50 rounded-xl"> | |
| <BrainCircuit className="w-5 h-5 text-purple-600" /> | |
| </div> | |
| <div> | |
| <h2 className="font-bold text-slate-800">{t('analytics.ai_cost_title')}</h2> | |
| <p className="text-xs text-slate-400">{t('analytics.ai_cost_subtitle')}</p> | |
| </div> | |
| </div> | |
| <div className="overflow-x-auto"> | |
| <table className="w-full text-sm"> | |
| <thead> | |
| <tr className="text-left text-xs text-slate-400 uppercase tracking-wider border-b border-slate-100"> | |
| <th className="pb-3 font-semibold">{t('analytics.col_feature')}</th> | |
| <th className="pb-3 font-semibold text-right">{t('analytics.col_calls')}</th> | |
| <th className="pb-3 font-semibold text-right">{t('analytics.col_tokens_in')}</th> | |
| <th className="pb-3 font-semibold text-right">{t('analytics.col_tokens_out')}</th> | |
| <th className="pb-3 font-semibold text-right">{t('analytics.col_cost')}</th> | |
| </tr> | |
| </thead> | |
| <tbody className="divide-y divide-slate-50"> | |
| {(usage.costs.byFeature as Array<{ feature: string; calls: number; tokensIn: number; tokensOut: number; costUsd: number }>) | |
| .sort((a, b) => b.costUsd - a.costUsd) | |
| .map((row) => ( | |
| <tr key={row.feature} className="hover:bg-slate-50 transition"> | |
| <td className="py-3 font-medium text-slate-700"> | |
| <span className="px-2 py-0.5 bg-purple-50 text-purple-700 rounded-full text-[11px] font-mono">{row.feature}</span> | |
| </td> | |
| <td className="py-3 text-right text-slate-600">{row.calls.toLocaleString()}</td> | |
| <td className="py-3 text-right text-slate-500">{row.tokensIn.toLocaleString()}</td> | |
| <td className="py-3 text-right text-slate-500">{row.tokensOut.toLocaleString()}</td> | |
| <td className="py-3 text-right font-bold text-slate-800">${row.costUsd.toFixed(4)}</td> | |
| </tr> | |
| ))} | |
| </tbody> | |
| <tfoot className="border-t-2 border-slate-200"> | |
| <tr> | |
| <td className="pt-3 font-bold text-slate-800" colSpan={4}>{t('analytics.total')}</td> | |
| <td className="pt-3 text-right font-bold text-purple-700">${(usage.costs.totalUsd as number).toFixed(4)}</td> | |
| </tr> | |
| </tfoot> | |
| </table> | |
| </div> | |
| </div> | |
| )} | |
| {/* ββ Text-to-SQL Search βββββββββββββββββββββββββββββββββββββββββββ */} | |
| <div className="bg-white rounded-3xl border border-slate-100 shadow-sm p-8"> | |
| <div className="flex items-center gap-3 mb-6"> | |
| <div className="p-2.5 bg-violet-50 rounded-xl"> | |
| <Search className="w-5 h-5 text-violet-600" /> | |
| </div> | |
| <div> | |
| <h2 className="font-bold text-slate-800">{t('analytics.nl_search_title')}</h2> | |
| <p className="text-xs text-slate-400">{t('analytics.nl_search_subtitle')}</p> | |
| </div> | |
| </div> | |
| {/* Example questions */} | |
| <div className="flex flex-wrap gap-2 mb-4"> | |
| {EXAMPLE_QUESTIONS.map(q => ( | |
| <button | |
| key={q} | |
| onClick={() => { setSqlQuestion(q); sqlInputRef.current?.focus(); }} | |
| className="text-[11px] px-3 py-1.5 bg-slate-50 hover:bg-violet-50 hover:text-violet-700 text-slate-500 rounded-full border border-slate-200 hover:border-violet-200 transition" | |
| > | |
| {q} | |
| </button> | |
| ))} | |
| </div> | |
| <form onSubmit={handleSqlQuery} className="flex gap-3"> | |
| <input | |
| ref={sqlInputRef} | |
| type="text" | |
| value={sqlQuestion} | |
| onChange={e => setSqlQuestion(e.target.value)} | |
| placeholder={t('analytics.nl_search_placeholder')} | |
| className="flex-1 px-4 py-3 rounded-xl border border-slate-200 text-sm focus:outline-none focus:ring-2 focus:ring-violet-300 bg-slate-50" | |
| /> | |
| <button | |
| type="submit" | |
| disabled={sqlLoading || !sqlQuestion.trim()} | |
| className="px-5 py-3 bg-violet-600 hover:bg-violet-700 disabled:opacity-40 text-white text-sm font-bold rounded-xl flex items-center gap-2 transition" | |
| > | |
| {sqlLoading ? <Loader2 className="w-4 h-4 animate-spin" /> : <Search className="w-4 h-4" />} | |
| {t('analytics.search_btn')} | |
| </button> | |
| </form> | |
| {/* Error */} | |
| {sqlError && ( | |
| <div className="mt-4 p-4 bg-red-50 border border-red-100 rounded-xl text-sm text-red-600"> | |
| {sqlError} | |
| </div> | |
| )} | |
| {/* Results */} | |
| {sqlResult && ( | |
| <div className="mt-5"> | |
| <div className="flex items-center justify-between mb-3"> | |
| <span className="text-xs font-bold text-slate-500">{sqlResult.count} rΓ©sultat{sqlResult.count > 1 ? 's' : ''}</span> | |
| <button | |
| onClick={() => setSqlResult(r => r ? { ...r, _showSql: !((r as any)._showSql) } as any : r)} | |
| className="flex items-center gap-1.5 text-[11px] text-slate-400 hover:text-slate-600 transition" | |
| > | |
| <Terminal className="w-3.5 h-3.5" /> {t('analytics.view_sql')} | |
| </button> | |
| </div> | |
| {(sqlResult as any)._showSql && ( | |
| <pre className="mb-4 p-3 bg-slate-900 text-emerald-400 text-[11px] rounded-xl overflow-x-auto"> | |
| {sqlResult.sql} | |
| </pre> | |
| )} | |
| {sqlResult.rows.length > 0 ? ( | |
| <div className="overflow-x-auto rounded-xl border border-slate-100"> | |
| <table className="w-full text-sm"> | |
| <thead className="bg-slate-50 text-xs text-slate-500 uppercase"> | |
| <tr> | |
| {Object.keys(sqlResult.rows[0]).map(col => ( | |
| <th key={col} className="px-4 py-3 text-left font-bold">{col}</th> | |
| ))} | |
| </tr> | |
| </thead> | |
| <tbody className="divide-y divide-slate-50"> | |
| {sqlResult.rows.map((row, i) => ( | |
| <tr key={i} className="hover:bg-slate-50/50"> | |
| {Object.values(row).map((val, j) => ( | |
| <td key={j} className="px-4 py-2.5 text-slate-700 text-xs"> | |
| {val === null ? <span className="text-slate-300">β</span> : String(val)} | |
| </td> | |
| ))} | |
| </tr> | |
| ))} | |
| </tbody> | |
| </table> | |
| </div> | |
| ) : ( | |
| <div className="text-center py-6 text-slate-400 text-sm">{t('analytics.no_results')}</div> | |
| )} | |
| </div> | |
| )} | |
| </div> | |
| </div> | |
| ); | |
| } | |
| function StatCard({ title, value, icon, trend, color, bg }: any) { | |
| return ( | |
| <div className="bg-white p-6 rounded-3xl border border-slate-100 shadow-sm hover:shadow-md transition group"> | |
| <div className="flex items-center justify-between mb-4"> | |
| <div className={`p-3 rounded-2xl ${bg} ${color} transition-colors`}> | |
| {icon} | |
| </div> | |
| {trend != null && ( | |
| <div className="text-[10px] font-bold bg-slate-50 text-slate-400 px-2 py-1 rounded-lg uppercase"> | |
| {trend} | |
| </div> | |
| )} | |
| </div> | |
| <div> | |
| <div className="text-sm text-slate-500 font-medium mb-1">{title}</div> | |
| <div className="text-2xl font-bold text-slate-900">{value}</div> | |
| </div> | |
| </div> | |
| ); | |
| } | |
| function Building2(props: any) { | |
| return ( | |
| <svg | |
| {...props} | |
| xmlns="http://www.w3.org/2000/svg" | |
| width="24" | |
| height="24" | |
| viewBox="0 0 24 24" | |
| fill="none" | |
| stroke="currentColor" | |
| strokeWidth="2" | |
| strokeLinecap="round" | |
| strokeLinejoin="round" | |
| > | |
| <rect width="16" height="20" x="4" y="2" rx="2" ry="2" /> | |
| <path d="M9 22v-4h6v4" /> | |
| <path d="M8 6h.01" /> | |
| <path d="M16 6h.01" /> | |
| <path d="M12 6h.01" /> | |
| <path d="M12 10h.01" /> | |
| <path d="M12 14h.01" /> | |
| <path d="M16 10h.01" /> | |
| <path d="M16 14h.01" /> | |
| <path d="M8 10h.01" /> | |
| <path d="M8 14h.01" /> | |
| </svg> | |
| ); | |
| } | |