#!/bin/bash

OUTPUT_CSV="shrewsbury_programs.csv"
echo "Program,Section,Dates,Schedule,Location,StartDate" > "$OUTPUT_CSV"

while read -r PID; do
  echo "Fetching $PID..."
  JSON=$(curl -s -L -A "Mozilla/5.0" "https://api.rec.us/v1/programs/$PID")
  
  # Extract program name
  PNAME=$(echo "$JSON" | jq -r '.data.programName')
  
  # Extract sections
  echo "$JSON" | jq -c '.data.sections[]' | while read -r SECTION; do
    SNAME=$(echo "$SECTION" | jq -r '.name')
    DATES=$(echo "$SECTION" | jq -r '.sessionsSummary.dateRange // ""')
    SCHED=$(echo "$SECTION" | jq -r '.sessionsSummary.recurrenceSummary // ""')
    LOC=$(echo "$SECTION" | jq -r '.sessionsSummary.locationSummary // ""')
    START=$(echo "$SECTION" | jq -r '.startDate // ""')
    
    # Escape quotes for CSV
    PNAME_ESC=$(echo "$PNAME" | sed 's/"/""/g')
    SNAME_ESC=$(echo "$SNAME" | sed 's/"/""/g')
    DATES_ESC=$(echo "$DATES" | sed 's/"/""/g')
    SCHED_ESC=$(echo "$SCHED" | sed 's/"/""/g')
    LOC_ESC=$(echo "$LOC" | sed 's/"/""/g')
    
    echo "\"$PNAME_ESC\",\"$SNAME_ESC\",\"$DATES_ESC\",\"$SCHED_ESC\",\"$LOC_ESC\",\"$START\"" >> "$OUTPUT_CSV"
  done
  
  # Small sleep to be polite
  sleep 0.2
done < program_ids.txt

echo "Done. Saved to $OUTPUT_CSV"