cityssm/parking-ticket-system

import type { Request, Response } from 'express'

import cleanupLicencePlateOwnersTable from '../../database/parkingDB/cleanupLicencePlateOwnersTable.js'
import cleanupParkingBylawsTable from '../../database/parkingDB/cleanupParkingBylawsTable.js'
import cleanupParkingLocationsTable from '../../database/parkingDB/cleanupParkingLocationsTable.js'
import cleanupParkingOffencesTable from '../../database/parkingDB/cleanupParkingOffencesTable.js'
import cleanupParkingTicketRemarksTable from '../../database/parkingDB/cleanupParkingTicketRemarksTable.js'
import cleanupParkingTicketStatusLog from '../../database/parkingDB/cleanupParkingTicketStatusLog.js'
import cleanupParkingTicketsTable from '../../database/parkingDB/cleanupParkingTicketsTable.js'
import { getConfigProperty } from '../../helpers/functions.config.js'

export default function handler(request: Request, response: Response): void {
  const table = request.body.table

  const recordDeleteTimeMillis = Math.min(
    request.body.recordDelete_timeMillis as number,
    Date.now() - getConfigProperty('databaseCleanup.windowDays') * 86_400 * 1000
  )

  let success = false

  switch (table) {
    case 'parkingTickets': {
      success = cleanupParkingTicketsTable(recordDeleteTimeMillis)
      break
    }

    case 'parkingTicketRemarks': {
      success = cleanupParkingTicketRemarksTable(recordDeleteTimeMillis)
      break
    }

    case 'parkingTicketStatusLog': {
      success = cleanupParkingTicketStatusLog(recordDeleteTimeMillis)
      break
    }

    case 'licencePlateOwners': {
      success = cleanupLicencePlateOwnersTable(recordDeleteTimeMillis)
      break
    }

    case 'parkingOffences': {
      success = cleanupParkingOffencesTable()
      break
    }

    case 'parkingLocations': {
      success = cleanupParkingLocationsTable()
      break
    }

    case 'parkingBylaws': {
      success = cleanupParkingBylawsTable()
      break
    }

    default:
  }

  response.json({ success })
}