import React, { useState } from 'react'; import { X, Download, FileSpreadsheet, Check, Filter, Calendar, Table, FileText, ShieldCheck, Copy, Layers, CheckCircle2, Building, Users, Award, } from 'lucide-react'; import { StudentApplication, AttendanceRecord, FeePayment, Course, User, GradeItem } from '../types'; import { generateStudentRegistrationsCsv, generateAttendanceRecordsCsv, generateConsolidatedAuditReportCsv, triggerCsvDownload, } from '../utils/exportCsv'; interface BulkExportModalProps { isOpen: boolean; onClose: () => void; applications: StudentApplication[]; attendance: AttendanceRecord[]; fees: FeePayment[]; courses: Course[]; allUsers: User[]; grades: GradeItem[]; } export const BulkExportModal: React.FC = ({ isOpen, onClose, applications, attendance, fees, courses, allUsers, grades, }) => { if (!isOpen) return null; // Selected export category const [exportType, setExportType] = useState<'registrations' | 'attendance' | 'consolidated'>('registrations'); // Filters for registrations const [regCourseFilter, setRegCourseFilter] = useState('all'); const [regStatusFilter, setRegStatusFilter] = useState('all'); const [regStudyModeFilter, setRegStudyModeFilter] = useState('all'); // Filters for attendance const [attCourseFilter, setAttCourseFilter] = useState('all'); const [attStatusFilter, setAttStatusFilter] = useState('all'); const [attStudentSearch, setAttStudentSearch] = useState(''); // Date filters const [startDate, setStartDate] = useState(''); const [endDate, setEndDate] = useState(''); // Status feedback const [downloadSuccess, setDownloadSuccess] = useState(false); const [copiedSuccess, setCopiedSuccess] = useState(false); const [showPreviewTable, setShowPreviewTable] = useState(true); // Compute active dataset results let exportResult = { csvString: '', count: 0, filename: '', }; if (exportType === 'registrations') { exportResult = generateStudentRegistrationsCsv(applications, courses, fees, { courseCode: regCourseFilter, status: regStatusFilter, studyMode: regStudyModeFilter, startDate: startDate || undefined, endDate: endDate || undefined, }); } else if (exportType === 'attendance') { exportResult = generateAttendanceRecordsCsv(attendance, applications, allUsers, courses, { courseCode: attCourseFilter, status: attStatusFilter, studentId: attStudentSearch || undefined, startDate: startDate || undefined, endDate: endDate || undefined, }); } else { exportResult = generateConsolidatedAuditReportCsv(applications, attendance, fees, courses, grades); } // Parse lines for the preview table const lines = exportResult.csvString .replace(/^\uFEFF/, '') .split('\r\n') .filter(l => l.trim().length > 0); const parseCsvLine = (line: string): string[] => { const result: string[] = []; let current = ''; let inQuotes = false; for (let i = 0; i < line.length; i++) { const char = line[i]; if (char === '"' && line[i + 1] === '"') { current += '"'; i++; } else if (char === '"') { inQuotes = !inQuotes; } else if (char === ',' && !inQuotes) { result.push(current); current = ''; } else { current += char; } } result.push(current); return result; }; const previewHeaders = lines.length > 0 ? parseCsvLine(lines[0]) : []; const previewRows = lines.slice(1, 6).map(parseCsvLine); const handleDownload = () => { triggerCsvDownload(exportResult.filename, exportResult.csvString); setDownloadSuccess(true); setTimeout(() => setDownloadSuccess(false), 3500); }; const handleCopyClipboard = async () => { try { await navigator.clipboard.writeText(exportResult.csvString.replace(/^\uFEFF/, '')); setCopiedSuccess(true); setTimeout(() => setCopiedSuccess(false), 3000); } catch (err) { console.error('Failed to copy CSV:', err); } }; const resetFilters = () => { setRegCourseFilter('all'); setRegStatusFilter('all'); setRegStudyModeFilter('all'); setAttCourseFilter('all'); setAttStatusFilter('all'); setAttStudentSearch(''); setStartDate(''); setEndDate(''); }; return (
{/* Header */}

Academic Registry Bulk Data Export

CSV • RFC 4180

Official institutional exports for local filing, regulatory audit & offline archive compliance.

{/* Modal Body */}
{/* Export Type Selector Tabs */}
{/* Option 1: Registrations */} {/* Option 2: Attendance */} {/* Option 3: Consolidated Audit */}
{/* Filtering Criteria Section */}
Export Filter Parameters:
{/* Registrations Filters */} {exportType === 'registrations' && (
)} {/* Attendance Filters */} {exportType === 'attendance' && (
setAttStudentSearch(e.target.value)} className="w-full p-2 bg-white border border-slate-300 rounded-lg text-slate-800 text-xs focus:ring-2 focus:ring-blue-500 focus:outline-none" />
)} {/* Consolidated Audit Info */} {exportType === 'consolidated' && (
Comprehensive Regulatory Audit Sheet (TEVETA & Ministry of Education)

This report automatically computes each student's attendance percentage, validates National Bank fee clearance, and cross-references academic grade averages to verify final examination eligibility.

)} {/* Date Range Inputs */} {exportType !== 'consolidated' && (
setStartDate(e.target.value)} className="w-full pl-8 pr-2 py-1.5 bg-white border border-slate-300 rounded-lg text-slate-800 text-xs focus:ring-2 focus:ring-emerald-500 focus:outline-none" />
setEndDate(e.target.value)} className="w-full pl-8 pr-2 py-1.5 bg-white border border-slate-300 rounded-lg text-slate-800 text-xs focus:ring-2 focus:ring-emerald-500 focus:outline-none" />
)}
{/* Audit Metrics & Summary Badge */}
{exportResult.count} {exportResult.count === 1 ? 'Record' : 'Records'} Matched • File: {exportResult.filename}

Soche Technical College • Registrar & Bursar Audit Portal • Blantyre, Malawi

{/* Live Data Preview Accordion/Table */}
Dataset Sample Preview (First 5 Rows of {exportResult.count}): {showPreviewTable && (
{previewHeaders.length > 0 ? (
{previewHeaders.map((header, idx) => ( ))} {previewRows.map((row, rIdx) => ( {row.map((cell, cIdx) => ( ))} ))}
{header}
{cell || '-'}
) : (
No records matched current filter criteria.
)}
)}
{/* Compliance & Local Filing Guidance Note */}
Local Filing & Compliance Standard: Generated files adhere to RFC 4180 standard with standard UTF-8 Byte Order Mark (BOM). Files can be immediately opened in Microsoft Excel, Google Sheets, or imported into Malawi TEVETA / MoEST central management databases.
{/* Modal Footer */}
); };