Project: Okul Database · Hub: Okul Database — Reference
Reference: Payment Statuses & Config
payments.status Values
| Value | Turkish | Description | is_paid | is_failed |
|---|
pending | Beklemede | Awaiting payment | No | No |
success | Başarılı | Payment completed | Yes | No |
failed | Başarısız | Payment attempt failed | No | Yes |
future_payment | Gelecek Ödeme | Scheduled for future date | No | No |
future_payment_failed | Gelecek Ödeme Başarısız | Future payment failed | No | Yes |
payment_request | Ödeme Talebi | Payment link sent to customer | No | No |
cancelled | İptal Edildi | Manually cancelled | No | Yes |
refund | İade | Refunded | No | Yes |
in_progress | İşlemde | Processing (gateway) | No | No |
in_progress_failed | İşlemde Başarısız | Failed during processing | No | Yes |
Revenue Query Filter
-- ONLY count as revenue:
WHERE status = 'success' AND paid_at IS NOT NULL
customer_agreements.agreement_type Values
| Value | Description |
|---|
fixed | Fixed-price contract |
regular | Standard recurring contract |
zero_tax_arge | Zero-VAT R&D project contract |
subscription | Subscription-based |
subscription_arge | Subscription + R&D |
customer_agreements.status Values
| Value | Description |
|---|
active | Active contract |
inactive | Inactive/expired |
pending | Awaiting approval |
rejected | Rejected |
cancelled | Cancelled |
checkouts.status Values
| Value | Description |
|---|
DRAFT | Cart created, not submitted |
PENDING | Submitted, awaiting payment |
COMPLETED | Payment successful |
CANCELLED | Abandoned or cancelled |
coupon_codes Fields
| Field | Values | Description |
|---|
type | defacto, … | Coupon type (defacto = default) |
status | available, used, expired | Current coupon status |
is_used | '0', '1' | Quick-use flag |