cityssm/parking-ticket-system

import { dateIntegerToString } from '@cityssm/utils-datetime';
import sqlite from 'better-sqlite3';
import { parkingDB as databasePath } from '../../data/databasePaths.js';
import { getMakeFromNCIC } from '../../helpers/functions.vehicle.js';
export async function getAllLicencePlateOwners(licencePlateCountry, licencePlateProvince, licencePlateNumber) {
    const database = sqlite(databasePath, {
        readonly: true
    });
    const owners = database
        .prepare(`select recordDate, vehicleNCIC, vehicleYear, vehicleColor,
        ownerName1, ownerName2, ownerAddress, ownerCity, ownerProvince, ownerPostalCode
        from LicencePlateOwners
        where recordDelete_timeMillis is null
        and licencePlateCountry = ? and licencePlateProvince = ? and licencePlateNumber = ?
        order by recordDate desc`)
        .all(licencePlateCountry, licencePlateProvince, licencePlateNumber);
    database.close();
    for (const owner of owners) {
        owner.recordDateString = dateIntegerToString(owner.recordDate);
        owner.vehicleMake = await getMakeFromNCIC(owner.vehicleNCIC);
    }
    return owners;
}
export default getAllLicencePlateOwners;