cityssm/lottery-licence-manager

import { formatPhoneNumber } from "@cityssm/expressjs-server-js/stringFns.js";
const baseFunctions = () => {
    const functions = new Map();
    functions.set("userFn_formatPhoneNumber", formatPhoneNumber);
    return functions;
};
export const reports = {
    "representatives-all": {
        sql: "select * from OrganizationRepresentatives"
    },
    "representatives-formatted": {
        sql: "select o.organizationName," +
            " o.fiscalStartDate, o.fiscalEndDate," +
            " representativeName, representativeTitle," +
            " representativeAddress1, representativeAddress2, representativeCity, representativeProvince," +
            " representativePostalCode," +
            " userFn_formatPhoneNumber(r.representativePhoneNumber) as representativePhoneNumberFormatted," +
            " userFn_formatPhoneNumber(r.representativePhoneNumber2) as representativePhoneNumber2Formatted," +
            " representativeEmailAddress" +
            " from OrganizationRepresentatives r" +
            " left join Organizations o on r.organizationID = o.organizationID" +
            " where o.recordDelete_timeMillis is null" +
            " order by organizationName, representativeName",
        functions: baseFunctions
    },
    "representatives-byOrganization": {
        sql: "select o.organizationName," +
            " representativeName, representativeTitle," +
            " representativeAddress1, representativeAddress2, representativeCity, representativeProvince," +
            " representativePostalCode," +
            " userFn_formatPhoneNumber(r.representativePhoneNumber) as representativePhoneNumberFormatted," +
            " userFn_formatPhoneNumber(r.representativePhoneNumber2) as representativePhoneNumber2Formatted," +
            " representativeEmailAddress," +
            " isDefault" +
            " from OrganizationRepresentatives r" +
            " left join Organizations o on r.organizationID = o.organizationID" +
            " where r.organizationID = ?" +
            " order by representativeName",
        params: (request) => [request.query.organizationID],
        functions: baseFunctions
    }
};
export default reports;