query.forLocationCard.handler.ts

import { prisma } from '@weareinreach/db'
import { handleError } from '~api/lib/errorHandler'
import { globalWhere } from '~api/selects/global'
import { type TRPCHandlerParams } from '~api/types/handler'

import { type TForLocationCardSchema } from './query.forLocationCard.schema'

const forLocationCard = async ({ input, ctx }: TRPCHandlerParams<TForLocationCardSchema>) => {
	try {
		const { id, isEditMode } = input

		const canSeeAll = isEditMode && !!ctx.session?.user?.permissions

		const result = await prisma.orgLocation.findUniqueOrThrow({
			where: {
				id,
				...(!canSeeAll && globalWhere.isPublic()),
			},
			select: {
				id: true,
				name: true,
				street1: true,
				street2: true,
				city: true,
				postCode: true,
				latitude: true,
				longitude: true,
				notVisitable: true,
				published: true,
				deleted: true,
				country: { select: { cca2: true } },
				govDist: { select: { abbrev: true, tsKey: true, tsNs: true } },
				phones: {
					...(!canSeeAll && { where: { phone: globalWhere.isPublic() } }),
					select: { phone: { select: { primary: true, number: true, country: { select: { cca2: true } } } } },
				},
				attributes: { select: { attribute: { select: { tsNs: true, tsKey: true, icon: true } } } },
				services: {
					select: {
						service: {
							select: {
								services: { select: { tag: { select: { primaryCategory: { select: { tsKey: true } } } } } },
							},
						},
					},
				},
			},
		})

		const transformed = {
			...result,
			country: result.country.cca2,
			phones: result.phones.map(({ phone }) => ({ ...phone, country: phone.country.cca2 })),
			attributes: result.attributes.map(({ attribute }) => attribute),
			services: [
				...new Set(
					result.services.flatMap(({ service }) =>
						service.services.map(({ tag }) => tag.primaryCategory.tsKey)
					)
				),
			],
		}

		return transformed
	} catch (err) {
		return handleError(err)
	}
}
export default forLocationCard