cityssm/parking-ticket-system

import { dateIntegerToString, isValidDateInteger } from '@cityssm/utils-datetime';
import sqlite from 'better-sqlite3';
import { parkingDB as databasePath } from '../../data/databasePaths.js';
export default function getLastTenConvictionBatches() {
    const database = sqlite(databasePath, {
        readonly: true
    });
    const batches = database
        .prepare(`select batchId, batchDate, lockDate, sentDate,
        recordCreate_userName, recordCreate_timeMillis,
        recordUpdate_userName, recordUpdate_timeMillis
        from ParkingTicketConvictionBatches
        where recordDelete_timeMillis is null
        order by batchId desc
        limit 10`)
        .all();
    database.close();
    for (const batch of batches) {
        batch.batchDateString = dateIntegerToString(batch.batchDate);
        batch.lockDateString = isValidDateInteger(batch.lockDate)
            ? dateIntegerToString(batch.lockDate)
            : '';
        batch.sentDateString = dateIntegerToString(batch.sentDate);
    }
    return batches;
}