cityssm/lottery-licence-manager

import { runSQL_hasChanges } from "./_runSQL.js";

import * as dateTimeFns from "@cityssm/expressjs-server-js/dateTimeFns.js";

import type * as llm from "../../types/recordTypes";
import type * as expressSession from "express-session";


export const updateOrganizationBankRecord = (requestBody: llm.OrganizationBankRecord, requestSession: expressSession.Session): boolean => {

  return runSQL_hasChanges("update OrganizationBankRecords" +
    " set recordDate = ?," +
    " recordIsNA = ?," +
    " recordNote = ?," +
    " recordUpdate_userName = ?," +
    " recordUpdate_timeMillis = ?" +
    " where organizationID = ?" +
    " and recordIndex = ?" +
    " and recordDelete_timeMillis is null", [
      (requestBody.recordDateString === ""
        ? undefined
        : dateTimeFns.dateStringToInteger(requestBody.recordDateString)),
      requestBody.recordIsNA ? 1 : 0,
      requestBody.recordNote,
      requestSession.user.userName,
      Date.now(),
      requestBody.organizationID,
      requestBody.recordIndex]);
};