cityssm/parking-ticket-system

import { dateIntegerToString } from '@cityssm/utils-datetime';
import sqlite from 'better-sqlite3';
import { parkingDB as databasePath } from '../../data/databasePaths.js';
export default function getUnreceivedLookupBatches(includeUnlocked) {
    const database = sqlite(databasePath, {
        readonly: true
    });
    const batches = database
        .prepare(`select b.batchId, b.batchDate, b.lockDate, b.sentDate, b.mto_includeLabels,
        count(e.batchId) as batchEntryCount
        from LicencePlateLookupBatches b
        left join LicencePlateLookupBatchEntries e on b.batchId = e.batchId
        where b.recordDelete_timeMillis is null
        and b.receivedDate is null
        ${includeUnlocked ? '' : ' and b.lockDate is not null'}
        group by b.batchId, b.batchDate, b.lockDate, b.sentDate, b.mto_includeLabels
        order by b.batchId desc`)
        .all();
    database.close();
    for (const batch of batches) {
        batch.batchDateString = dateIntegerToString(batch.batchDate);
        batch.lockDateString = dateIntegerToString(batch.lockDate);
        batch.sentDateString = dateIntegerToString(batch.sentDate);
    }
    return batches;
}