cityssm/parking-ticket-system

import {
  dateIntegerToString,
  timeIntegerToString
} from '@cityssm/utils-datetime'
import sqlite from 'better-sqlite3'

import { parkingDB as databasePath } from '../../data/databasePaths.js'
import type { ParkingTicket } from '../../types/recordTypes.js'
import { canUpdateObject } from '../parkingDB.js'

import getLicencePlateOwner from './getLicencePlateOwner.js'
import getParkingLocation from './getParkingLocation.js'
import getParkingTicketRemarks from './getParkingTicketRemarks.js'
import getParkingTicketStatuses from './getParkingTicketStatuses.js'

export default async function getParkingTicket(
  ticketId: number,
  sessionUser: PTSUser
): Promise<ParkingTicket | undefined> {
  const database = sqlite(databasePath, {
    readonly: true
  })

  const ticket = database
    .prepare(
      `select t.*,
        l.locationName,
        s.statusKey as ownerLookup_statusKey,
        s.statusField as ownerLookup_statusField
        from ParkingTickets t
        left join ParkingTicketStatusLog s
          on t.ticketId = s.ticketId
          and s.statusKey in ('ownerLookupPending', 'ownerLookupError', 'ownerLookupMatch')
          and s.recordDelete_timeMillis is null
        left join ParkingLocations l
          on t.locationKey = l.locationKey
        where t.ticketId = ?
        order by s.statusDate desc, s.statusIndex desc
        limit 1`
    )
    .get(ticketId) as ParkingTicket | undefined

  if (ticket === undefined) {
    database.close()
    return undefined
  }

  ticket.recordType = 'ticket'
  ticket.issueDateString = dateIntegerToString(ticket.issueDate)
  ticket.issueTimeString = timeIntegerToString(ticket.issueTime)

  ticket.licencePlateExpiryDateString = dateIntegerToString(
    ticket.licencePlateExpiryDate
  )

  if (ticket.licencePlateExpiryDateString !== '') {
    ticket.licencePlateExpiryYear = Number.parseInt(
      ticket.licencePlateExpiryDateString.slice(0, 4),
      10
    )
    ticket.licencePlateExpiryMonth = Number.parseInt(
      ticket.licencePlateExpiryDateString.slice(5, 7),
      10
    )
  }

  ticket.resolvedDateString = dateIntegerToString(ticket.resolvedDate)
  ticket.canUpdate = canUpdateObject(ticket, sessionUser)

  // Owner
  if (ticket.ownerLookup_statusKey === 'ownerLookupMatch') {
    ticket.licencePlateOwner = await getLicencePlateOwner(
      ticket.licencePlateCountry,
      ticket.licencePlateProvince,
      ticket.licencePlateNumber,
      Number.parseInt(ticket.ownerLookup_statusField, 10),
      database
    )
  }

  // Location
  ticket.location = getParkingLocation(ticket.locationKey, database)

  // Status Log
  ticket.statusLog = getParkingTicketStatuses(ticketId, sessionUser, database)

  if (!ticket.canUpdate) {
    for (const status of ticket.statusLog) {
      status.canUpdate = false
    }
  }

  // Remarks
  ticket.remarks = getParkingTicketRemarks(ticketId, sessionUser, database)

  if (!ticket.canUpdate) {
    for (const remark of ticket.remarks) {
      remark.canUpdate = false
    }
  }

  database.close()

  return ticket
}