remix-demo

adminReport.server.ts

(1324B)

 import { json } from "@remix-run/server-runtime";
 import { aggregateReportPerUser } from "~/models/foodEntry.server";
 import { requireAdmin } from "~/session.server";
 
 export async function generateReport(request: Request) {
   await requireAdmin(request);
 
   const today = new Date();
   const oneWeekAgo = daysLater(7, today);
   const twoWeeksAgo = daysLater(7, oneWeekAgo);
   const [thisWeek, lastWeek] = await Promise.all([
     aggregate(oneWeekAgo, today),
     aggregate(twoWeeksAgo, oneWeekAgo),
   ]);
 
   try {
     return json({ thisWeek, lastWeek });
   } catch (error) {
     console.error("Failed to generate admin report:", error);
     return json({ error: "Failed to generate admin report" }, { status: 500 });
   }
 }
 
 async function aggregate(start: Date, end: Date) {
   const result = await aggregateReportPerUser(start, end);
   const { total, calories, users } = result.reduce(
     (a, b) => {
       a.users += 1;
       a.total += b._count._all;
       a.calories += b._sum.calories || 0;
       return a;
     },
     { total: 0, calories: 0, users: 0 }
   );
 
   return {
     start: start,
     end: end,
     total,
     averagePerUser: Math.round(calories / users),
   };
 }
 
 function daysLater(days: number, date: Date): Date {
   const result = new Date(date);
   result.setDate(date.getDate() - days);
   return result;
 }