UserSubmission.ts

import { sendConfirmationEmail } from './ConfirmationEmail';

const EMAIL_SENT = 'EMAIL_SENT';
const QUOTA_EXCEEDED = 'QUOTA_EXCEEDED';

export interface SubmissionInfo {
  fname: string
  lname: string
  email: string
  city: string
  reason: string
  include_email: string
  idempotency_key: string
  email_sent: string
  retry_count: number
}

export class UserSubmission {
  header: any;
  rowIndex: number;
  sheet: GoogleAppsScript.Spreadsheet.Sheet;
  row: SubmissionInfo;

  constructor(header: any, rowIndex: number, sheet: GoogleAppsScript.Spreadsheet.Sheet, rowData?: any[]) {
    this.header = header;
    this.rowIndex = rowIndex;
    this.sheet = sheet;
    // rowData is optional field, just if the row has already been pulled out into an array so you don't have to
    //   do additional call to google sheets server
    if (!rowData) {
      rowData = sheet.getRange(rowIndex, 1, 1, sheet.getDataRange().getLastColumn()).getValues()[0];
    }
    this.row = this.buildSubmissionInfo(rowData)
  };

  buildSubmissionInfo = (row: any[]): SubmissionInfo => (
    {
      fname: row[this.header.FIRST_NAME - 1],
      lname: row[this.header.LAST_NAME - 1],
      email: row[this.header.EMAIL_ADDRESS - 1],
      city: row[this.header.CITY - 1],
      reason: row[this.header.REASON - 1],
      include_email: row[this.header.EMAIL_INCLUDE - 1],
      idempotency_key: row[this.header.IDEMPOTENCY_KEY - 1],
      email_sent: row[this.header.EMAIL_SENT - 1],
      retry_count: row[this.header.RETRY_COUNT - 1]
    }
  );

  addIdempotencyKey = () => {
    if (this.row.idempotency_key === '') {
      this.row.idempotency_key = Utilities.getUuid();
      this.sheet.getRange(this.rowIndex, this.header.IDEMPOTENCY_KEY, 1, 1).setValue(this.row.idempotency_key);
    }
  }


  setCityTitleCase = () => {
    let city = this.row.city.toLowerCase().split(' ');
    for (let i = 0; i < city.length; i++) {
      city[i] = city[i].charAt(0).toUpperCase() + city[i].slice(1);
    }
    this.row.city = city.join(' ');
    this.sheet.getRange(this.rowIndex, this.header.CITY).setValue(this.row.city);
  }

  postToLob = () => {
    if (!this.row.include_email) {
      this.row.email = '';
    } else {
      this.row.email = this.row.email.toLowerCase();
    }

    this.setCityTitleCase();
    this.addIdempotencyKey();
    const url = "https://api.lob.com/v1/postcards";
    const data = {
      description: "Postcard",
        to: toAddress,
      from: null,
      front: front_tmpl,
      back: back_tmpl,
      merge_variables: this.row,
    };
    const options = {
      method: 'post',
      contentType: 'application/json',
      headers: {
        Authorization: "Basic " + Utilities.base64Encode(API_KEY + ":"),
        'Idempotency-key': this.row.idempotency_key,
      },
      payload: JSON.stringify(data),
      muteHttpExceptions: true
  
    };
    try{
       // @ts-ignore
      const response = UrlFetchApp.fetch(url, options);
      const responseCode = response.getResponseCode();
      const values = [[new Date(), responseCode]];

      if (responseCode === 200.0) {
        this.sheet.getRange(this.rowIndex, this.header.SENT_TO_LOB, 1, 2).setValues(values);
      } else {
        this.sheet.getRange(this.rowIndex, this.header.SENT_TO_LOB, 1, 2).setValues(values);
        Logger.log('response: ', response.getContentText());
      }
    } catch (error) {
      Logger.log('error: ', error);
    };
  };

  incrementRetryCount = () => {
    this.row.retry_count += 1;
    this.sheet.getRange(this.rowIndex, this.header.RETRY_COUNT, 1, 1).setValue(this.row.retry_count);
  };

  sendConfirmationEmail() {
    let emailSentStatus = EMAIL_SENT;
    const emailQuotaRemaining = MailApp.getRemainingDailyQuota();
    Logger.log("Remaining email quota: " + emailQuotaRemaining);
    Logger.log('this.row: ', this.row);
    try {
      sendConfirmationEmail(this.row)
    } catch (err) {
      Logger.log('err: ', err);
      emailSentStatus = err.toString() === 'Email quota exceeded' ? QUOTA_EXCEEDED : emailSentStatus;
    }
    this.sheet.getRange(this.rowIndex, this.header.EMAIL_SENT, 1, 1).setValue(emailSentStatus);
  };

  markFailedEmailSent = () => {
    this.sheet.getRange(this.rowIndex, this.header.FAILED_EMAIL_SENT, 1, 1).setValue('Yes');
  };

};