cityssm/contract-expiration-tracker

import sqlite from "better-sqlite3";
import { contractsDB as databasePath } from "../../data/databasePaths.js";
export const getContractCategories = (requestSession) => {
    let sql = "select distinct contractCategory" +
        " from Contracts" +
        " where recordDelete_timeMillis is null" +
        " and contractCategory != ''";
    const parameters = [];
    if (requestSession.user.canUpdate) {
        sql += " union select distinct contractCategory from ContractCategoryUsers";
    }
    else {
        sql += " and contractCategory in (select contractCategory from ContractCategoryUsers where userName = ?)";
        parameters.push(requestSession.user.userName);
    }
    sql += " order by contractCategory";
    const database = sqlite(databasePath, {
        readonly: true
    });
    const rows = database.prepare(sql).all(parameters);
    database.close();
    const contractCategories = [];
    for (const row of rows) {
        contractCategories.push(row.contractCategory);
    }
    return contractCategories;
};
export default getContractCategories;