Export attendance to an external payroll system

{
  "meta": { "count": 3 },
  "data": [
    {
      "employeeId": "3f1c9b2a-5d84-4e7a-9c11-2b6f8d0a4e73",
      "employeeCode": "EMP-0421",
      "date": "2026-06-15",
      "status": "Present",
      "workedMinutes": 525,
      "otMinutes": 45
    },
    {
      "employeeId": "8a2e4d61-7c93-4b05-8f2d-1e5c9a3b7d40",
      "employeeCode": "EMP-0518",
      "date": "2026-06-15",
      "status": "Absent",
      "workedMinutes": 0,
      "otMinutes": 0
    },
    {
      "employeeId": "c05b7f38-1a92-4e6d-b840-9f3c2e1a5d67",
      "employeeCode": "EMP-0733",
      "date": "2026-06-15",
      "status": "Leave",
      "workedMinutes": 0,
      "otMinutes": 0
    }
  ]
}

const BASE = "https://app.ontime.hosai.app";
const KEY = process.env.ONTIME_API_KEY!;

type AttendanceRow = {
  employeeId: string;
  employeeCode: string;
  date: string;
  status: "Present" | "Absent" | "Half" | "Leave" | "WeeklyOff" | "Holiday";
  workedMinutes: number;
  otMinutes: number;
};

async function get<T>(path: string): Promise<T> {
  for (let attempt = 0; attempt < 5; attempt++) {
    const res = await fetch(BASE + path, {
      headers: { Authorization: `Bearer ${KEY}` },
    });
    if (res.ok) return res.json() as Promise<T>;
    if (res.status === 429 || res.status >= 500) {
      await new Promise((r) => setTimeout(r, 2 ** attempt * 1000));
      continue;
    }
    throw new Error(`OnTime ${res.status} on ${path}: ${await res.text()}`);
  }
  throw new Error(`OnTime: gave up on ${path}`);
}

function datesIn(month: string): string[] {
  const [y, m] = month.split("-").map(Number);
  const days = new Date(Date.UTC(y, m, 0)).getUTCDate();
  return Array.from(
    { length: days },
    (_, i) => `${month}-${String(i + 1).padStart(2, "0")}`,
  );
}

/** Aggregate a month into one row per employee. */
async function monthSummary(month: string) {
  const byEmployee = new Map<
    string,
    { code: string; paidDays: number; lopDays: number; otMinutes: number }
  >();

  for (const date of datesIn(month)) {
    const { data } = await get<{ data: AttendanceRow[] }>(
      `/api/public/v1/attendance?date=${date}`,
    );

    for (const row of data) {
      const acc = byEmployee.get(row.employeeId) ?? {
        code: row.employeeCode,
        paidDays: 0,
        lopDays: 0,
        otMinutes: 0,
      };

      // Paid: worked, on approved leave, on a holiday, or a rest day.
      // Half days count as half. Absent is the only unpaid case.
      if (row.status === "Half") acc.paidDays += 0.5;
      else if (row.status === "Absent") acc.lopDays += 1;
      else acc.paidDays += 1;

      acc.otMinutes += row.otMinutes;
      byEmployee.set(row.employeeId, acc);
    }

    await new Promise((r) => setTimeout(r, 150)); // stay well under 600/min
  }

  return [...byEmployee.entries()].map(([employeeId, v]) => ({
    employeeId,
    employeeCode: v.code,
    month,
    paidDays: v.paidDays,
    lopDays: v.lopDays,
    otHours: Math.round((v.otMinutes / 60) * 100) / 100,
  }));
}

const rows = await monthSummary("2026-06");
console.log("employeeCode,month,paidDays,lopDays,otHours");
for (const r of rows) {
  console.log(
    `${r.employeeCode},${r.month},${r.paidDays},${r.lopDays},${r.otHours}`,
  );
}