cityssm/lottery-licence-manager

import * as reportFunctions from "../../helpers/functions.report.js";

import type { ConfigReportDefinition } from "../../types/configTypes";


const reminderFunctions = (): Map<string, () => unknown> => {
  const functions = new Map();
  functions.set("userFn_reminderTypeKeyToReminderType", reportFunctions.userFn_reminderTypeKeyToReminderType);
  return functions;
};


export const reports: { [reportName: string]: ConfigReportDefinition } = {

  "reminders-all": {
    sql: "select * from OrganizationReminders"
  },

  "reminders-formatted": {

    functions: reminderFunctions,

    sql: "select o.organizationName," +
      " userFn_reminderTypeKeyToReminderType(reminderTypeKey) as reminderType," +
      " dueDate, dismissedDate," +
      " reminderStatus, reminderNote" +
      " from OrganizationReminders r" +
      " left join Organizations o on r.organizationID = o.organizationID" +
      " where r.recordDelete_timeMillis is null" +
      " and o.recordDelete_timeMillis is null"
  },

  "reminders-byOrganization": {

    functions: reminderFunctions,

    sql: "select o.organizationName," +
      " userFn_reminderTypeKeyToReminderType(reminderTypeKey) as reminderType," +
      " dueDate, dismissedDate," +
      " reminderStatus, reminderNote" +
      " from OrganizationReminders r" +
      " left join Organizations o on r.organizationID = o.organizationID" +
      " where r.recordDelete_timeMillis is null" +
      " and r.organizationID = ?",

    params: (request) => [request.query.organizationID]
  }
};


export default reports;