Data Export & Reporting

// Source: ExportMenu.tsx (lines 47-72)
<Popover open={open} onOpenChange={setOpen}>
  <PopoverTrigger asChild>
    <Button variant="outline" size="sm" className="gap-1.5 text-xs">
      <Download className="h-3.5 w-3.5" />
      Export
    </Button>
  </PopoverTrigger>
  <PopoverContent className="w-48 p-2" align="end">
    <button onClick={() => handleExport('csv')}>
      <FileSpreadsheet className="h-4 w-4 text-primary" />
      Export as CSV
    </button>
    <button onClick={() => handleExport('pdf')}>
      <FileText className="h-4 w-4 text-primary" />
      Export as PDF
    </button>
  </PopoverContent>
</Popover>

=== Dashboard Summary ===
Metric,Value
Posts Analyzed,12450
Active Topics,4
Active Alerts,2

=== Topics ===
Title,Hashtag,Sentiment,Volume,Change %,Crisis Level,Volatility,Summary
AI Regulation Debate,#AIRegulation,mixed,284500,42,medium,72,"35% fear, 28% anger → Main concerns: job displacement (48%), lack of oversight (31%)"
Climate Summit 2026,#ClimateSummit2026,negative,192300,-15,high,85,"42% anger, 25% sadness → Key frustrations: broken promises (55%), insufficient targets (30%)"

=== Emotion Breakdown ===
Topic,Emotion,Percentage,Count
AI Regulation Debate,fear,35,99575
AI Regulation Debate,anger,28,79660
AI Regulation Debate,surprise,18,51210
Climate Summit 2026,anger,42,80766
Climate Summit 2026,sadness,25,48075

=== Sentiment Timeline ===
Time,Positive %,Negative %,Neutral %,Volume
14:00,42,38,20,8500
15:00,45,35,20,9200
16:00,48,32,20,11400
17:00,44,40,16,15600

=== Live Feed ===
Platform,User,Emotion,Time,Text
X,@techinsider,anger,2m ago,"The AI regulation debate is heating up. Both sides make valid points but we need action NOW. #AIRegulation"
YouTube,TechReviewer,joy,5m ago,"Hands-on with iPhone 18 holographic display - this changes everything! Link in bio 🔥"

// Source: exportUtils.ts (lines 28-34)
function escapeCSV(val: string | number): string {
  const s = String(val);
  if (s.includes(',') || s.includes('"') || s.includes('\n')) {
    return `"${s.replace(/"/g, '""')}"`;
  }
  return s;
}

Sentiment Analysis Report
Generated: March 12, 2026, 2:30 PM

AI Regulation Debate (#AIRegulation)

35% fear, 28% anger → Main concerns: job displacement (48% mentions),
lack of oversight (31%), corporate monopoly (15%). Supporters cite
innovation benefits and safety improvements.

Key Takeaways:
• "We need guardrails, not roadblocks" — most repeated sentiment
• Tech workers express 3x more fear than general public
• EU regulation praised as template; US approach criticized

// Source: exportUtils.ts (lines 101-151)
const doc = new jsPDF({ orientation: 'landscape' });

// Title
doc.setFontSize(20);
doc.setTextColor(30, 30, 30);
doc.text('Sentiment Analysis Report', 14, 20);

// Tables
autoTable(doc, {
  head: [['Title', 'Hashtag', 'Sentiment', 'Volume', 'Change', 'Crisis', 'Volatility']],
  body: data.topics.map((t) => [
    t.title,
    t.hashtag,
    t.sentiment,
    String(t.volume),
    `${t.change > 0 ? '+' : ''}${t.change}%`,
    t.crisisLevel,
    String(t.volatility)
  ]),
  theme: 'striped',
  headStyles: { fillColor: [79, 70, 229] },  // Primary brand color
  margin: { left: 14, right: 14 },
  styles: { fontSize: 9 }
});

// Source: ExportMenu.tsx (lines 21-30)
const getExportData = () => {
  const topics = dbTopics && dbTopics.length > 0 
    ? dbTopics        // Use Supabase data if available
    : trendingTopics; // Fall back to mock data
  
  const timelineData = timeline && timeline.length > 0 
    ? timeline 
    : generateTrendData(24);
  
  return {
    topics,
    timeline: timelineData,
    feed: feed || [],
    stats: stats || { postCount: 0, topicCount: 0, alertCount: 0 }
  };
};

// Webhook payload includes export URLs
{
  "event": "scheduled_report",
  "topic": "AI Regulation",
  "export_urls": {
    "csv": "https://cdn.senti-radar.com/exports/ai-regulation-2026-03-12.csv",
    "pdf": "https://cdn.senti-radar.com/exports/ai-regulation-2026-03-12.pdf"
  },
  "summary": { ... }
}