cityssm/lottery-licence-manager

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


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

  "amendments-all": {
    sql: "select * from LotteryLicenceAmendments"
  },

  "amendments-formatted": {

    sql: "select a.licenceID, l.externalLicenceNumber," +
      " o.organizationName," +
      " amendmentDate, amendmentTime," +
      " amendmentType, amendment," +
      " isHidden" +
      " from LotteryLicenceAmendments a" +
      " left join LotteryLicences l on a.licenceID = l.licenceID" +
      " left join Organizations o on l.organizationID = o.organizationID" +
      " where a.recordDelete_timeMillis is null" +
      " and l.recordDelete_timeMillis is null"
  },

  "amendments-byLicence": {

    sql: "select l.licenceID, l.externalLicenceNumber," +
      " o.organizationName," +
      " a.amendmentDate, a.amendmentTime," +
      " a.amendmentType, a.amendment," +
      " a.isHidden" +
      " from LotteryLicenceAmendments a" +
      " left join LotteryLicences l on a.licenceID = l.licenceID" +
      " left join Organizations o on l.organizationID = o.organizationID" +
      " where a.recordDelete_timeMillis is null" +
      " and a.licenceID = ?",

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


export default reports;