Function main

scripts/sendWeeklyExcelSheet.mjs:83–140

()

}

async function main() {
  let args = parseArgs({
    allowPositionals: true,
    options: {
      local: {type: 'boolean', short: 'l', default: false}
    }
  });
  let isLocal = args.values.local;

  if (!isLocal && (!SLACK_TESTING_BOT_TOKEN || !SLACK_CHANNEL_ID)) {
    console.error('Missing required env vars: SLACK_TESTING_BOT_TOKEN, SLACK_CHANNEL_ID');
    process.exit(1);
  }

  let {startDate, endDate} = (() => {
    if (args.positionals.length === 0) {
      return getPreviousWeekRange();
    }
    if (args.positionals.length < 2) {
      console.error('Expected two date arguments: <startDate> <endDate>');
      process.exit(1);
    }
    let start = new Date(args.positionals[0]);
    let end = new Date(args.positionals[1]);
    if (isNaN(start.getTime()) || isNaN(end.getTime())) {
      console.error('Please verify that your dates are correctly formatted (YYYY-MM-DD)');
      process.exit(1);
    }
    return {startDate: args.positionals[0], endDate: args.positionals[1]};
  })();
  console.log(`Generating testing sheet for ${startDate} – ${endDate}...`);

  let {v3PRs, s2PRs, racPRs, aiPRs, otherPRs, offPRs, counts} = await generateData(
    startDate,
    endDate
  );
  console.log(
    `Found: V3=${counts.v3}, S2=${counts.s2}, RAC=${counts.rac}, AI=${counts.ai}, Other=${counts.other}, Off PRs=${counts.offPRs}`
  );

  let buffer = await createTestingSheet({v3PRs, s2PRs, racPRs, aiPRs, otherPRs, offPRs});

  let startLabel = formatDateLabel(startDate);
  let endLabel = formatDateLabel(endDate);
  let total = counts.v3 + counts.s2 + counts.rac + counts.ai + counts.other;
  let filename = `${endLabel}.xlsx`;
  let message = `*Testing sheet for ${startLabel} – ${endLabel}*\nV3: ${counts.v3} | S2: ${counts.s2} | RAC: ${counts.rac} | AI: ${counts.ai} | Other: ${counts.other} | Off PR: ${counts.offPRs} | Total: ${total}`;

  if (isLocal) {
    let outPath = path.resolve(process.cwd(), filename);
    await writeFile(outPath, buffer);
    console.log(`Saved testing sheet to ${outPath}`);
    return;
  }

  await uploadToSlack(buffer, filename, message);
  console.log('Posted to Slack successfully.');
}