Add Payment Flow

Integrates a Saudi-compatible payment gateway for processing earnest money, commissions, or subscription fees. Supports mada, Visa, Mastercard, and Apple Pay.

Inputs to gather

• Gateway — HyperPay (recommended for Saudi) or Moyasar
• Payment type — one-time (commission, deposit) or recurring (subscription)
• Entity — what is being paid for (dealId, subscriptionId, invoiceId)
• Amount source — fixed or computed from entity (e.g., deal commission amount)

Steps

1. Create the transactions model via /add-prisma-model:

   model transactions {
     id            String   @id @default(uuid())
     amount        Decimal
     currency      String   @default("SAR")
     status        String   @default("PENDING") // PENDING, COMPLETED, FAILED, REFUNDED
     gatewayRef    String?
     gatewayData   Json?
     entityType    String   // "deal", "subscription", "invoice"
     entityId      String
     userId        String
     organizationId String?
     createdAt     DateTime @default(now())
     updatedAt     DateTime @updatedAt
   }