cityssm/faster-web-helper

import { dateToInteger, dateToTimeInteger } from '@cityssm/utils-datetime'
import sqlite from 'better-sqlite3'

import { getKeyGuid } from '../helpers/moduleHelpers.js'

import { databasePath } from './databaseHelpers.js'

interface CreatePurchaseOrderForm {
  tenant: string
  orderNumber: string
  orderTotal: string
}

export default function createPurchaseOrder(
  form: CreatePurchaseOrderForm,
  user: PurchaseOrderApprovalSessionUser
): string {
  const database = sqlite(databasePath)

  const rightNow = new Date()
  const lastUpdatedDate = dateToInteger(rightNow)
  const lastUpdatedTime = dateToTimeInteger(rightNow)

  const keyGuid = getKeyGuid()

  database
    .prepare(
      `insert into PurchaseOrders
        (tenant, orderNumber, initiatingUserName, orderTotal,
          lastUpdatedDate, lastUpdatedTime, purchaseOrderKeyGuid)
        values (?, ?, ?, ?, ?, ?, ?)`
    )
    .run(
      form.tenant,
      form.orderNumber,
      user.userName,
      form.orderTotal,
      lastUpdatedDate,
      lastUpdatedTime,
      keyGuid
    )

  const approvalAmount = Math.min(
    user.approvalMax,
    Number.parseFloat(form.orderTotal)
  )

  database
    .prepare(
      `insert into Approvals
        (tenant, orderNumber, userName, approvalAmount, isApproved,
          lastUpdatedDate, lastUpdatedTime)
        values (?, ?, ?, ?, ?, ?, ?)`
    )
    .run(
      form.tenant,
      form.orderNumber,
      user.userName,
      approvalAmount,
      1,
      lastUpdatedDate,
      lastUpdatedTime
    )

  database.close()

  return keyGuid
}