Skip to main content

Bilingual Lease Documents (Qatar)

Qatar lease contracts are bilingual: an Arabic and an English text, and the Arabic version prevails before a court or the Rental Dispute Settlement Committee (Law 4/2008). PMFriend stores that pair per lease and renders it side-by-side.

What this feature deliberately does NOT do

PMFriend never machine-translates a contract. Anything contract-adjacent is gated on human Arabic legal review — the product stores and displays the two texts your practitioner produced; it makes no claim about their legal equivalence.

Data model

  • Table lease_documents (migration V38): at most one document per (lease, language)language IN ('ENGLISH','ARABIC'), enforced by a unique constraint. Re-uploading a language replaces the row and the blob (row first, old blob deleted after the save, so a failed replacement never leaves the lease without its previous file).
  • Blobs ride the same DocumentStorage adapter as property documents (S3 in production, filesystem in dev), keyed lease-documents/{leaseId}/{documentId}.{ext}.
  • Accepted: PDF or an image scan (JPEG/PNG/WebP/HEIC), max 25 MB.
  • Row-level security: same per-agency isolation as every other table.

API

EndpointWhat
POST /api/v1/leases/{leaseId}/documentsmultipart file + language=ENGLISH|ARABIC; replaces the existing version of that language
GET /api/v1/leases/{leaseId}/documentsthe stored pair (0–2 entries; each carries prevails: true for Arabic)
GET /api/v1/lease-documents/{id}/downloadstreams the file; ?inline=true serves it inline so the SPA can iframe it

Admin UI

On the property page's Current lease card (shown for QAR-currency agencies): a Contract versions section with two slots — English and العربية · Arabic (badged Prevails) — upload/replace per slot, and a View side-by-side toggle that renders both PDFs in paired iframes.

RDSC case-pack integration

The Qatar case pack's Lease & registration evidence section now records the contract versions on file per lease (— contract versions on file: Arabic (prevails, uploaded …) + English). When no Arabic version is on file for any lease, the pack carries a CAUTION: the Arabic text prevails before the Committee, and an English-only contract may need a certified Arabic translation before filing. As everywhere: record statements, not legal conclusions.

See also