Skip to content

Documentation


Documentation / @kizami/db / updateLeaveRequestStatus

Function: updateLeaveRequestStatus()

updateLeaveRequestStatus(db, params): Promise<{ createdAt: number; decidedAt: number | null; decidedBy: string | null; decisionNote: string | null; id: string; leaveDate: string; leaveType: string; minutes: number | null; reason: string; requestedBy: string; status: string; tenantId: string; unit: string; userId: string; } | null>

Defined in: packages/db/src/queries/leave.ts:246

status を更新する。fromStatus を渡すと条件付き UPDATE になり、0件更新なら null を返す(楽観ロック)。

Parameters

db

Database | SQLiteTransaction<"async", ResultSet, schema, ExtractTablesWithRelations<schema>>

params

UpdateLeaveRequestStatusParams

Returns

Promise<{ createdAt: number; decidedAt: number | null; decidedBy: string | null; decisionNote: string | null; id: string; leaveDate: string; leaveType: string; minutes: number | null; reason: string; requestedBy: string; status: string; tenantId: string; unit: string; userId: string; } | null>