Weekly Digests

type WeekData = {
  from: string;           // ISO date
  to: string;             // ISO date
  totalEvents: number;
  feeds: {
    count: number;
    totalMl: number;
    breastMin: number;
    perDay: number;       // Average feeds per day
  };
  diapers: {
    count: number;
    wet: number;
    dirty: number;
    perDay: number;       // Average diapers per day
  };
  sleep: {
    totalHours: number;
    sessions: number;
    avgPerDay: number;    // Average hours per day
  };
  meds: {
    taken: number;
    skipped: number;
    adherence: number;    // Percentage (0-100)
  };
  growth: number;         // Number of growth measurements
  notes: number;          // Number of notes logged
};

import { useQuery, useMutation } from "convex/react";
import { api } from "../../convex/_generated/api";

// Get weekly comparison
const comparison = useQuery(api.digest.getWeeklyComparison, { babyId });

// Generate AI summary (pseudo-code)
const summary = await generateAISummary(comparison);

// Save the digest
const saveDigest = useMutation(api.digest.saveDigest);
await saveDigest({
  babyId,
  weekStart: comparison.thisWeek.from,
  weekEnd: comparison.thisWeek.to,
  thisWeek: comparison.thisWeek,
  lastWeek: comparison.lastWeek,
  summary,
});

// List past digests
const digests = useQuery(api.digest.listDigests, { babyId, limit: 10 });

function generateDigestPrompt(thisWeek: WeekData, lastWeek: WeekData) {
  return `
Generate a friendly, concise weekly summary for a baby's activities.

This Week:
- Feeds: ${thisWeek.feeds.count} total (${thisWeek.feeds.perDay}/day), ${thisWeek.feeds.totalMl}ml
- Diapers: ${thisWeek.diapers.count} total (${thisWeek.diapers.perDay}/day)
- Sleep: ${thisWeek.sleep.totalHours} hours total (${thisWeek.sleep.avgPerDay} hrs/day)
- Medicine adherence: ${thisWeek.meds.adherence}%

Last Week:
- Feeds: ${lastWeek.feeds.count} total (${lastWeek.feeds.perDay}/day), ${lastWeek.feeds.totalMl}ml
- Diapers: ${lastWeek.diapers.count} total (${lastWeek.diapers.perDay}/day)
- Sleep: ${lastWeek.sleep.totalHours} hours total (${lastWeek.sleep.avgPerDay} hrs/day)
- Medicine adherence: ${lastWeek.meds.adherence}%

Provide:
1. Overview of this week's patterns
2. Notable changes from last week
3. Any concerns or positive trends
4. Brief encouragement for parents
  `;
}

🍼 Week of March 4-10, 2024

Great week! Your baby had 56 feeds this week (8 per day), maintaining a
steady feeding schedule. Total intake was 4,200ml, up slightly from last
week's 4,050ml.

😴 Sleep improved noticeably—baby got 98 hours total this week (14 hrs/day)
compared to 91 hours last week. The extra sleep is a positive sign of
growing comfort with nighttime routines.

🧷 Diaper changes were consistent at 49 this week (7 per day). Everything
looks healthy and normal.

💊 Excellent medicine adherence at 100%—all scheduled doses were given on time.

✨ Keep up the great work! The improved sleep is a wonderful milestone.

function DigestCard({ digest }: { digest: WeeklyDigest }) {
  const thisWeek = digest.thisWeek as WeekData;
  const lastWeek = digest.lastWeek as WeekData;
  
  const feedChange = thisWeek.feeds.perDay - lastWeek.feeds.perDay;
  const sleepChange = thisWeek.sleep.avgPerDay - lastWeek.sleep.avgPerDay;
  
  return (
    <div className="bg-white rounded-3xl p-6 shadow-sm border border-muted/10">
      <h3 className="text-xl font-bold mb-2">
        Week of {new Date(digest.weekStart).toLocaleDateString()}
      </h3>
      
      <div className="prose prose-sm mb-4">
        <p>{digest.summary}</p>
      </div>
      
      <div className="grid grid-cols-2 gap-4">
        <StatCard
          label="Feeds/day"
          value={thisWeek.feeds.perDay}
          change={feedChange}
        />
        <StatCard
          label="Sleep hrs/day"
          value={thisWeek.sleep.avgPerDay}
          change={sleepChange}
        />
      </div>
    </div>
  );
}

// Pseudo-code for email delivery
async function sendWeeklyDigestEmail(babyId: Id<"babyProfiles">) {
  const digest = await getLatestDigest({ babyId });
  const profile = await getBabyProfile({ id: babyId });
  const family = await getFamily(profile.familyId);
  
  await sendEmail({
    to: family.ownerEmail,
    subject: `${profile.name}'s Weekly Digest - Week of ${digest.weekStart}`,
    html: generateDigestEmailHTML(digest),
  });
}

function computeChanges(thisWeek: WeekData, lastWeek: WeekData) {
  return {
    feedsPerDayChange: thisWeek.feeds.perDay - lastWeek.feeds.perDay,
    feedsPerDayPercent: ((thisWeek.feeds.perDay - lastWeek.feeds.perDay) / lastWeek.feeds.perDay) * 100,
    
    sleepPerDayChange: thisWeek.sleep.avgPerDay - lastWeek.sleep.avgPerDay,
    sleepPerDayPercent: ((thisWeek.sleep.avgPerDay - lastWeek.sleep.avgPerDay) / lastWeek.sleep.avgPerDay) * 100,
    
    diapersPerDayChange: thisWeek.diapers.perDay - lastWeek.diapers.perDay,
    diapersPerDayPercent: ((thisWeek.diapers.perDay - lastWeek.diapers.perDay) / lastWeek.diapers.perDay) * 100,
    
    medsAdherenceChange: thisWeek.meds.adherence - lastWeek.meds.adherence,
  };
}

function TrendIndicator({ value, label }: { value: number; label: string }) {
  const isPositive = value > 0;
  const isNeutral = value === 0;
  
  if (isNeutral) {
    return <span className="text-muted">→ {label}</span>;
  }
  
  return (
    <span className={isPositive ? "text-green-600" : "text-red-600"}>
      {isPositive ? "↑" : "↓"} {Math.abs(value).toFixed(1)} {label}
    </span>
  );
}

// Convex cron job (pseudo-code)
export const generateWeeklyDigests = internalAction({
  handler: async (ctx) => {
    // Run every Monday at 9 AM
    const allProfiles = await ctx.runQuery(internal.events.listAllProfiles);
    
    for (const profile of allProfiles) {
      const comparison = await ctx.runQuery(api.digest.getWeeklyComparison, {
        babyId: profile._id,
      });
      
      const summary = await generateAISummary(comparison);
      
      await ctx.runMutation(api.digest.saveDigest, {
        babyId: profile._id,
        weekStart: comparison.thisWeek.from,
        weekEnd: comparison.thisWeek.to,
        thisWeek: comparison.thisWeek,
        lastWeek: comparison.lastWeek,
        summary,
      });
    }
  },
});