cityssm/lottery-licence-manager

import { formatPhoneNumber } from "@cityssm/expressjs-server-js/stringFns.js";

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


const baseFunctions = (): Map<string, () => unknown> => {
  const functions = new Map();
  functions.set("userFn_formatPhoneNumber", formatPhoneNumber);
  return functions;
};


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

  "organizations-all": {
    sql: "select * from Organizations"
  },

  "organizations-withDefaultRepresentatives": {
    sql: "select o.organizationID, o.organizationName, o.organizationAddress1, o.organizationAddress2," +
      " o.organizationCity, o.organizationProvince, o.organizationPostalCode," +
      " r.representativeName, r.representativeTitle, r.representativeAddress1, r.representativeAddress2," +
      " r.representativeCity, r.representativeProvince, r.representativePostalCode," +
      " userFn_formatPhoneNumber(r.representativePhoneNumber) as representativePhoneNumberFormatted," +
      " userFn_formatPhoneNumber(r.representativePhoneNumber2) as representativePhoneNumber2Formatted," +
      " r.representativeEmailAddress," +
      " o.recordUpdate_userName, o.recordUpdate_timeMillis" +
      " from Organizations o" +
      " left join OrganizationRepresentatives r on o.organizationID = r.organizationID and r.isDefault = 1" +
      " where o.recordDelete_timeMillis is null" +
      " and o.isEligibleForLicences = 1",
    functions: baseFunctions
  },

  "organizations-ineligible": {
    sql: "select o.organizationID, o.organizationName, o.organizationAddress1, o.organizationAddress2," +
      " o.organizationCity, o.organizationProvince, o.organizationPostalCode, o.organizationNote," +
      " o.recordDelete_userName, o.recordDelete_timeMillis" +
      " from Organizations o" +
      " where o.recordDelete_timeMillis is null" +
      " and o.isEligibleForLicences = 0"
  },

  "organizations-deleted": {
    sql: "select o.organizationID, o.organizationName, o.organizationAddress1, o.organizationAddress2," +
      " o.organizationCity, o.organizationProvince, o.organizationPostalCode," +
      " o.isEligibleForLicences, o.organizationNote," +
      " o.recordDelete_userName, o.recordDelete_timeMillis" +
      " from Organizations o" +
      " where o.recordDelete_timeMillis is not null"
  }
};


export default reports;