cityssm/parking-ticket-system

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

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

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

export function getLicencePlateExpiryDateFromPieces(
  requestBody: ParkingTicket
): { success: boolean; message?: string; licencePlateExpiryDate?: number } {
  let licencePlateExpiryDate = 0

  const licencePlateExpiryYear =
    Number.parseInt(requestBody.licencePlateExpiryYear as string, 10) ?? 0
  const licencePlateExpiryMonth =
    Number.parseInt(requestBody.licencePlateExpiryMonth as string, 10) ?? 0

  if (licencePlateExpiryYear === 0 && licencePlateExpiryMonth === 0) {
    licencePlateExpiryDate = 0
  } else if (licencePlateExpiryYear === 0 || licencePlateExpiryMonth === 0) {
    return {
      success: false,
      message:
        'The licence plate expiry date fields must both be blank or both be completed.'
    }
  } else {
    const dateObject = new Date(
      licencePlateExpiryYear,
      licencePlateExpiryMonth - 1 + 1,
      // eslint-disable-next-line sonarjs/no-identical-expressions
      1 - 1,
      0,
      0,
      0,
      0
    )

    licencePlateExpiryDate = dateToInteger(dateObject) as number
  }

  return {
    success: true,
    licencePlateExpiryDate
  }
}

export default function updateParkingTicket(
  requestBody: ParkingTicket,
  sessionUser: PTSUser
): { success: boolean; message?: string } {
  const database = sqlite(databasePath)

  const nowMillis = Date.now()

  const issueDate = dateStringToInteger(requestBody.issueDateString)

  if (getConfigProperty('parkingTickets.ticketNumber.isUnique')) {
    // Ensure ticket number has not been used in the last two years
    const duplicateTicket = database
      .prepare(
        `select ticketId from ParkingTickets
          where recordDelete_timeMillis is null
          and ticketNumber = ?
          and ticketId != ?
          and abs(issueDate - ?) <= 20000`
      )
      .get(requestBody.ticketNumber, requestBody.ticketId, issueDate)

    if (duplicateTicket) {
      database.close()

      return {
        success: false,
        message:
          'A ticket with the same ticket number was seen in the last two years.'
      }
    }
  }

  let licencePlateExpiryDate: number | undefined

  if (getConfigProperty('parkingTickets.licencePlateExpiryDate.includeDay')) {
    licencePlateExpiryDate =
      requestBody.licencePlateExpiryDateString === ''
        ? undefined
        : dateStringToInteger(
            requestBody.licencePlateExpiryDateString as string
          )
  } else {
    const licencePlateExpiryDateReturn =
      getLicencePlateExpiryDateFromPieces(requestBody)

    if (licencePlateExpiryDateReturn.success) {
      licencePlateExpiryDate =
        licencePlateExpiryDateReturn.licencePlateExpiryDate as number
    } else {
      database.close()

      return {
        success: false,
        message: licencePlateExpiryDateReturn.message
      }
    }
  }

  const info = database
    .prepare(
      `update ParkingTickets
        set ticketNumber = ?,
        issueDate = ?,
        issueTime = ?,
        issuingOfficer = ?,
        locationKey = ?,
        locationDescription = ?,
        bylawNumber = ?,
        parkingOffence = ?,
        offenceAmount = ?,
        discountOffenceAmount = ?,
        discountDays = ?,
        licencePlateCountry = ?,
        licencePlateProvince = ?,
        licencePlateNumber = ?,
        licencePlateIsMissing = ?,
        licencePlateExpiryDate = ?,
        vehicleMakeModel = ?,
        vehicleVIN = ?,
        recordUpdate_userName = ?,
        recordUpdate_timeMillis = ?
        where ticketId = ?
        and resolvedDate is null
        and recordDelete_timeMillis is null`
    )
    .run(
      requestBody.ticketNumber,
      issueDate,
      timeStringToInteger(requestBody.issueTimeString),
      requestBody.issuingOfficer,
      requestBody.locationKey,
      requestBody.locationDescription,
      requestBody.bylawNumber,
      requestBody.parkingOffence,
      requestBody.offenceAmount,
      requestBody.discountOffenceAmount,
      requestBody.discountDays,
      requestBody.licencePlateCountry,
      requestBody.licencePlateProvince,
      requestBody.licencePlateNumber,
      requestBody.licencePlateIsMissing ? 1 : 0,
      licencePlateExpiryDate,
      requestBody.vehicleMakeModel,
      requestBody.vehicleVIN,
      sessionUser.userName,
      nowMillis,
      requestBody.ticketId
    )

  database.close()

  return info.changes > 0
    ? {
        success: true
      }
    : {
        success: false,
        message: 'An error occurred saving this ticket.  Please try again.'
      }
}