cityssm/contract-expiration-tracker

import sqlite from "better-sqlite3";
import { contractsDB as databasePath } from "../../data/databasePaths.js";

import { dateStringToInteger } from "@cityssm/expressjs-server-js/dateTimeFns.js";

import type * as expressSession from "express-session";

interface AddContractForm {
  contractTitle: string;
  contractCategoryIsNew: "0" | "1";
  "contractCategory-existing": string;
  "contractCategory-new": string;
  contractParty: string;
  managingUserName: string;
  contractDescription: string;
  privateContractDescription: string;
  startDateString: string;
  endDateString: string;
  extensionDateString: string;
  hasBeenReplaced?: string;
}

export const addContract = (contractForm: AddContractForm, requestSession: expressSession.Session): number => {

  const rightNowMillis = Date.now();

  const database = sqlite(databasePath);

  const info = database.prepare("insert into Contracts (" +
    "contractTitle, contractCategory, contractParty, managingUserName," +
    " contractDescription, privateContractDescription," +
    " startDate, endDate, extensionDate, hasBeenReplaced," +
    " recordCreate_userName, recordCreate_timeMillis, recordUpdate_userName, recordUpdate_timeMillis" +
    ")" +
    " values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)")
    .run(contractForm.contractTitle,
      contractForm.contractCategoryIsNew === "1" ? contractForm["contractCategory-new"] : contractForm["contractCategory-existing"],
      contractForm.contractParty,
      contractForm.managingUserName,
      contractForm.contractDescription,
      contractForm.privateContractDescription,
      contractForm.startDateString === "" ? undefined : dateStringToInteger(contractForm.startDateString),
      contractForm.endDateString === "" ? undefined : dateStringToInteger(contractForm.endDateString),
      contractForm.extensionDateString === "" ? undefined : dateStringToInteger(contractForm.extensionDateString),
      (contractForm.hasBeenReplaced && contractForm.hasBeenReplaced !== "" ? 1 : 0),
      requestSession.user.userName,
      rightNowMillis,
      requestSession.user.userName,
      rightNowMillis);

  const contractId = info.lastInsertRowid as number;

  database.close();

  return contractId;
};