All files / apps/web/src/handlers/receipt-item-consumers remove.ts

100% Statements 14/14
100% Branches 8/8
100% Functions 4/4
100% Lines 14/14

Press n or j to go to the next uncovered block, b, p or k for the previous block.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63              6x                       4x 4x       4x     4x         4x 1x         3x 3x 1x         2x     2x             2x 1x            
import { TRPCError } from "@trpc/server";
import { z } from "zod";
 
import { getAccessRole } from "~web/handlers/receipts/utils";
import { authProcedure } from "~web/handlers/trpc";
import { peerIdSchema, receiptItemIdSchema } from "~web/handlers/validation";
 
export const procedure = authProcedure
	.meta({
		title: "Remove receipt item consumer",
		description: "Removes a peerId as a consumer of a given receipt item.",
	})
	.input(
		z.strictObject({
			itemId: receiptItemIdSchema,
			peerId: peerIdSchema,
		}),
	)
	.mutation(async ({ input, ctx }) => {
		const { database } = ctx;
		const receipt = await database
			.selectFrom("receiptItems")
			.where("receiptItems.id", "=", input.itemId)
			.innerJoin("receipts", (qb) =>
				qb.onRef("receipts.id", "=", "receiptItems.receiptId"),
			)
			.innerJoin("users", (qb) =>
				qb.onRef("users.id", "=", "receipts.ownerUserId"),
			)
			.select(["receipts.id", "receipts.ownerUserId"])
			.limit(1)
			.executeTakeFirst();
		if (!receipt) {
			throw new TRPCError({
				code: "NOT_FOUND",
				message: `Receipt item "${input.itemId}" does not exist.`,
			});
		}
		const accessRole = await getAccessRole(database, receipt, ctx.auth.userId);
		if (accessRole !== "owner" && accessRole !== "editor") {
			throw new TRPCError({
				code: "FORBIDDEN",
				message: `Not enough rights to remove item from receipt "${receipt.id}".`,
			});
		}
		const deleteResult = await database
			.deleteFrom("receiptItemConsumers")
			.where((eb) =>
				eb.and({
					itemId: input.itemId,
					peerId: input.peerId,
				}),
			)
			.returning("receiptItemConsumers.peerId")
			.executeTakeFirst();
		if (!deleteResult) {
			throw new TRPCError({
				code: "NOT_FOUND",
				message: `Peer "${input.peerId}" does not consume item "${input.itemId}" on receipt "${receipt.id}" doesn't exist.`,
			});
		}
	});