No {it.platform.name} account exists for this person.
)}
);
})}
{items.length === 0 && (
Inbox zero
Nothing waiting for a second reviewer. Nice.
)}
);
}
// Export modal
function ExportModal({ people, filters, teamStats = [], fetchLogs, onClose, onToast }) {
const [exports, setExports] = useState({
people: true,
userLog: true,
teamActivity: true,
});
const [exporting, setExporting] = useState(false);
const [scope, setScope] = useState('all');
const toggleExport = (k) => setExports(e => ({ ...e, [k]: !e[k] }));
const selectedExportCount = Object.values(exports).filter(Boolean).length;
const doExport = async () => {
if (!exports.people && !exports.userLog && !exports.teamActivity) {
onToast('Select at least one export option.');
return;
}
setExporting(true);
// Determine which records to export based on scope
let rows = people;
if (scope === 'complete') {
rows = people.filter(p => computeCounts(p, PLATFORMS).complete);
} else if (scope === 'filtered' && filters) {
if (filters.q) {
const q = filters.q.toLowerCase();
rows = rows.filter(p => p.name.toLowerCase().includes(q) || p.category.toLowerCase().includes(q));
}
if (filters.status !== 'all') {
rows = rows.filter(p => {
const c = computeCounts(p, PLATFORMS);
const pc = computeProfileCounts(p);
const profDone = pc.qc === pc.total;
if (filters.status === 'complete') return c.complete && profDone;
if (filters.status === 'review') return c.unverified > 0 || c.missing > 0 || pc.unverified > 0;
if (filters.status === 'qc') return (c.verified > 0 || pc.verified > 0) && !(c.complete && profDone);
if (filters.status === 'attrs') return pc.unverified > 0 || pc.verified > 0;
return true;
});
}
if (filters.source !== 'all') rows = rows.filter(p => p.source === filters.source);
}
// Some people have more than one handle for the same platform (e.g. an old
// account plus a new one) — give each platform as many columns as its
// most-populated row needs, so no handle gets silently dropped.
const platformHandles = (p, platform) => (p.handles?.[platform.id] || []).filter(h => h?.merged);
const platformColumnCount = {};
PLATFORMS.forEach(platform => {
platformColumnCount[platform.id] = rows.reduce((max, p) => Math.max(max, platformHandles(p, platform).length), 1);
});
// Build header for People sheet: name, MEPP ID, one (or more) URL column(s) per platform.
// MEPP ID isn't part of today's /people payload — comes through as p.mepp_id
// if/when the backend adds it; left blank otherwise.
const header = ['Name', 'MEPP ID'];
PLATFORMS.forEach(platform => {
const count = platformColumnCount[platform.id];
for (let i = 0; i < count; i++) {
header.push(count > 1 ? `${platform.name} ${i + 1}` : platform.name);
}
});
const dataRows = rows.map(p => {
const row = [p.name, p.mepp_id || ''];
PLATFORMS.forEach(platform => {
const handles = platformHandles(p, platform);
const count = platformColumnCount[platform.id];
for (let i = 0; i < count; i++) {
const handle = handles[i];
row.push(handle ? `https://${URL_ROOT[platform.id]}${handle.merged}` : '');
}
});
return row;
});
const wb = XLSX.utils.book_new();
const addSheet = (sheetName, sheetHeader, sheetRows) => {
const ws = XLSX.utils.aoa_to_sheet([sheetHeader, ...sheetRows]);
XLSX.utils.book_append_sheet(wb, ws, sheetName);
};
if (exports.people) {
addSheet('People', header, dataRows);
}
if (exports.userLog) {
let logs = [];
if (typeof fetchLogs === 'function') {
try {
const res = await fetchLogs({ limit: 2000, skip: 0 });
logs = Array.isArray(res?.data) ? res.data : [];
} catch (err) {
console.error('Failed to fetch logs for export:', err);
onToast('Could not fetch user log data. Exporting other selected sheets.');
}
}
const logHeader = ['Log ID', 'User', 'Person', 'Person ID', 'Platform', 'Status Change', 'Timestamp'];
const logRows = logs.map(l => [
l.id || '',
l.user_name || '',
l.person_name || '',
l.person_id || '',
l.platform || '',
l.status_change || '',
l.timestamp || '',
]);
addSheet('User Activity Log', logHeader, logRows);
}
if (exports.teamActivity) {
const teamHeader = ['User ID', 'Name', 'Email', 'Role', 'Total Changes', 'Verified', 'QC', 'No Account'];
const teamRows = (teamStats || []).map(m => [
m.user_id || '',
m.name || '',
m.email || '',
m.role || '',
m.total_changes ?? 0,
m.verified_count ?? 0,
m.qc_count ?? 0,
m.non_existing_count ?? 0,
]);
addSheet('Team Statistics', teamHeader, teamRows);
}
const dateTag = new Date().toISOString().slice(0, 10);
const fileName = `social_handles_export_${dateTag}.xlsx`;
XLSX.writeFile(wb, fileName);
onToast(`Exported ${selectedExportCount} sheet${selectedExportCount !== 1 ? 's' : ''} — ${fileName}`);
setExporting(false);
onClose();
};
return (
e.stopPropagation()}>
Export data
Export options
{/* People section with nested scope selector */}
{exports.people && (
Scope
Columns: Name, MEPP ID, and one URL column per platform (extra numbered columns appear when someone has more than one handle for that platform; blank if no handle).
)}
{/* User Activity Log */}
{/* Team Statistics */}
One Excel file will be created with one sheet per selected option.