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 payer",
description: "Removes a peerId as a payer 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 payer from item from receipt "${receipt.id}".`,
});
}
const deleteResult = await database
.deleteFrom("receiptItemPayers")
.where((eb) =>
eb.and({
itemId: input.itemId,
peerId: input.peerId,
}),
)
.returning("receiptItemPayers.peerId")
.executeTakeFirst();
if (!deleteResult) {
throw new TRPCError({
code: "NOT_FOUND",
message: `Peer "${input.peerId}" does not pay for item "${input.itemId}" on receipt "${receipt.id}" doesn't exist.`,
});
}
});
|