index.ts

import { CronJob } from "cron";
import Spreadsheet from "./spreadsheet";

import * as creds from "./creds/SlackBot-0bd3a3481e0e.json";

import * as googleSpreadsheet from "google-spreadsheet";
import googleSpreadsheetKey from "./creds/googleSpreadsheetKey";

import * as moment from "moment";
const job = new CronJob("0 0 9 * * *", () => {
  main();
});

function main() {
  const momentNow = moment();

  if (shouldRunAtMoment(momentNow) === false) {
    return;
  }

  const doc: any = new googleSpreadsheet(googleSpreadsheetKey);
  const thisDate: number = moment().date();
  const lastDayInMonth = moment().daysInMonth();

  doc.useServiceAccountAuth(creds, (err) => {
    doc.getInfo((error, info) => {
      for (const worksheet of info.worksheets) {

        if (worksheet.title !== "TID: Planering och rapportering=>"
        && worksheet.title !== "Modellparametrar"
        && worksheet.title !== "Holidays") {
          const sheet: any = worksheet;
          const name = worksheet.title;
          const spreadsheet = new Spreadsheet(sheet, name, doc);

          const callFuncs = async () => {

            try {
              const datesArr: any = await spreadsheet.getRowColOfDates();

              let monthColNumbers: number[] = [];
              let datesWithoutWeekend: any[] = [];
              let workingDates: number[] = [];

              const holidaysArr: any = await spreadsheet.checkHolidays();

              if (isFirstBusinessDayOfTheMonth(momentNow)) {
                monthColNumbers = spreadsheet.getSpecificMonthSpan(datesArr, true);
                datesWithoutWeekend = spreadsheet.getWeekdays(datesArr, true);
                workingDates = spreadsheet.workingDates(datesWithoutWeekend, holidaysArr, true);
              } else {
                monthColNumbers = spreadsheet.getSpecificMonthSpan(datesArr, false);
                datesWithoutWeekend = spreadsheet.getWeekdays(datesArr, false);
                workingDates = spreadsheet.workingDates(datesWithoutWeekend, holidaysArr, false);
              }

              const reportedTimeObj: any = await spreadsheet.findRowOfReportedTime();
              const rowNumberOfReportedCells: number = spreadsheet.getRowNumberOfReportedTime(reportedTimeObj);
              const hourCells: any = await spreadsheet.getTimeReported(rowNumberOfReportedCells, monthColNumbers);
              spreadsheet.checkTimeFilled(workingDates, hourCells);
            } catch (err) {
              console.log(err);
          }
        };

          callFuncs();
        }
      }

    });
  });
}

function shouldRunAtMoment(momentArg) {
  return isFirstBusinessDayOfTheMonth(momentArg) || isLastBusinessDayOfTheMonth(momentArg);
}

function isFirstBusinessDayOfTheMonth(momentArg) {
  const firstBusinessDayOfMonth = getFirstBusinessDayOfMonth(momentArg);
  return firstBusinessDayOfMonth.date() === momentArg.date();
}

function isLastBusinessDayOfTheMonth(momentArg) {
  const lastBusinessDayOfMonth = getLastBusinessDayOfMonth(momentArg);
  return lastBusinessDayOfMonth.date() === momentArg.date();
}

function getFirstBusinessDayOfMonth(momentArg) {
  const momentToCheck = momentArg.clone().startOf("month");

  while (momentToCheck.isoWeekday() > 5) {
    momentToCheck.add(1, "days");
  }

  return momentToCheck;
}

function getLastBusinessDayOfMonth(momentArg) {
  const momentToCheck = momentArg.clone().endOf("month");

  while (momentToCheck.isoWeekday() > 5) {
    momentToCheck.subtract(1, "days");
  }

  return momentToCheck;
}

job.start();
// function x(err, holidaysArr) {
//   // istället för callback, "wrapper" funktion som använder promise
//   // om success: promise.resolve
//   // om error: promise.reject
//   // för denna wrapper kan man sedan göra await (async/await)
// }
// }