cityssm/parking-ticket-system

import createParkingTicketStatus from '../../database/parkingDB/createParkingTicketStatus.js';
import getOwnershipReconciliationRecords from '../../database/parkingDB/getOwnershipReconciliationRecords.js';
import { getFormattedOwnerAddress } from '../../helpers/functions.owner.js';
export default async function handler(request, response) {
    const records = await getOwnershipReconciliationRecords();
    const statusRecords = [];
    for (const record of records) {
        if (!record.isVehicleMakeMatch || !record.isLicencePlateExpiryDateMatch) {
            continue;
        }
        const ownerAddress = getFormattedOwnerAddress(record);
        const statusResponse = createParkingTicketStatus({
            recordType: 'status',
            ticketId: record.ticket_ticketId,
            statusKey: 'ownerLookupMatch',
            statusField: record.owner_recordDateString,
            statusNote: ownerAddress
        }, request.session.user, false);
        if (statusResponse.success) {
            statusRecords.push({
                ticketId: record.ticket_ticketId,
                statusIndex: statusResponse.statusIndex
            });
        }
    }
    response.json({
        success: true,
        statusRecords
    });
}