// ─────────────────────────────────────────────────────────── // Huio Control Panel — Main App & Views (cp-app.jsx) // ─────────────────────────────────────────────────────────── const { useState, useEffect, useRef } = React; // ───── VALIDATE & UNPACK EXTERNAL SHELL MODULES ───── if (!window.CP_TRANSLATIONS) throw new Error('[cp-app] window.CP_TRANSLATIONS not loaded (check cp-translations.jsx)'); if (!window.CP_MOCK_DATA) throw new Error('[cp-app] window.CP_MOCK_DATA not loaded (check cp-mock-data.jsx)'); if (!window.CP_STYLES) throw new Error('[cp-app] window.CP_STYLES not loaded (check cp-styles.jsx)'); if (!window.CpCharts) throw new Error('[cp-app] window.CpCharts not loaded (check cp-charts.jsx)'); if (!window.CpDocsViews) throw new Error('[cp-app] window.CpDocsViews not loaded (check cp-docs-views.jsx)'); if (!window.CpErrorsView) throw new Error('[cp-app] window.CpErrorsView not loaded (check cp-errors-view.jsx)'); if (!window.CpBotLogsView) throw new Error('[cp-app] window.CpBotLogsView not loaded (check cp-bot-logs-view.jsx)'); if (!window.CpChatLogsView) throw new Error('[cp-app] window.CpChatLogsView not loaded (check cp-chat-logs-view.jsx)'); if (!window.CpFeedbackView) throw new Error('[cp-app] window.CpFeedbackView not loaded (check cp-feedback-view.jsx)'); if (!window.CpSupportView) throw new Error('[cp-app] window.CpSupportView not loaded (check cp-support-view.jsx)'); if (!window.CpBroadcastView) throw new Error('[cp-app] window.CpBroadcastView not loaded (check cp-broadcast-view.jsx)'); if (!window.CpSystemView) throw new Error('[cp-app] window.CpSystemView not loaded (check cp-system-view.jsx)'); if (!window.CpActivityLogsView) throw new Error('[cp-app] window.CpActivityLogsView not loaded (check cp-activity-logs-view.jsx)'); if (!window.CpDisputesView) throw new Error('[cp-app] window.CpDisputesView not loaded (check cp-disputes-view.jsx)'); if (!window.CpCccdView) throw new Error('[cp-app] window.CpCccdView not loaded (check cp-cccd-view.jsx)'); if (!window.CpWaitlistView) throw new Error('[cp-app] window.CpWaitlistView not loaded (check cp-waitlist-view.jsx)'); if (!window.CpGroupsView) throw new Error('[cp-app] window.CpGroupsView not loaded (check cp-groups-view.jsx)'); if (!window.CpDashboardView) throw new Error('[cp-app] window.CpDashboardView not loaded (check cp-dashboard-view.jsx)'); if (!window.CpAnalyticsView) throw new Error('[cp-app] window.CpAnalyticsView not loaded (check cp-analytics-view.jsx)'); if (!window.CpUsersView) throw new Error('[cp-app] window.CpUsersView not loaded (check cp-users-view.jsx)'); if (!window.CpPaymentsView) throw new Error('[cp-app] window.CpPaymentsView not loaded (check cp-payments-view.jsx)'); if (!window.CpReferralView) throw new Error('[cp-app] window.CpReferralView not loaded (check cp-referral-view.jsx)'); const { CP_TRANSLATIONS: TRANSLATIONS, CP_STYLES: appStyles, CP_MOCK_DATA: { INITIAL_USERS, INITIAL_GROUPS, INITIAL_CCCD_REQUESTS, INITIAL_RISK_ALERTS, INITIAL_DB_STATS, INITIAL_ANALYTICS_EVENTS, INITIAL_ERROR_LOGS, getInitialLogs, } } = window; // Allowed administrators whitelist (module scope) const ALLOWED_ADMINS = ['adbitmail@gmail.com', 'jamescook.quinn@gmail.com']; // Detect staging environment: hostname starts with cp-test. (e.g. cp-test.huio.app, cp-test.localhost) const isStagingEnv = typeof window !== 'undefined' && typeof window.location?.hostname === 'string' && window.location.hostname.startsWith('cp-test.'); // Production project credentials const PROD_SUPABASE_URL = 'https://qjuuaqdvhzzclsdwubll.supabase.co'; const PROD_SUPABASE_KEY = 'sb_publishable_Dt02ncAgzOf_aaZwSOa30Q__GSGjXNq'; // Staging project credentials (tczrwnmqkmqzroiavgyd) — public anon key only, NO service keys! const STAGING_SUPABASE_URL = 'https://tczrwnmqkmqzroiavgyd.supabase.co'; const STAGING_SUPABASE_KEY = 'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJzdXBhYmFzZSIsInJlZiI6InRjenJ3bm1xa21xenJvaWF2Z3lkIiwicm9sZSI6ImFub24iLCJpYXQiOjE3OTI1MDE3MjIsImV4cCI6MjEwODA3NzcyMn0.ht1ESNrAivfqAjduzhDHaBaOHNu_gC7kMCxFpv2kmoM'; // Global flags and dynamic defaults window.CP_IS_STAGING = isStagingEnv; window.CP_DEFAULT_SUPABASE_URL = isStagingEnv ? STAGING_SUPABASE_URL : PROD_SUPABASE_URL; const DEFAULT_SUPABASE_URL = window.CP_DEFAULT_SUPABASE_URL; const DEFAULT_SUPABASE_KEY = isStagingEnv ? STAGING_SUPABASE_KEY : PROD_SUPABASE_KEY; // ───── MAIN CONTROLLER COMPONENT ───── function HuioCpApp() { const [isAuthenticated, setIsAuthenticated] = useState(false); const [isAuthChecking, setIsAuthChecking] = useState(true); const [adminRole, setAdminRole] = useState('none'); const [authEmail, setAuthEmail] = useState(''); const [authPassword, setAuthPassword] = useState(''); const [isSigningIn, setIsSigningIn] = useState(false); const [authError, setAuthError] = useState(''); // Mark application as mounted to stop splash loading timeouts useEffect(() => { window.__CP_MOUNTED__ = true; if (isStagingEnv) { document.title = 'STAGING · test data — Huio Control Panel'; } }, []); // MFA / TOTP state const [showTotpEnroll, setShowTotpEnroll] = useState(false); const [showTotpChallenge, setShowTotpChallenge] = useState(false); const [totpEnrollData, setTotpEnrollData] = useState(null); const [mfaFactorId, setMfaFactorId] = useState(null); const [totpCode, setTotpCode] = useState(''); const [isVerifyingMfa, setIsVerifyingMfa] = useState(false); const [isEnrollingTotp, setIsEnrollingTotp] = useState(false); const [mfaError, setMfaError] = useState(''); const [pendingAdminUser, setPendingAdminUser] = useState(null); const [cpMfaRequired, setCpMfaRequired] = useState(false); const [hoveredStep, setHoveredStep] = useState(null); const [signedFrontUrl, setSignedFrontUrl] = useState(null); const [signedBackUrl, setSignedBackUrl] = useState(null); const [frontRotation, setFrontRotation] = useState(0); const [backRotation, setBackRotation] = useState(0); const [zoomImg, setZoomImg] = useState(null); const [activeTab, setActiveTabRaw] = useState(() => { const h = (typeof window !== 'undefined' && window.location.hash || '').replace(/^#\/?/, '').trim(); if (h.startsWith('user/')) return 'user_detail'; if (h) return h; return 'dashboard'; }); const [mobileMenuOpen, setMobileMenuOpen] = useState(false); const [selectedOrganizerId, setSelectedOrganizerId] = useState(() => { const h = (typeof window !== 'undefined' && window.location.hash || '').replace(/^#\/?/, '').trim(); return h.startsWith('user/') ? h.slice(5).trim() : null; }); const [isOrganizerModalOpen, setIsOrganizerModalOpen] = useState(false); const [telegramLinkToken, setTelegramLinkToken] = useState(null); const [isGeneratingTgToken, setIsGeneratingTgToken] = useState(false); const [urgentStats, setUrgentStats] = useState({ bankReviewCount: 0, dlqCount: 0 }); const [lang, setLang] = useState(() => { try { const saved = localStorage.getItem('huio-cp-lang'); if (saved === 'vi' || saved === 'en') return saved; } catch (e) {} const browserLang = typeof navigator !== 'undefined' ? (navigator.language || navigator.userLanguage) : ''; if (browserLang && browserLang.startsWith('vi')) { return 'vi'; } return 'en'; }); // App States const [users, setUsers] = useState(INITIAL_USERS); const usersRef = useRef(INITIAL_USERS); useEffect(() => { usersRef.current = users; }, [users]); // Member Registry Controls (Search, Filters, Sort, Pagination) const [userSearchQuery, setUserSearchQuery] = useState(''); const [userRoleFilter, setUserRoleFilter] = useState('all'); const [userPlanFilter, setUserPlanFilter] = useState('all'); const [userStatusFilter, setUserStatusFilter] = useState('all'); const [userSortBy, setUserSortBy] = useState('last_active_desc'); const [userPage, setUserPage] = useState(1); const [userPerPage, setUserPerPage] = useState(10); const [groups, setGroups] = useState(INITIAL_GROUPS); const groupsRef = useRef(INITIAL_GROUPS); useEffect(() => { groupsRef.current = groups; }, [groups]); const [cccdRequests, setCccdRequests] = useState(INITIAL_CCCD_REQUESTS); const [riskAlerts, setRiskAlerts] = useState(INITIAL_RISK_ALERTS); const [waitlistEntries, setWaitlistEntries] = useState([]); const [dbStats, setDbStats] = useState(INITIAL_DB_STATS); const [logs, setLogs] = useState([]); const [analyticsEvents, setAnalyticsEvents] = useState(INITIAL_ANALYTICS_EVENTS); const [errorLogs, setErrorLogs] = useState(INITIAL_ERROR_LOGS); // Organizer Payments Journal (P0) const [payments, setPayments] = useState([]); const [paymentsReport, setPaymentsReport] = useState(null); const [paymentsLoading, setPaymentsLoading] = useState(false); const [paymentFilters, setPaymentFilters] = useState({ search: '', method: 'all', status: 'all' }); const [recordPaymentModalOpen, setRecordPaymentModalOpen] = useState(false); const [paymentModalUser, setPaymentModalUser] = useState(null); const [paymentModalPlan, setPaymentModalPlan] = useState('organizer_pro'); const [paymentAdmins, setPaymentAdmins] = useState([]); // Organizer Referral Program (r1) const [referralOverview, setReferralOverview] = useState(null); const [referralLoading, setReferralLoading] = useState(false); const [disputes, setDisputes] = useState([]); const [disputesFilter, setDisputesFilter] = useState('pending'); const [resolvingReportId, setResolvingReportId] = useState(null); // Bot Logs state & filters const [botLogs, setBotLogs] = useState([]); const [isLoadingMoreBotLogs, setIsLoadingMoreBotLogs] = useState(false); const [hasMoreBotLogs, setHasMoreBotLogs] = useState(true); const [botLogsSearch, setBotLogsSearch] = useState(''); const [botLogsDateFilter, setBotLogsDateFilter] = useState(''); const [botLogsUserFilter, setBotLogsUserFilter] = useState('all'); const [botLogsCurrentPage, setBotLogsCurrentPage] = useState(1); const botLogsPerPage = 20; const [selectedBotChat, setSelectedBotChat] = useState(null); // Chat Logs state & filters const [chatLogs, setChatLogs] = useState([]); const [chatLogsSearch, setChatLogsSearch] = useState(''); const [chatLogsDateFilter, setChatLogsDateFilter] = useState(''); const [chatLogsGroupFilter, setChatLogsGroupFilter] = useState('all'); const [bankIntegrations, setBankIntegrations] = useState([]); const [auctionStreakAlerts, setAuctionStreakAlerts] = useState([]); const [chatLogsCurrentPage, setChatLogsCurrentPage] = useState(1); const chatLogsPerPage = 20; const [chatReadReceipts, setChatReadReceipts] = useState([]); const [signedGroupImgUrls, setSignedGroupImgUrls] = useState({}); const signedGroupImgUrlsRef = useRef({}); useEffect(() => { signedGroupImgUrlsRef.current = signedGroupImgUrls; }, [signedGroupImgUrls]); useEffect(() => { let isMounted = true; const resolveGroupImages = async () => { const pathsToSign = []; const pathToFullUrl = {}; const currentSigned = signedGroupImgUrlsRef.current || {}; for (const log of chatLogs) { if (log.image_url && log.image_url.includes('/chat-attachments/') && !currentSigned[log.image_url]) { const rawPath = log.image_url.split('/chat-attachments/')[1]; const cleanPath = rawPath ? decodeURIComponent(rawPath.split('?')[0]) : null; if (cleanPath && !pathsToSign.includes(cleanPath)) { pathsToSign.push(cleanPath); pathToFullUrl[cleanPath] = log.image_url; } } } if (pathsToSign.length === 0) return; const pendingMap = {}; pathsToSign.forEach(path => { pendingMap[pathToFullUrl[path]] = 'pending'; }); setSignedGroupImgUrls(prev => ({ ...prev, ...pendingMap })); try { const chunkSize = 50; const allResolved = {}; for (let i = 0; i < pathsToSign.length; i += chunkSize) { const chunk = pathsToSign.slice(i, i + chunkSize); const { data, error } = await supabaseClient.storage.from('chat-attachments').createSignedUrls(chunk, 3600); if (isMounted && data && Array.isArray(data)) { data.forEach((item, idx) => { const fullUrl = (item.path && pathToFullUrl[item.path]) || pathToFullUrl[chunk[idx]]; if (item.signedUrl && fullUrl) { allResolved[fullUrl] = item.signedUrl; } else if (fullUrl) { allResolved[fullUrl] = 'error'; } }); } else if (error) { chunk.forEach(p => { if (pathToFullUrl[p]) allResolved[pathToFullUrl[p]] = 'error'; }); } } if (isMounted) { setSignedGroupImgUrls(prev => ({ ...prev, ...allResolved })); } } catch (e) { console.error('Group chat images sign error:', e); if (isMounted) { const errorMap = {}; pathsToSign.forEach(p => { errorMap[pathToFullUrl[p]] = 'error'; }); setSignedGroupImgUrls(prev => ({ ...prev, ...errorMap })); } } }; if (chatLogs.length > 0 && supabaseClient) { resolveGroupImages(); } return () => { isMounted = false; }; }, [chatLogs, supabaseClient]); // Live Operations Logs state & filters const [logsCategoryFilter, setLogsCategoryFilter] = useState('all'); const [logsTypeFilter, setLogsTypeFilter] = useState('all'); const [logsSearchQuery, setLogsSearchQuery] = useState(''); const [logsCurrentPage, setLogsCurrentPage] = useState(1); const logsPerPage = 20; const [logsDateFilter, setLogsDateFilter] = useState(''); const [logsUserFilter, setLogsUserFilter] = useState('all'); // Analytics filters state const [eventFilter, setEventFilter] = useState('all'); const [platformFilter, setPlatformFilter] = useState('all'); const [searchQuery, setSearchQuery] = useState(''); // Error filters state & selected error const [errorFilter, setErrorFilter] = useState('all'); const [errorPlatformFilter, setErrorPlatformFilter] = useState('all'); const [selectedError, setSelectedError] = useState(null); const [errorTab, setErrorTab] = useState('raw'); const [showResolvedErrors, setShowResolvedErrors] = useState(false); const [isPromptModalOpen, setIsPromptModalOpen] = useState(false); const [promptText, setPromptText] = useState(''); const [copiedPrompt, setCopiedPrompt] = useState(false); // Feedback states const [feedbacks, setFeedbacks] = useState([]); const [feedbackSearchQuery, setFeedbackSearchQuery] = useState(''); const [feedbackCategoryFilter, setFeedbackCategoryFilter] = useState('all'); const [feedbackRatingFilter, setFeedbackRatingFilter] = useState('all'); const [feedbackStatusFilter, setFeedbackStatusFilter] = useState('all'); const [feedbackCurrentPage, setFeedbackCurrentPage] = useState(1); const feedbacksPerPage = 20; const [selectedFeedback, setSelectedFeedback] = useState(null); const [adminNotesInput, setAdminNotesInput] = useState(''); useEffect(() => { if (selectedFeedback) { setAdminNotesInput(selectedFeedback.admin_notes || ''); } else { setAdminNotesInput(''); } }, [selectedFeedback]); // Live Support Queue states (Sprint #30 MVP) const [supportQueue, setSupportQueue] = useState([]); const [supportLoading, setSupportLoading] = useState(false); const [supportFilter, setSupportFilter] = useState('all'); // 'all' | 'waiting' const [supportSearchQuery, setSupportSearchQuery] = useState(''); const [selectedSupportConv, setSelectedSupportConv] = useState(null); // Member Registry → Live Support (reuse CpSupportChatWidget / Option A desk) const [registrySupportTarget, setRegistrySupportTarget] = useState(null); const [registrySupportOpening, setRegistrySupportOpening] = useState(false); const openSupportChatForMember = async (member) => { if (!member?.id) return; // Demo admins: open widget; CpSupportChatWidget will no-op RPC without real client if (currentUser && (currentUser.email === 'demo-admin@huio.app' || currentUser.email === 'admin@huio.app')) { setRegistrySupportTarget({ user_id: member.id, user_name: member.name, user_phone: member.phone, conversation_id: null, demo: true, }); return; } if (!supabaseClient) return; setRegistrySupportOpening(true); try { const { data: convId, error } = await supabaseClient.rpc('get_or_create_huio_support_conversation', { p_user_id: member.id, }); if (error) throw error; setRegistrySupportTarget({ user_id: member.id, user_name: member.name, user_phone: member.phone, conversation_id: convId || null, }); } catch (e) { console.error('[openSupportChatForMember]', e); alert(t('users.action.message_error') || 'Could not open support chat.'); } finally { setRegistrySupportOpening(false); } }; const fetchSupportQueue = async (filter = supportFilter) => { if (!supabaseClient?.rpc) return; setSupportLoading(true); try { const { data, error } = await supabaseClient.rpc('get_support_inbox_queue', { p_filter: filter, p_limit: 100, p_offset: 0 }); if (error) throw error; setSupportQueue(data || []); } catch (e) { console.error('[fetchSupportQueue] error:', e); } finally { setSupportLoading(false); } }; const closeRegistrySupportChat = () => { setRegistrySupportTarget(null); if (activeTab === 'support') { fetchSupportQueue(supportFilter); } }; useEffect(() => { if (activeTab === 'support') { fetchSupportQueue(supportFilter); } }, [activeTab, supportFilter]); // Payments Journal fetch & mutation handlers (P0 + R2) const fetchPayments = async () => { if (!supabaseClient) return; setPaymentsLoading(true); try { const [paymentsRes, reportRes, adminsRes] = await Promise.all([ supabaseClient .from('organizer_payments') .select('*, organizer_payment_items(*)') .order('paid_at', { ascending: false }) .limit(200), supabaseClient.rpc('cp_payments_report', {}), supabaseClient .from('app_admins') .select('id, user_id, email, full_name, role') .eq('is_active', true), ]); if (paymentsRes.error) { console.error('Error fetching payments:', paymentsRes.error); } else { setPayments(paymentsRes.data || []); } if (reportRes.error) { console.error('Error fetching payments report:', reportRes.error); } else { setPaymentsReport(reportRes.data || null); } if (!adminsRes.error && adminsRes.data) { setPaymentAdmins(adminsRes.data); } } catch (err) { console.error('fetchPayments error:', err); } finally { setPaymentsLoading(false); } }; const handleOpenRecordPaymentModal = (user, plan) => { setPaymentModalUser(user); if (plan) { const p = String(plan).toLowerCase(); if (p.includes('business')) { setPaymentModalPlan('organizer_business'); } else if (p.includes('basic')) { setPaymentModalPlan('organizer_basic'); } else { setPaymentModalPlan('organizer_pro'); } } else { setPaymentModalPlan(null); } setRecordPaymentModalOpen(true); }; const handleRecordPayment = async (payload) => { if (!supabaseClient) throw new Error('Not connected to database'); const { data, error } = await supabaseClient.rpc('cp_record_organizer_payment', { p_user_id: payload.userId, p_paid_at: payload.paidAt, p_method: payload.method, p_external_ref: payload.externalRef, p_payer_name: payload.payerName, p_items: payload.items, p_plan: payload.plan, p_period_start: payload.periodStart, p_period_end: payload.periodEnd, p_note: payload.note, p_receipt_url: payload.receiptUrl || null, p_source: payload.source || 'manual', }); if (error) { console.error('[cp_record_organizer_payment] error:', error); throw error; } await logAdminAction('payment.record', 'payment', data?.payment_id || data?.id, { user_id: payload.userId, amount_vnd: payload.items?.reduce((s, it) => s + (Number(it.amount_vnd || 0) * Number(it.quantity || 1)), 0), plan: payload.plan, method: payload.method, payer_name: payload.payerName, receipt_url: payload.receiptUrl || null, source: payload.source || 'manual', }); await fetchPayments(); if (typeof loadRealtimeData === 'function') { loadRealtimeData(supabaseClient); } return data; }; const handleResolveUnmatchedPayment = async ({ unmatchedId, userId, plan, periodStart, periodEnd, note }) => { if (!supabaseClient) throw new Error('Not connected to database'); const { data, error } = await supabaseClient.rpc('cp_resolve_unmatched_payment', { p_unmatched_id: unmatchedId, p_user_id: userId, p_plan: plan, p_period_start: periodStart, p_period_end: periodEnd, p_note: note || null, }); if (error) { console.error('[cp_resolve_unmatched_payment] error:', error); throw error; } await logAdminAction('payment.unmatched_resolve', 'payment', data?.payment_id, { unmatched_id: unmatchedId, user_id: userId, plan, amount_vnd: data?.amount_vnd, }); await fetchPayments(); if (typeof loadRealtimeData === 'function') { loadRealtimeData(supabaseClient); } return data; }; const handleRefundPayment = async (paymentId, refundAmount, reason) => { if (!supabaseClient) throw new Error('Not connected to database'); const { data, error } = await supabaseClient.rpc('cp_refund_organizer_payment', { p_payment_id: paymentId, p_amount: refundAmount, p_reason: reason, }); if (error) { console.error('[cp_refund_organizer_payment] error:', error); throw error; } await logAdminAction('payment.refund', 'payment', paymentId, { refund_amount_vnd: refundAmount, reason: reason, }); await fetchPayments(); if (typeof loadRealtimeData === 'function') { loadRealtimeData(supabaseClient); } return data; }; const handleSetTester = async (userId, isTester) => { if (!supabaseClient) throw new Error('Not connected to database'); const { data, error } = await supabaseClient.rpc('cp_set_tester', { p_user_id: userId, p_is_tester: Boolean(isTester) }); if (error) { console.error('[cp_set_tester] error:', error); throw error; } setUsers(prev => prev.map(u => u.id === userId ? { ...u, isTester: Boolean(isTester) } : u)); if (typeof loadRealtimeData === 'function') { loadRealtimeData(supabaseClient); } return data; }; const handleSetDemo = async (userId, isDemo) => { if (!supabaseClient) throw new Error('Not connected to database'); const { data, error } = await supabaseClient.rpc('cp_set_demo', { p_user_id: userId, p_is_demo: Boolean(isDemo) }); if (error) { console.error('[cp_set_demo] error:', error); throw error; } setUsers(prev => prev.map(u => u.id === userId ? { ...u, isDemo: Boolean(isDemo) } : u)); if (typeof loadRealtimeData === 'function') { loadRealtimeData(supabaseClient); } return data; }; const handleVoidPayment = async (paymentId, reason) => { if (!supabaseClient) throw new Error('Not connected to database'); const { data, error } = await supabaseClient.rpc('cp_void_organizer_payment', { p_payment_id: paymentId, p_reason: reason, }); if (error) { console.error('[cp_void_organizer_payment] error:', error); throw error; } await logAdminAction('payment.void', 'payment', paymentId, { reason: reason, }); await fetchPayments(); if (typeof loadRealtimeData === 'function') { loadRealtimeData(supabaseClient); } return data; }; useEffect(() => { if (activeTab === 'payments' && supabaseClient) { fetchPayments(); } }, [activeTab, supabaseClient]); // Referral Program fetch & mutation handlers (r1) const fetchReferralOverview = async () => { if (!supabaseClient) return; setReferralLoading(true); try { const { data, error } = await supabaseClient.rpc('cp_get_referral_overview'); if (error) { console.error('Error fetching referral overview:', error); } else { setReferralOverview(data || null); } } catch (err) { console.error('fetchReferralOverview error:', err); } finally { setReferralLoading(false); } }; const handleUpdateReferralSettings = async (settings) => { if (!supabaseClient) throw new Error('Not connected to database'); const { data, error } = await supabaseClient.rpc('cp_update_referral_settings', { p_program_enabled: settings.program_enabled, p_allowlist_only: settings.allowlist_only, p_hold_days: settings.hold_days ?? settings.hold_period_days, p_min_payout_vnd: settings.min_payout_vnd ?? settings.min_payout_amount, p_payouts_enabled: settings.payouts_enabled, p_tier1_bps: settings.tier1_bps, p_tier2_bps: settings.tier2_bps, p_tier2_from_rank: settings.tier2_from_rank, p_annual_bps: settings.annual_bps, }); if (error) { alert('Lỗi cập nhật cấu hình: ' + error.message); throw error; } await fetchReferralOverview(); return data; }; const handleAddReferralPartner = async (userId, notes) => { if (!supabaseClient) return; const { data, error } = await supabaseClient.rpc('cp_add_referral_partner', { p_user_id: userId, p_notes: notes || null, }); if (error) { alert('Lỗi thêm đối tác CTV: ' + error.message); return; } await fetchReferralOverview(); return data; }; const handleToggleReferralPartner = async (userId, enabled) => { if (!supabaseClient) return; const { error } = await supabaseClient.rpc('cp_toggle_referral_partner', { p_user_id: userId, p_enabled: enabled, }); if (error) { alert('Lỗi cập nhật trạng thái đối tác: ' + error.message); return; } await fetchReferralOverview(); }; const handleCalculateQuarterlyBonuses = async (quarterStart) => { if (!supabaseClient) return; const { data, error } = await supabaseClient.rpc('referral_calculate_quarterly_bonuses', { p_quarter_start: quarterStart || null, }); if (error) { alert('Lỗi tính thưởng quý: ' + error.message); return; } alert(`Kết quả tính thưởng quý:\n- Quý: ${data?.quarter}\n- Số đối tác được thưởng: ${data?.bonuses_awarded_count || 0}\n- Tổng tiền: ${(data?.total_bonus_vnd || 0).toLocaleString('vi-VN')} ₫`); await fetchReferralOverview(); return data; }; const handleToggleReferralAllowlist = async (userId, isAllowed, notes) => { if (!supabaseClient) return; const { error } = await supabaseClient.rpc('cp_toggle_referral_allowlist', { p_user_id: userId, p_enabled: isAllowed, }); if (error) { alert('Lỗi cập nhật allowlist: ' + error.message); return; } await fetchReferralOverview(); }; const handleUpdateAttributionStatus = async (refereeId, status, reason) => { if (!supabaseClient) return; const { error } = await supabaseClient.rpc('cp_update_attribution_status', { p_referee_id: refereeId, p_status: status, p_reason: reason || null, }); if (error) { alert('Lỗi cập nhật liên kết: ' + error.message); return; } await fetchReferralOverview(); }; const handleCreateReferralPayoutBatch = async (notes) => { if (!supabaseClient) return; const { data, error } = await supabaseClient.rpc('cp_create_referral_payout_batch', {}); if (error) { alert('Lỗi tạo đợt chi trả: ' + error.message); return; } if (data && !data.success) { alert('Thông báo: ' + (data.error || 'Không có người đủ điều kiện chi trả')); } await fetchReferralOverview(); }; const handleRefreshCommissionsStatus = async () => { if (!supabaseClient) return; const { data, error } = await supabaseClient.rpc('refresh_referral_commissions_status'); if (error) { alert('Lỗi cập nhật trạng thái hoa hồng: ' + error.message); return; } alert(`Đã cập nhật: ${data?.updated_to_available_count || 0} hoa hồng sang khả dụng, ${data?.expired_attributions_count || 0} liên kết hết hạn.`); await fetchReferralOverview(); }; useEffect(() => { if (activeTab === 'referral' && supabaseClient) { fetchReferralOverview(); } }, [activeTab, supabaseClient]); // Push Broadcast state const [broadcastTarget, setBroadcastTarget] = useState('all'); const [broadcastUserId, setBroadcastUserId] = useState(''); const [broadcastTitle, setBroadcastTitle] = useState(''); const [broadcastBody, setBroadcastBody] = useState(''); const [broadcastTitleEn, setBroadcastTitleEn] = useState(''); const [broadcastBodyEn, setBroadcastBodyEn] = useState(''); const [isBroadcasting, setIsBroadcasting] = useState(false); const logAdminAction = async (action, targetType, targetId, details = {}) => { if (!supabaseClient) return; try { const { data, error } = await supabaseClient.rpc('log_admin_action', { p_action: action, p_target_type: targetType, p_target_id: targetId ? String(targetId) : null, p_details: details, }); if (error) { console.error('[logAdminAction] RPC error:', error.message, { action, targetType, targetId }); } else { console.log('[logAdminAction] recorded:', action, targetType, targetId); } } catch (err) { console.error('[logAdminAction] unexpected error:', err); } }; const openOrganizerCard = (userOrId) => { if (!userOrId) return; const uid = typeof userOrId === 'object' && userOrId !== null ? (userOrId.id || userOrId.user_id) : userOrId; if (!uid || typeof uid !== 'string') return; setSelectedOrganizerId(uid); setIsOrganizerModalOpen(false); setActiveTabRaw('user_detail'); if (typeof window !== 'undefined') { window.location.hash = '#/user/' + uid; } }; const handleGenerateTelegramToken = async () => { if (!supabaseClient) return; setIsGeneratingTgToken(true); try { const { data, error } = await supabaseClient.rpc('cp_create_admin_telegram_token'); if (error) throw error; setTelegramLinkToken(data?.token || null); } catch (err) { alert(err.message || String(err)); } finally { setIsGeneratingTgToken(false); } }; const setActiveTab = (tabId) => { if (activeTab === 'broadcast' && tabId !== 'broadcast') { const hasUnsavedChanges = broadcastTitle.trim() || broadcastBody.trim() || broadcastTitleEn.trim() || broadcastBodyEn.trim(); if (hasUnsavedChanges) { const confirmLeave = confirm( lang === 'vi' ? 'Bạn có thay đổi chưa gửi trong phần Phát thông báo. Bạn có chắc chắn muốn rời đi?' : 'You have unsaved changes in the Broadcast Center. Are you sure you want to leave?' ); if (!confirmLeave) return; } } if (tabId !== 'user_detail') { setSelectedOrganizerId(null); } setActiveTabRaw(tabId); if (typeof window !== 'undefined') { window.location.hash = '#/' + tabId; } }; // Hash-routing listener for deep links (#/user/{id}, #/bank, #/payments, #/cccd, #/support, #/errors) useEffect(() => { const onHashChange = () => { const h = (window.location.hash || '').replace(/^#\/?/, '').trim(); if (!h) return; if (h.startsWith('user/')) { const uid = h.slice(5).trim(); if (uid) { setSelectedOrganizerId(uid); setIsOrganizerModalOpen(false); setActiveTabRaw('user_detail'); } } else { const validTabs = [ 'dashboard', 'cccd', 'risk', 'disputes', 'feedback', 'support', 'activity_logs', 'errors', 'bot_logs', 'chat_logs', 'users', 'bank', 'payments', 'referral', 'groups', 'waitlist', 'broadcast', 'analytics', 'system', 'roadmap', 'changelog' ]; if (validTabs.includes(h)) { setSelectedOrganizerId(null); setActiveTabRaw(h); } } }; window.addEventListener('hashchange', onHashChange); return () => window.removeEventListener('hashchange', onHashChange); }, []); // Auto-save Broadcast draft useEffect(() => { if (broadcastTitle.trim() || broadcastBody.trim() || broadcastTitleEn.trim() || broadcastBodyEn.trim()) { localStorage.setItem('huio_cp_broadcast_draft', JSON.stringify({ title: broadcastTitle, body: broadcastBody, titleEn: broadcastTitleEn, bodyEn: broadcastBodyEn, target: broadcastTarget, userId: broadcastUserId })); } else { localStorage.removeItem('huio_cp_broadcast_draft'); } }, [broadcastTitle, broadcastBody, broadcastTitleEn, broadcastBodyEn, broadcastTarget, broadcastUserId]); // Restore Broadcast draft on mount useEffect(() => { try { const saved = localStorage.getItem('huio_cp_broadcast_draft'); if (saved) { const draft = JSON.parse(saved); if (draft.title) setBroadcastTitle(draft.title); if (draft.body) setBroadcastBody(draft.body); if (draft.titleEn) setBroadcastTitleEn(draft.titleEn); if (draft.bodyEn) setBroadcastBodyEn(draft.bodyEn); if (draft.target) setBroadcastTarget(draft.target); if (draft.userId) setBroadcastUserId(draft.userId); } } catch (e) { console.warn('Failed to restore broadcast draft', e); } }, []); // Web page reload protection for Broadcast tab useEffect(() => { const handleBeforeUnload = (e) => { const hasUnsavedChanges = broadcastTitle.trim() || broadcastBody.trim() || broadcastTitleEn.trim() || broadcastBodyEn.trim(); if (activeTab === 'broadcast' && hasUnsavedChanges) { e.preventDefault(); e.returnValue = ''; return ''; } }; window.addEventListener('beforeunload', handleBeforeUnload); return () => { window.removeEventListener('beforeunload', handleBeforeUnload); }; }, [activeTab, broadcastTitle, broadcastBody, broadcastTitleEn, broadcastBodyEn]); // Clear filters when tab changes useEffect(() => { setSearchQuery(''); setEventFilter('all'); setPlatformFilter('all'); setErrorFilter('all'); setErrorPlatformFilter('all'); setErrorTab('raw'); setBroadcastTarget('all'); setBroadcastUserId(''); setBroadcastTitle(''); setBroadcastBody(''); setBroadcastTitleEn(''); setBroadcastBodyEn(''); setRoadmapFilter('all'); setRoadmapSearch(''); setChangelogSearch(''); setLogsCategoryFilter('all'); setLogsTypeFilter('all'); setLogsSearchQuery(''); setLogsCurrentPage(1); setFeedbackSearchQuery(''); setFeedbackCategoryFilter('all'); setFeedbackRatingFilter('all'); setFeedbackStatusFilter('all'); setFeedbackCurrentPage(1); setSelectedFeedback(null); }, [activeTab]); // Load initial logs on start or language switch useEffect(() => { if (!isConnected) { setLogs(getInitialLogs(lang)); } else if (supabaseClient) { loadLogsHistory(supabaseClient); } }, [lang, isConnected, supabaseClient]); // Settings modal & Supabase state const [isSettingsOpen, setIsSettingsOpen] = useState(false); const [isSyncDocModalOpen, setIsSyncDocModalOpen] = useState(false); const [supabaseUrl, setSupabaseUrl] = useState(() => { if (isStagingEnv) return STAGING_SUPABASE_URL; return (typeof window !== 'undefined' && window.localStorage?.getItem('huio-cp-sb-url')) || DEFAULT_SUPABASE_URL; }); const [supabaseKey, setSupabaseKey] = useState(() => { if (isStagingEnv) return STAGING_SUPABASE_KEY; return (typeof window !== 'undefined' && window.localStorage?.getItem('huio-cp-sb-key')) || DEFAULT_SUPABASE_KEY; }); const [isConnected, setIsConnected] = useState(false); const [currentUser, setCurrentUser] = useState(null); const [supabaseClient, setSupabaseClient] = useState(null); // Modal for inspecting CCCD request const [selectedRequest, setSelectedRequest] = useState(null); const [rejectReason, setRejectReason] = useState(''); const [processingCccdId, setProcessingCccdId] = useState(null); const [rejectError, setRejectError] = useState(false); // Group details modal / overlay state const [activeGroupDetail, setActiveGroupDetail] = useState(null); const [groupSlots, setGroupSlots] = useState([]); const [groupLedger, setGroupLedger] = useState([]); const [groupUnpaidContribs, setGroupUnpaidContribs] = useState([]); const [groupDetailTab, setGroupDetailTab] = useState('slots'); const [isGroupDetailLoading, setIsGroupDetailLoading] = useState(false); const [roadmapContent, setRoadmapContent] = useState(''); const [changelogContent, setChangelogContent] = useState(''); const [isRoadmapLoading, setIsRoadmapLoading] = useState(false); const [isChangelogLoading, setIsChangelogLoading] = useState(false); const [roadmapFilter, setRoadmapFilter] = useState('all'); const [roadmapSearch, setRoadmapSearch] = useState(''); const [changelogSearch, setChangelogSearch] = useState(''); const [changelogLimit, setChangelogLimit] = useState(10); useEffect(() => { if (activeTab === 'roadmap' && !roadmapContent) { setIsRoadmapLoading(true); fetch('./roadmap.md') .then(res => res.text()) .then(text => { setRoadmapContent(text); setIsRoadmapLoading(false); }) .catch(err => { console.error("Failed to load roadmap:", err); setIsRoadmapLoading(false); }); } if (activeTab === 'changelog' && !changelogContent) { setIsChangelogLoading(true); fetch('./changelog.md') .then(res => res.text()) .then(text => { setChangelogContent(text); setIsChangelogLoading(false); }) .catch(err => { console.error("Failed to load changelog:", err); setIsChangelogLoading(false); }); } }, [activeTab, roadmapContent, changelogContent]); // Persist language useEffect(() => { try { if (lang === 'vi' || lang === 'en') { localStorage.setItem('huio-cp-lang', lang); } } catch (e) {} }, [lang]); // Load custom theme on start useEffect(() => { const savedTheme = localStorage.getItem('huio-cp-theme') || 'candy'; document.documentElement.setAttribute('data-theme', savedTheme === 'editorial' ? 'light' : savedTheme); }, []); // Load real-time data from Supabase if authenticated and not in demo mode useEffect(() => { if (isAuthenticated && currentUser && currentUser.email !== 'demo-admin@huio.app' && currentUser.email !== 'admin@huio.app') { if (supabaseClient) { // Clear mock data immediately before loading real-time data setUsers([]); setGroups([]); setCccdRequests([]); setRiskAlerts([]); setDbStats([]); setAnalyticsEvents([]); setErrorLogs([]); loadRealtimeData(supabaseClient); } } }, [isAuthenticated, currentUser, supabaseClient]); // Load signed URLs for CCCD photos useEffect(() => { if (selectedRequest && supabaseClient) { setSignedFrontUrl(null); setSignedBackUrl(null); setFrontRotation(0); setBackRotation(0); const pathsToSign = []; const front = selectedRequest.frontPhotoUrl; const back = selectedRequest.backPhotoUrl; if (front) { if (front.startsWith('http')) setSignedFrontUrl(front); else pathsToSign.push(front); } if (back) { if (back.startsWith('http')) setSignedBackUrl(back); else pathsToSign.push(back); } if (pathsToSign.length > 0) { supabaseClient.storage .from('identity-docs') .createSignedUrls(pathsToSign, 300) .then(({ data, error }) => { if (!error && Array.isArray(data)) { data.forEach(item => { if (item.path === front && item.signedUrl) setSignedFrontUrl(item.signedUrl); if (item.path === back && item.signedUrl) setSignedBackUrl(item.signedUrl); }); } }) .catch(e => console.error('[IdentityVerificationModal] createSignedUrls error:', e)); } } else { setSignedFrontUrl(null); setSignedBackUrl(null); setFrontRotation(0); setBackRotation(0); } }, [selectedRequest, supabaseClient]); // Subscribe to risk alerts useEffect(() => { if (supabaseClient && isAuthenticated && currentUser && currentUser.email !== 'demo-admin@huio.app' && currentUser.email !== 'admin@huio.app') { const risksChan = supabaseClient .channel('public:risk_alerts') .on('postgres_changes', { event: '*', schema: 'public', table: 'risk_alerts' }, async (payload) => { if (payload.eventType === 'INSERT') { const { data: profData } = await supabaseClient.from('profiles').select('name, avatar_url, phone, plan').eq('id', payload.new.user_id).single(); const newAlert = { ...payload.new, profiles: profData || {} }; setRiskAlerts(prev => [newAlert, ...prev]); } else if (payload.eventType === 'UPDATE') { setRiskAlerts(prev => prev.map(a => a.id === payload.new.id ? { ...a, ...payload.new, profiles: a.profiles } : a)); } else if (payload.eventType === 'DELETE') { setRiskAlerts(prev => prev.filter(a => a.id !== payload.old.id)); } }) .subscribe(); return () => { supabaseClient.removeChannel(risksChan); }; } }, [supabaseClient, isAuthenticated, currentUser]); // Subscribe to real-time CCCD verification request additions useEffect(() => { if (supabaseClient && isAuthenticated && currentUser && currentUser.email !== 'demo-admin@huio.app' && currentUser.email !== 'admin@huio.app') { const channel = supabaseClient .channel('public:identity_verifications') .on( 'postgres_changes', { event: 'INSERT', schema: 'public', table: 'identity_verifications' }, (payload) => { console.log('New identity verification request:', payload.new); // Map the new request const newRequest = { id: payload.new.id, userId: payload.new.user_id, name: payload.new.full_name || 'Anonymous', cccdNum: payload.new.cccd_number || 'N/A', dob: payload.new.birth_date || 'N/A', status: payload.new.status, frontPhotoUrl: payload.new.front_photo_url, backPhotoUrl: payload.new.back_photo_url }; // Add to cccdRequests list if it's pending if (newRequest.status === 'pending') { setCccdRequests(prev => [newRequest, ...prev]); // Play a nice double chime notification sound using Web Audio API try { const audioContext = new (window.AudioContext || window.webkitAudioContext)(); const playBeep = (time, freq) => { const osc = audioContext.createOscillator(); const gain = audioContext.createGain(); osc.connect(gain); gain.connect(audioContext.destination); osc.frequency.setValueAtTime(freq, time); gain.gain.setValueAtTime(0.1, time); gain.gain.exponentialRampToValueAtTime(0.01, time + 0.3); osc.start(time); osc.stop(time + 0.3); }; playBeep(audioContext.currentTime, 587.33); // D5 playBeep(audioContext.currentTime + 0.12, 880); // A5 } catch (e) { console.warn("Audio Context notification failed:", e); } // Add a log const timestamp = new Date().toTimeString().split(' ')[0]; const logText = lang === 'vi' ? `Yêu cầu xác minh CCCD mới từ ${newRequest.name}!` : `New CCCD verification request from ${newRequest.name}!`; setLogs(prev => [ { id: Date.now(), timestamp: new Date(), time: timestamp, date: new Date().toISOString().split('T')[0], type: 'info', category: 'user', userId: newRequest.userId, userName: newRequest.name, text: logText }, ...prev ]); } } ) .subscribe(); return () => { supabaseClient.removeChannel(channel); }; } }, [supabaseClient, isAuthenticated, currentUser, lang]); // Subscribe to real-time app feedbacks useEffect(() => { if (supabaseClient && isAuthenticated && currentUser && currentUser.email !== 'demo-admin@huio.app' && currentUser.email !== 'admin@huio.app') { const channel = supabaseClient .channel('public:app_feedbacks_realtime') .on( 'postgres_changes', { event: 'INSERT', schema: 'public', table: 'app_feedbacks' }, async (payload) => { console.log('New feedback received:', payload.new); // Resolve user profile for the new feedback let userName = 'Anonymous'; let userPhone = ''; if (payload.new.user_id) { const { data: profileData } = await supabaseClient .from('profiles') .select('name, phone') .eq('id', payload.new.user_id) .single(); if (profileData) { userName = profileData.name; userPhone = profileData.phone; } } const newFeedback = { id: payload.new.id, user_id: payload.new.user_id, user_name: userName, user_phone: userPhone, category: payload.new.category, rating: payload.new.rating, message: payload.new.message, device_info: payload.new.device_info, status: payload.new.status, admin_notes: payload.new.admin_notes, created_at: payload.new.created_at }; setFeedbacks(prev => [newFeedback, ...prev]); // Play a nice double chime notification sound using Web Audio API (C5 and G5) try { const audioContext = new (window.AudioContext || window.webkitAudioContext)(); const playBeep = (time, freq) => { const osc = audioContext.createOscillator(); const gain = audioContext.createGain(); osc.connect(gain); gain.connect(audioContext.destination); osc.frequency.setValueAtTime(freq, time); gain.gain.setValueAtTime(0.08, time); gain.gain.exponentialRampToValueAtTime(0.01, time + 0.25); osc.start(time); osc.stop(time + 0.25); }; playBeep(audioContext.currentTime, 523.25); // C5 playBeep(audioContext.currentTime + 0.1, 783.99); // G5 } catch (e) { console.warn("Audio Context notification failed:", e); } // Add a log const timestamp = new Date().toTimeString().split(' ')[0]; const logText = lang === 'vi' ? `Góp ý mới từ ${userName}: ${newFeedback.message.substring(0, 40)}...` : `New feedback from ${userName}: ${newFeedback.message.substring(0, 40)}...`; setLogs(prev => [ { id: Date.now(), timestamp: new Date(), time: timestamp, date: new Date().toISOString().split('T')[0], type: 'info', category: 'user', userId: newFeedback.user_id, userName: userName, text: logText }, ...prev ]); } ) .subscribe(); return () => { supabaseClient.removeChannel(channel); }; } }, [supabaseClient, isAuthenticated, currentUser, lang]); // Subscribe to real-time operations telemetry (users, groups, auctions, transactions, members, etc) useEffect(() => { if (!supabaseClient || !isAuthenticated || !currentUser || currentUser.email === 'demo-admin@huio.app' || currentUser.email === 'admin@huio.app') { return; } // Helper functions for names resolution const getUserInfo = (userId, cb) => { if (!userId) return cb('Guest', ''); const found = usersRef.current.find(u => u.id === userId); if (found) { cb(found.name, found.phone); } else { supabaseClient .from('profiles') .select('name, phone') .eq('id', userId) .single() .then(({ data }) => { cb(data?.name || 'Anonymous', data?.phone || ''); }) .catch(() => cb('Anonymous', '')); } }; const getGroupNameStr = (groupId, cb) => { if (!groupId) return cb('Unknown Group'); const found = groupsRef.current.find(g => g.id === groupId); if (found) { cb(found.name); } else { supabaseClient .from('hui_groups') .select('name') .eq('id', groupId) .single() .then(({ data }) => { cb(data?.name || 'Unknown Group'); }) .catch(() => cb('Unknown Group')); } }; // Subscriptions channels const channels = []; // 1. Profiles Subscription (New users) const profilesChan = supabaseClient .channel('public:profiles_realtime') .on('postgres_changes', { event: 'INSERT', schema: 'public', table: 'profiles' }, (payload) => { const p = payload.new; const newUser = { id: p.id, name: p.name || p.full_name || 'Anonymous', phone: p.phone || '0000000000', role: p.role || 'participant', plan: 'free', status: 'unsigned', suspendedAt: p.suspended_at, pushToken: null, date: p.created_at ? p.created_at.split('T')[0] : new Date().toISOString().split('T')[0] }; setUsers(prev => [newUser, ...prev]); const timestamp = new Date().toTimeString().split(' ')[0]; const logText = lang === 'vi' ? `Thành viên mới ${newUser.name} đăng ký tài khoản qua số điện thoại ${newUser.phone}` : `New user ${newUser.name} registered with phone number ${newUser.phone}`; setLogs(prev => [ { id: p.id, timestamp: new Date(), time: timestamp, date: new Date().toISOString().split('T')[0], type: 'success', category: 'user', userId: newUser.id, userName: newUser.name, text: logText }, ...prev ]); }) .subscribe(); channels.push(profilesChan); // 2. Groups Subscription (Create/Update/Delete groups) const groupsChan = supabaseClient .channel('public:hui_groups_realtime') .on('postgres_changes', { event: 'INSERT', schema: 'public', table: 'hui_groups' }, (payload) => { const g = payload.new; getUserInfo(g.organizer_id, (orgName) => { const newGroup = { id: g.id, name: g.name, organizer: orgName, amount: g.contribution, members: g.total_periods, period: `${g.current_period} / ${g.total_periods}`, volume: Number(g.contribution) * Number(g.total_periods), status: g.status }; setGroups(prev => [newGroup, ...prev]); const timestamp = new Date().toTimeString().split(' ')[0]; const logText = lang === 'vi' ? `Dây hụi mới "${g.name}" được tạo bởi chủ thảo ${orgName}` : `New hụi group "${g.name}" created by organizer ${orgName}`; setLogs(prev => [ { id: g.id, timestamp: new Date(), time: timestamp, date: new Date().toISOString().split('T')[0], type: 'success', category: 'group', userId: g.organizer_id, userName: orgName, text: logText }, ...prev ]); }); }) .on('postgres_changes', { event: 'UPDATE', schema: 'public', table: 'hui_groups' }, (payload) => { const g = payload.new; const oldG = payload.old; // Update local groups list setGroups(prev => prev.map(item => item.id === g.id ? { ...item, name: g.name, amount: g.contribution, members: g.total_periods, period: `${g.current_period} / ${g.total_periods}`, status: g.status } : item)); const timestamp = new Date().toTimeString().split(' ')[0]; let logText = ''; if (g.status === 'closed' && oldG.status !== 'closed') { logText = lang === 'vi' ? `Dây hụi "${g.name}" đã được đưa vào lưu trữ (archived)` : `Hụi group "${g.name}" was archived by organizer`; } else if (g.status === 'completed' && oldG.status !== 'completed') { logText = lang === 'vi' ? `Dây hụi "${g.name}" đã hoàn thành tất cả các kỳ` : `Hụi group "${g.name}" successfully completed all cycles`; } else if (g.status === 'active' && oldG.status === 'draft') { logText = lang === 'vi' ? `Dây hụi "${g.name}" đã được kích hoạt thành công` : `Hụi group "${g.name}" successfully activated`; } else { logText = lang === 'vi' ? `Dây hụi "${g.name}" đã được cập nhật thông tin` : `Hụi group "${g.name}" details updated`; } if (logText) { setLogs(prev => [ { id: g.id + '-' + g.status, timestamp: new Date(), time: timestamp, date: new Date().toISOString().split('T')[0], type: 'info', category: 'group', userId: g.organizer_id, userName: groupsRef.current.find(item => item.id === g.id)?.organizer || '', text: logText }, ...prev ]); } }) .on('postgres_changes', { event: 'DELETE', schema: 'public', table: 'hui_groups' }, (payload) => { const deletedId = payload.old.id; const matched = groupsRef.current.find(item => item.id === deletedId); const name = matched ? matched.name : `ID: ${deletedId.substring(0,8)}`; setGroups(prev => prev.filter(item => item.id !== deletedId)); const timestamp = new Date().toTimeString().split(' ')[0]; const logText = lang === 'vi' ? `Dây hụi "${name}" đã bị xóa khỏi hệ thống` : `Hụi group "${name}" deleted from system`; setLogs(prev => [ { id: deletedId + '-deleted', timestamp: new Date(), time: timestamp, date: new Date().toISOString().split('T')[0], type: 'warning', category: 'group', userId: deletedId, userName: name, text: logText }, ...prev ]); }) .subscribe(); channels.push(groupsChan); // 3. Members Subscription (Join/Leave group) const membersChan = supabaseClient .channel('public:hui_members_realtime') .on('postgres_changes', { event: 'INSERT', schema: 'public', table: 'hui_members' }, (payload) => { const m = payload.new; getGroupNameStr(m.group_id, (groupName) => { const timestamp = new Date().toTimeString().split(' ')[0]; const logText = lang === 'vi' ? `Hội viên ${m.name} (${m.phone}) đã được thêm vào dây hụi "${groupName}"` : `Member ${m.name} (${m.phone}) was added to hụi group "${groupName}"`; setLogs(prev => [ { id: m.id, timestamp: new Date(), time: timestamp, date: new Date().toISOString().split('T')[0], type: 'info', category: 'member', userId: m.user_id, userName: m.name, text: logText }, ...prev ]); }); }) .on('postgres_changes', { event: 'DELETE', schema: 'public', table: 'hui_members' }, (payload) => { const timestamp = new Date().toTimeString().split(' ')[0]; const logText = lang === 'vi' ? `Một hội viên đã bị xóa hoặc rời khỏi dây hụi` : `A member was removed or left the hụi group`; setLogs(prev => [ { id: payload.old.id + '-member-delete', timestamp: new Date(), time: timestamp, date: new Date().toISOString().split('T')[0], type: 'warning', category: 'member', userId: payload.old.id, userName: '', text: logText }, ...prev ]); }) .subscribe(); channels.push(membersChan); // 4. Slot Ownership History Subscription (Transfers, replacements, withdrawals) const slotsHistoryChan = supabaseClient .channel('public:slot_ownership_history_realtime') .on('postgres_changes', { event: 'INSERT', schema: 'public', table: 'slot_ownership_history' }, (payload) => { const h = payload.new; // Batch fetch details of both members const getMemberDetails = async (fromId, toId, cb) => { let fromName = 'N/A'; let toName = 'Anonymous'; try { const memberIds = [fromId, toId].filter(Boolean); if (memberIds.length > 0) { const { data: mData } = await supabaseClient.from('hui_members').select('id, name').in('id', memberIds); if (mData) { const map = Object.fromEntries(mData.map(m => [m.id, m.name])); if (fromId && map[fromId]) fromName = map[fromId]; if (toId && map[toId]) toName = map[toId]; } } } catch(e) {} cb(fromName, toName); }; // Fetch slot details to get group_id and slot_number supabaseClient .from('hui_slots') .select('slot_number, group_id') .eq('id', h.slot_id) .single() .then(({ data: sData }) => { if (!sData) return; getGroupNameStr(sData.group_id, (groupName) => { getMemberDetails(h.from_member_id, h.to_member_id, (fromName, toName) => { const timestamp = new Date().toTimeString().split(' ')[0]; let logText = ''; if (h.reason === 'withdraw') { logText = lang === 'vi' ? `Hội viên ${fromName} đã rút chân hụi #${sData.slot_number} khỏi dây hụi "${groupName}"` : `Member ${fromName} withdrew hụi slot #${sData.slot_number} from group "${groupName}"`; } else if (h.reason === 'replace') { logText = lang === 'vi' ? `Thay thế chủ chân hụi #${sData.slot_number} bằng ${toName} trong dây hụi "${groupName}"` : `Replaced owner of hụi slot #${sData.slot_number} with ${toName} in group "${groupName}"`; } else { logText = lang === 'vi' ? `Chuyển nhượng chân hụi #${sData.slot_number} từ ${fromName} sang ${toName} trong dây hụi "${groupName}"` : `Transferred hụi slot #${sData.slot_number} from ${fromName} to ${toName} in group "${groupName}" (${h.reason})`; } setLogs(prev => [ { id: h.id, timestamp: new Date(), time: timestamp, date: new Date().toISOString().split('T')[0], type: 'info', category: 'member', userId: h.from_member_id || h.to_member_id, userName: fromName !== 'N/A' ? fromName : toName, text: logText }, ...prev ]); }); }); }); }) .subscribe(); channels.push(slotsHistoryChan); // 5. Ledger Entries Subscription (Financial movements) const ledgerChan = supabaseClient .channel('public:ledger_entries_realtime') .on('postgres_changes', { event: 'INSERT', schema: 'public', table: 'ledger_entries' }, (payload) => { const l = payload.new; // Fetch member name const getMemberName = (memId, cb) => { if (!memId) return cb('Anonymous'); supabaseClient .from('hui_members') .select('name') .eq('id', memId) .single() .then(({ data }) => cb(data?.name || 'Anonymous')) .catch(() => cb('Anonymous')); }; getGroupNameStr(l.group_id, (groupName) => { getMemberName(l.member_id, (memberName) => { const timestamp = new Date().toTimeString().split(' ')[0]; const amountFormatted = Number(l.amount).toLocaleString() + 'đ'; let logText = ''; let logType = 'info'; if (l.kind === 'contribution') { logText = lang === 'vi' ? `Hội viên ${memberName} đã đóng hụi ${amountFormatted} vào dây hụi "${groupName}"` : `Member ${memberName} contributed ${amountFormatted} to hụi group "${groupName}"`; logType = 'success'; } else if (l.kind === 'payout') { logText = lang === 'vi' ? `Hội viên ${memberName} đã nhận hốt hụi ${amountFormatted} từ dây hụi "${groupName}"` : `Member ${memberName} received payout ${amountFormatted} from hụi group "${groupName}"`; logType = 'success'; } else if (l.kind === 'hoa') { logText = lang === 'vi' ? `Chủ thảo nhận phí hoa hồng ${amountFormatted} từ dây hụi "${groupName}"` : `Organizer collected commission of ${amountFormatted} from hụi group "${groupName}"`; } else { logText = lang === 'vi' ? `Giao dịch khác (${l.kind}): ${amountFormatted} trong dây hụi "${groupName}"` : `Other transaction (${l.kind}): ${amountFormatted} in hụi group "${groupName}"`; } setLogs(prev => [ { id: l.id, timestamp: new Date(), time: timestamp, date: new Date().toISOString().split('T')[0], type: logType, category: 'financial', userId: l.member_id, userName: memberName, text: logText }, ...prev ]); loadRealtimeData(supabaseClient); }); }); }) .subscribe(); channels.push(ledgerChan); // 6. Bids Subscription (Live auction bids) const bidsChan = supabaseClient .channel('public:auction_bids_realtime') .on('postgres_changes', { event: 'INSERT', schema: 'public', table: 'auction_bids' }, (payload) => { const b = payload.new; const getBidDetails = async (cb) => { try { const { data: pData } = await supabaseClient.from('hui_periods').select('group_id, period_number').eq('id', b.period_id).single(); if (!pData) return; const { data: mData } = await supabaseClient.from('hui_members').select('name').eq('id', b.member_id).single(); getGroupNameStr(pData.group_id, (groupName) => { cb(mData?.name || 'Anonymous', groupName, pData.period_number); }); } catch(e) {} }; getBidDetails((memberName, groupName, periodNum) => { const timestamp = new Date().toTimeString().split(' ')[0]; const amountFormatted = Number(b.amount).toLocaleString() + 'đ'; const logText = lang === 'vi' ? `Hội viên ${memberName} đặt giá đấu ${amountFormatted} tại kỳ #${periodNum} của dây "${groupName}"` : `Member ${memberName} placed bid of ${amountFormatted} for cycle #${periodNum} in group "${groupName}"`; setLogs(prev => [ { id: b.id, timestamp: new Date(), time: timestamp, date: new Date().toISOString().split('T')[0], type: 'info', category: 'financial', userId: b.member_id, userName: memberName, text: logText }, ...prev ]); }); }) .subscribe(); channels.push(bidsChan); // 7. Periods Subscription (Auction status updates) const periodsChan = supabaseClient .channel('public:hui_periods_realtime') .on('postgres_changes', { event: 'UPDATE', schema: 'public', table: 'hui_periods' }, (payload) => { const p = payload.new; const oldP = payload.old; getGroupNameStr(p.group_id, (groupName) => { const timestamp = new Date().toTimeString().split(' ')[0]; let logText = ''; let logType = 'info'; if (p.status === 'auction' && oldP.status !== 'auction') { logText = lang === 'vi' ? `TẬP TRUNG: Kỳ đấu giá #${p.period_number} của dây hụi "${groupName}" đã bắt đầu!` : `ATTENTION: Auction for cycle #${p.period_number} in group "${groupName}" has started!`; } else if (p.status === 'completed' && oldP.status !== 'completed') { if (p.winner_member_id) { supabaseClient .from('hui_members') .select('name') .eq('id', p.winner_member_id) .single() .then(({ data }) => { const winnerName = data?.name || 'Anonymous'; const bidFormatted = Number(p.winner_bid).toLocaleString() + 'đ'; const logText = lang === 'vi' ? `KẾT QUẢ: Kỳ đấu giá #${p.period_number} của dây "${groupName}" kết thúc. Người thắng: ${winnerName} (Giá đấu: ${bidFormatted})` : `AUCTION RESULT: Cycle #${p.period_number} in group "${groupName}" completed. Winner: ${winnerName} (Bid: ${bidFormatted})`; setLogs(prev => [ { id: p.id + '-completed', timestamp: new Date(), time: timestamp, date: new Date().toISOString().split('T')[0], type: 'success', category: 'group', userId: p.winner_member_id, userName: winnerName, text: logText }, ...prev ]); }); return; } else { logText = lang === 'vi' ? `Kỳ đấu giá #${p.period_number} của dây "${groupName}" đã kết thúc mà không có ai đấu` : `Auction for cycle #${p.period_number} in group "${groupName}" completed with no bids`; } } if (logText) { setLogs(prev => [ { id: p.id + '-' + p.status, timestamp: new Date(), time: timestamp, date: new Date().toISOString().split('T')[0], type: logType, category: 'group', userId: p.winner_member_id, userName: '', text: logText }, ...prev ]); } }); }) .subscribe(); channels.push(periodsChan); // 8. Analytics Events Subscription (Custom user flows log) const analyticsChan = supabaseClient .channel('public:analytics_events_realtime') .on('postgres_changes', { event: 'INSERT', schema: 'public', table: 'analytics_events' }, (payload) => { const ae = payload.new; getUserInfo(ae.user_id, (userName) => { const enrichedEvent = { ...ae, profiles: userName ? { name: userName, phone: '' } : null }; setAnalyticsEvents(prev => [enrichedEvent, ...prev]); const timestamp = new Date(ae.created_at).toTimeString().split(' ')[0]; const name = userName && userName !== 'Anonymous' ? userName : `Guest (${ae.anonymous_id.substring(0, 8)})`; const logText = lang === 'vi' ? `${name} thực hiện sự kiện: ${ae.event_type}` : `${name} performed action: ${ae.event_type}`; setLogs(prev => [ { id: ae.id, timestamp: new Date(ae.created_at), time: timestamp, date: ae.created_at.split('T')[0], type: 'info', category: 'analytics', userId: ae.user_id, userName: name, text: logText }, ...prev ]); }); }) .subscribe(); channels.push(analyticsChan); // 9. Error Logs Subscription (Exception catcher) const errorsChan = supabaseClient .channel('public:error_logs_realtime') .on('postgres_changes', { event: 'INSERT', schema: 'public', table: 'error_logs' }, (payload) => { const el = payload.new; getUserInfo(el.user_id, (userName) => { const enrichedError = { ...el, profiles: userName ? { name: userName, phone: '' } : null }; setErrorLogs(prev => [enrichedError, ...prev]); // Play alarm sound for fatal errors if (el.metadata?.isFatal) { try { const audioContext = new (window.AudioContext || window.webkitAudioContext)(); const playBeep = (time, freq) => { const osc = audioContext.createOscillator(); const gain = audioContext.createGain(); osc.connect(gain); gain.connect(audioContext.destination); osc.type = 'sawtooth'; osc.frequency.setValueAtTime(freq, time); gain.gain.setValueAtTime(0.08, time); gain.gain.exponentialRampToValueAtTime(0.01, time + 0.4); osc.start(time); osc.stop(time + 0.4); }; playBeep(audioContext.currentTime, 330); // E4 } catch (e) { console.warn("Audio Context alert failed:", e); } } const timestamp = new Date(el.created_at).toTimeString().split(' ')[0]; const name = userName && userName !== 'Anonymous' ? userName : `Guest (${el.anonymous_id.substring(0, 8)})`; const logText = lang === 'vi' ? `[LỖI HỆ THỐNG] ${name}: ${el.error_message}` : `[ERROR] ${name}: ${el.error_message}`; setLogs(prev => [ { id: el.id, time: timestamp, type: el.metadata?.isFatal ? 'system' : 'info', text: logText }, ...prev ]); }); }) .subscribe(); channels.push(errorsChan); // 10. QA Bot Logs Subscription const qaBotLogsChan = supabaseClient .channel('public:qa_bot_logs_realtime') .on('postgres_changes', { event: 'INSERT', schema: 'public', table: 'qa_bot_logs' }, (payload) => { const bl = payload.new; setBotLogs(prev => [bl, ...prev]); }) .subscribe(); channels.push(qaBotLogsChan); // 11. Group Chat Messages Subscription const chatMessagesChan = supabaseClient .channel('public:chat_messages_realtime') .on('postgres_changes', { event: 'INSERT', schema: 'public', table: 'chat_messages' }, (payload) => { const msg = payload.new; const matchedGroup = groupsRef.current.find(g => g.id === msg.group_id); const groupName = matchedGroup ? matchedGroup.name : 'Unknown Group'; const fullMsg = { ...msg, hui_groups: { name: groupName } }; setChatLogs(prev => [fullMsg, ...prev]); }) .on('postgres_changes', { event: 'UPDATE', schema: 'public', table: 'chat_messages' }, (payload) => { const msg = payload.new; setChatLogs(prev => prev.map(m => m.id === msg.id ? { ...m, ...msg } : m)); }) .on('postgres_changes', { event: 'DELETE', schema: 'public', table: 'chat_messages' }, (payload) => { const deletedId = payload.old.id; setChatLogs(prev => prev.filter(m => m.id !== deletedId)); }) .subscribe(); channels.push(chatMessagesChan); // 12. Group Chat Read Receipts Subscription const chatReadReceiptsChan = supabaseClient .channel('public:chat_read_receipts_realtime') .on('postgres_changes', { event: '*', schema: 'public', table: 'chat_read_receipts' }, (payload) => { if (payload.eventType === 'INSERT') { const receipt = payload.new; setChatReadReceipts(prev => { const filtered = prev.filter(r => !(r.group_id === receipt.group_id && r.profile_id === receipt.profile_id)); return [receipt, ...filtered].slice(0, 500); }); } else if (payload.eventType === 'UPDATE') { const receipt = payload.new; setChatReadReceipts(prev => prev.map(r => (r.group_id === receipt.group_id && r.profile_id === receipt.profile_id) ? receipt : r )); } else if (payload.eventType === 'DELETE') { const receipt = payload.old; setChatReadReceipts(prev => prev.filter(r => !(r.group_id === receipt.group_id && r.profile_id === receipt.profile_id) )); } }) .subscribe(); channels.push(chatReadReceiptsChan); // 13. Member Reports / Disputes Subscription const memberReportsChan = supabaseClient .channel('public:member_reports_realtime') .on('postgres_changes', { event: '*', schema: 'public', table: 'member_reports' }, async (payload) => { if (payload.eventType === 'INSERT') { const row = payload.new; const [{ data: rep }, { data: repd }, { data: grp }] = await Promise.all([ supabaseClient.from('profiles').select('name, phone').eq('id', row.reporter_user_id).maybeSingle(), supabaseClient.from('profiles').select('name, phone').eq('id', row.reported_user_id).maybeSingle(), row.group_id ? supabaseClient.from('hui_groups').select('name').eq('id', row.group_id).maybeSingle() : { data: null } ]); const enriched = { ...row, reporter: rep || null, reported: repd || null, hui_groups: grp || null }; setDisputes(prev => [enriched, ...prev.filter(d => d.id !== row.id)]); } else if (payload.eventType === 'UPDATE') { const row = payload.new; setDisputes(prev => prev.map(d => d.id === row.id ? { ...d, ...row } : d)); } else if (payload.eventType === 'DELETE') { setDisputes(prev => prev.filter(d => d.id !== payload.old.id)); } }) .subscribe(); channels.push(memberReportsChan); return () => { channels.forEach(ch => { supabaseClient.removeChannel(ch); }); }; }, [supabaseClient, isAuthenticated, currentUser, lang]); // (ALLOWED_ADMINS moved to module scope) // Helper to load historical logs from multiple tables and combine them const loadLogsHistory = async (client) => { if (!client) return; try { const [ { data: pData }, { data: gData }, { data: lData }, { data: mData }, { data: sData }, { data: aData }, { data: eData } ] = await Promise.all([ client.from('profiles').select('*').order('created_at', { ascending: false }).limit(50), client.from('hui_groups').select('*').order('created_at', { ascending: false }).limit(50), client.from('ledger_entries').select('*').order('created_at', { ascending: false }).limit(50), client.from('hui_members').select('*').order('joined_at', { ascending: false }).limit(50), client.from('slot_ownership_history').select('*').order('created_at', { ascending: false }).limit(50), client.from('analytics_events').select('*').order('created_at', { ascending: false }).limit(50), client.from('error_logs').select('*').order('created_at', { ascending: false }).limit(50) ]); const merged = []; if (pData) { pData.forEach(p => { const name = p.name || 'Anonymous'; merged.push({ id: 'profile-' + p.id + '-' + p.created_at, timestamp: new Date(p.created_at), time: new Date(p.created_at).toTimeString().split(' ')[0], date: p.created_at.split('T')[0], type: 'success', category: 'user', userId: p.id, userName: name, text: lang === 'vi' ? `Thành viên mới ${name} đăng ký tài khoản qua số điện thoại ${p.phone}` : `New user ${name} registered with phone number ${p.phone}` }); }); } if (gData) { gData.forEach(g => { const org = usersRef.current.find(u => u.id === g.organizer_id); const orgName = org ? org.name : 'Unknown Organizer'; merged.push({ id: 'group-' + g.id + '-' + g.created_at, timestamp: new Date(g.created_at), time: new Date(g.created_at).toTimeString().split(' ')[0], date: g.created_at.split('T')[0], type: 'success', category: 'group', userId: g.organizer_id, userName: orgName, text: lang === 'vi' ? `Dây hụi mới "${g.name}" được tạo bởi chủ thảo ${orgName}` : `New hụi group "${g.name}" created by organizer ${orgName}` }); }); } if (lData) { lData.forEach(l => { const matchedGroup = groupsRef.current.find(g => g.id === l.group_id); const groupName = matchedGroup ? matchedGroup.name : 'Unknown Group'; const member = usersRef.current.find(u => u.id === l.member_id) || { name: 'Anonymous' }; const memberName = member.name; const amountStr = Number(l.amount).toLocaleString() + 'đ'; let text = '', type = 'info'; if (l.kind === 'contribution') { text = lang === 'vi' ? `Hội viên ${memberName} đã đóng hụi ${amountStr} vào dây hụi "${groupName}"` : `Member ${memberName} contributed ${amountStr} to hụi group "${groupName}"`; type = 'success'; } else if (l.kind === 'payout') { text = lang === 'vi' ? `Hội viên ${memberName} đã nhận hốt hụi ${amountStr} từ dây hụi "${groupName}"` : `Member ${memberName} received payout ${amountStr} from hụi group "${groupName}"`; type = 'success'; } else if (l.kind === 'hoa') { text = lang === 'vi' ? `Chủ thảo nhận phí hoa hồng ${amountStr} từ dây hụi "${groupName}"` : `Organizer collected commission of ${amountStr} from hụi group "${groupName}"`; } else { text = lang === 'vi' ? `Giao dịch khác (${l.kind}): ${amountStr} trong dây hụi "${groupName}"` : `Other transaction (${l.kind}): ${amountStr} in hụi group "${groupName}"`; } merged.push({ id: 'ledger-' + l.id + '-' + l.created_at, timestamp: new Date(l.created_at), time: new Date(l.created_at).toTimeString().split(' ')[0], date: l.created_at.split('T')[0], type, category: 'financial', userId: l.member_id, userName: memberName, text }); }); } if (mData) { mData.forEach(m => { const matchedGroup = groupsRef.current.find(g => g.id === m.group_id); const groupName = matchedGroup ? matchedGroup.name : 'Unknown Group'; merged.push({ id: 'member-' + m.id + '-' + m.joined_at, timestamp: new Date(m.joined_at), time: new Date(m.joined_at).toTimeString().split(' ')[0], date: m.joined_at.split('T')[0], type: 'info', category: 'member', userId: m.user_id || m.id, userName: m.name, text: lang === 'vi' ? `Hội viên ${m.name} (${m.phone}) đã được thêm vào dây hụi "${groupName}"` : `Member ${m.name} (${m.phone}) was added to hụi group "${groupName}"` }); }); } if (sData && sData.length > 0) { const allMemberIds = [...new Set(sData.flatMap(s => [s.from_member_id, s.to_member_id].filter(Boolean)))]; let memberMap = {}; if (allMemberIds.length > 0) { const { data: mRows } = await client.from('hui_members').select('id, name').in('id', allMemberIds); if (mRows) memberMap = Object.fromEntries(mRows.map(m => [m.id, m.name])); } sData.forEach(s => { const fromName = memberMap[s.from_member_id] || (s.from_member_id ? 'Member' : 'N/A'); const toName = memberMap[s.to_member_id] || (s.to_member_id ? 'Member' : 'Anonymous'); const userName = fromName !== 'N/A' ? fromName : toName; let logText = ''; if (s.reason === 'withdraw') { logText = lang === 'vi' ? `Hội viên ${fromName} đã rút chân hụi` : `Member ${fromName} withdrew hụi slot`; } else if (s.reason === 'replace') { logText = lang === 'vi' ? `Thay thế chủ chân hụi bằng ${toName}` : `Replaced owner of hụi slot with ${toName}`; } else { logText = lang === 'vi' ? `Chuyển nhượng chân hụi từ ${fromName} sang ${toName} (${s.reason})` : `Transferred hụi slot from ${fromName} to ${toName} (${s.reason})`; } merged.push({ id: 'slot-hist-' + s.id + '-' + s.created_at, timestamp: new Date(s.created_at), time: new Date(s.created_at).toTimeString().split(' ')[0], date: s.created_at.split('T')[0], type: 'info', category: 'member', userId: s.from_member_id || s.to_member_id, userName, text: logText }); }); } if (aData) { aData.forEach(a => { const u = usersRef.current.find(item => item.id === a.user_id); const name = u ? u.name : `Guest (${a.anonymous_id.substring(0, 8)})`; merged.push({ id: 'analytics-' + a.id + '-' + a.created_at, timestamp: new Date(a.created_at), time: new Date(a.created_at).toTimeString().split(' ')[0], date: a.created_at.split('T')[0], type: 'info', category: 'analytics', userId: a.user_id, userName: name, text: lang === 'vi' ? `${name} thực hiện: ${a.event_type}` : `${name} performed action: ${a.event_type}` }); }); } if (eData) { eData.forEach(e => { const u = usersRef.current.find(item => item.id === e.user_id); const name = u ? u.name : `Guest`; merged.push({ id: 'error-' + e.id + '-' + e.created_at, timestamp: new Date(e.created_at), time: new Date(e.created_at).toTimeString().split(' ')[0], date: e.created_at.split('T')[0], type: e.metadata?.isFatal ? 'system' : 'warning', category: 'error', userId: e.user_id, userName: name, text: `${name}: ${e.error_message}` }); }); } // Sort all combined logs by timestamp descending merged.sort((a, b) => b.timestamp - a.timestamp); setLogs(merged); } catch(err) { console.error("Failed to merge and load logs history:", err); } }; // Helper to load real operational telemetry from database const loadRealtimeData = async (client) => { // Fetch row counts dynamically for all primary tables using high-load optimized RPC client.rpc('cp_get_db_stats') .then(({ data, error }) => { if (error) { console.error("Stats RPC error", error); setDbStats([]); } else if (data) { const results = data.map(d => ({ table: d.table, rows: d.rows || 0, rls: 'active' })); setDbStats(results); } else { setDbStats([]); } }); try { // Coordinated fetch profiles, groups, and analytics events so lookups & last activity timestamps are ready const [profilesRes, groupsRes, analyticsRes] = await Promise.all([ client.from('profiles').select('id, name, phone, display_id, role, language, is_tester, is_demo, deleted_at, suspended_at, created_at, avatar_url, user_push_tokens(push_token), features, identity_verifications(status), user_subscriptions(tier, plan, status, expires_at, trial_ends_at, source)').order('created_at', { ascending: false }).limit(500), client.from('hui_groups').select('*, profiles(name)').limit(500), client.rpc('cp_get_users_last_activity').then(res => res.error ? { data: [] } : res) ]); const lastActiveMap = {}; const lastSignInMap = {}; if (analyticsRes && analyticsRes.data) { for (const ev of analyticsRes.data) { if (ev.user_id && ev.last_active_at) { lastActiveMap[ev.user_id] = ev.last_active_at; } if (ev.user_id && ev.last_sign_in_at) { lastSignInMap[ev.user_id] = ev.last_sign_in_at; } } } const mapLegacyTierToPlan = (tier) => { switch (tier) { case 'free_trial': case 'basic_assistant': case 'premium_auto': case 'organizer': return 'organizer_pro'; case 'organizer_free': return 'organizer_free'; case 'organizer_pro': return 'organizer_pro'; case 'organizer_business': return 'organizer_business'; default: return null; } }; const effectivePlan = (sub) => { if (!sub) return 'free'; const plan = (sub.plan && String(sub.plan).trim()) || mapLegacyTierToPlan(sub.tier); if (!plan || plan === 'organizer_free') return 'free'; return plan; }; const activeGroupsCountByOrganizer = {}; if (groupsRes.data) { groupsRes.data.forEach(g => { if (g.status === 'active' && g.organizer_id) { activeGroupsCountByOrganizer[g.organizer_id] = (activeGroupsCountByOrganizer[g.organizer_id] || 0) + 1; } }); } if (profilesRes.data) { const mappedUsers = profilesRes.data.map((p, idx) => { const rawStatus = p.identity_verifications?.status || p.identity_verifications?.[0]?.status || 'unsigned'; const now = Date.now(); const activeSub = (p.user_subscriptions || []).find((s) => { if (s.status !== 'active') return false; const expOk = s.expires_at && new Date(s.expires_at).getTime() > now; const trialOk = s.trial_ends_at && new Date(s.trial_ends_at).getTime() > now; return expOk || trialOk; }); const plan = effectivePlan(activeSub); const lastActiveAt = lastActiveMap[p.id] || p.created_at || new Date().toISOString(); const lastSignInAt = lastSignInMap[p.id] || null; const activeGroupsCount = activeGroupsCountByOrganizer[p.id] || 0; const freeLimitReached = (plan === 'free' || plan === 'organizer_free') && activeGroupsCount >= 3; return { id: p.id || `usr-${idx}`, name: p.name || p.full_name || 'Anonymous', phone: p.phone || '', displayId: p.display_id || '', role: p.role || 'participant', plan, subscriptionSource: activeSub?.source || null, subscriptionExpiresAt: activeSub?.expires_at || activeSub?.trial_ends_at || null, activeGroupsCount, freeLimitReached, status: rawStatus, suspendedAt: p.suspended_at, pushToken: p.user_push_tokens?.push_token || (Array.isArray(p.user_push_tokens) ? p.user_push_tokens[0]?.push_token : p.user_push_tokens?.push_token) || null, features: p.features || {}, date: p.created_at ? p.created_at.split('T')[0] : '2026-05-01', createdIso: p.created_at || new Date().toISOString(), lastActiveAt: lastActiveAt, lastSignInAt: lastSignInAt, avatarUrl: p.avatar_url || null, language: p.language || 'vi', isTester: Boolean(p.is_tester), isDemo: Boolean(p.is_demo), deletedAt: p.deleted_at || null }; }); setUsers(mappedUsers); usersRef.current = mappedUsers; } if (groupsRes.data) { const mappedGroups = groupsRes.data.map(g => ({ id: g.id, name: g.name, organizer_id: g.organizer_id, organizer: g.profiles ? (g.profiles.name || 'Anonymous') : 'Unknown', amount: g.contribution, members: g.total_periods, period: `${g.current_period} / ${g.total_periods}`, volume: Number(g.contribution) * Number(g.total_periods), status: g.status })); setGroups(mappedGroups); groupsRef.current = mappedGroups; } // Now load the logs history! await loadLogsHistory(client); } catch (err) { console.error("Error loading real-time lookup caches:", err); } // Sync pending identity verifications (CCCD) client.from('identity_verifications').select('*').eq('status', 'pending').limit(20).then(({ data, error }) => { if (!error && data) { const mapped = data.map(d => ({ id: d.id, userId: d.user_id, name: d.full_name || 'Anonymous', cccdNum: d.cccd_number || 'N/A', dob: d.birth_date || 'N/A', status: d.status, frontPhotoUrl: d.front_photo_url, backPhotoUrl: d.back_photo_url, ekycProvider: d.ekyc_provider, ekycAutoApproved: d.ekyc_provider && d.ekyc_provider !== 'manual' && d.status === 'verified', livenessScore: d.liveness_score, faceMatchScore: d.face_match_score, nfcRead: d.nfc_read, ekycError: d.ekyc_error })); setCccdRequests(mapped); } }); // Sync risk alerts client.from('risk_alerts').select('*, profiles!user_id (name, avatar_url, phone)').order('created_at', { ascending: false }).limit(200).then(({ data, error }) => { if (!error && data) { setRiskAlerts(data); } }); // Sync waitlist entries client.from('hui_waitlist').select('*, profiles(name, phone), hui_groups(name)').order('requested_at', { ascending: false }).limit(100).then(({ data, error }) => { if (!error && data) { setWaitlistEntries(data); } }); // Sync onboarding analytics events client.from('analytics_events').select('*, profiles(name, phone)').order('created_at', { ascending: false }).limit(100).then(({ data, error }) => { if (!error && data) { setAnalyticsEvents(data); } }); // Sync error logs client.from('error_logs').select('*, profiles(name, phone)').order('created_at', { ascending: false }).limit(100).then(({ data, error }) => { if (!error && data) { setErrorLogs(data); } }); // Sync bot logs (initial 30 items for faster load) client.from('qa_bot_logs').select('*').order('created_at', { ascending: false }).limit(30).then(({ data, error }) => { if (!error && data) { setBotLogs(data); if (data.length < 30) setHasMoreBotLogs(false); } }); // Sync disputes (member_reports) client.from('member_reports') .select('*, reporter:reporter_user_id(name, phone), reported:reported_user_id(name, phone), hui_groups(name)') .order('created_at', { ascending: false }) .limit(200) .then(({ data, error }) => { if (!error && data) { setDisputes(data); } else if (error) { console.error('[CP] member_reports load failed', error); } }); // Sync chat logs client.from('chat_messages').select('*, hui_groups(name)').order('created_at', { ascending: false }).limit(300).then(({ data, error }) => { if (!error && data) { setChatLogs(data); } }); // Sync chat read receipts client.from('chat_read_receipts').select('profile_id, group_id, last_read_message_id, last_read_at').order('last_read_at', { ascending: false }).limit(500).then(({ data, error }) => { if (!error && data) { setChatReadReceipts(data); } }); // Sync bank integrations (admin RLS). No direct FK to profiles — enrich in two steps. client.from('organizer_bank_integrations').select('*').order('created_at', { ascending: false }).then(async ({ data, error }) => { if (error) { console.error('[CP] bank integrations load failed', error); return; } if (!data?.length) { setBankIntegrations([]); return; } const organizerIds = [...new Set(data.map((row) => row.organizer_id).filter(Boolean))]; let profileById = {}; if (organizerIds.length) { const { data: profiles, error: profileError } = await client .from('profiles') .select('id, name, phone') .in('id', organizerIds); if (profileError) { console.error('[CP] bank integration profiles load failed', profileError); } else { profileById = Object.fromEntries((profiles || []).map((p) => [p.id, p])); } } setBankIntegrations(data.map((row) => ({ ...row, profiles: profileById[row.organizer_id] || null, }))); }); // Auction antifraud soft analytics: consecutive wins (≥3) per group client .from('hui_periods') .select('group_id, period_number, winner_member_id') .eq('status', 'completed') .not('winner_member_id', 'is', null) .order('period_number', { ascending: false }) .limit(2000) .then(async ({ data, error }) => { if (error || !data?.length) { if (error) console.error('[CP] auction streak load failed', error); setAuctionStreakAlerts([]); return; } const byGroup = {}; for (const row of data) { if (!byGroup[row.group_id]) byGroup[row.group_id] = []; byGroup[row.group_id].push(row); } const alerts = []; for (const [groupId, rows] of Object.entries(byGroup)) { const sorted = [...rows].sort((a, b) => b.period_number - a.period_number); const winnerId = sorted[0]?.winner_member_id; if (!winnerId) continue; let streak = 0; for (const p of sorted) { if (p.winner_member_id === winnerId) streak += 1; else break; } if (streak >= 3) { alerts.push({ groupId, winnerMemberId: winnerId, streak, lastPeriod: sorted[0].period_number }); } } if (!alerts.length) { setAuctionStreakAlerts([]); return; } const memberIds = [...new Set(alerts.map((a) => a.winnerMemberId))]; const groupIds = [...new Set(alerts.map((a) => a.groupId))]; const [{ data: members }, { data: groupRows }] = await Promise.all([ client.from('hui_members').select('id, name').in('id', memberIds), client.from('hui_groups').select('id, name').in('id', groupIds), ]); const memberName = Object.fromEntries((members || []).map((m) => [m.id, m.name])); const groupName = Object.fromEntries((groupRows || []).map((g) => [g.id, g.name])); setAuctionStreakAlerts( alerts .map((a) => ({ ...a, groupName: groupName[a.groupId] || a.groupId, winnerName: memberName[a.winnerMemberId] || a.winnerMemberId, })) .sort((a, b) => b.streak - a.streak), ); }); // Fetch urgent queue counts (bank review & dead-letter queue) Promise.all([ client.from('bank_transactions').select('*', { count: 'exact', head: true }).in('status', ['amount_mismatch', 'require_review', 'multi_slot_candidate', 'duplicate', 'no_match']), client.from('bank_webhook_dead_letters').select('*', { count: 'exact', head: true }).eq('status', 'unresolved') ]).then(([bankReviewRes, dlqRes]) => { setUrgentStats({ bankReviewCount: bankReviewRes.count || 0, dlqCount: dlqRes.count || 0, }); }).catch(e => console.warn('[CP] urgent counts error:', e)); // Sync app feedbacks client.from('app_feedbacks').select('*, profiles(name, phone)').order('created_at', { ascending: false }).limit(200).then(({ data, error }) => { if (!error && data) { const mapped = data.map(d => ({ id: d.id, user_id: d.user_id, user_name: d.profiles ? (d.profiles.name || 'Anonymous') : 'Anonymous', user_phone: d.profiles ? d.profiles.phone : '', category: d.category, rating: d.rating, message: d.message, device_info: d.device_info, status: d.status, admin_notes: d.admin_notes, created_at: d.created_at })); setFeedbacks(mapped); } }); }; const handleUpdateFeedbackStatus = async (feedbackId, newStatus) => { if (!supabaseClient) return; try { const { error } = await supabaseClient .from('app_feedbacks') .update({ status: newStatus, updated_at: new Date().toISOString() }) .eq('id', feedbackId); if (error) throw error; // Update local state setFeedbacks(prev => prev.map(f => f.id === feedbackId ? { ...f, status: newStatus } : f)); setSelectedFeedback(prev => prev && prev.id === feedbackId ? { ...prev, status: newStatus } : prev); } catch (err) { console.error('Error updating feedback status:', err); alert(lang === 'vi' ? 'Cập nhật trạng thái thất bại: ' + err.message : 'Failed to update status: ' + err.message); } }; const handleSaveFeedbackNotes = async (feedbackId) => { if (!supabaseClient) return; try { const { error } = await supabaseClient .from('app_feedbacks') .update({ admin_notes: adminNotesInput, updated_at: new Date().toISOString() }) .eq('id', feedbackId); if (error) throw error; // Update local state setFeedbacks(prev => prev.map(f => f.id === feedbackId ? { ...f, admin_notes: adminNotesInput } : f)); alert(lang === 'vi' ? 'Đã lưu ghi chú!' : 'Notes saved!'); } catch (err) { console.error('Error saving feedback notes:', err); alert(lang === 'vi' ? 'Lưu ghi chú thất bại: ' + err.message : 'Failed to save notes: ' + err.message); } }; // Helper to load detailed slots & financial logs for a specific group const loadGroupDetails = async (groupObj) => { if (!groupObj) return; if (currentUser && (currentUser.email === 'demo-admin@huio.app' || currentUser.email === 'admin@huio.app')) { // Load mock data for demo mode setIsGroupDetailLoading(true); setTimeout(() => { // Mock slots const mockSlots = Array.from({ length: groupObj.members || 10 }, (_, i) => ({ id: `slot-${groupObj.id}-${i+1}`, slot_number: i + 1, status: i < 3 ? 'dead' : i === 7 ? 'withdrawn' : 'living', won_period: i < 3 ? i + 1 : null, hui_members: { id: `mem-${i+1}`, name: `Hội viên #${i+1}`, phone: `09012345${i+1}` } })); setGroupSlots(mockSlots); // Mock ledger logs const mockLedger = [ { id: `ledger-1`, created_at: new Date(Date.now() - 3600000 * 2).toISOString(), kind: 'contribution', direction: 'thu', amount: groupObj.amount || 1000000, payment_method: 'transfer', note: 'Đóng hụi kỳ 2', hui_members: { name: 'Hội viên #1' } }, { id: `ledger-2`, created_at: new Date(Date.now() - 3600000 * 48).toISOString(), kind: 'payout', direction: 'chi', amount: (groupObj.amount || 1000000) * (groupObj.members || 10) * 0.9, payment_method: 'transfer', note: 'Hốt hụi kỳ 1', hui_members: { name: 'Hội viên #2' } } ]; setGroupLedger(mockLedger); setGroupUnpaidContribs([]); setIsGroupDetailLoading(false); }, 300); return; } if (!supabaseClient) return; setIsGroupDetailLoading(true); try { const { data: slots, error: slotsErr } = await supabaseClient .from('hui_slots') .select('*, hui_members(id, name, phone)') .eq('group_id', groupObj.id) .order('slot_number', { ascending: true }); if (slotsErr) throw slotsErr; const { data: ledger, error: ledgerErr } = await supabaseClient .from('ledger_entries') .select('*, hui_members(id, name)') .eq('group_id', groupObj.id) .order('created_at', { ascending: false }); if (ledgerErr) throw ledgerErr; const { data: contribs, error: contribsErr } = await supabaseClient .from('period_contributions') .select('*, hui_periods!inner(group_id, status, period_number)') .eq('hui_periods.group_id', groupObj.id) .eq('hui_periods.status', 'completed'); if (contribsErr) throw contribsErr; setGroupSlots(slots || []); setGroupLedger(ledger || []); setGroupUnpaidContribs(contribs || []); } catch (e) { console.error("Error loading group details:", e); alert(lang === 'vi' ? 'Không thể tải chi tiết dây hụi.' : 'Failed to load group details.'); } finally { setIsGroupDetailLoading(false); } }; const handleForceCompleteGroup = async (groupId) => { if (!groupId) return; const confirmMsg = lang === 'vi' ? 'Bạn có chắc chắn muốn hoàn thành khân cấp dây hụi này? Trạng thái sẽ được chuyển thành Completed.' : 'Are you sure you want to force complete this group? Status will be updated to Completed.'; if (!window.confirm(confirmMsg)) return; if (currentUser && (currentUser.email === 'demo-admin@huio.app' || currentUser.email === 'admin@huio.app')) { setGroups(prev => prev.map(g => g.id === groupId ? { ...g, status: 'completed' } : g)); setActiveGroupDetail(prev => prev && prev.id === groupId ? { ...prev, status: 'completed' } : prev); alert(lang === 'vi' ? 'Cập nhật trạng thái thành công (Demo).' : 'Status updated successfully (Demo).'); return; } if (!supabaseClient) return; try { const { error } = await supabaseClient .from('hui_groups') .update({ status: 'completed' }) .eq('id', groupId); if (error) throw error; alert(lang === 'vi' ? 'Đã hoàn thành khẩn cấp dây hụi.' : 'Group force completed successfully.'); loadRealtimeData(supabaseClient); setActiveGroupDetail(prev => prev ? { ...prev, status: 'completed' } : null); } catch (e) { console.error(e); alert(lang === 'vi' ? 'Lỗi khi hoàn thành dây hụi.' : 'Error force completing group.'); } }; const handleRollbackLastPeriod = async (groupId) => { if (!groupId) return; const confirmMsg = lang === 'vi' ? 'CẢNH BÁO: Bạn có chắc chắn muốn hủy kỳ đấu giá vừa qua? Hành động này sẽ khôi phục trạng thái chân hụi thắng cuộc, trả các khoản đóng về nợ chưa đóng, và XÓA nhật ký thu chi liên quan đến kỳ này!' : 'WARNING: Are you sure you want to rollback the last auction cycle? This will resurrect the winning slot, revert contribution payments to unpaid, and DELETE all associated ledger entries!'; if (!window.confirm(confirmMsg)) return; if (currentUser && (currentUser.email === 'demo-admin@huio.app' || currentUser.email === 'admin@huio.app')) { alert(lang === 'vi' ? 'Hủy kỳ đấu giá thành công (Demo).' : 'Cycle rolled back successfully (Demo).'); return; } if (!supabaseClient) return; try { const { data, error } = await supabaseClient.rpc('rollback_last_period', { p_group_id: groupId, p_expected_period_id: null }); if (error) throw error; const res = data || {}; const ledgerCount = res.ledgerEntriesReversed ?? res.ledgerEntriesDeleted ?? 0; const successMsg = lang === 'vi' ? `Đã hủy kỳ đấu giá thành công!\nKỳ hoàn tác: ${res.rolledBackPeriodNumber}\nĐặt lại ${res.contributionsReset} khoản đóng hụi\nĐảo ngược ${ledgerCount} bút toán thu chi.` : `Auction cycle rolled back successfully!\nReverted cycle: ${res.rolledBackPeriodNumber}\nReset ${res.contributionsReset} contributions\nReversed ${ledgerCount} ledger entries.`; alert(successMsg); loadRealtimeData(supabaseClient); if (activeGroupDetail) { const updatedGroup = { ...activeGroupDetail, period: `${res.rolledBackPeriodNumber} / ${activeGroupDetail.members}`, status: 'active' }; setActiveGroupDetail(updatedGroup); loadGroupDetails(updatedGroup); } } catch (e) { console.error(e); alert(lang === 'vi' ? `Lỗi khi hoàn tác kỳ: ${e.message || e}` : `Error rolling back cycle: ${e.message || e}`); } }; // Helper to create Supabase client using sessionStorage (prevents permanent auto-login) const getSupabaseClient = (url, key) => { const finalUrl = isStagingEnv ? STAGING_SUPABASE_URL : (url || DEFAULT_SUPABASE_URL); const finalKey = isStagingEnv ? STAGING_SUPABASE_KEY : (key || DEFAULT_SUPABASE_KEY); return window.supabase.createClient(finalUrl, finalKey, { auth: { storage: window.sessionStorage, persistSession: true, autoRefreshToken: true } }); }; // MFA Helpers for Control Panel const startTotpEnrollment = async (client) => { try { setIsEnrollingTotp(true); setMfaError(''); // 1. Clean up any stale unverified factors for this user // so GoTrue won't fail with duplicate friendly_name or max_enrolled_factors limit. try { const { data: existingFactors } = await client.auth.mfa.listFactors(); const unverified = (existingFactors?.all || []).filter(f => f.status === 'unverified'); for (const factor of unverified) { try { await client.auth.mfa.unenroll({ factorId: factor.id }); } catch (unenrollErr) { console.warn('[CP-MFA] Could not unenroll stale unverified factor:', factor.id, unenrollErr); } } } catch (listErr) { console.warn('[CP-MFA] Error checking existing factors before enroll:', listErr); } // 2. Supply unique friendlyName to prevent collision const friendlyName = `Huio CP Authenticator (${Date.now()})`; const { data, error } = await client.auth.mfa.enroll({ factorType: 'totp', issuer: 'Huio Control Panel', friendlyName }); if (error) throw error; setTotpEnrollData(data); setShowTotpEnroll(true); setShowTotpChallenge(false); setTotpCode(''); setMfaError(''); } catch (err) { console.error('[CP-MFA] Enrollment error:', err); setMfaError(err.message || 'Error initiating TOTP enrollment'); setShowTotpEnroll(true); } finally { setIsEnrollingTotp(false); } }; const checkAdminMfaAndProceed = async (client, user, role) => { // Only super_admin and admin require MFA if (role !== 'super_admin' && role !== 'admin') { setCurrentUser(user); setAdminRole(role); setIsAuthenticated(true); loadRealtimeData(client); return; } try { // 1. Check if cp_mfa_required flag is active in app_config let isRequired = false; try { const { data: configRow } = await client .from('app_config') .select('value') .eq('key', 'cp_mfa_required') .maybeSingle(); isRequired = configRow?.value === '1'; } catch (e) {} setCpMfaRequired(isRequired); // 2. Query MFA factors for user const { data: factorsData, error: factorsErr } = await client.auth.mfa.listFactors(); const verifiedTotp = factorsData?.totp?.filter(f => f.status === 'verified') || []; if (verifiedTotp.length === 0) { // No factor enrolled yet! Prompt TOTP enrollment setPendingAdminUser({ user, role }); await startTotpEnrollment(client); return; } // 3. Factor exists: check current assurance level const { data: aalData, error: aalErr } = await client.auth.mfa.getAuthenticatorAssuranceLevel(); if (aalData?.currentLevel !== 'aal2') { // Challenge for second factor setPendingAdminUser({ user, role }); setMfaFactorId(verifiedTotp[0].id); setShowTotpChallenge(true); setShowTotpEnroll(false); setTotpCode(''); setMfaError(''); return; } // AAL2 achieved! setShowTotpEnroll(false); setShowTotpChallenge(false); setPendingAdminUser(null); setCurrentUser(user); setAdminRole(role); setIsAuthenticated(true); loadRealtimeData(client); } catch (err) { console.warn('[CP-MFA] MFA check error:', err); setCurrentUser(user); setAdminRole(role); setIsAuthenticated(true); loadRealtimeData(client); } }; const handleVerifyEnrollment = async (e) => { if (e) e.preventDefault(); const cleanCode = totpCode.trim(); if (!cleanCode || cleanCode.length !== 6) { setMfaError(t('auth.mfa.error_invalid') || 'Vui lòng nhập mã gồm 6 chữ số'); return; } try { setIsVerifyingMfa(true); setMfaError(''); const client = getSupabaseClient(supabaseUrl, supabaseKey); const { data: challengeData, error: chErr } = await client.auth.mfa.challenge({ factorId: totpEnrollData.id }); if (chErr) throw chErr; const { data: verifyData, error: verErr } = await client.auth.mfa.verify({ factorId: totpEnrollData.id, challengeId: challengeData.id, code: cleanCode }); if (verErr) throw verErr; // Success! TOTP verified and session upgraded to AAL2 setShowTotpEnroll(false); setTotpCode(''); if (pendingAdminUser) { setCurrentUser(pendingAdminUser.user); setAdminRole(pendingAdminUser.role); setIsAuthenticated(true); loadRealtimeData(client); setPendingAdminUser(null); } } catch (err) { setMfaError(err.message || (t('auth.mfa.error_invalid') || 'Mã xác thực không hợp lệ')); } finally { setIsVerifyingMfa(false); } }; const handleVerifyChallenge = async (e) => { if (e) e.preventDefault(); const cleanCode = totpCode.trim(); if (!cleanCode || cleanCode.length !== 6) { setMfaError(t('auth.mfa.error_invalid') || 'Vui lòng nhập mã gồm 6 chữ số'); return; } try { setIsVerifyingMfa(true); setMfaError(''); const client = getSupabaseClient(supabaseUrl, supabaseKey); const { data: challengeData, error: chErr } = await client.auth.mfa.challenge({ factorId: mfaFactorId }); if (chErr) throw chErr; const { data: verifyData, error: verErr } = await client.auth.mfa.verify({ factorId: mfaFactorId, challengeId: challengeData.id, code: cleanCode }); if (verErr) throw verErr; // Success! Elevated to AAL2 setShowTotpChallenge(false); setTotpCode(''); if (pendingAdminUser) { setCurrentUser(pendingAdminUser.user); setAdminRole(pendingAdminUser.role); setIsAuthenticated(true); loadRealtimeData(client); setPendingAdminUser(null); } } catch (err) { setMfaError(err.message || (t('auth.mfa.error_invalid') || 'Mã xác thực không hợp lệ')); } finally { setIsVerifyingMfa(false); } }; const handleSkipEnrollment = async () => { if (cpMfaRequired) { setMfaError(t('auth.mfa.error_required') || 'Xác thực hai yếu tố là bắt buộc.'); return; } if (totpEnrollData?.id) { try { const client = getSupabaseClient(supabaseUrl, supabaseKey); await client.auth.mfa.unenroll({ factorId: totpEnrollData.id }); } catch (e) { console.warn('[CP-MFA] Skip unenroll error:', e); } } setShowTotpEnroll(false); setTotpEnrollData(null); if (pendingAdminUser) { const client = getSupabaseClient(supabaseUrl, supabaseKey); setCurrentUser(pendingAdminUser.user); setAdminRole(pendingAdminUser.role); setIsAuthenticated(true); loadRealtimeData(client); setPendingAdminUser(null); } }; const handleCancelMfa = async () => { if (totpEnrollData?.id) { try { const client = getSupabaseClient(supabaseUrl, supabaseKey); await client.auth.mfa.unenroll({ factorId: totpEnrollData.id }); } catch (e) { console.warn('[CP-MFA] Cancel unenroll error:', e); } } setShowTotpEnroll(false); setShowTotpChallenge(false); setTotpEnrollData(null); setTotpCode(''); setPendingAdminUser(null); setMfaError(''); await handleLogout(); }; // Try Supabase connection & Auth session state listener useEffect(() => { let authSubscription = null; const effectiveUrl = isStagingEnv ? STAGING_SUPABASE_URL : (supabaseUrl || DEFAULT_SUPABASE_URL); const effectiveKey = isStagingEnv ? STAGING_SUPABASE_KEY : (supabaseKey || DEFAULT_SUPABASE_KEY); // Purge legacy permanent tokens from localStorage on mount try { if (typeof window !== 'undefined' && window.localStorage) { Object.keys(window.localStorage).forEach(k => { if (k.startsWith('sb-') && k.endsWith('-auth-token')) { window.localStorage.removeItem(k); } }); } } catch (e) {} if (effectiveUrl && effectiveKey && window.supabase) { try { const client = getSupabaseClient(effectiveUrl, effectiveKey); setSupabaseClient(client); // Define session handler const handleUserSession = async (session) => { if (session && session.user) { const email = session.user.email; // 1. Check dynamic database admins table (app_admins) with role & is_active try { const { data: adminRecord, error: adminErr } = await client .from('app_admins') .select('user_id, role, is_active') .eq('user_id', session.user.id) .maybeSingle(); if (adminRecord && adminRecord.user_id) { if (!adminRecord.is_active) { await client.auth.signOut(); try { if (typeof window !== 'undefined') { if (window.sessionStorage) window.sessionStorage.clear(); if (window.localStorage) { Object.keys(window.localStorage).forEach(k => { if (k.startsWith('sb-') && k.endsWith('-auth-token')) { window.localStorage.removeItem(k); } }); } } } catch (e) {} alert(lang === 'vi' ? 'Tài khoản của bạn đã bị tạm khóa quyền quản trị.' : 'Your administrative access has been suspended.'); setIsAuthenticated(false); setCurrentUser(null); setAdminRole('none'); return; } await checkAdminMfaAndProceed(client, session.user, adminRecord.role || 'manager'); return; } } catch (e) { console.warn('Error checking app_admins:', e); } // 2. If not yet in app_admins, attempt to claim whitelist invitation via secure RPC try { const { data: claimRes, error: claimErr } = await client.rpc('cp_claim_admin_invite'); if (claimRes && claimRes.ok) { await checkAdminMfaAndProceed(client, session.user, claimRes.role || 'manager'); return; } } catch (e) { console.warn('Error claiming admin invite:', e); } // 3. Fallback check hardcoded admin whitelist if (ALLOWED_ADMINS.includes(email)) { const role = email === 'adbitmail@gmail.com' ? 'super_admin' : 'admin'; await checkAdminMfaAndProceed(client, session.user, role); return; } // 4. Unauthorized access - purge tokens and deny entry await client.auth.signOut(); try { if (typeof window !== 'undefined') { if (window.sessionStorage) window.sessionStorage.clear(); if (window.localStorage) { Object.keys(window.localStorage).forEach(k => { if (k.startsWith('sb-') && k.endsWith('-auth-token')) { window.localStorage.removeItem(k); } }); } } } catch (e) {} alert(lang === 'vi' ? 'Tài khoản này không có quyền truy cập vào Control Panel.' : 'This account does not have administrative access to Control Panel.'); setIsAuthenticated(false); setCurrentUser(null); setAdminRole('none'); } else { // User logged out or no active session, but don't force reset if in demo mode or PIN mode const isDemo = currentUser && (currentUser.email === 'demo-admin@huio.app' || currentUser.email === 'admin@huio.app' || currentUser.is_demo); if (currentUser && !isDemo) { setIsAuthenticated(false); setCurrentUser(null); setAdminRole('none'); } } }; // Check active session on page mount client.auth.getSession().then(({ data: { session } }) => { handleUserSession(session); setIsAuthChecking(false); }).catch((err) => { console.warn('getSession error:', err); setIsAuthChecking(false); }); // Listen for authentication session status changes const { data: { subscription } } = client.auth.onAuthStateChange((_event, session) => { handleUserSession(session); }); authSubscription = subscription; // Health check to update header status dot client.from('profiles').select('id', { count: 'exact', head: true }).limit(1).then(({ error }) => { setIsConnected(!error); }); } catch (e) { setIsConnected(false); setIsAuthChecking(false); } } else { setIsConnected(false); setSupabaseClient(null); // fallback to mock data setDbStats(INITIAL_DB_STATS); setUsers(INITIAL_USERS); setGroups(INITIAL_GROUPS); setCccdRequests(INITIAL_CCCD_REQUESTS); setRiskAlerts(INITIAL_RISK_ALERTS); setIsAuthChecking(false); } return () => { if (authSubscription) authSubscription.unsubscribe(); }; }, [supabaseUrl, supabaseKey, lang]); // Translate function const t = (key, opts) => { const dict = TRANSLATIONS[lang] || TRANSLATIONS.vi || {}; if (dict[key] !== undefined) return dict[key]; if (typeof opts === 'string') return opts; if (opts && typeof opts.defaultValue === 'string') return opts.defaultValue; return key; }; // CCCD Decision Actions const handleCccdDecision = async (reqId, decision, reason = '') => { const request = cccdRequests.find(r => r.id === reqId); if (!request) return; if (decision === 'reject' && !reason.trim()) { setRejectError(true); return; } setRejectError(false); setProcessingCccdId(reqId); try { // Execute real update in Supabase if (supabaseClient && request.id) { const updateData = { status: decision === 'approve' ? 'verified' : 'rejected', updated_at: new Date().toISOString(), verified_by: currentUser?.email || 'system_admin' }; if (decision === 'approve') { updateData.vneid_confirmed_at = new Date().toISOString(); } else { updateData.rejection_reason = reason.trim(); } const { error: idVerErr } = await supabaseClient .from('identity_verifications') .update(updateData) .eq('id', request.id); if (idVerErr) { console.error("Failed to update identity verification on Supabase:", idVerErr); alert("Supabase Error: " + idVerErr.message); setProcessingCccdId(null); return; } if (request.userId) { // Touch profiles for cache invalidation & trigger guarantees const { error: profErr } = await supabaseClient .from('profiles') .update({ updated_at: new Date().toISOString() }) .eq('id', request.userId); if (profErr) { console.warn("[CP] Warning updating profile updated_at:", profErr); } } // Legal R1: purge raw CCCD photo documents from Supabase Storage per PDN decree try { const { data: purgeData, error: fnErr } = await supabaseClient.functions.invoke('purge-identity-docs', { body: { action: 'purge_one', verification_id: request.id }, }); if (fnErr) { console.warn("[CP] Warning purging identity docs via Edge Function:", fnErr); // Fallback to SQL RPC to at least mask URLs in DB const { error: rpcErr } = await supabaseClient.rpc('purge_identity_verification_docs', { p_verification_id: request.id, }); if (rpcErr) { console.error("[CP] Fallback purge RPC failed:", rpcErr); } } else { console.log("[CP] CCCD photos purged via Storage API successfully:", purgeData); } } catch (purgeErr) { console.warn("[CP] Error invoking purge-identity-docs:", purgeErr); } // Persistent admin audit logging await logAdminAction( decision === 'approve' ? 'cccd.approve' : 'cccd.reject', 'cccd', request.id, { user_id: request.userId, reason: reason.trim() } ); } // Update CCCD verification requests list setCccdRequests(prev => prev.filter(r => r.id !== reqId)); // Update matching user status setUsers(prev => prev.map(u => { if (u.id === request.userId) { return { ...u, status: decision === 'approve' ? 'verified' : 'rejected' }; } return u; })); // Add log const timestamp = new Date().toTimeString().split(' ')[0]; const logText = lang === 'vi' ? (decision === 'approve' ? `Đã DUYỆT xác minh danh tính cho ${request.name}` : `Đã TỪ CHỐI xác minh danh tính cho ${request.name}. Lý do: ${reason.trim()}`) : (decision === 'approve' ? `APPROVED identity verification for ${request.name}` : `REJECTED identity verification for ${request.name}. Reason: ${reason.trim()}`); setLogs(prev => [ { id: Date.now(), time: timestamp, type: decision === 'approve' ? 'success' : 'error', text: logText }, ...prev ]); setSelectedRequest(null); setRejectReason(''); setRejectError(false); } catch (err) { console.error("[CP] Error in handleCccdDecision:", err); alert("Error: " + (err.message || String(err))); } finally { setProcessingCccdId(null); } }; const handleResolveError = (errorId) => { if (supabaseClient && currentUser && currentUser.email !== 'demo-admin@huio.app' && currentUser.email !== 'admin@huio.app') { supabaseClient .from('error_logs') .update({ resolved: true }) .eq('id', errorId) .then(({ error }) => { if (error) { console.error("Failed to resolve error:", error); alert("Error: " + error.message); } }); } setErrorLogs(prev => prev.map(e => e.id === errorId ? { ...e, resolved: true } : e)); const timestamp = new Date().toTimeString().split(' ')[0]; setLogs(prev => [ { id: Date.now(), time: timestamp, type: 'success', text: lang === 'vi' ? `Đã xử lý lỗi ID: ${errorId.substring(0,8)}` : `Resolved error ID: ${errorId.substring(0,8)}` }, ...prev ]); }; const handleResolveErrorGroup = (errorMessage) => { if (supabaseClient && currentUser && currentUser.email !== 'demo-admin@huio.app' && currentUser.email !== 'admin@huio.app') { supabaseClient .from('error_logs') .update({ resolved: true }) .eq('error_message', errorMessage) .then(({ error }) => { if (error) { console.error("Failed to resolve error group:", error); alert("Error: " + error.message); } }); } setErrorLogs(prev => prev.map(e => e.error_message === errorMessage ? { ...e, resolved: true } : e)); const timestamp = new Date().toTimeString().split(' ')[0]; setLogs(prev => [ { id: Date.now(), time: timestamp, type: 'success', text: lang === 'vi' ? `Đã xử lý nhóm lỗi: "${errorMessage.substring(0, 30)}..."` : `Resolved error group: "${errorMessage.substring(0, 30)}..."` }, ...prev ]); }; const handleOpenPromptModal = () => { const unresolved = errorLogs.filter(e => !e.resolved); if (unresolved.length === 0) { alert(lang === 'vi' ? 'Không có lỗi chưa xử lý!' : 'No unresolved errors!'); return; } const grouping = {}; unresolved.forEach(e => { const msg = e.error_message; if (!grouping[msg]) { grouping[msg] = { message: msg, count: 0, platforms: new Set(), last_occurrence: e.created_at, stack: e.error_stack, metadata: [] }; } grouping[msg].count++; if (e.metadata?.platform) { grouping[msg].platforms.add(e.metadata.platform); } if (new Date(e.created_at) > new Date(grouping[msg].last_occurrence)) { grouping[msg].last_occurrence = e.created_at; } grouping[msg].metadata.push(e.metadata); }); let text = `# Goal: Resolve Active Runtime Errors\n\n`; text += `Please inspect and fix the following unresolved runtime errors in the Huio application.\n\n`; text += `> [!IMPORTANT]\n`; text += `> **Language Requirement**: Per repository rules, communicate with user, write plans and reports in Russian, but keep code and commit messages clean in standard format.\n\n`; text += `> [!WARNING]\n`; text += `> **Historical Verification**: Some errors in this list may already be resolved in recent commits.\n`; text += `> Before modifying code:\n`; text += `> 1. Search the codebase (e.g. grep) for relevant error identifiers.\n`; text += `> 2. Run \`npm run typecheck\` and \`npm test\` in \`huio app/\`.\n`; text += `> If the code is already resolved and tests pass, no code changes are needed.\n\n`; text += `> [!TIP]\n`; text += `> **Closeout Actions**:\n`; text += `> 1. **Mark resolved in DB**: \`node scripts/resolve_error.mjs --all\` or \`--message "..."\`\n`; text += `> 2. **Changelog**: Append an entry in \`CHANGELOG.md\`.\n`; text += `> 3. **Sync Docs**: Run \`npm run sync-docs\` in \`huio-control-panel/\`.\n`; text += `> 4. **Commit & Push**: Commit and push changes to repository.\n\n`; Object.values(grouping).forEach((g, i) => { text += `## ${i + 1}. ${g.message}\n`; text += `- **Platforms**: ${Array.from(g.platforms).join(', ') || 'N/A'}\n`; text += `- **Frequency**: ${g.count} times\n`; text += `- **Last seen**: ${g.last_occurrence}\n`; if (g.stack) { text += `- **Stack Trace**:\n\`\`\`\n${g.stack}\n\`\`\`\n`; } else { text += `- **Stack Trace**: N/A\n`; } text += `\n---\n\n`; }); setPromptText(text); setCopiedPrompt(false); setIsPromptModalOpen(true); }; const handleCopyPrompt = () => { navigator.clipboard.writeText(promptText); setCopiedPrompt(true); setTimeout(() => setCopiedPrompt(false), 2000); }; const handleDownloadPromptFile = () => { const blob = new Blob([promptText], { type: 'text/markdown' }); const url = URL.createObjectURL(blob); const a = document.createElement('a'); a.href = url; a.download = 'ACTIVE_ERRORS_PROMPT.md'; document.body.appendChild(a); a.click(); document.body.removeChild(a); URL.revokeObjectURL(url); }; // Push Broadcast Broadcaster (Bilingual VI/EN) const handleSendBroadcast = async (e) => { e.preventDefault(); if (!broadcastBody.trim()) { alert(lang === 'vi' ? 'Vui lòng nhập Nội dung thông báo (Tiếng Việt)!' : 'Please enter notification Body (Vietnamese)!'); return; } // Determine target users let targets = []; if (broadcastTarget === 'all') { targets = users; } else if (broadcastTarget === 'organizers') { targets = users.filter(u => u.role === 'organizer' || u.role === 'both'); } else if (broadcastTarget === 'participants') { targets = users.filter(u => u.role === 'participant' || u.role === 'both'); } else if (broadcastTarget === 'subscribers_paid') { targets = users.filter(u => (u.plan === 'organizer_pro' || u.plan === 'organizer_business') && (u.subscriptionSource === 'payment' || u.hasConfirmedPayment)); } else if (broadcastTarget === 'subscribers_all') { targets = users.filter(u => u.plan === 'organizer_pro' || u.plan === 'organizer_business'); } else if (broadcastTarget === 'subscribers_pro') { targets = users.filter(u => u.plan === 'organizer_pro'); } else if (broadcastTarget === 'subscribers_business') { targets = users.filter(u => u.plan === 'organizer_business'); } else if (broadcastTarget === 'user') { targets = users.filter(u => u.id === broadcastUserId); } if (targets.length === 0) { alert(lang === 'vi' ? 'Không tìm thấy người nhận phù hợp.' : 'No matching recipients found.'); return; } // Filter recipients with push tokens & language distribution const recipientsWithTokens = targets.filter(t => t.pushToken); const viCount = targets.filter(t => (t.language || 'vi').toLowerCase() !== 'en').length; const enCount = targets.filter(t => (t.language || 'vi').toLowerCase() === 'en').length; const confirmMsg = lang === 'vi' ? `Bạn có chắc chắn muốn gửi thông báo này tới ${targets.length} người dùng? (VI: ${viCount}, EN: ${enCount}, Push: ${recipientsWithTokens.length})` : `Are you sure you want to send this broadcast to ${targets.length} users? (VI: ${viCount}, EN: ${enCount}, Push: ${recipientsWithTokens.length})`; if (!window.confirm(confirmMsg)) return; setIsBroadcasting(true); const finalTitleVi = broadcastTitle.trim() || null; const logTitleVi = broadcastTitle.trim() || 'Huio'; const finalTitleEn = broadcastTitleEn.trim() || null; const logTitleEn = broadcastTitleEn.trim() || logTitleVi; const bodyEnTrimmed = broadcastBodyEn.trim() || null; if (currentUser && (currentUser.email === 'demo-admin@huio.app' || currentUser.email === 'admin@huio.app')) { // Demo Mode simulation setTimeout(() => { setIsBroadcasting(false); setBroadcastTitle(''); setBroadcastBody(''); setBroadcastTitleEn(''); setBroadcastBodyEn(''); try { localStorage.removeItem('huio_cp_broadcast_draft'); } catch (err) {} // Log action with both texts const timestamp = new Date().toTimeString().split(' ')[0]; const logText = lang === 'vi' ? `[DEMO] Đã gửi thông báo: [VI: "${logTitleVi}" / EN: "${logTitleEn}"] tới ${targets.length} người dùng (${recipientsWithTokens.length} push)` : `[DEMO] Broadcasted notification: [VI: "${logTitleVi}" / EN: "${logTitleEn}"] to ${targets.length} users (${recipientsWithTokens.length} push)`; setLogs(prev => [ { id: Date.now(), time: timestamp, type: 'success', text: logText, details: { title_vi: logTitleVi, body_vi: broadcastBody.trim(), title_en: logTitleEn, body_en: bodyEnTrimmed, recipients_count: targets.length, recipients_vi: viCount, recipients_en: enCount, } }, ...prev ]); alert(lang === 'vi' ? 'Gửi thông báo thành công (Demo).' : 'Broadcast sent successfully (Demo).'); }, 1000); return; } if (!supabaseClient) { setIsBroadcasting(false); return; } try { // Send broadcast via bilingual system RPC const { error: rpcErr } = await supabaseClient.rpc('admin_broadcast_system_notification', { p_title: finalTitleVi, p_body: broadcastBody.trim(), p_target: broadcastTarget, p_user_id: broadcastTarget === 'user' ? broadcastUserId : null, p_title_en: finalTitleEn, p_body_en: bodyEnTrimmed }); if (rpcErr) throw rpcErr; await logAdminAction('notification.broadcast', 'broadcast', null, { title_vi: logTitleVi, body_vi: broadcastBody.trim(), title_en: logTitleEn, body_en: bodyEnTrimmed, target: broadcastTarget, user_id: broadcastTarget === 'user' ? broadcastUserId : null, recipients_count: targets.length, recipients_vi: viCount, recipients_en: enCount, }); // Log success with both texts const timestamp = new Date().toTimeString().split(' ')[0]; const logText = lang === 'vi' ? `Đã phát thông báo: [VI: "${logTitleVi}" / EN: "${logTitleEn}"] tới ${targets.length} người dùng (VI: ${viCount}, EN: ${enCount})` : `Broadcasted notification: [VI: "${logTitleVi}" / EN: "${logTitleEn}"] to ${targets.length} users (VI: ${viCount}, EN: ${enCount})`; setLogs(prev => [ { id: Date.now(), time: timestamp, type: 'success', text: logText, details: { title_vi: logTitleVi, body_vi: broadcastBody.trim(), title_en: logTitleEn, body_en: bodyEnTrimmed, recipients_count: targets.length, recipients_vi: viCount, recipients_en: enCount, } }, ...prev ]); alert(lang === 'vi' ? 'Đã gửi thông báo thành công!' : 'Broadcast notification sent successfully!'); setBroadcastTitle(''); setBroadcastBody(''); setBroadcastTitleEn(''); setBroadcastBodyEn(''); try { localStorage.removeItem('huio_cp_broadcast_draft'); } catch (err) {} } catch (e) { console.error(e); alert(lang === 'vi' ? `Lỗi khi gửi thông báo: ${e.message || e}` : `Error sending broadcast: ${e.message || e}`); } finally { setIsBroadcasting(false); } }; // Subscription plan change — writes plan (+ legacy tier compat), source=cp_grant|trial const handlePlanChange = async (userId, newPlan) => { const displayPlan = newPlan === 'trial_pro_30d' ? 'organizer_pro' : newPlan; if (!supabaseClient) return; try { const timestamp = new Date().toTimeString().split(' ')[0]; const targetUser = users.find(u => u.id === userId); const userName = targetUser ? targetUser.name : 'Unknown'; // If switching to a paid plan, ask admin if they want to record official payment if (newPlan !== 'free' && newPlan !== 'organizer_free') { const isPaid = window.confirm( lang === 'vi' ? `NÂNG CẤP GÓI TRẢ PHÍ CHO [${userName}]\n\nKhách hàng đã chuyển khoản thanh toán chưa?\n\n• [OK] ĐÃ THANH TOÁN (Khuyên dùng) → Mở ngay biểu mẫu ghi nhận thanh toán để tính doanh thu Hộ kinh doanh và hoa hồng CTV.\n\n• [Cancel] CHƯA THANH TOÁN → Cấp dùng thử/miễn phí (cp_grant, không ghi nhận doanh thu).` : `PAID PLAN UPGRADE FOR [${userName}]\n\nDid the customer transfer payment?\n\n• [OK] YES, PAID (Recommended) → Open Record Payment form to track revenue & partner commissions.\n\n• [Cancel] NO / TRIAL → Grant complimentary access (cp_grant without revenue).` ); if (isPaid) { handleOpenRecordPaymentModal(targetUser, displayPlan); return; } } setUsers(prev => prev.map(u => u.id === userId ? { ...u, plan: displayPlan === 'organizer_free' ? 'free' : displayPlan } : u)); // 1. Cancel any currently active subscriptions await supabaseClient .from('user_subscriptions') .update({ status: 'cancelled', updated_at: new Date().toISOString() }) .eq('user_id', userId) .eq('status', 'active'); let days = 0; // Free = cancel only (no new row). Documented M2 policy. if (newPlan !== 'free' && newPlan !== 'organizer_free') { const now = new Date(); let plan = 'organizer_pro'; let source = 'cp_grant'; let expiresAt = new Date(now); let trialEndsAt = null; days = 30; if (newPlan === 'organizer_business') { plan = 'organizer_business'; const daysRaw = window.prompt( lang === 'vi' ? 'Số ngày Business (30/60/90/365):' : 'Business duration days (30/60/90/365):', '30' ); days = Math.max(1, Number(daysRaw) || 30); expiresAt.setDate(expiresAt.getDate() + days); } else if (newPlan === 'organizer_basic') { plan = 'organizer_basic'; const daysRaw = window.prompt( lang === 'vi' ? 'Số ngày Basic (30/60/90/365):' : 'Basic duration days (30/60/90/365):', '30' ); days = Math.max(1, Number(daysRaw) || 30); expiresAt.setDate(expiresAt.getDate() + days); } else { // organizer_pro (and any legacy fallback) plan = 'organizer_pro'; const daysRaw = window.prompt( lang === 'vi' ? 'Số ngày Pro (30/60/90/365):' : 'Pro duration days (30/60/90/365):', '30' ); days = Math.max(1, Number(daysRaw) || 30); expiresAt.setDate(expiresAt.getDate() + days); } const { error } = await supabaseClient .from('user_subscriptions') .insert({ user_id: userId, // Legacy CHECK still requires tier ∈ free_trial|basic_assistant|premium_auto|organizer tier: 'organizer', plan, status: 'active', expires_at: expiresAt.toISOString(), trial_ends_at: trialEndsAt ? trialEndsAt.toISOString() : null, source, }); if (error) throw error; } await logAdminAction('user.change_plan', 'user', userId, { plan: newPlan, days: days, display_plan: displayPlan, }); const logText = lang === 'vi' ? `Đã thay đổi gói Chủ hụi cho ${userName} thành [${displayPlan}]` : `Changed Organizer plan for ${userName} to [${displayPlan}]`; setLogs(prev => [ { id: Date.now(), time: timestamp, type: 'info', text: logText }, ...prev ]); } catch (error) { console.error("Failed to update user subscription plan on Supabase:", error); alert("Supabase Error: " + error.message); } }; const handleRoleChange = async (userId, newRole) => { // Update local state setUsers(prev => prev.map(u => u.id === userId ? { ...u, role: newRole } : u)); // Update in Supabase if (supabaseClient) { try { const { error } = await supabaseClient .from('profiles') .update({ role: newRole }) .eq('id', userId); if (error) { console.error("Failed to update user role on Supabase:", error); alert("Supabase Error: " + error.message); return; } await logAdminAction('user.change_role', 'user', userId, { new_role: newRole }); // Log action const timestamp = new Date().toTimeString().split(' ')[0]; const logText = lang === 'vi' ? `Đã thay đổi vai trò thành viên thành [${newRole.toUpperCase()}]` : `Changed user role to [${newRole.toUpperCase()}]`; setLogs(prev => [ { id: Date.now(), time: timestamp, type: 'info', text: logText }, ...prev ]); } catch (err) { console.error("Failed to change user role:", err); } } }; const handleToggleFeature = async (userId, featureName, currentValue) => { const newValue = !currentValue; // Find the user to get their current features object const userObj = users.find(u => u.id === userId); if (!userObj) return; const updatedFeatures = { ...(userObj.features || {}), [featureName]: newValue }; // Update local state setUsers(prev => prev.map(u => u.id === userId ? { ...u, features: updatedFeatures } : u)); // Update in Supabase if (supabaseClient) { try { const { error } = await supabaseClient .from('profiles') .update({ features: updatedFeatures }) .eq('id', userId); if (error) { console.error(`Failed to update ${featureName} feature on Supabase:`, error); alert("Supabase Error: " + error.message); return; } await logAdminAction('user.toggle_feature', 'user', userId, { feature: featureName, enabled: newValue, }); // Log action const timestamp = new Date().toTimeString().split(' ')[0]; const featureLabel = featureName === 'participant_cabinet' ? 'Cabinet' : featureName === 'organizer_enabled' ? 'Organizer Grant' : featureName === 'bank_integration' ? 'Bank' : featureName; const statusLabel = newValue ? 'ON' : 'OFF'; const logText = lang === 'vi' ? `Đã thay đổi tính năng [${featureLabel}] thành [${statusLabel}]` : `Changed [${featureLabel}] feature to [${statusLabel}]`; setLogs(prev => [ { id: Date.now(), time: timestamp, type: 'info', text: logText }, ...prev ]); } catch (err) { console.error(`Error updating feature ${featureName}:`, err); } } }; const loadMoreBotLogs = async () => { if (isLoadingMoreBotLogs || !supabaseClient) return; setIsLoadingMoreBotLogs(true); try { const from = botLogs.length; const to = from + 30 - 1; const { data, error } = await supabaseClient .from('qa_bot_logs') .select('*') .order('created_at', { ascending: false }) .range(from, to); if (error) { console.error("Failed to load more bot logs:", error); } else if (data) { if (data.length < 30) setHasMoreBotLogs(false); setBotLogs(prev => { const existingIds = new Set(prev.map(l => l.id)); const newRows = data.filter(r => !existingIds.has(r.id)); return [...prev, ...newRows]; }); } } catch (err) { console.error("Error loading more bot logs:", err); } finally { setIsLoadingMoreBotLogs(false); } }; const handleToggleSuspend = async (userId, currentSuspendedAt) => { const isSuspended = !!currentSuspendedAt; const nextSuspendedAt = isSuspended ? null : new Date().toISOString(); // Update local state setUsers(prev => prev.map(u => u.id === userId ? { ...u, suspendedAt: nextSuspendedAt } : u)); // Update in Supabase if (supabaseClient) { try { const { error } = await supabaseClient .from('profiles') .update({ suspended_at: nextSuspendedAt }) .eq('id', userId); if (error) { console.error("Failed to toggle suspension status on Supabase:", error); alert("Supabase Error: " + error.message); return; } await logAdminAction( isSuspended ? 'user.unsuspend' : 'user.suspend', 'user', userId, { suspended_at: nextSuspendedAt } ); // Log action const timestamp = new Date().toTimeString().split(' ')[0]; const logText = isSuspended ? (lang === 'vi' ? 'Đã bỏ chặn thành viên' : 'Unsuspended member account') : (lang === 'vi' ? 'Đã chặn (suspend) thành viên' : 'Suspended member account'); setLogs(prev => [ { id: Date.now(), time: timestamp, type: isSuspended ? 'success' : 'error', text: logText }, ...prev ]); } catch (err) { console.error("Failed to toggle suspension:", err); } } }; // Hard-delete user account (Super Admin only) const handleDeleteUser = async (userId) => { if (!supabaseClient) { alert(lang === 'vi' ? 'Chưa kết nối Supabase' : 'Supabase is not connected'); return; } const target = users.find(u => u.id === userId); const name = target?.displayName || target?.name || userId; const confirmed = window.confirm( (lang === 'vi' ? `Xóa vĩnh viễn tài khoản "${name}"?\nThao tác này KHÔNG THỂ HOÀN TÁC.` : `Permanently delete account "${name}"?\nThis action CANNOT be undone.`) ); if (!confirmed) return; try { const { data, error } = await supabaseClient.rpc('cp_delete_user_account', { p_target_user_id: userId }); if (error) { console.error('cp_delete_user_account error:', error); alert((lang === 'vi' ? 'Lỗi: ' : 'Error: ') + error.message); return; } // Remove from local state setUsers(prev => prev.filter(u => u.id !== userId)); await logAdminAction('user.delete', 'user', userId, { name }); const timestamp = new Date().toTimeString().split(' ')[0]; setLogs(prev => [ { id: Date.now(), time: timestamp, type: 'error', text: (lang === 'vi' ? `Đã xóa tài khoản: ${name}` : `Account deleted: ${name}`) }, ...prev ]); } catch (err) { console.error('handleDeleteUser exception:', err); alert((lang === 'vi' ? 'Lỗi không mong muốn: ' : 'Unexpected error: ') + err.message); } }; // Save Settings configuration const handleSaveSettings = (e) => { e.preventDefault(); if (isStagingEnv) { alert(lang === 'vi' ? 'Trên môi trường cp-test, kết nối luôn được cố định tới Staging DB (tczrwnmqkmqzroiavgyd).' : 'On cp-test environment, connection is strictly locked to Staging DB (tczrwnmqkmqzroiavgyd).'); setIsSettingsOpen(false); return; } const finalUrl = (supabaseUrl || '').trim() || DEFAULT_SUPABASE_URL; const finalKey = (supabaseKey || '').trim() || DEFAULT_SUPABASE_KEY; localStorage.setItem('huio-cp-sb-url', finalUrl); localStorage.setItem('huio-cp-sb-key', finalKey); setSupabaseUrl(finalUrl); setSupabaseKey(finalKey); setIsSettingsOpen(false); alert(t('db.settings.success')); }; // Disconnect / Reset Supabase configuration const handleResetSettings = () => { if (isStagingEnv) { setSupabaseUrl(STAGING_SUPABASE_URL); setSupabaseKey(STAGING_SUPABASE_KEY); setIsSettingsOpen(false); return; } localStorage.removeItem('huio-cp-sb-url'); localStorage.removeItem('huio-cp-sb-key'); setSupabaseUrl(DEFAULT_SUPABASE_URL); setSupabaseKey(DEFAULT_SUPABASE_KEY); setIsSettingsOpen(false); }; // Password Authentication Login Handler const handlePasswordSignIn = async (e) => { if (e && e.preventDefault) e.preventDefault(); setAuthError(''); const email = (authEmail || '').trim().toLowerCase(); const password = authPassword; if (!email || !password) { setAuthError(lang === 'vi' ? 'Vui lòng nhập đầy đủ Email và Mật khẩu.' : 'Please enter both Email and Password.'); return; } const effectiveUrl = isStagingEnv ? STAGING_SUPABASE_URL : (supabaseUrl || DEFAULT_SUPABASE_URL); const effectiveKey = isStagingEnv ? STAGING_SUPABASE_KEY : (supabaseKey || DEFAULT_SUPABASE_KEY); if (!effectiveKey) { setIsSettingsOpen(true); setAuthError(lang === 'vi' ? 'Vui lòng cấu hình Supabase Key trước khi đăng nhập.' : 'Please configure Supabase Key before signing in.'); return; } if (window.supabase) { try { setIsSigningIn(true); const client = getSupabaseClient(effectiveUrl, effectiveKey); const { data, error } = await client.auth.signInWithPassword({ email, password }); if (error) { setIsSigningIn(false); const errMsg = error.message === 'Invalid login credentials' ? (t('auth.invalid_credentials') || 'Email hoặc mật khẩu không chính xác.') : error.message; setAuthError(errMsg); return; } setIsSigningIn(false); } catch (err) { setIsSigningIn(false); setAuthError(err.message || 'Authentication error'); } } else { setAuthError('Supabase SDK is not loaded. Please verify your connection.'); } }; // Demo Sign-in Handler — localhost only (strictly forbidden on production cp.huio.app) const handleDemoSignIn = () => { const host = window.location.hostname; const isLocalhost = host === 'localhost' || host === '127.0.0.1'; const demoAllowed = isLocalhost && localStorage.getItem('huio-cp-demo-mode') === '1'; if (!demoAllowed) { alert(lang === 'vi' ? 'Chế độ Demo chỉ khả dụng trên môi trường nội bộ (localhost).' : 'Demo mode is only available on local development (localhost).'); return; } setCurrentUser({ email: 'demo-admin@huio.app', user_metadata: { full_name: 'Demo Admin' } }); setAdminRole('manager'); setIsAuthenticated(true); setDbStats(INITIAL_DB_STATS); setUsers(INITIAL_USERS); setGroups(INITIAL_GROUPS); setCccdRequests(INITIAL_CCCD_REQUESTS); setRiskAlerts(INITIAL_RISK_ALERTS); setLogs(getInitialLogs(lang)); }; // Sign out / Logout Handler const handleLogout = async () => { if (window.supabase && currentUser?.email !== 'demo-admin@huio.app' && currentUser?.email !== 'admin@huio.app') { try { const client = getSupabaseClient(supabaseUrl, supabaseKey); await client.auth.signOut(); } catch (e) {} } try { if (typeof window !== 'undefined') { if (window.sessionStorage) window.sessionStorage.clear(); if (window.localStorage) { Object.keys(window.localStorage).forEach(k => { if (k.startsWith('sb-') && k.endsWith('-auth-token')) { window.localStorage.removeItem(k); } }); } } } catch (e) {} setIsAuthenticated(false); setCurrentUser(null); setAdminRole('none'); setAuthEmail(''); setAuthPassword(''); setAuthError(''); // Restore default/mock data on logout so the Login screen demo option works setDbStats(INITIAL_DB_STATS); setUsers(INITIAL_USERS); setGroups(INITIAL_GROUPS); setCccdRequests(INITIAL_CCCD_REQUESTS); setRiskAlerts(INITIAL_RISK_ALERTS); }; // Supabase Connection Settings Modal helper const renderSettingsModal = () => { const currentTheme = document.documentElement.getAttribute('data-theme') || 'editorial'; const toggleTheme = (newTheme) => { document.documentElement.setAttribute('data-theme', newTheme === 'editorial' ? 'light' : newTheme); localStorage.setItem('huio-cp-theme', newTheme); }; return ( setIsSettingsOpen(false)} title={lang === 'vi' ? 'Cài đặt hệ thống & Giao diện' : 'Settings & Appearance'} >
{/* Section 1: Language Picker */}
🌐 {lang === 'vi' ? 'Ngôn ngữ hiển thị' : 'Language'}
{/* Section 2: Theme Picker */}
🎨 {lang === 'vi' ? 'Chủ đề giao diện (Theme)' : 'Appearance Theme'}
{/* Section 3: Supabase Connection Form */}
⚡ {t('db.settings.title')}

{t('db.settings.sub')}

{isStagingEnv && (
🔒 {lang === 'vi' ? 'Môi trường Staging (cp-test): Kết nối bị khóa cố định vào Staging DB (tczrwnmqkmqzroiavgyd) để ngăn rò rỉ dữ liệu.' : 'Staging Environment (cp-test): Connection is locked to Staging DB (tczrwnmqkmqzroiavgyd) to prevent data leaks.'}
)}
setSupabaseUrl(e.target.value)} placeholder="https://xxxxxx.supabase.co" style={{ ...appStyles.textInput, ...(isStagingEnv ? { opacity: 0.7, cursor: 'not-allowed' } : {}) }} required disabled={isStagingEnv} id="input-sb-url" />
setSupabaseKey(e.target.value)} placeholder="sb_publishable_... or anon key" style={{ ...appStyles.textInput, ...(isStagingEnv ? { opacity: 0.7, cursor: 'not-allowed' } : {}) }} required disabled={isStagingEnv} id="input-sb-key" />
{/* Section 4: Telegram Bot Link Section */}

🤖 Kết nối Telegram Bot (@huio_team_bot)

Nhận thông báo khẩn cấp P0 (Người dùng mới, thanh toán, giao dịch ngân hàng cần duyệt, eKYC) trực tiếp qua Telegram.

{telegramLinkToken ? (
Mã kích hoạt của bạn (hết hạn sau 15 phút):
{telegramLinkToken}
👉 Mở Telegram (@huio_team_bot) để kích hoạt
) : ( )}
); }; // Render loading splash screen while verifying active session if (isAuthChecking) { return (
Huio
Control Panel
{lang === 'vi' ? 'Đang xác thực phiên làm việc…' : 'Authenticating session…'}
Huio • Control Panel v{window.CP_VERSION || '0.10.79'}
); } // Render Login state vs Dashboard workspace if (!isAuthenticated) { return (
{isStagingEnv && (
⚠️ STAGING · test data (tczrwnmqkmqzroiavgyd)
)}
Huio Platform { e.currentTarget.style.display = 'none'; }} />
Control Panel {isStagingEnv && ( STAGING · test data )}
{showTotpEnroll ? (

{t('auth.mfa.setup_title')}

{t('auth.mfa.setup_sub')}

{mfaError && (
⚠️ {mfaError}
)} {totpEnrollData?.totp?.qr_code && (
2FA QR Code
{t('auth.mfa.secret_label') || 'Secret Key:'}
{totpEnrollData.totp.secret}
)} {!totpEnrollData ? (
) : (
setTotpCode(e.target.value)} placeholder="123456" required autoFocus className="hu-input" id="input-totp-enroll-code" style={{ textAlign: 'center', letterSpacing: '0.25em', fontSize: '20px', fontWeight: '700' }} />
{!cpMfaRequired && ( )}
)}
) : showTotpChallenge ? (

{t('auth.mfa.challenge_title')}

{t('auth.mfa.challenge_sub')}

{mfaError && (
⚠️ {mfaError}
)}
setTotpCode(e.target.value)} placeholder="123456" required autoFocus className="hu-input" id="input-totp-challenge-code" style={{ textAlign: 'center', letterSpacing: '0.25em', fontSize: '22px', fontWeight: '700' }} />
) : ( <>

{t('auth.title')}

{t('auth.subtitle')}

{/* Password Sign-in Form */}
{authError && (
⚠️ {authError}
)}
setAuthEmail(e.target.value)} placeholder="admin@huio.app" required autoComplete="email" className="hu-input" id="input-auth-email" />
setAuthPassword(e.target.value)} placeholder="••••••••••••" required autoComplete="current-password" className="hu-input" id="input-auth-password" />
{(typeof window !== 'undefined' && (window.location.hostname === 'localhost' || window.location.hostname === '127.0.0.1')) && ( )}
)}
); } const handleBankPause = async (id) => { try { const { error } = await supabaseClient.rpc('pause_bank_integration_auto_confirm', { p_integration_id: id }); if (error) throw error; alert('Integration paused'); loadStats(supabaseClient); } catch (e) { alert(e.message); } }; const handleBankResume = async (id) => { try { const { error } = await supabaseClient.rpc('resume_bank_integration_auto_confirm', { p_integration_id: id }); if (error) throw error; alert('Integration resumed'); loadStats(supabaseClient); } catch (e) { alert(e.message); } }; const handleResolve = async (reportId, resolution, note, confirmMsg) => { if (confirmMsg && !confirm(confirmMsg)) return; try { setResolvingReportId(reportId); if (supabaseClient && typeof supabaseClient.rpc === 'function') { const { error } = await supabaseClient.rpc('resolve_member_report', { p_report_id: reportId, p_resolution: resolution, p_resolution_note: note }); if (error) { console.error('Error resolving dispute:', error); alert((t('common.error') || 'Error') + ': ' + error.message); return; } } const nowIso = new Date().toISOString(); const newStatus = resolution === 'under_investigation' ? 'under_investigation' : (resolution === 'dismissed' ? 'dismissed' : 'resolved'); setDisputes(prev => prev.map(d => d.id === reportId ? { ...d, status: newStatus, resolution, resolution_note: note, resolved_at: resolution !== 'under_investigation' ? nowIso : d.resolved_at } : d)); } catch (err) { console.error('Failed to execute dispute resolution:', err); } finally { setResolvingReportId(null); } }; // Helper to render group details tab and actions const renderGroupDetails = () => { if (!activeGroupDetail) return null; const getSlotUnpaidDebt = (slotId) => { const unpaid = groupUnpaidContribs.filter(c => c.slot_id === slotId && !c.paid); return unpaid.reduce((sum, c) => { const gross = Number(c.amount) + Number(c.hoa_hong_amount || 0); const paidVal = Number(c.paid_amount || 0) + Number(c.advance_deduction || 0); return sum + Math.max(0, gross - paidVal); }, 0); }; const currentPeriodNum = parseInt(activeGroupDetail.period.split(' / ')[0]) || 1; return (
{/* Info Grid */}
{t('groups.col.organizer')}
{activeGroupDetail.organizer}
{t('groups.col.amount')}
{vnd(activeGroupDetail.amount)}
{t('groups.col.period')}
{activeGroupDetail.period}
{t('groups.col.volume')}
{vnd(activeGroupDetail.volume)}
{/* Emergency Actions Panel */} {activeGroupDetail.status !== 'completed' && activeGroupDetail.status !== 'closed' && (

⚠️ {t('groups.detail.emergency')}

{currentPeriodNum > 1 && ( )}
)} {/* Tabs */}
{/* Tab Content */} {isGroupDetailLoading ? (
) : groupDetailTab === 'slots' ? (
{groupSlots.map(s => { const debt = getSlotUnpaidDebt(s.id); const memberName = s.hui_members ? s.hui_members.name : 'Unknown'; const memberPhone = s.hui_members ? formatPhone(s.hui_members.phone) : ''; return ( ); })} {groupSlots.length === 0 && ( )}
{t('groups.detail.slots.num')} {t('groups.detail.slots.owner')} {t('groups.detail.slots.status')} {t('groups.detail.slots.won')} {t('groups.detail.slots.debt')}
#{s.slot_number}
{memberName}
{memberPhone &&
{memberPhone}
}
{s.status.toUpperCase()} {s.won_period ? `${s.won_period}` : '-'} {debt > 0 ? ( {vnd(debt)} ) : ( ✓ 0 ₫ )}
No slots found.
) : (
{groupLedger.map(l => { const mName = l.hui_members ? l.hui_members.name : 'Unknown'; const isThu = l.direction === 'thu'; const formattedTime = l.created_at ? l.created_at.split('T')[0] + ' ' + l.created_at.split('T')[1].substring(0, 5) : ''; return ( ); })} {groupLedger.length === 0 && ( )}
{t('groups.detail.ledger.date')} {t('groups.detail.ledger.owner')} {t('groups.detail.ledger.type')} {t('groups.detail.ledger.method')} {t('groups.detail.ledger.amount')} {t('groups.detail.ledger.note')}
{formattedTime} {mName} {l.kind} {l.payment_method} {isThu ? '+' : '-'}{vnd(l.amount)} {l.note || ''}
No financial transactions found.
)}
); }; const renderWorkspaceContent = () => { // Fail-closed RBAC Guard: If role is not a recognized administrator role, block all content if (!['super_admin', 'admin', 'manager'].includes(adminRole)) { return (
🔒

{t('forbidden.title') || 'Truy cập bị hạn chế'}

{t('forbidden.desc') || 'Yêu cầu quyền quản trị viên hợp lệ.'}

); } // RBAC Route Guard: manager is restricted from infrastructure & financial settings const managerForbiddenTabs = ['bank', 'referral', 'broadcast', 'activity_logs', 'errors', 'bot_logs', 'chat_logs', 'system', 'admins', 'risk']; if (adminRole === 'manager' && managerForbiddenTabs.includes(activeTab)) { return (
🚫

{t('forbidden.title') || 'Truy cập bị hạn chế'}

{t('forbidden.desc') || 'Khu vực này yêu cầu quyền Quản trị viên cấp cao. Vai trò hiện tại của bạn không có quyền truy cập.'}

); } // RBAC Route Guard: admins view is strictly for super_admin if (activeTab === 'admins' && adminRole !== 'super_admin') { return (
👑

{t('forbidden.title') || 'Truy cập bị hạn chế'}

{lang === 'vi' ? 'Chỉ Super Admin mới có quyền quản lý danh sách đội ngũ và phân quyền.' : 'Only Super Admin has permissions to manage team members and roles.'}

); } const isExcluded = window.isExcludedAccount || ((id) => false); const realUsers = users.filter(u => !isExcluded(u.id) && !u.isTester && !u.isDemo && !u.deletedAt); const realGroups = groups.filter(g => !isExcluded(g.organizer_id) && !users.some(u => u.id === g.organizer_id && (u.isTester || u.isDemo || u.deletedAt))); switch (activeTab) { case 'user_detail': case 'user': return window.CpOrganizerCard?.renderOrganizerPage ? ( window.CpOrganizerCard.renderOrganizerPage({ userId: selectedOrganizerId, onBack: () => { setActiveTab('users'); }, lang, t, appStyles, supabaseClient, currentUser, adminRole, onSetTester: handleSetTester, onSetDemo: handleSetDemo, onPlanChanged: () => { if (supabaseClient) loadRealtimeData(supabaseClient); }, onOpenRecordPayment: (user, plan) => { handleOpenRecordPaymentModal(user, plan); }, onOpenChat: (userId) => { openSupportChatForMember(userId); }, }) ) : null; case 'dashboard': return window.CpDashboardView.renderDashboard({ lang, t, appStyles, users: realUsers, groups: realGroups, logs, dbStats, errorLogs, isConnected, urgentCounts: { bankReviewCount: urgentStats.bankReviewCount, dlqCount: urgentStats.dlqCount, cccdCount: cccdRequests.length, supportCount: supportQueue.filter(s => s.status === 'waiting').length, errorsCount: errorLogs.filter(e => new Date(e.created_at || Date.now()) > new Date(Date.now() - 24 * 3600 * 1000)).length, }, onNavigate: setActiveTab, }); case 'activity_logs': return window.CpActivityLogsView.renderActivityLogs({ lang, t, appStyles, logs, users: realUsers, logsCategoryFilter, setLogsCategoryFilter, logsTypeFilter, logsSearchQuery, setLogsSearchQuery, logsCurrentPage, setLogsCurrentPage, logsPerPage, logsDateFilter, setLogsDateFilter, logsUserFilter, setLogsUserFilter, supabaseClient, currentUser, loadRealtimeData, onOpenOrganizer: openOrganizerCard, }); case 'bank': return window.CpBankView?.renderBankView ? window.CpBankView.renderBankView({ lang, t, appStyles, supabaseClient, currentUser, onOpenOrganizer: openOrganizerCard, }) : null; case 'users': return window.CpUsersView.renderUsers({ lang, t, appStyles, users: users, userSearchQuery, setUserSearchQuery, userRoleFilter, setUserRoleFilter, userPlanFilter, setUserPlanFilter, userStatusFilter, setUserStatusFilter, userSortBy, setUserSortBy, userPage, setUserPage, userPerPage, setUserPerPage, handlePlanChange, handleRoleChange, handleToggleSuspend, handleToggleFeature, openSupportChatForMember, registrySupportOpening, openRecordPaymentModal: handleOpenRecordPaymentModal, onOpenOrganizer: openOrganizerCard, adminRole, onSetTester: handleSetTester, onSetDemo: handleSetDemo, onDeleteUser: handleDeleteUser, }); case 'payments': return window.CpPaymentsView.renderPayments({ lang, t, appStyles, payments, report: paymentsReport, loading: paymentsLoading, filters: paymentFilters, setFilters: setPaymentFilters, users: realUsers, admins: paymentAdmins, supabaseClient, onRecordPayment: handleRecordPayment, onRefundPayment: handleRefundPayment, onVoidPayment: handleVoidPayment, onResolveUnmatchedPayment: handleResolveUnmatchedPayment, adminRole, }); case 'referral': return window.CpReferralView.renderReferral({ lang, t, appStyles, overview: referralOverview, loading: referralLoading, onRefresh: fetchReferralOverview, onUpdateSettings: handleUpdateReferralSettings, onToggleAllowlist: handleToggleReferralAllowlist, onUpdateAttributionStatus: handleUpdateAttributionStatus, onCreatePayoutBatch: handleCreateReferralPayoutBatch, onRefreshCommissionsStatus: handleRefreshCommissionsStatus, onAddPartner: handleAddReferralPartner, onTogglePartner: handleToggleReferralPartner, onCalculateQuarterlyBonuses: handleCalculateQuarterlyBonuses, users: realUsers, }); case 'groups': return window.CpGroupsView.renderGroups({ lang, t, appStyles, groups: realGroups, users: realUsers, setActiveGroupDetail, setGroupDetailTab, loadGroupDetails, onOpenOrganizer: openOrganizerCard, }); case 'disputes': return window.CpDisputesView.renderDisputes({ lang, t, appStyles, disputes, disputesFilter, setDisputesFilter, resolvingReportId, handleResolve, setZoomImg, }); case 'risk': return ; case 'cccd': return window.CpCccdView.renderCccd({ lang, t, appStyles, users, cccdRequests, processingCccdId, setSelectedRequest, setRejectReason, setRejectError, handleCccdDecision, }); case 'waitlist': return window.CpWaitlistView.renderWaitlist({ lang, t, appStyles, waitlistEntries, }); case 'roadmap': return window.CpDocsViews.renderRoadmap({ lang, appStyles, isRoadmapLoading, roadmapContent, roadmapSearch, setRoadmapSearch, roadmapFilter, setRoadmapFilter, }); case 'changelog': return window.CpDocsViews.renderChangelog({ lang, appStyles, isChangelogLoading, changelogContent, changelogSearch, setChangelogSearch, changelogLimit, setChangelogLimit, }); case 'analytics': return window.CpAnalyticsView.renderAnalytics({ lang, t, appStyles, analyticsEvents, eventFilter, setEventFilter, platformFilter, setPlatformFilter, searchQuery, setSearchQuery, hoveredStep, setHoveredStep, }); case 'errors': return window.CpErrorsView.renderErrors({ lang, t, appStyles, errorLogs, searchQuery, setSearchQuery, errorFilter, setErrorFilter, errorPlatformFilter, setErrorPlatformFilter, showResolvedErrors, setShowResolvedErrors, errorTab, setErrorTab, setSelectedError, handleResolveError, handleResolveErrorGroup, handleOpenPromptModal, }); case 'broadcast': return window.CpBroadcastView.renderBroadcast({ lang, t, appStyles, users, logs, broadcastTarget, setBroadcastTarget, broadcastUserId, setBroadcastUserId, broadcastTitle, setBroadcastTitle, broadcastBody, setBroadcastBody, broadcastTitleEn, setBroadcastTitleEn, broadcastBodyEn, setBroadcastBodyEn, isBroadcasting, handleSendBroadcast, }); case 'system': return window.CpSystemView.renderSystem({ lang, t, appStyles, dbStats, auctionStreakAlerts, bankIntegrations, setIsSyncDocModalOpen, handleBankPause, handleBankResume, }); case 'bot_logs': return window.CpBotLogsView.renderBotLogs({ lang, t, appStyles, botLogs, botLogsSearch, setBotLogsSearch, botLogsDateFilter, setBotLogsDateFilter, botLogsUserFilter, setBotLogsUserFilter, botLogsCurrentPage, setBotLogsCurrentPage, botLogsPerPage, hasMoreBotLogs, isLoadingMoreBotLogs, loadMoreBotLogs, setSelectedBotChat, onRefresh: () => supabaseClient && loadRealtimeData(supabaseClient), }); case 'chat_logs': return window.CpChatLogsView.renderChatLogs({ lang, t, appStyles, chatLogs, chatLogsSearch, setChatLogsSearch, chatLogsDateFilter, setChatLogsDateFilter, chatLogsGroupFilter, setChatLogsGroupFilter, chatLogsCurrentPage, setChatLogsCurrentPage, chatLogsPerPage, chatReadReceipts, users, signedGroupImgUrls, setZoomImg, onRefresh: () => supabaseClient && loadRealtimeData(supabaseClient), }); case 'feedback': // Хуки внутри renderFeedback → рендерим как компонент, а не вызовом функции (React #310, белый экран 01.11). return React.createElement(window.CpFeedbackView.renderFeedback, { lang, t, appStyles, feedbacks, feedbackSearchQuery, setFeedbackSearchQuery, feedbackCategoryFilter, setFeedbackCategoryFilter, feedbackRatingFilter, setFeedbackRatingFilter, feedbackStatusFilter, setFeedbackStatusFilter, feedbackCurrentPage, setFeedbackCurrentPage, feedbacksPerPage, setSelectedFeedback, users: realUsers, onOpenOrganizer: openOrganizerCard, }); case 'support': // Хуки внутри renderSupport → рендерим как компонент, а не вызовом функции (React #310, белый экран 01.11). return React.createElement(window.CpSupportView.renderSupport, { lang, t, appStyles, supportQueue, supportLoading, supportFilter, setSupportFilter, supportSearchQuery, setSupportSearchQuery, selectedSupportConv, setSelectedSupportConv, fetchSupportQueue, supabaseClient, users: realUsers, onOpenOrganizer: openOrganizerCard, }); case 'admins': return window.renderAdmins ? window.renderAdmins({ lang, t, appStyles, supabaseClient, currentUser, adminRole, logAdminAction, }) : null; default: return null; } }; return (
{/* Sidebar */} { setActiveTab(tab); setMobileMenuOpen(false); }} adminRole={adminRole} isOpen={mobileMenuOpen} onClose={() => setMobileMenuOpen(false)} /> {/* Header and Workspace Layout */}
{isStagingEnv && (
⚠️ STAGING · test data (tczrwnmqkmqzroiavgyd)
)} setIsSettingsOpen(true)} currentUser={currentUser} adminRole={adminRole} onToggleSidebar={() => setMobileMenuOpen(prev => !prev)} />
{renderWorkspaceContent()}
{/* CCCD Detail Inspection Modal */} { setSelectedRequest(null); setRejectError(false); setRejectReason(''); }} title={t('cccd.modal.title')} > {selectedRequest && (

{t('cccd.modal.front')}

{signedFrontUrl ? ( ) : ( window.CpCharts.renderCccdSvg('front', selectedRequest.cccdNum, selectedRequest.name, selectedRequest.dob, selectedRequest.status) )} {/* Overlay controls */}
{signedFrontUrl && ( )}

{t('cccd.modal.back')}

{signedBackUrl ? ( ) : ( window.CpCharts.renderCccdSvg('back', selectedRequest.cccdNum, selectedRequest.name, selectedRequest.dob, selectedRequest.status) )} {/* Overlay controls */}
{signedBackUrl && ( )}
{/* eKYC provider result (Sprint 2) — informational only, moderator still overrides below */} {selectedRequest.ekycProvider && selectedRequest.ekycProvider !== 'manual' && (
{selectedRequest.ekycAutoApproved && ( {t('cccd.ekyc.badge')} )}
{t('cccd.ekyc.provider')}: {selectedRequest.ekycProvider.toUpperCase()}
{selectedRequest.livenessScore != null && (
{t('cccd.ekyc.liveness')}: {Number(selectedRequest.livenessScore).toFixed(3)}
)} {selectedRequest.faceMatchScore != null && (
{t('cccd.ekyc.faceMatch')}: {Number(selectedRequest.faceMatchScore).toFixed(3)}
)}
{t('cccd.ekyc.nfc')}: {selectedRequest.nfcRead ? '✓' : '—'}
{selectedRequest.ekycError && (
{t('cccd.ekyc.error')}: {selectedRequest.ekycError}
)}
)} {/* Reject Reason input */}
{rejectError && ( {t('cccd.reject.error_required')} )}
{ setRejectReason(e.target.value); if (rejectError && e.target.value.trim()) setRejectError(false); }} placeholder={t('cccd.reject.placeholder')} style={{ ...appStyles.textInput, ...(rejectError ? { borderColor: 'var(--hu-coral)', background: 'rgba(224, 76, 56, 0.04)' } : {}) }} id="input-reject-reason" />
)} {/* Member Registry → Live Support */} { closeRegistrySupportChat(); setActiveTab('support'); }} > {lang === 'vi' ? 'Mở hàng đợi' : 'Open Support Queue'} } > {registrySupportTarget && ( registrySupportTarget.demo ? (
{lang === 'vi' ? 'Chế độ demo: chat thật chỉ khả dụng khi đăng nhập admin Supabase.' : 'Demo mode: live chat requires a real Supabase admin session.'}
) : ( fetchSupportQueue(supportFilter)} /> ) )}
{/* Feedback Detail Inspection Modal */} setSelectedFeedback(null)} title={lang === 'vi' ? 'Chi tiết góp ý khách hàng' : 'User Feedback Details'} > {selectedFeedback && (
{t('feedback.col.user')}
{selectedFeedback.user_name}
{selectedFeedback.user_phone || 'N/A'}
{t('feedback.col.date')}
{new Date(selectedFeedback.created_at).toLocaleString()}
{t('feedback.col.category')}
{selectedFeedback.category === 'bug' ? (t('feedback.category.bug') || 'Bug Report 🐛') : selectedFeedback.category === 'feature' ? (t('feedback.category.feature') || 'Feature Request 💡') : selectedFeedback.category === 'billing' ? (t('feedback.category.billing') || 'Billing 💳') : (t('feedback.category.general') || 'General Review 💬')}
{t('feedback.col.rating')}
{'★'.repeat(selectedFeedback.rating || 0)}
{selectedFeedback.device_info && (
{t('feedback.col.device')}
💻 OS: {selectedFeedback.device_info.os} 📱 App v: {selectedFeedback.device_info.app_version} 🎨 DS v: {selectedFeedback.device_info.design_system_version} 🌐 Locale: {selectedFeedback.device_info.locale}
)}
{t('feedback.col.message')}
{selectedFeedback.message}
{/* Interactive Support Chat Widget */} handleUpdateFeedbackStatus(selectedFeedback.id, newSt)} /> {/* Status Update */}
{lang === 'vi' ? 'Cập nhật trạng thái' : 'Update Status'}
{['new', 'read', 'in_progress', 'resolved'].map(st => ( ))}
{/* Admin Notes */}
{lang === 'vi' ? 'Ghi chú của Admin' : 'Admin Notes'}