recordTypes.ts

export interface Record {
  recordCreate_userName?: string
  recordCreate_timeMillis?: number
  recordCreate_dateString?: string

  recordUpdate_userName?: string
  recordUpdate_timeMillis?: number
  recordUpdate_dateString?: string
  recordUpdate_timeString?: string

  recordDelete_userName?: string
  recordDelete_timeMillis?: number
  recordDelete_dateString?: string
}

/*
 * Licence
 */

export interface Licence extends Partial<LicenceCategory> {
  licenceId: number | ''
  licenceCategoryKey: string
  licenceNumber: string

  licenseeName: string
  licenseeBusinessName: string
  licenseeAddress1: string
  licenseeAddress2: string
  licenseeCity: string
  licenseeProvince: string
  licenseePostalCode: string

  isRenewal: boolean

  startDate: number
  startDateString?: string
  endDate?: number
  endDateString?: string

  issueDate?: number
  issueDateString?: string
  issueTime?: number
  issueTimeString?: string

  baseLicenceFee: number | ''
  baseReplacementFee: number | ''
  licenceFee: number | ''
  replacementFee: number | ''

  bankInstitutionNumber?: string
  bankTransitNumber?: string
  bankAccountNumber?: string
  bankName?: string

  relatedLicences?: Licence[]
  licenceCategory?: string
  licenceFields?: LicenceField[]
  licenceApprovals?: LicenceApproval[]
  licenceAdditionalFees?: LicenceAdditionalFee[]
  licenceTransactions?: LicenceTransaction[]
}

export interface LicenceField extends Partial<Licence> {
  licenceFieldKey: string
  licenceFieldValue: string

  licenceField?: string
  licenceFieldDescription?: string
  isRequired?: boolean
  minimumLength?: number
  maximumLength?: number
  pattern?: string
  printKey?: string
}

export interface LicenceApproval extends Partial<Licence> {
  licenceApprovalKey: string
  isApproved?: boolean

  licenceApproval?: string
  licenceApprovalDescription?: string
  isRequiredForNew?: boolean
  isRequiredForRenewal?: boolean
  printKey?: string
}

export interface LicenceAdditionalFee extends Partial<Licence> {
  licenceAdditionalFeeKey: string
  additionalFeeAmount: number

  additionalFee?: string
}

export interface LicenceTransaction extends Partial<Licence> {
  transactionIndex: number
  transactionDate?: number
  transactionDateString?: string
  transactionTime?: number
  transactionTimeString?: string
  bankInstitutionNumber?: string
  bankTransitNumber?: string
  bankAccountNumber?: string
  bankName?: string
  externalReceiptNumber?: string
  batchDate?: number
  batchDateString?: string
  transactionAmount: number
  transactionNote?: string
}

/*
 * Licence Category
 */

export interface LicenceCategory extends Record {
  licenceCategoryKey: string
  licenceCategory: string
  bylawNumber: string
  licenceLengthFunction: string
  licenceLengthYears: number
  licenceLengthMonths: number
  licenceLengthDays: number
  printEJS?: string

  licenceCategoryApprovals?: LicenceCategoryApproval[]
  licenceCategoryFees?: LicenceCategoryFee[]
  licenceCategoryAdditionalFees?: LicenceCategoryAdditionalFee[]
  licenceCategoryFields?: LicenceCategoryField[]

  hasEffectiveFee?: boolean
}

export interface LicenceCategoryApproval extends Record {
  licenceApprovalKey: string
  licenceCategoryKey: string
  licenceApproval: string
  licenceApprovalDescription: string
  isRequiredForNew: boolean
  isRequiredForRenewal: boolean
  printKey: string
  orderNumber?: number
}

export interface LicenceCategoryFee extends Record {
  licenceFeeId?: number
  licenceCategoryKey: string
  effectiveStartDate?: number
  effectiveStartDateString?: string
  effectiveEndDate?: number
  effectiveEndDateString?: string
  licenceFee: number
  renewalFee?: number
  replacementFee?: number
}

export interface LicenceCategoryAdditionalFee extends Record {
  licenceAdditionalFeeKey: string
  licenceCategoryKey: string
  additionalFee: string
  additionalFeeType: 'flat' | 'percent' | 'function'
  additionalFeeNumber?: number
  additionalFeeFunction?: string
  isRequired: boolean
  orderNumber?: number
}

export interface LicenceCategoryField extends Record {
  licenceFieldKey: string
  licenceCategoryKey: string
  licenceField: string
  licenceFieldDescription: string
  isRequired: boolean
  minimumLength: number
  maximumLength: number
  pattern: string
  printKey: string
  orderNumber?: number
}

export interface Batch {
  batchDate: number
  batchDateString: string
  recordUpdate_dateString: string
  transactionCount: number
}

/*
 * User
 */

declare global {
  export interface GLMUser {
    userName: string
    canUpdate: boolean
    isAdmin: boolean
  }
}

declare module 'express-session' {
  interface Session {
    user?: GLMUser
  }
}