Appearance
Documentation / @kizami/db / index / 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;requiredSteps:number;status:string;step1DecidedAt:number|null;step1DecidedBy:string|null;tenantId:string;unit:string;userId:string; } |null>
Defined in: packages/db/src/queries/leave.ts:266
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; requiredSteps: number; status: string; step1DecidedAt: number | null; step1DecidedBy: string | null; tenantId: string; unit: string; userId: string; } | null>