group-categories.ts

import type { Request, Response } from 'express';
import * as schema from '../db/schema';
import { and, eq } from 'drizzle-orm';
import { canViewGroupsInGroupCategory } from '../services/group-categories';
import { NodePgDatabase } from 'drizzle-orm/node-postgres';

export function getGroupCategoriesHandler(dbPool: NodePgDatabase<typeof schema>) {
  return async function (req: Request, res: Response) {
    const groupCategories = await dbPool.query.groupCategories.findMany();
    return res.json({ data: groupCategories });
  };
}

export function getGroupCategoryHandler(dbPool: NodePgDatabase<typeof schema>) {
  return async function (req: Request, res: Response) {
    const groupCategoryId = req.params.id;

    if (!groupCategoryId) {
      return res.status(400).json({ error: 'Group Category ID is required' });
    }

    const groupCategory = await dbPool.query.groupCategories.findFirst({
      where: and(eq(schema.groupCategories.id, groupCategoryId)),
    });

    return res.json({ data: groupCategory });
  };
}

export function getGroupCategoriesGroupsHandler(dbPool: NodePgDatabase<typeof schema>) {
  return async function (req: Request, res: Response) {
    const groupCategoryId = req.params.id;

    if (!groupCategoryId) {
      return res.status(400).json({ errors: ['expected group category id'] });
    }

    const groupCategory = await dbPool.query.groupCategories.findFirst({
      where: eq(schema.groupCategories.id, groupCategoryId),
    });

    if (!groupCategory) {
      return res.status(404).json({ error: 'Group Category not found' });
    }

    const canView = await canViewGroupsInGroupCategory(dbPool, groupCategory.id);

    if (!canView) {
      return res
        .status(403)
        .json({ error: 'You do not have permission to view this group category' });
    }

    const groups = await dbPool.query.groups.findMany({
      where: eq(schema.groups.groupCategoryId, groupCategory.id),
      columns: {
        secret: false,
      },
    });

    return res.json({ data: groups });
  };
}