cityssm/parking-ticket-system

// eslint-disable-next-line eslint-comments/disable-enable-pair
/* eslint-disable @typescript-eslint/indent */

import sqlite from 'better-sqlite3'

import { parkingDB as databasePath } from '../../data/databasePaths.js'
import { getConfigProperty } from '../../helpers/functions.config.js'

export default function unresolveParkingTicket(
  ticketId: number,
  sessionUser: PTSUser
): { success: boolean; message?: string } {
  const database = sqlite(databasePath)

  // Check if the ticket is in the window
  const ticketObject = database
    .prepare(
      `select recordUpdate_timeMillis from ParkingTickets
        where ticketId = ?
        and recordDelete_timeMillis is null
        and resolvedDate is not null`
    )
    .get(ticketId) as
    | {
        recordUpdate_timeMillis: number
      }
    | undefined

  if (ticketObject === undefined) {
    database.close()

    return {
      success: false,
      message:
        'The ticket has either been deleted, or is no longer marked as resolved.'
    }
  } else if (
    ticketObject.recordUpdate_timeMillis +
      getConfigProperty('parkingTickets.updateWindowMillis') <
    Date.now()
  ) {
    database.close()

    return {
      success: false,
      message:
        'The ticket is outside of the window for removing the resolved status.'
    }
  }

  const info = database
    .prepare(
      `update ParkingTickets
        set resolvedDate = null,
        recordUpdate_userName = ?,
        recordUpdate_timeMillis = ?
        where ticketId = ?
        and resolvedDate is not null
        and recordDelete_timeMillis is null`
    )
    .run(sessionUser.userName, Date.now(), ticketId)

  database.close()

  return {
    success: info.changes > 0
  }
}