import { type DateString, dateStringToInteger } from '@cityssm/utils-datetime'

import addOrUpdateContractField from './addOrUpdateContractField.js'
import deleteContractField from './deleteContractField.js'
import { acquireConnection } from './pool.js'

export interface UpdateContractForm {
  contractId: string | number
  contractTypeId: string | number
  burialSiteId: string | number

  contractStartDateString: DateString
  contractEndDateString: DateString | ''

  funeralHomeId?: string | number
  funeralDirectorName?: string

  purchaserName?: string
  purchaserAddress1?: string
  purchaserAddress2?: string
  purchaserCity?: string
  purchaserProvince?: string
  purchaserPostalCode?: string
  purchaserPhoneNumber?: string
  purchaserEmail?: string
  purchaserRelationship?: string

  contractTypeFieldIds?: string
  [fieldValue_contractTypeFieldId: `fieldValue_${string}`]: unknown
}

export default async function updateContract(
  updateForm: UpdateContractForm,
  user: User
): Promise<boolean> {
  const database = await acquireConnection()

  const result = database
    .prepare(
      `update Contracts
        set contractTypeId = ?,
        burialSiteId = ?,
        contractStartDate = ?,
        contractEndDate = ?,
        funeralHomeId = ?,
        funeralDirectorName = ?,
        purchaserName = ?,
        purchaserAddress1 = ?,
        purchaserAddress2 = ?,
        purchaserCity = ?,
        purchaserProvince = ?,
        purchaserPostalCode = ?,
        purchaserPhoneNumber = ?,
        purchaserEmail = ?,
        purchaserRelationship = ?,
        recordUpdate_userName = ?,
        recordUpdate_timeMillis = ?
        where contractId = ?
        and recordDelete_timeMillis is null`
    )
    .run(
      updateForm.contractTypeId,
      updateForm.burialSiteId === '' ? undefined : updateForm.burialSiteId,
      dateStringToInteger(updateForm.contractStartDateString),
      updateForm.contractEndDateString === ''
        ? undefined
        : dateStringToInteger(updateForm.contractEndDateString),
      updateForm.funeralHomeId === '' ? undefined : updateForm.funeralHomeId,
      updateForm.funeralDirectorName ?? '',
      updateForm.purchaserName ?? '',
      updateForm.purchaserAddress1 ?? '',
      updateForm.purchaserAddress2 ?? '',
      updateForm.purchaserCity ?? '',
      updateForm.purchaserProvince ?? '',
      updateForm.purchaserPostalCode ?? '',
      updateForm.purchaserPhoneNumber ?? '',
      updateForm.purchaserEmail ?? '',
      updateForm.purchaserRelationship ?? '',
      user.userName,
      Date.now(),
      updateForm.contractId
    )

  if (result.changes > 0) {
    const contractTypeFieldIds = (
      updateForm.contractTypeFieldIds ?? ''
    ).split(',')

    for (const contractTypeFieldId of contractTypeFieldIds) {
      const fieldValue = updateForm[
        `fieldValue_${contractTypeFieldId}`
      ] as string

      // eslint-disable-next-line @typescript-eslint/no-unnecessary-condition
      await ((fieldValue ?? '') === ''
        ? deleteContractField(
            updateForm.contractId,
            contractTypeFieldId,
            user,
            database
          )
        : addOrUpdateContractField(
            {
              contractId: updateForm.contractId,
              contractTypeFieldId,
              fieldValue
            },
            user,
            database
          ))
    }
  }

  database.release()

  return result.changes > 0
}