cityssm/attendance-tracking

import { connect as sqlPoolConnect } from '@cityssm/mssql-multi-pool'
import type { IResult } from 'mssql'

import { getConfigProperty } from '../helpers/functions.config.js'
import type { AbsenceType } from '../types/recordTypes.js'

import { updateRecordOrderNumber } from './updateRecordOrderNumber.js'

export async function getAbsenceTypes(): Promise<AbsenceType[]> {
  const pool = await sqlPoolConnect(getConfigProperty('mssql'))

  const absenceTypeResult: IResult<AbsenceType> = await pool.request()
    .query(`select
      absenceTypeKey, absenceType, orderNumber
      from MonTY.AbsenceTypes
      where recordDelete_dateTime is null
      order by orderNumber, absenceType`)

  const absenceTypes = absenceTypeResult.recordset

  let expectedOrderNumber = -1

  for (const absenceType of absenceTypes) {
    expectedOrderNumber += 1

    if (absenceType.orderNumber !== expectedOrderNumber) {
      await updateRecordOrderNumber(
        'AbsenceTypes',
        absenceType.absenceTypeKey,
        expectedOrderNumber
      )
    }
  }

  return absenceTypes
}