cityssm/lottery-licence-manager

import { runSQL_hasChanges } from "./_runSQL.js";
import * as dateTimeFns from "@cityssm/expressjs-server-js/dateTimeFns.js";
export const updateOrganization = (requestBody, requestSession) => {
    return runSQL_hasChanges("update Organizations" +
        " set organizationName = ?," +
        " organizationAddress1 = ?," +
        " organizationAddress2 = ?," +
        " organizationCity = ?," +
        " organizationProvince = ?," +
        " organizationPostalCode = ?," +
        " trustAccountNumber = ?," +
        " fiscalStartDate = ?," +
        " fiscalEndDate = ?," +
        " isEligibleForLicences = ?," +
        " organizationNote = ?," +
        " recordUpdate_userName = ?," +
        " recordUpdate_timeMillis = ?" +
        " where organizationID = ?" +
        " and recordDelete_timeMillis is null", [
        requestBody.organizationName,
        requestBody.organizationAddress1,
        requestBody.organizationAddress2,
        requestBody.organizationCity,
        requestBody.organizationProvince,
        requestBody.organizationPostalCode,
        requestBody.trustAccountNumber,
        dateTimeFns.dateStringToInteger(requestBody.fiscalStartDateString),
        dateTimeFns.dateStringToInteger(requestBody.fiscalEndDateString),
        requestBody.isEligibleForLicences,
        requestBody.organizationNote,
        requestSession.user.userName,
        Date.now(),
        requestBody.organizationID
    ]);
};