cityssm/lottery-licence-manager

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

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

import type * as expressSession from "express-session";


export const updateOrganizationReminder = (requestBody: {
  organizationID: string;
  reminderIndex: string;
  reminderTypeKey: string;
  dueDateString?: string;
  reminderStatus: string;
  reminderNote: string;
  dismissedDateString: string;
}, requestSession: expressSession.Session): boolean => {

  return runSQL_hasChanges("update OrganizationReminders" +
    " set reminderTypeKey = ?," +
    " dueDate = ?," +
    " reminderStatus = ?," +
    " reminderNote = ?," +
    " dismissedDate = ?," +
    " recordUpdate_userName = ?," +
    " recordUpdate_timeMillis = ?" +
    " where organizationID = ?" +
    " and reminderIndex = ?" +
    " and recordDelete_timeMillis is null", [
      requestBody.reminderTypeKey,
      (requestBody.dueDateString === ""
        ? undefined
        : dateTimeFns.dateStringToInteger(requestBody.dueDateString)),
      requestBody.reminderStatus,
      requestBody.reminderNote,
      (requestBody.dismissedDateString === ""
        ? undefined
        : dateTimeFns.dateStringToInteger(requestBody.dismissedDateString)),
      requestSession.user.userName,
      Date.now(),
      requestBody.organizationID,
      requestBody.reminderIndex
    ]);
};