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 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 | 6x 4x 4x 4x 4x 4x 1x 3x 3x 1x 2x 2x 2x 1x 1x 1x 1x 1x 1x 1x | import { TRPCError } from "@trpc/server";
import type { Updateable } from "kysely";
import { z } from "zod";
import { partSchema } from "~app/utils/validation";
import type { DB } from "~db/types.gen";
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: "Update receipt item payer",
description:
"Updates the paid part share of a peerId for a given receipt item.",
})
.input(
z.strictObject({
itemId: receiptItemIdSchema,
peerId: peerIdSchema,
update: z.strictObject({
type: z.literal("part"),
part: partSchema,
}),
}),
)
.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 modify receipt "${receipt.id}".`,
});
}
const receiptItemPayer = await database
.selectFrom("receiptItemPayers")
.where((eb) =>
eb.and({
itemId: input.itemId,
peerId: input.peerId,
}),
)
.select([])
.limit(1)
.executeTakeFirst();
if (!receiptItemPayer) {
throw new TRPCError({
code: "NOT_FOUND",
message: `Peer "${input.peerId}" does not pay for item "${input.itemId}" of the receipt "${receipt.id}".`,
});
}
let setObject: Updateable<DB["receiptItemPayers"]> = {};
switch (input.update.type) {
// We want this to blow up in case we add more cases
// oxlint-disable-next-line typescript/no-unnecessary-condition
case "part":
setObject = { part: input.update.part.toString() };
break;
}
await database
.updateTable("receiptItemPayers")
.set(setObject)
.where((eb) =>
eb.and({
itemId: input.itemId,
peerId: input.peerId,
}),
)
.executeTakeFirst();
});
|