Zeiterfassung

db/migrations/20260924000100_time.sql

alter table app.time_entries  add constraint time_entries_no_overlap  exclude using gist (    employee_id with =,    tstzrange(started_at, ended_at, '[)') with &&  )  where (voided_at is null);

packages/rules/src/arbzg/index.ts

const { version, limits } = ruleSetFor(shift.date);const flag = (code, severity, facts = {}) => {  findings.push({ code, severity, date: shift.date,    ruleVersion: version, facts });};if (restMinutes !== null && restMinutes < limits.minRestMinutes) {  flag('ARBZG_5_REST_UNDER_11H', 'warning', { restMinutes });}

apps/api/src/db/database.ts

withTenant<T>(ctx: TenantContext, work: (trx: Trx) => Promise<T>): Promise<T> {  return this.transaction().execute(async (trx) => {    await sql`select set_config('app.tenant_id', ${ctx.tenantId}, true),      set_config('app.user_id', ${ctx.userId ?? ''}, true),      set_config('app.role', ${ctx.role}, true),      …`.execute(trx);    return work(trx);  });}

db/migrations/20260926000200_invoices.sql

insert into app.invoice_counters as c  (tenant_id, year, last_seq)values (app.tenant_id(), year_num, 1)on conflict (tenant_id, year)  do update set last_seq = c.last_seq + 1returning c.last_seq into seq;