cityssm/lottery-licence-manager

import { runSQL_hasChanges } from "./_runSQL.js";
import * as dateTimeFns from "@cityssm/expressjs-server-js/dateTimeFns.js";
export const issueLicence = (licenceID, requestSession) => {
    const nowDate = new Date();
    const issueDate = dateTimeFns.dateToInteger(nowDate);
    const issueTime = dateTimeFns.dateToTimeInteger(nowDate);
    return runSQL_hasChanges("update LotteryLicences" +
        " set issueDate = ?," +
        " issueTime = ?," +
        " trackUpdatesAsAmendments = 1," +
        " recordUpdate_userName = ?," +
        " recordUpdate_timeMillis = ?" +
        " where licenceID = ?" +
        " and recordDelete_timeMillis is null" +
        " and issueDate is null", [
        issueDate,
        issueTime,
        requestSession.user.userName,
        nowDate.getTime(),
        licenceID
    ]);
};