🚀 Major Update: v2.0.0 - Complete Administrative Dashboard ## Phase 1: Dashboard Overview & Authentication ✅ - Secure admin authentication with JWT tokens - Beautiful overview dashboard with key metrics - Role-based access control (admin, moderator permissions) - Professional MUI design with responsive layout ## Phase 2: User Management & Content Moderation ✅ - Complete user management with advanced data grid - Prayer request content moderation system - User actions: view, suspend, activate, promote, delete - Content approval/rejection workflows ## Phase 3: Analytics Dashboard ✅ - Comprehensive analytics with interactive charts (Recharts) - User activity analytics with retention tracking - Content engagement metrics and trends - Real-time statistics and performance monitoring ## Phase 4: Chat Monitoring & System Administration ✅ - Advanced conversation monitoring with content analysis - System health monitoring and backup management - Security oversight and automated alerts - Complete administrative control panel ## Key Features Added: ✅ **32 new API endpoints** for complete admin functionality ✅ **Material-UI DataGrid** with advanced filtering and pagination ✅ **Interactive Charts** using Recharts library ✅ **Real-time Monitoring** with auto-refresh capabilities ✅ **System Health Dashboard** with performance metrics ✅ **Database Backup System** with automated scheduling ✅ **Content Filtering** with automated moderation alerts ✅ **Role-based Permissions** with granular access control ✅ **Professional UI/UX** with consistent MUI design ✅ **Visit Website Button** in admin header for easy navigation ## Technical Implementation: - **Frontend**: Material-UI components with responsive design - **Backend**: 32 new API routes with proper authentication - **Database**: Optimized queries with proper indexing - **Security**: Admin-specific JWT authentication - **Performance**: Efficient data loading with pagination - **Charts**: Interactive visualizations with Recharts The Biblical Guide application now provides world-class administrative capabilities for complete platform management! 🤖 Generated with [Claude Code](https://claude.ai/code) Co-Authored-By: Claude <noreply@anthropic.com>
494 lines
14 KiB
TypeScript
494 lines
14 KiB
TypeScript
'use client';
|
|
|
|
import { useState, useEffect, useCallback } from 'react';
|
|
import {
|
|
Box,
|
|
TextField,
|
|
Select,
|
|
MenuItem,
|
|
FormControl,
|
|
InputLabel,
|
|
Card,
|
|
CardContent,
|
|
Alert,
|
|
Chip,
|
|
Avatar,
|
|
IconButton,
|
|
Tooltip,
|
|
Dialog,
|
|
DialogTitle,
|
|
DialogContent,
|
|
DialogActions,
|
|
Button,
|
|
Typography
|
|
} from '@mui/material';
|
|
import {
|
|
DataGrid,
|
|
GridColDef,
|
|
GridActionsCellItem,
|
|
GridRowParams,
|
|
GridPaginationModel
|
|
} from '@mui/x-data-grid';
|
|
import {
|
|
Visibility,
|
|
Block,
|
|
Delete,
|
|
AdminPanelSettings,
|
|
Person,
|
|
PersonOff
|
|
} from '@mui/icons-material';
|
|
|
|
interface User {
|
|
id: string;
|
|
email: string;
|
|
name: string | null;
|
|
role: string;
|
|
createdAt: string;
|
|
lastLoginAt: string | null;
|
|
_count: {
|
|
chatConversations: number;
|
|
prayerRequests: number;
|
|
bookmarks: number;
|
|
};
|
|
}
|
|
|
|
interface UserDetailModalProps {
|
|
userId: string | null;
|
|
open: boolean;
|
|
onClose: () => void;
|
|
onUserUpdate: (userId: string, action: string) => void;
|
|
}
|
|
|
|
function UserDetailModal({ userId, open, onClose, onUserUpdate }: UserDetailModalProps) {
|
|
const [user, setUser] = useState<any>(null);
|
|
const [loading, setLoading] = useState(false);
|
|
|
|
useEffect(() => {
|
|
if (userId && open) {
|
|
const fetchUser = async () => {
|
|
setLoading(true);
|
|
try {
|
|
const response = await fetch(`/api/admin/users/${userId}`, {
|
|
credentials: 'include'
|
|
});
|
|
if (response.ok) {
|
|
const data = await response.json();
|
|
setUser(data.user);
|
|
}
|
|
} catch (error) {
|
|
console.error('Error fetching user:', error);
|
|
} finally {
|
|
setLoading(false);
|
|
}
|
|
};
|
|
fetchUser();
|
|
}
|
|
}, [userId, open]);
|
|
|
|
const handleAction = async (action: string) => {
|
|
if (!userId) return;
|
|
|
|
try {
|
|
const response = await fetch(`/api/admin/users/${userId}`, {
|
|
method: 'PUT',
|
|
headers: { 'Content-Type': 'application/json' },
|
|
credentials: 'include',
|
|
body: JSON.stringify({ action })
|
|
});
|
|
|
|
if (response.ok) {
|
|
onUserUpdate(userId, action);
|
|
onClose();
|
|
}
|
|
} catch (error) {
|
|
console.error('Error updating user:', error);
|
|
}
|
|
};
|
|
|
|
return (
|
|
<Dialog open={open} onClose={onClose} maxWidth="md" fullWidth>
|
|
<DialogTitle>User Details</DialogTitle>
|
|
<DialogContent>
|
|
{loading ? (
|
|
<Typography>Loading...</Typography>
|
|
) : user ? (
|
|
<Box sx={{ py: 2 }}>
|
|
<Box sx={{ mb: 3 }}>
|
|
<Typography variant="h6" gutterBottom>
|
|
{user.name || 'Unknown User'}
|
|
</Typography>
|
|
<Typography color="text.secondary">{user.email}</Typography>
|
|
<Chip
|
|
label={user.role}
|
|
color={
|
|
user.role === 'admin' ? 'error' :
|
|
user.role === 'moderator' ? 'warning' :
|
|
user.role === 'suspended' ? 'default' : 'primary'
|
|
}
|
|
sx={{ mt: 1 }}
|
|
/>
|
|
</Box>
|
|
|
|
<Box sx={{ mb: 3 }}>
|
|
<Typography variant="subtitle1" gutterBottom>Account Information</Typography>
|
|
<Typography variant="body2">
|
|
<strong>Joined:</strong> {new Date(user.createdAt).toLocaleDateString()}
|
|
</Typography>
|
|
<Typography variant="body2">
|
|
<strong>Last Login:</strong> {user.lastLoginAt ? new Date(user.lastLoginAt).toLocaleDateString() : 'Never'}
|
|
</Typography>
|
|
</Box>
|
|
|
|
<Box sx={{ mb: 3 }}>
|
|
<Typography variant="subtitle1" gutterBottom>Activity Summary</Typography>
|
|
<Typography variant="body2">
|
|
<strong>Conversations:</strong> {user._count.chatConversations}
|
|
</Typography>
|
|
<Typography variant="body2">
|
|
<strong>Prayer Requests:</strong> {user._count.prayerRequests}
|
|
</Typography>
|
|
<Typography variant="body2">
|
|
<strong>Bookmarks:</strong> {user._count.bookmarks}
|
|
</Typography>
|
|
<Typography variant="body2">
|
|
<strong>Notes:</strong> {user._count.notes}
|
|
</Typography>
|
|
</Box>
|
|
|
|
{user.role !== 'admin' && (
|
|
<Box sx={{ display: 'flex', gap: 1, flexWrap: 'wrap' }}>
|
|
{user.role === 'suspended' ? (
|
|
<Button
|
|
variant="contained"
|
|
color="success"
|
|
onClick={() => handleAction('activate')}
|
|
>
|
|
Activate User
|
|
</Button>
|
|
) : (
|
|
<Button
|
|
variant="outlined"
|
|
color="warning"
|
|
onClick={() => handleAction('suspend')}
|
|
>
|
|
Suspend User
|
|
</Button>
|
|
)}
|
|
|
|
{user.role === 'user' && (
|
|
<Button
|
|
variant="outlined"
|
|
color="primary"
|
|
onClick={() => handleAction('make_moderator')}
|
|
>
|
|
Make Moderator
|
|
</Button>
|
|
)}
|
|
</Box>
|
|
)}
|
|
</Box>
|
|
) : (
|
|
<Typography>User not found</Typography>
|
|
)}
|
|
</DialogContent>
|
|
<DialogActions>
|
|
<Button onClick={onClose}>Close</Button>
|
|
</DialogActions>
|
|
</Dialog>
|
|
);
|
|
}
|
|
|
|
export function UserDataGrid() {
|
|
const [users, setUsers] = useState<User[]>([]);
|
|
const [loading, setLoading] = useState(true);
|
|
const [error, setError] = useState('');
|
|
const [paginationModel, setPaginationModel] = useState<GridPaginationModel>({
|
|
page: 0,
|
|
pageSize: 10,
|
|
});
|
|
const [rowCount, setRowCount] = useState(0);
|
|
const [search, setSearch] = useState('');
|
|
const [roleFilter, setRoleFilter] = useState('all');
|
|
const [selectedUserId, setSelectedUserId] = useState<string | null>(null);
|
|
const [modalOpen, setModalOpen] = useState(false);
|
|
const [deleteDialogOpen, setDeleteDialogOpen] = useState(false);
|
|
const [userToDelete, setUserToDelete] = useState<User | null>(null);
|
|
|
|
const fetchUsers = useCallback(async () => {
|
|
setLoading(true);
|
|
try {
|
|
const params = new URLSearchParams({
|
|
page: paginationModel.page.toString(),
|
|
pageSize: paginationModel.pageSize.toString(),
|
|
search,
|
|
role: roleFilter
|
|
});
|
|
|
|
const response = await fetch(`/api/admin/users?${params}`, {
|
|
credentials: 'include'
|
|
});
|
|
|
|
if (response.ok) {
|
|
const data = await response.json();
|
|
setUsers(data.users);
|
|
setRowCount(data.pagination.total);
|
|
} else {
|
|
setError('Failed to load users');
|
|
}
|
|
} catch (error) {
|
|
setError('Network error loading users');
|
|
} finally {
|
|
setLoading(false);
|
|
}
|
|
}, [paginationModel, search, roleFilter]);
|
|
|
|
useEffect(() => {
|
|
fetchUsers();
|
|
}, [fetchUsers]);
|
|
|
|
const handleUserUpdate = useCallback((userId: string, action: string) => {
|
|
// Refresh the data after user update
|
|
fetchUsers();
|
|
}, [fetchUsers]);
|
|
|
|
const handleViewUser = (params: GridRowParams) => {
|
|
setSelectedUserId(params.id as string);
|
|
setModalOpen(true);
|
|
};
|
|
|
|
const handleDeleteUser = (params: GridRowParams) => {
|
|
setUserToDelete(params.row as User);
|
|
setDeleteDialogOpen(true);
|
|
};
|
|
|
|
const confirmDeleteUser = async () => {
|
|
if (!userToDelete) return;
|
|
|
|
try {
|
|
const response = await fetch(`/api/admin/users/${userToDelete.id}`, {
|
|
method: 'DELETE',
|
|
credentials: 'include'
|
|
});
|
|
|
|
if (response.ok) {
|
|
fetchUsers();
|
|
setDeleteDialogOpen(false);
|
|
setUserToDelete(null);
|
|
}
|
|
} catch (error) {
|
|
console.error('Error deleting user:', error);
|
|
}
|
|
};
|
|
|
|
const getRoleChip = (role: string) => {
|
|
const colors: Record<string, any> = {
|
|
admin: 'error',
|
|
moderator: 'warning',
|
|
user: 'primary',
|
|
suspended: 'default'
|
|
};
|
|
|
|
return (
|
|
<Chip
|
|
label={role}
|
|
color={colors[role] || 'default'}
|
|
size="small"
|
|
variant="outlined"
|
|
/>
|
|
);
|
|
};
|
|
|
|
const columns: GridColDef[] = [
|
|
{
|
|
field: 'name',
|
|
headerName: 'User',
|
|
flex: 1,
|
|
minWidth: 200,
|
|
renderCell: (params) => (
|
|
<Box sx={{ display: 'flex', alignItems: 'center', gap: 1 }}>
|
|
<Avatar sx={{ width: 32, height: 32 }}>
|
|
{(params.row.name || params.row.email)[0].toUpperCase()}
|
|
</Avatar>
|
|
<Box>
|
|
<Typography variant="body2" fontWeight="medium">
|
|
{params.row.name || 'Unknown User'}
|
|
</Typography>
|
|
<Typography variant="caption" color="text.secondary">
|
|
{params.row.email}
|
|
</Typography>
|
|
</Box>
|
|
</Box>
|
|
)
|
|
},
|
|
{
|
|
field: 'role',
|
|
headerName: 'Role',
|
|
width: 120,
|
|
renderCell: (params) => getRoleChip(params.value)
|
|
},
|
|
{
|
|
field: 'createdAt',
|
|
headerName: 'Joined',
|
|
width: 120,
|
|
renderCell: (params) => new Date(params.value).toLocaleDateString()
|
|
},
|
|
{
|
|
field: 'lastLoginAt',
|
|
headerName: 'Last Login',
|
|
width: 120,
|
|
renderCell: (params) =>
|
|
params.value ? new Date(params.value).toLocaleDateString() : 'Never'
|
|
},
|
|
{
|
|
field: 'activity',
|
|
headerName: 'Activity',
|
|
width: 120,
|
|
renderCell: (params) => (
|
|
<Box>
|
|
<Typography variant="caption" display="block">
|
|
{params.row._count.chatConversations} chats
|
|
</Typography>
|
|
<Typography variant="caption" display="block">
|
|
{params.row._count.prayerRequests} prayers
|
|
</Typography>
|
|
</Box>
|
|
)
|
|
},
|
|
{
|
|
field: 'actions',
|
|
type: 'actions',
|
|
headerName: 'Actions',
|
|
width: 120,
|
|
getActions: (params) => {
|
|
const actions = [
|
|
<GridActionsCellItem
|
|
key="view"
|
|
icon={
|
|
<Tooltip title="View Details">
|
|
<Visibility />
|
|
</Tooltip>
|
|
}
|
|
label="View"
|
|
onClick={() => handleViewUser(params)}
|
|
/>
|
|
];
|
|
|
|
// Only show delete for non-admin users
|
|
if (params.row.role !== 'admin') {
|
|
actions.push(
|
|
<GridActionsCellItem
|
|
key="delete"
|
|
icon={
|
|
<Tooltip title="Delete User">
|
|
<Delete />
|
|
</Tooltip>
|
|
}
|
|
label="Delete"
|
|
onClick={() => handleDeleteUser(params)}
|
|
/>
|
|
);
|
|
}
|
|
|
|
return actions;
|
|
}
|
|
}
|
|
];
|
|
|
|
return (
|
|
<Box>
|
|
{/* Filters */}
|
|
<Card sx={{ mb: 3 }}>
|
|
<CardContent>
|
|
<Box sx={{ display: 'flex', gap: 2, flexWrap: 'wrap' }}>
|
|
<TextField
|
|
label="Search users"
|
|
value={search}
|
|
onChange={(e) => setSearch(e.target.value)}
|
|
size="small"
|
|
sx={{ minWidth: 250 }}
|
|
/>
|
|
<FormControl size="small" sx={{ minWidth: 150 }}>
|
|
<InputLabel>Role</InputLabel>
|
|
<Select
|
|
value={roleFilter}
|
|
label="Role"
|
|
onChange={(e) => setRoleFilter(e.target.value)}
|
|
>
|
|
<MenuItem value="all">All Roles</MenuItem>
|
|
<MenuItem value="admin">Admin</MenuItem>
|
|
<MenuItem value="moderator">Moderator</MenuItem>
|
|
<MenuItem value="user">User</MenuItem>
|
|
<MenuItem value="suspended">Suspended</MenuItem>
|
|
</Select>
|
|
</FormControl>
|
|
</Box>
|
|
</CardContent>
|
|
</Card>
|
|
|
|
{error && (
|
|
<Alert severity="error" sx={{ mb: 3 }}>
|
|
{error}
|
|
</Alert>
|
|
)}
|
|
|
|
{/* Data Grid */}
|
|
<Card>
|
|
<Box sx={{ height: 600 }}>
|
|
<DataGrid
|
|
rows={users}
|
|
columns={columns}
|
|
loading={loading}
|
|
paginationModel={paginationModel}
|
|
onPaginationModelChange={setPaginationModel}
|
|
rowCount={rowCount}
|
|
paginationMode="server"
|
|
pageSizeOptions={[10, 25, 50]}
|
|
disableRowSelectionOnClick
|
|
sx={{
|
|
border: 'none',
|
|
'& .MuiDataGrid-cell': {
|
|
borderBottom: '1px solid #f0f0f0'
|
|
}
|
|
}}
|
|
/>
|
|
</Box>
|
|
</Card>
|
|
|
|
{/* User Detail Modal */}
|
|
<UserDetailModal
|
|
userId={selectedUserId}
|
|
open={modalOpen}
|
|
onClose={() => setModalOpen(false)}
|
|
onUserUpdate={handleUserUpdate}
|
|
/>
|
|
|
|
{/* Delete Confirmation Dialog */}
|
|
<Dialog
|
|
open={deleteDialogOpen}
|
|
onClose={() => setDeleteDialogOpen(false)}
|
|
maxWidth="sm"
|
|
fullWidth
|
|
>
|
|
<DialogTitle>Delete User</DialogTitle>
|
|
<DialogContent>
|
|
<Typography>
|
|
Are you sure you want to delete user <strong>{userToDelete?.name || userToDelete?.email}</strong>?
|
|
</Typography>
|
|
<Typography variant="body2" color="error" sx={{ mt: 2 }}>
|
|
This action cannot be undone. All user data including conversations, prayer requests, and bookmarks will be permanently deleted.
|
|
</Typography>
|
|
</DialogContent>
|
|
<DialogActions>
|
|
<Button onClick={() => setDeleteDialogOpen(false)}>Cancel</Button>
|
|
<Button
|
|
onClick={confirmDeleteUser}
|
|
color="error"
|
|
variant="contained"
|
|
>
|
|
Delete User
|
|
</Button>
|
|
</DialogActions>
|
|
</Dialog>
|
|
</Box>
|
|
);
|
|
} |