Orders Schema · dazo/docs

Skema entitas Order & Payment Konco. Tabel orders adalah master polymorphic — tipe order ditentukan oleh relasi ke OrderSubscribe, OrderTopup, OrderWithdraw, dll.

`orders`

Master order — polymorphic via relasi subscribe(), topup(), withdraw(), transferBalance(), deduct(), payment(), businessManagers().

Field	Tipe	Catatan
`id`	UUID (PK)
`member_id`	UUID (FK)	→ `members.id`
`type`	string	`subscribe` / `topup` / `withdraw` / `transfer_balance` / `deduct` / `payment`
`flag`	string	`pending` / `paid` / `processed` / `cancelled` / `failed`
`amount`	decimal:2	Nominal
`refcode`	string	Kode referensi invoice
`description`	text	Catatan
`bank_account_id`	UUID (FK, nullable)	→ `bank_accounts.id`
`created_by`	UUID	`WithAuthor`
`updated_by`	UUID	`WithAuthor`
timestamps	—

Relasi polymorphic

Method	Tipe	Target
`subscribe()`	HasMany	`OrderSubscribe`
`withdraw()`	HasMany	`OrderWithdraw`
`deduct()`	HasOne	`OrderDeduct`
`payment()`	HasOne	`Payment`
`businessManagers()`	BelongsToMany	`MemberBm` via `order_business_managers`
`member()`	BelongsTo	`Member`
`member_bm()`	BelongsTo	`MemberBm`
`AdminRequest()`	HasOne	`AdminRequest`
`bank_account()`	BelongsTo	`BankAccount`

Accessor

Accessor	Fungsi
`transaction_type`	Label tipe transaksi
`transaction_icon`	Icon CSS class
`transaction_status_label`	Label status (`flag`)
`request_status_label`	Label status admin request
`account_count`	Jumlah akun terlibat
`bm_problem_count`	Jumlah BM bermasalah

`order_subscribes`

Detail order sewa akun iklan.

Field	Tipe
`id`	UUID (PK)
`order_id`	UUID (FK)
`ads_account_id`	UUID (FK)
`duration`	integer (months)
`fee_setting_id`	UUID (FK)
`amount`	decimal:2
timestamps	—

`order_topups`

Detail order top up spend cap.

Field	Tipe
`id`	UUID (PK)
`order_id`	UUID (FK)
`ads_account_id`	UUID (FK)
`amount`	decimal:2
timestamps	—

`order_withdraws`

Detail order penarikan saldo.

Field	Tipe
`id`	UUID (PK)
`order_id`	UUID (FK)
`ads_account_id`	UUID (FK)
`amount`	decimal:2
`completed_at`	datetime
timestamps	—

`order_transfer_balances`

Master transfer saldo antar-akun (lihat juga Transfer Balance).

Field	Tipe	Catatan
`id`	UUID (PK)
`order_id`	UUID (FK)
`destination_ads_account_id`	UUID (FK)	Akun tujuan
`destination_balance`	decimal:2	Saldo sebelum transfer
`total_transferred`	decimal:2	Total yang ditransfer
`status`	string	`pending` / `processing` / `completed` / `failed`
`error_message`	text (nullable)	Bila `failed`
`processed_at`	datetime	Saat mulai diproses
`completed_at`	datetime	Saat selesai
timestamps	—

`order_transfer_balance_details`

Item detail per akun sumber (1 transfer bisa multi-source).

Field	Tipe
`id`	UUID (PK)
`order_transfer_balance_id`	UUID (FK)
`source_ads_account_id`	UUID (FK)
`amount`	decimal:2
`status`	string
timestamps	—

`order_deducts`

Order biaya admin/fee.

Field	Tipe
`id`	UUID (PK)
`order_id`	UUID (FK)
`amount`	decimal:2
`description`	text
timestamps	—

`order_business_managers` (pivot)

Pivot relasi order ↔ BM (untuk order yang melibatkan BM).

Field	Tipe
`id`	UUID (PK)
`order_id`	UUID (FK)
`business_manager_id`	UUID (FK)
timestamps	—

`payments`

Record pembayaran.

Field	Tipe
`id`	UUID (PK)
`order_id`	UUID (FK)
`payment_method_id`	UUID (FK)
`amount`	decimal:2
`gateway`	string (`monitpay` / `duitku` / `transfer`)
`gateway_reference`	string
`status`	string
`payload`	array (JSON) — gateway response
timestamps	—

`refunds`

Record refund saldo.

Field	Tipe
`id`	UUID (PK)
`ads_account_id`	UUID (FK)
`order_id`	UUID (FK)
`amount`	decimal:2
`status`	string
timestamps	—

`payment_methods`

Master metode pembayaran.

Field	Tipe
`id`	UUID (PK)
`name`	string
`gateway`	string
`is_active`	boolean
`config`	array (JSON)
timestamps	—

`bank_accounts`

Master rekening bank member & admin.

Field	Tipe
`id`	UUID (PK)
`member_id`	UUID (FK, nullable)
`bank_name`	string
`account_number`	string
`account_name`	string
`is_active`	boolean
timestamps	—

Order flag lifecycle

text

[pending] ──payment success──► [paid] ──admin approve──► [processed]
   │
   └──expiry:order (timeout)──► [cancelled]

[paid] ──MyApi error──► [failed]
[processed] ──(manual)──► [failed]

Langkah berikutnya

Detail alur payment? Baca Payment Flow.
Schema transfer balance detail? Lihat Transfer Balance.
Schema akun iklan? Lihat Ads Accounts.

orders

Relasi polymorphic

Accessor

order_subscribes

order_topups

order_withdraws

order_transfer_balances

order_transfer_balance_details

order_deducts

order_business_managers (pivot)

payments

refunds

payment_methods

bank_accounts